Rachel R. Rozell
Ankeny
Summary
Experienced with analyzing market trends and user needs to support product development. Utilizes data-driven insights to inform strategic decisions and enhance product offerings. Strong understanding of cross-functional teamwork and agile methodologies to ensure successful product lifecycle management.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Product Management Analyst
Berkley Technology Services
Urbandale, Iowa
05.2024 - Current
- Develops and manages complex insurance requirements into product user stories
- Tests and monitors products for quality assurance
- Consults and builds relationships with cross functional stakeholders
- Reduced 80% keystrokes by implementing XML scraping and mapping of Acord data
Agency Development Analyst
EMC Insurance
Des Moines, Iowa
07.2023 - 05.2024
- Creating and enhancing Power BI dashboards and reports delivering actionable insights
- Gathering, analyzing, and presenting national agency performance data to senior leadership
- Utilizing vendor platforms to research leads lists and industry information
P&C Competitive Intelligence Analyst II
Farm Bureau Financial Services
Des Moines, Iowa
12.2021 - 07.2023
- Performed ETL process with R, SQL, and Excel
- Created reports and visualizations with actionable insights for actuarial team
- Monitored SERFF state filings for research into qualitative and quantitative market trends
- Collaboration contact for external vendors, focused on competitive industry data
Associate Business Analyst
RUAN Transportation
Des Moines, Iowa
06.2021 - 12.2021
- Documented user stories/use cases, process/data flows and scenarios utilizing Jira
- Created Power BI reports to analyze specific data requests
Account Manager
Assured Partners
Des Moines, Iowa
01.2015 - 07.2020
- Managed and retained diverse portfolio of middle market hospital, healthcare commercial accounts
- Participated in data migration to new agency management system
- Trained account coordinators on system use and procedures
Education
BS - Business Management/Management Information Systems
Iowa State University
Skills
- Commercial Insurance P&C
- Product Management
- Personal Lines P&C
- Relationship Management
- Industry trend analysis
- Sprint planning
- Agile Methodology
- Data Analysis
- Product requirement documentation
- Stakeholder management
Certification
CPCU
Timeline
Product Management Analyst
Berkley Technology Services
05.2024 - Current
Agency Development Analyst
EMC Insurance
07.2023 - 05.2024
P&C Competitive Intelligence Analyst II
Farm Bureau Financial Services
12.2021 - 07.2023
Associate Business Analyst
RUAN Transportation
06.2021 - 12.2021
Account Manager
Assured Partners
01.2015 - 07.2020
BS - Business Management/Management Information Systems
Iowa State University