Harmeet Kaur

Spearheaded migration from legacy Excel to SQL Server, automating complex finance workflows and increasing reporting velocity by 45% via stored procedures. Orchestrated ETL pipeline engineering for CSV, PDF, and Excel ingestion into centralized warehouses, decreasing data discrepancy rates by 25% across systems. Standardized IBS and macro-driven datasets through rigorous data cleansing and normalization, elevating data reliability by 30% for downstream analytics.

Senior Data Analyst at State Street (2023-05 – 2025-08)

• Spearheaded migration from legacy Excel to SQL Server, automating complex finance workflows and increasing reporting velocity by 45% via stored procedures.
• Orchestrated ETL pipeline engineering for CSV, PDF, and Excel ingestion into centralized warehouses, decreasing data discrepancy rates by 25% across systems.
• Standardized IBS and macro-driven datasets through rigorous data cleansing and normalization, elevating data reliability by 30% for downstream analytics.
• Architected interactive Power BI dashboards utilizing advanced slicers and DAX measures, empowering executives to monitor 10+ KPIs with 20% higher efficiency.
• Optimized report performance via DirectQuery and incremental refresh strategies, slashing dashboard latency by 35% to deliver near real-time data insights.
• Directed data governance initiatives by implementing automated validation rules and audit logs, reducing production errors by 28% through technical rigor.
• Liaised with cross-functional stakeholders to resolve 15+ complex reporting tickets monthly, achieving 25% faster resolution through precise requirements gathering.
• Championed scalable data integration strategies across enterprise systems, mitigating manual reconciliation efforts by 30% via streamlined SQL scripts.

Data Engineer at TradeSun (2019-10 – 2023-01)

• Engineered high-throughput data pipelines to support large-scale analytics, accelerating ingestion speed by 40% across distributed cloud-based architectures.
• Overhauled AWS workflows using SageMaker, S3, and Lambda, reducing batch processing duration from eight hours to three hours through parallel execution.
• Redesigned system evaluation metrics to enhance failure detection accuracy by 22%, utilizing statistical modeling to strengthen cloud infrastructure stability.
• Developed hierarchical BI reporting structures across three distinct levels, improving stakeholder accessibility and data transparency by 25% for global teams.
• Built ASTRA NLP application using Python and Regex for unstructured text extraction, boosting data processing efficiency by 30% through automated parsing.
• Integrated unit and regression testing frameworks into CI/CD pipelines, decreasing production defects by 27% and ensuring robust software deployment cycles.
• Managed collaborative version control using Bitbucket, improving code deployment frequency by 20% through systematic branching and merge conflict resolution.
• Authored comprehensive technical documentation and mapping specifications, reducing engineering onboarding time by 35% via detailed architectural diagrams.

Certificate in Data Science – University of Toronto (2020-01 – 2020-12)

B.Tech in Electronics & Telecommunication – NIT Raipur (2004-08 – 2008-05)