PROFESSIONAL SUMMARY:

• Over 7+ 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 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.
• Have hands on experience in design and development of complex datastage jobs, sequencers and Fast track, Metadata Workbench and Business Glossary.
• Have hands on experience in Auto sys and Control-M job schedulers.
• Experience in UNIX scripting, troubleshooting and file handling on the 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 the 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 that give a snapshot of the status of the 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 the 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 the files and NDM’ ing the 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 the job designing with the help of Metadata Management and Fasttrack Mapping specifications.
• Providing 24X7 productions supports for the 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.1

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 EXPERIENCE:

Confidential

Sr. Datastage developer

Responsibilities:

• Attended meetings with client and business teams to understand the requirement and prepared the low level design document, technical specification documents.
• Identified the impacts and created Data Mapping Sheets.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• 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 the 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 then schedule this 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 the jobs by interpreting performance statistics of the 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 the same in all environments Dev, CIT, SIT, UAT, Pre production and Production.
• Prepared the 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 the HP ALM to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.

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

Confidential, NC

Sr. Datastage Developer

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 the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• 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 the 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 then schedule this 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 the jobs by interpreting performance statistics of the 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 the HP ALM to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Prepared the 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, Microsoft Visio, IBM AIX 4.2/4.1, SQL Server, IBM DB2, ORACLE 11G, Autosys Scheduler, Unix, Windows, HP ALM

Confidential, WI

Sr. Datastage Developer

Responsibilities:

• Implemented Data Quality process which transforms the input fields into the data types used in the target database tables and also does basic checks on the data fields and reports the data errors
• Developed Parallel Jobs which loads Dimension Tables and maintained Surrogate key generation in multiple run.
• Developed Subject Area Jobs for performing all the transformations required in the data process for creating the load ready files.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions process.
• 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 the jobs.
• Created process flow diagrams using Microsoft VISIO.
• Documented the 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 Developer

Responsibilities:

• Studying the business requirement, preparing the impact analysis document.
• Prepared technical specification document, upon review of the solution developed the solution using Datastage jobs and sequencers.
• Used sequential file stage as the source for most of the source systems.
• Developed a file check process that checks the format, volume and date in the file decides whether the right file is being sent by the source and whether the right file is being loaded into the 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 the test cases, captured the results.
• Supported the SIT testing, UAT testing.
• Worked on packaging the code with the help of tortoise SVN version controlling tool and worked with respective teams to deploy the code.
• Supported the system post production and worked in co-ordination with the production support teams to resolve any issues.

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