SUMMARY:

• 16+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• 13+ years of specialized work experience on Data warehousing technologies - Design, Development and Testing using ETL and Data Migration life cycle using Confidential DataStage 11.x/8.x/7.x (Datastage Designer, Datastage Manager, Datastage Director).
• Certified on Confidential Products Confidential ® InfoSphere DataStage 8.1 & 7.5.
• Leading ETL Datastage programs/projects.
• Extensive experience with design, development, implement and support Data Integration & Business Intelligence - BI processes in ETL.
• Used Agile & Waterfall methodology for the process.
• Experienced in solution architecture designing for conversion projects.
• Experienced in end-to-end ETL application design and processes.
• Expert in designing DataStage Parallel Extender (PX) jobs using various processing stages, file stages, Database, Real time stages, Sequencers, etc.
• Experienced in Hierarchical, XML stages, MQ stage and SAP Packs.
• Proficient in Data analysis and translating business requirements to technical requirements.
• Excellent knowledge and experience in creating source to target mapping, in establishing transformation rules, and in the complete Software Development Life cycle (SDLC).
• Strong database skills & knowledge - experienced in Oracle & DB2, building SQL queries, fine tuning, Object Oriented Programming, development knowledge and analysis of relational databases.
• Experienced in Control-M, Robot job & Confidential Tivoli workload scheduler.
• Expert in working on systems like UNIX. Expertise in UNIX shell scripting using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers.
• Experience in project deliverables using structured methodology.
• Good in Client interaction and Documentation skills.
• Good in providing technical solutions to the business team.
• Executed software projects for HealthCare, Industrial, Telecom, Immigration Department and Retail industry
• Good communication skills, interpersonal skills, self-motivated, quick learner, a good team player.
• Extensive knowledge in Industrial Product’s master data Legacy applications.

TECHNICAL SKILLS:

ETL Tools: Confidential InfoSphere DataStage 11.7, 11.5, 9.1, 8.1, 8.5 & 8.7, Ascential DataStage 7.5IBM WebSphere MQ, Informatica 7.1

Development Tools: Confidential InfoSphere suit, Confidential Rational series, DataStage SAP Packs, Confidential Tivoli Workload Scheduler, Robot job Scheduler, Control-M

Functional Modules: Distribution/Order Management, Data Integration

RDBMS: MSSQL, Oracle 11g, Confidential DB2 11, 10 & 8

Languages: Python, Unix Basic & UNIX Sell Scripting

O/S: Windows NT/2000 Server, XP, UNIX

Processes: Confidential s QMS (Quality Management System), RQM, Clear Quest, Clear Case, HP Quality Center, Code Collaborator, JIRA, Github

WORK EXPERIENCE:

Confidential, Freeport, ME

Sr. DataStage Consultant

Responsibilities:

• Gathering requirements, data analysis, estimation, planning, design, development, Implementation and support Data Integration project using Confidential InfoSphere DataStage 11.7.
• Use Agile methodology for planning and implementation.
• Reviewing the Functional specification documents and mapping sheet.
• Creating Solution design based on the approved mapping document.
• Prepared Technical requirements definition, Modeling, Data Mapping Documents, Macro/Micro design documents and designed ETL jobs based on these documents.
• Active participation in decision making and Data Quality review meetings.
• Checking and analyzing the file format and mainframe table structure and taking decision on what process to implement.
• Developing DataStage jobs and sequencers to extract data from different sources systems like mainframe, flat file, etc.. and then load the data into standardized EP platform using various parallel stages that is used for further reporting.
• Used different stages to extract & load like., Hierarchical for JSON extract, Unstructured Data, Row & Column Generator, External Source, etc..
• Used the Hierarchical stage exclusively to Extract and transform the JSON files.
• Creating UNIX shell script to execute specific functions which are difficult to handle in DataStage and to automate various transformations, parameterization, file move, split, record check, reconcile, reporting, etc.
• Executing Python scripts to publish, load/delete into Google cloud env.
• Setting up Control M jobs to automate end to end flow by providing different timeframe window.
• Generating reports from source, intermediate stages and target table for analyzing the difference.
• Documenting unit test plans (UTPs) and testing it for the developed job.
• On completion of the DS job development and delivery of the code bundle using Datastage packages, walk through the team for code review in GitHub on the unit test reports and getting sign off for the project.
• Created Code migration document for the end-to-end ETL application design and processes that developed using structured methodology.
• Guide the Operation team for execution and provide job fixes when defects are encountered within given timeframe during migration cycles.
• Attend check point calls with the business teams in assessing the risk factors and change requirements based on the interim test results.

