Introduction
I specialize in architecting sophisticated VBA solutions to streamline complex capital markets workflows. My expertise lies in automating end-to-end data pipelines—from harvesting real-time market insights via Bloomberg and Refinitiv to dynamic batch processing within Sophis systems. I focus on driving operational excellence by replacing manual interventions with resilient, automated frameworks that ensure data integrity and organizational efficiency.
COLLINE
Built a custom macro using Selenium Basic to automate data extraction and updates on the Colline platform. This solution handles complex web interactions and automated comparisons, replacing an hour of manual effort with a high-speed, error-free automated pipeline.
SCREAM
Managed complex data integration for the SCREAM system by processing multi-source inputs from Bloomberg, Sophis, and external files. I engineered dynamic templates to filter, deduplicate, and reformat inconsistent source data into specific upload formats for various ticker types, while centralizing quarterly reporting to ensure data integrity across the platform.
FIXING RECON
Engineered an end-to-end automation for Fixing Recon, replacing manual file imports and multi-team emails with a centralized VBA framework. The tool handles sophisticated fall-back fixing scenarios across various instrument types and dates, achieving advanced data processing capabilities that were previously impossible through manual methods.