Jonathan Collins
815 NE 123rd St. Seattle,WA
Summary
Data analyst and scientist with a focus on developing user-friendly databases and dashboards. Achievements include launching a new reporting suite to monitor over 1000 claims representatives and automating data processing, reducing time by 80%. Proficient in SQL and Python, driving innovative solutions to enhance operational efficiency.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Senior Data Solutions Analyst
Liberty Mutual Insurance
11.2022 - 02.2026
- Launched a new data pipeline and reporting suite consisting of 6 unique reports and over 80 different claims quality metrics to help monitor over 1000 claims reps
- Assisted junior analysts to help innovate and modernize the reporting suites that our team had built and maintained
Senior Client Data Specialist
Hannover Re
04.2021 - 11.2022
- Processed 500+ data files, reports, and claim documentation received monthly from 20 different clients
- Automated the processing of client files, reducing the processing time by 80% and creating validation checks to ensure files received are accurate and include required information
- Created multiple tracking reports and comparison tools to assist in the creation of a new database warehouse
Assistant Center Director and Lead Instructor
Mathnasium
05.2021 - 07.2022
- Implemented strategies to continuously improve the environment of the center to create a safe space for students to learn to the best of their ability
- Supported other instructors by improving their instructional techniques and helping them handle difficult students
- Developed customized reports to help monitor students' workout plans and provide clarity to parents regarding their children's monthly progress
Data Solutions Analyst
Liberty Mutual Insurance
07.2017 - 11.2020
- Monitored and maintained 80+ scheduled reports for business analysts and claims manager to assist in claims handling
- Taught a monthly class to business partners about our claims data warehouse, and continuously provided support for our 50+ claims analyst with any data issues or questions
- Automated the sprint planning process for our AGILE team using Python, improving the team's sprint planning efficiency by 75%
Education
BBA - Management Information Systems and Finance, Business Analytics
Villanova University
Villanova, PA05.2017
Skills
- SQL
- Database design
- Data modeling
- Python programming
- BI model development
- ETL development
- Custom reporting
- KPI tracking
Certification
- Microsoft Power BI Data Analyst Associate Certification
- Microsoft Office Specialist: Excel Expert (Office 2019)
Timeline
Senior Data Solutions Analyst
Liberty Mutual Insurance
11.2022 - 02.2026
Assistant Center Director and Lead Instructor
Mathnasium
05.2021 - 07.2022
Senior Client Data Specialist
Hannover Re
04.2021 - 11.2022
Data Solutions Analyst
Liberty Mutual Insurance
07.2017 - 11.2020
BBA - Management Information Systems and Finance, Business Analytics
Villanova University