The scope of the project is to receive the Spend details for Research, Study, Travel, Food, Educational Items, and Advisory Board Meetings, maintain the data related to Healthcare Professionals and healthcare organizations, applying various business logics to approve or reject the reimbursement. All the application related data logic and business requirements are implemented in Informatica interface and populated to SQL Developer database.

• Understanding Business requirements and preparing Approach and design documents.
• Developed end-to-end mapping with various Informatica transformations and complex Business logic for new source system transition.
• Used SQL overrides in source Qualifier to meet business requirements.
• Collaborate with reporting team and collect requirement to implement activities such as create table, implement logics, schedule jobs.
• Performed Unit/Integration Testing for all the SOWs and Developments, in Dev and Test environment before migrating to Production.
• Experience in fine tuning Informatica mappings and identifying bottlenecks to enhance performance.
• Performance tuning source SQL queries for long running production jobs and reduce run-time appreciably.
• Created SQL Queries to check the row counts for source and target tables.
• Providing KTs and taking the same on the new tasks.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Solved CR’s, involved in production implementation, and received client appreciation
• Developed more than 20-25 objects (INFA Mappings) with utmost efficiency with short duration of time.
• Worked as a SME for two applications.
• Handled Production Support also for the project and solved all technical and data centric issues faced during the support.

The Hanover Insurance Group Inc is the holding company for a group of insurers that includes The Hanover Insurance Company, Citizens Insurance, Chaucer Holdings PLC, and their affiliates. The Hanover offers a wide range of property and casualty products and services to businesses, individuals, and families through a select group of independent agents across the US.

• Understanding and reviewing the functional requirements which we get from Business Analyst and signing off the requirement document.
• Prepared technical design document as per the functional specification and unit test cases. Developed and tested Informatica mappings based on the specification.
• Used various transformations to extract data from different files and relational source system.
• Extensively used Informatica to load data from flat files, Oracle database.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Involved in unit testing and providing support to SIT, QA and UAT
• Implemented slowly changing dimension (SCD) Type 1 and Type 2 mappings for changed data capture.  

• Maintained strict adherence to schedules, delivered the deliverables on time and given more importance on quality over quantity.