Shobhit Jauhari Miamisburg, OH

Telephone: 937-***-****

ETL Consultant Email: acoj0a@r.postjobfree.com

PROFILE

• Has excellent experience in ETL IBM DATASTAGE technology of 7.2 Years and during this worked in multiple roles

which comprise of Development, Design, Testing, and Solution providing and making Best practice standards in ETL

area.

• Result driven and goal oriented professional with superb skills and 7 years of successful experience in Data

Warehouse and development with Infosys Limited

• Talent for proactively identifying and resolving problems, maximizing productivity, and delivering exceptional results.

• Deep understanding of Information Technology Software Development Life Cycle (SDLC).

• Proficient in developing Datastage Jobs for the ETL functionality for complex requirements in projects.

• Overcome complex business challenges and make high stakes decisions using experience backed judgment, strong

work ethic, and irreproachable integrity. Respected as a proponent of empowerment and accountability.

• Exceptional analytical and critical thinking skills with excellent ability to produce outstanding results.

• Extensive experience in Design and Development of ETL methodology for supporting Data Transformations &

Processing using Datastage.

• Easily adapt to any working environment while maintaining professionalism and high quality performance.

• Dynamic and self motivated leader with ability to train, coach, and motivate team members.

• Wide experience in extracting data from Teradata, Netezza, Oracle, Sql server, Flat Files, XML’s Files and loading data

to OLAP systems.

• Excel at Debugging, Optimizing, and Performance Tuning of Datastage jobs developed code.

• Proven ability to manage complex situations in a diplomatic manner.

• Well convergent in Star Schema modeling, Fact and Dimension tables, Physical and Logical data modeling.

• Involvement in the Upgrade of Datastage 8.0 to 8.5

• Implemented QS Address Verification interface version upgrade 8 to 10.

• 3.5 years of experience in IBM Datastage Administrator. Maintained and managed 10 Datastage Server.

Performed patches and upgrades in the Server.

• Single point of contact with IBM, for technical issues faced by users.

• About 3.5 years’ experience of working in USA and in Onsite Offshore working model.

• Excellent in Job Scheduling tool planning and developing Configuring Mainframe OPC applications and JCL’s.

• Provided 2 Days Training on Datastage at client location and 5 days training to Infosys colleagues of 40 members

group.

• Have experience in developing DS Web Services and managing them.

• Performed Disaster recovery for DS environment during the DR testing at client location, happens twice a year

• Well aware of DS admin tasks : Creation of users, making new DS projects, providing different access to the Users,

handling DS server Unix directory.

• Developed DS Project backup script using batch/perl script and scheduled it through Mainframe OPC.

AREAS OF EXPERTISE

• ETL Tool – Datastage 8.x, Informatica

• CRM BI Tool – OBIEE 10g (have 5 Months experience)

• Scheduling functionality–Mainframe OPC and JCL, DAC 10.1.3.4 Tool

• Query Languages – SQL

• DBMS – Oracle 10g, Teradata v13, MSSQL 2005, Netezza

• RDBMS Utilities – Oracle SQL Developer, SQL Assistant Teradata, Microsoft SQL Server

PROFESSIONAL DEVELOPMENT

CERTIFICATIONS

Datastage Certification – Internal to Infosys

Quality Process Certification – Internal to Infosys

Basics of OSS BSS– Internal to Infosys

ORA BI (OBIEE) – Internal to Infosys

PROFESSIONAL EXPERIENCE

Project: EBPS Development Project

Software: Datastage 8.0 and 8.5, Oracle 10g, MSSQL Server 2005, Teradata

Duration: 1.5 year (Sep, 2013 to till date)

Client: LexisNexis located at Miamisburg, USA

This project involved Developing Datastage jobs, discussion the requirement with client and coordination with multiple dependent

teams to develop the jobs. Performing data migration task through DS jobs for 5 systems.

DUTIES AND RESPONSIBILITIES

• Carry out complex business requirements analysis, review and design DS Jobs to meet the requirements.

• Designing new DS job and providing solution to design

• Discussion with client and dependent team on the required functionality to be achieved by DS jobs.

• Configuring the DS job scheduling part and ensuring proper handover/dependency with other DS sequencer and

upstream/downstream systems.

• System, Performance, Integration and User Acceptance Testing

Project: Datastage Administrator And Team Lead

Software: Datastage 8.0 and 8.5, Oracle 10g, MSSQL Server 2005, Teradata, Mainframe OPC,WS FTP Pro

Duration: 3.5 years (Aug, 2011 to till date)

Client: LexisNexis located at Miamisburg, USA

This project involved Supporting Datastage Application for a cluster, handling dependency with the client upstream and

downstream systems. Performing Datastage Administration tasks and managing 10 DS Servers.

DUTIES AND RESPONSIBILITIES

• Maintenance and supporting of about 10 DS Servers in the role of Datastage Administrator.

• Performed patches Fix pack 2 and other fix patches on DS 8.5 Servers and Clients.

• Point of Contact for communication with IBM for Datastage related issues.

• Performed Upgrade of AVI 8 to AVI 10 in all Servers and existing DS jobs. Performed testing on new version and

worked with IBM to resolve the identified on the issues. Conducted UAT with End users and dependent team and got

the sign off.

• Developed and Supported Real time DS jobs which are used for Address verification across multiple clusters.

• Maintenance and Enhancement of Datastage applications which are scheduled through Mainframe.

• Resolving issues in case of failure and ensuring its completion with the SLA, which involves coordination with

dependent teams and client personals.

