Summary
Overview
Work History
Education
Skills
Websites
Certification
Professional Development
Timeline
Generic

Saurabh Ganguly

Plano,Texas

Summary

Dynamic ETL Lead with Marvel Tech Group, specializing in Snowflake data engineering and AWS solutions. Proven track record of optimizing data pipelines, achieving a 40% reduction in processing time. Strong leadership and collaboration skills, driving project success and enhancing client satisfaction through innovative data integration strategies and CI/CD automation practices.

Overview

13
13
years of professional experience
1
1
Certification

Work History

ETL Architect | Team Lead – Client: USAA

Marvel Tech Group
Plano, United States
04.2023 - Current
  • Engineered end-to-end Snowflake data pipelines and AWS Lambda-based automation, reducing manual data processing time by 40% and accelerating time-to-insight for CFO Actuary reporting.
  • Developed reusable IBM DataStage jobs for regulatory reporting, ensuring 100% data integrity and reducing remediation costs by $120K annually through automated data validation and compliance.
  • Led onshore/offshore teams to streamline requirement gathering and technical delivery, improving project delivery timelines by 25% and increasing client satisfaction scores from 3.8 to 4.6 out of 5.
  • Optimized SQL and shell scripts for Snowflake and AWS environments, achieving a 23% performance improvement within 9 months and reducing cloud compute costs by $35K per year.
  • Implemented CI/CD pipelines for ETL jobs, cutting deployment cycle times from 3 days to 4 hours and enabling faster response to business changes.
  • Engineered API-driven ETL processes, increasing data accessibility for analytics teams and supporting executive decisions that improved customer retention rates by 8%.
  • Conducted rigorous unit and integration testing, reducing post-production defects by 60% and minimizing risk of regulatory penalties.

Data Analytics & Reporting Developer

Capgemini NA
United States, United States
04.2021 - 04.2023
  • Designed and optimized Snowflake data warehouses for manufacturing and inventory management, enabling real-time inventory tracking and reducing stockouts by 18%, directly impacting revenue.
  • Built and automated data pipelines using AWS Lambda, Redshift, and Athena, reducing data integration time from 2 weeks to 2 days and accelerating business decision-making.
  • Implemented multi-cloud ETL solutions, resulting in a 63% increase in report accuracy and supporting executive leadership in making data-driven pricing and procurement decisions.
  • Created interactive Power BI dashboards, empowering 120+ business users and executives with actionable insights, leading to a 12% improvement in operational efficiency.
  • Led Infrastructure as Code (IaC) initiatives, reducing environment provisioning time from 5 days to 2 hours and cutting cloud costs by $28K annually.
  • Collaborated with cross-functional teams to define data models and access controls, ensuring secure and compliant data operations and supporting regulatory audits.

Process Validation Data Specialist

Iziel Healthcare
United States, United States
02.2021 - 04.2021
  • Engineered data validation pipelines for healthcare analytics, reducing data reconciliation time by 50% and supporting executive decisions to improve patient outcomes and reduce operational risk.
  • Collaborated with technical teams to implement robust database solutions, ensuring data quality and consistency across 15+ data sources.
  • Conducted training sessions for team members, increasing team proficiency and reducing onboarding time for new analysts by 30%.

Manufacturing Process Data Specialist

TekWissen
United States, United States
06.2020 - 01.2021
  • Developed and executed data quality frameworks for manufacturing processes, reducing manual validation effort by 70% and supporting executive decisions to optimize supply chain operations.
  • Provided expert consultation on data integration and validation, resulting in a 25% reduction in data errors and improving inventory accuracy for key business stakeholders.
  • Supported business intelligence initiatives, enabling leadership to make informed decisions that reduced excess inventory and improved cash flow.

Graduate Student Assistant

Wayne State University
Detroit, United States
08.2018 - 06.2020
  • Assisted in data engineering research projects, developing advanced analytics models that supported faculty research and informed executive decisions on resource allocation.
  • Conducted workshops on SQL and data visualization, increasing student proficiency and supporting data-driven learning outcomes.

Supply Chain Data Analyst Expert

Indian Jute Mills Association
Kolkata, India
10.2014 - 08.2018
  • Optimized supply chain operations through data-driven insights, reducing operational costs by 15% and improving on-time delivery rates by 20%.
  • Utilized SCD concepts for data warehousing, enabling executive leadership to track supply chain performance and make strategic sourcing decisions.

Business Analyst – Data Quality Steward

L&T
, India
06.2012 - 10.2014
  • Implemented database solutions in SAP HANA, reducing data retrieval time by 40% and supporting executive decisions to streamline business processes.
  • Led data quality initiatives, resulting in a 30% reduction in data-related rework and improving the accuracy of financial reporting.

Education

MS - Industrial Engineering

Wayne State University
Detroit, MI
06.2020

Skills

  • Snowflake data engineering and architecture
  • AWS cloud solutions
  • ETL and ELT processes
  • Data modeling and warehousing
  • Data integration strategies
  • CI/CD automation practices
  • Microservices architecture
  • API-driven data pipelines
  • SQL proficiency
  • Python programming
  • Java development
  • Shell scripting skills
  • Data security measures
  • Governance and compliance
  • Performance optimization techniques
  • Scalability solutions
  • Cloud platform expertise
  • ETL and ELT tools proficiency
  • Programming languages knowledge
  • Data visualization techniques
  • DevOps methodologies
  • Automation frameworks
  • Database management systems

Certification

  • Snowflake Data Engineering Certification
  • SnowPro Core Certification
  • AWS Solutions Architect Associate
  • AWS Certified Cloud Practitioner
  • SAP Analytics Cloud Application Associate
  • SAP BW/4HANA Application Associate
  • ASQ Certified Quality Engineer
  • ASQ Certified Six Sigma Black Belt
  • SAP S/4HANA Embedded Analytics
  • SAP BTP Extension Suite (Learning Hub)
  • SAP BTP Integration Suite (Learning Hub)

Professional Development

Continuous learning in Apache Iceberg, advanced Snowflake features, and cloud-native data architecture.

Timeline

ETL Architect | Team Lead – Client: USAA

Marvel Tech Group
04.2023 - Current

Data Analytics & Reporting Developer

Capgemini NA
04.2021 - 04.2023

Process Validation Data Specialist

Iziel Healthcare
02.2021 - 04.2021

Manufacturing Process Data Specialist

TekWissen
06.2020 - 01.2021

Graduate Student Assistant

Wayne State University
08.2018 - 06.2020

Supply Chain Data Analyst Expert

Indian Jute Mills Association
10.2014 - 08.2018

Business Analyst – Data Quality Steward

L&T
06.2012 - 10.2014

MS - Industrial Engineering

Wayne State University

Similar Profiles

CREATE PROFILE