William M. Fischer

*** *** ******

St Augustine Beach, Fl 32080

(c) 901-***-****

Email: acs4yi@r.postjobfree.com

Information Technology and AS/400 Professional

Insightful, results-driven AS/400 professional with noteworthy accomplishments

in designing, programming and implementing a broad range of application systems

to support business objectives. Excel in design and analysis of full life-cycle

project. Well versed in all versions of RPG through RPG-ILE. Hands-on experience

as DP Manager and Team Leader in all stages of system development.

Education

Bachelor of Science in Accounting and Finance

College of Commerce and Finance, St. Louis University

Technical Proficiencies

RPG, RPGII, RPGIII, RPGIV and RPG-ILE Programming, SQL, Imbedded SQL, System/3 CCP Programming,3600 Financial System Programming, C++ Programming, Bill of Material Structuring(Dave Garwood), Materials Requirement Planning(Joe Orlicky).

Programs & Software

RPG I, II, III, IV, RPGILE, CLP, CLPLE, DDS, SEU, RLU, SQL, IPICS, MAPICS, BPCS, CMAS, DMAS, INNOVATIVE, JDEdwards World, ACCOUNTING 2000, PREMENOS, GENTRAN, MCCORMICK, DATA COMMANDER, ALDON, SQL, JOB COST, NuBridges FTP, Microsoft Office (Word, Excel, Access, PowerPoint, Outlook), Support Works Enterprise Support Platform(Hornbill),Macess 2.0(SunGard), SQL Viewpoint, AVANTIS.XA software, WMS System Software

Professional Experience

4/29/2015 to Present Frontier Communications

Application Developer RPG & SQL

Involved in Conversion Project to assimilate over 5 million customer purchased from Verizon into Frontier’s Data Base. Created programs to report that all Service Orders were correctly converted to Frontiers data Base.

6/01/2014 to 3/01/2015 U.S. Assure

Application Developer RPG & SQL

Responsible in updating all files and programs to switch from a 9-byte Policy Number to a 14-byte character value Policy Number. Included analysis of current programs and files to determine what needed to be changed. Created conversion programs where necessary to facilitate changes.

5/19/12 to 4/01/2015 Electrolux

Application Developer RPG & SQL

Modified Programs within JDE Manufacturing based upon user requirements. Designed, Wrote, Installed and supported Employee Call-In System for HR. Active in Avantis.XA system supporting users and creating/modifying reports based upon user requirements. Supported the SM9 Help Desk system including responding and fixing user problems in JDE World, Avantis, RF Smart and WMS Warehouse Management System

8/09 – 2/12 WEA Trust Madison, WI

Contract Programmer/Analyst – RPGII,III IV,ILE, SQL

Modified and rewrote various programs (batch & Interactive) for the various lines of business (Health, Drug, Dental, Long Term Care & Disability, Short Term Disability, Life. Worked on and managed the Help Desk.

9/08 - 4/09 The Commerce Insurance Company, Webster, MA.

Contract Programmer/Analyst – RPGIII,IV,ILE

Recruited to analyze, document and define steps necessary to remove four major systems written in RPG that had been made obsolete by the Massachusetts Insurance Commissioner. Modified an Insurance Statistical Reporting System written in RPG IV,LE to utilize FTP in place of Tapes for reporting to outside agencies.

8/06 - 3/08 LMI Aerospace (aircraft parts mfg), St. Charles, Missouri

Contract Programmer/Analyst – RPGIV, ILE

Designed and programmed a MinMax Inventory, production and customer ship scheduling system in RPGIV and ILE using prototypes, procedures, service programs, triggers, and subprocedures. Programs scheduled customer shipments based upon daily min/max values retrieved from customers web sites, generated manufacturing work order recommendations based upon min/max supply levels and EOP/EOQ.

Key Achievements:

Programs were instrumental in reducing the number of "red" parts from 65% to 15% in the first 6-months the system was implemented thus improving the customers service level rating for the company

HPI(Home Products International), Chicago, IL

Contract Programmer/Analyst – RPGIII, RPGIV, ILE

Upgrade of JD Edwards software from version 7.2 to 7.3 cum 11. Retrofitted in house program modifications to JDE version 7.3 programs. Applied all available SAR's to bring software up to Cum 11 level. Modified all non-JD Edwards programs to make them Y2K compatible. Performed extensive testing to verify modified programs functioned correctly.

Designed and programmed changes to JDE Forecasting System based upon customer requirements. Wrote Maintenance program to permit the modification of shipment history and allowed input of multiple manual forecasts allocated to multiple plant requirements. Interfaced with JDE Mfg as front-end load to MRP system.

Key Achievements:

Y2K Program modifications were successfully implemented by the turn of the century. New forecasting process allowed company to identify high margin products; pinpoint potential product shortfalls or surpluses and react faster to expand or contract inventory levels thus lowering overall product cost.

Hunter Fan Company, Memphis, TN.

Contract Programmer/Analyst – RPGIII, RPGIV

Responsible for the Design, Programming, Installation, Education and Maintenance of the "PSI System". It included a forecasting module interfacing with JDEdwards files that permitted users to input forecasts using actual shipment history as its basis. Forecasts were input by multiple departments using PC based data. Interactive screens were also used to modify forecasts.

Designed a Pseudo MRP process that used the input from the forecasting process as the Material Requirements. Interfaced the JDE files to permit visibility of 3-Years of past shipment history accurate through the previous days shipments, available Inventory including On Hand and In Transit with anticipated delivery dates, On Order with delivery dates and Current Customer Orders with projected due dates. Supplied a work screen encompassing all above data that generated a month by month material requirements calculation that could be changed interactively as a "what if" process. This process was used by the buyers to determine Manufacturing, Purchasing and Offshore requirements and capacities.

Key Achievements:

* Reduced Inventory Levels by 20%

M.S. Carriers, Inc. (trucking), Memphis, TN

Contract Programmer - RPGIII

Involved in upgrading the Innovative Transportation and Distribution Software. Designed and programmed a Tractor/Trailer Maintenance system for a fleet of 400 tractors and 1200 trailers. System included capturing vehicle usage data and statistics that were used to schedule periodic maintenance. Kept track of and generated reports on hub mileage and fuel usage.

Created a mini Accounting/Parts Inventory System that allocated labor and maintenance costs on all vehicle maintenance, kept stock parts in inventory and generated purchase orders when required. Interfaced PM maintenance messages, Parts available messages to the Innovative Driver Maintenance System.

Penn Insurance Company, St Louis, MO

Contract Programmer/Analyst

Designed and Wrote a reinsurance System that was used to track and facilitate the company with its reinsurance process. Process included the sale of an interest in large blocks of insurance coverage's to spread the liability among multiple carriers. Included the accounting and allocating of premiums and

claims within multiple companies.

The Binkley Company (metal fabricator), Warrenton, MO.

Director of Data Processing

Responsible for all data processing functions which included directing a 2-shift data processing department with 13 employees. Designed, wrote and installed an integrated payroll and labor costing system to interface with manufacturing production control. Installed an inventory and material cost system and set up the basic framework for an MRP system.

St. Charles County Government, St. Charles, MO

Director of Information Systems

Responsible for all data processing functions within the County. Computerized many of the functions within each of the offices including assessment, collection, budgetary accounting, recorder of deeds records, court records and sheriffs records.

Contact this candidate