SQL Server
Scott D. Perry
Technology Leader
Gainesville,GA
Summary
Knowledgeable IT Manager oversees technology deployment and maintenance. Instructs and leads IT staff members in support of hardware, software and networking infrastructure. Actively works with executives to determine and implement tech needs. Manages technology strategy, training and documentation.
Overview
8
8
years of post-secondary education
8
8
years of professional experience
Work History
Global Database Manager
TenCate Geosynthetics
Pendergrass, GA
07.2017 - Current
- Responsible for managing all personnel, globally, involved in database projects.
- Responsible for managing all data projects globally.
- Responsible for managing all database servers for global organization, including Unites States, Austria, France, Netherlands, China and Malaysia.
- Key systems include Microsoft SQL Server 2000, 2005, 2008, 2012, 2016 and 2017, Oracle 8i, Snowflake, SSIS, SSRS, Alteryx, Azure Synapse, Dynamics CRM, Dynamics Finance & Operation, Azure Data Factories, Azure DevOps.
- Manage creation and maintenance of SSIS packages to move data from various regions into Global data warehouse.
- Manage all backup operations for SQL Servers using both SQL Safe and Microsoft SQL backup.
- Monitor performance for all SQL Servers using SQL DM.
- Responsible for maintenance of all database servers, both on premise and in Azure.
- Responsible for Tableau installation (Tableau Server), user training and server administration for Tableau as replacement for Business Objects.
- Responsible for Creation of Global Tableau workbooks.
- Responsible for supporting creation of regional Tableau workbooks.
- Key Projects:.
- Upgrade of Wonderware system for Manufacturing.
- Installation and implementation of Tableau as means of data analytics.
- Bi-Quarterly Tableau Server Upgrades.
- Managed migration of all database servers during disentanglement of TenCate Geosynthetics from TenCate domain.
- Created SSIS packages to move data from 4 ERP systems globally (SAP, NESI/Infinium, JDE China and JDE Malaysia) into new Global Data Warehouse.
- Moved Global Data Warehouse from On-premise server to Azure.
- Global Open Order Book (Backlog) move into Global Data Warehouse from regional ERP systems.
- Led Purchasing Information System project.
- Data engineer for Global Sales Information System project.
- Brought Alteryx to company as another means of ELT, making getting data from SAP in Europe and JD Edwards in Asia more democratized process.
- Led project to move global inventory data and shipping data into Snowflake.
- This project allowed me to create Global Inventory Management System creating deeper analytics for inventory management and pricing of obsolete inventory.
- This project led to sale of obsolete inventory that was in rented warehouse, saving us $175,00 per year in rented warehouse space and one-time $2,000,000 revenue increase.
- Lead data engineer for pricing revitalization project leading to 12% margin increase for Fiscal Year 2019 through first 5 months.
- Lead engineer on APAC ERP Data Consolidation project.
- Led consolidation of JD Edwards data from China and Malaysia into Global Data Warehouse.
- Moved Data Warehouse from Azure VM to Azure Synapse.
- Moved ETL processes to ELT processes in Azure Data Factories.
- Led data integration between TenCate Geosynthetics and Solmax after purchase.
- Led DevOps transformation of entire IT Department in Americas region. This inspired global transformation of TenCate Geosynthetics and Solmax.
IT Department Manager
American Hole ‘N One
Buford, GA
09.2016 - 09.2017
- Managed development of new Customer Service Application that is projected to increase efficiency allowing Customer Service Representatives to concentrate on sales and better customer service as opposed to writing contracts.
- Managed development of new websites for all three of our holdings in America and both of our holdings in US and UK.
- Manage day to day IT operations.
- Manage day to day Marketing operations in US and UK.
- Developed empowering employee culture focused on equipping employees to independently meet customer needs.
Information Systems Technician
Koyo Bearings, North America
Dahlonega, GA
10.2014 - 09.2016
- Manage network of more than 12 servers and 350 workstations to include.
- Build and maintain computer systems.
- Assist with network administration to include LAN and WAN troubleshooting and configuration of Cisco switches and Routers on local area network with 20 subnets and 12 VLANs.
- Administration of servers to include Windows Server 2003, 2008 and 2012 and one Linux Server.
- Active Directory administration, DHCP configuration and DNS administration and troubleshooting.
- Assist with network hardening plans.
- Assist with Database administration (Oracle and SQL).
- Use VBA to create MS Access Front ends to run queries and reports including daily Profit/Loss data, daily Sales and transfers, daily raw material scrap, Monthly Raw Material Weigh-back reports and various area-specific reports throughout manufacturing facility.
Department Head
Cambridge Construction Management
Alpharetta, GA
12.2013 - 10.2014
- Oversaw employees for Data and IT Departments.
- Set up and configured LAN at both Memphis, TN and Lawrenceville, GA offices to include setup of Windows Server 2012 File and Print servers, DHCP and DNS servers.
- Set up WAN to connect Memphis and Lawrenceville offices.
- Created databases for maintaining storm and sewer conditions for Gwinnett County, GA, Memphis, TN, Valley, AL and several engineering firms helping CCM reach year-1 profit of over $2 million.
Education
Master of Business Administration - IT Management
Western Governor’s University
Salt Lake City 03.2021 - Current
Bachelor of Science - Business Administration – IT Management
Western Governor’s University
Salt Lake City, UT 02.2016 - 07.2020
Associate of Applied Science - Information Technology
Westwood College - Denver North
Denver, CO 01.2013 - 12.2015
Skills
Leadership
DevOps
Automated Deployments
Data Management
Database development
Infrastructure development
Agile framework
Project lifecycle management
Software
SSIS
Azure DevOps
Azure Data Factories
Azure Synapse
Python
C#
Snowflake
Alteryx
Timeline
Master of Business Administration - IT Management
Western Governor’s University
03.2021 - Current
Global Database Manager
TenCate Geosynthetics
07.2017 - Current
IT Department Manager
American Hole ‘N One
09.2016 - 09.2017
Bachelor of Science - Business Administration – IT Management
Western Governor’s University
02.2016 - 07.2020
Information Systems Technician
Koyo Bearings, North America
10.2014 - 09.2016
Department Head
Cambridge Construction Management
12.2013 - 10.2014
Associate of Applied Science - Information Technology
Westwood College - Denver North
01.2013 - 12.2015