Larry J. Cutshaw

PO Box 508

Chuckey, TN 37641-9998

Expert in AS/400 (I-Series), EDI, ERP, PC Platforms

Web Page

lcutshaw_consultant@comcast.net

Skills Summmary | Work History | Education and Courses
Skills | Special Training

Skills Summary

Extensive experience in analysis, design, development, programming, and implementation of systems on the AS/400 (ISeries) and other major platforms including IBM mainframe, DEC systems, and PC platforms utilizing a variety of tools and techniques. Solid background in cross-platform and business oriented-applications and functionality, along with experience in the latest in developmental and application technologies. These include EDI, .Net, Java, Web development, Websphere Development Tools, and other leading edge technologies. This is coupled with a results oriented background in traditional ERP systems, including Infinium, MAC-PAC, BPCS, MAPICS, and others to provide innovative leading edge solutions for companies today. Outstanding ability to work professionally with clients relating to their business environment and provide the appropriate technical solutions to their business problems. A highly responsive and responsible team player readily adaptable to new technologies and ideas.

[top]

Work History

Responsible for all phases of the systems development life cycle. Frequently developed multiple and complex interfaces to transfer data between different geographically disparate locations and dissimilar systems. Developed test cases or test approach, wrote and executed unit test and debugged programs. Provided systems and operational support as needed for various clients on an ad hoc basis. ILE COBOL, RPG IV, RPGLE, RPG free format, CLLE, DDS, DB2 SQL, FTP, IFS, stored procedures, trigger programs, WDSC, Hawkeye, batch and online processing in MAC-PAC.

Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC on I-Series. Implemented software and system changes in MACPAC environment to support reporting, data modification with respect to sales orders and manufacturing orders, and production schedule lead time changes. Resolved all issues remotely on ad-hoc basis for assorted clients. Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC in RPG III, RPG IV, RPG free, CLP, and DDS on I-Series.

Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC on I-Series. Implemented software and system changes in MACPAC environment to support reporting, data modification with respect to sales orders and manufacturing orders, and production schedule lead time changes. Resolved all issues remotely on ad-hoc basis for assorted clients. Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC in RPG III, RPG IV, RPG free, CLP, and DDS on I-Series.

Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC on I-Series. Resolved all issues remotely on ad-hoc basis for assorted clients. Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC in RPG III, RPG IV, RPG free, CLP, and DDS on I-Series. Also resolved issues with EDI trading partner setup in GENTRAN for 830, 856, 820, 825, and 856 transaction sets.

Responsible for resolving client based issues in RPG III, RPG IV, CLP, DDS, SEU, RPG Free on AS/400 (I-Series) in MAC-PAC and home-grown systems in a remote mode. Implemented software and system changes in MAC-PAC environment to support reporting and data modification in RPG III, RPG IV, and RPG Free. Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC. Resolved all issues remotely on ad-hoc basis for assorted clients.

Responsible for resolving client based issues in RPG III, RPG IV, CLP, DDS, SEU, RPG Free on AS/400 (I-Series) in MAC-PAC and home-grown systems in a remote mode. Implemented software and system changes in MAC-PAC environment to support reporting and data modification in RPG III, RPG IV, and RPG Free. Worked with financial and manufacturing systems with respect to changes and additions to MAC-PAC. Resolved all issues remotely on ad-hoc basis for assorted clients.

Responsible for AS/400 (I-Series) Innovative and Drakes and Associates system level multi-company conversion programming in CLP, DDS, RPG free, and RPG IV in support of business functions related to transportation on the AS/400 (I-Series). Converted programs from single company processing to multi-company processing, finished incomplete programs, and performed general consulting on EDI setup in non-translator oriented environment. Implemented 820s in same environment.

Responsible for AS/400 Innovative and Drakes and Associates system level programming in CLP, DDS, and RPG IV in support of business functions related to transportation and AS/400 (I-Series) system setup. Utilized single sign-on analysis setup and deployment on AS/400 (I-Series). Resolved EDI and system level problems associated with system migration, along with programming changes to accomodate new configurations in Drakes and Associates and Innovative customized software. Setup EDI communications utilizing SFTP and AS/400 (I-Series) PASE software.

 

