selftaught


Khanh "Dewy" Pham

PROFILE

  • Results-driven Data Scientist and Analyst with 5+ years of experience in Oklahoma state government agencies. Proven ability to acquire, clean, and analyze complex datasets, build predictive models, and translate findings into actionable insights for executive leadership. Expert in SQL, Python (Pandas, NumPy, Scikit-learn), Power BI, and Tableau for statistical modeling and data visualization. Experienced in stakeholder communication, data governance, policy compliance, and statewide data initiatives.

PROFESSIONAL EXPERIENCE

Oklahoma Tax Commission

August 2023 – Feb 2026

Business Analyst / Senior Data Analyst

  • Developed a predictive classification model using Python (Pandas, Scikit-learn) and SQL to identify patterns in fraudulent tax returns, reducing manual workload for the ITA team.
  • Applied regression models and time-series analysis to predict monthly tax trends during and post-tax season, supporting the Director of TRC with resource allocation decisions.
  • Analyzed Corporate Income Tax (CIT) filings to verify NAICS code accuracy, identifying 2,300+ discrepancies enabling improper tax exemption claims — findings reported directly to auditors.
  • Evaluated 37,000+ corporate income tax accounts (2021–2024), calculating Oklahoma taxable income and sales tax frequency to support auditor investigations and compliance enforcement.
  • Applied sentiment analysis algorithms to classify taxpayer communications, identifying emerging complaint patterns and informing agency response strategies.
  • Built automated ETL pipelines using Apache Airflow and Snowflake with dbt, delivering daily executive dashboards with SLA compliance and agent performance intelligence.
  • Developed REST API integrations (NICE inContact, HappyFox, Qmatic/OData) to extract and analyze contact center data, enabling pattern detection across platform engagement metrics.
  • Created PeopleSoft-based SQL solutions to track agency expenditures and revenue against budget projections across PS_VOUCHER, PS_PO_HDR, and PS_LEDGER tables.

Oklahoma Dept. of Mental Health & Substance Abuse

March 2021 – July 2023

Junior Data Analyst (Remote)

  • Collaborated on Federal grant projects, contracts, and state initiatives (State Opioid, Re-entry programs) to monitor financial KPIs and ensure funding requirements were met.
  • Created and optimized SQL stored procedures to generate weekly and monthly reports, significantly reducing manual report time from over 5 hours to just 5 minutes.
  • Developed an algorithm using Python/SQL to match client data to third-party apps (CHESS Health and Oklahoma Employment Security Commission), reducing manual matching time from 4 hours to 10 minutes.
  • Leveraged Tableau/Power BI to create visually engaging performance monitoring dashboards for administrators and stakeholders, evaluating treatment effect.
  • Gathered, transformed, and loaded data using Python/SQL/Power BI query from mental health, substance abuse, and caregiver surveys to the Agency's SQL Server for reporting in SSRS.

Oklahoma State University, ISSO

January 2017 – December 2018

Data Analyst/Tech Graduate Research Assistant

  • Implemented a flutter-based Android/IOS app with Spring boot service to scan barcodes, resulting in increased efficiency of check-in process up to 50%.
  • Created innovative SAS macro code and Python scripts to automate generation of weekly reports on confidential student and immigration data.

EDUCATION BACKGROUND

Oklahoma State University, MS International Studies

Dec 2018

Oklahoma State University, BS MIS

Dec 2016

ACTIVITIES AND ACHIEVEMENTS

  • Top 3/25 of SQL Code Challenge Decision Support Service, 2023
  • Building Excellent Services Together Pin (Outstanding Customer Service), 2022
  • SAS Analytics Experience Conference in Washington, DC, 2017
  • OSU Health Data Shootout Top 8/40 Competitors, 2016
  • Club O+ Donor of Oklahoma Blood Institute, 2012-present



Contact

405-933-8099
khanh.pham@okstate.edu
khanhpham.site
OKC, OK

Skills

Analytics:
SQL, Python, Snowflake, Tableau, Power BI

95%

Data Science:
Predictive Modeling, NLP, Regression

85%

Contact Now