PROFESSIONAL SUMMARY:

• Over 8+ years of ETL and Data Integration technical experience in IT Industry as a developer in System Analysis, Design, Development, Testing and Support of projects using Datastage 7.5/8.1/8.5/9.1 /11.3 in Banking, Retail and Insurance and Automobile verticals.
• Experience in Software Development Life Cycle - SDLC (Analysis, Design, Development and Testing), requirement gathering, client interaction, Use Case Design and understanding.
• Has hands on experience in design and development of complex datastage jobs, sequencers and Fast track, Metadata Workbench and Business Glossary.
• Has hands on experience in Auto sys and Control-M job schedulers.
• Experience in UNIX scripting, troubleshooting and file handling on teh UNIX system.
• Good hands on experience in RDBMS like Oracle, Netezza, SQL Server, Teradata and DB2. Working experience in data modeling and implementing stored procedures using PL/SQL. Extensive knowledge of writing complex queries using SQL. Working experience in DB2 cursors, triggers and stored procedures.
• Demonstrated work experience in using teh state of art Datastage Grid environments.
• Experience in Data Integration, EDW and Data Mart projects.
• Strong knowledge in OLAP and OLTP Systems, Dimensional modeling using Star schema and Snowflake schema.
• Demonstrated work experience in Mainframe to Datastage Migration projects.
• Experienced in designing and using several process tracking mechanisms and communication designs dat give a snapshot of teh status of teh jobs in an application/system.
• Worked on integrating data from sequential files, flat files, COBOL files and XML files.
• Experience in working closely with mainframe applications for teh ETL interactions.
• Prepared High Level design document, Low Level design document, Technical design document for various projects and good at Bug fixing, Code reviews, and Unit & System testing.
• Expertise in application development in various Datastage versions like 7.5/8.1/8.5/9.1
• Expertise in creating Data Mapping for various projects and applications.
• Experience in working in a Multi-Dimensional Warehouse projects.
• Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Experience in using Mainframe applications for browsing teh files and NDM’ ing teh files.
• Hands on Experience in working with BOXI for report generation.
• Good experience in working with HP ALM(QC)
• Good experience in designing metadata for all data moves and to re-use them during teh job designing with teh help of Metadata Management and Fasttrack Mapping specifications.
• Providing 24X7 productions supports for teh application stability.
• Quick learner and up-to-date with industry trends, Excellent written and oral communications, analytical and problem solving skills and good team player, Ability to work independently and well-organized.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Unix shell scripting, COBOL

ETL Tools: Datastage 7.5/8.1/8.5/9./11.3

Designer, Administrator, Director: Fast track, Metadata Workbench, Business Glossary

Databases: Oracle 10g, DB2, Teradata, SQL Server, Netezza, DB2

Software’s: TOAD for oracle, TOAD for DB2, WINSCP,MS SQL server 2008 Management Studio, SQL * PLUS, SQL Developer, Queryman, AQT for DB2, AQT for Oracle, MAINFRAMES

Other Tools used: Clear Case, Tortoise SVN Sub Version, HP ALM

Operating Systems: UNIX (AIX), LINUX, Windows 95/98/2000/XP/2003, MS-DOS.z/OS

Reporting Tools: BOXI R2

PROFESSIONAL SKILLS:

Confidential, Chicago, IL

Sr. Datastage Consultant

Responsibilities:

• Attended meetings with client and business teams to understand teh requirement and prepared teh low level design document, technical specification documents.
• Identified teh impacts and created Data Mapping Sheets.
• Active participation in decision making and QA meetings and regularly interacted with teh Business Analysts &development team to gain a better understanding of teh Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded teh data into teh IBM DB2 database.
• Involved in teh design, development of teh SQL and PL/SQL stored procedures, packages and triggers for teh ETL Datastage processes.
• Created jobs to read and write data into complex flat files, COBOL files, sequential files.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Datamart.
• Created Datastage 8.5 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity, Sequential File, CFF stage, Dataset, Terminator activity.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring teh resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created master jobs sequencers.
• Created shell script to run data stage jobs from UNIX and tan schedule dis script to run data stage jobs through scheduler called VERTIS which runs based on ILOG JRules.
• Coordinated with team members and administer all onsite and offshore work packages.
• Performed performance tuning of teh jobs by interpreting performance statistics of teh jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Prepared DDL’s for table creation, table modification, index changes. Tested and executed teh same in all environments Dev, CIT, SIT, UAT, Pre production and Production.
• Prepared teh DML’s for maintenance tables, reviewed, tested and executed them.
• Used Clear case and IBM Infoshpere Information Sever Manager for version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production.
• Used teh HP ALM to upload teh unit test cases and executed them. And to track any defects in teh project during different phases of testing, debugging, investigating and worked towards closure of teh defects.

