Project Data

NEERAJ KUMAR SHRIVASTAVA

E-Mail: ******.*****@**********.***; Mobile: +1-872-***-****

Total 10+ Years ETL Assignments (implementation/development/support 6.5+years in Abinitio and 3.8+years in Informatica) in Banking, Retail, Insurance and card services (Banking domain) with leading organizations and currently working full time with Capgemini in US on H1B visa.

Professional Profile

1.B.Tech (4-years Engineering Degree) with 10.0+ years of ETL assignments.

2.Significant exposure to maintain & executing product features, Data Warehousing concepts with emphasis on ETL and Life Cycle Development such as requirements understanding, designing, coding, UAT, SIT, supporting projects in testing phase and also after production implementation in warranty time period in Leading organizations Like Reliance Industries Ltd, Steria(Inda) Ltd, Coginizant and currently working in Capgemini America.

3.Good knowledge in design and Abinitio project automation using Express>It tool.

4.A keen communicator with excellent analytical and problem solving skills. Abilities to comprehend new technologies with ease.

Interest in Profile: I am looking for a role in ETL (Ab>Initio) design and development in Data

Warehouse.

Major Tools: Abinitio-GDE, Continuous-Flow, Conduct>IT(Task and Methods),Express>IT (BRE, Tesding Data Management, Testing Framework),Informatica(9.1.0), ORACLE(10g) - SQL, UNIX.

Languages: UNIX and Shell scripting

Scheduler: Tivoli and Autosys

GANISATIONAL EXPERIENCE IN ETL PROJECTS -> CAPGEMINI

Abibnitio Current Project:

Client: Transunion

Role: Senior Consultant (Development and Design)

Duration Feb-2016 to till date

Project: UDA(Universal Data Acquisition) & EDH(Enterprise Data Hub) application.

Technology Skills: Abinitio(gde-3.2 co>op 3.2), Conduct>IT, BRE,UNIX, Express>IT. Team Size: 15

About Project: UDA is Universal data Acquisition –this is a platform where Transunion take any kind of data from outside 3rd parties to create warehouse for use of its credit product.

EDH is there base application where all data is collected and refined to provide required data to downstream applications.

Responsibilities:

1.I work as senior developer involved in design and coding end to end UDA and EDH projects. Also work as onsite coordinator for offshore team in India and help team to understand business requirement and coding for on-boarding of new data source in UDA, EDH platform.

2.Majority we use Conduct-IT plans, task, methods, abinito component like run program, reformat, filter by expression, join, rollup, scan, read xl, write xl, read multifile, write multifile, partitioning component, BRE rules etc to implement project end to end.

3.Review code developed by team members or code walkthrough and design walkthrough which I create for different sources/requirement.

4.Create work space in express it for new projects. Also write new scripts or some graphs wherever it’s required to automate entire project using express>it to setup regression test bed by testing/qa team.

5.I create turn over document for testing team about project that I am responsible for also support testing team during the time of their testing to fix defects or wherever they need more information for test cases and data creation.

6.Identify performance improvement in code/schedules etc wherever it is required and fix them for existing projects.

7.Creating JIL files for corresponding Autosys schedule implementation.

8.Data masking in Express>IT using TDM to create test data for unit testing .

9.Provide work estimates in hours during sprint planning as client operate in agile method. Also responsible for reviewing Daily and Weekly Status report send by off shore team and then to share it with client.

Abinitio Project 2:

Client: Discover financial Services

Role: Senior Consultant(Project Lead)

Duration Dec-2014 to Jan-2016

Projects: Campaign Management, PRS (Promotional Rewards Services).

& Enterprise Data Services (EDS)

Technology Skills: Abinitio(gde-3.2 co>op 3.0),Conduct>IT, UNIX, oracle

Team Size: 20

About Project: Campaign Management and PRS is initiative of Discover Financial Services to offer different kind of rewards for customer having their cards. EDS is Enterprise Data Services warehouse where all sources data is stored.

Responsibilities:

1.understanding requirement document coordinating with onsite coordinator designing, writing required abinitio code, fixing defects, code walk through, review etc.

2.Identifying possible fixes for code issues and performance in production and then sending it to client for approval and their implementation.