Environment: Confidential ® InfoSphere DataStage 11.7, DB2, MSSQL, Mainframe, Oracle 11g, UNIX, Control-M.

Confidential, Eagan, MN

Sr. DataStage Consultant/Lead

Responsibilities:

• As a Data Integration Consultant participate in data analysis, estimation, planning, design, development, Implementation and support Data Integration project using Confidential InfoSphere DataStage 8.7.
• Involved in Agile methodology planning and implementation.
• Reviewing the Functional specification documents and mapping sheet.
• Leading the GH ETL program and creating Solution design based on the approved mapping document.
• Prepared Technical requirements definition, Modeling, Data Mapping Documents, Macro/Micro design documents and designed ETL jobs based on these documents.
• Active participation in decision making and Data Quality review meetings.
• Checking and analyzing the file format and ODS table structure in DB2 and taking decision on what process to implement.
• Used DataStage as an ETL tool to extract data from different sources systems like DB2 db, flat file, etc.. and then loaded the data into standardized GH platform using various parallel stages that is used for further reporting.
• Created UNIX shell script to execute specific functions which are difficult to handle in DataStage. Also using scripts the process is automated for various transformations like, parameterization, xfm looping, file move, split, record check, scp, reconcile, reporting, etc.
• Created Robot job to automate the flow end to end by providing different timeframe window.
• Generating reports from source, intermediate stages and target table for analyzing the difference.
• Documenting unit test plans (UTPs) and testing it for the developed job.
• On completion of the DS job development and delivery of the code bundle, walk through to the team for the code review on the unit test reports and getting sign off for the project.
• Created Code migration document for the end-to-end ETL application design and processes that developed using structured methodology.
• Guide the Operation team for execution and provide job fixes when defects are encountered within given timeframe during migration cycles.
• Attend check point calls with the business teams in assessing the risk factors and change requirements based on the interim test results.

Environment: Confidential ® InfoSphere DataStage 8.7, DataStage Parallel Extender, Datastage Designer, Datastage Director, DB2 10.1, UNIX, Robot Job Scheduler

Confidential, Eden Prairie, MN

Sr. DataStage Developer

Responsibilities:

• Involved as Sr. ETL Developer during the data analysis, planning, design, development, Implement and support Data Integration project using Confidential InfoSphere DataStage 8.1 & 8.5.
• Guiding and assigning team members on the development activities.
• Performed a lead role in data warehousing projects.
• Reviewing the Functional specification documents and mapping sheet.
• Creating Solution design based on the approved mapping document.
• Prepared Data Mapping Documents, Macro design documents and designed ETL jobs based on these documents.
• Active participation in decision making and Data Quality review meetings.
• Checking and analyzing the file format and taking decision on what process to implement.
• Used DataStage as an ETL tool to extract data from different sources systems like File, HL7 ADT, Census, Oracle, etc and then loaded the data into standardized OCS platform using various parallel stages.
• Created UNIX shell script to execute specific functions which are difficult to handle in DataStage. Also using scripts the process is automated for various transformations like, file move, split, record check, scp, reconcile, reporting, etc.
• Created Tivoli workflow to automate the flow end to end by providing different timeframe window.
• Generating reports from source, intermediate stages and target table for analyzing the difference.
• Documenting unit test plans (UTPs) and testing it for the developed job.
• On completion of the DS job development and delivery of the code bundle, walk through the functional team on the unit test reports and getting sign off for the project.
• Guide the Operation team for execution and provide job fixes when defects are encountered within given timeframe during migration cycles.
• Attend check point calls with the business teams in assessing the risk factors and change requirements based on the interim test results.

Environment: Confidential ® InfoSphere DataStage 8.5, DataStage Parallel Extender, Datastage Designer, Datastage Director, Oracle 11g, UNIX, Confidential Tivoli Workload Scheduler

Confidential, Raleigh, NC

Sr. DataStage Lead

