Gustavo Gyotoku

Power BI & Executive Dashboards: Built Power BI dashboards showcasing circuits projected to be overloaded based on prior-year forecasts, supporting engineering leadership decisions on substation load planning.

SQL & Snowflake ETL: Extracted and managed meter data from Snowflake cloud data warehouse using SQL, applying min-max normalization across agricultural, commercial, residential, and industrial sectors to generate 8760 hourly profiles feeding substation forecasts.

Python ETL Automation: Automated LGP and CEVT forecasting consolidation workflow with Python ETL (filtering, file merging, dynamic 15-year column generation), reducing approximately one month of manual labor across a four-engineer team.

Engineer 2 - Southern California Edison via Russell Tobin - Pomona, CA

(2025-04 - 2026-02)

• Power BI & Executive Dashboards: Built Power BI dashboards showcasing circuits projected to be overloaded based on prior-year forecasts, supporting engineering leadership decisions on substation load planning.
• SQL & Snowflake ETL: Extracted and managed meter data from Snowflake cloud data warehouse using SQL, applying min-max normalization across agricultural, commercial, residential, and industrial sectors to generate 8760 hourly profiles feeding substation forecasts.
• Python ETL Automation: Automated LGP and CEVT forecasting consolidation workflow with Python ETL (filtering, file merging, dynamic 15-year column generation), reducing approximately one month of manual labor across a four-engineer team.
• Full BI Lifecycle & Git: Created and managed a GitHub repository housing all forecasting scripts — the team's first use of version control — and built a Tkinter GUI so non-technical engineers could run the ETL workflow end-to-end.
• Large-Scale Data Generation: Generated 14.9 GB of synthetic substation-year forecast data (10 years × all SCE substations × 8760 hourly observations) using Python batch processing to test the Structured Level Forecast (SLF) tool.
• Root-Cause Analysis: Identified and performed root-cause analysis of data irregularities, presenting findings and proposed solutions to engineering leadership within targeted timelines.

Senior Pricing Analyst - Isuzu Commercial Truck of America via TRICOM QUEST - Anaheim, CA

(2023-02 - 2025-04)

Converted to FTE

• PostgreSQL Data Warehouse & Dimensional Modeling: Designed and built a dimensional data warehouse using UML methodology to model fact and dimension tables on a PostgreSQL backend, with SAS extraction and Python ETL loading — pitched to and approved by VP, serving 20+ users.
• Power BI Development & Data Gateway: Connected Power BI to PostgreSQL dimension and fact tables via Data Gateway with daily refresh schedules, replacing static SAS scripts with self-service interactive dashboards for supply and pricing teams.
• Power Query & ETL: Built ETL processes using Power Query advanced functions and developed a Power Query solution that interacted with SAP to auto-navigate transaction codes and update pricing, eliminating manual data entry.
• Python & SAS Automation: Developed Python programs using FTP/SFTP to distribute pricing files to 30+ distributors with error handling, logging, and dynamic notifications; automated SAS pricing pipelines that cut processing from hours to minutes.
• Predictive Modeling: Built an XGBoost predictive pricing model with 40+ features trained on full ERP pricing history, with SAS macro validation to keep outputs within acceptable margin bounds.
• Data Management & Verification: Managed data review processes across 650+ dealer accounts in four countries, working with large databases and performing data verification with limited supervision.

Senior Marketing Analytics Lead - Curtiss-Wright Corporation via Tandym Group - Brea, CA

(2021-08 - 2022-12)

Converted to FTE

• Power BI Development (5 Executive Dashboards): Served as primary Power BI developer, building five dashboards used by marketing, sales, and ~5 executives — including an executive financial dashboard co-developed with IT for CEO-level summarized reporting.
• DAX & Power Query ETL: Built custom correlation matrices with DAX comparing advertisement features to identify linear relationships, and developed ETL processes using Power Query advanced functions to centralize data from Google Analytics, LinkedIn Ads, and multiple company websites.
• Time-Series Forecasting: Developed ARIMA-based 3-month sales forecasting model to evaluate the effectiveness of the company's existing naive forecast, visualizing confidence intervals in Power BI dashboards alongside departmental forecasts.
• Statistical Analysis: Applied Bayesian probability analysis to advertising click distributions, recommending a shift from ad-spend expansion to A/B testing that produced 5–10% improvement in impression-to-click conversion.
• Root-Cause Analysis: Performed root-cause analysis on marketing performance data, identifying data irregularities and presenting proposed solutions to executive stakeholders.

Business Analyst - Honda North America via North American Staffing Group - Torrance, CA

(2020-02 - 2021-04)

• Large-Scale Projects & Executive Reporting: Supported execution of large-scale projects with limited direction, managing data review across 650+ dealer accounts and contributing to $20M in cost savings presented to VP and CEO via executive PowerPoint.
• Excel Automation: Built a dynamic Excel workbook that automated NPS score calculations across department, management level, and tenure segments, eliminating weeks of manual work.
• Stakeholder Engagement: Independently engaged with customers and business partners to gather requirements, validate results, and communicate data-driven insights to VP-level stakeholders.

Master of Science - Data Science - Syracuse (2022 - 2025)

Certification - Data Analytics - USC Viterbi School of Engineering (2021 - 2022)