Collin Evers Email & Phone Number

Pharmacy Economics - Pathwell Network Specialty Drug Analytics

Pricing Methodology and Transformation Team supporting Europe and Global Segments

Tampa, Florida, US

• Highly involved in Medicare Advantage Dashboard Product team WAHOO, primarily with:
• Designing a large portion of the initial SQL automation process from scratch
• Assisting in Power BI Visualization design and integration with SQL process, including DAX coding in Power BI for dynamic data aggregations and filtering
• Servicing 3 clients monthly with Data processing, assumption updating, and refreshed dashboards
• Maintained ownership of MA and PD Bid pricing models for two clients (one each on MA and PD side)
• Assisted in three projects for CMMI Value-Based Care program strategy or settlement reconciliation

Tampa, Florida, US

My main project for the summer was developing a Monte Carlo Claims Simulation tool from scratch. The tool is intended to assist Provider and Payer clients in analyzing the range of potential outcomes in Value-Based Risk sharing contracts using Simulation and dynamic modeling. The tool also incorporated input features for quicker analysis of contracts for.

Chicago, Illinois, US

Gained knowledge and Assisted the Value-Based Care Strategic Initiative team in writing a white paper about Provider Actuary work. I learned new concepts as well as how Value-Based Care is being implemented in practice while taking in notes from many professionals and other sources and generating the initial sections of the white paper.

Madison, WI, US

Aided professors in Market Research for the purposes of creating new Masters and Undergraduate Minor programs in Business Analytics within our Business School.

Bloomfield, CT, US

• Reconciled Bond Market Yields between Internal data and 3rd party asset manager data and educated my team on factors driving data discrepancies in addition to suggesting improvements
• Modeled Net Investment Income projections and allocations for European business entities
• Utilized Diver Database software, Bloomberg API software, and Microsoft Excel for data pulling and analysis
• Documented credit and exposure risk review procedures for time deposits in International Markets to ensure compliance
• Learned about Health Insurance and Investment Portfolio Management through speakers and informative meetings
• Collaborated with Interns in Nashville while participating in a 3-day Healthcare Pricing and Underwriting case study

Appleton, Wisconsin, US

• Quoted Insurance Premiums and analyzed package options for clients using Auto Rating software
• Aided in customer acquisition and retention by finding clients better rates or coverage options
• Built professional skills by sitting in on meetings with carrier representatives and sharing my findings about their rates and competiveness throughout our quoting processes

Prairie Du Sac, WI, US

• Demonstrated stress management skills through working lead positions in the front of the store
• Negotiated solutions with guests and was held responsible when managers were off the floor
• Trained new employees on company practices, safety procedures, and quality assurance
• Contributed to our store becoming National “Crew Challenge” Champions in 2013

Bachelor Of Business Administration (B.B.A.), Actuarial Science | Finance, Investment, And Banking | Risk Management & Insurance

Education record