SUMMARY:

• Skilled programmer in many different applications including Shop Floor Control and Costing
• Experienced developer in RPG, CL and ILE
• IBM Certified AS/400 Developer
• Effective and comfortable working and communicating from the boardroom to the production floor
• Create STORED PROCEDURES on the AS/400 to feed Retail Web Order inquiries.
• Accomplished and talented information technology professional with extensive project management, programming management and consulting experience.
• Skillful staff developer and team builder, with superb analytical skills.
• Broad technical background, which includes process/systems analysis and design for infrastructure technology groups.
• Extensive business knowledge and experience in many industries.

TECHNICAL SKILLS:

Operating Systems: OS/400, CPF, S/36, DOS, WINDOWS, UNIX

Languages: RPGFREE, RPG/ILE, RPG/400, RPG III, RPG II, CL, CLLE, SQL

Utilities: SEU, SDA, RLU, ODBC, DFU, QUERY, FTP, TOAD

Hardware: AS/400(iSeries), SYS/38, SYS/36, SYS/34, PC, Dematica

Miscellaneous: MAPICS, Specialty Insurance System, ALDON, Turnover, MKS Implementer, XPOINT, BPCS, PKMS, EZ - Print, Infinium, Lawson, DBU, GENTRAN, Trusted Link(Harbinger), TCP/IP, MS-Excel, MS-Word, MS-Access, MS-Project, Client Access.

PROFESSIONAL EXPERIENCE:

Confidential, Solon, OH

Senior Developer

Responsibilities:

• Production support analyst for PRMS in manufacturing AS/400 environment.
• Design, Develop and implement new Put away Process for Warehouse system.
• Implement EXCEL production from RPG on AS/400 in batch environment.
• Troubleshoot and modify nightly processing.
• Monitor AS/400 QSYSOPR for processing issues and resolve repetitive errors.
• Apply PTF’s for AS/400 operating systems upgrades..
• Meet with users to get requirements for new reporting.

Environment: AS/400, CLP, CLLE, RPGLE, RPGIV, RPGFREE, SQL.

Confidential, Columbus, OH

Application Developer

Responsibilities:

• Production support analyst for Infor XA in Drug packaging manufacturing AS/400 environment.
• Design, Develop and implement new Interface Process for New Warehouse system SQL Database to AS/400 ERP system for updating.
• Implement EXCEL production from RPG on AS/400 in batch environment.
• GENTRAN EDI support on AS/400 mapping and client setup.
• Implement New TEST environment and Quality Control for coding on AS/400.
• Monitor AS/400 QSYSOPR for processing issues and resolve repetitive errors.
• Apply PTF’s for AS/400 operating systems upgrades.
• Administer TURNOVER as needed.
• Meet with users to get requirements for new reporting.
• Use SHAREPOINT to provide users with data mining capabilities.

Environment: AS/400, CLP, CLLE, RPGLE, RPGIV, RPGFREE, SQL.

Confidential, Shelbyville, IN

IT Consultant

Responsibilities:

• Production support analyst for CSM in nationwide manufacturing AS/400 environment.
• Design, Develop new AS/400 Label Print Process for Existing Production.
• Monitor AS/400 QSYSOPR for processing issues and resolve repetitive errors.

Environment: AS/400, CLP, CLLE, RPGLE, RPGIV, RPGFREE, SQL.

Confidential, London, OH

Senior IT Engineer

Responsibilities:

• Production support analyst for AS/400 Infor XA in worldwide manufacturing environment.
• Design, Develop and implement new AS/400 Label Print Process for New Production.
• Implement EXCEL production from RPG on AS/400 in batch environment.
• Implement New TEST environment and Control on AS/400.
• Monitor AS/400 QSYSOPR for processing issues and resolve repetitive errors.
• Use SHAREPOINT to provide users with data mining capabilities.

Environment: AS/400, CLP, CLLE, RPGLE, RPGIV, RPGFREE, SQL.

