Charlie Napier

Intensive full-time bootcamp focusing on data analytics fundamentals and problem solving. Used real-world datasets and included projects where findings were presented to stakeitolders from the community.

• Analyzed data using Microsoft Excel, including utilizing pivot tables and lookups, and connected to external data sources using the PowerPivot add-on
• Built and deployed dashboards using Tableau and PowerBI.
• Wrangled data and performed exploratory data analysis using Python's pandas library.
• Created data visualizations using matplotlib and seaborn
• Gathered data through APls and webscraping
• Performed geospatial analysis using geopandas and folium
• Retrieved and analyzed data using PostgreSQL and sqlalchemy
• Source code version control with Git/GitHub
• Project management/tracking with GitHub project boards and issue tracking

• Manages and tracks financials for employee benefits, catering to a portfolio of Chicago-based clients with a focus on claim trends and financial health
• Regularly coordinates with internal partners to review data trends, discuss strategy, and prepare for client meetings
• Presents financial updates and claim spending trends to clients, ensuring transparency and fostering informed decision-making
• Runs budget forecasts for various lines of employee health coverage and negotiates with health insurance carriers to secure cost savings
• Leads projects to streamline and standardize data analytics processes
• Helps facilitate the training and mentoring of new hires

• Managed a diverse portfolio of 40 clients across Tennessee and Iowa, servicing organizations with employee sizes ranging from 200 to 5,000
• Monitored and reported on monthly claim activities, ensuring clients received timely updates and accurate financial reporting
• Completed comprehensive underwriting projects encompassing cost forecasting, employee contribution modeling, IBNR claim analysis, and benefit plan benchmarking
• Participated in client meetings and conference calls to deliver financial consulting services, assess potential risks, and provide informed budget recommendations for upcoming policy periods

• Analyzed and managed risk for medical insurance quoting, ensuring accurate pricing for commercial clients with both fully insured and self-funded plans
• Facilitated collaboration with cross-functional teams to devise effective sales strategies for client acquisition and retention within a middle-market portfolio
• Contributed to the Renewal Projection Model Committee by participating in the testing of updates and enhancing efficiency through monthly strategic discussions