SUMMARY

• 9 years of experience in IT Industry in system Analysis, Design, Development and Maintenance various domains including Data Warehousing, ETL (DataStage), Oracle (SQL) and Windows environments.
• Over 8 years of experience in building Data Warehouse/Data Marts using IBM Infosphere Information Server/Ascential DataStage 11.5/9.1/8.5/8.1/8.0/7.5.
• Proficient in Software Development Life Cycle Methodology (SDLC) and Operational Data Store (ODS).
• Participating in high level and detailed analysis and design efforts focusing on Extract, Transform and Loading of data.
• Expertise in data warehousing concepts, ETL programming using IBM/Ascential DataStage
• (Designer, Director, Manager) Parallel jobs/Parallel Extender 7.x, Server jobs, Job Sequencers, Batch Jobs and other data warehouse lifecycle tasks such as data analysis, cleansing, transforming, debugging/testing, and data loading across source systems.
• Experience in working with large data warehouses, mapping and extracting data from /Oracle/Db2/
• Experience in Pipeline and Partitioning concepts.
• Experience in developing complex Jobs, Sequences and re - usable jobs/containers.
• Expert knowledge of performance tuning source, mapping, target and sessions.
• Assisting the Data Modeler/Data warehouse developer in reviewing staging, data warehouse and data mart modules for completeness and the ability to load.
• Good understanding of data modeling - star schema modeling, snowflake schema modeling, physical and logical data modeling, normalized forms, facts and dimension tables.
• Strong understanding of the principles of Datamart and Data ware House.
• Optimized the query performance with modification in SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
• Extensive experience in writing SQL scripts and UNIX scripts.
• Worked on Data Lineage and reconciliation data flows and rules.
• Experience Working with MS Office Suite (Word, Excel, Access and PowerPoint skills).
• Possess excellent communication and interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS:

Data Warehousing Tool: IBM Information server/DataStage 11.5/9.1/8.5/8.1/8.0/7.5

Databases: Oracle 9i/10g/11g/12c and Db2 v8.1\v9.1.0

Version Control: DataStage Version control tool (Subversion).

Languages: SQL, UNIX shell scripting

Operating Systems: Windows NT/2000/2003/XP

Data modeling tools: Erwin 4.1, Microsoft Visio

Database Tools: SQL * Plus, Information Analyzer, AQT, Azure

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. DataStage Developer

Responsibilities:

• Worked closely with Business analysts, Business users and stake holders to understand the requirements and to build the technical specifications.
• Developed DataStage parallel jobs to load data in to DB2 from Sequential Files.
• Used DataStage Designer for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating and loading data into target systems.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator, Difference Stage, Change Data Capture Stage, DB2 Enterprise, Oracle Enterprise.
• Created Master sequencers using User Variable Activity, Job Activity, Execute Command Stage, Start Loop
• Activity, End Loop Activity, Nested Condition, Exception Handler Stages
• Scheduled various ETL Batch processes using TWS scheduler.
• Performance tuning of ETL jobs.
• Involved in using Stage Variables to calculate the derived fields in target tables.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Created job sequences and schedules for automation.
• Responsible to migrate jobs from DEV to UAT and PROD and for end-to-end for all the environments testing.
• Responsible for Production On call Support during Migration event
• Worked on Business Data Analysis to match up the report that fed is expecting.
• Worked on (Version 1) to record tasks based on sprint planning.
• Worked on Axiom reporting tool to generate federal reports.
• Performed Business and Data level analysis to meet our business expectations.
• Worked on Datastage Code migration from 9.1 Version to 11.5 Version.
• Worked on Data Analysis and Data reconciliation process.
• Worked on Confluence tool to upload the production flow charts.
• Explored options on Alation tool to make Database updates.
• Worked on Mainframe tool to perform Data copy process (PROD TO TEST environment).

Environment: IBM Info sphere 11.5 (Administrator, Designer, Director, IIS Manager), Information Analyzer, DB2 9.1, Data Lineage and Reconciliation, TWS Scheduler, SQL, Windows NT, LINUX, Citrix, Alation, York, Grapevine, Axiom Reporting tool, Mainframe, Confluence tool, IDA Tool.

Confidential, Nashville, TN

Sr. DataStage Developer

Responsibilities:

• Participate in all stages of the development life cycle including requirement analysis, design,
• development testing and implementation.
• Involve in design and code reviews and extensive documentation of standards, best
• practices, and ETL Design.
• Project management planning document which define and encapsulate the component
• interfaces.
• Functional Requirement Document (FRD) on delivered functionality / code as required.
• Responsible for all activities related to the development, implementation, administration
• and support of ETL processes for large-scale data warehouses using IBM Information Server.
• Design ETL Code dealing with different data sources (Delimited Flat Files, fixed length file
• and Oracle SQL developer etc.) and load the data into target data sources by performing
• different kinds of transformations using IBM Information Server (Datastage).
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Worked on Data Quality Rule stage that is used to publish rules from Datastage Quality stage.
• Develop SQL queries to perform DDL, DML against the databases.
• Perform Unit Integration and System Testing.
• Developed test data and conducted performance testing on the developed modules.

