SUMMARY

• Over 7+ years of extensive experience in building data warehouse/data marts with extraction transformation and loading (ETL) processes using IBM InfoSphere Information Server-Data Stage versions 8.7/8.1/7.x/ and Quality Stage.
• Extensive experience in using Oracle development tool set (Including PL/SQL, SQL*Plus, SQL Loader, PL/SQL developer).
• Production job scheduling on UNIX through Control-M scheduling tool and also using Datastage.
• Involved in all the stages of Software Development Life Cycle.
• Proven track record in troubleshooting of Datastage jobs and addressing production issues like performance tuning and enhancement.
• Good knowledge on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Extensively worked with Parallel Extender /Server to improve job performance while

working with data sources.

• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Complex Flat Files, Aggregator, Join, Transformer, Sort, Remove Duplicates, Merge, Filter and Lookup.
• Worked with Local Containers, Shared Containers and Job Sequences.
• Demonstrated ability in dealing with different stages (Hash, Shared Containers, and Merge etc).
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Strong experience in UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
• Experience on DW/Business Intelligence tools.
• Experience in Data analysis to understand the Business requirement.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Experience with the Build, Migrate and Shakeout process of the development code to higher environments (Sys Test, UAT, and PROD).
• Extensive experience in MS- SQL 2005, PL/SQL, SQL, Procedures and Oracle 11g/10g/9i.
• Experience on IBM Web Sphere 8.1/8.0 Quality Stage.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Excellent communication skills.
• Aptitude for analyzing, testing, debugging code, identifying problems, creating solutions and documentation.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Good aptitude for problem solving and logical analysis.
• Highly motivated, team player with excellent interpersonal and communication skills, organized and quick learner.

Technical Skills:

ETL Tools:

ASCENTIAL DATASTAGE 7.X/8.0/Quality Satge.

Databases:

ORACLE 7.X/8i/9i/10g, SQL SERVER 6.5/7.0, DB2 UDB 7/8/9.7, Teradata V2R5/V2R6/V12, TeraData

Languages:

C, C++, Java, UNIX Shell Programming, SQL, PL/SQL

Data Modeling:

Star Schema Modeling, Snowflake Modeling, FACT and Dimension tables, Erwin 4.0

Reporting Tools:

Business Objects/Web Intelligence

Web Technologies:

HTML, Dreamweaver, FrontPage

Operating Systems:

Windows NT4.0/2000/SP-3, MS-DOS, UNIX (Solaris, Linux, AIX, HP-UX)

Tools:

Autosys, Control M, SQL*Loader.

Professional Experience:

Confidential,CA May’12 to Present
Sr. Datastage Developer

VSP GlobalSMis a complementary group of leading companies, working together to meet and exceed the needs of eyecare professionals, clients, and our more than 57 million members. Combining the strength and expertise of each of these companies, VSP Global provides benefits, services, products, and solutions that are unparalleled in the optical industry.

Responsibilities:

• Involved in multiple projects Loyalty2013, Connecting consumers, Optics& Lens.
• Directly interacted with the Business users for collecting the requirements.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Extensively worked on DB2 and Oracle tables handling large volumes of customer data.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different tables.
• Extensively worked on modified the shell scripts in different environments.
• Extensively used Sequential files, Oracle, DB2, Complex Flat Files, Sort, Funnel, Remove Duplicates, Merge, Aggregator , Pivot, FTP and created datasets.
• Done performance tuning for already existing jobs and also performed query optimization.
• Involved in production deployment process of DataStage jobs and shell scripts.
• Built Sequencer jobs to synchronize the control flow of multiple activities in a job sequence and Scheduled for Automation.
• Wrote the Design documents and specifications in accordance with VSP’s design frameworks and best practices.
• Undertook Change and Enhancements request.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Used Version Control to keep track of multiple versions of Datastage jobs and promote latest job versions from Development to QA and Production environments.
• Extensively worked on Migrating Datastage jobs form Infosphere DataStage 8.0.1 to InfoSphere Information Server8.7 version.
• Also provide Production support for jobs already in use and rigorously worked on resolving errors in production environment.

Environment: IBM Infosphere DataStage 8.0.1, IBM AIX -5.3, Eclipse, Shell Scripts, Oracle 10g, Sql Plus, DB2 9.7, Unix, Windows XP SP-3.

Confidential,Alpharetta, Ga Mar’11 to Apr’12
Sr. Datastage Developer

