Grant Matson Email & Phone Number

Canonsburg, Pennsylvania, United States

Greater Pittsburgh Area

- Orchestrated roadmap, center of excellence and company adoption of Power BI. Estimated annual savings of $250K versus prior BI license structure. Full end to end scope included development of company wide insight tracking, cloud architecture monitoring, security and hosted training sessions. These sessions were created in Rmarkdown with reproducible walk through examples.- Daily data engineering executed with the tools that fit the task. Experience creating data pipelines with R scripts, Azure Data Factory activites, Informatica Cloud mappings, Databricks workbooks, PowerShell scripts, Power Query functions and more. I have touched a variety of storage solutions and setup custom connectors: Azure Data Lake (G1&2), Azure Blog Storage, MS SQL, Salesforce SOQL, Oracle SQL, Cosmo DB, Apache Drill and hosted files shares.- Implemented a cross departmental reporting model for a complex business application (92 ODS SQL tables) - Rolled out a new active directory security model to remove silos and increase insight visibility.

Pittsburgh, Pa

- Backbone analytics for the Commercial team supporting Planning, Operations and Trading groups with insights. Cross department collaboration included Reservoir Engineering, Accounting and Finance.- Developed a gas optimization model in R to maximize daily revenues and visualize through map projections. Was showcased to members of the board of directors.- Enhanced forecasting using dynamic data loading structures through Spotfire via JavaScript.- Active monitoring of Market to Market projections with conditional error reporting.- Built a natural gas liquids volume forecast model through multivariate regression techniques. Was ported to multiple processing facilities.

Canonsburg, Pa

- Traded, scheduled and balanced multiple pipeline assets (TCO, CGT, AGS-SGG, ETRN).- Developed and actively managed REM’s position report with Appalachian basin focus. Dynamic views including bid week, marketable production and realized hedge pricing. This was a stepping stone to managing flat price and basis risk pre-ETRM.- Accelerated implementation of ETRM (ENDUR) completed in 5 months. Custom production forecast incorporated to adhere to ad hoc market conditions. - In depth fundamental analysis executed through highly interactive Power BI dashboards and reports. Custom generated reports include: forward market changes, spot market history, macro level pipeline views and weather/demand forecasts.- Formulated a Real-Time Trade Sheet used by the cash trading desk.

Cadiz, Ky

B.S. Engineering

Honors Diploma