Walt Grace Email & Phone Number

Herriman, Ut, Us

• Designed, developed, and implemented a Role Based Access Control (RBAC) system; using IBM Data Studio to design the database, SQLRPGLE-FREE programs and service programs to encapsulate the tables (data access object), store the RBAC functionality and create maintenance programs• Designed, developed, and implemented a dynamic sql generation program, as part of the loan servicing import system development, to import variable loan information updates received, and apply the user approved data changes to the loan servicing system using SQLRPGLE-FREE and sql functions; also modified other parts of the loan servicing import system• Helped maintain and improve the commercial lending system using SQLRPGLE-FREE• Streamlined the bank wire system for creating and transmitting bank wires for home loan closings• Designed, developed, and implemented various reports using SQLRPGLE-FREE• Initiated modernization of the existing legacy system by introducing a layered software architecture through the use of modular SQLRPGLE-FREE service programs, table access encapsulation, copy books, and centrally defined common constants (to replace hard-coded values) • Mentored other developers on using service programs to create libraries of related procedures (eg. string manipulation) for maximum reusability• Mentored other developers on implementing a layered architecture using service programs and layer level binding directories

Peachtree Corners, Georgia, Us

• Implemented architectural standards for Programming and Design development• Initiated modernization of the existing legacy system by introducing a layered software architecture through the use of modular service programs, table access encapsulation, copy books, and centrally defined common constants (to replace hard-coded values)• Initiated modernization of the legacy database through database normalization, introduction of sql referential integrity, sql triggers, sql views, sql functions, and sql procedures• Developed a Distribution Dashboard to help manage Labor Costs by estimating labor needed according to order volume using SQL and MS Excel• Improved manufacturing order entry by providing the user the functionality (using recursive SQL and SQLRPGLE-FREE Service Programs) to enter an order for a finished good, and having the system generate the remaining manufacturing orders needed for all the lower level assemblies found in the Bill Of Materials (this allowed Plaid to reduce Production Control workforce by one)• Designed, developed, and implemented an Imports Receiving system using SQLRPGLE-FREE Service Programs, sql tables, sql views, sql triggers, and sql procedures, and leveraging EDI documents (214, 315, 856) in order to keep Purchase Orders updated for our JIT processes• Managed Plaid's installation of Manhattan's Warehouse Management System (PKMS) and the interface to the in-house developed Host system• Developed, implemented, and managed EDI documents and processes using TrustedLink• Designed, developed, and implemented various reports using SQLRPGLE-FREE, sql views, sql functions, and sql procedures• Designed documents (labels, invoice, etc) using Mark Magic• Managed helpdesk for production issues• Managed user system access security• Used Catapult software to manage report distribution• Used Monarch software to parse IBMi legacy reports and output Excel spreadsheets

• Performed Production Support, Development, and Design for Kubota's customized BPCS manufacturing system, using an SDLC process and languages such as RPGLE, CLLE, and SQL• Designed and implemented a generic reporting system using RPGLE, SQL, and Service Programs, allowing the quick and easy creation of reports that can be displayed on screen, printed, or emailed in multiple formats• Consolidated multiple physical inventory systems into a more stable homogenous modular system • Helped design and develop a managed inventory system that included external vendor managed inventory, using object oriented methodology• Designed a shipping tracking system• Was involved in the project to create an electronic update interface with corporate headquarters in Japan• Was involved in the BPCS LX conversion project• Developed a plan for implementing a stable layered architecture for the customized system• Mentored other developers on using service programs to create libraries of related procedures (eg. string manipulation) for maximum reusability• Mentored other developers on implementing a layered architecture using service programs and layer level binding directories

Jacksonville, Florida, Us

• Performed Production Support, Development, and Design for LOTSolutions' insurance information system using an SDLC process and techniques, languages, and structures such as UML, RPG, RPG-FREE, RPGLE, CLP, CLLE, embedded SQL, Service Programs, Stored Procedures, and Triggers• Using an Object Oriented methodology, designed and implemented a database file encapsulation system using UML, RPGLE-FREE, embedded SQL, and Service Programs • Helped maintain the system's Service Oriented Architecture, which was developed to support the system's .Net web client, and was implemented using triggers and stored procedures, comprised of either SQL, RPG/LE programs, or sub-procedures• Designed and created, using SQLRPGLE-FREE service programs, a system to handle incoming and outgoing digital document exchange with clients and partners; FTP Manager was used as the front end• Developed a generic file mapper using SQLRPGLE-FREE service programs in order to facilitate the mapping of incoming and outgoing Client files to/from their proprietary formats into LOTSolutions specific file formats• Developed a Proprietary Billing System Interface between various internal Applications and an external .NET application• Created Table Maintenance programs using Progen, the Application Development package• Helped develop some of the SDLC process documents• Helped develop and deploy some of the System Architectural standards and documents

