Jerome Gonzaga Email & Phone Number

Irvine, Ca, Us

• Provided data-driven guidance for new payments revenue streams to increase MRR by $500k within 6 months• Produced Hex notebooks to tell a story about GMV trends observed over time which resulted in actionable insights and recommendations for various teams• Redeveloped more robust and reliable subscriber model to adequately capture subscriber and MRR/ARR growth• Collaborated with Risk team to identify potential malicious activity and to roll out MFA for increased security

• Performed a funnel analysis that uncovered opportunities to reach 26k+ customers for new payment system• Analyzed historical GMV trends to predict seasonal sales that brought in $2M+ per month for customer base

Remote

• Built data models in dbt using SQL and Python for Marketing, Product, Finance, and Commerce teams• Contributed to and maintained LookML repositories to surface data pertinent to business initiatives and needs• Developed various interactive dashboards allowing stakeholders to self-service data and identify actionable insights• Set up multiple automated processes to export metrics and data to email, Slack, Google Sheets, Google Docs, and other destinations for streamlined reporting, notifications, and anomaly detection• Used a regression model to characterize GMV of businesses over time to identify potential high-value customers• Created ML models using Facebook’s Prophet to detect anomalies and to forecast volume of new customers• Assisted with ad-hoc analyses for various stakeholders and provided recommendations based on findings

Irvine, California, United States

• Wrote 100+ ETL scripts in less than 2 months using ETL tools to populate MVD tables for use in ML models• Migrated ETL scripts off of cronjobs running on local machines to utilizing Airflow and AWS for resiliency• Led training sessions on using Tableau, Airflow and ETL tools to standardize practices for the analytics team• Conducted Feature Engineering to assist with answering key business questions through intentional Machine Learning

Peoria, Illinois, United States

• Built and maintained data pipelines using Python, APIs and SQL queries to ETL data into enterprise data warehouse• Used SSMS to create database solutions suitable for ETL processes and Tableau reporting• Created interactive dashboard, visualizations and business tools within Tableau and Jupyter Notebooks to assist management with data-driven decisions• Developed OKR process to facilitate strategic planning and execution of organizational and departmental goals

Irvine, Ca

• Designed and built customized phone, desktop and web applications to distribute and track documents• Using object-oriented programming, developed a custom Kanban dashboard and intranet dashboard in C# to send and track work tickets for assignments and to help colleagues more efficiently navigate network folders• Extracted, transformed and loaded inspection data stored on a UCI website using Python and Selenium to analyze patterns and determine actionable items to minimize likelihood of failed inspections• Used Google scripts and VBA to automate a notification system to provide a list of action items to employees• Developed multiple automation tools for the department to increase the efficiency of performing repetitive computer tasks• Performed engineering calculations and analysis on new construction projects to ensure mechanical, civil and plumbing systems are code-compliant• Timely distributed documentation to all appropriate users and reviewers to ensure prompt review of RFIs & Submittals for construction projects• Generated code-compliant and campus standard specifications and drawings within Request for Proposals stipulating Design-Builder’s requirements

Santa Ana, Ca

• Designed code-compliant solar photovoltaic systems using structural, mechanical, and electrical engineering concepts and calculations• Used AutoCAD 2D software and custom software tools to design residential photovoltaic roof top systems• Worked with project managers to submit plans and drawings to building departments• Tracked permitting process through approval• Worked cross functionally with sales, project management and installation teams to ensure clients’ needs and internal deadlines are met

Danville, California

District Engineering Support, Sewer Authority Mid-Coastside, Half Moon Bay, California:• Provided staff assistance in developing a prioritized capital maintenance program for the agency• Assisting in the development of a near-term wet weather pump station reliability plan that will include sizing of wet weather bypass pumps and equipment• Contracting with suppliers and vendors for as-needed assistance• Developing standard operating procedures for facilities operationPipeline Rehabilitation and Replacement Prioritization Project, City of Richmond, California• Providing project engineering support in development of a risk-based pipeline replacement strategy for the City of Richmond• Gathered County GIS data, reviewed pipeline asset attributes including NASSCO PACP defect scores and codes, and developed metrics, scores, and a numerical algorithm for assigning risk and replacement priorities

City And County Of San Francisco Public Utilities Commission

• Identified and implemented process improvements for entering tunneling and concrete grouting data through automation• Automated validation of tunneling and pipe installation data using VBA (Visual Basic for Applications)• Assisted with Cordilleras micro-tunnel construction inspection; monitored and tracked progress of secant pile installation to address potential delay claims• Prepared procurement and RFP specifications which involved much research, critical thinking and literature reviews to include detailed requirements that ensure good quality products for SFPUC• Surveyed points to determine the settlement of SFPUC pipelines and land surrounding a tunneling shaft• Performed construction inspection on contractor's work for the Bay Tunnel project

Walnut Creek, Ca

• Supervised an underground utility investigation project consisting of one hundred forty one (141) potholes to determine the depth and location of existing utilities surrounding the proposed Cathedral Hill Hospital in San Francisco• Drafted 3-dimensional and 2-dimensional plans and profiles in AutoCAD Civil 3D of existing utilities on the project site• Redesigned and suggested alternative lane configurations along a California Pacific Medical Center in San Francisco in order todeter vehicles from making unsafe U-turns in an intersection

San Ramon, Ca

• Created a preliminary soils analysis report describing subsurface conditions and bridge foundation recommendations for the proposed SMART light-rail line extending from the Sonoma county to the Marin county• Installed water level and settlement monitoring instruments for a reservoir• Automated data entry for a well-drawdown analysis project in Rio Vista by scripting in Excel Visual Basic• Performed various laboratory soil tests to learn the fundamentals to identify and characterize various types of soil

• Effectively assessed and implemented an internet and communications program for the Bay Tunnel Project

Fullerton, Ca

• Prepared a Water Quality Management Master Plan for a project in Los Angeles• Created and submitted tract maps, parcel maps, radius maps, condominium conversion plans, and subdivision plans• Assisted in the collection of field data with the land surveyors

Master Of Science (M.S.), Civil Engineering

Activities and Societies: Graduate Student Instructor for course on Project and Construction ManagementSpecializing in Engineering.

Bachelor Of Science (B.S.), Civil Engineering

Activities and Societies: Chi Epsilon