CURRICULUM VITAE
Vinit A Rathi
Mobile No.:- +91-909*******
Email Id: - ***********@*****.***
Objective
I would like to be utilizing my skill and abilities in the ETL and Reporting Tools, where every assignment would be a challenging, innovative and offers to professional growth.
Professional Summary
• Software Engineer with 2.4 years of experience in the IT industry
• Worked on various projects involving data warehousing platforms like Structured Querying, ETL and worked on all the phases of Project SDLC and has good understanding of all the phases.
• Acquired a comprehensive grasp on various technologies like Informatica PowerCenter, UNIX, and Oracle SQL and Control-M Scheduler.
• As a Programmer, involved in analysis, design, development, and testing.
• Extensive hands on experience in Informatica and SQL
• Process oriented; willing to work in target based environment.
Skill Set
Programming Language : SQL
ETL Tool : Informatica 8.6
Database Management System : Oracle 9i, Oracle 10g
Operating System : UNIX, Windows 98/2000/XP
Scheduler : Control-M
Current Employer
Employer : iGATE Computer Systems Ltd.
Designation : Senior Software Engineer
Experience : 2.4 years
Project Profile
Project1 : Genworth Insurance Admin Server Application
Role : Programmer
Duration : September 2011 to Till date.
Client : Genworth Life & Annuity Insurance, US
Team Size : 2
Project Overview : Genworth Financial is strategically focused and positioned in insurance domain to provide the stability, confidence and support to policyholders, customers and distributors. This project involved maintenance and enhancements in XML Code (Policy Administration Tool), ETL logic, also to write Oracle code in order to generate required reports in CSV format.
Responsibilities:
• Enhancement &Maintenance for ETL
• Creation of new ETL mapping (Through SDLC flow)
• Changing ETL logic of existing mapping
• Developing SQL queries based on business requirements
• Basic functional testing for new jobs using functional details provided by client
• Tuning ETL and SQL code for loads taking longer time
• Maintenance & Support for XML code through Oracle Insurance Policy Administration interface
• Maintenance of code for policy screen (user interface) as per business requirement
• Create new transaction/activity for existing company-product
• Testing interface functionality for XML code and to create test cases
Project2 : CFS CEEMEA
Role : Programmer
Duration : September 2010 to August 2011.
Client : Procter & Gamble
Team Size : 14
Project Overview : Customer Financials System (CFS) is ETL and Reporting application of P&G where business does the reporting of Finance and Shipments data. The System processes Revenue and Expense data which is used for Profit and Loss realization.
Responsibilities:
• Informatica coding and issue resolution during test runs. Also responsible for code migration to QA and UAT environments
• Completely responsible for Control-M setup. Took the ownership to resolve all the technical issues related to Control-M
• Creation of Unit test cases and System integration test cases to make sure that all the functional and technical aspects are covered
• Validation of Oracle, Informatica & control M objects post migration to QA & UAT environments
• Creation of R2P documents including Migration list for objects in Oracle, Informatica, control M. Also worked on Support handover documents such as Master run book.
• Involved in Peer and Peer-to-Peer review of test case documents, R2P documents
• Communication with Onsite coordinator for discussing project requirements & resolving issues
Achievements
• Get Pat on the Back in CFS CEEMEA project
Educational Qualification
• B.E. from Babasaheb Naik College of Engineering, Pusad in 2009 with First class
Personal Information
Name : Vinit Ashok Rathi
Email : ***********@*****.***
Passport : Yes
Date of Birth : 7th Feb. 1987
I hereby declare that the above information is true to the best of my knowledge.
Vinit A Rathi