Responsible for AS/400 (I-Series) MAC-PAC system level programming in support of business functions related to financial and order processing functions of MAC-PAC. Implemented software and system changes in MAC-PAC environment to support reporting and data modification with respect to sales orders processing for new plant implementation. Utilized multiple native AS/400 (I-Series) languages, including but not limited to, RPG, ILE RPG, RPG IV, CLP, DDS, queries, SQL, and SDA were also used for data query and change control respectively. Worked closely with Steelcraft staff on project development, enhancement, and implementation in a remote development environment to accomplish project completion.

Responsible for AS/400 (I-Series) MAC-PAC system level programming in support of business functions related to production schedule modifications. Implemented software and system changes in MACPAC environment to support reporting, data modification with respect to sales orders and manufacturing orders, and production schedule lead time changes. Wrote rules programs used to trigger events for processing applications . Utilized multiple native AS/400 (I-Series) languages, including but not limited to, RPG, ILE RPG, RPG IV, CLP, DDS, queries, and SQL. DBU, SDA, RLU, and Implementer were also used for data query and change control respectively. Worked closely with Atrium staff on project development, enhancement, and implementation in a remote development environment to accomplish project completion.

EDI GENTRAN conversion and upgrade from GENTRAN Windows NT Server 3.1.1 to 4.0.01 in windows 2000 Server environment. Performed pre-upgrade analysis, upgrade, and implementation. Also gathered trading partner information from partners and created transaction set maps for 850, 830, and 856 transaction sets in GENTRAN Server NT environment. Worked closely with customer EDI representatives and staff to effectively resolve EDI issues. Performed all work remotely through VPN and the internet in self-supervising environment.

Performed various consulting roles on different short term PC related projects, including HTML and Web development, financial package modifications and interfacing, EDI with Quickbooks Pro, PC repair and PC system troubleshooting. Worked with AS/400 (I-Series) Websphere Web facing tool with MAC-PAC to develop web interfaces for order entry applications. Also worked closely with consulting firm on specialized AS/400 (I-Series) project development and requirements processing fot Web enabling legacy applications with respect to legacy applications, notably MAC-PAC.

Worked in GENTRAN EDI to create inbound and outbound transaction sets for 830, 856, 820, 826, and 824s in MACPAC environment. Performed analysis, design, and coding to integrate EDI transactions into MACPAC order entry, shipping, and financial modules in manufacturing environment. Utilized multiple AS/400 (I-Series) languages, including but not limited to, ILE RPG, RPG IV, CLP, queries, and Sequel to effect programming solutions to the EDI interface. Worked closely with customer EDI representatives and Legris staff to effectively resolve EDI issues. Accomplished work entirely through remote hookup through VPN and DSL internet connection.

Consulted and worked in AS/400 Infinium and Synergen Oracle 9i environment on database interface project. Interfaced Purchase Order Management and Synergen Purchase Order nodules in real-time database interace using PL/SQL Developer, TOAD, and SQL in Windows 2000 Server environment interfacing to Infinium Purchase Order system on AS/400. Performed work remotely through VPN communications link entirely through remote hookup through VPN and DSL internet connection

Performed analysis, design, and coding in OBMS environment to convert existing sales, order, and manufacturing software to accommodate new corporate acquisition. Created both online and batch procedures integrated into the ODMS system environment along with modifications to existing OBMS programs to effect processing for sales, order entry, sales reporting, and manufacturing, international data processing requirements. Designed, developed, and implemented programs in RPGIV, RPG, SQL, CLP, and DDS in both online and batch environments

Performed analysis, design, and coding in Infinium environment to implement pre-invoicing in medical environment. Utilized job controls and other Infinium internal features to effect purchase order management and invoicing solutions to financial applications problems. Created both online and batch procedures integrated into the Infinium environment along with modifications to existing Infinium programs to effect pre-receipt invoicing processing for accounting and auditing control. Enhanced visibility of current transaction types and added new auditing transaction types for visibility. Utilized ILE RPG, RPG IV, embedded SQL, and other AS/400 native languages to effect programming solutions and modifications.