• Used RPG/ILE Free and embedded SQL to produce assorted reports• Created Table Maintenance programs using RPG/ILE Free, embedded SQL, Service Programs, and SubFiles• Designed a Transportation and Materials Management system for a local manufacturing company• Implemented various Utility Service Programs, with RPG/ILE Free, covering OS/400 system functions, SQL functions, and other useful ‘Built-in’ functionality

• Designed, implemented, and maintained solutions for AT&T's proprietary client/server customer management system, CARE • Used standardized RPG procedures, service programs, and header files to implement solutions using object oriented methodology which resulted in extensively reusable modular programs and significantly reduced design and coding time on projects• Used service program procedures and header files to encapsulate commonly used OS/400 system functions and AS/400 APIs, making them easily accessible from RPG programs• Designed and implemented, using RPG and embedded SQL, an efficient cutting edge bulk customer account extract and purge system that is completely database driven and will extract customer account information from every relevant file in this very large customer management system• Designed and implemented an interactive database journal search system which helped when attempting to determine where system errors may have occurred• Created an SQL analysis tool to help determine which SQL programs were misbehaving• Maintained Sockets service program used for direct communication with other systems, written in C• Helped define the system programming and design standards documents• Implemented a searchable online knowledge base system for the CARE billing system using Linux, PHP, CSS, Apache, and Xoops

Peachtree City, Georgia, Us

• Designed, implemented, and maintained a powerful inventory tracking and balancing system for finished products which interfaces with MAPICS sales, shipping, and inventory systems as well as Quick Receiver and was produced in modular fashion using RPG/ILE, service programs, and embedded SQL for filtering• Proficiently converted the company from MAPICS v3 to MAPICS v4 in response to the notorious year 2000 bug which included modifying and testing several hundred custom RPG and COBOL programs, some of which interface with MAPICS• Developed an effective Service Parts system used to fulfill custom parts orders and saving the user several hours per day by consolidating all reporting functions into the interface through the use of embedded SQL which also reduced printing needs, as all information required for reviewing orders could now be efficiently obtained online• Successfully converted warranty data from a custom system on their previous AS/400 to WCFields on their current AS/400 in response to the year 2000 issue and then again to a newly developed warranty system• Created custom routing sheets for use in Production Control by using the overlay function available• Devised critical accounting interfaces and reports including custom customer statements with revised ageing analysis• Produced informative reports for the sales department• Created and documented a standardized system naming convention for easily identifying programs• Provided support and training for the in-house IT staff on AS/400 operations

• Configured and maintained the Red Hat Linux Server which included configuring Apache with complex redirection schemas, maintaining security through the use of IP Chains, configuring SSL and Secure FTP for use, etc• Maintained SinglesInternet.com’s dating application, written in Perl and JavaScript, and improved the system through modularization and layered abstraction, documentation, and the introduction of programming standards• Converted the application from hardcoded HTML formatting to Cascading Style Sheets, to facilitate easy changing of the site’s appearance• Removed HTML code, embedded in many programs, to their own files and used tokens to be able to populate these forms from the database• Installed and integrated a credit card billing system

Stamford, Ct, Us

• Increased my AS/400 knowledge by learning and using more OS/400 objects, SQL, RPG IV, and ILE• Encouraged and facilitated the introduction and use of RPG IV and ILE by demonstrating its ease of use, reusability, and program maintenance efficiency• Implemented a set of service programs using RPG IV and ILE that act as a system template for creating a highly functional file maintenance/inquiry/selection program including the ability to sort on any column, filter on any column, and user defined custom sorting by profile• Designed and implemented an automated system to download data from the AS/400 into an Excel spreadsheet to refine the daily commodities position into information the accounting department could use, quickly and easily, saving the company several thousands of dollars monthly• Provided internal customer support, program maintenance, and other custom programming solutions to increase productivity

• Provided system administration for the AS/400, Novell Netware, DEC VAX, and LAN/WAN network• Supplied some light programming using RPG for the JD Edwards system implementation project as well as administration of JD Edwards, including user configuration and menu customization

• Responsible for customer phone support which entailed helping customers to set up and troubleshoot their modem issues so that they could connect to this Internet service provider

• Project leader for implementing the Health Care Center Management system for several clients which covered the following tasks; devising an installation schedule, writing data conversion programs and overseeing database population, configuring the AS/400 for communications using both modems and digital multi-port leased lines, setting up terminals and PC's, installing printers, coordinating wiring installation, hardware options cost analysis, as well as tailoring the system software through program modifications using RPG to meet unique client needs• Conceived and taught training classes for client employees on the use of the Health Care Center Management system• Designed an Immunization Tracking System for the AS/400 to be used in conjunction with the Carter Center child immunization project• Designed and implemented the reporting system for the Health Care Center Management System using RPG• Provided system maintenance and development using RPG for the Health Care Management system