Sales Customer Service

Mogavero, Joe

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

Billerica, Ma ****2

Tele 978-***-****

Cell 978-***-****

EDUCATION:

Northeastern University, Boston, Ma.

Masters in Business Administration, 1982

Certificate in Client Server Technology 1998.

Suffolk University Boston, Ma

• Bachelor of Science in Journalism, 1975

Cambridge Institute For Computer Programming, Boston, Ma

• Certificate in Computer Programming. 1984.

PROFESSIONAL EXPERIENCE:

June 1986 – November 2010 Charles River Laboratories, Wilimington, Ma.

Specializing in analysis and programming on ISeries Mainframe for sales order entry, order processing, sales Analyis, various financial systems, purchasing, inventory, and manufacturing systems. Extensive business knowledge of RMS – Small Animals and services, GEMS, RADS, Avian and Invitro business systems. Technical skills include RPG IV programming language, Progress 4/GL, SQL, PIVOT Tables, Lotus Notes, Office 2003, and Office 2007.

2009 – Present IT Specialist II - Analysis & Development,

Co-wrote a Data Dictionary for Decision Center reporting.

Created various sales analysis reports within decision center using Excel Pivot tables.

Perform Daily and Monthly RMS Decision Center reconciliation reporting. Include research and troubleshooting variances within SAP. Updating the IConnect Data Reconciliation page daily.

Investigate Daily Invalid Data report issues, investigating, and entering TCC tickets when necessary. Create and distribute a log report weekly to TTC decision Center incidents.

Involved in Customer and materials harmonization using the associated tools to validate Galaxia, Ruby, and other legacy system data.

Participated in SAP design sessions providing input on requirements for : customer accounts, RMS and JDE products and services; RMS US pricing and contract requirements; Grantees; Government Pricing; crate packing schedules; sales order analysis, material usage/description, and customer account conversion.

Provided data sets in excel format for RMS testing including products and services and open receivables data to SAP for testing purposes.

Attended high-level data warehouse overview sessions on Customer Add/Change and data harmonization applications: Products and Services application, and data warehouse environment.

Participated in design and strategy discussions with SAP team in addition to an overview of legacy system data for:

o RMS Canada and US Pricing and contracts (surgery, value added services, animal freight) NIA and Non-NIA, Inter-Company, Grantee, RADS, GEMS, Invitro, and Avian.

o Transportation and Route Codes.

o RMS Open Orders

o Inventory and materials.

Worked closely with the data warehouse team to understand current item/customer design and mapping. Analyzed and debugged JDE/Animal System sales feed questions and issues.

Extracted and transformed the following legacy systems:

o Invitro Inventory

o Partnership Relationship files for RMS accounts.

o JDE Convert and RMS Ship to convert files for cleansing team.

o Exception reporting for missing DH numbers and partnership relationships for RMS pricing contracts, JDE Contracts, and RMS open orders.

Participated in the RMS US customer extraction and conversion process which involved combining data from the Decision Center, Anima, and JDE systems.

RMS Animal and JDE Systems Support:

o System changes for new freight carrier – Pilot Air Services

o Analysis and implantation for Invitro product line and item class reorganization.

o Setting up new acquisition Piedmont in JDE.

o Modified system for RMS Canada to process lab health cards.

o YTD tax reporting for 2006, 2007, and 2008 for Finance department.

o Production Automation system

o Sales analysis and reporting changes.

o Lab health card reporting.

o Assisted marketing in Global sales reporting configuration.

June 1999 – 2008 IT Staff Specialist

As part of the exiting ERP project team provided demo to existing legacy systems; created legacy system road maps and documentation for members to get a better understanding; worked with SAP programmers on business logic; provided knowledge transfer to team members and consultants; provided sample data to ERP team from legacy systems; attended various meetings and offered ideas; and worked with team members to develop mapping data into SAP

Provided analysis, designed and programming for the Preconditioned Animal Services Models. In order to accommodate this new service key enhancements were made to exiting sales order entry and order processing and inter faces to the ILIMS lab system.

Wrote an analysis and design document on RMS Animal Order Entry system Improvements.

Upgraded Alden Software – A Change management application tied closely with Sarbanes –Oxley CRL controls.

Instrumental in converting National Cancer Research (NCI). Made the required programming and setup changes to allow them to process orders in JD Edwards.

Designed and programmed Animal Inventory system for ZDF rats based on age and date of birth categories. This was integrated into the RMS sales order entry system providing inventory lookup and side by side inventory comparisons with ZDF FA/FA versus ZDF +FA inventory.

