SHARMILA SUBRAMANIAM

ETL DEVELOPER

An exorbitant team player with 3.2 years of experience in Data warehousing with interest to learn technical skills. Looking for a career to share my skills/experience on challenging projects involving extensive use of technologies to productively contribute towards the betterment of self and company ac88e8@r.postjobfree.com +974******** Doha, Qatar WORK EXPERIENCE

07/2017 – 12/2018

Associate

Zurich North American Insurance

Cognizant-Chennai,India

ZNAW Release - Zurich North America Warehouse is the operational data store,it conforms/transforms data from disparate systems into single repository and feeds financial information to SAP,Actuarial partners and Zurich Enterprise Analytics such as Organization information, Company, State, Line of Business, Reinsurance information, Calendar Date, Accident Date and other dimensions which are accessed through reporting tool Business Objects by Finance end-users.

Developing/Modifying ETL codes based on user requirements. Extracted data from various source system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center

Performed Unit testing and maintained test logs and test cases for all the mappings.

Optimizing the mapping, session and workflow to improve the load performance.

Coordinating with the QA team in resolving the issues and moving the codes successfully till production

Scheduling jobs in Autosys using jill script to automate daily production run.

10/2015 – 06/2017

Programmer Analyst

Branch Banking and Trust (BB&T)

Cognizant-Chennai,India

FMER - Financial Marketing Executive Reporting deals with developing ETL design to cumulative loan, credit and debit amount for clients belonging to various Line of Business. ETL designing, coding, and testing

Tuned Informatica mappings and sessions for optimum performance. Preparing Unit Test Plan Document, Unit Testing Document, SIT Document Maintained warehouse metadata, naming standards and warehouse standards for future application development.

After Completion of testing deployment of code in production Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time

EDUCATION

2011 – 2015

Bachelor of Engineering in Electronics and

Communication with CGPA of 8.52

Velammal Engineering College

Chennai,India

SKILLS

Informatica PowerCenter DB2 Netezza SQL

UNIX Autosys CA Workstation

Data warehousing JILL

ACHIEVEMENTS

"ANALYTICS AND INFORMATION MANAGEMENT BRITE"

award from Cognizant Technology Solutions

Banking and Financial Service “HACKATHON-2017”

Winner from Cognizant Technology Solutions

"ANALYTICS AND INFORMATION MANAGEMENT

WIZARD"award from Cognizant Technology Solutions

LANGUAGES

English

Tamil

INTERESTS

Marathon Running Reading

Social Services -Volunteering Gardening

Achievements/Tasks

Achievements/Tasks

Contact this candidate