• Designed and deployed scalable data pipelines using DBT and Snowflake, increasing data processing efficiency by 30% and ensuring reliable ETL workflows.
• Developed and optimized 30+ complex stored procedures in SQL Server to automate data validation, reconciliation, and anomaly detection across 20+ production datasets, reducing manual intervention by 60%.
• Engineered 10+ monitoring solutions using DataDog and T-SQL, proactively identifying data quality issues such as re-retirement violations and metadata gaps across 13+ legacy registries.
• Managed 25+ deployment workflows through Azure DevOps, automating pipeline execution and enabling faster and safer releases across development, staging, and production environments.
• Investigated and resolved 100+ cross-registry accounting discrepancies by analyzing production data using window functions, linked servers, and cross-database joins, ensuring alignment between ledger and transactional systems across 12+ tenants.