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.

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.

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 modified communication strategies based on the findings of this research.• 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.