EXPERIENCE SUMMARY:

• Over 10.5+ years of work experience as ETL Datastage Designer/Developer, Data Warehouse Designer, System Analyst, BI Reports Developer, Solution Architect and Team Lead.
• My key responsibilities involve Requirements Gathering, System Analysis, Data Mapping, High Level and Low - Level Design, Code Development, Testing, Quality assurance and Code maintenance & support activities.
• Hands-on experience with a strong knowledge base in Extraction Transformation Loading (ETL) designs for Data Warehouses and real-time interfaces usingDataStageEE, UNIX Shell Scripting, DB2 Queries, SQL, Stored Procedure and Mainframe JCL.
• Responsibilities included as Technical Team Lead, Module Lead, Deployment and Release Manager and Solution Architect.
• Hands-on Experience in all levels of Software Development Life Cycle with comprehensive experience in both Waterfall and Agile project development methodology. Underwent Agile methodology training and evaluation by Ralph Hughes from Ceregenics, one of the pioneers and leaders in Agile Data Warehousing.
• Hands-on experience in creating real-time wave jobs, handling Message Queues (MQ) using IBM - WebSphere MQ Explorer, Distributed Transaction Stage (DTS), Change Data Capture (CDC), Slowly Changing Dimension (SCD), XML parsing and XML building using new XML stage in DataStage.
• Hands-on experience in handling different format of data sources and targets such as Flat Files, Variety of Databases, iSeries, Teradata, SAP - IDocs, Mainframe Complex Flat Files, XML and XSDs, MQ Messages.
• Hands-on Experience in Quality Assurance and Automation for Functional System Testing, Integration testing, User Acceptance testing, Performance testing and End to End reconciliation.

TECHNICAL SKILLS:

Operating Systems: Windows NT/200x Server/XP, z O/S, AIX UNIX.

ETL Tools: IBM InfoSphere DataStage and QualityStage Enterprise Edition V 7.1.1 till V 11.3 (Hands-On).

RDBMS: DB2, Oracle, PL/SQL, Aqua Data.

Business Areas: Data warehousing, ETL, BI Reporting,E-commerce, Retail Domain Knowledge, Confidential Domain Knowledge.

Software Development Methods: SDLC - Waterfall, Agile Methodology.

Other Tools/Language: Shell Scripting, Control- M, InfoSphere Data Replication V11.3, IBM Information Analyzer, Information server manager& Administrator, IBM - WebSphere MQ Explorer, Informatica Power Center V.10 (Beginner - Self-taught), Teradata, Putty, WinSCP, FileZilla, SAP - ABAP, Mainframe - JCL, C and C++, HP Quality Center, JIRA, Bugzilla, RALLY (Agile Project Manager),Altova XML Spy, RFHUTIL,Zuzena (Testing Automation Tool).

Reporting Tools: Information Builders - Webfocus (BI Reporting), Tableau (Beginner - Self-taught).

Data modeling: Erwin, IBM IIW data model.

PROFESSIONAL EXPERIENCE:

Confidential

Sr.ETL Designer/Developer, Team Lead

Responsibilities:

• Requirement gathering and understating business requirement to derive mapping rules for transforming data.
• Designing a robust framework for data transformation from source to Confidential system.
• Developing DataStage ETL jobs to extract the source data from tables/Folder location and load it into the data warehouse after cleansing, transforming and integrating the business data as required.
• Transformation includes converting the semantics of new source data from new front-end to match and load it into existing legacy data warehouse tables applying necessary transformations without impacting the views of end business user to carryout business as usual.
• Creating source to Confidential mapping and job design documents.
• Creating and configuring CDC subscription using InfoSphere Data Replication V11.3
• Preparing the Unit test plan, Unit test cases and test the code developed.
• Providing support and immediate resolution to issues raised by testing team after testing the code and performing Route Cause Analysis (RCA) and document the same for future reference.
• Preparing lessons learnt, Proof of Concept and Job description manuals for future reference and maintenance.
• Monitoring data load in production and fixing any issues on the spot and updating the status to stake holders ensuring uninterrupted business as usual.

Tool:

• IBM InfoSphere Pack 11.3
• InfoSphere Data Replication V11.3
• IBM Information Analyzer
• Information Server manager and Administrator
• UNIX
• DB2
• PL-SQL

Solution Environment: ETL tool - IBM WebSphere DataStage & Quality stage EE V11.3, DB2, UNIX

Confidential

ETL Designer/Developer, Stream Lead, Deployment Manager