Environment: IBM Information Server 11.5, IBM Import Export ManagerIBM DB2, Oracle SQL Developer, SQL server management, Azure, Putty, Autosys and Linux.

Confidential, Cincinnati, OH

Sr. DataStage Developer

Responsibilities:

• Worked closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Developed DataStage parallel jobs to load data in to DB2 from Sequential Files and COBOL Files.
• Used DataStage Designer for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating and loading data into target systems.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator, Difference Stage, Change Data Capture Stage, DB2 Enterprise, Oracle Enterprise.
• Scheduled various ETL Batch processes using TWS scheduler.
• Performance tuning of ETL jobs.
• Involved in using Stage Variables to calculate the derived fields in target tables.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Worked on shared containers.
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Created job sequences and schedules for automation.
• Responsible to migrate jobs from DEV to UAT, DR, PROD and for end-to-end for all the environments testing.
• Worked on (QC) Quality Center to record defects on it.

Environment: IBM Info sphere 11.5 (Administrator, Designer, Director, IIS Manager), Information Analyzer, DB2 9.1, Data Lineage and Reconciliation, TWS Scheduler, SQL, Windows NT, LINUX, Citrix.

Confidential, Newark, DE

DataStage Developer

Responsibilities:

• Worked with Business users to understand the requirements and to build the technical specifications.
• Developed DataStage parallel jobs to load data in to DB2 and Oracle from Sequential Files and COBOL Files.
• Used DataStage Designer for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating and loading data into target systems.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator, Change Data Capture Stage, DB2 Enterprise, Oracle Enterprise.
• Responsible to create source to target mappings (STT) from functional specifications and analyzing the required transforms.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Worked on Data Quality Rule stage that is used to publish rules from IA(Information Analyzer)
• Worked on shared containers.
• Scheduled various ETL Batch processes using CONTROL M.
• Performance tuning of ETL jobs.
• Exclusively worked on Information Analyzer on writing data quality rules.
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Created job sequences and schedules for automation.
• Responsible to migrate jobs from DEV to SIT, CIT, DR, TT, PROD A and PROD B and for end-to-end for all the 7 environments testing.
• Worked on (QC) Quality Center to record defects on it.

Environment: IBM Info sphere 9.1 (Administrator, Designer, Director), DB2 9.1, Oracle 11.0, SQL, LINUX, Control M, Citrix, Data Lineage and Reconciliation, Quality Center.

Confidential, Cranston, RI

DataStage Developer

Responsibilities:

• Analyzed the transactional data model and data elements. Interacted with business analyst, SME (subject matter experts) on day-to-day basis to create technical specifications for data conversion programs.
• Worked with different Sources such as Oracle, MS SQL Server and Excel, Flat files.
• Used DataStage Administrator to create Repository, User groups, Users and managed users by setting up their profiles and privileges.
• Created source table definitions in the DataStage repository by studying the data sources
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects using DataStage Manager.
• Worked on several parallel datastage components like Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Row Generator stages.
• Created Error files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Responsible to migrate code from SIT to QA and QA to PROD.
• Worked on Main Frames and CA7 for all the 3 SIT PROD and QA environments.
• Used DataStage debugger to troubleshoot jobs.
• Tuned the DataStage transformations and Datastage jobs to enhance their performance.
• Used the DataStage Director and its run-time engine to schedule and run the jobs, testing and debugging its components and monitoring the resulting executable versions on an ad-hoc or scheduled basis.
• Created job sequences to control the flow of jobs.
• Used Autosys for automating job execution.

Environment: IBM Info sphere 8.5 (Administrator, Designer, Director, IIS Manager), Information Analyzer, DB2 9.1, AutoSys, SQL, Windows NT, LINUX, Data Lineage and Reconciliation, Toad, Citrix.

Confidential, Charlotte, NC

Data Stage Developer

Responsibilities:

• Worked closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Documented data sources and transformation rules required populating and maintaining database content.
• Developed DataStage parallel jobs to load data in to DB2 from Sequential Files and COBOL Files.
• Used DataStage Designer for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating and loading data into target systems.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator, Difference Stage, Change Data Capture Stage, DB2 Enterprise, Oracle Enterprise.
• Responsible to create source to target mappings (STT) from functional specifications and analyzing the required transforms.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Created job sequences and schedules for automation.
• Responsible to migrate jobs from DEV to SIT and for end-to-end SIT testing.
• Involved in the development and implementation of ad-hoc reporting system using Business Objects.

Environment: IBM Info sphere 8.5 (Administrator, Designer, Director, IIS Manager), Information Analyzer, FastTrack 8.5, DB2 9.1, AutoSys, SQL, Windows NT, LINUX, Citrix.