Summary
Overview
Work History
Education
Skills
Personal Information
Linguistic Abilities
Notable Accomplishments
Timeline
Generic

Dimple Matta

Gurgaon

Summary

A Qualified Professional with 12 years of experience in ETL, Business Intelligence, and data warehouse with a rich exposure in providing Business Solutions. Deep exposure on the IBM DataStage (Designer, Director, and administrator) for creating ETL Jobs and workflows using IDMC ETL pipelines using the AWS cloud platform. Worked for various client engagements in the Financial, Telecom, and Demand Management sectors and have gained exposure to many phases of project development. Core Competencies: Quality Testing, Project coordination, Problem-Solving Ability, Adaptability, Stakeholder Management, and Team management. Technical Skills: AWS, SQL, Snowflake SQL, Unix Shell scripting, DataStage, Databricks,IDMC. Certification: AWS Cloud Practitioner, IDMC CDI Implementation Practitioner, IDMC CDI Associate.

Overview

13
13
years of professional experience

Work History

Senior Consultant

Deloitte Consulting India
01.2022 - Current
  • Majorly worked with four different major accounts Walmart, Baxter, TIAA, NYL. Currently serving NYL (New York Life Insurance). Refer to below modules for the summary of work done so far.
  • Underwriting NYL: This is majorly related to insurance domain. This is crucial department responsible for evaluating and analyzing risks involved before insuring insurance coverage. Working as a ETL lead in here and majorly supported recent DataStage to IDMC migration. Daily key responsibilities involve planning sprint stories for team, participating in ongoing development activities and looking for reported client open issues. Coordinating with onshore lead and clients.
  • EDHR (Electronic Devic History Record) responsibilities: Worked as technical lead in eDHR. Involved in oversight of project progress, initial analysis, Design documents updates, project plan modifications, weekly onshore offshore deck presentations updates. Orchestrated daily interactions with onshore leads, tackling queries and project updates. Involved in business client meetings to discuss on open questions in absence of onshore leads.
  • DataStage Extracts: Worked as a lead in TIAA for the DataStage extracts team. Majorly worked on Hadoop to snowflake migration part. Involved in initial analysis, Design documentation, Object tracker updates, Object assignment teamwise and helped team in resolving issues and ensured timely delivery of modules on time. Apart from this had daily touch base with clients on open issues and risk and migration of 300+ objects successfully done.
  • Maximo Integration responsibilities: Worked on technical specification & testing documentation for few objects followed by Check-in of respective code smooth code migration and converted technical documents and enabled business to provide requirement further. Facilitated daily connects with Onshore leads to address concerns / open questions and projects status to ensure timely project delivery. Gained two project functional knowledge and in grooming 45 junior resources both technically and functionally to make them self-sustainable.
  • Endeavor: Currently working in endeavour project leading two modules with four team members. Worked on technical specification documentation for few objects and has done code review, UT and TS documents review for fortyfive objects to ensure accuracy and consistency.

Assistant Manager

Genpact India Pvt Ltd
Gurgaon
12.2017 - 12.2021
  • Company Overview: It is DW BI project from financial domain.
  • In this project we are doing financial reporting of PAN Genpact Region wise. Data gathered from heterogeneous source like oracle, files provided by business users on monthly basis and various db2 sources. After this applying business logics on top of this data shared the Cognos financial reports with business users. These reports help the business users to check their financial numbers at region level as well as their granular level.
  • Worked as a developer in this project and participated in designing the dimensions and fact tables for profit and loss report.
  • Also worked on the queries raised by business on ad hoc basis.
  • Helped the team members whenever needed.
  • Also enrolled in team meetings with business to explain the system logic implemented so far.
  • It is DW BI project from financial domain.

Software Engineer

IBM India Pvt Ltd
05.2012 - 12.2017
  • Worked for client Airtel India and Airtel Africa.
  • Project brief: Airtel Africa It is a DW and BI project from Telecom domain which migrates and consolidates data from many heterogeneous sources systems and integrated to the target data warehouse for each involved country. The Data Warehouse of Airtel is a system of Business Intelligence that makes information available to users of different nature.
  • Airtel India It is a DW and BI project from the Telecom domain which migrates and consolidates data from many heterogeneous sources systems and integrated to the target data warehouse for circle in india.
  • Project: Signet Postpaid Automation The availability of facility to use 3G pack on 4G network, there is need to bifurcate data usage in order to correct revenue accounting and to take benefit of lower spectrum fee in 2300Mhz spectrum. This project is to make signet for automation of postpaid revenue accounting at customer level and summary level.
  • Roles & Responsibilities in Airtel Africa: Worked as a Etl Developer in airtel Africa and got exposure to work on DataStage, DB2 tools. Prepared SQL scripts to reconcile the data from source to target.
  • Responsibilities In Airtel India: Worked in RSU, Signet Postpaid projects end to end. Worked for various client engagements in Financial, Telecom, have gained exposure to many phases of project development.
  • Involved in extensive interaction with end customer for Project requirement gathering, understanding functional need, and translating functional designs into technical report designs, Design and Construction of standard parallel jobs and Sequencer with advanced features of running jobs automatically through creating Unix shell scripts, Quality Testing and Handling UAT service requests.
  • Periodic knowledge transfer to production support team and functioned as POC for concerned issues.
  • Responsible for providing important level of customer service whilst effectively operating the data processing and integrating various legacy systems with BI.
  • Responsible for dimensional modelling, fact loading, source data extraction and loading.
  • Also responsible for providing L3 support for raised service requests, change request, incidents.
  • Prepared Unix shell scripts for automation of projects. Scripts created for (cleaning the files, merging multiple files into one file, removing junk characters from file, looping for renaming the files etc.)

Education

Bachelor of Engineering - Information and Technology

Kurukshetra University
01.2012

Senior Secondary and Higher School -

HBSE

Skills

  • AWS
  • SQL
  • Snowflake SQL
  • Unix Shell scripting
  • DataStage
  • Databricks
  • IDMC

Personal Information

Date of Birth: 09/26/90

Linguistic Abilities

  • English
  • Hindi

Notable Accomplishments

  • Deloitte Consulting, Led and mentored team of five people and tracked project deliverables end to end., Applause Award, Successfully delivered the project and groomed junior resources.
  • Deloitte Consulting, Successfully delivered the project on time., Applause Award, Delivered translated piece on time and with high quality.
  • Deloitte Consulting, Efficiently managing PI initiatives., Applause Award, Delivered PI initiatives smoothly.
  • Genpact India, Worked as a senior DataStage developer., Bronze Award, Managed the Project ad hoc request and successfully delivered on time.

Timeline

Senior Consultant

Deloitte Consulting India
01.2022 - Current

Assistant Manager

Genpact India Pvt Ltd
12.2017 - 12.2021

Software Engineer

IBM India Pvt Ltd
05.2012 - 12.2017

Bachelor of Engineering - Information and Technology

Kurukshetra University

Senior Secondary and Higher School -

HBSE

Similar Profiles

CREATE PROFILE
Dimple Matta