Quan Do
Folsom,USA
Overview
2
2
years of professional experience
Work History
Analyst
CALIFORNIA DEPARTMENT OF JUSTICE
Sacramento, CA
10.2024 - Current
- Collaborated on testing controlled substance database builds within the Software Development Life Cycle (SDLC); supported developers by validating data outputs and reviewing Oracle Database structures, with exposure to SQL-based workflows; logged bugs, enhancements, and fixes in JIRA.
- Enabled HIT system connectivity to the controlled substance database by configuring authentication credentials using KeePass; tested and validated API interactions with Postman to confirm successful data exchange.
- Built dynamic Excel dashboards using Power Query and formulas to improve the tracking and searchability of procurement forms and statuses.
- Facilitated meetings with stakeholders, including heads of other California state departments, to share key updates; prepared statistical analyses on user registrations, bug reports, and interstate data requests to support informed decision-making.
Program Analyst/Technician Intern
UNITED STATES DEPARTMENT OF AGRICULTURE – FARM SERVICE AGENCY
Tualatin, OR
05.2024 - 07.2024
- Managed and cleaned datasets for 3,000+ farms in Excel using VLOOKUP, PivotTables, and Power Query to identify crop and land use trends.
- Built interactive dashboards in Power BI to visualize key farming metrics by county, integrating ArcGIS data and large datasets; published on SharePoint for agency-wide access across county offices.
- Regularly reviewed farm program and tax documents to assess applicant eligibility based on adjusted gross income, wages, and filing status; supported compliance with federal farm program requirements.
Student Assistant
CALIFORNIA DEPARTMENT OF JUSTICE
Sacramento, CA
01.2024 - 05.2024
- Collaborated with senior analysts to identify filing errors by extracting and analyzing data from 100+ accounts using advanced Excel functions and data validation techniques.
- Entered financial details from tax documents into the database for multiple programs, ensuring accuracy and timely processing of reimbursement checks to reconcile accounts.
- Efficiently processed and organized over 900 critical tax documents daily—including filings for charitable organizations—by stamping, categorizing, and routing them to designated program review teams to maintain compliance and workflow accuracy.
Education
Masters of Science - Data Science
Eastern University
St. Davids, PA08.2025
Bachelors of Science - Management and Business Economics
University of California, Merced
Merced, CA08.2024
Skills
- Languages and tools: Python, R, SQL, C, STATA
- Libraries and platforms: scikit-learn, pandas, NumPy, matplotlib, Tableau, Power BI, Excel, PostgreSQL, pgAdmin
- Other: Microsoft Office Suite, SharePoint
Projects
Student Grade Prediction Models (Python, Tableau):
Developed regression models in Python using scikit-learn to predict students' final math grades from demographic, behavioral, and academic features. Preprocessed data using StandardScaler, MinMaxScaler, and one-hot encoding within pipelines. Trained and evaluated Linear Regression, Lasso, and Ridge models using cross-validation, R², and RMSE. Created complementary Tableau dashboards to visualize grade distributions, feature importance, and model performance for stakeholder presentation.
Relational SQL Queries for Banking & University Data (PostgreSQL, pgAdmin):
Used SQL in PostgreSQL/pgAdmin to write advanced queries with JOINs, subqueries, and SET operators across Banking and University databases; extracted insights into customer behavior, academic metrics, and account relationships using robust, reusable logic.
Timeline
Analyst
CALIFORNIA DEPARTMENT OF JUSTICE
10.2024 - Current
Program Analyst/Technician Intern
UNITED STATES DEPARTMENT OF AGRICULTURE – FARM SERVICE AGENCY
05.2024 - 07.2024
Student Assistant
CALIFORNIA DEPARTMENT OF JUSTICE
01.2024 - 05.2024
Masters of Science - Data Science
Eastern University
Bachelors of Science - Management and Business Economics
University of California, Merced
Similar Profiles
Jasmine RandhawaJasmine Randhawa
Student Assistant at California Department of JusticeStudent Assistant at California Department of Justice
Mikaela SmithMikaela Smith
Student Assistant at California Department Of JusticeStudent Assistant at California Department Of Justice
Brennan CroughBrennan Crough
Crime Analyst I at State Of California, Department Of JusticeCrime Analyst I at State Of California, Department Of Justice
Paula BidgoodPaula Bidgood
New Business Integration Technical Program Manager at Intel CorporationNew Business Integration Technical Program Manager at Intel Corporation
CHELSIE GRAYCHELSIE GRAY
Accounting Assistant at Access Business Technologies, LLCAccounting Assistant at Access Business Technologies, LLC