John Morgan
Jacksonville,FL
Summary
Results-driven Senior Database Engineer with a successful history at HD Supply and Ameris Bank. Proficient in creating advanced ELT data models and seamlessly transferring databases to cloud platforms using SQL Server, Snowflake, and Python. Recognized for exceptional collaboration and innovative problem-solving, resulting in improved data efficiency and system performance.
Overview
7
7
years of professional experience
Work History
Senior Database Engineer
HD Supply
Jacksonville, FL
03.2021 - 11.2024
- Successfully developed and maintained ELT data models using dbt, Python, and Snowflake.
- Developed a powerful solution that seamlessly manages item restrictions across various geographic regions, overseeing an impressive inventory of four million products.
- Received multiple performance awards for the quality and timeliness of my deliverables, and my consistent demonstration of the organization's core values to our customers, employees, and 3rd-party vendors.
- Contributed to the migration of multiple legacy SQL Server databases to various cloud-based platforms, including Azure, Google Cloud Platform (GCP), AWS, and Snowflake.
- Performed advanced SQL query optimization techniques, including join optimization and data retrieval strategies.
Database Engineer
HD Supply
Jacksonville, FL
07.2019 - 03.2021
- Revamped 65+ SSRS reports and stored procedures to meet the dynamic data needs of management and business units, facilitating seamless collaboration with internal teams and external vendors.
- Rigorously refined query performance, resulting in remarkable improvements in overall database efficiency and dramatically reduced response times for user queries.
- Developed ETL packages for data loading from various sources, including JSON files, flat files, and XML files into the Data Warehouse using SSIS.
Senior Database Developer
Ameris Bank
Jacksonville, FL
04.2018 - 05.2019
- Contributed to the design and modeling of a new Enterprise Data Warehouse (EDW) and its corresponding data mart, utilizing SQL Server and SQL Server Integration Services (SSIS).
- Engineered robust packages to efficiently extract, transfer, and load data from SQL Server, Oracle, and vendor flat files, streamlining the data integration process with precision and expertise.
- Diligently monitored the production environment to quickly identify and address any issues that arose, specifically focusing on resolving failures of SQL jobs to ensure smooth operations.
Education
Bachelor of Science - Information Systems
Virginia Commonwealth University
Richmond, VA05-2001
Skills
- SQL Server (SSIS/SSRS)
- Snowflake
- Confidently mastering data modeling with the Data Build Tool (dbt)
- Python
- Collaborative team member
- Innovative thinker who explores unconventional approaches to problem-solving
Militaryexperience
United States Army, 1991 - 1995, Battalion Legal Clerk, Specialist (E4)
Timeline
Senior Database Engineer
HD Supply
03.2021 - 11.2024
Database Engineer
HD Supply
07.2019 - 03.2021
Senior Database Developer
Ameris Bank
04.2018 - 05.2019
Bachelor of Science - Information Systems
Virginia Commonwealth University