Patrick Gao
Pacific Gas & Electric (PG&E) - Contract via Insight Global
San Francisco
4
years of professional experience
Detail-oriented Data Analytics and Business Analysis Professional with 4+ years of experience in utilities and insurance. Developed SQL-based ETL workflows and Power BI data models while automating reporting processes for operational planning. Delivered solutions through effective requirements gathering, data validation, and stakeholder collaboration, enhancing scheduling, vendor capacity, financial performance, and project portfolios.
Work History
Data Analyst
1 Year 2 Months- Delivered Rate Reducing Large Load Power BI dashboards covering 20+ projects, 3 teams, and up to 30 users, integrating engineering completion and megawatt capacity for executive portfolio reviews.
- Delivered Power BI dashboards for 20+ projects and 30 users, integrating engineering completion and megawatt capacity to enhance executive portfolio reviews.
- Designed data models and DAX measures to count unique work orders by week, correcting duplicate-count discrepancies and improving dashboard performance and vendor capacity-reporting accuracy.
- Built a self-service Power BI reporting platform including data dictionary with 70+ configurable field selections and preset bookmarks based on stakeholder requirements, enabling users to tailor reports to their different needs.
- Designed data models and DAX measures to accurately count unique work orders by week, resolving duplicate-count discrepancies and optimizing dashboard performance.
- Analyzed animal-contact ignition history and pole, equipment, and geographic data using SQL to support selection of five candidate poles for ignition arrester installation during the pilot phase.
- Built self-service Power BI reporting platform with data dictionary and 70+ configurable field selections, allowing users to customize reports to meet diverse stakeholder needs.
- Configured and enhanced a Power Apps project intake application, integrating SharePoint data sources and resolving validation and submission errors to support reliable project creation and updates in UAT.
Data Analyst
1 Year 6 Months- Developed and optimized SQL-based ETL workflows across 100+ tables to integrate vegetation, inspection, and work-status data. Consolidated operational datasets to improve data reliability and reduce manual reporting effort for planning and compliance oversight.
- Designed Power BI dashboards using DAX and Power Query to track work progress, backlog, and inspection performance. Converted operational data into consistent KPIs that supported field teams in monitoring delivery and identifying outstanding work.
- Gathered reporting requirements from field stakeholders, translating them into analytical metrics and dashboard views to support regulatory compliance tracking and align with operational priorities.
- Structured reporting across constraint, prescription, and vegetation-point hierarchies to enable region and district analysis, tracing work status from detailed records to program-level summaries and facilitating investigation of operational issues.
- Produced weekly and ad hoc Excel reports for oversight of 20,000+ Salesforce work orders and projects, using lookups and pivot tables to reconcile, validate, and summarize operational data for stakeholder insights.
Client Service Associate II | Data Analyst
1 Year 3 Months- Analyzed premium, loss, and exposure data for commercial real estate insurance portfolios, producing actionable reports that informed risk assessment and supported strategic business decisions.
- Analyzed premium, loss, and exposure data for commercial real estate insurance portfolios, producing reports that informed risk assessment and guided business decisions.
- Managed client datasets and premium allocations using Excel VLOOKUP and pivot tables, reconciling allocation data to ensure accuracy in reporting and billing for commercial real estate accounts.
Education
B.S. - Statistical and Data Science
Skills
Business Intelligence & Reporting: Power BI
DAX
Power Query (M)
Tableau
Excel (VBA
XLOOKUP/VLOOKUP
Pivot Tables)
Programming & Databases: SQL (SQL Server
PostgreSQL
MySQL)
Python (pandas
NumPy)
Data Integration & Quality: ETL
data modeling
cleansing
validation
reconciliation
data dictionaries
Business Analysis: Requirements gathering
KPI development
forecasting
trend
variance analysis
user acceptance testing (UAT)
executive reporting
Tools & Automation: Power Automate
Power Apps
SharePoint Lists
Palantir Foundry
SAP
Salesforce
Timeline
Data Analyst
Pacific Gas & Electric (PG&E) - Contract via Insight Global
08.2025 - CurrentRead More
Data Analyst
TRC Companies, Inc.
02.2024 - 08.2025Read More
Client Service Associate II | Data Analyst
Gallagher Insurance, Risk Management & Consulting
09.2022 - 12.2023Read More
University of California, Santa Barbara (UCSB)
B.S. from Statistical and Data Science
Read More