Resume

Sign in

Sr Datastage Developer

Location:
New Delhi, Delhi, 110064, India
Salary:
8 Lacks/Annum
Posted:
May 31, 2010

Contact this candidate

Abhishek Gaba

Software Engineer

UnitedHealth Group

Email: nyry6e@r.postjobfree.com

Contact: **-921*******

Profile

I have a total IT Experience of ~3 years in Data Warehousing projects involving Extraction Transformation & Loading (ETL). Worked extensively on Datastage 8.0.1, Ascential Datastage 7.5.2, Scripting (UNIX), Oracle 9i (SQL*plus),

The major Client that I have worked for are Galaxy (UnitedHealth Care), Walgreens, Eli-Lilly and Agilent Technologies. Work closely with ETL Architect and Data Modeler.

Languages Oracle PL/SQL, SQL, Shell Scripting

Tools IBM Information Server V8.0.1, Data stage 8.0.1, Data stage 7.5.2, Autosys, Putty, MS Visio, SQL Developer, Pl/sql developer, Ultra Edit

Operating System Windows 98/2000/XP, UNIX AIX (for Servers), Red Hat Linux (for Servers),

Software Citrix Development Environment, Oracle 9i, M.S Office

Career Profile

Dec 2009 – Till Date UnitedHealth Group, Gurgaon (India)

Nov 2007 – Nov 2009 Tata Consultancy Services Limited, New Delhi (India)

Qualifications

Degree and Date Institute Major and Specialization

Bachelor of Engineering, 2007 JMIT-Kurukshetra University Computer and science

Assignment Details

Project Galaxy-Ingenix

Customer UnitedHealth Group (Galaxy)

Period Dec 2009 – Till date

Project Description Ingenix, a wholly-owned subsidiary of UnitedHealth Group (UHG), is a global healthcare information company founded in 1996 to develop, acquire, and integrate best-in-class healthcare information capabilities.

At the heart of all BI activity at Ingenix/UHG is the Galaxy enterprise data warehouse (DW). Galaxy is an atomic DW with transformations, integrating subject areas across various UGH platforms. Ingenix focused on data availability, performance, and information quality to develop Galaxy. The result: Galaxy is now the company’s single source of truth for many applications. Technologies and techniques developed for UHG are also sold to other healthcare companies, making Ingenix both an in-house analytics and IT group and a commercial solutions provider. Ingenix has three information quality goals:

• Ensure the company (and all applications using Galaxy) meets business-defined quality standards and goals. The database “must always be valid” to a Six Sigma level of verifiable quality.

• Monitor information quality continuously to save operational maintenance costs.

• Continuously improve Galaxy’s overall quality to ensure UHG’s overall health.

Role & Responsibilities • Enhancement and performance tuning of Datastage jobs.

• Automation of various ETL process from different sources via Unix Scripts and Datastage jobs

• Scheduling of jobs by using Autosys tool.

• Purging and archiving of the data.

• Analysis on the BA/SME request on the projected reports delivered to the customers.

Operating Systems Linux (for Servers) , Windows 2000(for Desktop/Clients)

Tools IBM Websphere DataStage 7.5.2 , PL/SQL Developer, Putty

Project PBS-ODS

Customer Walgreens (US)

Period May 2009 – Nov 2009

Project Description Assists organization to provide with Operational Data Store and with better Decision Support System for improving its telesales, marketing, accounts and sales management by providing aggregated, consolidated and highly Optimized information which is shared across multiple employees to implement Business Intelligence.

Role & Responsibilities • Requirement gathering - Data Quality and Data Profiling

• Involved in Data Modeling activities.

• End to end Business requirement analysis to find the feasibility of the project.

• Creation of Wrapper script (Script to invoke Datastage jobs with input parameters).

• 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 DataStage designer tools for loading the data into the data warehouse as per the specified design.

• Developer from ETL Development side.

• Creation of the low level and high level design documents.

• Developing design strategy for loading huge amounts of data.

• Preparation of Unit Test cases and Unit test results document and End –end testing of the jobs.

• Preparation of Integration and system level testing scenarios.

• Support to the Development & Testing Team regarding Server Configuration and build related issues at Onsite/Offshore.

Operating Systems Linux (for Servers) , Windows 2000(for Desktop/Clients)

Tools IBM Websphere DataStage 8.0.1 , PL/SQL Developer, Putty

