Ache W

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.

Data Analyst at Rose International – Kansas Dept. for Children & Family (2025-04 – 2026-07)

• 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 at Strategic Staffing Solutions – Capital One (2024-10 – 2025-05)

• 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 at Blue Cross Blue Shield of Kansas City (2022-04 – 2024-07)

• 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.

M.S. in Data Science – University of St. Thomas (2019-09 – 2022-06)

M.S. in Environmental Sanitation – University of Ghent (2003-09 – 2005-06)

B.S. in Biological Sciences – Ahmadu Bello University (1993-01 – 1997-06)