 Manage team of actuarial specialists responsible for setting provider reimbursement and capitation rates across Medicaid.  Program manager for all rate updates, contract renewals and certification packages for bureau of financial services. Regularly interact with senior management and external partners to coordinate cross-functional initiatives to ensure projects remain on schedule and meet scope requirements. Built MS Access database model using extensive VBA to standardize the process and track changes of coverage and pricing for medical procedures to replace existing process. Identified and in the process of executing multiple process improvement initiatives to improve consistency, reliability and accuracy across the department. Write SQL queries to mine data from multiple massive Medicaid data sources and perform various analysis on the data. Published my findings to senior leadership and legislators, making my analysis easy to understand and delivering impactful conclusions.

 Evaluated all MIS across the organization and established strategic priorities Standardized reporting protocols and setup governance structure across organization Produced monthly reporting package (PowerPoint) of all risk oversight activities that was delivered to board of directors, executive committees and regulators• Improved content and message of the report by formalizing the process to gather information from multiple providers• Devised quality controls using VB to ensure numbering and formatting were consistent and compliant with policy• Reduced handling time by several hours per cycle by automating content updates and quality controls using VB Managed the program plan for the entire Risk Oversight function• Established milestones and deadlines for major initiatives• Identified linkages and dependencies across the organization and discovered critical tasks to be completed before they became regulatory issues• Ensured all risk oversight responsibilities were carried out and completed on time Designed and executed issue tracking system that was used across organization to oversee risk issues• Consolidated multiple ad hoc tracking methods to have a single source of tracking• Created self-service functionality and ability to analyze details Recognized inefficiencies and led team through execution of improving multiple process improvements• Built automated workflow tools in SharePoint to manage approvals of policy changes• Consolidated disparate sources and calculation of metrics which reduced errors and handling time while improving accuracy and efficiency

Reporting & Analytics Designed and built a new reporting model from scratch to inform executives of regulatory issues• Initiated automated technical solutions to manage data and facilitate analysis• Standardized reporting process model which ensured accuracy and consistency• Established strong quality control process which minimized risk of errors and enhanced understanding of information being reported Analyzed regulatory operational issues and identified trends, key themes, risks and financial impacts• Presented my conclusions to senior executives on a regular basis• May of my recommendations for improvement were applied to business unit goals which improved customer satisfaction and reduced compliance exposures Collaborated with business & tech organizations to develop data warehouse for common data needs• Produced standardized templates for automated input of data into warehouse• Employed flexible warehousing principles which maximized efficiencies and data quality Developed transition plan of data management model to new warehouse structure Dissected data ownership and data management for approval process of new accounts• My conclusions and recommendations helped drive the creation of a data ownership function across the company Learned brand new software package to automate data file workflows (Decisions, Inc.) without the aid of user manuals or other experienced users• Software was purchased and implemented before user manuals were created• Utilized trial and error methods to experiment with software which enabled my team and I to learns the intimate details of the software• Constructed a working model that computerized the management of incoming data files

Business Planning, Financial Analysis & Reporting CFO Pinnacle Award winner (awarded to the top 50 finance employees globally) Prepared weekly/monthly sales reporting and income statements  Analyzed actual results against forecast and determined cause & explanations for variances Forecasted sales and income/expenses for multiple new products in a high growth business unit Integrated multiple reporting modules and created a Management Reporting model capable of reporting income statements by region, market, product & sales channel• Developed driver methodology that allocated revenues and expenses to markets and products and produced detailed P&Ls• Creatively applied multiple levels of drivers to accurately allocate P&L lines Built from the ground up comprehensive reporting package that dissected new product performance• Gathered multiple new data points from different reporting tools that improved insight into and enabled an all-inclusive view of important product behaviors• Introduced new KPIs to monitor performance of developing products• Standardized dashboard reports which enable horizontal comparisons across all products Redesigned global sales and income statement reporting models using Cognos• Eliminated inefficiencies that shortened processing time by 90%• Added ability to analyze sales by product, channel, currency and market• Consulted with industry experts to ensure best practices were leveraged and implemented Managed global planning and forecasting process across multiple product lines and business units• Created templates that facilitated forecasting and enabled automation• Recognized business drivers that predict future revenues and expenses• Built process to integrate data from multiple sources into a single source which improved evaluations and reduced incorrect conclusions Developed scorecard reporting and KPIs to monitor performance of new and legacy products

 Liaised with business partners which ensured that new products and sales channels had sufficient process controls to protect company assets Identified $8 million compliance exposure, developed and implemented a plan to remedy the situation immediately and put into operation long term plan to eliminate exposure Oversaw entire abandoned property and escheatment procedures and policies Revamped old escheatment procedures which simplified the process and saved time and money

 Taught business management and accounting courses in class room Coached students on reports and presentations