Jonathon Holden Email & Phone Number

Glenpool, Ok, Us

Tulsa, Oklahoma, United States

Tulsa, Oklahoma, United States

*Handled multiple ERP system conversions at a time. This spans multiple vendors with the central goal of pulling the data into Epicor Prophet 21. *Created and maintained multiple SSRS reports used to verify and rationalize data between the source and destination systems. *Created custom applications to extract, transport and import data from remote systems that were not directly accessible. *Designed multiple SQL functions and procedures to remove data imperfections, automate portions of our process and to enhance the rationalization process through the use of "fuzzy" logic. *Worked with multiple departments and subject matter experts to meet project deadlines and to successfully migrate data from source systems (various ERPs) to our destination system (Epicor P21).

Tulsa, Oklahoma

*Maintained and created custom applications, websites and scripts utilizing HTML, Javascript, C#, and Powershell.*Handled the backups and maintenance for three SQL servers before consolidating a majority of applications to one. This also involved migrating all of the SSRS reports to a new server and restructuring their underlying datasets (which also removed their reliance on Analysis services). *Assisted in migrating from Great Plains 2013 to Great Plains 2018. In the process, I wrote a custom web application to handle some of the dynamic report distribution previously performed by FRx (which was replaced by Management Reporter in later versions of Great Plains).*Assisted in migrating the phone system from a legacy version of Interactive Intelligence (3.0) to Genesys PureCloud. After the implementation, I also acted as a secondary administrator for the system.*Created and maintained all of the Juniper network device configs across all corporate, call center and restaurant locations to keep them secure (based on the results of frequent vulnerability assessments) and PCI compliant. This included building additional segmentation between corporate, IoT and guest networks. *Replaced an outdated network and device monitoring tool with Solarwinds . Built out custom device templates for configuration management and network/device monitoring. *Developed a project plan and worked closely with our vendor (in planning meetings and on each night of the upgrade in-person) to upgrade/replace all central networking equipment in the corporate office. This involved documenting the existing configs and updating any outdated network diagrams, coordinating the deployment while Covid protocols were in place, and splitting the upgrade into multiple segments (spanning two physical buildings and impacting 60+ restaurants in three states) that could be accomplished overnight without limiting the call center's capability the next morning.

Remote

*Migrated on-premise systems, other cloud based services and custom applications to Rackspace, AWS or Azure*Supported customers in upgrading or maintaining software*Worked closely with project managers to communicate status, billable time and any unforeseen issues that could cause a variance between the quoted time and the actual process.

Tulsa, Oklahoma Area

*Maintained applications, websites and scripts utilizing HTML, Javascript, PHP, C#, VB, VBS, and Powershell. *Maintained legacy processes utilizing Access databases. *Created/Maintained reports built in SSRS*Maintained an SSAS cube and MDX queries based on the cube. Additional Responsibilities:*Maintained the phone system. *Maintained all servers, domain environment, Hyper-V, backup solution and Exchange.

Broken Arrow, Ok

*Coordinating with department leads to create SSRS reports to drive business operations*Converting reports built in Crystal Reports over to SSRS*Building ETL packages for SSIS*Cube design/deployment in SSAS and Halo BI*Scripting in Powershell*Migrating data from various ERP system to Epicor P21

Broken Arrow, Ok

*Created custom reports using SSRS to track incident trends so that we could better identify problem areas.*Implemented a standardized image for deployment and maintained two WDS servers*Maintained our helpdesk platform (ChangeGear) and assisted in its customization.*Provided support for 600+ employees spanning multiple states. *Setup and maintained users in Active Directory*Setup users and equipment within Cisco Call Manager*Created documentation for our end users*Participated in a monthly on-call rotation.

Broken Arrow, Ok

*Provided support for office personnel and business customers*Performed onsite service such as workstation setup, hardware replacement, network diagnostics and malware removal.*Setup and maintained users in AD and Exchange*Supported users over the phone and through the use of remote programs such as LogMeIn.*Used LabTech software to monitor the health of workstations and to troubleshoot system issues.*Worked on multiple tickets at a time and provided detailed notes regarding the issue and its resolution. *Kept a detailed log accounting for the time spent on each ticket within ConnectWise. *Created SOPs for tasks requiring special configurations.

Bixby, Ok

*Troubleshooting internet, VoIP, and IPTV issues *Configuring and troubleshooting internet and TV service within Calix, Redback, Juniper, Metaswitch, and FSCDN*Configuring Allworx phone systems to function correctly within existing networks*Configuring routers and switches from a variety of vendors *Troubleshooting issues with residential and business LANs*Conducting site surveys and generating a quote*Installing complete networks or upgrading components*Troubleshooting and resolving PC issues *Replacing PC hardware and installing software *Working with a variety of operating systems that include Linux, Mac, and Windows*Removing malware and installing antivirus software to avoid future infections*Implementing local and network based backup solutions*Providing phone support and remote assistance*Testing and configuring IPTV equipment *Logging parts for inventory*Compiling a monthly Excel spreadsheet for the income generated by PC repair Accomplishments:*Passed Comptia Network+, Server +, Security +, and Cisco CCNA certification tests*Recognized with an "Employee of the Quarter" award*Generated extra monthly revenue for the PC repair department by selling a maintenance agreement to a business customer

Tulsa, Ok

*Troubleshooting hardware/software issues*Installation of a variety of Microsoft operating systems*Malware removal*Software based data recovery*Quoting/assembling custom PCs*Onsite service*Phone support*Customer serviceAccomplishments:*Passed Comptia A+ certification test

Tulsa, Ok

*Running cabling throughout different school buildings*Hooking up PCs*Deploying system images*Phone support*Resetting user passwords within AD*Testing for flaws within a student email service**After completing this summer internship, I enrolled and completed the requirements for the Cyber Security/Forensics program at Tulsa Tech**

Information Technology

Cyber Security/Forensics

Activities and Societies: BPA Member, Class PresidentParticipated in Cyber Security Invitational at OSU-Okmulgee