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 email@example.com +974******** Doha, Qatar WORK EXPERIENCE
07/2017 – 12/2018
Zurich North American Insurance
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
Branch Banking and Trust (BB&T)
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
2011 – 2015
Bachelor of Engineering in Electronics and
Communication with CGPA of 8.52
Velammal Engineering College
Informatica PowerCenter DB2 Netezza SQL
UNIX Autosys CA Workstation
Data warehousing JILL
"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
Marathon Running Reading
Social Services -Volunteering Gardening