Design, implement and manage Personal Lines Policy Operational Data Store (ODS) ETL systems using Informatica PowerCenter mapping and workflow management tools utilizing the SAFE/Agile development methodology.Design, implement and manage SAP Business Objects Universe Designer solutions for the Personal Lines Policy Operation Data Store system.Manage all development tasks and projects using the JIRA-Atlassian tracking software.

Mapped claims data extracts from medical insurance carriers and pharmacy benefit managers into Decision Master Warehouse, a web-based decision support application for insurance brokers, using IBM DataStage ETL mapping software.Analyzed the executive summary and data analysis results from the processed data and propose possible solutions and action items to our insurance broker clients through scheduled consultations.Assisted with implementation and support of all Data Analytics applications, both internally and for our customers.Created necessary validation reports and metrics to ensure high quality data output using SQL Server queries, Microsoft Access and Microsoft Excel.Trained new hires in all Data Services department processes and procedures.

Performed data analysis on commercial and residential property claims for internal and external customers by using newly developed or established SQL queries in Microsoft SQL Server 2005 Management Studio or Microsoft SQL Query Analyzer.Applied property claims knowledge to large amounts of claims data in identifying areas for claims practice improvement.Provided the SQL coding to the production support team for new or updated business rules for the MS/B Analytics WebTQS dashboard.Used Microsoft Office Suite to prepare presentations, reports and studies from the analyzed data with charts, graphs.Investigated new methods through which the property insurance industry can operate more effectively.