Working as Developer

Universal American is one of the Americas Health Care providers. UAM group of companies offers affordable products and programs including traditional health insurance, Medicare managed plans and Medicare prescription drugs benefits. Informatica is used for ETL purpose. Transform the data according to business requirement and then load the data.

Working as Team member

Indian Oil Corporation is Indias Largest Oil and Gas Company and is the 88th largest company in the world having branches across India, Sri Lanka and Mauritius. It has its own cooking gas supplying chain through 9500 distributors across India and increasing day by day with having 15 crore customers. As per Indian Govt, each domestic gas connection will get 12 cylinders per year with subsidiary price, the person has to pay the full amount to the distributor and the subsidiary amount will automatically credited to the customer account. The purpose of this project is to provide the subsidiary amount to the customer through bank which will happen by linking their Aadhaar number and bank account details. Here the main stream of informatica is to capture the customer details from OLTP and separate it bank wise and providing the same data to NPCI. And to collect the information of customers on Daily, weekly, monthly basis and analyze the business in order to compare the revenues and to check the monthly deposits in bank as whole.