Ankit Pandey Email & Phone Number

Pune, MH, IN

Pune, Maharashtra, India

• Utilized Azure Data Factory (ADF) to orchestrate and automate data pipelines for extracting data from heteroge-neous sources, including on-premises SQL databases, CSV files, JSON files, and REST APIs.
• Seamlessly moved extracted data into Azure Data Lake Storage (ADLS), optimizing data movement using AzureData Factory (ADF) for efficient cloud migration.
• Implemented secure connections and authentication using Azure Active Directory (AAD) and Azure Key Vaultto ensure data privacy and access control.
• Collaborated with cross-functional teams to gather business requirements, ensuring the successful integrationand transformation of critical data for an insurance project.
• Employed PySpark, and Azure Databricks to perform data transformation, data cleaning, and ensure data qualityand consistency.
• Performed data aggregation and summarization based on business requirements, enabling the data analyticsteam to generate reports and build dashboards for actionable data insights.

Pune, Maharashtra, India

• Worked on UI data mapping and migration activities across multiple systems within the BFSI (Banking, FinancialServices, and Insurance) domain.
• Utilized SQL expertise to build optimized queries for loading data into target tables during migration activities.
• Implemented data validation processes for incoming CSV files in Azure Data Lake Storage.
• Implemented optimization techniques, including indexing and query tuning, resulting in a 40% reduction in queryresponse times.
• SQL, PySpark, Query Optimization, Oracle PL/SQL, Azure Data Factory, Indexing, Python, ETL Processes

Pantnagar

Involved in Production Part Approval Process Closure, that helps manufacturers and suppliers communicate and approve production designs and processes before, during and after manufacturing.

B.Tech, Mechanical Engineering, 88.6 %

Cbse, Science, 80%