Jessica Zimmerman
New York,NY
Overview
4
4
years of professional experience
1
1
Certification
Work History
Global Data Lead, Reporting
Gallagher Re
04.2023 - Current
- Manages a team of five analysts in the development of a Power BI dashboard on client demographics, win/loss rates, and qualitative feedback achieving an 80% reduction in the preparation time of standard client materials
- Leads 20+ external consultants in merging eight legacy financial SQL databases into a master data source, resulting in a 75% reduction of time required to generate reports
- Coordinates with Engineering and Sales teams to incorporate new application features and reports on client KPIs including market share and average price, expanding global application usage by 300%
- Collaborates with the CDO, cross-functional executives, and external consultants to design the strategic five-year roadmap for building the global transactional reporting platform
Senior Data Consultant
Gallagher Re
01.2022 - 03.2023
- Developed a SQL stored procedure synchronizing global data terminology and produced a Power BI dashboard on KPIs including annual price change and sales growth, reducing a two-month process to two days
- Built an R-Shiny application for visualizing client profitability and dynamic geospatial concentration, replacing a repetitive Excel analytical process from three weeks to minutes
- Developed and implemented five R functions to automate the validation and organization of client data, reducing client errors by 60% and saving two weeks of data cleansing per client
- Conducted a weekly Power BI and Python book club guiding attendees through interactive instructional material
Actuarial Consultant
Willis Re
07.2020 - 12.2021
- Analyzed 30+ client data extracts to identify annual trends, compare to external benchmarks, and aggregate into internal pricing models to provide plan design options for five clients per year; presented options with cost and risk tradeoffs supporting the client in making an informed purchasing decision
- Constructed and presented a COVID Excel model to calculate projected losses based on COVID-induced hospitalizations, prompting the client to set aside an extra $7.5M for future expenses
- Evaluated a client’s portfolio using proprietary financial models and presented financial bond and reserve allocations enabling the client to go from an AM Best rating of B++ to A-
Data Analytics Intern
Cigna
05.2019 - 08.2019
- Utilized SQL Server to query customer data and collaborated with internal medical experts to identify KPIs such as time spent per patient leading to the creation of a preferred cardiologist network and a 15% reduction in Cigna's healthcare costs
Education
BBA - Actuarial Science (Predictive Analytics)
Temple University
Philadelphia, PA05.2020
BBA - Risk Management
Temple University
Philadelphia, PA05.2020
Skills
- Python (numpy, pandas, scikit-learn)
- R (dplyr, tidyr, leaflet, Shiny)
- SQL Server
- Power BI
- Git
- Jira
- Power Query
- Excel
Certification
Data Analytics - Columbia University, February 2022
Additional Information
Passed three Actuarial Professional Exams: (1) Probability, (2) Financial Mathematics, and (3) Investments in Financial Markets
Accomplishments
- Initiated a $50k investment from Gallagher Re into the Cristo Rey High School Corporate Work Study Program; facilitated a semester-long program as the lead volunteer supervisor of five students
- Co-leads a global coding community, organizing the firm's first hackathon and increasing membership from 45 to 155 colleagues in two years
- Women in Tech Member and Mentee
- Intramural Soccer & Kickball
Timeline
Global Data Lead, Reporting
Gallagher Re
04.2023 - Current
Senior Data Consultant
Gallagher Re
01.2022 - 03.2023
Actuarial Consultant
Willis Re
07.2020 - 12.2021
Data Analytics Intern
Cigna
05.2019 - 08.2019
BBA - Actuarial Science (Predictive Analytics)
Temple University
BBA - Risk Management
Temple University
Similar Profiles
ADAM KETLEYADAM KETLEY
Placement Support Handler at Gallagher RePlacement Support Handler at Gallagher Re
Rohit KotianRohit Kotian
Accounts Controller at Gallagher ReAccounts Controller at Gallagher Re
Kaileigh McCrillisKaileigh McCrillis
Senior Executive Assistant at Gallagher ReSenior Executive Assistant at Gallagher Re
Savitha SuraSavitha Sura
Senior Catastrophe Research Analyst at Gallagher ReSenior Catastrophe Research Analyst at Gallagher Re
Norman Trotter IVNorman Trotter IV
Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)