selftaught


Khanh "Dewy" Pham

PROFILE

  • Results-driven Data and Business Analyst with 7+ years of experience in digital metrics management, automated ETL pipelines, and executive reporting. Expert in SQL, Python, and Snowflake for interpreting audience trends and optimizing platform growth.
  • Proven ability to translate complex data anomalies into actionable business strategies for cross-functional leadership.

PROFESSIONAL EXPERIENCE

Oklahoma Tax Commission

August 2023 – Feb 2026

Business Analyst/ Data Analyst

  • Designed and utilized a custom Peoplesoft ERD to streamline complex SQL queries across PS_VOUCHER, PS_PO_HDR, and PS_Ledger tables, ensuring accurate tracking agency expenditures and revenue against budget projection.
  • Leveraged deep understanding of PeopleSoft Distribution lines (PS_DISTRIB_LINE) to reconcile accounts, department ID (DEPID), and budget references, ensuring all financial activities aligned with statutory regulations.
  • Performed large-scale data segmentation on 37,000+ unique business (CITFAN AND CITAN from 2021 to 2024), mapping industry codes (NAICS) to revenue metrics to identify growth opportunities and ensure data integrity.
  • Analyzed Corporate Income Tax (CIT) fillings to verify NAICS code accuracy, identifying 2,300+ discrepancies to prevent improper tax exemption claims.
  • Developed a predictive classification model to identify patterns in fraudulent tax returns, aiming to reduce manual workload for the ITA team.
  • Managed and analyzed platform engagement metrics (volume, wait times, and reason trends), identifying patterns to optimize service delivery and resource allocation.
  • Applied regression models to predict monthly trends during and post-tax season, supporting the Director of TRC with resource allocation.
  • Calculated key performance indicators (KPIs), including First Call Resolution (FCR) and handle rate, to assess agent performance and determine bonus allocations.

Oklahoma Dept. of Mental Health & Substance Abuse

March 2021 – July 2023

Junior Data Analyst (Remote)

  • Created and optimized SQL stored procedures to generate reports, reducing manual processing time from over 5 hours to just 5 minutes.
  • Developed an algorithm using Python/SQL to match client data to third-party apps, reducing manual matching time from 4 hours to 10 minutes.
  • Leveraged Tableau and Power BI to create performance monitoring dashboards to evaluate treatment effect.

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
dedicatedlife.info
Edmond, OK

Skills

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

95%

Data Science:
Predictive Modeling, NLP, Regression

85%

Contact Now