Candidates About

 

William Murphey

Senior Technical Business Analyst, Project Leader, and Senior Developer with 30 years of experience using strong documentation and analytical skills in designing, specifying, coding, testing, and implementing complex data bases, general ledger, scheduling, inventory control, warehouse, distribution, banking, and interface systems. IBM and JD Edwards Management experience with a staff of up to 11 consultants.

Hardware:           AS/400, IBM Mid-Range System i, IBM PC.

Languages:          CL, RPG-Free Format, RPG-ILE, RPG-IV, SQL, IBM MQ, Visual Basic 6.0, MS Access, MS Excel.

Software:              Intentia Movex 12.6 & X12, PKMS WMS 18.2, Oracle Enterprise (JD Edwards World) 8.2.6 & 7.3(GL, AP, AR, Allocations, Distribution, Utility Billing), JDA MMS Retail, KBM, Aldon Change Management, GXS Trading Grid & TeamBook EDI, Inovis (Harbinger, Premenos) EDI, Visio 2000, Island Pacific, Ron Lynn Management, MAPICS, BPCS, Email & FTP on the AS400, AS400 Query, IBM PDM, Installshield 3.5, MS Office Suite, MS Project, Vantive Helpdesk System, QlikView Reporting, NuOrder 4.0 Web Retail System, TLAshford 3.2 Barcode400 Label software.

 

Experience:

Delta Galil Clothing MFG                                                                               1/17-10/17

Consultant, MOVEX X12, GXS EDI, NuOrder Web Wholesale, QlikView Reporting, TLAshford, AS400

·         Performed Business systems and data analysis for MOVEX users.

·         Tested and deployed new customer EDI documents 850, 856, 810, and UCC128 labels.

·         Developed system documentation and user instruction documentation.

·         Provided user training in class sessions and individually.

·         Supported NuOrder database setup and launch of web presence for Splendid/ella moss Brand.

 

Private Client Project                                                                                       10/16-12/16

Consultant, JDEdwards ERP SME, AS400

·         Performed technical data analysis.

·         Designed and coded system enhancement.

·         Developed technical system documentation and user instruction documentation.

·         Provided client and end user training.

 

Michael Kors                                                                                                      3/15-10/16

Business Analyst, Solution Designer, Sr Programmer Consultant, AS400

·         Developed software solutions for the Ron Lynn Management Wholesale system on the iSeries.

·         Designed and developed interfaces using IBM Message Queues (MQ) and XML formatted exchange files.

·         Developed Sales Order import system receiving data through EDI.

 

NAPA Genuine Parts Company                                                                     6/13-3/15

Business Analyst, Solution Designer, Sr Programmer Consultant, AS400, RPG ILE, JDEdwards ERP

·         Developed Remote Inventory Management interface for Chicago Transit Authority in to GPC JD Edwards. Including EDI file conversions, automatic part number creation, and automated obsolete inventory depletion.

·         Designed and implemented automated daily sales reports using SQL and CoolSpools utility.

·         Design automated CoolSpools email utility for any job to email EXCEL sheets to multiple email recipients.

·         Designed RF scanner utilities for field reporting in the warehouses.

·         Automated the creation of Vendor Debit Memos in JD Edwards for Core Return Fees. Including Parent/Child address book logic and control table setup.

·         Supervised the consolidation of 58 warehouse libraries in the one enterprise library for the future management of the Core Return System.

 

Edison Group – JDEdwards Business Application Specialist                1/13-5/13

Business Analyst Consultant, JDEdwards ERP and E1

·         Provided marketing analysis guidance for Oracle/JDEdwards marketing research.

·         Analyzed JD Edwards client interviews for E1 and World environments.

·         Determined marketing strengths and weaknesses.

·         Reviewed Analysis Report for Oracle/JDEdwards group.

 

Bank of America – Global Wealth Management Team                          8/10-12/12

Business Analyst Consultant

·         Network performance testing and reporting using TeamQuest PE tools and MS PowerPoint.

·         Provided Remote 3rd level Production Support of network capacity issues.

·         New Development server capacity impact analysis of Response, Stability, and Regression Comparison.

·         Report format design and evolution to meet client-side requirements.

·         Managed training of overseas support team to create 24/7 P.E. testing environment.

·         Completed BOA Certification in the following:

-    Information Protection and Privacy 2010

-    Information Protection and Privacy 2011

-    AML Enterprise Awareness v1 2010

-    AML and Economic Sanctions 2011

 

Private Client Projects                                                                                     5/10-8/10

Consultant

·         Performed technical analysis and system engineering services.

·         Hardware installation and testing.

·         Network performance engineering and reporting using TeamQuest PE tools.

 

Duane Reade Pharmacy                                                                                   11/09-6/10

System Architect Consultant, AS400, RPG ILE, JDA Retail, ALDON CMS

·         Performed technical analysis and design revision to integrate a parallel rebate and allowances system into base JDA.

