Project Customer Service
Resume:
JOSEPH W. ROCK
Cumberland, RI **864
****.**@*****.***
HARDWARE: IBMi / i-Series / AS/400
APPLICATION SOFTWARE: RPG Free, RPG/IV ILE, RPG/400, RPG III, CL, SQL, Microsoft Office, WDSC
BUSINESS APPLICATIONS: Retail, Manufacturing, Financial, Healthcare
SKILLS: Programming, Development, Business Analysis, DB2 Database Design, Technical Design Documenting, Project Lead, Mentoring
CONTRACTING: 1994 - 2011
COVIDIEN 2010 - 2011
Mansfield, Ma.
Performed analysis and programming modifications to complete and customize Mallinckrodt’s unfinished end customer rebates application to fit Covidien’s business needs.
Wrote a program to use with the Kronos payroll application to comply with new federal government requirements.
STAPLES, INC. 2005 – 2009
Framingham, Ma.
Working closely with business partners and IS groups to fulfill system requirements, including software enhancements and new development.
Developed slides in Power Point for teaching a 3-part course on the advantages of using free-format RPG programming including usage of built-in functions, prototyped calls to procedures and modules, binding directories, service programs, and the recommended applications for each ILE choice when designing project specifications.
Managed the Commission Extract Report Project, meeting with the business and providing the Project Charter, Project Approach and System Requirements, while assisting a development team with the technical design. Planned daily meetings with on-shore and off-shore resources, and conducted weekly meetings with the business as requirements shifted.
Acted as technical lead on Product Alternates project, which provided alternate choices for customers shopping on StaplesLink.com based on price, margin and/or customer initiatives. Provided technical design using ILE techniques (service programs and modules) to integrate the selection of alternate products in the existing contract pricing engine program. Supervised one contractor on this successful effort. Organized and led meetings with the web team and another group that developed the maintenance screens to enroll customers in the Product Alternates program to develop the best approach.
Developed some monitoring programs to alert on-call technicians when EDI orders are not being processed in order to quickly solve issues when they happen.
Worked with a team as a principal designer/programmer/analyst on a project to on board Ingram Micro technology items as wholesaler SKUs available for purchase on StaplesLink.com. This was a successful effort that crossed multiple platforms and technologies. I primarily focused on the program that accepts order requests and stock checks and sends them to another program through message queues that passes the requests on to Ingram Micro. Additionally, I was instrumental in the define, design and implementation phases across the whole project.
Acted as technical lead on the Automatic Item Blocking process, in conjunction with the StaplesLink.com team. This project enabled contract customers to optionally automatically block new items from being made available to their purchasers until they had a chance to review and electively unblock the SKUs they wished to make available to purchase. Led a group of two senior programmer/analysts who helped in the reporting process of the project, which included a daily “new items” report and system logging files to track activity. I designed and created the code for the blocking process.
Helped as an additional programmer on the Copy & Print project to lessen the load on the team assigned to that project.
Created a process to enable the Customer Set-Up department to assign customer service phone numbers at the master, bill-to or ship-to levels for printing on their packing slips. Made the database process, including service programs, modules and procedures, generic to use for other similarly keyed applications so it could serve other future purposes and not be restricted in its use.
Took the initiative in helping to stabilize the Contract Order Management System, analyzing and finding permanent solutions to recurring issues in the background batch jobs, such as record locks and duplicate record writing, in order to stop the on-call technicians from constantly performing manual workarounds.
Created a modular application to process returned cartridges and toner as part of the Staples Ink Drop process. Incorporated an Ink Drop item lookup service program for the process which can be used in other applications as a generic item lookup service program.
Created a modular label printing process for printing return labels to be packed with an Ink Drop order using Mark Magic label designing software.
Supported stabilization projects for the North American Delivery team to fix existing bugs.
Modified order history retrieval modules to return customer purchases by most frequent and most recent for EZRO (easy reorder) process, enabling customers to view the most likely products to purchase on the Staples website.
TYCO HEALTHCARE RETAIL GROUP 2003 - 2005
King of Prussia, Pa.
Created a daily and 12-month projected inventory report for the CFO, using BPCS and IMREX files,
as a tool to project ending inventory in dollars and units for any month, based on sales forecasts and
planned production. Set up report to automatically be e-mailed nightly to the CFO and other top managers
as the basis for their financial reporting.
Rewrote a broker commissions report system, enabling the process to differentiate between paid and unpaid invoices, to comply with a new company policy to pay brokers only after the company received their payment from the customer. Separate reports were generated for paid, unpaid, and potential commission payments.
Led a project with two other programmer/analysts to produce an ILE system of modules and service programs to create a sales forecasting system, called Sandbox, that enabled the planners to obtain financial data based on varying forecasting scenarios. Once satisfied with the results, the “sandbox” data could then be copied into the “live” forecast. User-friendly screens included push buttons, radio buttons and
hyperlinks to give the programs a GUI appearance and functionality.
Created various other inventory and financial reports for the company.
Anchored an IS staff in transition, while interviewing candidates to help in the selection process to build a permanent IS team.
Put together a tutorial and taught a class involving the new hires, teaching them the concepts of ILE service programs, modules and procedures, as well as the proper application for each concept.
Helped establish the IS coding rules for the business and included that in my tutorials.
Worked extensively with the latest ILE techniques as well as using time-sensitive SQL subfile techniques.
ARKWRIGHT INC. 2003
Fiskeville, RI
Created custom programs for business needs utilizing BPCS database. Created menu system to reduce
effort required by system operator to perform daily tasks. Part of the menu system dealt with making the arduous task of releasing multiple BPCS orders (sales, purchasing, etc) from erroneous “hold” statuses
much simpler.
KENDALL HEALTHCARE INC. 1999 – 2003
Mansfield, Ma.
Wrote conversion programs and orchestrated a successful transition of the Tyco Adhesives group from
Imrex to BPCS.
Rewrote Kendall’s entire contract maintenance/inquiry and contract hierarchy maintenance/inquiry
programs using modules and service programs. User-friendly screens included push buttons, radio
buttons and hyperlinks to give the programs a GUI appearance and functionality.
Worked extensively with the latest ILE techniques as well as using time-sensitive SQL subfile techniques.
Supported my own as well as existing rebates and tracings system, responding to user needs.
Provided demonstrations of the new rebates and tracing (contract) system I created.
Created a new point-and-click menu system on the AS400 for Kendall’s inter-company relationships, called PARTNER, with built-in maintainability to create and change menus as well as on-line help text.
Integrated Keyes Mail system into AS400 programs to enable sending files, reports and messages from the
AS400 to the company’s email server, allowing users to send AS400 reports to anyone with an email address.
TYCO ADHESIVES INC. 2000
Norwood, Ma.
After orchestrating the Imrex to BPCS conversion at Kendall Healthcare, I moved on to Tyco Adhesives
to provide initial BPCS support.
Wrote some complex sales extract programs and reports using the familiar Imrex layouts that were retained
with the conversion to BPCS.
Introduced the AS/400 push button and hyperlink logic to Tyco Adhesives in my work there.
WRIGHT LINE INC. 1999
Worcester, Ma.
Worked with a team of consultants to modify company’s software for Y2K compliance.
ARKWRIGHT INC. 1998 - 1999
Fiskeville, RI
Applied Y2K logic to custom programs. Applied custom modifications in BPCS 4.0 to BPCS 6.4 Y2K compliant code. Created an application program to enable users to manipulate their own spooled files.
C+K COMPONENTS INC. 1997 - 1999
Watertown, Ma.
Designed application programs based on existing Data3 package to work with Intermec bar code scanners for shipping and receiving. Applications include inventory transaction processing and order receipts. Other projects analyzed, coded and completed per user requests. All coding done on an AS/400 using RPG/IV and RPG/400.
KAO INFOSYSTEMS INC. 1995 - 1999
Plymouth, Ma.
Supporting remote plants using BPCS manufacturing package in day to day operations.
Coordinating installation of Varsity Shipper software at Ontario location and transition of business to California and Ontario locations in preparation for Plymouth plant shutdown.
Supported user requests including enhancing and troubleshooting BPCS, Varsity Shipper and KnowledgeNet packages for all locations.
Created many new applications using RPG/IV with BPCS files, including a complex A/R tracking report system and a customized shipping label system utilizing TL Ashford bar coding software and Zebra thermal bar code printers. Created and maintained custom data bases to produce reporting for all custom programming applications. Redesigned BPCS shop order and pick list to customer specifications. Wrote scripts and programs to transfer AS/400 files to internet addresses and an HP3000 during a client move from BPCS to an HP3000 platform. Did extensive work using subfiles and DDS windows.
EDUCATION:
RHODE ISLAND COLLEGE
B.A. in Mathematics and Computer Science
Contact this candidate