• Create solutions plans focused on AWS data migrations using Redshift, Aurora, and Athena. Createconceptual, logical, and physical data models including dimensional and snowflake design patterns• Evaluate solutions for effort versus value, adherence to standards versus exceptions, and time for delivery.• Ensured standard adherence for creating data engineering artifacts using AWS Glue and Lambda functions.

• Lead project team initially tasked to deploy Computer Vision models to determine natural gas flow rate. Upon discovery of extremely low model accuracy, and faulty modeling and data assumptions;recommended defunding the project as these resulted in a much larger expense than previously expected, and marginal benefits if successful. Then created a proof of concept using Azure Databricks and AutoML.• Lead Supply Chain analytics team redesigning stocking parameters for all of the company's inventory items incorporating Python forecasting, SQL data storage, and displaying results using Power BI.• Refactored, enhanced, and automated Sales Conversions recommendation analytics and Disconnect for Non-Payment system for Natural Gas using Python and deployed code as containers on Kubernetes.• Utilized pySpark to provide product enhancements and bug resolutions for energy efficiency projects, and detailed reports of anomalous analytics. Also delivered performance enhancements reducing execution time reducing overall system execution time from weeks to hours.

• Performed time series analysis of admissions data across all KSU departments.• Utilized Python for webpage data scrubbing and data collection from external APIs to create large SQL data stores, and perform exploratory data analysis.• Reviewed Applied Data Science using Python certificate coursework and assignments. Covered topics include decision trees and random forests, clustering support vector machines, neural networks.

• Lead team creating process to load test data warehouse ETL. Worked with a data architect to recommend, implement, and test enhancements to improve performance and functionality reducing overall execution time from hours to minutes. Stored results to SQL data layer and displayed findings with Power BI.• Lead of team testing multiple deployment processes using TFS Release Management 2016, Powershell, and AWS Cloudformation.

• Rewrote code to scale solutions and provided product enhancements for pricing and rating functionality including the SAS/Analytics and SAS/Operations Research packages.• Used R for forecast prototyping and created dashboards in Tableau comparing my forecasts with Tableaubuilt in functionality, as well as displaying historical TV ratings. Presented results to leadership.• Created SAS web services and stored processes layer to integrate SAS with SSIS packages and monitorperformance metrics. Enhanced and created new SSIS packages and T-SQL.

• Wrote batch scripts to load test SAS code to test SAS code repositories and provide enhancements• Executed systems through all phases of release cycle including bug troubleshooting and resolution• Install, configure, maintain, and monitor SAS Office Analytics and SAS Forecast Server in a tieredenvironment including ARM metrics• Administered customer service tools including Zendesk, Bomgar, and StarPound

• Examined effects of insurance claim length on amount incurred and paid using R.• Examined effects of regulation on consumers across time using payday loan data.• Held office hours and assisted doctoral students with analytical components of theses.

• Wrote ansi-SQL to pull data into applications from mySQL databases• Wrote process to automate conversion of SAS data sets to mySQL databases for use in applications.• Converted base SAS ETL to utilize SAS Data Integration Studio.• Wrote Unix scripts to automate SAS execution.

• Trained new servers. Shift closing responsibilities. Led St. Jude fundraiser 2005.

• Shift leader.