Worked in Peregrine EDI creating EDI translation maps for processing inbound transaction sets for customer trading partners. Used CLP, RPG IV, and AS/400 COBOL to process data into ODS manufacturing system. Used GEIS and IBM Network Data Interchange to setup and receive trading partner information. Directly responsible for obtaining and evaluating trading partner EDI requirements with respect to existing system requirements. Converted RPG code to AS/400 COBOL for use by programming staff.

Worked in GENTRAN EDI on the AS/400 to create inbound and outbound transaction sets for 830, 856, 862, and 824 transaction sets. Designed and integrated Toyota Motor Sales, Harley, Mitsubishi, and other trading partners in ILE RPG IV to support order processing and order fulfillment. Designed and coded automated EDI processing system to aid in correct and timely processing of transaction sets and trading partners. Utilized prototyping, service programs and other ILE concepts to effect solutions to data processing problems along with CLP, DDS, TL Ashford barcoding, and panel groups. Designed and coded inventory case management system using both online and batch system processing to support inventory management of EDI order processing requirements.

Responsible for AS/400 system level programming to implement TCP/IP interfaces to Novell LAN. Acted as lead technical resource as to AS/400 configuration, operation, and system capacity planning. Utilized BEST modeling tools to analyze future system requirements as to system hardware ands software requirements. Implemented software and system changes in MACPAC environment to support Infoprint32 network printer and printing of company invoices and account statements. Performed analysis, design, and coding for support of EDI GENTRAN in order processing module(s). Utilized data queues, LPD and LPR to resolve TCP/IP printing problems. Designed and implemented unattended backup procedures both in and out of ROBOT scheduling system. Worked closely with upper management to assist in enhancing AS/400 operations and system environment. Created procedure to produce electronic overlays for use on the AS/400 used Windows PC based software. Designed and implemented utility to create DDS source files from RPG or RPG IV source members.

Designed and implemented multiple custom system interfaces to Infinium 2000 systems including 401K processing, employee benefits, general ledger, accounting, payroll, and human resources. Designed multi-platform security using Client Access, Windows 95, and Windows 98 functions. Utilized APIs in RPG IV in both online and batch processes and Infinium job controls. Performed general consulting on Microsoft Access and Excel transfer and security issues, along with creating file transfers from and to the AS/400 with IBM file transfers and Client Access. Configured and wrote exit programs for AS/400 servers in RPG IV to enhance security across platforms. Performed general maintenance and enhancements to current Infinium systems in RPG IV. Also performed Y2K analysis and implementation for homegrown interfaces to Infinium. Utilized CLP, DDS, SQl, and other AS/400 tools to effect programming solutions to business problems. Designed benefits conversion implementation to load benefits information into Infinium.

Performed general consulting on systems integration between BPCS and Future III systems with respect to manufacturing, order entry, inventory, purchase orders, shipping, and EDI systems in AS/400 environment. Programmed in RPG/400, CLP, SQL, and utilized other AS/400 utilities to effect online and batch solutions to manufacturing systems problems. Also performed general maintenance and enhancements to current BPCS systems in RPG/400 and etc. Consulted on EDI conversion issues between Future III systems and solved EDI problems between EDI trading partners and Hurd. Resolved Y2K issues withinn Future III. Interfaced PC EDI transmisssions in GENTRAN with AS/400 systems using Access 97, Microsoft SQL Server, Windows NT 4.5, and SQL on AS/400 for data transfers between PC and AS/400.

Enhanced and modified several PRMS financial, order entry, and manufacturing database applications to customer specifications. Provided emergency system and general project support until a permanent programming resource was found. Instrumental in PRMS forecasting modifications and project analysis. Assisted in PRMS version upgrade and conversion with respect to additional company acquisitions. Performed general technical consulting as to system operations and software implementation and management.

