Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Certification
Timeline
Generic

Shiva Panchal

Techno-Functional Manager | Data & Cloud Architect | EY GDS
Gurgaon,Haryana

Summary

Results-driven Techno-Functional Manager with 11+ years of experience delivering complex data and analytics solutions for global clients, primarily in Banking and Capital Markets. Proven expertise in cloud modernization, Snowflake architecture, ETL design, and Data Warehousing across Azure, AWS, and Informatica ecosystems. Skilled in managing end-to-end project delivery while contributing as an individual contributor for architecture design, data modeling, and performance optimization. Adept in stakeholder management, agile delivery, and cross-functional leadership.

Overview

11
11
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

EY GDS – Manager (Banking & Capital Markets)

EY GDS
Gurugram
09.2021 - Current
  • Led cloud modernization programs, migrating legacy platforms to Snowflake and Azure for global banking clients.
  • Designed scalable, secure ETL pipelines using ADF, Snowpipe, Kafka, Glue, and Python for batch and real-time ingestion.
  • Architected Data Vault models and enterprise DWH layers (Raw, Stage, Conformed, EDW).
  • Set up CI/CD pipelines using Git, dbt, Airflow to automate Snowflake deployments.
  • Delivered Power BI dashboards on semantic layers, enabling business insights.
  • Managed offshore delivery teams, project timelines, and client reporting.
  • Ensured strong data governance, access control, and quality assurance via IDQ.

Capgemini – Senior Consultant (Microsoft Projects)

Capgemini
11.2018 - 09.2021
  • Built ETL workflows and semantic layer-based reports for Microsoft clients using ADF, Snowflake, and Power BI.
  • Migrated on-prem data warehouses to Azure cloud with performance and cost optimization.
  • Created automated jobs in Control-M; managed full ETL lifecycle from ingestion to dashboarding.
  • Developed “Star Billing” platform enabling interchange fee tracking for card networks like VISA.
  • Led unit testing, QA support, and production deployments.

Accenture – Sr Software Engineer (Fidelity)

Accenture
09.2017 - 04.2018
  • Delivered ODS and DW solutions using Salesforce data as source; implemented using Informatica, Oracle, UNIX.
  • Managed test cycles, defect resolution, and deployment automation using SVN, Bamboo, and Urban Deploy.

Cognizant – Programmer Analyst (US Bank)

Cognizant
07.2014 - 08.2017


  • Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Data Quality rule implementation, change, and report testing.
  • Performing data quality test at source side using Informatica IDQ.
  • Involved in development activities for the work packets SOR Golden Copy and the work packet mapping (Golden Copy from SOR to RAW and RAW to Harmonized).
  • Developed ETL workflows and mappings and ensure code is delivered on schedule.

Education

Bachelor of Technology - Electronics & Communications

Meerut Inst of Eng & Tech
Meerut
01.2009 - 05.2013

Skills

  • Cloud Platforms: Snowflake, AWS, Azure

  • ETL & Data Pipelines: Informatica PowerCenter/IDQ, Azure Data Factory, AWS Glue

  • Orchestration & Automation: Apache Airflow, Control-M, dbt

  • Data Modeling: Star/Snowflake Schemas, Data Vault

  • Analytics & Visualization: Power BI, Python (Pandas, NumPy)

  • DevOps & CI/CD: Git, Bamboo, UrbanCode, SVN

  • Databases: SQL Server, Oracle, Hive

  • Tools: Unix/Linux, Jira, ServiceNow

Websites

Personal Information

Certification

Snowpro Core Certified

Timeline

EY GDS – Manager (Banking & Capital Markets)

EY GDS
09.2021 - Current

Capgemini – Senior Consultant (Microsoft Projects)

Capgemini
11.2018 - 09.2021

Accenture – Sr Software Engineer (Fidelity)

Accenture
09.2017 - 04.2018

Cognizant – Programmer Analyst (US Bank)

Cognizant
07.2014 - 08.2017

Bachelor of Technology - Electronics & Communications

Meerut Inst of Eng & Tech
01.2009 - 05.2013

Similar Profiles

CREATE PROFILE
Shiva PanchalTechno-Functional Manager | Data & Cloud Architect | EY GDS