Digital Transformation for High-Yield Fund Infrastructure. 

Executive Summary

A global asset management client faced severe operational bottlenecks due to manual data consolidation workflows. Financial analysts spent hours copy-pasting portfolio metrics from disparate databases into Excel files for quarterly reporting, introducing high risks of human error and data desynchronization.

We engineered an automated, end-to-end data extraction ecosystem. By developing a high-performance custom Web API deployed on Microsoft Azure and building a native, centralized Excel Add-in, we transformed a multi-day manual extraction chore into a secure, single-click automated pipeline—drastically improving data accuracy and reporting velocity.

The Technical Challenge

• The Spreadsheet Dependency: The client’s analysts required Excel for complex modelling and downstream calculations. Forcing them into an unfamiliar stand-alone SaaS UI would ruin user adoption.

• Data Fragmentation & Query Latency: Financial data was trapped behind siloed relational databases and legacy accounting software. Querying these systems concurrently for large-scale reports caused heavy database lockups and timeout failures.

• Data Integrity & Version Control: Manual extraction meant that multiple versions of truth existed simultaneously across local workstations, presenting a significant compliance risk for audited financial reports.

Our Engineering Approach & Architecture

1. Native Excel Integration (Office JavaScript API)

Instead of developing an unstable, legacy COM/VBA add-in, we architected a modern, cross-platform Office Web Add-in using HTML5, TypeScript, and React, interacting directly via the Office JS API framework.

• Frictionless UX: The add-in embeds natively as a secure custom task pane within Excel, allowing analysts to authenticate and select data schemas without leaving their active workbook.

• Asynchronous Processing: Data population routines run asynchronously, preventing Excel from freezing or crashing while fetching millions of data rows.

2. High-Throughput RESTful Backbone (ASP.NET Core on Azure PaaS)

We built an enterprise-grade Web API using ASP.NET Core, optimized for massive data extraction payloads, and deployed it on Azure App Services.

• API Management & Guardrails: Deployed behind Azure API Management (APIM) to enforce rate-limiting, request throttling, and payload compression (Brotli/Gzip), ensuring Excel frontends receive optimized data packages.

• Caching Layer: Integrated Azure Cache for Redis to temporarily store frequently queried historical financial records, dropping API response latency from seconds to milliseconds.

3. Identity and Row-Level Security

To prevent unauthorized data access via Excel, the entire pipeline is bound to the client’s corporate security framework.

• The Add-in utilizes MSAL (Microsoft Authentication Library) to handle Single Sign-On (SSO) through Microsoft Entra ID (Azure AD).

• The Web API decodes incoming JWT bearer tokens to strictly enforce Row-Level Security (RLS) at the database layer, ensuring analysts can only extract data blocks they have explicit clearance to view.

The Results

• Reporting Speed: Reduced data gathering and report generation timelines by 92%, turning a 4-hour manual compilation task into an automated, 20-second retrieval process.

• 100% Data Accuracy: Eliminated manual data entry entirely. Because the Excel Add-in pulls live data directly from the verified Azure database, data drift and human typographical errors were reduced to absolute zero.

• Enterprise Audit Trail: Centralizing the data extraction logic through our Web API created a unified telemetry log within Azure Monitor / Application Insights. Compliance officers can now audit exactly who extracted what data into an Excel spreadsheet and when.