John Warkentin

John Warkentin | Lobox

User details

0Follower

0Following

0Mutual

0Post

Member since: Jan 22, 2025

About Availability

Bio

More than thirty years of experience in the Information Technology industry. Experience in various platforms and environments working with COBOL, DB2, JCL, Progress, LINUX, BASIC, and SQL. Dedicated and committed professional who enjoys precise data management, critical thinking, solving problems, analyzing code, providing technical leadership, and learning new concepts.

Experience

Worked on the SSUPDATE Incident queue on Team 26M, using MVS TSO, ISPF, COBOL, JCL, Endevor, Expediter, and File-Aid. Updated and tested changes to the SSUPDATE program. Provided analysis to clients when results did not match expectations. Used Teams, Excel, Word, Outlook, and Adobe Acrobat to communicate the complexity of problems to clients. Worked on the WinterFrost and Wagyu projects, adding functionality and flawless processing to existing BASIC programs in support of new products at Greater Omaha Packing. Analyzed user access to sensitive Finance menus and provided solutions to IT analysts for unwanted access. Analyzed, coded, tested, and implemented code changes in BASIC and LINUX to the ALPHA system for Production Incident Reports, Service Reports, and Change Requests. Updated and tested changes to cron jobs in LINUX. Used SQL Server, LINUX, Excel, and Word to analyze data changes over time. Created, tested, and scheduled a price change after hours using BASIC, ALPHA, and a LINUX cron job. Resolved errors in reports automatically created for Corporate decision-makers using LINUX, SQL Server, and Excel. Helped several departments with data entry, financial calculations, data cleanup, EEO initiatives, and onboarding at Prime Time Healthcare. Set up software and user IDs on new machines for a network migration at Prime Time Healthcare. Studied Salesforce programming during spare time at Prime Time Healthcare. Maintained EDI order and invoice systems with third-party entities at Future Foam, resolving transmission and data formatting errors.

Worked on the WinterFrost and Wagyu projects, adding functionality and flawless processing to existing BASIC programs in support of new products. Analyzed user access to sensitive Finance menus and provided solutions to IT analysts for unwanted and accidental access. Analyzed, coded, tested, and implemented code changes in BASIC and LINUX to the ALPHA system for Production Incident Reports, Service Reports, and Change Requests. Updated and tested changes to cron jobs in LINUX. Used SQL Server, LINUX, Excel, and Word to analyze data changes over time. Created, tested, and scheduled a price change after hours using BASIC, ALPHA, and a LINUX cron job. Resolved errors in reports automatically created for Corporate decision-makers in a timely manner using LINUX, SQL Server, and Excel.

Helped several departments with data entry issues, financial calculations, data cleanup, EEO initiatives, and onboarding of new employees. Set up software and user IDs on new machines for a network migration. Used spare time to study Salesforce programming.

Maintained EDI order and invoice systems with third-party entities, resolving errors in file transmission and data formatting in business-critical timelines. Designed, created, and implemented applications and reports for many projects. Wrote and tested UNIX scripts and Progress procedures. Created user documentation. Set up servers, printers, switches, and monitors at several locations across the United States. Managed rollout of software upgrades. Managed and repaired WYSE terminals and keyboards. Monitored file exchange and backups at all locations across the United States. Developed a help ticket system using ColdFusion, Oracle, HTML, CSS, and JSP at Alltel. Used CFMAIL tag to generate emails based on fields from an Oracle database. Formatted emails with HTML and included anchor links for easy navigation to the original ticket. Added ability for users to attach files to a help ticket, storing file names in an Oracle table and files on the LAN. Used JavaScript to create unique file names to prevent overwriting. Provided on-call support for Ringback Tones and Product Health Score systems using UNIX, Oracle, and URLs.

Developed a help ticket system using ColdFusion, Oracle, HTML, CSS, and JSP. Coded and tested several modules as part of a larger ticket tracking system. Used the CFMAIL tag to generate emails based on fields selected from an Oracle database. Formatted emails with HTML to present clear, concise, consistent help tickets to users. Included anchor links for easy navigation to the original ticket in the help ticket system. Added ability for users to attach any number of files to a help ticket, tracked file names in an Oracle table and stored files on the LAN. Used JavaScript to create unique and consistently formatted file names to prevent overwriting. Provided on-call support for the Ringback Tones and Product Health Score systems. Trained in the use of software and troubleshooting using UNIX, Oracle, and URLs.

Directed and controlled access to fourteen test environments. Acted as 'Air Traffic Control' for all people, data, processes, and machines for projects needing test environment resources. Coordinated requests for access and resources and administered requests in a library. Set up all requested security requirements. Wrote REXX CLISTS using DFSORT to extract and sort data in support of test projects. Created and supported REXX programs that supported testing of CICS and SQL code. Researched and set up data and processes as a test bed (DB2, VSAM, flat files, Control Cards, PROCs, JCL, Assembler, etc.). Set up and validated data and processes in the test environment. Deidentified sensitive data copied from Production. Administered, managed, and reported all bugs encountered during testing. Restored and backed up data during test cycles. Monitored, executed, managed, and repaired test cycles. Volunteered to improve practices by working with Change Management, Information Security, Software Maintenance, DBA, and Project Management. Improved SDLC methodology by restricting code library access, protecting sensitive data, coordinating third-party software upgrades, removing redundant resources, and coordinating project deliverables.

Designed, created, and implemented applications for many projects including conversion from flat files to DB2, Life Experience database, Annuity Data Warehouse formatting, Analytical DataMart support, Web Security monitoring, Media Code integration for Campaign Management, Face-To-Face Leads tracking system, Lead Universe Build, and Campaign Management. Created and documented procedures for creating a System Test Environment, eliminating more than 80% of effort and time. Maintained timely communication with Project Managers on all relevant tasks and issues. Mentored co-workers having difficulty with technical tools or workload efficiency problems. Volunteered for initiatives such as the LINUX Project and Environment Management.

Education

Recommendations

Contact

Location

Skills

Bio