Responsibilities:

• Analyze and understand 40+ years of claims data from start of business - till date and understand business process changes over time.
• Data profiling using IBM InfoSphere Information Analyzer 9.1.
• Reviewing mapping documents by working closely with business users and System analyst.
• Developing DataStage ETL jobs to effectively transform large volumes of legacy data to new business format which involves complex transformation rules and high-performance requirements.
• Coding Shell scripts, DB2 stored procedures and Routines as required to fulfill the requirements.
• Preparing complex SQL queries to validate the data transformed and to reconcile and match transformed data with legacy data.
• Designing and developing Audit and Error Handling framework.
• Preparing the Unit test plan and Unit test cases for transformation identified and test the jobs developed.
• Automating testing using Automation toll Zuzena for regression testing.
• Performing code deployment and version management using IBM Information Server Manager.
• Design and develop dependency and schedule jobs using Control- M.
• Preparing Implementation Plan, Control-M schedule sheet, Components tracker and other required documentations.
• Demo the data and reconciliation reports to business users and obtain Sign-off.
• Perform Peer-Review on code and deliverables by team members.
• Track and report project status using Agile Project manager - Rally.
• Conducting Story Pointing Conference and Sprint end retrospective in the absence of SCRUM Master.
• Attend daily SCRUM and report progress.
• End-to-End ownership/testing support of all jobs, scripts and other components delivered.

Tool:

• IBM Infosphere Pack 9.1.2,
• IBM Information Analyzer,
• Information Server manager and Administrator,
• IBM Fast Track,
• Putty, FileZilla,
• JIRA, RALLY (Agile Project Manager),
• Zuzena (Automated Testing).

Solution Environment: ETL tool - IBM WebSphere DataStage & Quality stage EE V9.1.2, DB2, UNIX, Control -M.

Confidential

ELT Designer/Developer

Responsibilities:

• Gathering Requirements by conducting discussion with Business Users and SMEs.
• Prepare mapping document using IBM Fastrack.
• Analyze and Review the requirement document and mapping document and prepare effective ETL design.
• Developing DataStage ETL jobs using MQ Stage, XML Parser, DTS stage and Wave concept to read XML/Flat File from source queue and transform as per requirement and load it into Confidential EDW IIW Data Model.
• ETL jobs to Transform data and load Dimension and Fact tables in EDW.
• Analyze XML using Altova XML spy and create XSD.
• Implementing IBM-IIW Confidential EDW data model and Stone Soup ETL development framework patterns for ETL development.
• Designing and developing Audit and Error Handling framework.
• Preparing Unit Test Plan and Unit test cases for transformation rules developed and execute the same.
• Track and report project status using Agile Project manager - Rally.
• Story-pointing and estimating identified tasks for the Sprint.
• Design and develop dependency and schedule jobs using Control- M.
• Attend daily SCRUM and report progress.
• Integration, System and performance testing support by fixing bugs and fine tuning the code based on test results.

Tool: InfoSphere Pack 8.7, DataStage XML and DTS Stages, Rally - Agile Project Manager, IBM Fast Track, Putty, WINSCP, HP Quality Center, FileZilla, Altova XML spy, RFHUTIL.

Solution Environment: ETL tool - IBM WebSphere DataStage EE V8.7, DB2, UNIX, Control-M.

Confidential

Solution Architect, ETL Designer, Team Lead (Technical) and Onsite Coordinator

Responsibilities:

• Requirement Gathering by organizing meeting and workshops with business users.
• Complete understanding of current Amazon E-commerce business process and in-future expected WCS (WebSphere Commerce suit) business knowledge.
• Preparing High Level Design (HLD).
• Analysis, Review the requirement document and Prepared System analysis and impact document.
• Prepare low level design document (LLD).
• Preparing Functional and Technical Mapping documents.
• Designing efficient ETL design and Developing DataStage ETL jobs for identified requirements and mapping rules.
• Preparing the Unit test plan and cases for identified transformation rules.
• Co-ordination with offshore team to explain the requirements, provide ETL design and review the completed code to ensure quality of the deliverables.
• During the time at working from offshore, lead a team of over 7 associates and delivered the project with good quality without missing any deadlines.
• Preparing time and effort Estimations for identified components and preparing estimation sheets.
• Ensure code quality and maintain versioning using SVN tool.
• Create job schedule using Control-M.
• Preparing Operation Support Manual (OSM) to guide support team for trouble-shooting the delivered code.
• Track the project activities using IPMS, Delta Tracker and report weekly status to Delivery Head.
• Resource and Effort estimation (both on-shore and off-shore)
• End-to-End ownership and warranty support of interfaces developed, during sustainment period.
• Conducting training sessions in E-commerce, Retail business process and DataStage to new members in the project and bringing them up to speed.

