SIPHO MWAMBA
Atlanta
Summary
Data Analyst and Account Operations professional with experience applying SQL, Excel, R, and Power BI to drive data-informed decision-making. Skilled in regression modeling, KPI development, business intelligence automation, and translating business requirements into actionable insights. Proven ability to collaborate cross-functionally, solve complex problems, validate data integrity, and present compelling data stories that influence strategic decisions.
Overview
13
13
years of professional experience
2
2
Certifications
Work History
Traffic Operations Specialist
Atrium/Cox
08.2023 - Current
- Analyze contract lifecycle and operational data using Excel (Pivot Tables, VLOOKUP, XLOOKUP) to monitor KPIs and identify discrepancies.
- Utilize SQL to extract, validate, and reconcile contract and revenue data for reporting accuracy.
- Develop performance tracking reports to monitor contract revisions and activation timelines.
- Conduct data validation and quality assurance checks to maintain data integrity.
- Identify operational trends and escalate high-priority risks with recommended solutions.
- Collaborate cross-functionally with Sales, Traffic, Finance, and Operations teams.
- Recommend and implement process improvements to streamline workflows.
Data Analyst
YNB Business Consultant
05.2024 - 07.2025
- Built and validated linear regression models in R to forecast applicant conversion rates.
- Conducted descriptive, correlational, inferential, and predictive statistical analyses.
- Developed and automated Power BI dashboards, reducing manual reporting time by 40%.
- Translated business requirements into data models aligned with strategic priorities.
- Created executive-ready reports to influence hiring decisions.
Account Operations Data Analyst
SpectraForce / EcoLab
10.2023 - 04.2024
- Analyzed operational and sales data using SQL to support strategic decisions.
- Developed Power BI dashboards for Sales and Accounting teams.
- Validated and documented business requirements for analytics initiatives.
- Identified process inefficiencies and recommended data-driven improvements.
Business Immigration Analyst
Fragomen Immigration
09.2021 - 09.2023
- Collected, cleaned, and validated data using SQL and Excel.
- Developed weekly KPI reports and presented findings to leadership.
- Created Power BI visualizations to support forecasting and case management.
- Ensured compliance and maintained data governance standards.
Client Services Specialist
ExamOne
09.2016 - 09.2021
- Generated SAP reports and analyzed healthcare performance data.
- Conducted audits to improve data quality and accuracy.
- Researched discrepancies and provided resolution recommendations.
Insurance Case Manager
Quest Diagnostics
08.2013 - 08.2016
- Analyzed health insurance claims, call volume, and member service data to identify utilization trends, processing delays, and productivity gaps, implementing data-driven improvements that increased operational efficiency.
- Reduced claim routing errors and misdirected insurance inquiries by 16% within two months by analyzing workflow patterns and optimizing case assignment processes.
- Developed data-informed training documentation based on recurring claim and compliance issues, reducing member complaints by 35% and improving service accuracy.
- Ensured compliance with HIPAA regulations and data governance standards by conducting regular data audits, validation checks, and quality assurance reviews of protected health information (PHI).
Education
Master of Information Technology - Data Science
Middle Georgia State University
Macon, GABachelor of Science - undefined
Bellevue University
Bellevue, NESkills
- Data Analytics
- Predictive Modeling
- R Regression Models
- Statistical Analysis
- KPI Development
- Business Intelligence Reporting
- Dashboard Automation
- SQL (Oracle)
- Excel (Pivot Tables, VLOOKUP, XLOOKUP)
- Power BI
- Tableau
Certification
Data Analysis – General Assembly
Timeline
Data Analyst
YNB Business Consultant
05.2024 - 07.2025
Account Operations Data Analyst
SpectraForce / EcoLab
10.2023 - 04.2024
Traffic Operations Specialist
Atrium/Cox
08.2023 - Current
Business Immigration Analyst
Fragomen Immigration
09.2021 - 09.2023
Client Services Specialist
ExamOne
09.2016 - 09.2021
Insurance Case Manager
Quest Diagnostics
08.2013 - 08.2016
Bachelor of Science - undefined
Bellevue University
Master of Information Technology - Data Science
Middle Georgia State University