Securities & Derivatives Analyst Citigroup
I architected and maintained an automated KPI reporting solution using Excel, Power Query, Power Pivot, and DAX. The solution reduced manual report preparation from approximately three hours to five minutes, a 97% reduction, and enabled scalable reporting without dedicated development resources.
I own end-to-end operational performance reporting for six LATAM markets, consolidating, cleaning, and transforming multi-source data into weekly, monthly, and year-to-date reports. I design data models, DAX measures, dashboards, and presentations; perform trend, anomaly, and exception analysis; reconcile reporting inputs; and implement validation checks. I also document business requirements and partner with Operations, Business, and Technology teams on reporting enhancements in a control-focused securities and derivatives environment.