Confidential, Connersville, IN

Senior Analyst/Developer

Responsibilities:

• Production support analyst for MAPICS/Infor XA in worldwide manufacturing environment.
• Design, Develop and implement new EDI industry standards for PIES.
• Implement EXCEL production from RPG.
• Project Lead for Enterprise Wide implementation of Multi-Currency.
• Upgrade MAPICS 6 to XA 9.
• Convert to new iSeries from older AS/400.
• Convert to new FORMS management product.
• Monitor QSYSOPR and resolve repetitive errors.
• Use SHAREPOINT to provide users with data mining capabilities.

Environment: AS/400, CLP, CLLE, RPGLE, RPGIV, RPGFREE, SQL.

Confidential, Monroe, OH

PKMS Consultant(Everest Technologies)

Responsibilities:

• Production support analyst for PKMS.
• Monitor Print and Application Servers for errors in processing.
• Define nature of problem and solution.
• Create SQL statement to remedy production error.

Environment: AS/400, SQL, UNIX, CICS, TOAD

Confidential, Groveport, OH

PKMS Consultant(Jtech Staffing)

Responsibilities:

• Assist multiple teams with testing of converted data for PKMS.
• Design, develop and implement “HELP DESK” menus.
• Allow user to create, change and enable user profiles via IBM API’s.
• Design, develop and implement “PRINT ROOM” menus.
• Create outqueue utility using IBM API’s that allows user to sort/select by any column.
• Design, develop and implement process that allows the user to see all spooled files for a selected WAVE.
• Create utility that shows only printable documents for a specified WAVE using IBM API’s.
• Assist in system and application configuration for implementation of new WMS and new WEB order handling.
• Meet with end users to find out what their true need is for this and future acquisitions.
• Create design specifications document for all new processes and procedures.

Environment: AS/400, IBM API’s, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

Confidential, Columbus, OH

Responsibilities:

• Replace defective disk drives and reload operating systems and applications.
• Configure network connections and internet connections for all workstations.
• Ongoing maintenance of all workstations(Registry cleanup, remove old files etc).
• Custom interior and audio/video installation.

Confidential, Warren, PA

PKMS Consultant(Jtech Staffing)

Responsibilities:

• Assist multiple teams with testing of converted data for PKMS.
• Design, develop and implement STORED PROCEDURES for data verification. Meet with end users to get the data/processing needed for each interface.
• Create objects necessary for each procedure to generate the necessary return data for each interface.
• Created RPG procedures to return STATUS of order for web users, ITEM availability and pricing, SHIPPING information.
• Analyze existing interface and create design specifications for new business acquisitions.
• Create design specifications document for change to existing interface process for additional functionality needed for new business acquisitions and existing business users.
• Create field to field cross file and programming to use the new field to field file for incoming document processing.
• Created RPG procedure to insure that flat file records are in expected format.
• Created RPG procedure to READ the flat (comma delimited) file and create a work file record for entry to production data file.
• Created RPG procedure to READ the work file and generate a record in production using the field cross file to set the sequencing of these records for display.
• Develop, test and implement new application interface.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

Confidential, Dublin, OH

PKMS Consultant(Sapphire Technology)

Responsibilities:

• Design, develop and implement new FTP process for DEA Daily Sales reporting.
• The process will generate two Accrual Point Alert Reports, Confidential for Retail Independent customers and Confidential for Non-Retail Independent customers, to allow QRA to distinguish Confidential business type from another in order to react appropriately to the information contained in each report.
• Create STORED PROCEDURES on the AS/400 to feed Retail Web Order inquiries.
• Provide current status's and product availability for Web Order Entry. Made future enhancements much easier to accommodate with centralized modular processes. This will save the company time and money by being standardized.
• Design, develop and implement new Over Threshold Email reporting.
• Automated DEA Sales & Suspicious Order reporting. Designed and created BATCH processing to send daily reports. This saved the company 2 man hours a day.
• Assist multiple teams with testing of new procedures for RETAIL WEB ORDER.
• Design, develop and implement STORED PROCEDURES for Network accessibility.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

