Colleen Hickman Email & Phone Number

Madison, Wisconsin, United States

• Identified opportunity to increase the value of core Rebate product offering and subsequently led a cross-functional Agile team of developers and product analysts in the research, discovery, design, development, and implementation of a forecasting methodology that resulted in up to 18% improvement in financial guarantees offered in RFP responses.• Created a QlikView program that quantifies the value of Navitus’ formulary and utilization products by way of estimating avoided drug… Show more • Identified opportunity to increase the value of core Rebate product offering and subsequently led a cross-functional Agile team of developers and product analysts in the research, discovery, design, development, and implementation of a forecasting methodology that resulted in up to 18% improvement in financial guarantees offered in RFP responses.• Created a QlikView program that quantifies the value of Navitus’ formulary and utilization products by way of estimating avoided drug costs. Results used to monitor performance toward guarantees, validate clients’ purchase decision and to communicate sustained value of services. Program demonstrated $95k in savings beyond guarantee for a hospital system client with 7,000 members.• Leverage curiosity, intuition for problem-solving, deep knowledge of business operations and industry benchmarks with nearly a decade of experience developing business intelligence solutions to analyze data, distill insights, and deliver effective data stories that enable stakeholders to make informed business decisions. • Support sales in responding to RFPs by ensuring strategy alignment among analysts, supplying rebate forecasting assumptions, and synthesizing inputs for risk assessment. Further, I use Monte Carlo simulations to evaluate the risk to the organization of missing guarantees and use analysis insights to inform guarantees and pricing strategy.• Partner with pharmacists and pricing teams to adjust prospective pricing models as needed based on evidence of headwinds and tailwinds.• Collaborate cross-functionally on the development of materials used for sales and marketing initiatives including case studies, podcasts, white papers, blog posts, annual publications, RFP positioning and finalist presentations Show less

Madison, Wisconsin Area

Madison, Wisconsin Area

• Leveraged descriptive and diagnostic analytics to support wide range of departments and initiatives across the organization. Provided consultation and delivered actionable takeaways and recommendations based on research, identification of trends, patterns and outliers, data modeling, and distilled insights.• Partnered with PharmD/Director of Clinical Informatics to research, analyze and provide most metrics and data-visualizations published in annual Navitus Drug Trend Reports (2016… Show more • Leveraged descriptive and diagnostic analytics to support wide range of departments and initiatives across the organization. Provided consultation and delivered actionable takeaways and recommendations based on research, identification of trends, patterns and outliers, data modeling, and distilled insights.• Partnered with PharmD/Director of Clinical Informatics to research, analyze and provide most metrics and data-visualizations published in annual Navitus Drug Trend Reports (2016 -2020).• Co-lead a cross-functional team in the content redesign and report automation of client annual performance presentations, resulting in improved client engagement and saving the company around 3,000 hours annually of manual work.• Contributed to client retention initiatives by supporting Account Managers in customer crisis management by analyzing client drug cost trends and modulators, distilling often complex analyses into simple and concise messages, and effectively communicating the data story to clients. Show less

Madison, Wisconsin Area

Madison, Wi

• Gathered requirements, designed and developed dozens of purpose-driven business intelligence dashboards and reporting solutions used to alert staff of inappropriate claim rejections, identify members subject to therapy disruption, and model financial impact of plan design changes.• Converted complex compliance monitoring program used to support Medicare Part D audits from SAS into QlikView.• Proactively created and implemented department onboarding process, enabling new hires… Show more • Gathered requirements, designed and developed dozens of purpose-driven business intelligence dashboards and reporting solutions used to alert staff of inappropriate claim rejections, identify members subject to therapy disruption, and model financial impact of plan design changes.• Converted complex compliance monitoring program used to support Medicare Part D audits from SAS into QlikView.• Proactively created and implemented department onboarding process, enabling new hires to contribute quickly and build a common foundation of terminology and processes across the team.• Mentored two junior analysts through onboarding and guided their development into competent QlikView developers and subject matter experts. Both are now leaders in the organization. Show less

• Analyzed website traffic for leads using HubSpot, developed customer profile reports and communicated results weekly to Sales and Marketing Vice President• Identified several prospective clients, resulting in proposals to McKesson, Hewlett Packard and Disney

Olathe, Ks

• Directed teams of 50-60 divers, ages 6-18 and supervised two assistant coaches. Responsible for planning and conducting diving competitions for up to 90 athletes and 10 event support staff.• Managed all facets of the competitive dive team including mentoring both beginning and accomplished athletes in learning new skills, creating and maintaining rapport with athletes, and directing communication among parents.• Lead the women’s gymnastics team to win the KS State Championship… Show more • Directed teams of 50-60 divers, ages 6-18 and supervised two assistant coaches. Responsible for planning and conducting diving competitions for up to 90 athletes and 10 event support staff.• Managed all facets of the competitive dive team including mentoring both beginning and accomplished athletes in learning new skills, creating and maintaining rapport with athletes, and directing communication among parents.• Lead the women’s gymnastics team to win the KS State Championship competition and two medalists in the KS State Diving Championship. Show less

Lawrence, Kansas Area

• Prepared and supervised distinct lesson plans for small group settings• Utilized unique teaching methods appropriate for students’ specific needs