Carrie Rondo
Reese,MI
Summary
Accomplished Senior Business Systems Analyst with a proven track record at Frankenmuth Insurance, specializing in ClaimCenter & ContactManager systems. Excelled in data analysis and SQL proficiency, leading system conversions and enhancing user experiences. Demonstrated exceptional teamwork and problem-solving abilities, ensuring regulatory compliance and system integration success.
Overview
31
31
years of professional experience
Work History
Senior Business Systems Analyst
Frankenmuth Insurance
05.2020 - Current
- Provided primary support for Claim Financials, 1099 reporting, Medicare reporting process, and Contact Manager Vendor entry as well as syncing processes between centers,
- Optimized team performance by providing SQL Server training to Claims DEV Team's Business Systems Analysts.
- Developed customized SQL reports for Claims Product Owners and Managers, meeting specific department needs within company while ensuring data accuracy and accessibility.
- Championed efforts to ensure ClaimCenter Medicare reporting compliance in accordance with regulatory guidelines within our system design.
- Led cross-functional teams to deliver a system integration with a new vendor to offer more payment options for our customers.
Business Systems Analyst III
Frankenmuth Insurance
06.2016 - 05.2020
- Spearheaded Claim system conversion from Exceed Claims into Guidewire to enhance claims user experience and ensure seamless transition for Adjusters into new system.
- Analyzed existing Exceed Client system and database to lead conversion of Vendor data into Guidewire ContactManager.
- Facilitated communication between technical and non-technical team members, ensuring project alignment for Predictive Analytics (WC Severity model) across all parties involved.
- Identified and mitigated potential risks to business operations by conducting detailed systems analysis in preparation for Guidewire ClaimCenter V10 upgrade.
Business Analyst II
Frankenmuth Insurance
05.2002 - 05.2020
- Supported PL Policy Lines of Business in iBIS (SQL Platform).
- Led and Implemented Personal Umbrella policy entry processing in iBIS policy system.
- Provided lead analytical support in implementation of Exceed Client system on aDB2 platform and integrated batch process between Exceed Client and PMS.
- Supplied system assistance to internal business staff as well as our agents and insureds by answering support calls.
- Developed Databridging processes with multiple comparative rating software companies utilizing ACORD and XML file structures.
Business Analyst
Frankenmuth Insurance
10.1998 - 05.2002
- Interacted with internal customers to understand business needs for Personal Policy Lines of Business and translate those into requirements and project scope.
- Streamlined GTAM table update processes.
- Enhanced Policy Management System by implementing fixes in COBOL code logic.
- Utilized programming tools such as XPEDITER, File Aid, and JCL.
- Integrated Policy system with AIS system for MVR reporting and implementation of Automated MVR Attribute Assignment process for IDSS.
- Performed internal system acceptance to deliver well-tested enhancements and meet business requirements.
I.T. College Intern
Frankenmuth Insurance
05.1996 - 10.1998
- Assisted full-time employees on projects as needed, demonstrating flexibility and eagerness to contribute effectively to any task assigned.
- Maintained Ratefile and GTAM tables in PMS legacy policy system.
- Created test matrices and conducted extensive testing of PMS legacy policy system changes.
- Exceeded expectations set forth by supervisors throughout various aspects of the internship program while maintaining a strong academic performance at college simultaneously.
Work Study Student
SVSU Admissions Office
09.1993 - 05.1997
- Conducted campus tours for prospective students and parents, enhancing university's recruitment efforts.
- Managed an organized filing system for important documents from prospective students, ensuring easy access when needed.
- Completed data entry to produce various acceptance and denial letters for prospective students.
Education
Bachelor of Science - Accounting And Computer Science
Saginaw Valley State University
Bay City, MI05.1998
Skills
- ClaimCenter & ContactManager expertise
- Defect Identification & Root Cause Analysis
- Application support
- Data Analysis
- SQL Proficiency
- Data Mapping
- Use Case Development
- Team liaison
- Requirements Gathering
- Teamwork and Collaboration
- Attention to Detail
- Problem-solving abilities
Timeline
Senior Business Systems Analyst
Frankenmuth Insurance
05.2020 - Current
Business Systems Analyst III
Frankenmuth Insurance
06.2016 - 05.2020
Business Analyst II
Frankenmuth Insurance
05.2002 - 05.2020
Business Analyst
Frankenmuth Insurance
10.1998 - 05.2002
I.T. College Intern
Frankenmuth Insurance
05.1996 - 10.1998
Work Study Student
SVSU Admissions Office
09.1993 - 05.1997
Bachelor of Science - Accounting And Computer Science
Saginaw Valley State University
Similar Profiles
Aaron WheelerAaron Wheeler
Commercial Lines Underwriting Assistant at Frankenmuth InsuranceCommercial Lines Underwriting Assistant at Frankenmuth Insurance
RYAN HAGARTYRYAN HAGARTY
Field Manager at Frankenmuth InsuranceField Manager at Frankenmuth Insurance
Rachel SimmonsRachel Simmons
Personal Lines Territory Lead Underwriter III at Frankenmuth InsurancePersonal Lines Territory Lead Underwriter III at Frankenmuth Insurance