AHMAD T. STEVENS
Orangeburg
Summary
Professional data analyst with solid experience in data management and analysis. Strong focus on team collaboration and delivering actionable insights. Highly adaptable, reliable, and skilled in SQL, Python, and data visualization tools such as Tableau. Known for analytical thinking, problem-solving abilities, and effective communication.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Associate Data Analyst/ Software developer
Voya Financial
11.2021 - Current
- Analyzed and validated benefits enrollment, eligibility, and coverage data for 50,000+ members using advanced SQL across effective-dated HR and insurance tables
- Impact: Reduced enrollment discrepancies by 30% during audit and reconciliation cycles
- Built and optimized complex SQL queries (CTEs, window functions, multi-table joins) across enrollment, salary, role, and coverage datasets
- Impact: Improved query performance by 40%, cutting reporting turnaround from hours to minutes
- Investigated and resolved duplicated roles, incorrect coverage multipliers, and effective-date mismatches within Benefitfocus enrollment records
- Impact: Prevented $500K+ in potential billing and premium calculation errors
- Supported COBRA, voluntary life, and supplemental benefits by validating cancellations, reinstatements, and coverage changes for 10,000+ qualifying events annually
- Impact: Maintained 100% regulatory compliance and avoided member escalation issues
- Performed root-cause analysis (RCA) on enrollment defects by tracing data across upstream HR feeds and downstream reporting layers
- Impact: Reduced repeat production issues by 35% quarter-over-quarter
- Partnered with business analysts, QA, and operations teams to translate benefits policy and insurance rules into technical logic and data validation checks
- Impact: Shortened issue resolution cycles by 25%
- Developed reusable SQL validation scripts and reconciliation queries to support audits, production support, and open enrollment readiness
- Impact: Saved 10–15 analyst hours per week through automation
- Supported high-volume open enrollment periods impacting 20K–30K members per cycle, validating salary updates, elections, and coverage recalculations
- Impact: Reduced post-enrollment defects by 40%
- Applied software development best practices (Git version control, structured debugging, documentation) while supporting analytics and data workflows
- Impact: Improved knowledge transfer and reduced onboarding time for new analysts by 20%
- SQL: Advanced joins, CTEs, window functions, effective-dated logic (datasets with millions of rows)
- Data Analysis: Enrollment reconciliation, defect RCA, audit support
- Platforms: Benefitfocus, enterprise HR/benefits systems
- Domains: Employee benefits, insurance, COBRA, compliance
Epic Data Analyst
Boston Medical Center
10.2020 - 03.2021
- Rectified and resolved 400 medical claim denials encompassing various issues, which included a lack of prior authorization, duplicate services on claims, and telemedicine denial.
- Supported 200+ patients accurately via electronic health record system and filing.
Unit Supply Representative/ Logistics Analyst Secret, Security Clearance Opm
United States Army
02.2014 - 07.2017
- Drove 100% accountability for $4.7M in equipment through supervising a Change of Command with 129 personnel, serving as Supply Sergeant, accounting for property, and conducting inventory.
- Optimized $620,000+ in sensitive, mission-critical equipment by maintaining precise accountability.
- Supported $400,000+ in highly sensitive equipment by assisting with supervision and maintenance.
Education
Certiticate in Advance Graduate Studies CAGS - Data Science
Northwestern University
06.2027
MBA - Healthcare Management
South Carolina State University
01.2022
Tableau Data Analytics Certificate - undefined
Emory University
01.2021
Bachelor of Science - Health Education Services Minor Business Administration
South Carolina State University
01.2020
Skills
- ETL development
- SQL programming
- Machine learning
- Problem-solving
- Competitive analysis
- SQL and databases
- Decision-making
Certification
Technologies: CoLab, Jupyter Notebook, NumPy, Python, SQL, Tableau, Power BI, R, Excel
Timeline
Associate Data Analyst/ Software developer
Voya Financial
11.2021 - Current
Epic Data Analyst
Boston Medical Center
10.2020 - 03.2021
Unit Supply Representative/ Logistics Analyst Secret, Security Clearance Opm
United States Army
02.2014 - 07.2017
Tableau Data Analytics Certificate - undefined
Emory University
Bachelor of Science - Health Education Services Minor Business Administration
South Carolina State University
Certiticate in Advance Graduate Studies CAGS - Data Science
Northwestern University
MBA - Healthcare Management
South Carolina State University