Candidates About

Duane Garrett

Accomplished, results‐oriented, and dedicated Systems Analyst, Project Manager and Liaison with over 20 years of experience (4 years of Big 5 experience) , which includes:

·         Comprehensive understanding of business process management and the business requirements of the customers and the ability to translate them to specific software requirements.

·         Extensive experience documenting and analyzing the information and data, including logic/process flow diagrams for complex routines and assisting in debugging of programs, testing and correction of program logic.

·         Ability to evaluate information gathered through workshops and surveys, business process description and task analysis.

·         Effective communications with internal teams and external clients to deliver functional requirements like GUI screen and interface designs.

·         Very strong technical skills coupled with business intelligence and a deep understanding of customer's needs so that they can be transformed into application and operational requirements.

·         Expertise acting as an interface between business units, technology teams and support teams

QLIKVIEW BUSINESS INTELLIGENCE SOFTWARE

·         Design, analysis and implementation of internet based operational dashboards using QlikView Business Intelligence Software.

ORACLE ENTERPRISE ONE (JD EDWARDS ONEWORLD, WORLD)

·         Financial (General Ledger, Accounts Payable/Receivable, Address Book, Financial Statements and Fixed Assets

·         Oracle User Productivity Kit (UPK) (also known as Global Knowledge OnDemand Developer)

·         Ten full cycle JDE/E1 implementations, and 7 partial cycle implementations

Other Methodologies

·         Rational Unified Process (RUP), SCRUM, User Acceptance Testing (UAT)

·         Project Management Institute (PMI) and Prince2 methodologies

·         Change Management: RACI analysis, ADKAR and Lewin Change Analysis

7/2012–Present                           Reliance Steel & Aluminum, Co.                                    Cypress, CA

Senior Systems Analyst, Business Intelligence

·         Provided system analysis for the design, development and deployment of QlikView BI applications to twenty-five subsidiary steel companies.

·         Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) tools.

·         Rolled out and support of Maintenance Connection CMMS software to twenty-six subsidiary companies.

·         Experience on the installation, configuration, server settings, and client server installations of Hyperion products such as Hyperion Essbase, Essbase Administration Services, Shared Services, and Hyperion Reports.

·         Involved in emergency support and analysis of system failures and outages. Analyzing system logs and identifying potential systems issues. Improved unreliable management information approach through analysis and modifications of systems and/or procedures.

2/2011–7/2012                                          Independent Consulting                                    Various

Business Analyst/Project Manager

·         Responsible for configuration and setup of system master data to support efficient use of the JD Edwards financial systems, including security, menu/task setup and financial AAI configurations.

·         Lead financial testing team in a JD Edwards EnterpriseOne 9.0 implementation for a major international food distributor.  Designed and reviewed Use Case Testing Scripts of all financial processes on EnterpriseOne 9.0 G/L, A/R, A/P, Inventory and Distribution. Conducted CRP’s through Unit Testing, System Integration Testing and User Acceptance testing. Reviewed technical and functional documentation, as well as test scripts for system interfaces.

·         Assisted in developing high quality business cases for Medical Center and Regional capital projects for a major medical provider.  Duties include using process mapping tools, project work plan tools, charts and graphs and Microsoft MapPoint.

·         Assisted the Procurement department in a JD Edwards EnterpriseOne 9.0 implementation for a major health insurance provider.  Conducted set up and configuration, training documentation and trouble shooting of procurement and financial modules including A/P and G/L.

·         Implemented multicurrency functionality in JD Edwards EnterpriseOne 8.12 for a global construction company.  Duties included set up and configuration, training documentation and trouble shooting.

9/2010 – 12/2010                                          Innowave Technology                        Irvine, CA

Contract Consultant / Presales Consultant   

·         Perform sales and marketing calls to reserve meetings with prospective clients.  Duties included cold calling, lead generation, referral generation and pre-sales support and presentations in JD Edwards EnterpriseOne 8.12.

12/2009–8/2010                                           HauteLook.com                        Los Angeles, CA

Contract Consultant / Business Analyst

·         Implemented Microsoft Dynamics GP 10 financials and inventory for this internet retailer.  Developed all training materials as well as project plans and setup documentation.  Created enterprise wide reports using Microsoft SQL Server Reporting Services.

1/2007 – 9/2009                                            Innowave Technology                        Irvine, CA

Business Analyst/Project Manager   

