Summary
Overview
Work History
Education
Skills
Employer Details
Certifications Awards
Timeline
Generic
Sachin Gupta

Sachin Gupta

Data Architecture And Anaytics Expert
Mumbai Suburban

Summary

Results-driven, goal-oriented project management and project delivery leader seeking to leverage past learning and experiences in a Senior Manager role. Experienced in leading teams, driving operational efficiency, and implementing strategic initiatives to enhance productivity and foster growth. Eager to launch a successful career with a progressive company that rewards initiative and superior performance with long-term opportunities for professional growth.

Overview

17
17
years of professional experience
2007
2007
years of post-secondary education
2
2
Languages

Work History

ADW/BIU - Senior Manager II

ICICI Prudential Life Insurance
08.2022 - Current
  • Created DataMart for the Underwriting team to ensure that data relevant to a specific business area is readily available for analysis and reporting.
  • Create a new system, Group Asia, to handle the group policy and other products. Currently, Group Asia data is merged with Life Asia. Life Asia holds the retail data only. Since the size of databases is growing exponentially and causing a lot of handling issues so need to create the new data. Segregation of data must do at the retail and group policy so functioning of system has been carried out smoothly. This will help populate regulatory reports BAPS which consume data from both the system GA and LA.
  • In addition to this also handle BIU project where accountable for creating Data Marts to various users like Claims, Underwriting team which assist them to get the data more quickly and efficiently. Responsible for month-end and data analysis related to Persistency model. Successfully completed Client merger activity and the data pipeline to reduce the loading time and improve the efficacy of the DB system.
  • Delivery Manager- manage a team of 25 people, responsible for project delivery, and people management.
  • Handle projects of more than 40 million Rupees
  • ETL lead of Information System - ADW, IAXIS, BIU, BAP
  • Established strong relationships with clients and stakeholders, ensuring long-term partnerships and repeat business.
  • Implemented and developed operational standards, policies and procedures.
  • Provided strong leadership to enhance team productivity and morale.

CRM Project- Solution Specialist

Teradata India Pvt Ltd
01.2019 - 07.2022
  • Delivered CIM and MAU training and run the base set-up wizard and Upgrade CIM to Team, to prepared them self-accusation on topics namely CIM Overview and Installation, Security Administration and 1-on-1 Logon, Custom Attributes. Designed and developed a campaign. The objective of the project is to migrate Unica campaigns/flowcharts to the Teradata CRM application, CIM. Worked on converting Unica derived field logics to implement the logic in CIM.
  • Data governance activities were strictly followed so that it helps in maintaining database hygiene.
  • Following were the specific activities that performed as a CIM administrator and as an Implementation consultant: Object mapping (tables/views from DB to CIM application) using CIM MAU (Metadata Administration Utility)
  • Attribute creation, defining range, range templates for attributes.
  • Created schemas - new and cross and their links. Also created output template.
  • Created Extended Data Source so that views can be replaced, and results will be produced effectively.
  • Created the selector tab for different schemas and assigned the attribute category.
  • Converted view from Oracle to TD and then added it to the Metadata table.
  • Creating Monthly/Weekly/Daily analysis reports for campaigns and communication lifestyle.
  • Did performance tuning of queries took longer and reduced the execution time by 50%.
  • Analysis and resolution of all types of failures in Campaigns, campaigns using SQL, Shell script.
  • Creation of daily, weekly, monthly reports and managing team's roaster and work schedule.
  • Handling all the incidents through ServiceNow, Remedy and Jira.
  • Developed and Execute Data jobs, created scripts to fetch data.
  • Worked as a solution architect to design the data flow in an optimistic manner.
  • Manipulating and processing data using Excel and SQL. Responsible for loading, extracting and validation of client data.
  • Did the clean-up of MAU and the database to get rid of redundant objects like attributes, range template and so on.
  • Created base segments and suppression based on the requirements and add split ranges to get the desired output.
  • Mentoring Fresher batch of 20 people.

EDW - Solution Architect /Team Lead Consultant

