Alan Kerker, LSSMBB
Camas, WA 98607
****@*************.***
CAREER SUMMARY
Senior Project Lead/Business Systems Analyst responsible for all phases of project leadership and
business analysis including project definition, timeline management, requirements gathering,
analysis, documentation, feasibility analysis, cost analysis, design, testing and implementation.
Consistently deliver projects on time and on budget. 22 years of JD Edwards experience. I am able to
build strong teams from diverse functions and backgrounds.
SKILLS SUMMARY
Methodologies/Tools:SDLC, Agile Methodology, PMBok, RUP, UML, Microsoft Project, Visio,
SharePoint, DB Visualizer, Visual Studio.NET
Applications: MS Office Suite, Excel, Microsoft Info Path, Microsoft One Note, Outlook,
ERP: JD Edwards Software: A7.3, A9.1, XE, E1 8.0, 8.10, E1 8.12, E1 9.0, E1 9.1
JD Edwards Modules: Procurement, Inventory, MRP, Sales Order Processing, CAM (Capitol asset
Management), GL, AP, AR, FA, Multi Currency. Work Orders
Languages: VB.NET, Visual Basic 6.0, XML, HTML, XHTML, SQL, COBOL, RPG IV,
RPG ILE
Databases: SQL Server, Oracle, Access
Operating Systems: Windows XP, UNIX, OS/400, Vista, Windows 7
CAREER EXPERIENCE
Shasta Consulting, Senior Project Lead/Business Systems Analyst/Consultant 2007 - Present
• Trex – Senior Consultant (functional)
Lead consultant for the implementation of JDE E1 9.1. Modules implemented: Capitol Asset
Management (CAM). Responsible for: Project plan, Project budget, analysis, design,
configuration, training, testing, go-live support.
• Nektar Pharmaceutical – Senior Consultant (functional)
Lead consultant for the implementation and support of JDE E1 9.1 upgrade of their existing
JDE system. AP, GL, AR, Inventory, Procurement, MRP, Forecasting, Manufacturing, Sales
Order Processing & Advanced Pricing. Responsible for: Project plan, Project budget,
analysis, design, configuration, testing, training & go-live support
• SRY – Senior Consultant (functional)
Lead consultant for the implementation and support of JDE E1 9.1 upgrade of their existing
JDE system. Inventory, Procurement, Capitol Asset Management (CAM), Work Orders, Sales
Order Processing & Advanced Pricing. Responsible for: Project plan, Project budget,
analysis, design, configuration, testing, training & go-live support
• Aviation Partners Boeing – Senior Consultant (functional)
Lead consultant for the implementation and support of JDE E1 9.02 implementation of a new product
line to their existing JDE system. Inventory, Procurement, MRP and Sales Order Processing,
Advanced Pricing. Responsible for: Project plan, Project budget, analysis, design, configuration,
testing, training & go-live support.
• Weatherford Industries – Senior Consultant (functional)
Lead consultant for the implementation of JDE E1 9.1. Modules implemented: AWM, Capitol
Asset Management (CAM), Equipment Billing, Inventory, and Procurement & Sub Contracts.
Responsible for: Project plan, Project budget, analysis, design, configuration, training, testing,
go-live support.
• Tutor Perini Construction – Senior Consultant (functional)
Lead consultant for the implementation of JDE E1 9.1. Modules implemented: Capitol Asset
Management (CAM), Equipment Billing, Inventory, and Procurement & Sub Contracts.
Responsible for: Project plan, Project budget, analysis, design, configuration, training, testing,
go-live support.
• City of Lethbridge – Senior Consultant (functional)
Lead consultant for the upgrade to JDE E1 9.0. Upgrade from: 8.12. Modules upgraded: GL,
AR, AP, Capitol Asset Management (CAM), CRM, Inventory, and Procurement. Responsible
for: Project plan, Project budget, analysis, design, configuration, testing, training & go-live
support.
• Aviation Partners Boeing – Senior Consultant (functional)
Lead consultant for the implementation and support of JDE E1 9.02 Inventory, Procurement, MRP
and Sales Order Processing, Advanced Pricing. Responsible for: Project plan, Project budget,
analysis, design, configuration, testing, training & go-live support.
• The Northwest Company – Senior Consultant (functional)
Lead consultant to re-implement JDE E1 9.0. AP, Sales Order Processing, EDI, Inventory and
streamline the closing process. This led to a significant reduction in the time needed to
process accounts payable and perform the monthly/yearly close. We also cleaned up the
chart of account, which led to improved reporting efficiencies.
• Utah Transit Authority – Senior Consultant (functional)
Lead consultant for the upgrade to JDE E1 9.0. Upgrade from: 8.0. Modules upgraded: GL,
AP, AR, Fixed Assets, Capitol Asset Management (CAM), Inventory, and Procurement.
Responsible for: Project plan, Project budget, analysis, design, configuration, testing, training
& go-live support.
• Roseburg Forest Products – Senior Consultant (functional)
Lead consultant for the implementation and support of JDE E1 9.0 Procurement and Sales
Order Processing, Inventory, AWM, Advanced Pricing. Responsible for: Project plan, Project
budget, analysis, design, configuration, testing, training & go-live support.
• City of Plano, Texas – Senior Consultant (functional)
Lead consultant for the implementation of JDE E1 9.0 Procurement & Inventory (with lot/serial
number controls). Responsible for: Project plan, Project budget, analysis, design,
configuration, testing, training & go-live support.
• Semco Energy – Senior Consultant (functional)
Lead consultant for the upgrade to JDE E1 9.0. Upgrade from: Xe . Modules upgraded: GL,
AP, Job Cost, Fixed Assets, Inventory, Procurement, Sub Contracts Multi Currency.
Responsible for: Project plan, Project budget, analysis, design, configuration, testing, training
& go-live support.
• D-Link Europe & North America – Senior Consultant (functional)
Lead consultant for the upgrade of 3 sites to JDE E1 9.0. Upgrades from: Xe, 8.12 & 8.0.
Modules upgrades: GL, AR, AP, Sales Order Processing, Inventory, Procurement, CRM,
AWM, Transportation (new), Multi Currency, EDI & RF Smart. Responsible for: Project plan,
Project budget, analysis, design, configuration, testing, training & go-live support
• Strathcona County – Senior Consultant (functional)
Responsible for the project plan, project budget, analysis, design, system configuration,
testing, training & go live support & project reporting to the county board. Implemented JD
Edwards (A9.1) Job Cost, Purchasing, Sub Contracts & enhanced AP.
• Florida Canyon Mines Inc. – Senior Consultant (functional)
Responsible for the analysis, design, configuration, data conversions, testing training and go
live support for the JD Edwards 8.12 implementation. Modules implemented: GL, AP, HR,
Inventory, Procurement, Fixed Assets, and Capitol Asset Management. Tools Used: Visio, MS
Project, MS Office, SQL
• Florida Canyon Mines Inc. – Senior Consultant (functional)
Performed an analysis of the JD Edwards E1 (8.12) fit for the client. Modules evaluated
included EAM (Enterprise Asset Management/Capital Asset Management), GL, AP, Inventory,
Purchasing/MRP, HR & Payroll. Tools Used: Visio, MS Office Suite
• Crown Packaging/Turkey – Senior Consultant (functional)
Performed an analysis of the JD Edwards configuration in relation to the Turkish legal
requirements. Identified the gaps in the configuration, created, tested and implemented a
solution bringing the system into compliance. Tools Used: Visio, MS Office Suite
• UnivarUSA – Project Lead/Business Analyst (functional)
Performed an analysis of the Inbound Supply Chain, Order to Cash, Work Order
Management (Shop Floor Processes) & Accounting (General Ledger) work flows. Worked
with the users to analyze and streamline the processes. Significant cost savings were
recognized. Tools Used: SQL, PMBok, Microsoft Project, Visio, MS Office Suite
• Sound Transit – Project Lead/Business Systems Analyst (functional)
Project Lead/Business Analyst for the “ORCA” project. Responsible for developing a
comprehensive test and go-live plan. Led the 7 regional participants through a
comprehensive testing process. Worked with the solution provider to resolve issues that
arose during the testing phase. Tools Used: PMBok, Microsoft Project, Visio, SharePoint, MS
Office Suite. Technical Environment: Java, Oracle 10g, Win XP.
• Nike Inc. – Senior Business Analyst (functional)
Performed requirements analysis for the C2Cim project. Responsible for the design,
functional specs and documentation of the Model Object. Wrote the use cases and test
scripts. Documented AS-IS and TO-BE processes. Tools Used: Agile Methodology, RUP,
Microsoft Project, Visio, MS Office Suite. Technical Environment: Java, Windchill, SQL
Server.
• WebTrends, Inc. – Project Lead/Business Systems Analyst (functional)
Performed requirements analysis, wrote the RFP, managed Vendor Demo’s. Guided the client
through the ERP package selection process enabling WebTrends to select the ERP package
that will best meet their current and future needs. Documented AS-IS and TO-BE processes.
Tools Used: PMBok, SharePoint, Visio, MS Office Suite.
Sr. Project Lead/Business Systems Analyst, Nautilus, Inc. (functional) 2003 - 2007
Senior Project Lead/Business Systems Analyst responsible for leading process improvement
projects to leverage technology advancements more effectively to deliver business efficiencies
and cost savings. Led cross-functional teams to determine business requirements, design
solutions and technical implementation. Delivered all projects on-time and on-budget, using
SharePoint to provide the project status.
• Project Lead/Business Analyst for the outsourcing of shipping. Consolidated shipping from
three company owned facilities to one 3rd party facility resulting in over $1M in savings annually.
Responsible for the process of RFP, business requirement generation, vendor selection, contract
negotiation, & system integration. Documented AS-IS and TO-BE processes.
• Project Lead/Business Analyst for the implementation of radio frequency (RF) bar-coding in
the Portland distribution center resulting in increased productivity equivalent of 5 FTE. Responsible
for the process of RFP, business requirement generation, vendor selection, contract negotiation, &
system integration. Documented AS-IS and TO-BE processes.
• Project Lead/Business Analyst for the JDE E1 8.10 ERP implementation to drive enhanced
business efficiency through consolidation of inventory, sales and financial reporting systems. Modules
implemented: GL, AP, AR, Inventory, Procurement, Sales Order Processing, Advanced Pricing and
Customer Service. Drove development of business and technical requirements, wrote project
specifications and software configuration, developed test cases & developed and delivered user
training. Documented AS-IS and TO-BE processes.
• Senior Business Analyst for JDE E1 MRP implementation. Project enabled buyers to more
accurately match supply with demand resulting in reduced inventory costs. Ran process to develop
requirements; developed and wrote project specifications, configured the software views and drove
consolidated picture of supply and demand. Developed technical test cases. Designed, developed
and delivered user training. Documented AS-IS and TO-BE processes.
• Senior Business Analyst for EDI implementation with the retail channel, streamlining order to
cash process with major retail accounts. Responsible for gathering and developing retail account and
Nautilus requirements, driving them to a consolidated, prioritized and agreed upon set of
specifications and delivering on them. Documented AS-IS and TO-BE processes.
• Tools Used: PMBok, MS Project, MS Office, Visio, JDE E1 8.10 ERP, RUP, UML. Technical
Environment: Gentran, Blue Martini, SQL Server
Kerker Consulting, LLC., Senior Project Lead/Sr. Analyst/Consultant 2003
• Benefit Solutions, Inc., Project Lead/Sr. Analyst
Performed requirements analysis and guided the client through the package selection
process enabling improved effectiveness of marketing lead management. Documented AS-IS
and TO-BE processes. Selected and installed SharePoint. Tools Used: PMBok, MS Office
Suite, Visio, MS Project, SharePoint.
• ICOM America, Project Lead/Analyst
Designed and wrote enhancements to the Sales Order Processing system in JD Edwards
(JDE) to enhance ability to track pricing changes in financial systems. Installed a Sales
Quoting system, integrated with the Sales Order system in JD Edwards (JDE) to enable
better tracking of closure rates and margins for sales teams. Tools Used: MS Office Suite,
JDE) v 7.3.
• Clark County YMCA, Project Lead/Analyst
Designed, coded and deployed an automated lending library system, using Access, Visual
Basic, and Visual Studio.NET. Documented AS-IS and TO-BE processes. Tools Used: MS
Office Suite, Access, Visual Basic, Visual Studio.NET.
PHD USA, Inc., Project Lead/Business Systems Analyst/Consultant 2002
• Project Lead/Senior Business Systems Analyst responsible for planning of, and leading a
team through the implementation of ERP software for the Distribution Services Business. Conceived
and created a system to allow for the automation of the manual billing system resulting in measurable
efficiencies in the financial systems. Documented AS-IS and TO-BE processes.
• Designed and wrote enhancements to the A/R system to allow more accurate application of
cash to receipts. Documented AS-IS and TO-BE processes.
• Modified the sales analysis system to allow more accurate analysis of the small dealer
program, resulting in significant cost savings.
• Tools Used: PMBok, MS Project, Visio, MS Office Suite, JDE v 7.3. Environment: JDE v 7.3,
AS400.
J.D. Edwards & Co. 1992 - 2001
Project Lead/Consultant, J.D. Edwards & Co. - Midwest Region, 1995– 2001
Project Lead/Consultant using E1 and World Software. Responsible for making initial client
contact, assessing needs and developing project plans and estimates. Recommended and wrote
enhancements to the base software allowing clients to more efficiently and effectively run their
businesses. Led the projects from conception through execution, including design and
development, budgets, staffing, and communication. Coached teams through difficult technical
modifications, conversions and required interface changes. Managed relationships with business
partners to staff projects and subcontract work. Delivered projects on time and on budget.
• Managed 3 multi-plant projects (2 World, 1 OW) which generated over $1 million each in
revenue. Technical scope included conversions, interfaces, manufacturing, supply chain and
financials. All projects were delivered on time and under budget.
• Managed 5 mid-sized (3 World, 2 OW) multi-plant projects (approximately $500,000 -
$1,000,000 in revenues). Technical scope on all projects included conversions, interfaces and
modifications, and were delivered on time and under budget.
• Midwest Region in-house specialist on EDI (OW and World). Worked with more than twenty
different clients to implement the J.D. Edwards EDI module. This included on-site training and
modifications when needed.
• Worked with a broad range of clients to implement and integrate financials, distribution and
manufacturing modules (OW and World).
• Tools Used: PMBok, MS Project, MS Office Suite, Visio, RUP, JDE. Technical Environment:
JDE, EDI, AS400, UNIX.
Technical Consultant, Brussels, Belgium HQ; EMEA (Europe, Middle East, Africa) 1992 -1994
As a Technical Consultant, responsible for assessing client needs and designing modifications,
conversions and required interfaces to meet those needs. Collaborated with the development team in
JD Edwards headquarters to integrate customer required modifications to the base ERP package.
Designed and implemented customer modifications and conversions. Conceived, designed and
coded add-on modules to the base ERP package to meet diverse country currency or reporting
requirements.
• Designed, coded and implemented the statutory accounting requirements for Greece
and Turkey, which were integrated into the base JD Edwards software.
• Designed and coded a significant modification for a client that became the basis for
multiple general ledgers at the detail level in the base J.D. Edwards ERP system.
• Was a key member of the 3 continent team which successfully converted a $25
Billion multinational client’s ERP systems.
• Designed and coded system modifications to allow payments in a third party
currency.
• Worked with diverse clients to implement distribution, manufacturing and financial
modules.
• Lead instructor for both standard and on-site custom classes for clients and business
partners.
• Tools Used: PMBok, MS Project, MS Office Suite, Visio, RUP, JDE. Technical Environment:
JDE, EDI, AS400.
Cap Gemini America, Programmer/Consultant 1989 – 1991
Buckeye Sports Supply, Programmer 1987 - 1988
EDUCATION
• Bachelors of Science, Management, University of Phoenix
• Villanova University – Lean Six Sigma Black Belt
• Villanova University – Lean Six Sigma Master Black Belt
• American Management Association - Business Writing
Certifications
• JD Edwards software
• LSSMBB (Lean Six Sigma Master Black Belt)
Professional Memberships:
• PMI
• APICS