Data Developer

Manas Ab-initio Mishra ETL Developer

Visa Type: H1B, Email: ***********.**@*****.***, Contact#:+1-302- 455-8343

Objective To be part of an organization where the process of learning never ends and everyday is a challenge to work, perform and deliver. To secure a position where I can utilize my skills and abilities in the industry which gives me Experience a challenging Summary environment, professional growth while being resourceful, innovative & flexible.

Around 5+ years of IT experience, My main area of experience is in data warehousing development and maintenance. My technological fortes are Abinitio 1.16/2.15/3.0, UNIX shell scripting,Oracle,SQL server and possess good communication skills. My current role is Ab-initio Developer.

Extensive exposure across all phases of the software development cycle, primarily in requirements Analysis, ETL Design, Coding and Unit Testing.

Well experienced in handling the role of Technical Lead, Team Lead and Developer.

Well experienced in handling L3 Prod Support and On Call.

Experienced in Data ware house applications and good experience on Abinitio.

Responsible for managing software system development and integration projects through all phases of project life cycle including analysis, coding, testing, implementation, documentation to ensure quality project deliverables.

Responsible for gathering / analyzing client's requirements by interacting with them on a regular basis to provide them with the required data in form of reports, files and schema.

Instrumental in developing and implementing client needs assessment and product specifications to define and manage specified expectations resulting in quality project delivery.

Instrumental in building credibility, establishing rapport and maintaining communication with clients and team members at multiple levels.

Experience in Different Software development methodologies like Waterfall Model and Agile Software Development process.

Worked as the Information security co-coordinator (ISC) and Crises management lead (CML) for 3 years.

Responsible for conducting/arranging the security tanning and facing security related audits. (Both internal and external).

As CML responsible for conducting the BCP drills and creating the BCP plans for our project.

Part of TCS Maitree (TCS CSR initiative) for the last 4.5 years and lead computer education program at various schools.

TechnicalSkills:-.

Professional experience

Project 1:- FCP .net/SQL server to ETL Rewrite

Customer JP Morgan Chase, Cards

Period Oct- 2015 – till now

Description Financial Control Platform(FCP)

Any Credit Card Manual payment and Adjustment

data comes from FCP GUI to SQL server

database.

FCP also acts as a pass through system for

CSD(Collections team)

FCP send Payment and adjustment to MGW and

then Core for posting.

GL and settlement :FCP

For the payments posted at Core FCP

also does a bookkeeping .

It is actually the total debit transaction

should be equal to total credit

transaction.

Capture General process picks up the

GL entries from SQL server database

and sends it to Settlement team

Role On-Shore/off shore Co-ordination /Tech Lead

Responsibilities Requirement Capturing from business Analyst in terms of functional and converting into technical

understanding .

Create ETL design in vesio from existing .net

code and assigninging modules to team

members.

Developing generic process for ETL code .

Creating UT documents and defect handling .

Creating ITSM, Implementation plans and

updating the Tech documents in LL.

Solution Environment Abinitio 3.0/Unix/SQL server 2005 /Oracle 11.0 Tools Ab-initio GDE 3.0

Oracle Sql Developer 2.1.063,TWS scheduler

Specialized knowledge gained Ab-initio Co>operating 3.15 ProgrammingLanguages C++,Unix Scripting,Ab-Initio, ORACLE,SQL server ETL TOOL Abintio v3.0/2.15/v1.6,Abinitio BRE v3.0,PL/SQL Developer 7.1.5 Unix

Tools Putty

HP Defect Management system(DMS)

HP AML (Application Managment Lifecycle )

Version Control Tool:

Tortoise Sub-Version(SVN) 1.6.2

Scheduler

TWS(Tivoli Workload Scheduler).

DomainKnowledge BankingandFinancial Services

Operating Systems Microsoft Windows XP/7/ 8/10, Linux( Fedora, Ubuntu),Unix SQL server 2005

Work Location(s) Wilmington, Delaware

Project Location(s) US

Project 2:- MDES to ST5 migration

Customer JP Morgan Chase, Cards

Period Dec -2014 – Oct 2015

Description MDES to ST5 migration :-

Any incoming/outgoing file to/from MAC block was via MDES(GTI team) both internal and external.

As MDES was decommissioned and all the code

need to be changed to accommodate transmission

of file via ST5 1.0 .

Installation of Auth Key:-

In order to establish SSH password less

connectivity with ST5 2048 encrypted keys need

to be installed into each functional account.

Code base is changed to to transmit files via St5 .

All the ETL application in MAC block was

impacted.

Role On-Shore/off shore Co-ordination /Tech Lead

Responsibilities Requirement Capturing from business Analyst in terms of impact analysis .

Design the new changes without impacting the

existing BAU etl code base .

Co-coordinating with chase internal and external teams to test the file connectivity.

Developing generic transmission process for all

ETL code .

Creating UT documents and defect handling .

