John Hess Email & Phone Number

Saint Paul, Mn, Us

 Manage day to day operations of multiple large Oracle Data Warehouses totaling 70TB Monitor and support Informatica ETL jobs Proactively tune databases to improve the performance of daily batch processes Log and manage problem and change tickets to support our environment Developed process to archive unused data in our databases, thereby saving on disk and reducing our risk of data exposure Co-led upgrade of 50TB Oracle 10g database to Oracle 12c, working with system dba team

 Perform upgrades of Microsoft Dynamics Great Plains software and internally developed Feed Mill Management Software on external customer systems Install/Upgrade Microsoft SQL Server on external customer systems Support SaaS websites hosted in Azure. Perform updates and deployments of new code to sites per customer and development requirements Log and manage CRM Cases for external customers Developed a Change Management process based on ITIL principles Developed onboarding document for new product specialists Improved documentation used for performing MS GP upgrades and other internal documentation

Hopkins, Mn

 Carry out and enforce Cargill’s data retention and information policies Mentor and coach colleague in risk controls, processes, and best practices Manage database services through global processes Provide operational support for over 1,600 Oracle databases and 2,000 SQL Server databases globally Contributed to cross-training as Latin American and North American teams merged Provide support for SAP rollout in the company Led projects for new database setups, disaster recovery scenarios, upgrades A primary resource for data center move, setting up Dataguard standbys to facilitate the switchover. Database patching using Grid Control procedures Advanced compression and ASM implementation

Hopkins, Mn

 Helped developed the software distribution process according to compliance and licensing policies Performed monthly audits on key metrics including Microsoft patch compliance and other IP minimums Continued participation on Architecture sub-domain groups (Client and Client/Server Security Tools) Defined local admin rights policies Wrote virus remediation processes for the Service Desk Created IP Dashboard that facilitated EUC’s high IP standards Wrote variances for legacy support tools Cleaned up user access during outsourcing initiative Worked with BUs and other IT groups to resolve issues with support Trained Service Desk and Client agents in Pune, India and Minnetonka Developed processes for support and management of 25,000 North American client devices

Minnetonka, Mn

 Developed script for determining “health” of local desktops and laptops in accordance to IP and PC Standards Developed a thorough knowledge of Altiris for packaging, imaging, and client recovery (Notification Server, Deployment Server, Recovery Server) and ITSM/Remedy’s Incident, Change, and Configuration modules Participated on Architecture sub-domain groups to set client direction and security tools Provided Level 2 and 3 support for 3,700 devices throughout North America Hardware support for desktops, laptops, and thin clients

Blair, Ne, Gainesville, Ga

 Participated in plant IP walkthrough and Information Protection education of the local user base Packaged software for global project using Wise Package Studio Worked in plant environment for 5 years providing support Provided Level 2 and 3 support for 3,000 devices throughout North America Participated in new workstation deployment project for over 3,500 laptops and desktops Provided mentorship to several college interns and high school co-op students Developed “single” image for use across multiple devices and models (laptop/desktop)