Automated a process to create a Customer Price File which took days to create manually. Designed and programmed a system whereby the user can enter a customer account number to create an Excel file with customers’ price list based on list and contract pricing and thus email it to the customer in minutes.

Modified the Production Automation System to allow weekly census recording for Monogamous and Polygamous Obese Rat and Mouse production models. .

Designed and developed an automated Credit Card reporting process whereby Customers received via PDF email a weekly summary status report of their credit card orders.

Endosafe Manufacturing Project. Designed, setup, and training. Install JD Edwards’s modules – Product Data Management, Shop Floor Control, Distribution and Planning, Product Costing and Manufacturing Accounting. In addition, implemented and tested Product cost accounting, forecasting and budgeting, inventory controls, dream writer menus, and sales reporting requirements.

Reduced faxing costs for Customer Order Status and Order Acknowledgements by making system changes to allow customer service to email PDFs.

Contract Billing and Service Billing converting archived billing and reporting from On Demand archival to Spymaster Optical Software. Moreover, created menu options with customer and invoice lookup to view, print, fax, and email these documents.

• Integrated new acquisition GMI into the RMS sales order entry and processing, Accounts Receivables, and Sales Analysis system.

• Converted the transfer of Canadian Shipping documents and files by modifying the processed by using TCPIP and FTP.

• Instrumental in the purchase, implementation, and training of the Blue Ocean Track-It Help desk system.

• Responsible for the design and programming the PAI Contract Billing system reporting.

• Activated the order processing system for the RMS Lakeview facility after it was closed for a couple of years. This included programming for processing shipping documents - Rundowns, Customer Receiving Slips, Freight Manifests, Health cards and shipping labels. Setup backup remote line and high speed printers.

• Member of the document management system and implementation system for Master Control software. Involved with vendor setting up and installing software. Responsible for installing client software, testing response time from remote locations. Additionally, created a network diagrams to validate the network for FDA requirements

• Converted CRL San Diego onto the RMS Order processing system to process shipping documents – Rundowns, Receiving Slips, Freight Manifests, health cards and shipping labels.

• Installed RJS Report Splitter This allows reports to be automatically split into manageable sections before they leave the AS/400 and print at different locations.

• Modified the Freight rate system to handle the setup of freight rates based on start and expiration dates thus allowing customer service the ability price orders scheduled to ship at the beginning of the new year

• Modified the RMS Small Animal pricing system to provide customer service the ability to automatically price orders using next year’s pricing for orders shipping into the next year.

• Installed JDE Electronic Burst and Bind (EEB) report distribution software. This allowed reports

• Provided Lotus Notes and Telemar Implementation and technical support to the 24 person CRL sales force during the 1999 Sales meeting in Florida.

• JD Edwards support for Sales order Processing, Advanced Pricing, Inventory, and batch lot control.

• Designed and programmed a system whereby Frederick Cancer Research Government contract was able to use existing CRL system to process their credit card orders and account receivables.

Designed and programmed a Late Order Notification system for the RMS Small Animal system. When late orders were orders were entered, changed, or cancelled an email notification was sent immediately with the order specifications notifying the shippers at the plant and area level to start preparations to ship the order.

Special Animal Management System (SAMS). Using Progress Software ADE/4GL programming language was able to design browsers and programming of catalog, project entry, protocol and non-pedigree animal inventory and mating data. … Wrote the billing system and interface to the PIVOT system.

As part of the Order Entry/2000 team made numerous programming changes and enhancements to incorporate 21st century date logic and new file structures.

As part of the Production Information/2000 teams enhanced the system numerous programming changes and enhancements to incorporate 21st century date logic and new file structures.

1991 – 1999 Senior Application Systems Analyst and Programmer

• Installed Monarch Software - a desktop report mining tool used to extract data from readable spool files, such as text, PDF and parse the data into a table. This was a time saver for accountants and marketing personnel for putting together monthly spreadsheets.

• Designed and developed the Isolator System which records weekly isolator inventory information and uploads summary data by strain to the Production Information system.

• Designed and programmed the RMS Timpreg/Retired breeder which interfaces with the RMS Sales Order entry system.

• Project leader for Y2K Certification testing for RMS Order Entry and processing. Validated numerous order processing scenarios using year 2000 dates.

• Converted Endosafe (Invitro) to the JDE Sales Order processing and Inventory Control. Wrote customized functions for batch/lot control an implemented advanced pricing. Created menus, dream writers, world writers and processing options to meet the business requirements. Trained users in SOPs, Inventory Control, pricing, and accounts receivables