·         Designed, coded, and implemented Rebate Control Table and Rebate Entry system.

·         Analyzed accounting formulas, designed, and coded rebate average cost adjusting programs for instant rebate claim invoicing.

 

Allied Beverage Group                                                                                    4/08-8/09

Business Analyst and Subject Matter Expert Consultant, AS400, RPG ILE, JDEdwards ERP

·         Redesigned JD Edwards 8.2.6 environment for future release upgrade.

·         Performed data analysis, summarization, and purge for 1993-2001.

·         Design, code, and implement JDE Z-file interface for GL (F0911) and AR (F0311) entries from marketing data.

·         Modified Invoice Entry program to perform additional customized date edits for Invoice Date ranges.

·         Developed AS400 system to convert Spool Reports to EXCEL sheets in the IFS drive and send email from the AS400 to distribute the XLS files.

·         Developed an Open AR extract file sent to the IFS drive that combined JDE AR and a custom database AR system to produce a single format file for PC data mining.

 

URL Mutual Pharmaceuticals                                                                        8/06-3/08

Business Analyst and System Architect Consultant, AS400, RPG ILE and Free, KBM, ALDON CMS

·         Designed, coded in RPG Free and ILE, and implemented sales data interface to KBM invoicing and General Ledger files using System I IFS objects to transfer data from PC based MAPPER database tool.

·         Replaced custom EDI 844 and 849 Chargeback system with a status code based multiple resubmission management and processing system.

·         Created system documentation and user training manuals. Provided group and individual user training sessions.

 

Misco Home and Garden, Inc.                                                                        5/06-7/06

Business Analyst Consultant, AS400, RPG ILE, JDEdwards ERP

·         Analyzed, fixed, and enhanced partially completed Sales History Reporting tools containing SQL functions, and wrote additional new reports.

·         Provided business analysis of current JD Edwards implementation.

·         Provided direct counseling to VP of Sales for overseas freight management, warehouse management, and data integrity systems with in the current JD Edwards system.

 

Baldwin Hardware Corporation                                                                   2/06-5/06

Consultant, AS400, RPG ILE, KBM, ALDON CMS

·         Developed interactive inquiry programs with data edits to support Sales Promotional programs in KBM.

·         Debugged and fixed subfile inquiry and display to determine screen rolling error in existing KBM program.

·         Updated Discount Matrix and Supplier Quote table with SQL.

·         Created EXCEL exports from AS400 Database files to support management analysis.

·         Assisted in Quickbase Project Tracking system improvements.

 

Ross Air Systems                                                                                                12/05-2/06

Business Analyst and Project Management Consultant, AS400, RPG, MAPICS, PC, MS Access, Visual Basic

·         Performed business analysis of firm’s work flow on legacy AS400 MAPICS and current server based system.

·         Designed and specified VB software solution and data migration paths.

·         Compiled project time line and budget information for management approval.

·         Using MS Access and Visual Basic coded PC based Bill of Material software solution and data conversion.

·         Modified Contract builder application in MS Word with Visual Basic Forms and code.

·         Provided documentation and training for 20 users.

 

 Franco Manufacturing                                                                                    6/05-11/05

Technical Project Leader, AS400, RPG ILE, KBM, ALDON CMS

·         Developed AS400 side of RFID tag checking for outgoing Walmart orders by modifying RPGIII programs.

·         Developed Container Demurrage/Detention Contract management system in RPGILE and by converting several RPGIII programs to ILE. Contract Database provided automated Date Maintenance for shipping containers.

·         Developed MIS Department software change control system using user interviews, Visio flow chart design, RPGILE, and softcoding (table driven) techniques.

 

Amerex, Inc.                                                                                                        1/05-6/05

Consultant, AS400, RPG IV, PKMS WMS, Gentran EDI, ALDON CMS

·         Supported Gentran EDI software interfaces and operational needs to include problem analysis and EDI interface testing for 850, 856, and 810.

·         Maintained PKMS environment and provided user support for multiple warehouses.

·         Analyzed and extracted historic data for AS400 to PC database for long term retention.

 

Allied Beverage Group                                                                                    1/05

Consultant, AS400, RPG IV, JDEdwards ERP

·         Upgraded PeopleSoft Enterprise (JD Edwards) 8.2.2 to PeopleSoft Enterprise (JD Edwards) 8.2.6. Project included full analysis of existing functionality, menu and Data Dictionary changes.

·         Analyzed, organized and implemented Finance Department security setup. This included menu masking and program traces for backdoor access.

·         Restructured custom menus and menu/option masking.

 

GlaxoSmithKline                                                                                               9/04-12/04

Business Analyst Consultant, BPCS, AMICS, ERP Business Analysis, MS Project, MS Office tools

·         Performed business analysis of existing MRP system to include user interviews, VISIO flowcharts, FDA regulatory compliance analysis.

·         Wrote Business Requirements Specification to replace MRP system.

