Summary

• Over 8 years of career reflecting IT experience in Data Warehousing, Data Integrations, Data Migrations, Data Quality using IBM InfoSphere Information Server 8.5/8.1/8.0/7.5/7.0 and other tools like Quality Stage 8.5/8.1,Information Analyzer 8.5/8.1.
• Designed high level design documents, low level design documents, mapping specifications, UTC/UTQ's etc. based on the projects requirement.
• Extensively worked on DataStage parallel jobs using Various Stages like Join, Lookup, Merge, Change Capture, Filter, Funnel, Aggregator, Sort, Sequential File, File set, XML Input, XML Output, Transformer, Websphere MQ connector, Data set, Oracle Enterprise, Teradata, DB2, Sybase and Remove Duplicate Stages, Routines etc..
• Experience in migration from DataStage 7.5 environment to IBM InfoSphere DataStage 8.5 and server jobs to parallel.
• Performed different Data Quality tasks using DataQuality stages like investigate, unduplicate match, standardize and survive.
• Experienced in writing complex SQL queries and PL/SQL stored procedures on Oracle 11g database.
• Extensively worked on Parallel Extender on Orchestrate/Enterprise Edition Environment for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve job performance using partitioning methods and APT Configs.
• Performed Debugging, Troubleshooting, Monitoring and Performance Tuning for DataStage jobs.
• Involved in all the stages of Software Development Life Cycle SDLC .
• Strong Data modeling skills including Star Schema and Snow-Flake models and E-R modeling.
• Strong database skills with Oracle, SQL Server, Db2 and Teradata.
• Worked on Teradata Utilities like Fastload, TPUMP, MLoad etc.
• Having very good knowledge on connecting to XML Sources.

Technical Skills:

Professional Experience:

Confidential

Sr. IBM DataStage Developer

Responsibilities:

• Worked on complete life cycle of Design, Development, Testing, documentation of conversion process and maintenance.
• Interacting with business users to identify the most important KPI's and meetings with SMEs on gathering the business requirements.
• Performed Source System Analysis. Analyzed the Source and Target Data elements, developed S2T Mapping documents, profiled the source systems and Unit System Test Plan.
• Worked on the technical development delivery strategy packages which include technical design, development and testing phase.
• Developed ETL procedures to ensure conformity, translated business rules/functionality requirements for Healthcare Exchange to Altegra Health for analysis and CMS reporting from both EDW and FACETS Membership, Enrollment, Provider, Claims, Employer Groups, Medical Groups, PCP Assignment and Provider Speciality XWalks and other subset of subject areas using InfoSphere DataStage 8.5
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities Triggers Conditional and Unconditional , Wait for file, Email Notification, Sequencer, Exception handler activity.
• 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 on an ad hoc or scheduled basis.
• TDD and Code review sessions with Hap Idt technical team, worked with client management and on-site BAs to implement test, prepared own UTCs/UTQs and reviewing them with Hap Idt technical team.
• Researched, resolved production CMS reporting issues on RAPS .
• Optimize DataStage jobs, SQL and Pl/SQL scripts to reduce run-time, worked on ACES Framework model.
• Proactively evaluated the quality and integrity of data required by the users to satisfy their business needs. Issue analysis and bug fix in QA phase
• Knowledge transition on systems and domain for new project team members and extended teams for enhancements

Environment: IBM InfoSphere DataStage 8.5 Designer, Director, and Administrator , Oracle 11g, FACETS,Toad, SQL Developer , ACES Framework, Unix Shell Scripts and Windows 7.

Confidential

Sr. IBM DataStage Developer

Responsibilities:

• The Project goal is to load the Members related data for various Applications into the DB2 Enterprise Data Warehouse and MS SQL Server. This involved in pulling data from various source systems like Flat Files, Oracle, DB2 and Sybase and loading the target Identity Access Management Database Tables.
• The main purpose of the project was to build integrated reporting of health and care management including integrated, web-based, on demand reporting capabilities for employers as well as internal consulting staff thereby improving customer access to clinical and financial data to help.
• Worked on more than 6 waves among 24 and involved in migration from server jobs to parallel, Involved in designing the simple to complex Data Stage jobs.
• Involved in building the base fact tables, aggregate fact tables, dimension tables, Data mart tables, change requests and defect issues related to the Data Warehouse project.
• Involved in the technical development delivery strategy packages which include technical design, development and testing phase.
• Effectively used DataStage Manager to Import/Export projects from development server to production server and implemented Slowly Changing Dimension techniques.
• Coordinated K tables with dba for each wave in devl, test, prod and monitored common routines list and priority, providing specifications.
• Created and executed SQL queries for validating transformation rules used in source to target mappings. Worked on SQL/PLSQL queries for extraction of data.
• 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 on an ad hoc or scheduled basis.
• Developed Job Sequences, job activtities, execute commands, user variable activity and implemented logics for job sequence loops, recovery and restart.
• Performed the unit testing.by using MS Access and extensively used Daptiv for defects management.
• Identified performance bottle-necks and suggested improvements.

Environment: IBM InfoSphere DataStage 8.5/7.5 Designer, Director, and Administrator , IBM InfoSphere FastTrack, DB2, SQL Server, Oracle11g, SQL Server management Studio,DB2 Control center, ZENA, Daptiv, DB2 Putty and Windows 7.

Confidential

Sr. IBM DataStage Developer

Responsibilities:

• Participated in gathering the user requirements and involved in writing technical design documents, Detailed Design Document and Unit Test plans.
• Used the IBM InfoSphere DataStage 8.5 to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively used IBM InfoSphere FastTrack for different Business Requirement Documents and implemented job designs accordingly.
• Participated meetings with Data Architect and Business users to define correct sources of Data Marts tables and Data warehouse tables.
• Developed the overall data integration framework for the project.
• Responsible for complete end to end data deliverables with data team support.
• Direct responsible for Project migration from Development to QA, UAT and production.
• Worked on performance tuning, performance monitoring and enhancement of DataStage jobs.
• Extensively used AquaData Studio and Squirrel for writing SQL queries while unit testing to make sure with the business requirements applied are correct.
• Worked with DataStage import/export metadata, jobs, and routines from repository and also created data elements. Extracted data from sources like FACETS target.

Environment: IBM InfoSphere DataStage 8.5 Designer, Director, and Administrator , IBM InfoSphere FastTrack, DB2,Oracle 11g,AquaData Studio 13.0,SQuirreL3.0/2.6.9 SQL, Autosys, Putty and Windows 7

Confidential

IBM DataStage Developer

Responsibilities:

• Participate in meetings with Data Architect, Business users and Source system teams to define correct sources of Data Marts tables and Data warehouse tables.
• Involved in Business analysis and technical design sessions with Business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Implemented and Review the ETL code and Unit Test plans of all the requirements before moving into UAT phase.
• Design DataStage jobs by using IBM InfoSphere DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into Data Mart.
• Created QualityStage jobs to Match, Un-Duplication, Survive and Standardize data from different source systems.
• Involved in up-gradation of DataStage 7.5 to 8.5.
• Created XML documents by using XML Input/output stages to send and receive Medicaid and Medicare information to Insurance companies, Pharmacy managers.
• Participate in application and infrastructure engineering review and security audit.
• Optimize DataStage jobs, SQL and Pl/SQL scripts to reduce run-time.
• Involved in preparation of production support guidelines documents.
• Involved in implementation of UNIX shell scripts to copy files among different servers and to invoke PL/SQL scripts, DataStage jobs.
• Involved in preparation of Autosys JIL scripts to schedule the jobs.

Environment: IBM Information Server 8.5, Erwin 5.5, Cognos8.2, Linux, Oracle 11g, Flat files, Hashed files, SQL, PL/SQL, UNIX, Toad, SQL Developer, Autosys and Putty.

Confidential

ETL Developer

Responsibilities:

• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.
• Data analysis to study the data base data that is required for the different source system.
• Extensively Worked with DataStage Enterprise Server Edition to use improved stages Dataset, Look-Up Stage, File-set and Row generator.
• Developed Analytical applications that can analyze large amounts of online and offline data using orchestrate environment.
• Knowledgeable in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Using Orchestrate, integrated third party applications within house applications.
• Unit testing of the jobs developed.
• Worked on programs for scheduling Data loading and transformations using DataStage from legacy system and Data Warehouse to Oracle 9i.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Categories and creating new data elements.

Environment: Ascential DataStage 7.1, IBM DB2 7.0, Oracle 8i, DB2, Windows XP.