PROFESSIONAL SUMMARY:

• 10+ years of experience in system analysis, design, development and implementation of Relational Database and Data Warehousing systems using IBM DataStage 8.5, 8.1/7.x/6.x/5.x (Information Server, Web Sphere, Ascential DataStage).
• Experienced in designing, developing, documenting, and testing of ETL jobs and mappings in Server and Parallel jobs using DataStage to populate tables in Data Warehouse and Data marts.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Expert in designing parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experienced in integration of various data sources (DB2 - UDB, SQL Server, Sybase, Oracle, Teradata, XML and MS-Access) into data staging area.
• Expert in working with DataStage Manager, Designer, Administrator, and Director.
• Experienced with Microsoft DTS packages.
• Experienced in handling facets in Health care systems.
• Involved in system transaction training on Claims, Utilization Management, Benefit Plans, Billing, Commissions, Capitation, Customer Service, and Security.
• Experienced in Data Modeling as well as reverse engineering using tools Erwin, Oracle Designer MS .
• Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Worked on different Scheduling tools like Autosys for automating jobs run.

TECHNICAL SKILLS

Skillset: IBM Information Infosphere, 11.2,9.1, 8.5(Datastage, Information Analyzer, Business Glossary),IBM Information InfoSphere 8.1, Ascential DataStage Enterprise Edition and DataStage 7.5.2/7.0/6.0 (Administrator, Designer, Manager and Director), Informatica Power center 9.0,Infosphere Data Architect 7.5.2,Teradata SQL Assistant, Oracle Designer, Erwin, ER/Studio, TOAD, C, C++, Visual Basic, SQL, PL/SQL, Oracle 11i/10g/9i/8i/7.x, SQL Server 2000/2005/2008, MS Access, Teradata, DB2, Unix, Linux, IBM AIX 5.2/5.1,7.1,9.1, Sun Solaris V8.0, HP-UX V11.0, Windows XP/NT/2000/98, DataStage Version Control.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis MO

Datastage Developer / Quality stage Developer

Hardware/Software: IBM Info sphere Information server 8.5 (Data stage, Quality Stage, Information Analyzer, Business Glossary), Oracle 11g, TOAD, UC4, Sequential files, AIX UNIX, Autosys.

Responsibilities:

• Actively participated in the SCRUM meetings for daily update and Iteration Planning meetings.
• Interacted with BA to understand the business requirements and in identifying data sources.
• Worked on BOEING project for loading into final schemas tables for Anderson and Epic Clarity Data.
• Involved in meetings with IBM team for upgradation of IBM Datastage.
• Working on loading the data in MCDW POTCL tables.
• Used Data Stage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Used Aggregator stage, to count the no of records that were rejected during Execution of ETL job.
• Data Profiling, Standardization, matching and cleansing activities through data quality process.
• Used Quality Stage for standardizing the names and Address, Identified Duplicates, Matched and Unmatched records in each source system.
• Used Investigation stage for identifying handled and unhandled data.
• Involved in creating designing and mapping documents for DataStage jobs.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Created Job Sequencer to execute a set of jobs.
• Created error and exception handling procedures to identify record, report and fix errors.
• Validated the current production data, the existing data and programming logics involved.
• Used TOAD as a querying tool to perform the basic database testing to see if there any data inconsistencies
• Used shell scripting for Scheduling and FTP process..
• Extensively tested the ETL jobs that were scheduled in UC4 tool for scheduling, timing and data integrity.
• Used Daptiv for Project management tool.