• Modified the RMS Open Orders reporting to include more field information, filtering and sort selections. .

• Installed and maintained Marcams' PIVOT Order Entry and Billing system Trained Users on various functions of this system. Designed and implemented Packing Slip, Shipping labels, Acknowledgements, and Invoice forms.

• Made major modifications to the PIVOT system. ... Expanded selection criteria for reports. ... Streamlined on line shipping and freight calculation processing methods ... Wrote streamlined order entry system with customer look ups and shipping address overrides.

• Designed and wrote a system to monitor on a monthly basis orders entered by a customer service reps.

• Designed and wrote a sales analysis system for our non animal sales. This system includes on line inquiries, weekly, monthly, quarterly, and yearly reports.

• Researched, wrote, and presented an analysis of the company's Sales Analysis systems

Sales Order Entry

• Made major modifications to our Animal order entry system. Allowed for the cancellation and re entering of an order thus eliminating key strokes.

• Designed and wrote Customer Expert System based on customer inventory storage location preferences. This would block certain locations based on Lab Health profiles. It was built into the order entry system with warning messages and drill down capabilities to the actual expert system record.

• Designed and programmed a system whereby a customer service rep can fax a Customer Order Status report to a customer from their computer. This change alone saved their department a minimum of eight hours per week. (Prior to this they had to cut and paste information from different reports and individually fax them).

• Participated in the migration of System 38 objects to the AS/400.

• Evaluated the following software MARCAM (PRISM), Software 2000 (ARIES), SSA (BPICS), MAPICS, and COGNOS.

• Evaluated the following vendor software packages Debugging software as AMALGAMATED EXTERMIN8, and INTERNATIONAL SOFTWARE GROUPS AID/400. Helpdesk software by CYRO and SILVRON. PC software as LOTUS 123, MICROSOFT WINDOWS and PARADOX.

• Wrote an on line HELP DESK SYSTEM which allows users to enter help requests. The requests are then transferred to the person most responsible for the system. When the problem is solved the user is notified by E mail of the resolution.

• Worked with the following software packages LAWSON Inventory; MARCAM PIVOT, MAPICS Accounts Receivables, COMPUTER ASSOCIATES General ledger, RYDEX FAX, GUMBO Software Report Designer.... Programming tools utilized EZVIEW, PROBE, and ABSTRACT.

June 1986 – May 1986 Programmer/Analyst

• Wrote a CER to purchase MAPICS software. Planned and installed three MAPICS modules Inventory Management, Product Data Management, and Production Control & Costing.

• Inventory Control: Helped coordinated several physical inventories of Opticell equipment. .... Provided users with ad hoc reporting, wrote a program to generate physical inventory tags.

• Enhanced reporting and helped design a VAF/Plus Card for our Laboratory Health system.

June 1985 – May 1986 Allied Instrumentation Labs Andover, Ma.

Systems Analyst Programmer I

• Maintenance of Payroll system. This included successful debugging of a Payroll Budget System. ... Restoration and enhancement of the Payroll EEO Quarterly system.

• Performed maintenance to Accounts Payable, Accounts Receivables, and Payroll, Inventory, and Order Entry systems. Trained users on systems I modified.

• Wrote a feasibility study on the overhaul of a sales tax system to be replaced by VERTEX sales tax package.

April 1984 – May 1985 James W Daly Company Inc, Peabody, Ma

Programmer Analyst

.

• Programmed in RPG III and CL on a System 38 for a pharmaceutical and hospital supply distributor.

• Designed and wrote a sales analysis application to monitor sales

via the company's telecommunication system.

• Created a monthly manpower distribution application which

monitors employees' regular and overtime hours for various departments.

• Wrote a series of programs to monitor purchases for Hospital Contract Association (HCA). Included were monthly and quarterly with elaborate statistical information ... economic order point quantity, turnover rate, average purchases per month, purchases in descending dollar amounts, etc.

• Installation and replacement of matrix printers and modems for order confirmation system to hospitals.

April 1984 – May 1985 Co owner, Joseph’s 'Produce Market, Boston, Ma.

Entered a family owned business with an equity position. Responsible for total operation, including hiring and training employees, marketing, finance, and transportation.

Part Time Jobs include various positions during 1971 75 including: part-time reporter for Winthrop Sun Transcript (published over 40 articles).

INTERESTS:

Interests include traveling, military history, old building architecture, old cemeteries, sporting events, golf, gourmet cooking wine making and gardening.

Contact this candidate