Avatar

Antonio Williams

Data & Analytics (Python & SQL) Developer

Atlanta, GA

antoniowilliams123@gmail.com

(770)595-6084

Skills

Health & Group Benefits Domain Knowledge

99%

Underwriting, Budgeting & Forecasting

99%

Exploratory Data Analysis

99%

Coding & Report Automation

99%

Python

99%

Data Science

98%

Storytelling with Data & Financials

98%

SQL

98%

Tableau (Data Visualization)

98%

Power BI (Data Visualization)

98%

Microsoft Excel

98%

Microsoft PowerPoint

98%

Web Development

98%

Time Series Analytics

98%

Data Science Libraries

Pandas

100%

Numpy

98%

Openpyxl

98%

PyAutoGUI

98%

Selenium

98%

Matplotlib

98%

Plotly

98%

Seaborn

98%


Work Experience

Blue Cross Blue Shield of North Carolina
12/2019 - 4/2023 (Remote)

Senior Business Intelligence Developer/ Senior Data Engineer - Client Reporting Team | Analytics & Insights

  • Provided ad hoc analytical support to Sales and Healthcare Consultants regarding medical claims, utilization, and membership.
  • Developed autonomous scheduling code for medical claims and membership reports, automating their generation and deposit onto shared drives for internal recurring consumption.
  • Automated the company's MA-1099 letter operation using Python and SQL, accurately filling in thousands of PDF letters based on conditions and criteria.
  • Trained Analysts on leveraging Python to enhance the dynamism and parameterization of SQL for improved efficiency and scalability.
  • Delivered several successful projects through effective team collaboration and iterative development.
  • Wrote complex SQL queries to extract, transform, and analyze data from diverse databases, enabling actionable insights for stakeholders.
  • Played a key role in code remediation and data migration from Teradata to Snowflake, ensuring smooth transition & optimal performance
  • Gathered, wrangled, and cleaned data from various systems, providing clients with data-driven insights in reporting that enhanced healthcare strategy.
  • Streamlined monthly and quarterly Excel dashboards for Consultants, freeing up their time for more critical tasks.
  • Created an application that scans all SQL files saved on the shared drive to increase code reusability and provide easy access to reference points.
OneDigital Health and Benefits (formerly Northwestern Benefit Corporation)
4/2018 – 6/30/2019

Senior Analytics Consultant - Mid-Market / Large Market Clients

  • Developed outcome-focused data visualizations through clear dashboards, enabling clients to understand the effectiveness of their healthcare strategies.
  • Calculated healthcare cost projections and set budget rates for a range of self-funded clients, recommending design changes for improved dashboard performance.
  • Automated several algorithmic methods to reduce time to insight, increase accuracy, and improve engagement with other consultants.
  • Assisted clients in understanding employee plan utilization relative to benchmarks, actuarially pricing self-funded plans to ensure coverage of future costs.
  • Communicated data-driven insights to HR Leaders and C-Suite executives, discussing the financial impact of proposed strategy changes.
  • Streamlined predictive underwriting, data analysis, and autonomous reporting processes by transitioning from Excel to the Python programming language.
Regions Insurance Group (now McGriff, Seibels & Williams)
1/2015 – 3/2018

Senior Financial Analyst / Consultant – Employee Benefits Division - Mid-Market Clients

  • Tracked financial outcomes on a year-to-date and rolling twelve-month basis using dynamic dashboards connected to predictive models for continuous forecasting.
  • Delivered creative strategy recommendations to prospective clients, effectively illustrating financial savings opportunities to secure new clients.
  • Calculated underwriting and budget projections for self-funded clients, ensuring clear and effective communication of financial strategy content.
  • Communicated data-driven insights to HR Leaders and C-Suite executives, discussing both past and future financial impacts of healthcare strategy changes.
  • Improved the performance of the internal team by sharing reusable technology that addressed business intelligence and analytics challenges.
  • Collaborated with Analysts from other offices to develop predictive models that resolved a variety of reporting and analytics issues for the National team.
Willis Towers Watson
6/2014 – 11/2014

Senior Analyst II – Health and Group Benefits - Mid-Market Clients

  • Utilized Towers Watson tools and other resources to gather relevant data points for the development of client strategies.
  • Ensured appropriate utilization of strategy resources and clear communication of healthcare strategy content.
  • Mentored and trained Junior Analysts and Entry Level Actuarial Analysts in building custom financial models for self-funded clients.
  • Facilitated the RFP/Marketing process, involving top health and ancillary insurance carriers, and evaluated proposals to recommend the best options to clients.
Aon Hewitt
12/2011 – 6/2014

Health and Benefits Analyst - Mid-Market Clients

  • Provided analytical support to help employer-groups achieve strategic goals related to healthcare cost reduction and expense optimization.
  • Negotiated on behalf of clients during the RFP/Marketing process, delivering optimized health and benefits programs aligned with client expectations.
  • Calculated claims projections/budget forecasts and modeled alternative strategies for Large and Middle Market clients.
  • Assisted self-funded clients in designing intentional programs, leveraging BI tools to uncover data insights leading to actionable outcomes and tangible returns.
  • Collaborated with the Actuarial team and Consultants to deliver innovative health and group benefits strategies.
Anthem Blue Cross Blue Shield/WellPoint
1/2009 – 12/2011

Group Underwriter I, Group Underwriter II (National Accounts) 500+ Employees - New Business and Renewals

  • Partnered with Sales, Account Executives, and Actuarial teams to support profitable growth, increase membership, and foster long-lasting client relationships.
  • Managed risk, profit, and growth for a 21-employer group book of business, supporting the Underwriting Department's Annual Plan.
  • Consistently improved revenue, membership, and profitability over a three-year period.
  • Responded to RFP/RFI questionnaires in competitive bid situations, successfully winning new business and renewing existing clients. Played a key role in major wins.
  • Contributed to the development of "The Retention Model," a widely used predictive model that generated profitable fees based on projected expenses; used by Underwriters nationwide.

Education

Georgia State University
2004 - 2008

Bachelor of Business Administration - Managerial Science

Self Taught Python Developer
2015 - 2019

Late Nights... Reading and Watching Tutorials