McKesson is America\'s oldest and largest health care services company, with its pharmaceutical wholesaling roots dating back more than 175 years. McKessonis dedicated to delivering the vital medicines, supplies and information technologies that enable the health care industry to provide patients better, safer care. This project is intended for Data Conversion from People soft, Oracle, HP to SAP System.

Responsibilities:

• Built Datastage jobs for Data Conversion project.
• Developed Business specification documents by collecting the information from several Business teams.
• Worked closely with the Contracts and Sales Orders teams in gathering the functional requirements to give a high level design.
• Extensively worked with Datastage Designer, Administrator and Director for creating and implementing jobs.
• Extensively worked on Data Extraction, Transforms, Loading and Analysis.
• Worked with Oracle tables and Flat files.
• Performed lookups and transformation on the data and Performance tuned DataStage to reduce batch run time.
• Extensively used Sequential files, Complex Flat Files, Sort, Funnel, Remove Duplicates, Merge, Aggregator and created datasets.
• Created jobs to produce unit test data using Row Generator, Column Generator, Sequential file and Dataset to perform UTP(unit test plan)
• Developed Shell scripts for Cleansing, Moving and Archiving the files.
• Enforcing data Integrity rules/ Business Rules. Maintaining huge volume of data.
• Performed Data validation and Regression testing for the downstream systems.
• Used Datastage Sequencer jobs extensively to take care of inter dependencies and to run Datastage parallel jobs in sequence.
• Documented Source-Target mapping and Unit Test plans and scripts for the DS jobs.
• Provided support for QA and Production Environments.

Environment: Infosphere DataStage 8.0.1, IBM AIX -5.3, DataStage Version Control, SAP GUI ECC 6.0 , Shell Scripts, Maestro scheduler, Unix, TeraData, Windows XP SP-3.

Confidential,Detriot, MI May’09 - Feb’11
Sr. Datastage Developer

GMAC Financial Services is a global finance company and specializes in automotive finance, real estate finance, insurance, commercial finance and online banking. The main goal of the EDW Project is to extract the data from source system (GIF), standardized and loads in to Enterprise Data Ware house (EDW).

Responsibilities:

• Designed jobs using different parallel job stages such as Sequential files, Complex Flat Files, Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup File Set, Change Data Capture, Modify, and Aggregator.
• Used the Quality Stage to standardize and cleansing the source data which comes from GIF.
• Extensively used INFORMATION SERVER (8.1) to develop the parallel jobs.
• Exporting of DataStage Components & Packaging of Projects using DataStage Designer and to create backups.
• Using TIVOLI scheduler for scheduling various jobs.
• Prepared the Source to stage and Stage to EDW mapping documents and provided to the offshore team for the Development
• Involved in the design and documentation of High Level design document and detailed design document.
• Involved in modifying of UNIX shell scripts for Batch jobs etc /State file creations etc.
• Loaded data into staging and lookup tables.
• Involved in mapping team discussions to solve the issues in mapping document/Design.
• Extensively worked on Integrity’s processes such as Investigation, Standardization, Matching and Survive and pre-defined rule sets for data cleansing.
• For Effective Standardization manually defined rule sets.
• Implemented the slowly change dimensions (Type 2) using CDC (change data capture) Process.
• Worked with deployment team in data cleansing before moving it into the production environment.
• Ran jobs using Parallel Extender for splitting bulk data into subsets and dynamically distribute to all available nodes to achieve best job performance
• Design complex job control processes to manage a large number of Jobs.
• Used Datastage Parallel Extender for splitting the data into subsets and to load data, utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment
• Done the Performance tuning on long run ETL jobs.

Environment: IBMInformationAnalyzer 8.1(DataStage EE), Quality Stage, Oracle 10g, Tivoli Scheduler, SQL, PL/SQL, Shell Scripts, SAP.

Confidential,Foothill Ranch, CA Feb\'08 – Apr’09
DataStage Developer

Apria Healthcare Group and its subsidiaries provide home healthcare services and related support services in the United States. It operates in three segments: Home Respiratory Therapy, Home Infusion Therapy, and Home Medical Equipment.

Responsibilities:

• Worked at Apria Healthcare on the Presto EDW Project designed to cater to the Decision Support Systems of the various business segments.
• Primarily worked on the conversion of the existing jobs in DataStage Version 7.5.1 to DataStage Version 8.0 and incorporation of data from new business acquisitions into the DWH.
• Executed Proof of concepts to understand the impact to older jobs in the DataStage Version 8.0
• Migrated existing jobs to DS Version 8.0 and did scheduled multiple runs of sequences to verify the ETL processes
• Extensively coded older Quality Stage components in the new DataStage 8.0 version.
• Understood functional documents for new business source systems and applications and their integration into the existing DWH.
• Defined the Mapping and Test Case documents.
• Identified source systems connectivity, related tables and fields and ensure data suitably for mapping.
• Extensively analyzed the Data Sources in identifying data anomalies, patterns, value ranges. Wrote SQL scripts for accomplishing the same.
• Loaded data using both DB2 API and EE Stages.
• Used Data Stage Enterprise Edition/Parallel Extender stages namely Datasets, Sort, Lookup, Peek, Standardization, Row Generator stages, Remove Duplicates, Filter, External Filter, Aggregator, Funnel, Modify, Column Export in accomplishing the ETL Coding.
• Developed DataStage job sequences used the User Activity Variables, Job Activity, Wait for File stages, Execute Command, Loop Activity, Terminate
• Modified Extensive Unix scripts for running the Datastage jobs, used awk utility for validating data.
• Developed Error Logging and Auditing strategies for the ETL jobs.
• Checked source code into Datastage Version Control, promoted code for Integration runs and subsequent QA Deployment.
• Co-ordinated the deployments of code across test and production environments with the deployment teams.
• Tuned DataStage jobs to enhance their performance.

Environment: DataStage 8.0 Enterprise Edition/Parallel Extender, Quality Stage, DB2 Version 8.0, AIX, SQL/PL/SQL, Unix Shell Scripting, Ultra Edit.

Confidential,Cincinnati, OH Nov’06 - Jan’08
Datastage Consultant

Union Central Life Insurance provides homeowners insurance, life insurance and investment products. The goal of the project is to implement ETL process to load Enterprise data warehouse and develop customer relationship data mart (CRDM) which supports Business Intelligence. Customer Relationship Data mart contains two schemas one for sales and one for intermediary.

Responsibilities:

• Extensively used Datastage for extracting, transforming and loading databases from sources including Oracle, Teradata and Flat files.
• Worked on IBM Datastage Designer, Manager, Administrator and Director.
• Created re-usable components using shared containers for local use or shared use. Exported the universe to the Repository to make resources available to the users.
• Loaded data into load, staging and lookup tables. Staging area was implemented using flat files.
• Wrote Datastage Routines for implementing business rules.
• Generation of Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
• Created Batches (DS job controls) and Sequences to control set of Datastage jobs.
• Developed QualityStage jobs using the stages including Standardize and Investigate.
• Used QualityStage Jobs to cleanse the data, by calling it from Datastage.
• Created Data Model using Erwin from data sources and defined the dimensions, levels and measures in the model.
• Utilized Datastage Parallel Extender, to optimize performance in this very large database environment.
• Ran jobs using Parallel Extender for splitting bulk data into subsets and dynamically distribute to all available nodes to achieve best job performance.
• Created stored procedures, functions using PL/SQL for implementing business rules and transformations.
• Implemented the underlying logic for Slowly Changing Dimensions.
• Executed Pre and Post session commands on Source and Target database using Shell scripting.
• Experience on Performance Tuning.

Environment: Ascential Datastage (Enterprise Edition) V 7.5, UNIX, SQL, ORACLE10g, PL/SQL, IBM AIX 5.2, Windows 2000 Operating system.

Confidential,Hyderabad, India Aug’05 - Oct’06

Oracle Developer

The Objective of the project is to design and develop Resume Mart which is a place for job Seekers and Job Providers to meet. The database should collect also the Minute details about the job seekers and provider. Resume Mart is designed to collect multiple resumes from the jobseeker. Resume Mart is provide Job Provider with enormous amount of data. Modules Involved 1.Designing and implementing job seekers & job providers. 2. Designing and Implementing Resume Database, Job Database. 3. Designing a Resume search engine.

Responsibilities:

• Participated in the detail Database Design.
• Participated in the detail Resume Mart Designing, coding.
• General Procedures and functions for various user requirements were coded, tested and implemented.
• Participated in the detail design of the specifications of the database and the associated Screens.
• Developed Forms and Reports using PL/SQL routines, Packages and Triggers.
• Excellent communication skills.
• Declaration of host variables to establish communication between the host application and the oracle database.
• Involved in reengineering the existing database to design temporary tables for storing legacy system data before loading into oracle system.

Environment: Oracle8i, Developer 6i, PL/SQL