Brannen H. Email & Phone Number

Tampa, FL, US

Tampa, FL

• Manage and develop WellCare interns gain a better understanding of the WellCare business; focusing on SAS, excel best practices, and company knowledge.
• Manage company’s drug pipeline financial impact. Look for up and coming high spend drugs and run analysis to understand the dollar impact it could possibly have.
• Work closely with actuary to make sure we are within range on our Early Read Forecast against our budget.
• Utilize SAS and excel to automate monthly reports that are dynamically designed for upper management to easily manipulate, understand, and make decisions.
• Oversee the day-to-day pharmacy analytics ad hoc email folder to set realistic timeframes with stakeholders and work with teammates to disperse ad hoc analysis based on expertise and current workload.
• Develop excel dashboards from ground up based on upper management needs.

Tampa, FL

• Helping buyers and sellers find their dream home!
• Developed a buying/selling scenario dashboard that helps my clients understand every cost or fee associated with buying/selling a home within $200 accuracy.

Tampa, FL

• Managed Clients: American Claims Management, Everest National Insurance, Sedgwick, and Southwest Airlines.
• Managed the largest PBM client, Sedgwick. Consisted of thousands of fortune 500 companies under the carrier and brought in around $500 million revenue annually.
• Automated all of the monthly reports through MicroStrategy, which required no human intervention. Helped spread this knowledge through the Informatics team.
• Utilized excel dashboard and VBA skills to create an automated QBR (Quarterly Business Review) dashboard that reduced QBR time from 7-10 days of creation time to 2 hours or less.
• Lead the analysis on compound drugs and how to combat the exorbitant cost and usage. Led to the installment of a PA (Prior Authorization) review on all compound drugs to determine medical necessity, thus reducing the.
• Tools: Access, Excel, PowerPoint, Word, SalesForce, MicroStrategy, TOAD Data Point, Tableau

Tampa, FL

• Managed Clients: Arrowpoint Capital, Everest National Insurance, John’s Eastern Company, Southwest Airlines, and Kentucky Employers Mutual Insurance.
• Spearheaded the drive in Southwest Airlines to become one of our best in class clients, achieving a savings rate of around 47%.
• Proactively researched a program that would help drastically lower opioid spend and keep active workers healthy and at a lower risk of injury.
• Took on the company’s most intricate client, Everest National Insurance that consisted of five different companies rolled into one. Developed a great relationship with the account manager, brought all of their ad hoc.
• Utilized Microsoft Access to create a database fix for importing data until IT could set up an automated FTP to upload into our database system.
• Tools: MicroStrategy, TOAD Data Point, Tableau, Excel, Access, PowerPoint, Word

Orlando, Florida Area

• Resolved complex participant issues including conducting research, analyzing plan provisions, and translating provisions to the ongoing processing environment.
• Collaborated with a team member to develop an excel calculator that would calculate all of Nationwide Insurance plan provisions without human intervention. Shared excel calculator with the team and increased production.
• Heavily utilized excel and attention to detail while working on peoples’ pension funds.
• Team lead on developing a master spreadsheet for data entry and pulling system queries.
• Utilized exceptional customer service skills to attract and retain high-value customers.

Winter Haven, FL

• Researched new fiber glass techniques to improve cost effectiveness.
• Company visits to boat plants to evaluate application of tools so we can design the best process or a new tool for the company.

Bachelor'S, Finance, General

High School