Project Manager Customer Service

Robert L. Gentile

* ****** **.

Douglas, MA *****

508-***-**** (Home)

774-***-**** (Cell)

Email:

********@***************.***

Summary of Experience

Hardware: IBM AS/400, IBM I series servers, Personal Computers

Operating Systems: IBM OS/400, Windows XP, Windows VISTA

Tools: RPG II, RPG III, RPG/ILE, CLLE, SQL, SQLRPG, SQLRPGILE, AS/SET case tool, Microsoft Office Suite, MQ Series, DSI Scanning software, MOVEX Development Manager, SalesForce.com

Software Packages: BPCS versions 6.0.02 through 6.4, KBM versions 1.5 and 2.0, MOVEX versions 10.6 through 12.4, Robot, Turnover, Hawkeye

Databases: DB2/400

Professional History

10/02 – 05/2011 – Teknor Apex Company, Inc. Pawtucket, RI – Manufacturing

Independent Consultant/Project Manager

I had three programmers that are direct reports and an additional three which are in-direct reports. This including writing the programs spec and evaluating the rate of success based on the goals set forth at their reviews. I determined the percentage of pay increase when a person was entitled to the increase. I also have to manage their vacation time, sick time, holiday schedules and training schedules.

Managed a team of five programmers on a project designed to purge the database of item based information which was no longer needed in the live system, but needed to be retained in an archive system. This project will affect 90 percent of the files within MOVEX and has an estimated budget of 1 million dollars.

Help design and write a Bill of Material archive system, which allowed users to archive bills of material into a separate database. The current bill of material programs were modified to use the archive database files and to allow users to automatically reinstate a bill of material. When archiving or reinstating a bill of material the item master, item warehouse, item facility, and drawing measures will also be moved from one database to another. The budget for this project was $125,000.00 and we were able to finish early and under budget.

I designed and managed a team to 4 people in a project that modified the Lab and Inspection module of MOVEX to meet the needs of Teknor Apex. These changes are needed because the core MOVEX software did not support the functionally that is needed by Teknor Apex. As well as being the project manager I am so the lead programmer and systems analysis. The modification needed by Teknor Apex required that every program and file within the Lab and Inspection module of MOVEX be modified. Once this project is completed the Lab and Inspection module of MOVEX will be fully integrated into a SPC software package called InfinityQS. This project will provide a cost savings benefit to the company of over $125,000 per year. I have been the project manager on this project for over three years. The project budget for this project was 1.5 million dollars. Upon completion we met our installation deadline and stay within our budget.

Wrote program specification and manage work load of four full time and three contract programmers. This work load included re-designing the Bill of Material maintenance programs to handle the bills of material in both a whole number and percentage based quantity. Re-designing the changes to the Certificate of Analysis document. This document is what is provided to customers at the time of shipment to show that the product they are receiving meets their needs. Designed the changes to the available to promise date logic used in the Customer Service module of MOVEX. The original version did not take into account warehouse shut down time nor QC lead-time.

Wrote a number of quick reference manuals that all programmers in the company use. These manuals were guides on how to use the MOVEX Development Manager, DSI programmer tool kit, and Turnover with work-lists.

Help to select, modify and implement the current scanning software package. This package was purchased from Data System International. I had to learn the DSI programming tool kit and modify the DSI scripts to handle the ever changing demands of the Teknor Apex warehouses.

11/08 – 03/11 – Velocity Inc. Toronto, Canada – Consulting

Independent Consultant

I work on a team of about 3 to support the day to day operation for a distribution company. These duties included documenting all reported problems then providing a solution for the problems. Once the solution was approved by the project review team I would provide the programming that was needed to correct the problem. This included a unit test plan, system test plan and a user test plan. Once the test plans were fully executed the project was review by the project review team again before the modifications could be moved into production.

I work on a team of about 15 from three different companies to get MOVEX and Menlo's worldwide software to communicate. This project included being able to send and receive shipment and receipt transactions from MENLO worldwide and have them post correctly within MOVEX. Within MOVEX we used the warehouse integration module which allows us to post shipments and receipts correctly. There were a total of 7 different transaction types that we processed and within those 7 types there was over 20 different orders types that could be processed. I was responsible for writing the programs which extracted the data from MOVEX and create a transaction in a flat file. The flat file was then processed by a JAVA program and convert into an XML. I was also responsible for writing the programs which read a transaction based flat file and loaded the data in the warehouse integration files.

