Jonathan Grady Email & Phone Number

Pewaukee, Wi, Us

Pewaukee, Wi, Us

• Support 450+ end users in 51 locations across 22 states.• Direct and Influence decisions regarding P21 Third Party Integrations and fundamental process changes.• Develop SQL scripts and data maps for third-party integrations with Prophet 21.• Create isolated testing environments for Conference Room Pilots of major Prophet 21 version releases.• Deploy and test upgrades to the Prophet 21 software in an RDS environment across 20 Servers.• Develop Process Documents for navigation of Prophet 21 processes and procedures.• Research and Develop use case information for Solution Concept Forms for Custom Modifications developed by Epicor Support for the Prophet 21 software.• Estimate the Scope of Work for Prophet 21 projects.• Develop & deploy custom External Reports for Prophet 21 Crystal Report Viewer using Crystal Reports.• Develop Business Rules for Prophet 21 software using T-SQL and C# class libraries.• Develop Portals for Prophet 21 using Infomaker and T-SQL.• Support Epicor Data Analytics (EDA) reporting platform.• Develop SQL Scripts to modify and enhance existing Databases and create new databases in the EDA platform• Support Epicor Manifest shipping platform.• Manage, Support, and Resolve projects and end-user issues using Trello Boards and the Freshservice ticketing system.• Develop export files, import files and data maps for data integration.• Develop SQL scripts to update and/or fix data missed or incorrect after data migration• Create Tables, Views, Triggers, Stored Procedures and SQL Agent Jobs using SQL Server Management Studio.• Develop Automation for third-party imports/exports, data validation, FTP file sends and retrieves, Prophet 21 rebuilds and existing Prophet 21 Stored Procedure fixes outside of the Prophet 21 software.•Analyze current Prophet 21 business processes to recommend avenues to increase efficiency and reduce errors

• Designed website using Wordpress template and input from the Directors. • Used PHP, HTML, and CSS to edit and modify a template to fit their needs.• Manage, monitor, and update website content on an as needed basis.

• Manage Windows Server 2008 R2, Server 2012 R2, Microsoft SQL Server 2012, and Epicor Prophet 21 ERP software in a Hyper-V and Remote Desktop Services environment. • Develop and implement SQL Server Integration Services ETL processes to integrate with cloud-based applications using Microsoft Excel, Google Sheets, C# scripting and JavaScript. • Develop & deploy custom reports in SQL Server Report Services and Crystal Reports.• Develop & deploy custom reports for the Prophet 21 Crystal Report Viewer using Crystal Reports.• Handle desktop support and maintenance.• Installation of computers and computer peripherals (i.e. copiers, printers, projectors, monitors, etc.).• Train new and current employees how to use the software packages such as Microsoft Office and Prophet 21.• Create and manage AppSheet apps created for use by Sales Representatives in the field (i.e. RMA Entry and Activity Log).• Handle setup and maintenance of the company iPhones/Samsung Galaxy phones and iPads.• Support company wide end-users at Texas and Mississippi locations, as well as Customers from Arizona to Florida via email, text, phone, and remote connections as well as physically within the office.• Troubleshoot issues with Prophet21, Server hardware, networking, cell phones, iPad/tablets, desktops, as well as website and customers, items, dealers, and suppliers information in the Prophet21 system.• Migrate company website to SimpleWeb on the Joomla! platform using the SimpeWeb API, PHP, Bootstrap, CSS3, HTML5, and JavaScript.• Customize ERP software using T-SQL and C# class libraries(Prophet 21 Dynachange Business Rules) that integrate with and enhance the enterprise software.

• Handle desktop support and maintenance, Barracuda firewall, and installation of computers and computer peripherals (i.e. copiers, printers, projectors, monitors, etc.).• Researched and purchased items for administrators, faculty, and staff.• Small repair of peripherals (i.e. projector bulbs, copier drums, computer hard drives, and virus removal).

Brownwood, Tx, Us

• Monitor student use of University Lab computers. Assist students with minor computer and printer issues. • Helped students with work related to Computer Information Classes.

Kohler, Wisconsin, Us

• Set up equipment for employee use, performing or ensuring proper installation of cables, operating systems, or appropriate software.• Installed and performed minor repairs to hardware, software, or peripheral equipment, following design or installation specifications.• Printed labels and fixed Zebra Label Printers.

Bachelor Of Science (Bs), Computer Information Systems-System Development

Associate Of Arts (Aa), General Education