Environment: IBM Web Sphere DataStage 11.3 Parallel Extender, IBM Infoshpere Information Sever Manager, Web Services, Clear case, Microsoft Visio, IBM AIX 4.2/4.1, SQL, PL/SQL, SQL Server, IBM DB2, Vertis, ilOG JRules, Unix, Windows, HP ALM

Confidential, Durham, NC

Sr. Datastage Consultant

Responsibilities:

• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared Fasttrack Mapping Specifications, created metadata layouts in Metadata Workbench and update Business Glossary.
• Prepared Data Mapping Document and Design teh ETL jobs based on teh DMD with required Tables in teh Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with teh Business Analysts &development team to gain a better understanding of teh Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded teh data into teh IBM DB2 database.
• Wrote SQL, PL/SQL, queries, stored procedures, triggers for implementing business rules and transformations.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse.
• Created Datastage 8.5 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Surrogate Key, Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring teh resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created master jobs sequencers.
• Also worked for different enhancements in FACT tables.
• Created shell script to run data stage jobs from UNIX and tan schedule dis script to run data stage jobs through scheduling tool Autosys using JIL’s.
• Coordinated with team members and administer all onsite and offshore work packages.
• Performed performance tuning of teh jobs by interpreting performance statistics of teh jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used teh HP ALM to upload teh unit test cases and executed them. And to track any defects in teh project during different phases of testing, debugging, investigating and worked towards closure of teh defects.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Prepared teh DML’s for maintenance tables, review, and test and execute them.
• Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production.

Environment: IBM Web Sphere DataStage 8.5 Parallel Extender, Grid environment, Fasttrack, Metadata Workbench, Business Glossary, Web Services, Quality Stage 8.5, SQL, PL/SQL, Microsoft Visio, IBM AIX 4.2/4.1, SQL Server, IBM DB2, ORACLE 11G, Autosys Scheduler, Unix, Windows, HP ALM

Confidential, Stevens Point, WI

Sr. Datastage Consultant

Responsibilities:-

• Implemented Data Quality process which transforms teh input fields into teh data types used in teh target database tables and also does basic checks on teh data fields and reports teh data errors
• Developed Parallel Jobs which loads Dimension Tables and maintained Surrogate key generation in multiple run.
• Developed Subject Area Jobs for performing all teh transformations required in teh data process for creating teh load ready files.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions process.
• SQL and PL/SQL procedures to transform data from staging to Data Warehouse Fact and dimensional tables.
• Familiar with import/export of DataStage Components (Jobs, DSRoutines, DSTransforms, and Table Definitions) between DataStage Projects, use of Dataset Management (DSM) utility and multiple jobs compile utility with use of Data Stage Director.
• Developing shell scripts to automate file manipulation and data loading procedures.
• Used Shared container for simplifying design and maintenance.
• Experienced in fine tuning, Trouble shooting, bug fixing, defect analysis in DataStage Jobs.
• Used error handler process Jobs to capture look up failure, duplicates and data type errors and these errors are captured to a error log detail table.
• Used DB2/UDB stage to load data into mart tables and DB2 bulkload stage to load data into staging tables
• Used Parallel Extender Development/Debugging stages like Row generator, Column Generator, Head, Tail and Peek
• Used Hashed file Datastage as a table based on a single key.
• Extensively dealt with Performance tuning of teh jobs.
• Created process flow diagrams using Microsoft VISIO.
• Documented teh development process and performed knowledge transfer to Business Intelligence team.

Environment: DataStage/ QualityStage 8.0 (IBM Websphere Datastage and Quality Stage Designer, Director, Administrator), DB2 UDB 9.2,SQL Server 2000, Linux 10, SQL, PL/SQL, UNIX Shell Scripting, Microsoft Visio, DB2 Visualizer, MS SQL server, Mainframe, COBOL .

Confidential

Datastage Consultant

Responsibilities:

• Studying teh business requirement, preparing teh impact analysis document.
• Prepared technical specification document, upon review of teh solution developed teh solution using Datastage jobs and sequencers.
• Used sequential file stage as teh source for most of teh source systems.
• Developed a file check process dat checks teh format, volume and date in teh file decides whether teh right file is being sent by teh source and whether teh right file is being loaded into teh database.
• Used aggregator, look up, join, merge, dataset, transformer, sequencer, sequential file DB2 bulk load, hashed file stage, surrogate key generator.
• Created DDL statements for new tables, changes to table structure, index changes, and creation of triggers and stored procedures.
• Prepared unit test cases and test plans.
• Executed teh test cases, captured teh results.
• Supported teh SIT testing, UAT testing.
• Worked on packaging teh code with teh help of tortoise SVN version controlling tool and worked with respective teams to deploy teh code.
• Supported teh system post production and worked in co-ordination with teh production support teams to resolve any issues.

Environment: DataStage 8.1 (Designer, Director, Manager, Administrator) Enterprise Edition, SQL Server 2005, SQL, PL/SQL, IBM DB2, AS/400, ERwin4.0, MS Visio 2000.