Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Zahid Shaikh

Mumbai

Summary

Experienced Data Engineer with a strong background in building and optimizing ETL workflows, specializing in the insurance domain. Adept at leading teams, automating regulatory reporting, and delivering business analytics solutions. Seeking to leverage technical and leadership expertise for impactful data-driven roles.

Overview

6
6
years of professional experience

Work History

Senior Consultant

Ernst & Young
Mumbai
12.2021 - Current
  • Led a team of 10 in an ODS Support project, responsible for ensuring the reliable operation and integration of the ODS, which served as the primary data source for multiple critical downstream applications, including CRM systems, call center integrations for customer experience, and SAP integration.
  • Monitored and optimized numerous ETL pipelines feeding into the ODS, proactively identifying and resolving issues to prevent data inconsistencies or service disruptions that could directly impact business operations.
  • Coordinated with application and business teams to promptly handle data requests, issue resolutions, and Change Requests (CR), ensuring high availability and accuracy of business-critical reports and integrations.
  • Architected and automated financial regulatory reports for TATA AIA Insurance to enhance IRDA compliance.
  • Collaborated with Valuation team to design DataStage ETL solutions for accurate reserve calculations.
  • Developed agent commission calculation systems with the Operations team, improving accuracy and payout efficiency.
  • Built data models and analytical datasets for BI team to support Power BI dashboards visualizing KPIs.

Assosciate

IFTAS
Mumbai
08.2019 - 08.2021
  • Designed and implemented RESTful APIs for mobile banking applications using Spring Boot.
  • Led a proof of concept (POC) for a rule-based engine: architected an application capable of ingesting data and applying dynamic, Excel-like formulae as business rules.
  • Enabled users to define multiple rules, order them in a custom sequence, and construct complex data workflows meeting specific business logic requirements.

Education

Bachelor of Engineering - Electronic Engineering

University of Mumbai
06-2019

Skills

  • ETL Tools: IBM DataStage, Azure Data Factory (ADF), Databricks, SSIS
  • Databases: Oracle SQL, Microsoft SQL Server
  • Programming: PySpark, Spring Boot (Java)
  • Business Intelligence: Power BI
  • Other: Data warehousing, SCD2 modeling, data automation, reporting optimization

Accomplishments

  • Recognized as Business Extraordinaire in EY for managing core delivery tasks at TATA AIA independently
  • Automated financial regulatory reporting for an insurance client, reducing reporting cycle time, and increasing reliability
  • Architected SCD2 ETL models to support incremental financial reporting and compliance.

Timeline

Senior Consultant

Ernst & Young
12.2021 - Current

Assosciate

IFTAS
08.2019 - 08.2021

Bachelor of Engineering - Electronic Engineering

University of Mumbai

Similar Profiles

CREATE PROFILE
Zahid Shaikh