Cynthia Baumann Email & Phone Number

Tampa/St. Petersburg, Florida Area

Tampa/St. Petersburg, Florida Area

• Provide ad hoc reports and ongoing reports to end users and state entities regarding dental insurance activity.
• Recoded approximately 60% of monthly reports upon start of employment due to SQL errors in code.
• Assisted in automation project by compressing 80% of the total SQL dashboard code to speed up processing time on the server.
• Liaised with account managers and functional areas to improve accuracy of reporting and eliminate miscommunications, improving timeliness of reporting by 10%.
• Documented processes and procedures to assist with onboarding of new employees and trained and mentored incoming personnel.

Madison WI

• Analyze reimbursement scenarios for use in hospital contract negotiations, maintain hospital reimbursement per contracts, work closely with other functional areas, and document all internal processes.
• Ensured accurate compensation and bonus reports for client agencies and internal departments such as Sales and Retention.
• Introduced a SharePoint database that interfaced with SAS and expanded access to web-based data by 80%.
• Ensured state and federal regulation compliance through creation and maintenance of Process and Procedure documentation.

Madison, Wisconsin

• Provide ad hoc reports and Excel workbooks to multiple clients in healthcare industry, offering analysis of market trends and consumer behavior.
• Co-managed a national health-system account and decreased client’s monthly reporting turnaround time by 50% (40 FTE hours) through Excel VBA programming.
• Introduced analysis of the effectiveness of marketing strategies for General Surgery service line by comparing timing of patient utilization versus timeliness of marketing communication. Account managers adopted.
• Empowered a call center client to accurately monitor KPIs for performance evaluations and review purposes via reporting that our team created. Decreased client’s reliance on hand-written tracking by 90%.
• Trained or mentored 30% of team members.