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).
• 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.
• 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.

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.
• 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.
• 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.

• 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

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.
• 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.
• 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

• 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.
• 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.
• 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

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.
• 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.
• 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.
• 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

• 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.
• 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.
• 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.
• 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