Jayesh Shettigar Email & Phone Number

Mumbai, MH, IN

Mumbai, Maharashtra, India

• Worked as a Snowflake/Matillion Delivery Architect on a Cloud Transformation Program to build Electric Data Platform for largest global Energy Utilities company using Snowflake, Matillion on Azure Cloud
• Responsible for technical delivery of 15 Snowflake & Matillion developers working on multiple implementation tracks
• Client was aiming at large-scale multi-year greenfield implementation program to build enterprise data repository to store 30+ source applications (around 2000 tables) data and to provide single version of the truth.
• Responsible for end-to-end solution establishing right process for data ingestion, processing, storage & automation of jobs
• Designed incremental data load strategies covering change tracking and full compare delta detection & delete strategies covering API based data ingestion as well
• Responsible for designing performance efficient data loads and processing for time-series data load from sensors

Mumbai, Maharashtra, India

• Worked as a Snowflake/Matillion Delivery Architect on a Cloud Transformation Program to build Electric Data Platform for largest global Energy Utilities company using Snowflake, Matillion on Azure Cloud
• Responsible for technical delivery of 15 Snowflake & Matillion developers working on multiple implementation tracks
• Client was aiming at large-scale multi-year greenfield implementation program to build enterprise data repository to store 30+ source applications (around 2000 tables) data and to provide single version of the truth.
• Responsible for end-to-end solution establishing right process for data ingestion, processing, storage & automation of jobs
• Worked as a Senior Technical Project Manager/ETL Architect for Platform Migration for American office staffing company using Informatica IICS, SQL Server database
• Managed a team of 12+ IICS & SQL Server developers working on migration

Mumbai, Maharashtra, India & Overland Park, Kansas City, USA

• Worked as a Senior Project Manager to implement a BI Reporting solution for global engineering, procurement, consulting and construction company using ODI, OBIEE 11g, BI Publisher and Oracle database
• Managed a team of 12+ developers working on implementation and support tracks
• Interacted with client for understanding business requirements, feasibility study and effort estimates
• Worked closely with Sales and Engagement Manager onsite to expand the team
• Managing client expectations and demands proactively while maintaining good client relationships
• Responsible for Interacting with project sponsors, project stakeholders and multiple business and technical teams to define and deliver solution to meet business needs

Mumbai, Maharashtra, India & Concord, New Hampshire, USA

• Worked as a DW ETL Architect to implement a data warehousing solution for Fortune 200 Insurance & Investment Management company
• Interacted with client for understanding business requirements, feasibility study and effort estimates
• Performed DW assessment, AS-IS architecture, gap analysis, to come-up with TO-BE architecture and roadmap to implement the changes
• Prepared and successfully presented assessment report

Mumbai, Maharashtra, India

• Worked as a DW ETL Lead/Manager/Architect to implement a large data warehousing solution for Fortune 100 Health Insurer
• Managed a team of 35+ developers working on implementation and support tracks for EDW
• Interacted with client for understanding business requirements, feasibility study and effort estimates
• Responsible for design, development, production implementation and support of Enterprise Data Warehouse (EDW) using Oracle, Informatica Power Center, DM Express ETL tool
• Mentoring and training the team on Oracle, database performance tuning, DW/ETL concepts, Informatica Power Center, DMExpress
• Responsible for Stakeholder management across multiple business lines to coordinate requirement & deliver with Quality

Louisville, Kentucky, United States

• Worked as a Senior ETL Developer/Lead to implement a large data warehousing solution for Fortune 100 Health Insurer
• Interacted with client for understanding business requirements, feasibility study and effort estimates
• Responsible for design, development, production implementation and support of Enterprise Data Warehouse (EDW) using Oracle, Informatica PowerCenter, DM Express ETL tool
• Lead the team of 5 developers to completely resolve web reporting issues
• As part of ETL process improvement team, analyzed/instrumented/performance tuned packages
• Lead team to create technical design for business requirements including process flows

Mumbai, Maharashtra, India

As Senior Database Engineer, the job profile involved analysis, design, coding, integration, testing & maintenance of software modules using Oracle, SQL Server database technologies.

Diploma - Advanced Computing, Oracle, C, C++

Bachelor'S Degree, Electrical, Electronics And Communications Engineering