Txais Xiong
Data Analyst · Sacramento, CA
Data Analyst with 3+ years modernizing public-sector and utility data workflows, replacing manual, error-prone processes with systems built on clear rules instead of judgment calls.
I built a Python pipeline processing 750,000+ statewide construction permits that became a research product for legislative, legal, and real estate clients, and collapsed a 4-hour audit cycle to under 15 minutes at a regional utility. I'm currently at PG&E, auditing and reconciling thousands of SAP engineering asset records spanning decades of accumulated data during an active platform migration. StorAIQ is where I publish the same practice independently.
Where the practice comes from.
Engineering Assistant I
ContractFeb 2026 – Present- Auditing and correcting thousands of SAP engineering asset records dating back to 1980, resolving decades of data drift before it propagates into operational reporting during an active platform migration.
- Applying structured business rules and quality checks to validate record integrity in SAP, flagging discrepancies before they reach downstream operational systems.
- Standardizing legacy engineering documentation against PG&E's categorization schema, making decades of historical records retrievable and audit-ready for the first time.
Data Management Technician
ContractMay 2025 – Jan 2026- Built a reconciliation system between GIS asset records and the enterprise asset management platform, collapsing audit cycles from 4 hours to under 15 minutes, a 95% reduction that freed roughly 180 labor hours a year.
- Replaced subjective manual review with a deterministic validation framework that auto-flags discrepancies before Quality Control, cutting downstream rework.
- Drove cross-team data correction cycles with QC, IT, and field operations, owning the queue from intake to resolution so corrections landed in days, not quarters.
Senior Research Analyst
Nov 2023 – May 2025- Promoted through four roles: Data Entry Intern, Data Analyst, Research Analyst, Senior Research Analyst.
- Built the Python (pandas/NumPy) pipeline that standardizes, validates, and classifies California's statewide construction permit data, now 750,000+ records and the backbone of a research product used by legislative, legal, and real estate clients.
- Cut permit processing time per record by ~69% and drove classification error rates under 10%, replacing manual interpretation with a structured validation layer.
Education, certifications, and core strength.
Education
B.A. Ethnic Studies, California State University, Sacramento. Completed December 2025 while working full-time.
Certifications
- Constraint and Bottleneck Management, LinkedIn Learning, Jan 2026
- Excel Essential Training, Microsoft 365, LinkedIn Learning, Sep 2025
- Bluebeam Revu 21 Essential Training, LinkedIn Learning, Jun 2025
Core Strength
Finding broken manual workflows and replacing them with automated, rule-based, deterministic systems that scale.