William Behr

Experience

• 

  Lenox Corporation

  Jan 1993 - Jan 1995

  Programmer

  Performed Maintenance and Enhancements on a Marketing and Sales Reporting System.Designed, Programmed and Implemented the following applications:-AS/400 E-mail system enabling sales force to communicate via their existing AS/400 connectivity. Provided full editing capabilities as well as tracking and return receipt capabilities.-Sales reporting application that eliminated a hard copy process. This application greatly improved the company’s management capability of the sales force.-Data Warehousing process utilized to analyze sales and production performance.-Created trend analysis application used to forecast production requirements. Show less

• 

  U.S. Food Service

  Jan 1996 - Jun 1996

  Consultant

  Wrote RPG programs on an AS/400 to combine data from various sources onto a centralized AS/400. This project allowed the client to consolidate data from several business segments into a single application giving them the ability to centralize their operation.

• 

  Munich Re

  Jun 1996 - Mar 2000

  Senior Consultant

  While consulting for a major Re-Insurance company participated in the following significant applications;- Y2K Application and Data File Modification of an Insurance Brokering System. This application consisted of 4500 AS/400 Objects.- Performed Y2K impact analysis.- Designed, Developed and Implemented the Data Expansion & Migration process for the completion of the Y2K project.- CISC to RISC migration analysis and implementation.- Enable View Only user access for a Document Tracking Application written in Access.- Created an Access application for Standardization of Client Insurance Exposure Data. It standardized and summarized data from a wide variety of sources and formatted it in preparation for export.- Created an application providing the Client with a centralized Name and Address database. Name & Address information was downloaded from the AS/400 and organized into an Access database.- Wrote an Access application to enable the user to track contract offerings and negotiations. Show less

• 

  Nabisco Biscuit Company

  Mar 2000 - Feb 2001

  Consultant

  Designed, programmed, tested, and implemented an application to track manufacturing performance. This application collects data from a variety of other sources on several different platforms. Utilizing multiple technologies such as RPG-ILE, ODBC, FTP, Excel and VBA a user friendly spreadsheet was made available at several levels of detail. For the individual manufacturing locations, an excel spreadsheet with their performance information (Including History) was available, while at the corporate level all locations were available for review and comparison. Subsequent updates to the original concept included a web enabled version of the corporate model. The web version was designed and programmed utilizing HTML and ASP for the front end and accessed the existing data from the AS/400 back end using an ODBC connection.Participated in all aspects of daily maintenance and troubleshooting for the MIMS system which is the Maintenance Information Management System utilized by multiple locations. My responsibilities included maintaining existing programs, performing analytical functions and writing new programs when needed. Show less

• 

  Mondelēz International

  Feb 2001 - May 2002

  Consultant

  Participated in the financial integration of two major manufacturing companies. Designed, programmed, tested, implemented, and operated all programs needed to perform the following tasks:- Automatically identify, isolate, and convert all DB2/400 files containing key financial information to new formats.- Automatically identify all AS/400 application objects requiring modification due to file changes.- Programmatically identify all lines of source code containing references to modified fields.- Automatically convert data from one company's files to match values specified by the other company’s financial application.Designed, programmed and implemented CL and RPG programs to complete the transfiguration of the old accounting application to function in accordance with the new accounting rules.Participated in collecting system specifications for a third party application to replace an existing home grown application. Designed, programmed and implemented an MS Access application to collect survey forms and generate statistics based on survey responses. The results highlighted what areas and specific functionality was of most importance to which group(s). Show less

• 

  Toshiba America Consumer Products

  May 2002 - Dec 2004

  Consultant

  Designed, programmed, implemented and tested a variance report utilizing PRG-SQL-ILE on the AS/400 in conjunction with VBA-Excel. This product generates all of the source data on the AS/400 back end and is presented in an Excel spreadsheet format that the clients are familiar with on the front end. The spreadsheet allowed the user to select from a predefined list of production figures and compare them utilizing a running variance. Various time periods were also selectable. Participated in a project to integrate an ERP package with a supply chain management system. All work was performed using PRG-ILE and RPG-SQL-ILE on the AS/400 platform. I wrote, tested and implemented various batch processing programs to extract data such as sales history and model information. Other responsibilities included performing program maintenance as well as the design, programming, testing and implementation of interactive, data entry and subfile type programs. Additionally, I provided analytical expertise, assisting in troubleshooting design specifications and providing data to the design team in excel format.Designed, programmed, tested, and implemented an automated process (in RPG on the AS/400) to provide a third party vendor with Model and Part information. This process analyzes the Model/Part information for a particular customer and programmatically determines if any add, change or delete action was taken. Each month the application summarizes all of the changes and FTP’s a Delta file to the vendor. Show less

• 

  Laurelton LogicWorks

  Sept 2003 - now

  Provided IT consulting services to my various clients.

  • Independent Contractor

    Dec 2020 - now

  • Owner

    Sept 2003 - now
• 

  Kube Pak Corp

  Apr 2004 - Dec 2020

  IT Director / Business Analyst / Developer

  IT Director• Provide the strategic inputs to the President/Owner of the business and write detailed scope documents for complex projects• Lead strategic discussions along with Business Leaders to deliver the technology solutions• Lead and provide guidance to a dedicated off-shore/off-site team of developers and Project Manager for ongoing modernization projects for the business• Negotiate with vendors for purchase of technology specific hardware• Manage the allocated budgets and optimize operations IT Manager and Business Analyst• Responsible for the Corporation’s information systems and applications• Ensure high availability of core systems, applications for use by the team• Create professional project scope documents that create the road map for complex custom applications for the business• Manage regular audit of code quality and distribute work to dedicated off-site partners• Ensure time-bound delivery of quality code for scoped solutions• Manage and maintain quality documentation with reference to applications, solutions, and platform• Provide hands-on support for all aspects of IT, including Infrastructure (firewall, networking, fiber optics, 25 acres of wireless, NAS), Hardware (installation, maintenance, and repair) Developer• Actively engaged in coding on the iSeries• Guide the off-site partner team of developers and work closely with them with complex coding for critical applications• Leverage 20 plus years’ experience with RPG, RPG-ILE free, embedded SQL, DB2, DDS, DLL CL, SQL, FTP/SFTP, SSH, CGI, Web Services, RDi, Visual Studio Code, Office 365, SharePoint, VBA, HTML5, CSS3, JavaScript Show less

• 

  Laurelton Fire Company

  Jan 2005 - now

  Firefighter/Past-President

  I have been with the Laurelton Fire Company #1 since 2005. In addition to performing the duties of firefighter, I have served on both the Line and Executive sides of the officer ranks. I have been either an executive or line officer since 2006. My posts have included Corresponding Secretary, Accountability Officer, Recording Secretary, Vice-President, Safety Officer, and President.

• 

  NESTU

  Jan 2020 - now

  President

  Special thanks to my colleagues at NESTU for their vote of confidence. I look forward to moving our organization forward with all of your support!NESTU of New Jersey, Inc., is a New Jersey not for profit corporation whose principal objective is to advance the effective usage among its members of the IBM i platform including legacy and open source technologies. The board of directors consists of a group of all-volunteer members who are responsible for the ongoing operation of the organization, coordination of events and ensuring the availability of NESTU services to its constituent membership. Show less