Project Portfolio Hub

Deployed core accounting data to Microsoft Fabric using pipelines to collect data from data vault and load to bronze staging area. Transformed data using Python notebooks to gold region with scheduled refreshes. Created semantic model for Power BI analytics and C# command line application for document exports.

Developed Graph API integration with Office 365 to retrieve reports delivered by email. Implemented C# solution with Exchange Web Services for complex Refinitiv file processing across multiple emails. Built mailbox monitoring and support integration with Cursor AI assistance for best practices.

Migrated trade reporting process from ODBC to MQ for real-time trade processing. Developed C# orchestration solution with API integration, real-time security master data requests, and refactored stored procedures. Coordinated development across multiple teams for enterprise-scale implementation.

Migrated security master data acquisition from scheduled Bloomberg reports to on-demand API interface. Developed C# solution with Bloomberg HAPI interface, dynamic response processing, and extensive error reporting. Eliminated SLA risks and improved data completeness.

Designed and implemented a comprehensive Data Vault warehouse for entire operational database for $150bn asset management firm.

Developed comprehensive marketing data reporting framework to ensure accurate delivery of marketing data to external website and cloud-based solution for fund fact sheets. Created 18 new SSIS packages and reports with data quality framework and table-driven delivery system.

Refactored all accounting data ETL to conform with middle office report changes. Coordinated development with overseas resource to upgrade reporting system, modify business rules, and improve processing time from 4:00AM-5:30AM to midnight-1:30AM. Completed documentation and integrated with error-reporting framework.

Developed comprehensive system to restore operational databases to development server for global contractors. Implemented extensive data masking and permission management with table-driven solution. Reduced restore time from 2+ hours to 20 minutes for 500GB data using SSIS and SQL Server.

Led development of comprehensive counterparty risk reporting warehouse managing team of 5 developers. Full-stack solution using SQL Server, SSIS, and MicroStrategy with ETL pipelines, staging region, and formal data warehouse using snowflake schema. Expanded to include country risk reporting.

Led development and design of comprehensive operational risk reporting warehouse using Oracle, IBM DataStage, and Business Objects. Managed team of 3 developers to implement dimensional model with snowflake schema, complex data relationships, and 50+ reports across multiple risk disciplines.

Assumed responsibility for comprehensive RCSA (Risk Control Self Assessment) reporting solution with 20+ SSRS reports. Replaced team of 5 contractors, developed custom C# controls, and optimized 100+ issues to completion within months.

Developed a comprehensive controls catalog application to collect and manage operational risk controls. Built with Microsoft Access and Visual Basic, featuring multi-tab UI, centralized repository, and remote client deployment. Captured 50+ data points for risk assessment and reporting.

Managed a large-scale IT procurement project involving 100,000+ laptops and PCs. Led RFP process with Dell, Lenovo, and HP, coordinated executive decision-making, and managed successful deployment across the organization.

Developed and supported a comprehensive commodity pricing system that collected data from 20+ sources and completed mark-to-market portfolio pricing. Reduced processing time from hours to minutes with further optimization achieving 5-minute completion.

Led the development and design of the processing system used to approve business card applications. The system used a Btrieve database to interface with the various credit bureaus. System interfaced with OCR document scanning process to import applications.