Teradata India Pvt Ltd
11.2013 - 12.2018
  • In Client Analytics and Risk Modeling Phase1 source data from 25 scoped Source Systems were loaded into Acquisition layer (Tier1) which is staging platform of the EDM. One on One view will be created in Tier3. Phase 2 of the project will cover the data flow from Acquisition layer (Tier1) to Integrated Data Layer (Tier 2) and Access/Semantic Layer (Tier 3) for only RISK Modeling. Phase 3 includes more countries into the system and makes the data available for the user. The EDM Platform loads and processes millions of rows of diverse types of data from many different data sources daily. Sometimes loading data cannot compete successfully due to data exceptions and batch load issues, as a result count mismatch happens between EDM and Source System. This reconciliation is done daily, and a detailed report is generated and sent across teams. The objective of the proposed Trend Analysis and Exception Report is to have complete coverage of gaps within EDMP thereby improving OLA, SLA adherences and awareness in recon breaks and communicating to data consumers.
  • Westpac Group Data Warehouse (GDW) Re-platform project is driven under Refresh and Reliability program. The scope of this project is too re-platform the existing GDW on Oracle platform onto a brand-new Teradata platform. This would subsequently lead to decommissioning of current GDW on Oracle and repointing of all interfaces, both upstream and downstream, to new Teradata platform.
  • Deployed successfully DevOps model that really helps to achieve the result faster.
  • Lead Team for Tier-3 Teradata production support involves team managers, client interactions, coordination onshore-offshore, managing system outages and helping downstream to analyze issues.
  • Set-up data check for reporting and ensure data is populated correctly and there is no delay for the business user.
  • Being a Single Point of contact for Service Risk, responsible for fixing production issues and ensure that SLAs would meet. Along with, handle multiple teams to fix the production issue (S@R, medium or highest priority incident) and return the batch back to BAU mode without or minimal impact of data delay to downstream or end user.
  • L3 support to analyze the long running batch, identified the issues, optimized several job streams, tuned high skewed SQLs, and brought down batch up time by 2.5 hours. This gave more time to resolve the batch issues which helped the team to continuously meet the SLA.
  • Involved in design & development of mapping based on ETL specification besides performing ETL activity through ETL Tool and Teradata.
  • Conduct test mapping in compliance with ETL specifications for data loading, design ETL for implementation of SCD for dimensions of data marts.
  • Responsible for reviews design/architectural based on client's feedback and suggestions. Knowledge Transfer to Teradata offshore team for enhancements.
  • Design data loading solutions to optimize the ELT approach in an effective manner and overall reduce the load on the database.
  • Streamlining the process helps to improve the operational and monitoring activity and reduce the monitoring effort from 12 hours to 7 hrs.
  • Set up the Business Process Management to implement new ideas/process by overcoming old processes which were time consuming processes and impact the load on the system like changing load methodology from full dump to incremental.
  • Management consulting builds a repo at client location where suggested approaches and providing training on GCFR so that entire team handle works effectively with limited error without impacting BAU.
  • Set up DR database and load the data effectively on both servers. Also carried out DR drill every quarter to check availability of the system in times of need.
  • Worked on a snowflake database as a migration activity. Where data was migrated from Teradata to Snowflake.
  • Evaluate various staging tools like DataStage, Informatica, Talend for data processing as a part of POC to load data from source to target to create data warehouse for the bank.

Software Engineer

Target India Pvt. Ltd.
02.2008 - 11.2010
  • DB2 upgrade from version 8.2 to 9.1 required as support ends April 2009. P4 Unix servers reach end of life in late 2009 and need to be upgraded to P5. The cost of new hardware is $1.5M.ETL consolidation onto Data Stage engines requires job migration, script enhancements and associated testing. The project requirement is to migrate the critical HR information (Headcount & Payroll) from HR data source (EPM and business client) to EMI Data Mart. The objective is to analyze and control the payroll expenses. Reporting frameworks assist in analyzing and in combination of HR data with financial data. Information related to Employee, Headcount, Hour & dollar related to HQ, DC will be stored in Expense Management Initiative Data mart. It includes data for HQ Position Headcount Report, Adhoc analysis, Business College Head Count report, Bonus details analysis, Labor Distribution. Loading the dimensions of the EMI Adhoc data Unit & Transaction from Info Retrieval (IR) and Common Sales Processing Accumulate Management (CSPAM) into EMI Data Mart, validate referential integrity for relevant attributes, call appropriate external routines for error handling and parameter management and perform the necessary transformation logics and generate surrogate keys for new records.
  • Data profiling sets up as a critical task before bringing data from various sources to the database.
  • Involved in design & development of mapping based on ETL specification besides performing ETL activity through ETL Tool and DB2.
  • Conduct test mapping in compliance with ETL specifications for loading of data, design ETL for implementation of SCD for dimensions of data marts.
  • Participated in design/architectural reviews with clients and provided feedback and suggestions. Transfer the learning back to the onshore team and bring them up to speed on upcoming enhancements in production.
  • Successfully completed User Acceptance Testing and took Sign-off.
  • Accountable for code migration to production of technical development of ETL and Report.
  • Furnished on-call support for post implementation.
  • Accomplished knowledge transition with the whole team to support the delivered work.
  • Prepared test case document and asked team to follow the same for rigorous testing of the code before moving to production.
  • Data Migration activity for DB2 upgrade version.

Education

Bachelor of Technology (Hons.) - Electronics and Communications Engineering

University

Skills

Strategic planningTalent developmentOperations planning & managementResource allocationCross-functional collaboration & communicationData analyticsData-driven decision makingBusiness performance managementProblem-solving abilitiesTime managementProject planningAnalytical skillsBusiness developmentBusiness analysis and reporting

Employer Details

  • ICICI Prudential Life Insurance, Mumbai, Maharashtra, 2022-07-01, Present
  • Teradata India Pvt Ltd, Mumbai, Maharashtra, 2010-11-01, 2022-07-01
  • Target India Pvt. Ltd., Bangalore, Karnataka, 2008-02-01, 2010-11-01
  • The Metric Soft, Noida, Uttar Pradesh, 2006-11-01, 2008-02-01

Certifications Awards

  • Teradata 16 Associate Exam
  • Teradata 12 Certified Professional
  • Teradata 12 Advanced SQL Certified
  • Teradata 12 Certified Technical Specialist Certificate
  • Certificate Of Completion AWS Certified Solutions Architect Associate SAAC03 Cert Prep 4 Compute Services
  • Certificate Of Completion Agile Project Management Continuous Improvement

Timeline

ADW/BIU - Senior Manager II

ICICI Prudential Life Insurance
08.2022 - Current

CRM Project- Solution Specialist

Teradata India Pvt Ltd
01.2019 - 07.2022

EDW - Solution Architect /Team Lead Consultant

Teradata India Pvt Ltd
11.2013 - 12.2018

Software Engineer

Target India Pvt. Ltd.
02.2008 - 11.2010

Bachelor of Technology (Hons.) - Electronics and Communications Engineering

University

Similar Profiles

CREATE PROFILE
Sachin GuptaData Architecture And Anaytics Expert