·         Performed Cost/Benefit analysis of several MRP systems to include BPCS, AMICS, and ProduceIT-ME.

·         Developed project management timelines and tracked group progress.

 

Merck & Co., Inc.                                                                                                6/03-6/04

Business Analyst Consultant, AS400, RPG IV, JDEdwards ERP

·         Responsible for monthly Sales, Inventory, and Costing extract from global JDEdwards sites.

·         Developed Function Specifications and User Manuals for Initial Installation, System Setup, 2 global releases, FTP processes, and various major system programs.

·         Redesigned data extraction programs to use control tables to reduce future maintenance requirements and enhance user flexibility.

·         Collect and standardize multiple versions of source code from 30 sites worldwide.

·         Responsible for full Project Lifecycle for enhancements and all aspects of system support and software management in Aldon CMS.

 

Calvin Klein Jeans                                                                                            4/02-6/03

Project Leader, EDI Manager, AS400, RPG IV, Harbinger EDI, Ron Lynn Management

·         Responsible for all Harbinger EDI operations, daily error analysis and solutions.

·         Setup EDI Trading partner relationships, Document Mapping for 856s and 810s, interfaces, and testing.

·         Developed UPC multi-database cross-reference system for Ron Lynn Management system.

·         Wrote Business Requirements and designed project plan to correct existing QRS/UPC system errors and automate daily maintenance operations across two databases.

·         Setup and supervised Microsoft Project implementation for MIS department task tracking.

 

AE Products                                                                                                        1/02-3/02

Consultant, AS400, RPG IV, JDEdwards ERP

·         Developed Session Inactivity Monitor that worked with message queue triggers to allow selected sessions to stay open even if inactive.

·         Designed and wrote automated OUTQ maintenance job to clear selected OUTQs.

·         Developed Shipping reports using JDEdwards’ FASTR and Dream Writer features.

 

Gucci America                                                                                                    3/01 – 1/02

Client Manager and Business Analyst Consultant, AS400, RPG IV, JDA Retail, PKMS WMS, Visual Basic

·         Supported daily JDA analysis and programming needs.

·         Wrote Business Requirements and Functional Requirements, coded, and implemented Automated Store Transfer system using barcode scanning, PC batch files, Visual Basic, and FTP with interfaces into JDA. Created Installshield utility for automated chain-wide distribution of the system.

·         Reviewed and executed consulting contracts in support of various requirements.

·         Wrote Functional Requirements, designed, coded, and implemented the Serial Number tracking features in PKMS. This included interfaces with the IMREX download that provided the order and item information, new FTP transmission programs, and enhancements to existing PKMS programs to create custom editing and maintenance features not provided by PKMS.

·         Designed and wrote several programs to convert existing divisions to PKMS with their historic data.

·         Provided analysis, programming and support for Lawson Employee systems implementation and employee renumbering.

·         Wrote AR Aging and several other reports as part of MOVEX implementation.

 

Atlantic Container Lines                                                                                  4/00 – 3/01

Business Analyst Consultant, AS400, RPG IV

·         Developed Functional Requirements and completed full project cycle in writing an EDI interface to handle their automotive bills of lading input from a major business partner.

·         Managed, maintained, and enhanced in-house legacy ship management system, which included project tracking and prioritizing, user interviews and training, a major rewriting of the ship scheduling system and several port cost reporting systems.

·         The projects were required to provide soft coded handling of services and other control values as the business expanded past the original hard coded designs.

·         Used ODBC, MS Access, and Visual Basic to provide ship operations with direct online proof sheets of data for monthly reconciliation.

 

Tommy Hilfiger                                                                                                 11/98 – 3/00

Business Analyst Consultant, AS400, RPG IV, JDEdwards ERP

·         Responsible for establishing the trading partner links and, then coordinating the testing and implementation process through several divisions of Chase Bank.

·         The data was extracted from the Transaction Ledger, logged for Clearing, and exchanged using EDI X12 formats and Premenos software.

·         Automated the Reconciliation process to receive data and process it into the JDE Reconciliation work files.

·         Provided the technical and programming expertise for the implementation of JD Edwards 7.3.8 GL and AP modules.

·         Developed Functional Requirements and wrote automated processes for the monthly sales and licensing interfaces from their custom Divisional systems to JDE ‘Z’ files.

·         Analyzed and wrote documentation of their custom inter-AS/400 platform batch job manager system.

·         Developed Functional Specifications and Requirements, wrote, and implemented Positive Pay Verification between JDE AP and Chase Bank.

·         Provided production support during the absence of Finance Department managers.

·         As part of the group working on an NMC Accounts Receivable expansion, wrote the Order Approval/Hold program in ILE. The program allowed detail level partial order approval, performed account credit limit checks and order status updates. It also maintained statistical summaries for six month performance tracking.

 

Additional AS400 and RPG environment Consulting Assignments      9/87 – 10/98

Project and Management Details will be provided upon request.

·<span style="f