SUMMARY

• Have 16+ years of ETL experience in development, testing, documentation and production support using IBM DataStage 11.7,11.5,9.1,8.x/7.x., Information Analyzer and SAP BODS
• Worked on all phases of data warehouse project cycle from requirements gathering, ETL Development, testing, warranty and production support.
• Worked on ETL tools like DataStage and SAP BODS and certified in DataStage v8.5.
• Worked on DataStage information analyzer for data quality assessment and profiling
• Worked on Data modeling using Erwin
• Worked on AWS Athena and Sales Force
• Worked on ETL version migration projects (DataStage versions 7.5 to 8 and 8.5 to 11.7)
• Worked on database conversion projects (DB2 to Teradata)
• Worked on both agile and waterfall project methodologies
• Hands on experience in developing Unix, PL/SQL, SQL scripting and XML
• Hands on experience on mainframe and MF scheduling
• Worked on ETL Data Hub and Info center for implementing Guidewire policy center, billing center, claims center and contact manager.
• Have hands on experience in creating mapping, low level and high - level detailed design documents. Have solid exposure in overall SDLC.
• Worked within demanding project schedules and environments, have excellent analytical and problem-solving skills and a motivated team player.

TECHNICAL SKILLS

ETL Tools: DataStage 7.5/8.0/8.5/9.1/11.5/11.7 , SAP BODS 3/4.0, Talend

Databases: Teradata, DB2, Oracle, SQL Server, Netezza, AWS Athena

Programming: SQL, Shell Scripting, PL/SQL, XML

Tools: RTC, Toad, HPQC, Message way Server, Erwin

Environment: Unix, Linux

Scheduling Tools: Control - M, AutoSys, Mainframe

Data Quality: DataStage Information Analyzer 11.5

PROFESSIONAL EXPERIENCE

Confidential

Senior DataStage Developer and Lead

Responsibilities:

• Created High Level and Low level detailed design document of the ETL Design.
• Involved in DataStage Admin by creating and setting up Projects and users
• Involved in Production bug fixes and Production support
• Updated the data marts both fact and dimension tables using DataStage
• Worked with business teams for requirement gathering and create the mapping document for the ETL Development.
• Created ETL jobs to read data from AWS Athena, Salesforce and load data into Staging tables
• Involved in Unit Testing and System Integration Testing
• Create Deployment Checklist and Implementation plan as part of the Code deployment

Technical Environment:: DataStage 11.7, AWS Athena, Salesforce, Linux, SQL Server

Confidential

DataStage Developer and Lead

Responsibilities:

• Created architecture review document which includes creating logical data model, physical data model and reviewed along with the vendors architecture document
• Created detailed design document and review the vendors detailed designed document
• Reviewed the design and development of the vendor team including the RFM changes in the DataHub and Info center
• Involved from the initial stages of requirement walkthroughs, conceptual and physical data modeling and creating design walkthroughs
• Involved in sessions with the functional team to understand the RFM and NAICS implementation to the existing DW system.
• Conducted brainstorming sessions within the team to analyze the impact of the functional and Guidewire table changes
• Performed sensitive analysis of the impacted tables/columns in the existing system.
• Updated the data marts both fact and dimension tables
• Worked with business teams for requirement gathering and create the mapping document for the ETL Development.
• Executed the SAP BODS jobs for Datahub and Infocenter
• Created Users in the SAP BODS adminsrator console
• Developed ETL DataStage jobs to read and transform data from various legacy systems, Guidewire (PC, BC and CC), DataHub and load data into data warehouse
• Executed Unit test cases for development and supported the QA team with System Integration testing and business approval testing
• Worked on conversion of jobs from version DataStage 8.5 to 11.7
• Provided improvement ideas/actions that provide a material benefit for delivering better quality or improving productivity
• Co-ordinated with different teams and ensure the projects are 100% compliant with the process.

Technical Environment: DataStage 11.7/9.2, SAP BODS, Linux, SQL Server, Oracle, DB2, ERWIN, BIT Bucket, HPQC, Visio, Mainframe

Confidential

Senior DataStage Information Analyzer/Developer

Responsibilities:

• Designed and developed DataStage jobs in Version 11.5
• Created data quality rules and rule definitions in DataStage Information analyzer
• Interacted with end user community to understand the business requirements and in identifying data sources.
• Worked on creating mapping document for the development.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing.
• Participated in daily scrum meetings as part of agile methodology
• Coordinated with team members and administer all onsite and offshore work packages.
• Created tasks in Jira as per the scrum process

Technical Environment:: DataStage 11.5, Information Analyzer, UNIX, HDFS, Oracle

Confidential

Senior DataStage Technical Lead

Responsibilities:

• Designed and developed DataStage jobs in Version 9.1
• Performed unit testing of ETL and related components (mainframe job, Unix scripts and loading database)
• Worked on multiple projects (loyalty, EDW, freight management) at the same time
• Read data from mainframe file and load into Oracle/Netezza database
• Worked on Unix Shell scripting
• Worked independently in end to end implementation (requirement gathering to warranty support)
• Transferred files to different vendors using MessageWay Server
• Scheduled/Triggered the jobs using mainframe scheduling
• Worked on change request process, creation and implementation of the C.R
• Created detailed design documents for the C.R implementation
• Created design documentation for the developed jobs

Technical Environment: DataStage 9.1, Netezza, UNIX, Mainframe

Confidential

DataStage and Testing Lead

Responsibilities:

• Involved in data migration from legacy systems to Guidewire policy and billing centers
• Developed DataStage jobs to read and transform data from various legacy systems
• Worked on SQL scripting and DataStage job design and development
• Involved in testing of the data for data marts and reports of Guidewire policy center, billing center, claims center and contact manager
• Worked with business teams for requirement gathering and performed end to end defect fixes - analysis, build, test and delivery role
• Provided improvement ideas/actions that provide a material benefit for delivering better quality or improving productivity
• Communicating between the onshore and offshore teams
• Implementation of best practices to Improve the client system
• Trained the offshore team with the client system
• Co-ordinated with different teams and ensure the projects are 100% compliant with the process.
• Provided KT for the BAT testing team with respect to the Guidewire data model

Technical Environment: DataStage 9.1, SQL Server, Oracle, DB2, UNIX, Mainframe, Guidewire