Patrick Davies Email & Phone Number

St Louis, Missouri, Us

Travel Centers of America – Diesel Price Optimization MAY 2022 – AUG 2022• Designed and implemented Snowflake database objects and processes for consuming and transforming data to support Diesel Price Optimization modeling.• Converted Pilot data processing from Python to Snowflake for rollout to client.• Set up and secured Azure resources and integrations.Used: Snowflake, Azure, PythonAnheuser-Busch – Zone Based Brewing Application Support OCT 2020 – FEB 2022• Member of the Managed Application Services (MAS) team where we support 300+ Applications utilized by AB employees. • Work with a wide variety of user tickets requiring an understanding of different application and database architectures as well as debugging application code and troubleshooting data.• Developed high priority changes to several critical applicationsUsed: Oracle, MS SQL Server, Sybase, .NET/C#, JavaScript, VB6

Arlington, Va, Us

IT Data Warehouse Developer- Created a variety of automated ETL processes to pull data from source applications- Developed and maintained intranet website in .NET Framework/C#- Designed and built VIPER system for collecting and displaying data catalog information

Arlington, Va, Us

Third Rotation: IT Infrastructure, IT Data Warehouse- Retired three legacy data warehouses and transitioned customers to IT Data WarehouseSecond Rotation: IT Business Partners, BMA IT-Engaged U.S. and Foreign customers to provide access to F-15 resources- Supported F-15 DMS and FLEX file sharing applications- Maintained F-15 Eagle intranet websiteFirst Rotation: HR Systems, My Learning-Provided requirements analysis and definition, testing development and execution, andproduction support for the enterprise My Learning system- Collaborated with onshore and offshore resources from sourcing partner to createmodifications for My Learning application

St. Louis, Missouri, Us

Assisting in business analysis through requirements gathering and documentation, process design, data analysis, testing, and report development

O'Fallon, Mo, Us

Set up automated testing for customer facing website

O'Fallon, Mo, Us

Ensure daily checks were sent out properly with all required paperwork. Addressed purchase order discrepancy reports. Collaborated with finance department and plant managers to reduce purchase order discrepancy report by over one million dollars.

B.S., Computer Science

Master'S Degree, Information Technology