# About Txais Xiong

I am a Sacramento data analyst working across construction reporting, utility records and asset reconciliation. StoraIQ brings that experience to public construction and housing data.

# Work experience
Work history and results from my September 2026 resume.

## Pacific Gas and Electric Company | Engineering Assistant I (Data & Records Analyst) | Feb 2026 - Present

- Audit and correct legacy engineering asset records in SAP dating back to 1980, 8,000+ completed to date, verifying construction milestone and project dates against engineering drawings during an active platform transition.
- Apply business rules and structured quality checks that catch data-to-report mismatches before they reach supervisor-level reporting, where an incorrect milestone date would misstate project progress to leadership.
- Standardize historical documentation against PG&E’s categorization schema so legacy records are retrievable and audit-ready; proposed a point-of-entry validation tool for drawing revisions and facility names.

## Sacramento Area Sewer District | Data Management Technician | May 2025 - Jan 2026

- Owned the district’s weekly reconciliation between IT system exports and the GIS/AME (ESRI) asset database; built an automated Excel system that cut the audit cycle from 4 hours to under 15 minutes (95%, about 180 hours a year).
- Replaced subjective manual review with a rule-based validation framework that auto-flags discrepancies before Quality Control, with an audit trail on every record.
- Executed service-request change control in Maximo (CMMS), updating asset geometry, headers, indicators, and property lines to match engineering drawings; cross-referenced Granite inspection video against AME records to confirm pipeline lengths and cleanout locations.

## California Homebuilding Foundation (CIRB) | Senior Research Analyst | Nov 2023 - May 2025

- Designed and shipped the statewide permit-classification pipeline: a JSON-configurable keyword rule engine for the clear majority of records, a PyTorch neural network on sentence embeddings for the ambiguous cases, and a mandatory human review queue for low-confidence results, covering 750,000+ permits from all 539 California jurisdictions in a 33-category taxonomy.
- Cut processing time per report from 64.3 to about 20 minutes (about 69%), raised per-analyst throughput about 93%, and brought classification error rates from 20–25% to under 10%, replacing manual VBA/Excel workflows.
- Built the system with self-taught Python and AI-assisted development, and externalized the rules so non-technical staff update classification behavior without code.
- Adapted the pipeline to a new California Air Resources Board reporting agreement without added headcount; provided technical support and process documentation for staff and work-study analysts.

## Sacramento Chinese Community Service Center

Program Manager: Oct 2023 - May 2024, concurrent with the CIRB internship. Team Leader roles: May 2021 - Oct 2023.

- Ran a grant-funded after-school program for 100+ students, including staffing, scheduling, and compliance reporting.