At Allio Capital, I design SQL Server dimensional models and maintain SSIS pipelines that bring investment operations, member account, and external market data into consistent reporting datasets.
I diagnosed recurring stored-procedure timeouts using execution plans and Dynamic Management Views, then redesigned indexing to cut average query runtime by about 42%. I also introduced reconciliation checks that reduced transaction discrepancy incidents by about 60%.
I translate portfolio operations stakeholders’ reporting requests into Power BI datasets and DAX measures used for the standard monthly performance dashboard. I also moved SQL and SSIS assets into Git-based source control and introduced automated deployment across environments.
Previously, at Goldman Sachs, I built ETL processes and dimensional models for trade, risk, and compliance reporting. At Claro Insurance, I developed C# backend services and maintained data pipelines for policy and claims reporting.
