Experience

Dean Health Plan

• United States
• Insurance
• 300 - 400 Employee

• Senior Informatica/ETL consultant

  • Aug 2013 - Present

  Working as Senior Informatica/ETL consultant at Dean Health Plan, one of the largest integrated healthcare delivery systems in the US. Dean provides various Health insurance plans to individuals as well as employer groups. The ETL solutions were developed to generate the EOB forms as per the new HCR rules & regulations. Working as Senior Informatica/ETL consultant at Dean Health Plan, one of the largest integrated healthcare delivery systems in the US. Dean provides various Health insurance plans to individuals as well as employer groups. The ETL solutions were developed to generate the EOB forms as per the new HCR rules & regulations.



TD Bank

• Canada
• Financial Services

• Lead Informatica / Data Warehousing consultant

  • Aug 2010 - Aug 2013

  Worked as Lead Informatica / Data Warehousing consultant at TD Bank. Implemented various data warehousing and data conversion projects for retail, small business and commercial lines. Worked as Lead Informatica / Data Warehousing consultant at TD Bank. Implemented various data warehousing and data conversion projects for retail, small business and commercial lines.



Sentry Insurance, WI

• Accounting
• 1 - 100 Employee

• Senior Informatica / ETL Consultant

  • Dec 2009 - Aug 2010

  Handled the roles and responsibilities of a Senior Informatica consultant to help Sentry ETL team to implement the data integration efforts for the Policy, and Claim information. Handled the roles and responsibilities of a Senior Informatica consultant to help Sentry ETL team to implement the data integration efforts for the Policy, and Claim information.



State Department Of Health, PA

• Senior Informatica Consultant

  • Jul 2009 - Nov 2009

  Developed the etl process to implement Audit and Reconcile process for the State Department of Health of PA. Developed the etl process to implement Audit and Reconcile process for the State Department of Health of PA.



Great American Insurance Company

• United States
• Insurance

• Informatica Consultant

  • Sep 2007 - Jun 2009

  Helped the Claim center conversion project team to design/develop the etl solution to migrater data from the Legacy sources to Guide Wire Claim Center for the various lines of business. Helped the Claim center conversion project team to design/develop the etl solution to migrater data from the Legacy sources to Guide Wire Claim Center for the various lines of business.



Allianz Life Insurance

• 1 - 100 Employee

• Informatica Consultant

  • Feb 2007 - Jul 2007

  Helped in Developing a centralized database to provide data analysis for Policies, Claims Adjudication and Product information by implementing the data integration. Helped in Developing a centralized database to provide data analysis for Policies, Claims Adjudication and Product information by implementing the data integration.



WEA Trust

• United States
• Insurance
• 100 - 200 Employee

• ETL / Informatica Consultant

  • Sep 2006 - Jan 2007

  Developed a Claims management system that assists claims professionals in administering claim practices in a timely and effective manner. Developed a Claims management system that assists claims professionals in administering claim practices in a timely and effective manner.



State Dept. Of PA

• United States
• Medical Practices
• 1 - 100 Employee

• Informatica Consultant

  • Sep 2005 - Sep 2006

  Developed the Data Warehouse for the Departemnt of Public Welfare of PA to generate reports about budget allocation and usage for approval of the annual budget. Developed the Data Warehouse for the Departemnt of Public Welfare of PA to generate reports about budget allocation and usage for approval of the annual budget.