Responsibilities:

• Involved as primary on-site ETL Developer during the data analysis, estimation, planning, design, development, Implement and support Data Integration project using Confidential InfoSphere DataStage 8.1 & 8.5.
• Involved in analysis, Extraction, Transformation and Reconciliation of MDM (Master data Management) data.
• Reviewing the Functional specification documents and mapping sheet and coordinating the development team Confidential offshore.
• Creating Solution design based on the newly approved functional design documents.
• Prepared Data Mapping Documents, Macro design documents and designed ETL jobs based on these documents.
• Active participation in decision making and Data Quality review 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 different sources systems like File, DB2, etc and then loaded the data into SAP system using various parallel stages.
• Created UNIX shell script to execute specific functions which are difficult to handle in DataStage.
• Reconciliation of Master data from source, middleware and target Blue Harmony SAP systems. Creating solutions for re-processing the data for the failure records.
• Documenting unit test plans (UTPs) and testing it for the developed job.
• On completion of the DS job development and delivery of the code bundle; walk through the functional team on the unit test reports and getting sign off for the object.
• Created Code migration document/deliverables for the end-to-end ETL application design and processes that developed using structured methodology.
• Touch base with Software lab for any enhancement in tool with respect to Blue Harmony project & Confidential ’s market in whole.
• Guide the testing team for execution and provide job fixes when defects are encountered within given timeframe during data migration cycles.
• Attend check point calls with the business teams in assessing the risk factors and change requirements based on the interim test results.

Environment: Confidential ® InfoSphere DataStage 8.1 & 8.5, DataStage Parallel Extender, Datastage Designer, Datastage Director, Confidential ® MQ, Confidential ® DB2, Confidential ® AIX, Confidential ® Rational ClearCase, Confidential ® Rational ClearQuest, Confidential ® Quality Manager, UNIX

Confidential

Sr. DataStage Developer

Responsibilities:

• Understanding conversion design document and writing technical design documents.
• Communicating the requirements to the team and leading the team in developing jobs as per specification.
• Preparing Knowledge transfer documentation on the completed deliverables.
• Creating checklists for job standardization for the project.
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, DB2 connectors, SAP Pack - Bapi, IDOC, ABAP, MQ stage, XML Stage, FTP, Change Apply, Change data Capture CDC, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Surrogate Key, Aggregator, Transformer, Row Generator stages.
• Created UNIX Shell scripts and UNIX basic commands
• Reviewing the jobs developed by the team as per checklist.
• Reconciliation of Master data from source, middleware and target BH SAP systems.
• Trouble shooting the issue Confidential the time of test cycles and production release.
• Touch base with Software lab for any enhancement in tool with respect to Blue Harmony project & Confidential ’s market in whole.
• Support and facilitate the implementation and execution of Data Migration cycles and System Integration Test cycles by creating test plans, executing test cases, and fixing defects and finally in the execution of move to Production cycles for the conversion.
• Guide the testing team for execution and testing during data migration cycles.
• Participated in weekly status meetings to provide status of the conversion objects assigned.

Environment: Confidential ® InfoSphere DataStage 8.1, DataStage Parallel Extender, Datastage Designer, Datastage Director, Confidential ® MQ, Confidential ® DB2, Confidential ® AIX, Confidential ® Rational ClearCase, Confidential ® Rational ClearQuest, Confidential ® Quality Manager, UNIX

Confidential

DataStage Developer

Responsibilities:

• Responsible as a team member in delivering solution to customer in the Telecom sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Understanding all business rules and logic by interacting with client directly and getting all information related to the respective gateway and creating Design document.
• Responsible for Designing & Developing the job as per the requirement.
• Created UNIX Shell scripts and UNIX basic commands
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and testing that culminate in client acceptance of the results.
• Checking for error reports for the released jobs in System testing & UAT environment, and resolving it to run in a smother way. Re-solving & Re-designing the job if any error report created by them. After getting all approval state from ST & UAT then according to process and deadline going to the next step.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Keep on interacting with client for the best performance of the job developed.
• Key projects handled so far include AOTS, Calnet, ACMS

Environment: Windows XP, UNIX, Ascential DataStage 7.5 Server, Datastage Designer, Datastage Manager, Datastage Director, Oracle 9i