Software Engineer

Madhava Email:- **********.*****@*****.*** ETL Developer Mobile No: +91-872*******

Summary of Skills and Experience:

Having 3.8 years of experience in IT Industry with experience in Designing, Development and Implementation in Data warehousing using IBM Info sphere Data stage 9.1v.11.3v.11.5v

Extensive experience in Designing and Debugging Parallel Jobs and Job Sequence.

Having knowledge on data warehouse concepts like Star Schema, Snow Flake, Dimension and fact tables.

Experience with various stages of software life cycle - Design (high-level and low-level design), Implementation, Unit testing and Maintenance.

Developed Parallel jobs using different Stages like Aggregator, Join, lookup, Transformer, Sort, Merge, Funnel, Modify, Filter, Remove duplicates stage, Data set stage, File set stage, Change Capture etc.

Expert in Creation of Sequence jobs using Job Activity, Wait for File Activity, Exception Handler, Sequencer, Terminator Activity, Notification Activity etc.

Good Knowledge in UNIX and SQL.

Good communication skills, Quick learner and ability to meet tight deadlines and work under pressure.

Flexible and versatile to adapt to any new environment and work on any project.

Educational Qualification:

B.Tech (CSE) from JNTU (Kakinada)-2015.

Experience Summary:

Worked as an Associate Software Engineer in Tech Mahindra, Chennai from June 2015 to Dec 2017.

Currently working as Software Engineer with Accenture, Bangalore from Jan 2018 to till date.

Technical Skills:

ETL Tools : IBM Info sphere Data stage 9.1& 11.5,

Programming Languages : SQL, UNIX,

Database Server : Oracle 10g/11g, Db2

Operating Systems : Windows Family.

Project#1

Customer : Johnson & Johnson

Project : UDMH

Position : ETL Developer

Duration : Jan-18 till date

Project Description:

Johnson & Johnson Janssen Care Path One Platform consists of a digital platform for Providers, Patients, and HUB partners that enable the Patient’s access and affordability for Janssen products by providing services such as Benefit Investigations, Prior Authorizations, Savings Program Enrolment and Activity Monitoring, and Prescription Fulfillment.

The primary goal of the UDMH project is to extract patient related data from sales force data and load the data warehouse. This data will be used to analyze the patient case history and provide maximum discount on the cancer medication.

Responsibilities:

Data Extraction from sources and loading into staging area.

Data from Staging area to be loaded into the BDW Model. Before loading into the BDW Model the Data needs to be cleansed for address, phone number, emails etc.

The Data from the BDW Model to be loaded into Data mart and Business Vault after another round of cleansing: mainly the de-duping of customers.

Developing of data stage jobs for extraction and staging, cleansing, transformation of data as per mappings document.

Jobs are developed by using stages like Transformer, Lookup, Join, Merge, remove duplicates, funnel, join, Aggregator, filter, sort, Datasets, Sequential files etc.

Involved to improve the job performance for the developed Data stage jobs.

Project#2

Customer: Verizon (Telecom domain)

Project: Verizon - Verizon Telco Audit Tool (VTAT)

Position: ETL Developer

Duration: Sep-2016 till Dec-2017

Project Description:

The main aim of the project is to load the invoices are currently maintained in different kinds of files and in

Mainframe database to staging area. Each file has different format records which indicate a telephone invoice.

These records of the same type’s i.e. similar invoices from different invoice files and mainframe are

Consolidated, loaded into ODS.

Responsibilities:

Developer from ETL Development side. Responsible for creation of low level design documents

Development of jobs and sequencers for extracting the data from the variable data sources such as Flat files, main frame database etc. loading modules using the Data Stage designer tools for loading

The data into the data warehouse as per the specified design.

reviewing of the jobs created by others

Preparation of Unit Test cases and Unit test results document and End –end testing of the application

Understand Business requirements and different Mapping documents for each module.

Analyze various mapping documents for all releases and developed jobs by using different stages like change capture, Transformer, Lookup, Sequential file, aggregator, sort and Datasets etc.

Developed SCD type1 and type2 jobs that process the data from file to EDW.

Performed unit testing and prepare various Test case documents.

Fixed various types of issues which are raised by support team.

Did performance tuning to enhance the performance of job

Involved in status calls to Client and provide the daily status reports.

Project#3

Assignment : BD Sunshine.

Client : Becton, Dickinson and Company.

Duration : July-2015 to Aug–2016

Database : Oracle, Db2

Tools : Data Stage 9.1

Project Description:

Tesco is a multinational grocery and general merchandise retailer, it is the second-largest retailer in the world measured by profits and third-largest retailer in the world measured by revenues.

Change Program is for the development of Tesco’s Web-Based Market Place platform, development of new Source systems replacing traditional Legacy Systems and end to end integration of data from various source systems involved. Business Intelligence in this project involves extracting huge data coming from various sources, which is then integrated, transformed and loaded into ODS, Enterprise DataMart, Reporting DataMart following a near snowflake Schema.

Tesco.com change program is a step towards integrating processes across multiple lines of business of Tesco and effectively leveraging the existing store, delivery, and call center infrastructure to provide a consistent and a truly multi-channel shopping experience to the customer.

Responsibilities:

Understanding the requirements from business and shareholders and creating the functional and mapping documents.

Understanding the Source system changes and analyzing the impact on previously developed jobs.

Creating the ETL job based on requirements and mapping documents.

Creating the feeds for Tesco third party vendors in order to improve or promote the business based on the inputs received from customers.

Creating the ETL jobs to process the data from one system to another system.

Very good experience in monitoring and fixing the incidents for daily and weekly production jobs.

Involved in defect triage calls to discuss blockers and defect review meetings to prioritize the defects based on business criticality.

Involved in unit, performance, Regression and Integration testing and prepared Documentation.

Contact this candidate