• Performing the Root cause analysis on the Critical issues and fixing them to avoid repetition of issues.

• Resolving severity 1, 2 Tickets within defined SLA’s.

• Carry out business requirements review and helping in designing new DS jobs for other teams.

• Part of Centre of Excellence team for Datastage at client – helping in collating information from other DS clusters,

setting up DS coding and scheduling standards etc.

• Oversaw multiple enhancement projects as Onsite coordinator by handling different activities as requirement gathering,

design review with business users, code review, conducting UAT session for users, and completing the successful UAT

for project, deployment of project code.

• Handling and supporting High Availablity (HA) environment of Datastage

• ClearCase integration with Datastage

Project: BI Enhancement project

Software: OBIEE 10g, Oracle 10g, Informatica 8.1.1, DAC

Duration: 5 Months (March 2011 – July 2011)

Client: LexisNexis located at Miamisburg, USA

This project involved support and change work in the implemented BI Apps module for Marketing Management for client.

DUTIES AND RESPONSIBILITIES

• Enablement of data elements to the business users for reporting in OBIEE 10g.

• Carry out business requirements review and design on various reports to build in OBIEE 10g.

• Design and Development of ETL Jobs in Informatica and implementing the corresponding DAC Task in the existing

execution plan.

Project: Datastage Migration Project & DS Project Backup Automation

Software: Datastage 8.0, MSSQL Server 2005, Oracle 10 G

Publisher 10.1.3.4

Duration: 6 Months (Sept 2010 – Feb 2011)

Client: LexisNexis located at Miamisburg, USA

This project involved Enterprise Data warehouse Creation, Data migration from Legacy/Transactional systems to the Data

warehouse and Automation of DS project backup

DUTIES AND RESPONSIBILITIES

• Developing Datastage job for Legacy data migration

• Implementing Business logic for the different transformation rules to be implemented.

• Coordination with different teams for data correction, cleansing functions.

• Developed Datastage project backup script in Windows server and scheduled it through the OPC scheduler to run

daily/weekly. It also updates the backup success/failure report in a text file for the history of backups with date/time,

• Auto cleanup of backups which are more than 3 weeks old as per requirement.

• Also developed script for rollback the backups taken when needed.

Project: Enterprise Customer MAster

Software: Datastage 8.0, MSSQL Server 2000, Oracle 10g 8.0, Mainframe OPC, Oracle SQL developer, WS FTP

Pro, Putty

Duration: 14 Months (July 2009 – August 2010)

Client: LexisNexis located at Miamisburg, USA

This project involved different Legacy source systems to establish the party database model. The major objective of this project is to

deploy party based data model that will serve as the basis for the ECM data model. It provides the flexibility and scalability needed

to meet enterprise customer data management requirements

DUTIES AND RESPONSIBILITIES

• Responsibilities included requirement gathering, designing, development, unit testing, system testing and warranty

support for the ETL jobs using DataStage V 8.0.

• Lead development of 3 out of 7 Source systems DS job development and also developed Common jobs using data from

staging area data of these source system to the publishing layer, which includes Data cleansing, Address Verification &

Standardization, Perl scripting, primary key generation using CRC process and rejecting orphan child entity data.

• Additional responsibilities were to enhance competency knowledge of the team and increase their knowledge base in

DataStage.

Project: DS Job Development Project

Software: Datastage 8.0, Oracle 10g, Netezza, Putty

Duration: 10 Month (September 2008 – June 2009)

Client: COLT located in London, UK

The Project involves the automation of Daily and Monthly data loads in the target Netezza Data warehouse. There were Daily

Dimension files feed and Weekly and monthly Unbilled and Billed Transaction data received from the source database. This data

was used to generate the New Generation Reports using Business Object tool which enables Client for Business Intelligence (BI)

and adding value to the business

DUTIES AND RESPONSIBILITIES

• Co ordination with Designers to translate the requirements & coding ETL jobs in DataStage 8x, design activities

• Testing of the solution and Debugging.

• Worked for the development large volume of data for Charge Detail Records, Charge Transaction Records & Voice

Traffic Records modules in Telecom industry.

Ds Job Performance Tuning.

• Additional responsibilities included the environment setup and resolving the environment issues faced by the team.

Project: NGB Migration Project

Software: Datastage 8.0, Oracle 10g, Netezza, Putty

Duration: 7 Month (Jan 2008 – August 2008)

Client: COLT located in London, UK

Client has its retail system in and it was running using PL/SQL written procedures. In this project these PL/SQL procedures were

migrated to the DataStage ETL jobs and were automated for the Daily data load to the Netezza Database from Oracle Database.

DUTIES AND RESPONSIBILITIES

• Conversion of the PL/SQL procedures in the DS jobs

• Detailed Design Documentation, Development, Unit testing, and Integration testing of these Jobs

• Performance Tuning of these jobs

Project: Infosys Training

Software: Datastage and BI tool Training

Duration: About 3 Months (Nov 2007 Jan 2008)

Undergone Training in Data warehousing, Basics of Datastage and BI (OBIEE) tool

DUTIES AND RESPONSIBILITIES

• Undergone training for 2 months on Data warehousing concepts, ETL concepts, Datastage tool and BI (OBIEE) tool

• Cleared the exams on these Training. Worked and developed few sample projects on Datastage coding.

ACADEMIC QUALIFICATIONS

Qualifications Year Institute University/Board Percentage

Bachelor of Technology Uttar

Institute of Integral

(Information 2007 Pradesh Technical

Technology 71.82 %

Technology) University

Contact this candidate