Abhishek Gaba
Software Engineer
UnitedHealth Group
Email: nyry6e@r.postjobfree.com
Contact: 91-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*******