Data Analyst & Data Scientist

Ache Wakai

Data Analyst Data Scientist

Chicago, IL • 832-***-**** • *********@*****.***

PROFESSIONAL SUMMARY

Data Analyst Data Scientist with 4+ years of experience in data analysis, business intelligence, and data visualization. Holds an M.S. in Data Science, a Microsoft Power BI certification, and an Oracle certification. Proven ability to translate complex, multi-source datasets into actionable insights across healthcare, financial services, and government sectors. Skilled in Python, SQL, DAX, and ETL pipelines, with a track record of building scalable dashboards, automating reporting workflows, and enabling data-driven decision-making across cross-functional teams.

WORK EXPERIENCE

Data Analyst Apr 2025 – Jul 2026

Rose International – Kansas Dept. for Children & Family • Remote

•Power BI Development – Served as the primary Power BI developer, designing and maintaining interactive dashboards, KPI scorecards, and Excel-based analytical reports used by program directors and field offices to monitor placement stability, caseload trends, and compliance metrics.

•ETL Pipeline Engineering – Built robust ETL pipelines using Power Query (M Language) to clean, normalize, and consolidate data from disparate source systems, reducing manual prep time and improving downstream data reliability.

•Power BI Service Administration – Managed Power BI Premium capacity, configured deployment pipelines across workspaces, and governed data lineage and impact analysis to ensure scalable, well-structured BI environments.

•Advanced DAX Modeling – Authored complex DAX measures for caseload distribution, placement duration, worker-level KPIs, and cross-report filtering, enabling intuitive self-service analytics for non-technical staff.

•Stakeholder Requirements Analysis – Partnered with program managers, supervisors, and policy teams to translate operational needs into scalable semantic models and automated reporting solutions.

•Data Quality & Governance – Conducted routine data quality checks, schema validations, and anomaly detection to ensure accuracy across ingestion, transformation, and reporting layers.

•Training & User Adoption – Led Power BI training sessions and user enablement workshops, increasing self-service analytics adoption and building confidence in data-driven decision-making across teams.

Senior Data Analyst Oct 2024 – May 2025

Strategic Staffing Solutions – Capital One • Remote

•Dashboard Development – Built and maintained interactive Amazon QuickSight dashboards and parameter-driven reports, integrating multi-source datasets to deliver real-time operational KPIs and performance insights.

•Data Quality Automation – Designed and executed end-to-end data validation workflows, implementing schema checks, anomaly detection, and reconciliation logic to ensure accuracy across ingestion, transformation, and reporting layers.

•Python Analytics – Leveraged Python (pandas, NumPy, matplotlib) for exploratory data analysis, statistical profiling, and custom data visualizations on large structured and semi-structured datasets.

•SQL Optimization – Developed and optimized SQL scripts for database updates, view creation, and stored procedures across relational databases, improving query performance and supporting downstream BI consumption.

•Data Warehouse Modeling – Contributed to star-schema designs, dimensional modeling, and pipeline reliability improvements to support scalable analytics infrastructure.

•Analytics-Driven QA – Supported QA teams through defect triage, root-cause analysis, and data-driven troubleshooting; bridged the gap between engineering and analytics to accelerate issue resolution.

Government Programs Analyst Apr 2022 – Jul 2024

Blue Cross Blue Shield of Kansas City • Kansas City, MO

•ETL Development – Engineered end-to-end ETL pipelines using SAS, Alteryx, and Power Query to ingest, normalize, and integrate multi-source healthcare datasets into Power BI semantic models supporting ACA and Medicare Advantage analytics.

•Clinical Coding Analytics – Applied ICD-10, CPT, and HCPCS coding frameworks to validate encounter data, enhance feature engineering, and ensure regulatory alignment for CMS Risk Adjustment models and audit-ready reporting.

•Regulatory Data Operations – Managed ACA and Medicare Advantage enrollment and claims submissions through EDGE server and RAPS/EDS pipelines, performing data integrity checks, schema validation, and discrepancy resolution with CMS technical teams.

•Cross-Functional Collaboration – Served as analytical liaison between Clinical SMEs and engineering teams, translating medical documentation issues into actionable data requirements, and resolving defects impacting Risk Adjustment scoring and compliance reporting.

•Workflow Optimization – Re-architected Alteryx workflows to streamline data ingestion and transformation logic, reducing processing time by 20% and significantly lowering downstream error rates across automated reporting pipelines.

•Risk Score Analytics – Conducted advanced data mining and pattern analysis to identify coding gaps, improve HCC capture accuracy, and refine member risk stratification models used for targeted outreach and financial forecasting.

•Data Literacy Enablement – Led stakeholder workshops to strengthen organizational data literacy, transitioning operational teams from intuition-based decisions to evidence-driven analytical practices supported by Power BI insights.

EDUCATION

M.S. in Data Science Sep 2019 – Jun 2022

University of St. Thomas — St. Paul, MN

M.S. in Environmental Sanitation Sep 2003 – Jun 2005

University of Ghent — Ghent, Belgium

B.S. in Biological Sciences Jan 1993 – Jun 1997

Ahmadu Bello University — Zaria, Nigeria

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate – IC7548-8F8A29 2025

Oracle Certified Associate (OCA) Oracle

TECHNICAL SKILLS

Data Visualization

Power BI (Certified), Tableau, Amazon QuickSight, Looker, Excel

Programming

Python (pandas, NumPy, matplotlib, scikit-learn), SQL, R, MATLAB

ETL & Data Engineering

Alteryx, SAS, Informatica, Power Query (M Language)

Databases

Oracle (Certified), MySQL, MSSQL, DB2, Cassandra, Snowflake

Reporting & Metrics

DAX, KPI Modeling, Stakeholder Reporting, Data Storytelling

Data Analysis

Exploratory Data Analysis, Statistical Profiling, Anomaly Detection, Root-Cause Analysis

Machine Learning

TensorFlow, PyTorch, Regression, Classification, Hypothesis Testing

Cloud & Big Data

AWS, Hadoop, Spark, Snowflake

Tools & Platforms

JIRA, MS Office Suite, Visio, Power BI Service, Deployment Pipelines

Soft Skills

Cross-functional Collaboration, Stakeholder Communication, Training & Mentoring, Data Literacy

Contact this candidate