Senior ETL Developer & Data Analyst

Company Tata Consultancy Service Limited ,London
Project DMS Shadow Support
Customer Thames Water Utilities - United Kingdom
Period 24th Nov 2016 to 20th July 2017
Description
Data management system is centralized repository of Thames water and will act as market Repository
and Market Transaction Data store for MOSL. DMS working as Operational Data system (ODS).
Technically DMS has already been live on 3 rd Oct 2016 and functionally it will be on 1 st April
2017 for all UK customers. MOSL directly interact with DMS system for all kind of transaction after
1st April 2017. Shadow support, TCS will provide support like whether DMS data compatible as per
MOSL or not. Basically during Shadow support all water company will validate internal function
system. If New transaction/Changes identified then Enhancement/New development will be implemented
during Shadow support as per MOSL standard.

Role Technical Lead and ETL Developer
Solution Environment Oracle-11g, SQL Developer 2008, TOAD, PUTTY
Tools IBM Data Stage 11.3, Quality Stage
Highlights
* Working as a Technical Lead to understand the all business requirements from Onshore.
* To discuss development ETL workflows, mappings, SQL, Shell scripts to translate high level
documents to code assign the task accordingly to offshore assigned team.
* Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet
all the complex business rules implemented in ETL mappings.
* Maintained Coding standards and participated in Code Review.
* Responsible for creating High level and low level design specification documents for the ETL
mappings.
* Responsible for the Data Cleansing of Production Source
Data before data loading.
* If Team unable to developed complex logic then Designed and developed complex ETL's and PL/SQL
code.

Company Tata Consultancy Service Limited , London
Project DMS Development
Customer Thames Water Utilities - United Kingdom
Period 1st June 2016 to 23rd Nov 2016
Description
Data management system is centralized repository of Thames water and will act as market Repository
and Market Transaction Data store for MOSL. DMS working as Operational Data system (ODS). As MOSL
declared 3 rd Oct 2016 to open the Market for functional validation before opening the market
official. DMS had designed as per MOSL compatible and technically live on 3 rd Oct 2016




Role Developer and Requirement Analysts
Solution Environment SQL Developer 2008, DB2, PL/SQL, Unix Scripting ,Toad, Putty
Tools IBM Data Stage 8.5,9.1 and Quality Stage
Highlights
* Working as a Requirement Analyst understands the all business requirements directly with Client.
* Responsible for designing Data Model of DMS system.
* Responsible to connect with different vendor to understand the project requirement.
* I was worked as Developer due to very tight deadline of project requirement.
* To develop ETL workflows, mappings, SQL, Shell scripts to translate
* Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet
all the complex business rules implemented in ETL mappings and PL/SQL coding.
* Maintained Coding standards and participated in Code Review.

* Responsible for the Data Cleansing of Production Source Data before data loading.
* Designed and developed complex ETL's using various stage and developed the automated DMS system
which directly
access by MOSL system through ESB/IDEX.
* DMS system is live model and will directly access by centralized Market operator 1st April 2017
onward.

Project Initial Data Upload
Company Tata Consultancy Service Limited , London
Customer Thames Water Utilities - United Kingdom
Period 15th March 2016 to 30th May 2016
Description
IDU was one of the most important modules of every water company before opening the Market on 3 rd
Oct 2016. IDU comes into picture because all water/Waste company had existing commercial customer
and same information must be send into MOSL/CMOS System before marketing opening. As per MOSL, 1 st
April 2017 the entire commercial customer will be communicated through MOSL instead of individual
Water/Waste Service provider company. So through IDU module, All water/Waste company had loaded the
existing customer data into CMOS as per MOSL shared format.

Role Developer and Requirement Analysts
Solution Environment SQL Developer 2008, DB2, PL/SQL, Unix Scripting ,Toad, Putty
Tools IBM Data Stage 9.1,11.3 and Quality Stage




Highlights
* Working as a Requirement Analyst understands the all business requirements directly with client.
* Responsible for designing solution for IDU (Initial Data upload) of existing customer into MOSL
aligned to open water requirement.
* I was worked as Developer due to IDU was very critical module of Thames Water and client didn't
want to share the confidential data outside UK.
* This module completely developed in DB2 PL/SQL code and ETL only used to extract the data from
source system. So develop Complex DB2 PL/SQL scripts as per business requirement.
* Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet
all the complex business rules implemented in PL/SQL coding.
* Maintained Coding standards and participated in Code Review.
* Responsible for creating High level and low level design specification documents for the Business
logic align in DB2 PLSQL code mappings.
* Responsible for the Data Cleansing of Production Source
Data before data loading.
* IDU was successfully load MOSL system on 27th May 2016.

Company Tata Consultancy Service Limited , London
Project Wholesale Eligibility Tool
Customer Thames Water Utilities - United Kingdom
Period 19th Dec 2015 to 14th March 2016
Description
Wholesale Eligibility tool are automated tool to identifying the commercial and Non commercial
Customer of United kingdom. This tool was developed because MOSL only expect only Commercial
property for Market opening in 1st April 2017. This tool is working as taking Address of any
customer in any format, Tool first convert the address into standard format and then validate the
list of Commercial customer of VOA and then segregated accordingly.

Role Developer
Solution Environment SQL Developer 2008, DB2, PL/SQL, Unix Scripting ,Toad, Putty
Tools IBM Data Stage 8.5,9.1 and IBM Quality Stage
Highlights
* Working as Developer and identified the all the Wholesale customer of Thames and ready for Market
opening in 1st April 2017.
* Responsible for designing solution for Wholesale Eligibility
and shared the eligibility customer list with business through




automated PLSQL script.
* Initially this module completely developed in DB2 PL/SQL code after that move into ETL quality
stage as per Client request.
* Maintained Coding standards and participated in Code Review.
* Responsible for creating High level and low level design specification documents for the Business
logic align in DB2 PLSQL code mappings.
* Responsible for the Data Cleansing of Production Source
Data before data loading.
* Wholesale Eligibility tool is Live automated tool and various water companies are using to confirm
whether properties are commercial and Non commercial

Description Master Data Management is Automated system that undergoes step by step pre defined validation and
provides the data into SAP format.
Role Developer
Solution Environment SQL Developer 2008, DB2, PL/SQL, Unix Scripting ,Toad, Putty
Tools IBM Data Stage 8.5
Highlights
* Working as Developer and written DB2 PL/SQL code to developed the Automated system
* Data Migration of all the code from Oracle to DB2 9.7.
* Maintained and correct earlier written code into standards and participated format Code.
* Responsible for creating High level and low level design specification documents for the Business
logic align in DB2
PLSQL code mappings.
* Responsible for the delivering the Master data into SAP format.

Project Master Data Management
Customer CVS Caremark, USA
Period Jan 2013 to Dec 2013
Description Master Data Management is Automated system that undergoes step by step pre defined validation and
provides the data into SAP format.
Role Developer
Solution Environment SQL Developer 2008, DB2, PL/SQL, Unix Scripting ,Toad, Putty




Tools IBM Data Stage 8.5,9.1
Highlights
* Responsible for all activities related to the development of ETL processes for large-scale data
extraction, transformation and loading in Tables or SFTP the feed to data warehouse using ETL,
Pl/SQL
* The code is delivered in different releases every 4 to 6 months. I was streamlined to deliver the
code for the particular release.
* I make sure that all the coding standards are followed and
the code delivered is highly optimized with highest level of performance.
* Creating Design out of Business Requirement and the Use Cases.