Resume
Experience
Jul 2022 - Present
Data Analyst
Farmers Insurance Group
King of Prussia, PA
-
Designed and implemented a Python and SQL-based ETL pipeline to extract and transform data from Pendo’s v1 API, resulting in improved data accessibility for the marketing and customer experience teams, as well as enabling the efficient processing of large datasets
-
Created dynamic and interactive dashboards in Power BI to visualize call center data, increasing data accessibility and reducing analysis time by 20% for the customer experience team
Jul 2016 - Jul 2022
Liability Claims Supervisor
Farmers Insurance Group
King of Prussia, PA
-
Supervises a team of 6 claims professionals, with oversight of approximately 700 bodily injury claims, to adjust and negotiate the settlement of insurance claims and manage complex claims litigation
-
Nominated for Farmers Insurance’s prestigious Passion for Excellence Award for the design, development and maintenance of a dynamic excel reporting dashboard, which consolidated claims management key performance indicators and helped spur a 19% increase in the percentage of claims closed within 90 days
-
Spearheaded a mobile video conferencing initiative as a Subject Matter Expert, which was later expanded to Farmers claims operations in Pennsylvania, Ohio, Maryland and Virginia
Aug 2015 - Jul 2016
Special Liability Claims Representative
Farmers Insurance Group
King of Prussia, PA
-
Decreased average claims cycle time by 3.1 days and reduced average total cost of repairs by $507, by identifying and troubleshooting process issues, as the Subject Matter Expert for the Farmers’ preferred repair facility program
-
Increased claims handling efficiency by collaborating with Liability Supervisors in Olathe, KS to create standardized email templates to expedite the resolution of minor coverage issues
-
Trained 2 new employees as a New Hire Peer Guide to investigate, evaluate and negotiate bodily injury claims and monitored their performance through inventory tracking and weekly recap discussions
Feb 2014 - Aug 2015
Senior Liability Claims Representative
Farmers Insurance Group
King of Prussia, PA
-
Represented the King of Prussia Claims Office as a member of the Northeast Employee Advisory Committee. Acted as a liaison between the claims representatives and management, developed strategies to improve communication, and provided feedback about proposed strategies, policies and programs
Mar 2012 - Feb 2014
Liability Claims Representative
Farmers Insurance Group
-
Guided and coached a claims representative transitioning into a new role as a liability claims representative by sharing best claims handling practices and investigative techniques
King of Prussia, PA
Technical Skills
Programming Languages
Python (NumPy, Pandas, Matplotlib, Seaborn, Plotly)
SQL
Tools
Postgresql, Tableau, PowerBI, Alteryx, Snowflake, Microsoft Excel
Skills
Git, Database Design & Management, Data Analysis, Data Visualization, Advanced Microsoft Excel, Excel VBA, Data Modeling, Project Management
Education
Rutgers, The State University of New Jersey
New Brunswick, NJ
Bachelor of Arts in Political Science
James Dickson Carr Scholarship Recipient
Education
Rutgers, The State University of New Jersey
New Brunswick, NJ
Bachelor of Arts in Political Science
James Dickson Carr Scholarship Recipient