Project CDI

Customer Walgreens (US)

Period Dec 2008 – May 2009

Project Description Assists organization to provide with better Decision Support making for improving its telesales, marketing, accounts and sales management by providing aggregated, consolidated and highly Optimized information which is shared across multiple employees to implement Business Intelligence.

Role & Responsibilities • 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 DataStage designer tools for loading the data into the data warehouse as per the specified design.

• Transformation and Aggregation of data using various stages in Datastage 8.0 according to the business requirements

• Developer from ETL Development side.

• Creation of the low level design documents.

• Developing design strategy for loading huge amounts of data.

• Preparation of Unit Test cases and Unit test results document and End –end testing of the jobs.

• Support to the Development & Testing Team regarding Server Configuration and build related issues at Onsite/Offshore.

Operating Systems Linux (for Servers) , Windows 2000(for Desktop/Clients)

Tools IBM Websphere DataStage 8.0.1 , PL/SQL Developer, Putty

Project Customer Data Maintenance

Customer Agilent Technologies (US)

Period Jul 2008 – Nov 2008

Description The main aim of the project is to maintain the existing data warehouse and also enhance/create new flows to enhance the data marts according to the requests received from the client.

Role • Developer

• Tester

• Reviewer

Responsibilities • Transformation and Aggregation of data using various stages in Datastage 8.0 according to the business requirements.

• Interacting with the client for the change requests (CRs) implementation including code enhancement and testing.

• Developing design strategy for loading the data mart tables as per the request received from the client.

• Development of Workflows, data flows, r/3 flows (pulling data from SAP, sequential files, oracle etc.)And sequencing them into the existing jobs as per requirement for loading the data into the data warehouse as per the specified design.

• Reviewing of the ETL jobs.

• Maintaining the existing application by monitoring the loads, resolving the production issues in very quick turn around time and also resolving the queries asked by the different users who use the data.

Operating System

Windows Server 2003(for Business objects data integrator11.7.3)

Business objects data integrator 11.7.3, PL/SQL Developer

Tools IBM Websphere DataStage 7.5x/7.5.1.A, PL/SQL Developer, Putty

Project Lit Station

Customer Agilent Technologies (US)

Period Feb 2008 – Jun 2008.

Description The aim of the project was to build a business intelligence layer on top of the existing Data warehouse as to provide a reporting solution which can be used by the managers for making strategic decisions

Role • Developer

• Tester

• Reviewer

Responsibilities • Development of ETL jobs using datastage.

• Preparation of High Level Design for the job scheduling and complex ETL jobs.

• Responsible for the whole project life cycle (PDLC) starting from requirements gathering from business users to successfully delivering the project through Agile Scrum methodology.

• Design of the database tables from the user requirements, views necessary for the reporting and design of the jobs.

• Developing complex SQL and PL/SQL components such as packages, functions, and views etc which are necessary for the project.

• Review of the deliverables and quality assurance.

Operating System

OS:-UNIX AIX (for Servers), Windows 2000(for Desktop/Clients).

Tools PL/SQL Developer, SQL*Plus, Datastage 7.5x/7.5.1.A.

TCS Corporate training (Initial Learning Program)

Location – Bhubhneswar (Orissa)

Duration – Nov 2007 – Jan 2008

During the ILP various software management processes were undertaken like system engineering, QMS, OOPS, software development life cycle and software engineering process. As part of training program, I as a part of a team developed a project, using Java and Oracle.

Courses attended –

 Data Warehousing

 Data Mining

 Object Oriented Programming

 Software engineering process

 SDLC

 UNIX

Certified Skills:

Title Organized by

Business Intelligence (Data Warehousing) TCS

DataStage TCS

Six Sigma - Introduction and DMAIC process TCS

Reporting with SAS (Stats) - module (E1), (E2) and (E3). TCS

Introduction to Oracle and SQL in Oracle Database 10g TCS

Unix Shell scripting TCS

Personal Details:

Name : Abhishek Gaba

Date of Birth : 06th -Sep 85

Sex : Male

Nationality : Indian

Marital Status : Single

Designation : Software Engineer (SE)

Location : New Delhi (INDIA).

Contact : C block – 201/A, 2nd floor, Hari Nagar

New Delhi -110064

Mobile: +91-921*******



Contact this candidate