Analyst, Financial Planning and Trend Analysis
Humana, Inc.
Total years of experience :18 years, 4 Months
Responsible for determining trends for Medicare and Commercial business and maintaining databases of medical facilities in the United States.
• Analyzed data to monitor trends and initiatives for local markets to increase revenue and decrease costs, saving millions of dollars
• Maintained databases consisting of over 50, 000 medical facilities to accurately allocate billions of dollars of medical claims to individual facilities using SQL Server, SAS, and SSIS
• Kept up to date with hospital transactions and changing government regulations
• Updated and maintained SharePoint sites for the team
Accepted various assignments for several non-profit organizations.
• Analyzed financial donations, producing reports and ensuring the accuracy of data
• Responsible for recruiting, scheduling, and organizing volunteers
• Delivered oral presentations at organizational meetings
Analyzed the purchasing and distribution of prescription drugs by all Pharmerica pharmacies throughout the United States.
• Developed and produced monthly financial reports, accurately tracking the purchasing and distribution of items valued in the tens of millions of dollars
• Performed data analysis on cost management, utilization management, pricing models and other client performance metrics via SAS Enterprise Guide, Microsoft Excel, Microsoft Access and Hyperion Brio
• Determined trends and changing market patterns in order to establish cost saving opportunities
• Created internal reports to forecast and maximize revenues and assist in contract evaluations
• Developed SQL-based queries in SAS and macros in Visual Basic for Microsoft Excel
Responsible for auditing interpreted court-ordered documents for garnishment services national account clients for accuracy and providing feedback for associates interpreting orders.
• Promoted to Auditor after only eight months of working as a specialist
• Had the lowest error rate in the department, resulting in zero judgments and zero security breaches, saving time and hundreds of thousands of dollars
• Responsible for auditing 19 clients, the most clients for any auditor
• Exceeded daily quota of 180 orders by auditing approximately 230 court orders daily
• Recognized in the monthly Associate Recognition Meeting for 100% accuracy for 2 consecutive months
Interpreted court ordered documents for national account clients, utilizing in-depth knowledge of rules and regulations for all types of liens and ADP systems.
• Interpreted 90+ orders on a daily basis when the standard was 60 orders for a 12 month tenured specialist
• Recognized five different times in the monthly Associate Recognition Meetings for significantly exceeding standards and assisting other teammates
• Trained new employees from El Paso, TX on company procedures
Concentration in Economics Completed a 4 year degree in 2 years