Tool: InfoSphere Pack 8.5, DataStage XML 8.5 Stage, Putty, WINSCP, Altova XML Spy, RFHUTIL, WebSphere MQ Explorer, HP Quality Center.

Solution Environment: ETL tool - IBM WebSphere DataStage EE V8, V8.5, DB2, UNIX, Control-M

Confidential

ETL Developer, Technical Lead

Responsibilities:

• Requirement gathering and business analysis by attending requirement gathering workshops.
• Developing DataStage ETL processes to extract the source data and load it into the DataHub data warehouse after cleansing, transforming and integrating the business data as required.
• Created source to Confidential mapping and job design documents from staging area to Data Warehouse.
• Developing DataStage jobs to integrate and aggregate all the sales data from all selling channels in M&S and load it into DB tables which in turn is used for BI reporting.
• Documentation of everyday activities, issues tackled, lessons learnt and Operational Manual for future reference by project team.
• Have prepared all Low-Level Design (LLD) documents, ETL design documents and User manuals for developed interfaces.
• Have efficiently used HP Quality centre by resolving all defects and providing Root Cause Analysis (RCA) after defect fix and closures.
• Track the project activities using Delta Tracker (A tool for time and effort logging) and report weekly status to Project Manager.

Tool: InfoSphere Pack 8.0, Putty, WINSCP, HP Quality Center, Delta Tracker.

Solution Environment: ETL tool - IBM WebSphere DataStage EE V8.0.1, DB2, UNIX, Control-M.

Confidential

ETL Developer, BI Reports Developer

Responsibilities:

• Developed ETL processes to extract the source data from tables and load it into the enterprise-wide data warehouse after cleansing, transforming and integrating with other relational data.
• Designed and developed jobs using DataStage Designer as per the mapping specifications using appropriate stages.
• Created source to Confidential mapping documents and job design documents from staging area to Data Warehouse.
• Documentation of everyday activities, issues faced, lessons learnt and Operational Manual for future reference for the project team.
• Have efficiently used HP Quality centre by resolving all defects and providing Root Cause Analysis (RCA) after defect fix and closures.
• Track the project activities using IPMS and report weekly status to Project Manager.
• Created BI reports using Webfocus - BI reporting tool.
• Have conducted training sessions for new resources on business process in project and DataStage.

Tool: RIP, InfoSphere Pack 8.0, Putty, WINSCP, Integrated Project Management System.

Solution Environment: ETL tool - IBM WebSphere DataStage EE V8.0, Aqua Data, Information Builders - Webfocus.

Confidential

Developer (ETL, SAP ABAP, Teradata and Mainframe)

Responsibilities:

• Developing ETL Jobs to extract the source data (CSV files, Tables, Mainframe files and SAP-IDocs) and transform it into required format (CSV files, Tables, Mainframe files and SAP-IDocs) after cleansing, transforming and integrating data as per business needs.
• Designing and developing jobs using DataStage Designer 7.5.1 as per the mapping specifications using appropriate stages and monitor job logs using DataStage Director.
• Developing Teradata scripts using MultiLoad, FastLoad and FastExport.
• Performing Unit test and document the results in Unit Test Result Document.
• Preparing ETL design documents and support document for all developed interfaces.
• Using HP Quality centre by resolving all defects and providing Root Cause Analysis (RCA) after defect fix and closures.
• Track project activities using IPMS (Integrated Project Management System) and report weekly status to Project Manager.
• Preparation of Unit and Assembly Test Plans and preparing test data for testing.
• Hands-on work experience in SAP-ABAP, Mainframe-COBOL, Teradata and Mainframe-JCL, have delivered modules in these technologies as and when needed.
• Ensuring accepted quality standards of all code and documents delivered.
• Have authored a “How to” documentation on usage of encoding and decoding techniques in Mainframe-JCL in KnowMax-TCS Knowledge sharing portal.

Tool: Mainframe - JCL, Putty, WINSCP, UNIX, Shell Script.

Solution Environment: ETL tool - IBM WebSphere DataStage EE V7.5, Oracle, SAP-ABAP, Teradata (MultiLoad, FastLoad, FastExport).