·         Project management duties included developing the business case, strategic roadmap, project charter as well as the project plan on an EnterpriseOne/JD Edwards/JD Edwards 8.12 financial, Multi-currency, distribution, transportation implementations at a major supplier of fresh-cut produce in the San Gabriel valley.

·         Implemented a hosted instance in a cloud computing environment with WTS.

·         Requirement gathering using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.

·         Proactive business analysis and iterative development of two offsite locations using video and teleconferencing.

·         Developed in-house training materials based on EnterpriseOne/JD Edwards 9.0 using Oracle UPK training software

·         Analyzed and designed custom JDE reports/applications and interfaces.

5/2001–12/2006                                        Independent Consulting                                    Various

Business Analyst/Project Manager

·         Created financial user training materials (General Ledger, Multi-currency, Accounts Payable/Receivable, Fixed Assets and Job Cost) in collaboration with department heads and super-users for international manufacturer EnterpriseOne/JD Edwards 8.11 implementation.

·         PM and Financial Lead of five EnterpriseOne/JD Edwards implementations.

·         Implemented Job Cost and re-implemented EnterpriseOne/JD Edwards 8.10 financials, including Fixed Assets for a Katrina impacted casino hotel on the Gulf Coast.

·         Prepared and taught EnterpriseOne/JD Edwards Homebuilder Management and Job Cost training class for a major northeast builder.

·         Preparation of functional design documents and technical specifications for both on site and off shore locations.

·         Managed development and implementation of a Grant Accounting/Job Cost solution for County of Los Angeles.

·         Implemented EnterpriseOne/JD Edwards Property Management for the Guam International Airport Authority.

3/1998–5/2001                                             Arthur Andersen, LLC                        Los Angeles, CA

Business Analyst/Project Manager

·         Designed, managed, and executed multiple Oracle Enterprise One/JDE implementations for the Financials (General Ledger, Multi-currency, Accounts Payable/Receivable, and Fixed Assets), Distribution/Inventory, Manufacturing, and Property Management suites.  Average project billings $4 million.  Average team size between 8 and 15 developers and consultants, depending on project phase.

7/1997–3/1998                                                    The Hunter Group                        Baltimore. MD

Contract Consultant / Business Analyst

·         Managed JD Edwards OneWorld 6.5 financial (General Ledger, Multi-currency, Accounts Payable/Receivable, and Fixed Assets) implementation at a high tech manufacturing firm in Silicon Valley.  Worked in unison with JD Edwards developers in Denver to debug this early OneWorld release.

2/1997–6/1997                                           Data Profit Corporation                        Springfield, MA

Contract Consultant / Business Analyst

·         ERP sales to small and mid-sized clients in the Northeast using JD Edwards Genesis Solution.  Duties included prospecting and lead development as well as formal presentations. Principle Architect for pre-sales consulting engagements.

·         Managed five JDE World (General Ledger, Multi-currency, Accounts Payable/Receivable, and Fixed Assets) implementations.  Client industries included manufacturing, real estate, currency printing, and a foster care agency.

8/1996–1/1997                        Sebastian International Hair care               Woodland Hills, CA

Contract Consultant / Business Analyst

·         Functional architect advisor for the rollout of SAP FI & MM modules including chart of accounts structure, security level analysis and data flow breakdown for the North American Sales division.  This implementation was only the second time that SAP had been implemented on an AS/400 platform.

2/1994–5/1996                        The Four Seasons Restaurant                    New York, NY

Financial Intern

·         Performed an in depth menu cost analysis on the landmark 5 star restaurant in midtown Manhattan as part of a graduate internship.

1994–1996      Cornell University                                                                 Ithaca, NY

·         Master of Management, Hospitality and Computer Science.

1986–1990      Excelsior College, SUNY                                                     Albany, NY

·         Bachelor of Science, General Business.

other training & certifications

2016                QlikView Training                                                                 Irvine, CA

·         Training on the self-service Qlik Sense product.

2016                Maintenance Connection                                                     Cypress, CA

·         Training in the set up and administration of Maintenance Connection CMMS product.

2014                Dale Carnegie                                                                        West Covina, CA

·         Human Relations & Effective Communications Course

2000                Arthur Andersen Training Center                                      Irvine, CA

·         OneWorld B7333: Sales Order Management, Purchasing Management & Manufacturing Management

1997                JD Edwards Training Center                                              Denver, CO

·         OneWorld B7331: Foundation, General Accounting, Account Receivable,  Account Payable & Fixed Assets

1996                JD Edwards Training Center                                              Reston, VA

·         World A6.5: Accounting Modules, Worldwriter & Dreamwriter