Confidential, Atlanta (GA

Datastage / QualityStage Developer:

Hardware/Software: BM Info sphere Information server 11.2 (Data stage, Quality Stage, Fast track, Information Analyzer, Business Glossary), SAP ECC 6.0,SQL, Server 2008, Oracle 11g, Autosys, Erwin, UNIX, HP quality center.

Responsibilities:

• Involved in status meetings, and interacted with the Business Analyst to get the business rules
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Involved in meetings with SAP functional team, to discuss on Customer master and Vendor master data.
• Continuously working with data stewards to gather requirement specifications.
• Worked on BDR (Business Data repository) to identify fields in SAP.
• Fast Track mapping from legacy systems to target SAP.
• Profiling Legacy systems like column analysis, Drill through Reports & custom filters in information Analyzer.
• Data Profiling, Standardization, matching and cleansing activities through data quality process.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the DataStage coding.
• Applied default, field and cross reference Transformation rules in data stage.
• Implemented RTL Process from Staging area to alignment to generate gap reporting.
• Used different stages in Datastage designer to load the data in different SAP tables (LFA1, LFBK, LFM1, ADDR2, ADDR3, ADDR6, and TIBAN Tables).
• Involved in creating functional and scope documentation for data cleansing, conversion, and integration processes.
• Managed the Metadata associated with the ETL processes used to populate the data.
• Used Information Analyzer for generating Column Analysis and Primary Key analysis report..
• Used Quality Stage for standardizing the names and Address, Identified Duplicates, Matched and Unmatched records in each source system.
• Used Investigation stage for identifying handled and unhandled data.
• Created SAP Idoc jobs to load data into SAP Idoc.
• Used the DataStage Director for scheduling and monitoring the jobs.
• Involved in Exports and Imports of ETL jobs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for extracting the data..
• Involved in job scheduling using Autosys.
• Created re-usable components using shared containers for local use or shared use.
• Created Job Sequencer to execute a set of jobs.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results,

Confidential

Datastage Developer

Hardware/Software: IBM Info sphere Information server 9.1 (Data stage, Quality Stage, Information Analyzer, Business Glossary), Oracle 11g, Autosys, TOAD 9.6, Erwin, UNIX, HP quality center.

Responsibilities:

• Involved in technical leadership in the analysis, decision-making, design, and support phases of implementation of computer applications and network hardware and infrastructure, operating systems, databases and enterprise-wide business applications.
• Involved in development phase meetings for Business Analysis, Requirements Gathering and managed offshore team to get Expected results.
• Extensively used DataStage Manager, Designer, Administrator and Director for creating and implementing jobs.
• Extensively worked on error handling, cleansing of data, creating lookup files and performing lookups for faster access of data.
• Used DataStage Manager to import the Metadata from sources and targets.
• Involved in creating technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the DataStage coding.
• Used the DataStage Director for scheduling and monitoring the jobs
• Used DataStage debugger to troubleshoot the designed jobs.
• Used Shared Containers for code reuse and implementing complex business logic.
• Tuned DataStage jobs to enhance their performance

Confidential, Cleveland OH

Data Stage Developer/Quality Stage Developer:

Hardware/Software: IBM info sphere Data Stage 8.5 (Designer, Director, Manager, and Parallel Extender), Oracle 11i, Teradata, PL/SQL, MS SQL, Server 2008, DB2, Flat files, Sequential files, AIX UNIX, Erwin 7.5, and

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Designed the Data Models using Erwin 7.5.
• Created Physical and Logical models using Erwin.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Involved in creating entity relational and dimensional relational data models using Erwin tool.
• Generated snowflake, models through dimension modeling.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.

Confidential, New York City (NY)

Datastage Developer/Quality Stage Developer

Hardware/Software: IBM Info sphere Information server 8.5 (Data stage, Quality Stage, Information Analyzer, Business Glossary), Oracle 11g, Flat files, Autosys, TOAD 9.6, Erwin, UNIX, hp quality center.

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Involved in appropriate and quality of data for data integration initiatives.
• Involved in Facets of integrated health care management system designed to handle the complex requirements of managed care programs
• Involved in system transaction training on Claims, Utilization Management, Benefit Plans, Billing, Commissions, Capitation, Customer Service, and Security.
• Involved in detailed knowledge of Quality Stage stages to develop an effective application..
• Used appropriate tool to fulfill data quality and business requirements.
• Provided metadata to create functional and technical specifications for data integration/cleansing applications.
• Monitored resolution of data quality issues.
• Involved in understanding logical and physical models for the subject area of the Customer Information Management.
• Involved in Documentation Planning and Implementation.
• Experienced with data modeling tools such as MS Visio and/or Erwin

Confidential: Chicago IL

Datastage Developer/Quality Stage Developer

Hardware/Software: IBM Infosphere Information server 8.5 (Datastage, Quality Stage, Information Analyzer, Business Glossary), Oracle 10g,SQL Server 2008, DB2 UDB, Teradata, Flat files, Sequential files, Control-M.

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Developed and executed IBM Quality Stage data quality tools.
• Supported and generated Enterprise Data Governance quality assurance metrics.
• Created critical field reporting tools for Enterprise Data Management customer segments..
• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of Data Stage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.

Confidential

Hardware/Software: IBM InfoSphere Information Server (DataStage and Quality Stage, Information Analyzer, Metadata Workbench) 8.1, IBM-AIX, SQL Server 2008, Oracle 11g, Unix Shell Scripts (ksh), PL/SQL,UNIX, Autosys, Erwin/MS Visio .

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts to get specific user requirements.
• Involved in understanding logical and physical models for the subject area of the Customer Information Management.
• Involved in Documentation Planning and Implementation.
• Experienced with data modeling tools such as MS Visio and/or Erwin.
• Experienced in relational data models such as conceptual, logical and physical data models, dimensional data models, data dictionary, and metadata.
• Responsible for developing, validating, and communicating data modeling solutions, including both relational and dimensional models.
• Designed the mappings between sources (external files and databases) and Operational staging targets.
• Involved in Project management from analysis and design to implementation and construction.
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director.
• Received the source data in the form of Oracle tables, Sequential files, flat files and Excel sheets, Mainframes, SQL Server.
• Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
• Involved in job scheduling using Autosys.

Confidential

Lead ETL/ DataStage Developer

Hardware/Software Data Stage 7.5 (Parallel Extender), Oracle 8i, DB2, Sybase, SQL Server, Control-M, Erwin 4.0, Windows Visio, UNIX, Windows-XP.

Responsibilities

• Involved in technical leadership in the analysis, decision-making, design, and support phases of implementation of computer applications and network hardware and infrastructure, operating systems, databases and enterprise-wide business applications.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Extracted, rectified, cleansed and loaded data from flat files, using shell scripts and different stages into different databases...
• Migrated development mappings as well as hot fixes them in production environment.
• Performed an impact analysis on ETL jobs, before the jobs migrated in Datastage 7.5.3 version.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and to dynamically distribute to all available nodes to achieve best Job performance.
• Involved in raising an incident, after the batch monitoring done by an offshore team.
• Involved in the migration of DataStage jobs from development to production environment.

Confidential

ETL /DataStage Developer

Hardware/Software IBM Infosphere Information Server 8.1 (DataStage, Information Analyzer, MetaStage, Quality Stage), SQL Server 2005, Oracle 10g, Sun Solaris UNIX, Windows XP, IBM DB2, Autosys 3.0.

Responsibilities

• Involved in status meetings, and interacted with the Business Analyst to get the business rules.
• Migrated Outbound Data Feeds from SQL Server as source to Oracle as destination.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes when necessary.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Extracted data from text files, using FTP Stage and loaded into different databases.
• Migrated the pharma data structure sales to a target data bases.
• Designed Parallel jobs using various stages like join, merge, remove duplicates, filter, dataset, lookup file set, modify, aggregator and funnel stages.
• Created the data models for sales structures.
• As per the data volume, presented the size requirements and partitioning requirements for ODS tables in Oracle.
• Developed the customized routines and functions for better job performance.
• Used Autosys to schedule the DataStage ETL batch jobs on a daily, weekly and monthly

Confidential

ETL /DataStage Developer

Hardware/Software: Datastage 7.5.2(Designer, Director, Manager, Parallel Extender), Oracle 10g, DataStage BASIC, HP UNIX, MS Access, XML files, Erwin 7.0, Windows XP, Crontab.

Responsibilities:

• Interacted with source system users and business users to get business requirements.
• Modeled the Star schema data marts by identifying the fact and dimension tables using ERwin data modeling tool.
• Created DataStage jobs to extract, transform and load data into data marts according to the required provision from various sources like legacy systems, RDBMS, flat files.
• Developed Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector, XML.
• Worked with IBM support to solve critical DataStage issues.
• Used version control tools like Version Management (Clear Case and Quest) and DataStage Version Control.
• Defined constraints, stage variables and derivations in a transformer.
• Performed data manipulation using Basic functions and DataStage transforms.
• Used FTP stage to fetch the data and to deliver the data to target Database.
• Extensively used DataStage Manager, Designer, Administrator and Director for creating and implementing jobs.
• Extensively worked on error handling, cleansing of data, creating lookup files and performing lookups for faster access of data.
• Used Dynamic RDBMS stage to pull the data from source.
• Used DataStage Manager to import the Metadata from sources and targets.
• Involved in creating technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.