Fortune 15 Oil and Gas Company – Data Analytics ArchitectRelevant Technologies: Azure Machine Learning, Databricks, Power BI, Analysis Services (AAS/SSAS), SQL Server, Data Lake (ADLS), Data Factory (ADF), Visual Studio, DevOps, APIsSystems Architect – Led multiple SAFe Agile Release Trains across the organization as Systems Architect, overseeing 12+ product lines consisting of Power BI, Web Apps, API and MLOps solutions. Provided architectural direction and technology guidance to scrum teams, product owners, outside vendors and client SME’s, as well as portfolio and digital advisors. Project Manager – Oversight of offshore developers and managed production release of Self-Service BI platform with 300+ current business users, as well as interviewing/onboarding all new resources and guiding solution architecture and design.Analytics Developer – Architected data models and ETL processes from disparate sources, including reducing data volume from 7.2B to 265M records and allowing deep insights and visualizations on Historical Real-Time Sensor Data.Cost Optimization – Implemented Azure Cost Reduction initiatives realizing $60k+ in annual savings.

Fortune 100 Oil and Gas Company – Data Analytics DeveloperRelevant Technologies: Azure Machine Learning, Power BI, SQL Server, Visual Studio – SSIS & SSASOil Auditing - Worked with team to develop a data model from disparate sources that connected automated sensor data with hauling company run tickets. Utilized the data model to build an audit dashboard in Power BI that provided deep insight into hauling company trends, equipment performance and geographical heat maps. Machine Learning - Utilized Azure Machine Learning to develop statistical model that accurately predicted net oil volume based on supplemental data gathered from hauling companies run tickets. Production Planning - Built Power BI dashboard capable of supporting trend analysis for the Completions team, focused on eliminating downtime and identifying impacts of process change. Designed and implemented SSAS Tabular Model to support use of Data Services across the organization.

Drove operational strategy and analytics for multiple business lines, asset channels and organizations across the U.S. Consulted with business partners to translate complex business requirements into end-to-end solutions and implemented, monitored and reported progress.Worked with marketing team to launch both mail and digital campaigns. Developed A/B testing, tracked response rates, conversion rates and ROI and created dashboards to convey results. Created customer segmentation model in Azure Machine Learning, leading to an increase in ROI and improvement in customer conversion rates.

Utilized data visualization tools such as Microsoft Power BI, Excel and IBM Cognos to produce actionable dashboards and reports used internally and externally across the organization. Supervised team of data analysts to support the development of dashboards and reporting packages that ensured successful return thresholds on assets and franchise profitability.Partnered with development teams to design test cases, performed testing against requirements, documented outcomes, initiated feedback loop and determined test results.

Developed and automated daily revenue reporting, KPI and dashboard reporting, as well as collaborated with other teams to identify business opportunities. Mined company data to identify trends, produced ad hoc reports to support findings, and presented tactical recommendations to Chief Operating Officer.

Participated in the design, testing and implementation of IBM InfoSphere Identity Insight software to prevent fraudulent transactions from successfully processing through the system. Acted as system administrator for adjusting anti-fraud rules, while not disrupting the normal course of business. Identified trends in fraud complaints, modeled rule enhancements, presented recommendations and adjusted system thresholds accordingly.Lead analyst for reporting anti-fraud program results to Federal Trade Commission (FTC), built out external reporting and dashboards, as well as established all internal KPI and reporting for anti-fraud call center team. Also, worked alongside business users to document workflow processes and create functional guidance manual for step-by-step procedures.