Sheethal R V

Results-driven professional with 5 years of technical experience in Analysis, Design, Development, and Implementation of Client Server Application and Data warehousing ETL in Informatica Power Center. Skilled in developing on diverse data sources such as Oracle, Excel, and Flat files. Strong ability to create and execute unit test plans based on system and validation. Excellent technical skills combined with effective communication and team coordination. Committed to achieving company goals and delivering exceptional service. Enthusiastic about continuous learning and professional development.

Project : HARTFORD Reinsurance

Domain: Insurance

Reinsurance is insurance for insurance companies. It’s a way of transferring or “ceding” some of the financial risk insurance companies to another insurance company, the reinsurer. Reinsurance transactions were between two insurance entities: the primary insurer that sold the original insurance policies and the reinsurer. Most still are Primary insurers and reinsurers can share both the premiums and losses, or reinsurers may assume the primary company’s losses above a certain dollar limit in return for a fee. Risks of various kinds, particularly of natural disasters, are now being sold by insurers and reinsurers to institutional investors in the form of catastrophe bonds and other alternative risk and spreading mechanisms.

Project : Aventis Pharma

Domain : Healthcare

Aventis is a pharmaceutical company, which provides new and improved biotech drugs for various diseases and their symptoms. The objective of the project is to extract data stored in different databases and load into oracle system which is the staging area and the business logic is applied to transform the tables in the required way. The data warehouse is fed by marketing data, sample data, market (competitor) data, prescription data and others.

Project : Allstate

Insurance Domain: Insurance

Allstate is one of the fastest growing Auto/Property/ Life Insurance Company. It serves its customers by offering a range of innovative products to individuals and group customers at more than 600 locations through its company-owned offices. The primary objective of this project is to capture different customers, policies, claims agents, products and financial related data from multiple OLTP systems and flat files. Extracted, Transformed & Loaded data into data warehouse using Informatica Power Center and generated various reports on a daily, weekly, monthly and yearly basis. These reports give details of the various products of Allstate Insurance products that are sold.