Ankur Yadav Email & Phone Number

Bengaluru, Karnataka, India

• Led the migration of financial data from Intuit’s on-premise servers to a Data Lake, using Spark SQLto design and implement efficient ETL pipelines, optimizing data processing and ensuring seamlesstransition.
• Optimized SQL queries and triggers for RDBMS, improving data manipulation and retrieval acrossplatforms.
• Analyzed and backtracked Informatica mappings and business rules, ensuring accurate and reliabledata transformations.
• Designed complex SQL queries with joins, subqueries, and window functions to support businessintelligence and reporting.
• Reduced query execution time by 30%-40%, boosting reporting speed and system performance.
• Developed and implemented data validation frameworks and quality checks to ensure 100% dataaccuracy throughout migration.

Bengaluru, Karnataka, India

• Engineered comprehensive logical and physical data flow models for ETL applications, streamliningdata integration processes and ensuring seamless data transformation and loading with optimizedworkflows.
• Diagnosed and resolved invalid data mappings within the ETL pipeline, troubleshooting complexdatabase issues and improving data accuracy, integrity, and system reliability.
• Leveraged relational SQL to optimize query performance, reducing unnecessary data transfer andminimizing network latency, leading to a significant improvement in processing efficiency and fasterdata operations

New Delhi, Delhi

• Analyzed ML-generated data to detect fraudulent activities and anomalies, identifying criticalpatterns for improved fraud detection algorithms.
• Prepared detailed reports on data insights and findings, enabling data-driven strategicdecision-making.
• Conducted in-depth analysis to uncover trends, enhancing the effectiveness of fraud detectionmodels.