Performed general consulting on systems integration between BPCS and Future III systems with respect to manufacturing, order entry, inventory, shipping, and EDI systems in multiple AS/400 environments. Programmed in RPG/400, CLP, SQL, and utilized other AS/400 utilities to effect online solutions to manufacturing systems problems. Also performed general maintenance and enhancements to current BPCS systems in RPG/400 and etc. Consulted on EDI conversion issues between Future III systems and solved EDI problems between EDI trading partners and Hurd. Interfaced PC EDI transmisssions in GENTRAN with AS/400 systems using Access 97, Microsoft SQL Server, Windows NT 4.5, and SQL on AS/400 for data transfers between PC and AS/400.

Redesigned and coded online physical inventory system in RPG/400 for user friendliness and software function. Used CLP, occurs data structures, message subfiles, windows, and other online screen display techniques to streamline information presentation and enhance the user interface for ease of use and functionality. Designed and wrote conversion software for migration from old to new system in CAMS/400 environment. Performed ad hoc consulting on other MIS projects.

Designed and coded online bill and hold system in ILE RPGIV for shipping system. Utilized user spaces, APIs, and pointers in RPGIV to effect programming solutions to business problems. Also used recursive design techniques in programs to allow an OOPs design paradigm. Used CLP, occurs data structure, message subfiles, windows, and other online screen display techniques to streamline information presentation and enhance the user interface. Used interactive debugger for both RPGIV and RPG/400 along with DBU and SQL to test and debug software.

Redesigned and coded problem tracking system in ILE RPGIV for consumer affairs division of Coca-Cola. Programs were all online and included inquiry and maintenance functions. Also designed and implemented a menu control system to support all online functions. Used program binding and service functions of ILE along with message subfiles, occurs data structures and other techniques to streamline and optimize program performance

Designed and implemented program and file analysis system for project tracking and audit purposes on AS/400 date and item field length conversion project under DISTRACK. Performed critical project analysis and actual program and file conversions utilizing aforementioned tracking system on large system project. Performed conversions using RPG/400, CLP, Query, and other OS/400 features and languages including APIs and SQL to affect final programming and file conversions. Used Aldon change management software to implement and track changes..

Performed PC to AS/400 system conversion from O'Hanlon PC based system to QTOPS brokerage software utilizing Novell LAN upload network software. Designed and wrote data Conversion software for receivables, carriers, customer information, order information, and other System information. Also converted PC customer information to load to Tele-Magic sales information tracking system. Designed and implemented agent settlements system allowing user control of settlement types, amounts, and other critical information. Utilized RPG/400, CLP, Query, and other OS/400 facilities to accomplish project requirements along with PC based C++, Visual Basic 3.0, and QBASIC to accomplish data reformatting for upload and conversion. Worked closely with end users to develop requirements for the upload and conversion.

Performed development and maintenance under MAC PAC utilizing Sequel, RPG/400, CLP, Query, IQ38, EASYVIEW, CMS, Implementer, and other AS/400 functions and techniques to effect data processing solutions to backlogged service requests. Worked closely with end users in manufacturing systems such as JIT, flow authorization, and inventory control, and also in financial systems. Programmed system to system customized asynchronous data transfer in AS/400 peer to peer network. Used APIs, subfiles, APPC/APPN communications, and data queues in assignments to effect timely and effective solutions to data processing problems. Worked closely with users to develop and enhance systems with respect to usability and understandability. Also received training in Lotus Notes with respect to database design and administration. Used Aldon change management to test, track, and implement changes.

Designed and implemented multi company processing under CAMS for corporate acquisition and merger. Utilized RPG/400, CLP, Query, DBU, and other OS/400 functions to effect data processing solutions to the problems presented by the acquisition and merger. Implemented changes throughout entire system including Order Entry, Production Planning, Inventory and Claims. Provided general consulting as to system performance and change control. Worked closely with users to develop and enhance systems with respect to user friendliness and usability. Developed program implementation and recompilation system to eliminate level checking with respect to files and programs and implemented conflict resolution system for use by programming staff. Solved emergency production problems in self supervising atmosphere with respect to Order Entry, Inventory, Claims, Billing, and Sales systems.

