SUMMARY

• 12+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• 9+ years of specialized work experience on Data warehousing technologies - Design, Development and Testing using ETL and Data Migration life cycle using IBM DataStage 8.x/7.x (Datastage Designer, Datastage Manager, Datastage Director).
• Certified on IBM Products IBM® InfoSphere DataStage 8.1 & 7.5.
• 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 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 Robot job & IBM Tivoli workload scheduler.
• Expert in working on systems like UNIX AIX. Expertise in UNIX shell scripting using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers.
• Experienceinproject 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: IBM® InfoSphere DataStage 8.1, 8.5 & 8.7, Ascential DataStage 7.5IBM® WebSphere MQ, Informatica 7.1

Development Tools: IBM InfoSphere suit, IBM Rational series, DataStage SAP Packs, IBM Tivoli Workload Scheduler, Robot job Scheduler

Functional Modules: Distribution/Order Management, Data Integration

RDBMS: Oracle 11g, IBM® DB2 8.1 & 10.1

Languages: Visual Basic 5, C, Unix Basic & UNIX Sell Scripting

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

Processes: IBM’s QMS (Quality Management System), RQM, Clear Quest, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential - Eagan, MN

Sr. DataStage Consultant

Responsibilities:

• As a Data Integration Consultant participate in data analysis, estimation, planning, design, development, Implementation and support Data Integration project using IBM InfoSphere DataStage 8.7.
• Involved in Agile methodology 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 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: IBM® 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 IBM InfoSphere DataStage 8.1 & 8.5.
• Guiding and assigning team members on the development activities.
• Performed a lead rolein 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: IBM® InfoSphere DataStage 8.5, DataStage Parallel Extender, Datastage Designer, Datastage Director, Oracle 11g, UNIX, IBM Tivoli Workload Scheduler

Confidential, Raleigh, NC

Sr. DataStage Consultant/Lead

Responsibilities:

• Involved as primary on-site ETL Developer during the data analysis, estimation, planning, design, development, Implement and support Data Integration project using IBM 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 & IBM’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: IBM® InfoSphere DataStage 8.1 & 8.5, DataStage Parallel Extender, Datastage Designer, Datastage Director, IBM® MQ, IBM® DB2, IBM® AIX, IBM® Rational ClearCase, IBM® Rational ClearQuest, IBM® 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, 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 & IBM’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: IBM® InfoSphere DataStage 8.1, DataStage Parallel Extender, Datastage Designer, Datastage Director, IBM® MQ, IBM® DB2, IBM® AIX, IBM® Rational ClearCase, IBM® Rational ClearQuest, IBM® 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

Confidential

DataStage Developer

Responsibilities:

• Contributed in development of two releases with using the tool DataStage 7.5.2 PX, XML spy, and DB2.
• Understanding all business rules and logic and creating Micro and Macro design.
• Designing & Developing the job as per the requirement.
• Ensure that development is performed as per requirements.
• Daily and Weekly updates with the team and senior position team leaders of the ongoing project and issues.
• Deploying it into the Production server to run in production, and provide production support for the released job.
• Work with QA team to create test scripts and scenarios for enhancement and customization of core product
• Communicate activities/progress to project managers, project leaders, business analysts and clients
• Develop implementation, test plans and work with clients to oversee the acceptance and dissemination process

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

Confidential

Informatica Developer

Responsibilities:

• Involved in Development activities for the whole project. Designed with the tool Informatica & the database with Oracle.
• Business rule validation process and design of documents.
• Creation of Unit test plan and specification & testing it with the rules specified.
• Client interaction for the weekly updates and specification gathering.
• Monitoring job issue and complex jobs.

Environment: Windows XP, UNIX, Informatica 7.1, Oracle 9i

Confidential

Informatica Developer

Responsibilities:

• Developed jobs or mappings using Informatica and with the supporting database oracle
• Developed complex jobs, and closely monitored for the errors.
• Unit test plan creation and testing them.
• Client and Team interaction for the process flow and improvement.
• Deployment to the testing & production environment.
• Continued support for production issues as third level production support specialist.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets

Environment: Windows XP, UNIX, Ascential DataStage 7.5, Informatica 7.1, Oracle 8i

Confidential

Informatica Developer

Responsibilities:

• Designed for all dimension table loading jobs.
• Developed customized solution for test data recording.
• Record checking and tracking error messages.

Environment: Windows XP, UNIX, Informatica 7.1, Oracle 8i