I was responsible for getting the warehouse integration programs to work correctly. This included getting MOVEX to update the order and inventory correctly.

11/08 – 02/09 – Badger Meter, Inc. Milwaukee, WI – Manufacturing

Independent Consultant

Documented the Order Entry system for BPCS 6.4. This document included screen validation, screen prompting and record creation for Customer Orders, Quotes and RMAs. The document outlined each phase of the order entry process including: removal of order lines, posting of orders, notes, “pricing, sales and commissions”, “billing and financial”, shipping, inventory, “taxes, currency, and payments”. Each panel which was available to the users was documented, this included a picture of the panel and detailed explanation of what each field on the panel was there for and what its function was once the user accepted the data within the panel. The final document was over 350 pages.

04/08 – 06/08 – Lawson, Inc. Minneapolis, MN – Consulting

Independent Consultant

Designed and coded a Bill of Material Search engine. This engine gave the user the ability to search bills of material based on drawing measurements and/or components. With the components they could further define their search by including and excluding item types and component quantities. The selection criteria could be linked using both and functionally and or functionally. Each entered search will be saved under the person who created the search. A user can enter as many searches as they wish. The bill of material search engine will search both the live MOVEX data and the archived MOVEX data.

05/02 – 10/02 – Fidelity Investments, Inc. Boston, Ma – Finance

Independent Consultant

Designed and coded a modification that tracked outstanding shares on 10 different mutual funds. These were mutual funds, which Fidelity Investments managed but did not own. Because of certain Security and Exchange Commission rules and laws the number of outstanding share at any one point could not exceed 10 percent of all outstanding shares. The system had to monitor all transactions attempted by Fidelity Investments against these mutual funds. The system had to accept, reject and make recommendations based on the total number of shares held by Fidelity Investments at the time of the transactions. The system made buy or sell recommendations for each of the mutual funds forty-five minutes before the close of the New York Stock Exchange each day.

12/00 – 04/02 – MarMaxx Group, Inc. Westboro, Ma – Retail

Independent Consultant

Provided programming support to a project that changed the communication protocol to MQ Series. I changed application programs that used IMS protocol to MQ Series. These changes were needed to help stabilize the production environments. Before these changes were in place inventory transactions between the Main Frame and AS/400 were constantly getting lost. This caused many man-hours to be wasted trying to resend hung transactions or trying to recreate lost data on both platforms. By changing the communication protocol to MQ Series we were able to save the company approximately 1500 IT man hours a year because time was no longer wasted re-sending transactions or re-creating data. Because inventory transactions will no longer be lost or need to be re-created manually the company was able to estimate that it saved over 15 million dollars in the first year.

Designed and coded modifications to the current software package that provided a more efficient way of tracking transportation costs. Transportation data was being collected and stored on 8 different AS/400s. I wrote a process that utilized FTP functionally to store the data on a centralized AS/400. The process ran nightly and collected transportation data this data was then FTPed to a centralized AS/400. Once the data was on the centralized AS/400 a second process ran over this data to determine the number of emptied trailers at each DC. An EDI process was then run over the empty trailer data and this sent EDI (227) transactions to our EDI vendor. Our EDI vendor then faxes to each carrier a report of trailer(s) that are available to be picked up. The fax came with an automatic confirmation of receipt. Once the EDI vendor received the confirmation it would send EDI (100) transactions back to acknowledge receipt of the fax by the carrier. Once a carrier had acknowledged receipt of the fax we would update the empty trailer data with a receipt date. Based on this receipt date plus two days all container charges were stopped. Meaning that we gave the carriers two extra days to pick up their empty trailers. Regardless of if the trailer was pickup or not we no longer would pay container cost for trailer that were not picked up but had a fax receipt date associated to it. The company was able to estimate that it saved over 44 million dollars in the first year.

Researched and provided documentation that outlined the effort involved in making a major modification to the current software package. The modification was needed because an inventory control number field needed to be expended from 6 positions to 8 positions. This field needed to be expanded because the number was about ready to roll over. The roll up is projected to occur in less than 18 months. After researching the entire system I found a way to use existing fields to extend the life of the inventory control numbers by an additional 36 months. With this new information this project was placed on hold while a new approach was looked to solve the problem. By extending the life of the inventory control number by 36 months I saved the company 3 million dollars in programmer cost.

