Rockville, Maryland, United States
1. Improved Medicaid financials model with breakout by benefit category. Incorporated utilization data into medical expense variance analysis to provide insight analytics on cost drivers. 2. Developed revenue and expense forecast and budget for MAS by line of business and by jurisdiction. Investigated variance to identify risk/opportunity for strategic operational and financial decision. 3. Organized highly detailed information from multiple systems. Leverage Access, Excel, SQL and other financial tools to enhance reporting efficiency and quality. 4. Maintained budget system, validate budget information and manage overall revenue budget submission. Communicate effectively and timely in order to complete and meet deliverable timeline. 5. Redesigned premium and supplemental revenue forecast models to improve accuracy and ensure alignment with management priority.
•Drove monthly forecasting and annual budgeting processes. Monitored actual performance against budget and prior year. Identify trends and highlight significant operational performance issues to management team. •Delivered operational and financial reports in an accurately and timely manner. Provided business unites with analysis needed to advance their business goals. •Coordinated with seven regional finance teams to improve global workflow. Developed Hyperion models to improve reporting efficiency and quality.
•Created an automated investment evaluation model for ACCION Global Investments. Provided financial analysis and portfolio management for various investment vehicles. •Built quantitative models to track the performance of each investment across various financial, social, and risk dimensions for portfolio monitoring and evaluation.
•Developed a new evaluation model to reduce research cost. •Conducted data analysis and market research to evaluate efficiency of advertisement.