Sign in

Associate System Engineer

Mumbai, MH, India
April 18, 2016

Contact this candidate


Jayesh Dateer

Mail-id : Address: Sr. No. 28/4, Near

Cell: +91-966-***-**** Bollywood Theatre, Old Mundhwa

Road Kharadi, Pune, 411014

Career Objective

To pursue a career in a progressive environment where learning is encouraged and my skill set can be enhanced to contribute to the overall success and growth of both the organization and self.


2.4 Years of IT Industry experience with IBM India Pvt. Ltd as Informatica Developer.

Certified Scrum Master from Scrum Alliance.

5 months on Android & Web Development project as Industrial Training at Ypsilon IT Solution, Indore.

Worked on PHP/MySQL as minor project in MCA.

Extensive development and testing experience with Informatica Power center 9x.

Proficient in analyzing and translating business requirements to technical requirements.

Knowledge of working on Agile Projects with along with onshore-offshore model.

Good experience in Oracle and UNIX.

Involved in Unit Testing, Peer review of the ETL code and in building the Unit Test case documents.

Managed Support for daily monitoring of automated ETL load jobs.

Excellent documentation and presentation skills.

Object Oriented Programming and development knowledge.


Skill Set

ETL Tools Informatica Power Center, Informatica 9.6

RDBMS Oracle 9i and 10g

Languages C, OOP concepts

O/S Windows

Scheduler Control-M

Source Control Tools Tortoise-SVN

Defect Tracker Tool HP Quality Center


2013 MCA from National Institute of Technology Karnataka with 7.68 CGPA.

2010 BCA from Softvision College, DAVV University Indore with 72% marks.

2007 12th from Kendriya Vidyalaya No. 1, CBSE Board with 75% marks.

2004 10th from MarThoma School, M.P. Board with 80% marks.


1.BASEL Export Blue – Amex (General Ledger Reconciliation)

Client American Express, USA

Organization IBM

Start Date February 2014

End date March 2016

Role ETL- Informatica Developer

Tools & Technology Used Informatica 9.6, Oracle, Toad, UNIX, Putty, WinSCP

American Express Corporation is an American multinational financial services corporation. Basel project aims to implement data warehouse solution for Amex operations to enable them to take better business decisions. It includes business intelligence functionality, which will enable Amex to collect and analyze customer data to reduce churn, develop new attractive offerings and increase customer profitability. The goal is to establish a good, scalable architecture for the BI Solution which would also contain a flexible ETL solution.

General Ledger Reconciliation is the process performed by accountants to verify the integrity of account balances on the company’s general ledger of accounts. It involves comparing the general ledger account balances with other independent systems, statements, and reports, to verify that the balances are correct and accurate; investigating thoroughly any discrepancies that are identified; and taking proper corrective actions to resolve these discrepancies.

It is an enhancement project where we modified few existing as per Business requirements with accurate delivery and zero percent defects.


Analyze and understand the Technical Specification Document (Source to Target matrix) for all mappings and clarify the issues with Data Architects (Owner of Technical Specification Documents).

Development of the mappings and building Workflows.

Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica.

Involved in Unit testing from my end before delivering to SIT & UAT team so as to ensure we deliver a quality code.

Handled SIT load and supported testing team whenever required.

Supported testing team during UAT data load, executed jobs through Control-M.

Documentation (design doc, UTP, migration doc, review checklist)

Use SQL queries to validate the data loaded into the target tables.

Personal Information

Father’s Name : Dattatray Dateer

DOB : 28-04-1989

Permanent Address : 12/3, Nanda Nagar,

Indore, M.P. – 452011

PAN Number : AWMPD4031G

Contact this candidate