• Designed and developed SQL database for the Trade Surveillance application, delivering the capability for Risk Compliance to monitor and analyze commercial contracts• Led the development of Andeavor's Risk solution as part of a two-year long SAP S/4HANA implementation project• Acted as lead architect for the development of the Risk Position and Profit/Loss dashboard, providing the capability for end-users to visualize and perform analytics on a 20+ million row data-set• Work cross-functionally with business stakeholders and IT departments to translate business requirements into development objectives• Design and develop applications in a variety of languages, including SQL for ETL processes, VBA for automating and standardizing Excel models, C# for web development, MS Power BI for data visualization, and in both R and MATLAB for advanced statistical analytics• Document and manage project plans to ensure business requirements are met and project is staying on schedule• Support end-users by helping document and prioritize application enhancements and troubleshooting errors• Create training material and process flow charts for teaching users about application functionality

• Managed price risk exposure and profit/loss models for daily reporting• Fully re-designed and developed the risk position and P/L Excel models from scratch – improved data flow processes and leveraged VBA to create a new process that is streamlined, robust, and less prone to error• Analyzed operational data to provide the information required for daily hedging of price risk• Worked with commercial traders and schedulers, accounting, contract management, and various other offices to validate data quality of position and P/L reports• Rotated through multiple analyst desks to gain exposure to both the crude acquisition and product placement sides of the refining value chain• Worked with a variety of enterprise applications including Trade Capture, Commercial Scheduling System, SAP, SolArc RightAngle, Triple Point CSL, OpenLink Endur, Morningstar, and MarketView

• Analyzed technical information and budget estimates for environmental regulation projects to produce project summaries using Microsoft Excel and Word• Collaborated with 20+ team members to prioritize and divide workload to meet deadlines