Involved in the ongoing support of the software package that is used by the nine distribution centers. This was a home grown software package.

05/00 – 07/00 – The Arlee Group, Inc. New York, NY – Retail

Independent Consultant

Designed and coded major change to the ARP module in BPCS. These modifications were made to allow the ARP module the ability to process more the 1000 checks in a single batch check run. This change was needed because the current process required an accounts receivable clerk to work a check for up to three weeks before it would balance. This is because ARP could only handle 1000 invoice on a single check and the customers were receiving up to 15000 invoices on a single check. A process was written the accepted in EDI 820 payment transactions and based on the header information in the 820 transaction the check was balanced and converted into records that could be processed using the ARP nightly process. By making this modification an accounts receivable clerk could work a check in less than 2 hours and get the check to balance. It was estimated that the company would save about 500 hundred thousand dollars a year with the new process in place.

6/98 – 12/00 – Thomas & Betts, Inc. Attleboro Falls, Ma – Manufacturing

Independent Consultant/Project Manager

Involved in a series of projects that were BPCS database conversions. I was one of a team of 3 people. We took two sites from BPCS 2.1 to BPCS 6.0.04 and one site from BPCS 3.1 to BPCS 6.0.04. I was responsible for ensuring quality to the programming efforts.

Lead programmer on a project team of 3 that transfer data from a Mainframe to files that resided on the AS/400. The files on the AS/400 needed to reflect customer orders, item inventory and costing information that resided in a Mainframe order entry system. The plants profits and MRP/MPS were driven by the information that resided in the Mainframe order entry system.

Designed, developed, implemented and supported a corporate wide Inter plant Order Processing System. The system could extract requirements from one ERP package and place manufacturing orders on another ERP package. It could also extract shipments from one ERP package and place re-supply orders on another ERP package.

Helped with system performance issues by running subsystem analysis and performance reports. Made recommendations as to change in subsystem allocations that help improve system performance.

Designed, developed, implemented and supported a corporate wide Database Purge System. This system reduced that amount of data contained at each site thus reducing the amount of time each month-end process took. It also reduced the amount of DASD each plant used helping to reduce the cost of doing business for both the plants and the corporation.

12/92 – 6/98 – QCC, Inc. Dedham, Ma. – Software Solutions Provider

Project Manager/ Northeast BPCS User Group AS/SET Chairman - 07/97 to 6/98.

Project Manager and Senior Technical Programmer for projects, which involved bring customers up on SSA’s century date compliant version of BPCS. During this time I managed three implementations at one time. Each implementation involved a group of 4 people, tracking time and quality. Along with the standard conversion issues the three projects involved over 1.5 million dollars’ worth of BPCS modifications.

Some of the non-customer related tasks that I was responsible for include vacation planning, education planning, resource management and providing senior management with a six week, forecast of my teams’ billable hours.

I was responsible for in-house and customer training on SSA’s case tool AS/SET. I developed a BPCS version of the training class for those customers who required this type of training as opposed to the standard AS/SET training.

Technical Lead - 12/96 to 6/98.

Hands-on technical lead developer on a team of 10. Responsible for the functional and technical specifications for all work given to the group. One major project required that I spec out and help code over 200 file conversion programs because no conversion programs existed. This conversion was later sold to SSA to be used by other customers that were trying to convert from a System/38 to a RISC AS/400.

Senior Programmer Analysis – 12/92 to 12/96

Varies programming assignments, which involved coding, testing and implementing programs. Worked for all types of manufacturing facilities and a couple of retail chains.

4/89 to 12/92 – Commerce Insurance Company, Webster, Ma.

Programmer I/II - 4/89 to 02/91 to Senior Programmer Analysis - 2/91 to 12/92

During this time I work on everything from simple AS/400 Queries to complex systems. I was the lead designer and programmer on a Commission Charge-back System, which involved making site visits to each of the agents that were working on a commission basis. This system was to allow the company to charge-back unearned commissions.

Education

9/84 - 4/88 Fitchburg State College, Fitchburg, MA.

Bachelor of Science, Computer Science.

References Furnished Upon Request

Contact this candidate