3.Making sure every day plan get complete by coordinating with different team members in project development in offshore, received from onsite coordinator.

4.Preparing different utilities to read complex graph output for testing team, also create graph wherever testing team need to create flat files for their testing after creating data into xl sheets.

5.Helping QA team in data creation for other downstream team to complete their data requirement for testing by masking data in Express>IT.

Abinitio Continuous Flow Project in -> Cognizant Technology Solutions

Client: Barclays Bank

Role: Senior Associate (Senior Associate)

Duration July-2013 to Dec-2014.

Project: RDE: Risk Decision Engine and PSD(Public Services Directives)

Technology Skills: Abinitio(gde-1.14,3.1 co>op 2.15,3.15), UNIX, Mainframe, Teradata.

Team Size: 10

About Project: RDE deals with customer Authentication: Creating data to online driver engine (Triad 8.5) to confirm Customer Authentication at point of sale, decision of plastic card issuance, payment hold and customer payment collection and recovery. PSD deals with public service directives order regulated in UK for all banks to avail credit of a card customer within two hours from the time of customer make payments.

Responsibilities:

1.Understanding requirement part for which I was responsible to write code in abinitio and informatica. Creation of plans, psets, using continuous component like subscriber, publisher, reformat, join, rollup.

2.Converting cobol copybook dml into ebcdic format to read files received from mainframe server and writing code to process files for further processing.

3. Creating abinitio queue and queue dml to read incoming file after file’s header validation to process it through continuous reformat component to apply Logic.

4.Fixing the abinitio related defects and also used to re-write code for already existing graph for performance improvement.

Abinitio Continuous Flow Project in -> Steria Indial Ltd

Client: Barclays Bank

Role: Senior Developer

Duration Sep-2010 to July-2013

Projects: US-BIN: Bin Sponsorship, Insurance Major Projects(Life, Accidental and Motor)

Technology Skills: Abinitio(gde-1.15,3.1 co>op 2.15,3.15 ), UNIX, Mainframe

Team Size: 15

About Project: Bank has been introduced payment acceptance business first time in US by sponsoring some of its BIN. Payment acceptance is done by 3rd party HPS. Datamart creation was required for three files DAF(Daily Activity File), DDF(Daily Dispute File) and Visa File. Received from different data sources or 3rd parties.

Responsibilities:

1.Understanding requirement part for which I was responsible to write code in abinitio.

2.Creating dmls to read US bin files having definitions explained in requirement documents for required and optional fields.

3.Creating data model for Teradata tables field and requesting dba to create table structure for given schema in us bin project.

4.Creating graph to clean the file received from source and validating header for valid date, trailer for record count and detail record for required fields received in file.

5.Creating load ready file by writing transformations to achieve business logics applying on cleansed data

6.Creating load graph using multiload in Teradata utility to achieve fast loading in Teradata tables.

7.Fixing the abinitio related defects and also used to re-write code for already existing graph for performance improvement. Reviewing code with team.

8.Writing Tivoli schedules definition for schedule implementation in QA and production.

Informatica Projects Reliance Info Solutions Ltd.

Client: Reliance Retail

Role: Developer Engineer

Duration Oct-2006 to Aug-2010

Projects: I2 (Forecast & Replenishment), SAP IS-Retail

Technology Skills: Shell Scripting, SQL, Informatica(v 9.1), UNIX, SAP.

Team Size: 15

About Project:

I2-F/R: It is a SCM (Supply Chain Management) project. It is used for Forecast &

Replenishment in Reliance Retail. I2-F/R contains three major steps of job

Responsibilities:

1. Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer. Used transformations in Informatica and Workflow manager to create Workflows, sessions.

2.Developed unix scripts for email about mapping failure and business report notification

3.Using SQL for data updating. Scheduling the workflows using CIS task scheduler

4.Analyse to find solution of problems arising in SAP-I2 integration or SAP-I2 interaction.

5.Pushing the prices from SAP to POS (SAP POS INTEGRATION)and maintaining prizing.

6.Recovering the PO Number from Data base tables and checking the document flow for the goods from warehouse to stores.

Contact this candidate