Confidential, Lexington, KY

Systems Administrator

Responsibilities:

• Lead for Centralization implementation.
• Create 12 partitions with all resources on production machine.
• Create 3 partitions with all resources on backup machine.
• Hook up and document all communications - ETHERNET, FIBER, INTERNAL/EXTERNAL MODEMS.

Environment: AS/ MMA POWER6

Confidential, Springfield, OH

Senior Systems Analyst/Developer

Responsibilities:

• Lead analyst for new ERP/EDI software implementation.
• Lead programmer for Special Shop Operations implementation.
• Create new sub applications from BPCS using SYNON.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL, SYNON

Confidential, Elkhart, IN

Senior Developer/Analyst

Responsibilities:

• Lead analyst for new ERP software implementation.
• Lead programmer for Shop Floor implementation.
• Create new reports as needed by departments from MAPICS.
• Design new Excel spreadsheet generation from RPG.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL, DBU

Confidential, Norfolk, VA

Senior Developer/Analyst(Consultant)

Responsibilities:

• Technical Lead for Hawkeye Pathfinder installation and management.

  Create new extracting for upload to WEB service.

• Design new dynamic XML generator from file driven base.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL, DBU

Confidential, Marysville, OH

Senior Programmer Analyst

Responsibilities:

• Technical Team Lead for upgrade of SIS (Specialty Insurance System) V-2 to V-12.
• Create new sequencing for print of paperwork to be used to load trucks.
• Design new PROCEDURES/PROGRAMS to synchronize WEB based Order Entry application with MAPICS on the AS/400 thru production and shipping of product.
• Setup new customer EDI transactions for order processing(830, 862, 856, 810 etc.).
• Develop new reporting for LAWSON for Invoicing and AR.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, CLLE, QUERY400, SQL, DBU, Implementor, Trusted Link

Confidential, Columbus, OH

Senior Programmer Analyst(Consultant)

Responsibilities:

• Modification of existing programs to meet Sarbanes - Oxley requirements.
• Modify Security programs to meet Sarbanes - Oxley.
• Design, code and implement new PROCEDURES to return data giving Confidential point of control.

Environment: AS/400, RPG III, RPG-ILE, CL, QUERY400, DBU, MKS

Confidential, Pittsburgh, PA

Senior Programmer Analyst

Responsibilities:

• Assist client with multiple report requests.
• Create process to meet the client's needs in the E-Business environment dealing with reports to E-mail and send.
• Design, code and implement processes to correct invalid converted data due to acquisitions.
• Modify Screen and report programs to accommodate changing business environment.
• Mentor Junior programmers in use of ILE and newer programming concepts.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, CLLE, SQL, DBU

Confidential

Consultant

Responsibilities:

• Worked with multiple clients(MAC Tools, Columbus Showcase, HONDA Of America) pertaining to System Performance, Capacity Planning, Operating System Upgrades,
• Application Upgrades, Software Analysis and Year-End processing.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, COBOL, CL, CLLE, SQL

Confidential

Developer/Analyst Consultant

Responsibilities:

• Extensively modify INFINIUM programs to meet client needs.
• Created process on AS/400 to download and generate Excel spreadsheet
• Design, code and implement process to send outbound documents according to ANSI X-12 standards for EDI system utilizing RPGILE, CLLE, GENTRAN and FTP.
• Automated "Invoice process" to check for necessary documents for Billing;
• Project/Programming lead for multiple Software Application and System conversions.
• Instrumental in helping clients plan, purchase and setup AS/400 for production.
• Plan and implement Operating Systems/Software Application upgrades in MAPIC

Environment: AS/400, RPG III, RPG/400, RPG-ILE, COBOL, CL, CLLE, SQL, MAPICS