ASHISH PANDEY
Indore
Summary
Microsoft Certified Azure Data Engineer with extensive experience crafting scalable data solutions in the Healthcare CRM domain. Proven success in leading data integration projects using Snowflake and Python across Azure and AWS environments. Currently leveraging this expertise as a Senior Consultant in AI and Data at Deloitte Consulting, specializing in robust data flow management and strategic data warehousing architectures.
Overview
11
11
years of professional experience
1
1
Certification
Work History
SENIOR CONSULTANT – AI & Data
Deloitte Consulting
Pune
11.2021 - Current
- Platform Migration Leadership: Spearheaded the migration from Veeva to Salesforce Lifesciences Cloud, managing 1,000+ integration mappings across five regions.
- ETL Framework Development: Developed a database-driven ETL framework using Python-based Snowpark in Snowflake to optimize performance and reduce costs.
- Archival Process Modernization: Led the migration of legacy archival processes from IICS-Oracle to a more efficient Snowflake-Python environment for three major organizations.
- Team Leadership & Awards: Led an eight-member team to achieve project goals on schedule, earning an outstanding performance award.
- Azure Data Management: Designed Azure Data Factory pipelines for multi-source ingestion into Snowflake and created a metadata management and audit framework in Azure SQL Database.
- Cloud Integration: Integrated AWS services within a Cloud Foundry environment, utilizing Netflix Conductor for orchestration.
LEAD ASSOCIATE – Data Integration
WNS GLOBAL
Gurgaon
03.2018 - 11.2021
- Data Pipeline Development: Developed processes for data transformation from Azure Data Lake to Azure SQL Database and automated data loads from Azure Blob storage.
- Databricks/Spark Expertise: Created Delta tables, performed data transformations using PySpark, and implemented analytical logic in Spark SQL.
- ETL Management: Scheduled and monitored ETL jobs within Databricks and utilized SQL for performance optimization and back-end testing.
- Security & QA: Managed secrets securely in Azure Key Vault and conducted thorough unit testing for quality assurance.
SOFTWARE ENGINEER – BI Analytics
TECHLINK INFOWARE
Mumbai
10.2015 - 02.2018
- ELT Implementation: Implemented efficient Teradata-based ELT strategies and performed micro design/table deployment.
- Integration & Automation: Integrated Teradata with Linux/Control-M, utilized AWS/Hadoop (Hive), and automated data loads via shell scripts.
- Data Quality & Documentation: Conducted data profiling and documented operation guides for system testing.
SOFTWARE ENGINEER – Financial Reporting
CARESOFT INC
Bhopal
08.2014 - 09.2015
- EPM Management: Developed and optimized HFM/Planning applications (Hyperion 11.x) and managed Workspace architecture/security.
- Customization & Reporting: Created customized dimensions, currency rules, spreadsheet-replicating web forms, and various Hyperion/Smart View reports.
Education
Bachelor of Engineering - Computer Science Engineering
Rajiv Gandhi Technical University
Bhopal, India05.2014
High School - Science
Vatsalya Public School (CBSE)
Mandsaur, Madhya Pradesh, India03.2010
Skills
- Data migration and ETL development
- SQL and data warehousing
- Cloud architecture and integration
- Data integration design
- Driving technology upgrades
- Team leadership
- Agile project methodologies
- Work planning and prioritization
Certification
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Azure Fundamentals
- AMCAT Certified Data Processing Specialist (1517672-211)
- Python 3 Tutorial course SoloLearn (1073-7304184)
Languages
English
Proficient (C2)
C2
Hindi
Native
Native
Accomplishments
Q3 2025 - Outstanding Performance Award.
Affiliations
Cluster Lead - Impact Day at Deloitte (2025)
Timeline
SENIOR CONSULTANT – AI & Data
Deloitte Consulting
11.2021 - Current
LEAD ASSOCIATE – Data Integration
WNS GLOBAL
03.2018 - 11.2021
SOFTWARE ENGINEER – BI Analytics
TECHLINK INFOWARE
10.2015 - 02.2018
SOFTWARE ENGINEER – Financial Reporting
CARESOFT INC
08.2014 - 09.2015
Bachelor of Engineering - Computer Science Engineering
Rajiv Gandhi Technical University
High School - Science
Vatsalya Public School (CBSE)