AS/400 / iSeries Senior Programmer/Analyst
Resume:
Andrew Catanese
adhos9@r.postjobfree.com
CAREER SUMMARY
A dynamic, solution-oriented IT professional with thirty plus years of diverse, well-rounded experience in varied corporate environments and numerous business sectors. I have a background in technology and have achieved success in positions ranging from Programmer / Analyst to Project Manager, establishing a reputation of delivering high quality solutions on time and within budget. I have excellent verbal and written communication skills and interact effectively with peers, end users and senior management. I enjoy a challenging, tightly integrated business / IT environment where I can utilize my strong project management, problem solving, analytical and development skills to assist the organization in achieving its business and system goals.
TECHNICAL SUMMARY
Hardware: iSeries, AS/400, IBM System/36, IBM System/38, IBM PC
Programming Languages: RPG III, RPG IV, RPG ILE, RPG Free, CLP, HTML, Net.Data, ASP.Net
Utilities/Tools: RLU, SDA, PDM, DFU, DBU, SQL/400, Query/400, Turnover, Aldon, NewVersion, Sequel, Probe/Abstract, ROBOT
Midrange Software: Premenos, Trusted Link, SalesTracker, Infinium, BPCS, PRISM, Warehouse Boss, Daily.Commerce, Mincron, J.D. Edwards World, ASW, iDocs, Atomic, PRMS
PC Software: Visual Basic, Microsoft Windows, Excel, Word, Access, Outlook, ABC Flowcharting, Visio, Microsoft Project, Microsoft PowerPoint, Microsoft Publisher, Microsoft Front Page, Macromedia Dreamweaver, Adobe Photoshop, Noventri Suite
PROFESSIONAL EXPERIENCE
Dynamic Systems Resources, Incorporated 04/91 – Present
Consultant
Consulting Assignments:
Medical Supply Packaging Material Manufacturer 06/19 – Present
Consultant
· Responsible for all aspects of the iSeries.
Converted Invoices, CoC, CoA, Shipment Confirmation, PO Acknowledgement, Credit Memo’s, Purchase Orders, into iDocs.
Made extensive changes to the PRMS software in the Distribution, Purchasing, and Financial Modules.
Made changes to the Atomic software in the Manufacturing Module.
Created many programs written in RPG IV & Free Format RPG that integrated into PRMS database.
Created complete systems including database
Created multiple manufacturing projects using the Noventri Suite software package.
All projects included requirements gathering, writing functional & technical specs, flowcharting, database design, test documents, and programming.
Hospital Supply Packaging Manufacturer 01/13 – 06/19
Consultant
· Converted Invoices, CoC, CoA, Shipment Confirmation, PO Acknowledgement, Credit Memo’s, Scorecards, and Bar Codes into iDocs.
Made extensive changes to the PRMS software in the Distribution Module.
Made changes to the Atomic software in the Manufacturing Module.
Created many programs written in RPG IV & Free Format RPG that integrated into PRMS database.
Created multiple manufacturing projects using the Noventri Suite software package.
All projects included requirements gathering, writing functional & technical specs, flowcharting, database design, test documents, and programming.
Packaging Company 02/16 – 04/17
Consultant
Involved in major upgrade to IBS’s ASW ERP software for the AS/400.
Made software changes to IBS’s ASW, which is written in RPG III and RPG IV.
Tool Manufacturer 10/05 – 11/12
Consultant
· Made extensive changes to the PRMS software in the Distribution, Purchasing, Financial, and Manufacturing modules.
Made changes to the Warehouse Boss software system.
Created many new programs written in RPG IV and RPG Free that integrated into the PRMS and Warehouse Boss systems. Most programs were interactive subfile type programs.
Created 250, 255, 256 EDI transactions.
All projects included writing Functional Specs, Technical Specs, Flowcharting, Database Design, Test Documents, and programming.
Assisted in second level help desk issues.
Analyzed and recommended changes to the entire purge process.
Packaging Company 06/05 – 10/05
Consultant
· Involved in the implementation of Daily.Commerce ERP software for the AS/400.
Made many software changes to Daily.Commerce, which is written in RPG III and RPG IV.
Created new RPG IV programs, mostly interactive programs with subfiles that integrated into the Daily.Commerce software.
Created 250 and 256 EDI transactions.
Restaurant Supply Distributor 07/04 – 05/05
Programmed the entire Fuel Surcharge system in RPG ILE, which included making major modifications to the Daily.Commerce Order Entry & Billing System, creating many new maintenance and inquiry programs, and modifying their Logility System.
Created a Technical Design, Program Specifications, Database Design, and programs in RPG ILE for a stand-alone Carrier system which interfaced with the Daily.Commerce Order Entry & Billing System.
Modified the Daily.Commerce Order Entry & Billing Programs to automatically email a user when an Order was being place on Transportation hold. Also gave them an inquiry screen to view all orders on Transportation hold and allow them to take the orders off of hold.
Modified several Daily.Commerce Purchasing programs in RPGLE.
Created file transfer programs to move data to the web.
Extensively used Turnover Change Management Tool.
Healthcare Manufacturer 04/03 – 11/03
Consultant
Made modifications to the J.D. Edwards World Purchase Order Program.
Made changes to several Dream Writers.
Mid-sized Muffler & Brakes Company 09/02 – 01/03
Consultant
· Created a Franchise Opportunities section to their Webpage that included Online Brochures and an application form.
Created a complete extranet page for their distributors, which included News, Training registration, POP Ordering, Advertising clips, and General Information.
Created HTML code for the company’s new Web page.
Created Net.Data macros tying the data on an AS/400 to the webpage.
Setup IP addresses and hosting of Customer’s Web Page
Small Construction Company 11/01 – 04/02
Consultant
· Created HTML code for the company’s new Web page.
Created Net.Data macros tying the data on an AS/400 to the webpage.
Setup IP addresses and hosting of Customer’s Web Page
Small Machine Distributor 12/00 – 04/01
Consultant
· Created a substantial amount of HTML code for the company’s new Web page.
Created Net.Data macros tying the data on an AS/400 to the webpage.
Created an Order Entry web page linking data to the AS/400.
Setup IP addresses and hosting of Customer’s Web Page
Plumbing Supply Manufacturer 10/99 – 03/00
Consultant
· Led team of six programmers in major revamp of the Distribution System in Mincron on the AS/400.
Made major modifications to the Mincron Order Entry Program.
Created many new reports for the Distribution system.
Made major modifications to the Mincron PO Entry programs.
Led the testing and implementation of the new system.
Trained employees on the new features of the Distribution System.
Seed Manufacturer 10/98 – 03/99
Consultant
Led a project of eight consultants that came in on time and on budget.
The project included the creation of a new web page that had a new Blanket Order Maintenance System that was integrated with the J.D. Edwards World files real time. It also included Web reporting tying back to J.D. Edwards as well as several web inquiries tying back to J.D. Edwards data files.
Created several Functional and Technical designs.
Created complete Database for new system.
Extensive usage of Microsoft Project.
Oversaw the entire system implementation.
Healthcare Manufacturer 05/98 – 09/98
Consultant
Made several modifications to the J.D. Edwards World Order Entry Program.
Made changes to several Dream Writers.
Major Pharmaceutical Manufacturer 03/97 – 04/98
Consultant
On team to upgrade PRMS system from 8.3 to 8.4.
Responsible for upgrading the Multi-system module, purchasing module, and the Accounts Receivable module.
Created the MRP summary reports system, which would retrieve MRP information from 12 plants, consolidate the information, and print reports that would assist in locating components with no usages, excess material, and multiple usage products amongst the plants.
Created the PO and Inventory analysis reports, which would retrieve the Purchasing information from PRMS and the Inventory information from the mainframe.
Created the product download program, which would allow the user to select the consolidated Bill of Materials from an entered list of products and download this information to the PC for processing.
Major Oral Hygiene Manufacturer 04/95 – 03/97
Consultant
· Made major user modifications to the following PRMS distribution programs: Order Entry, Allocations, Pick Slip Release, Pick Slip Print, Shipment Confirmation, Invoice Release, Invoice Print, Invoice Update, Credit/Debit Memo Entry, Debit/Credit Memo Print and Update, and Promotional Pricing.
Made major modifications to the PRMS Multi-systems programs: Product Master Maintenance and Customer Master Maintenance.
Made modifications to the PRMS Accounts Payable Entry program.
Incorporated the Vertex Tax package into the PRMS distribution system.
Created a Sales System based on the PRMS Sales Files and Invoicing files.
User training for the PRMS Distribution System.
Therapeutic Bath Manufacturer 08/94 – 04/95
Consultant
· Conversion of System /36 MAPICS software to AS/400 PRMS software including Order Entry, Purchasing and Receiving, Accounts Payable, Accounts Receivable, Inventory, Forecasting, and General Ledger.
· Made major modifications to the PRMS Order Entry System including changes to the Order Entry Maintenance, Pick Slip Print, Shipment Confirmation, Invoice Release, and Credit/Debit Entry and Maintenance programs.
· Created numerous PRMS related maintenance, inquiry, and reporting programs.
· Converted PRMS from a member driven environment to a library driven environment.
· Responsible for bringing PRMS software to new releases including 8.3 9404 and 8.3 9409.
· Led weekly PRMS project installation meeting for all participating users.
· Extensive user training for all PRMS Modules.
Major Chemical Manufacturer 02/94 – 08/94
Consultant
· Conversion of System /36 Sales System into PRMS Order Entry and Sales history files.
· Created appropriate sales maintenance, inquiries, and reporting programs.
· Made major modifications to PRMS Order Entry System, including changes to the Order Entry Maintenance, Shipment Confirmation, and Invoice Release programs.
Re engineered the Credit/Debit Process to include Receiving and reporting functions.
Major Pharmaceutical Manufacturer 04/91 – 02/94
Consultant
· Custom fit PRMS Manufacturing software to client needs.
· Multiple AS/400 Environments
· Wrote Functional and Technical specifications.
· Wrote Test Plans and User documentation.
· Performed several software evaluations.
· Responsible for bringing PRMS software to new releases.
· Wrote many new programs utilizing subfile programming.
Performed RPG III subfile programming education to client employees.
Sandoz Crop Protection 11/90 – 04/91
Project Leader
· Responsible for all Marketing, Sales, Payroll, and Human Resources application systems.
· Custom fit PRMS Manufacturing software to plant needs.
· Multiple AS/400 Environments
· Lead programming teams in the design, development, testing, implementation, and maintenance of software.
Part of a team to evaluate case tools. Installed and tested Lansa Case Tool.
Sandoz Crop Protection 09/88 – 11/90
Senior Programmer/Analyst
· Responsible for Design, Analysis, and coding of On-line Sales, Forecasting, and Budgeting systems.
· Utilized Subfile Programming.
· Responsible for coding of On-line Expense Reporting system.
Recommended multiple solutions to Project Leaders and Users when analyzing a project.
Advanced Computer Management 07/87 – 09/88
Programmer Analyst
· Responsible for conversion from MAPICS to BPCS Manufacturing Software.
Responsible for Payroll systems including W2 Forms.
Mercantile Systems Incorporated 03/86 – 07/87
Programmer Analyst
· Analyzed, programmed, and implemented business application programs.
Responsible for Accounts Receivable and Collections software.
VMS Realty Incorporated 09/84 – 03/86
Programmer
· Programmed and implemented business application software.
Responsible for Accounts Receivable and Collections software.
EDUCATION
Northeastern Illinois University, Chicago, IL.
Computer Learning Center, Chicago, IL.
Contact this candidate