Experience

Welker

• United States
• Oil and Gas
• 1 - 100 Employee

• Director of Applied Technology

  • Apr 2022 - Present

• Applied Technology Manager

  • Jan 2017 - Present

  • Acted as system administrator/CNC for ERP JD Edwards EnterpriseOne 9.1 including package management, SAR deployment, and managing server reboots• Continuous JD Edwards E1 development utilizing Oracle Event Rules, ANSI C, Data Dictionary, Table Design Aid, Form Design Aid, Report Design Aid, Business View Design Aid, Data Structure Design, and Business Function Builder, resulting in over 150 custom objects/modifications• Acted as DBA for one Pervasive SQL database underpinning Global Shop, one Oracle SQL 11g database underpinning JDE E1, and one Microsoft SQL database underpinning SolidWorks 2017• Managed ten virtual machines residing on an Oracle VM Server infrastructure consisting of three Oracle X-5 blades, one ZS3-2 storage controller, one DE2-24c storage unit, and a StorageTek SL150 tape drive• Oversaw the transition of company email from an internal IMAP/SMTP server to Office 365 (Exchange Online), resulting in email uptime of 100% for 2017• Created a ratticDB password management system on CentOS 7 for encrypted storage of company and user logins and passwords• Implemented a 24TB virtualized Samba environment for internal company server backups• Managed the company Domain Controller, including Group Policy Objects Show less

• Corporate Projects

  • Jan 2016 - Dec 2016

  • Managed the technical side of $2 million ERP implementation of JD Edwards EnterpriseOne 9.1, Toolset 9.1.5.3• Reviewed design specifications, developed custom JD Edwards objects in Oracle Event Rules including UBEs and Interactive Applications, and tested the objects in DV and PY environments• Additional DBA duties related to Oracle SQL 11g database underpinning JD Edwards EnterpriseOne, including management of the JDE database structures• Coded custom business functions in ANSI C• Developed a financial model for determining optimal Safety Stock levels to work in tandem with an item forecasting model• Created a retention ratio model for company earnings Show less

• QA Analyst

  • Dec 2013 - Dec 2015

  • Performed data analytics on key metrics, including on-time delivery, non-conformances, and supplier performance• Completed root cause analysis on a representative sample of process and product deficiencies• Presented metric trends to management on a regular basis• Developed SQL queries and Excel spreadsheets that provided internal customers with accessible data• Consulted internal customers on the underpinnings of the ERP SQL database and automated repetitive work via scripting Show less