Designed and developed salesman commission tracking system for integration with DMAS system on AS/400 in RPG/400. Customized DMAS system software to enable client to more efficiently and effectively utilize DMAS databases for sales, order entry, and financial decisions. Utilized Query/400, CLP programs, subfile programming and other AS/400 OS/400 techniques to effect programming solutions. Performed all analysis, design work, and programming. Consulted with and trained client personnel during implementation of system modifications and new development work. Also designed and implemented new backup procedures for AS/400 and DMAS.

Developed and designed customized software for manufacturing in process system on AS/400 in RPG/400. Utilized CLP, Query, PC Support, and other AS/400 functions to effect data processing solutions to manufacturing problems. Also developed and designed shipping and warehousing software to support distribution center functions with respect to inventory and trucking. Designed system to maintain production mirror from AS/400 to AS/400 using data queues and ICF files. Performed general technical consulting with respect to programming problems and solutions. Designed and implemented asynchronous data transfer software from AS/400 to PC and from PC to AS/400 with PC Support.

Customized and enhanced BPCS system in both on line and batch processing on AS/400 in RPG/400 utilizing BPCS database design and modified BPCS programs. Utilized CLP programs, on line and batch processing, and other AS/400 features to effect final data processing solutions to customization problems. Also designed and implemented original software in both on line and batch modes to satisfy customer requirements. Interfaced with all levels of customers in order to determine design requirements and programming solutions to business problems. Performed general consulting for Zartic employees in a technical mode as to AS/400 performance.

Designed and implemented shipment confirmation system with PC interface to AS/400 in RPG/400 utilizing PRMS database design and modified PRMS programs. Utilized data queues, SQL, CLP, and other native AS/4000 languages in both online and batch processing, APPC/APPN, and other AS/400 features to effect final data processing solution to problems. Also designed and implemented error correction programs and procedures using suspension file techniques to correct erroneous data. Interfaced with IDSI clients on a continuing basis to determine design requirements and programming solutions to business problems..

Developed on line and batch systems in RPG/400 for mainframe to AS/400 conversion in heavy manufacturing environment for BPCS. Employed CLP, queries, SQL, DBU, and other system functions to satisfy customer reporting and processing requirements. Performed general consulting with management and other data processing personnel to resolve design and implementation problems with respect to the conversion.

Planned and developed on line and batch systems in COBOL and RPG/400 on AS/400 in custom manufacturing environment in MAPICS. Also designed and executed configuration for system security and setup for job queues, subsystems, and data communications in token ring peer to peer architecture. Employed CLP, queries, EZVIEW, and other AS/400 OS/400 services to satisfy customer processing and reporting requests. Worked closely with both end users and data processing staff in consulting on software solutions to both technical and business problems. Also responsible for emergency service request problem solving and implementation of data processing solutions to emergency problems.

Developed on line software for a barcode inventory management system in RPG/400 on an AS/400 in MAPICS. Utilized CLP, DBU, query, and other OS/400 system functions to both design and implement innovative software solutions to data processing design problems. Bar code system utilized radio connected terminals in a heavy manufacturing environment. Designed global internal record locking and error handling routines for use by entire system. Worked closely with warehousing staff to meet their initial setup and processing requirements with respect to internal warehouse organization. Responsible for both issuing and receiving portions of the bar code system with respect to both design and coding in an on line environment.

Designed and developed software interfaces between PRISM, Innovative, and DSI software packages on AS/400 and 3090 mainframe in RPG/400, CLP, SDA, and DFU on AS/400 and COBOL, JCL, and JES2 on 3090 mainframe. Worked with both batch and on line solutions on the AS/400 to accomplish necessary on line subfile error corrections and interfaces with RJE batch transmissions on a prescheduled basis. Applications involved include Cost Accounting, Shipping, and Transportation Load Makeup. Conducted unit testing of interfaces between software packages on the AS/400 and the transmission interfaces from AS/400 to 3090 and from 3090 to AS/400. Performed general consulting with other team members on various design issues and technical questions.