Created FXM requests to engage GTI team.

Creating ITSM, Implementation plans and

updating the Tech documents in LL.

L3 Prod Support and On Call

Solution Environment Abinitio 3.0/Unix /Oracle 11.0/ST5 Tools Ab-initio GDE 3.0

Oracle Sql Developer 2.1.063,TWS scheduler

Specialized knowledge gained Ab-initio Co>operating 3.15 Work Location(s) Wilmington, Delaware

Project Location(s) US

Project 3: ACME/MGW/RGW/AGW/NDS/ODE

Customer JP Morgan Chase, Cards

Period Feb- 2013 – Dec-2014

Description Data processing :ACME/MGW

We receive data in flat files from different users with a predefined format.

Process the file based on priority,do

transformation and send it to different destination systems.

Destination systems are like core and CIS .Central repository for Cards block.

Data Reconciliation: ACME/MGW

A process to check the consistency of

the data send to destination system

and actual response received from

them.

If the actual number of user data send

is equal to the number we received.

The end users can check the status of

their file from control tables at any

point of time

Role Developer/L3 maintenance.

Responsibilities Requirement Capturing from business Analyst in terms of functional specs and converting into

technical understanding .

Create new graphs for applications like

ACME/RGW/NDS and also creating UT

documents.

Creating ITSM, Implementation plans and

updating the Tech documents in LL.

Providing On call production support for MAC

applications like ACME/MGW/RGW/ACH.

L3 Prod Support and On Call

Solution Environment Data warehouse, Unix

Tools Ab-initio GDE 1.16

Oracle Sql Developer 2.1.063,TWS scheduler

Specialized knowledge gained Ab-initio Co>operating 2.16 Work Location(s) Bhubaneswar

Project Location(s) US

Project 4:- LRR HK FRS

Customer JP Morgan Chase,APAC

Period May 2012 – Jan-2013

Description Data Sourcing:

Data required for regulatory reporting are sourced from agreed product systems or manually upload by

users

Data Loading:

Handle receive of data to LRR data

model

Loading of auto feed is done per prior

agreement with data providers

Manual data update can be done

online or in batch mode

Online function and/or report available

to inquiry the ETL process

Data Reconciliation:

A process to check the consistency of

ledger and product balance after data

loading process

Auto-generated entities is generated if

ledger and product balances do not tie

Reconciliation result has to be

captured for reporting

Data consolidation:

Data from product staging area inside

LRR data model is transformed,

enriched and populated to FRS data

model (GDM)

Common Reports:

Common reports support tracing of

exceptions on data processing,

inquiring system reference data and

identifying data discrepancy

Role Developer

Responsibilities Requirement Capturing from business users in terms of functional specs.

Creating Generic Ab Initio Graph that can fit to load the data into landing and staging table with various transform logic that are implemented in BRE.

Creating design documents for batch jobs.

Solution Environment Data warehouse, Unix

Tools Ab-initio GDE 3.0.3

Oracle Sql Developer 2.1.063

Specialized knowledge gained Ab-initio Co>operating, BRE Work Location(s) Bhubaneswar

Project Location(s) HongKong

Project 5:- APAC LRR Singapore

Customer JP Morgan Chase,APAC

Period Mar-2011 to May-2012

Description The APAC LRR-SG caters to the Singapore geography. It deals with running of reference data load, dimension table load. Data from various sources are kept in the landing path from where ab-initio graphs pick up the data validate, process them according to the rules specified in the graphs and then load these data to different fact table. Further the reports are generated which then sent to customer via mail.

Abinitio version 3.0 is used to develop graphs for processing data. BRE (Business Rule Environment) version 3.0 is used to develop

Master of Computer Application (MCA),India

Key Competencies & Skills

Skills Proficiency(E0 to E4)

Oracle E0

Unix Programming E0,E1

Abinitio E0,E1

Trainings Conducted

Year Title Location Presented To

2012 Data ware house Architecture Bhubaneswar Team 2012

Unix Basic commands and

shell scripting Bhubaneswar Team

Work Permit Status

Visa Type H1B

Visa Validity 11/22/2014 – 08/06/2017

the business rules involved in the project. Abinitio version 3.0 is used to develop graphs.

Role Developer

Responsibilities

Analysis the etl feed specification documents and data mapping documents for the change.

Analysis for the change in the existing generic graph and getting details for the changes to be made in BRE rules xfrs and graphs.

Developing and modifying various generic graph,

building new graphs,BRE rules according to

requirements

Developing the unit test documents.

Migrating the code to SIT and UAT for testing.

Fixing the defects raised in the SIT and UAT.

Solution Environment Database-Oracle 10g, WINDOWS XP Tools Abinitio v3.0/1.16,Abinitio BRE 3.0, PL/SQL Developer 7.1.5, Putty, Sub-Version(SVN),Control-M

Location Bhubaneswar, India

Contact this candidate