Planned and developed on line airline schedule printing control software on AS/400 in COBOL. Used CLP, DDS subfile programming, DBU, and other OS/400 system functions to implement software solutions for the final design. Prototyped and effected internal program designs for all command key functions required for the external project design. Also consulted on AS/400 performance tuning and implemented some performance enhancements. Responsible for unit testing of completed software and installation of design enhancements along with problem solving and general technical consulting with other project members.

Provided emergency support, enhancements, and development for software control system EDISON on AS/400, System 38, and System 36 for MAPICS. Effected software solutions to emergency problems, configured and resolved problems with data communication networks associated with EDISON. Provided general technical consulting and support for IBM internal MAPICS packaging problems. Planned and enhanced related systems such as APAR processing on the AS/400. Utilized RPG III, CLP, EZVIEW, and other OS/400 functions to resolve data processing problems. Also employed VM/CMS, REXX, and EXEC 2 on IBM mainframe to solve APAR transmission problems to and from AS/400, System 38, and System 36.

Solely responsible for debugging and analysis of software problems on the System 38 and implementation of software solutions in a manufacturing environment. Employed RPG III, CLP, PROBE/ABSTRACT, and other system productivity tools to effect data processing solutions. Also responsible for system performance analysis and tuning. Installed and implemented RJE bisynchronous communications software. Supervised outside contractors in development of customized software. Designed and developed systems to interface with outside vendors software in both batch and on line environment. Involved in future systems requirements evaluation.

Designed and implemented on line systems for manufacturing use in RPG III and CLP on System 38. Used DBU and System 38 productivity tools to produce on line and batch systems in textile environment. Also performed regular and emergency problem solving and maintenance. Worked closely with users to enhance and develop reporting and accounting systems under ABS.

Designed and implemented on line accounting systems on DEC 10, VAX 11/780, and VAX 8700 under TOPS 10 and UNIX operating systems respectively. Interfaced with customers in subcontracting environment to design, implement, and/or modify software in FORTRAN, System 1022, MIC, and INFORMIX. Telecommunications experience in DECNET and KERMIT were also used to affect programming solutions to data processing problems. Responsible for establishing corporate reputation and credibility with customers at Oak Ridge National Labs..

Responsible for emergency problem solving for on line and batch systems dealing with the business, personnel, and financial operations of the university under MVS/OS, JCL, COBOL, Easytrieve, Easytrieve Plus, IMS, Panvalet, TSO/ISPF, and JES2. Also responsible for development and maintenance of applications on the IBM System 38 for all admissions, holds, recruiting, and administrative systems in RPG III and COBOL. Performed general technical consulting for OIS with respect to development of office programming standards, change control design, and under MVS/XA implementation of TSO/ISPF using CLIST and the TSO/ISPF Panel Development Facility.

Responsible for Product Distribution and Sales System database performance analysis and reporting in an ADABAS/NATURAL environment. Maintained applications to enhance system performance on IBM 3081 mainframe. TSO/ISPF, VTAM, COMPLETE, and the NATURAL programmer productivity tools were all utilized to implement on line fleet order processing for Chevrolet. Also designed and implemented a customer performance analysis system for use by on line customers. Performed performance problem analysis and resolution along with system utilities support and enhancement.

[top]

Education and Courses

VAX 11/780 Assembler, COBOL, FORTRAN 77, BASIC, Data Communications, Database Management, Accounting, Business Law, Advanced Programming Techniques, Statistics, Structured Programming Techniques,and other programming related courses. Developed on line programs in COBOL, FORTRAN, and Assembler for use in an on line business environment.

Electronic Music Techniques, Music Theory, Counterpoint, Orchestration and Instrumentation, and other music related course work. Also 2 years course work in Architecture with Calculus, World Art, architectural design, Structures and Materials,and other architectural studies.

[top]

Skills

AS/400

[top]

EDI

[top]

IBM Mainframe

[top]

Personal Computers

[top]

DEC Systems

[top]

ERP Systems

[top]

Special Training/Certificates