Johnny A. Dolstra

Senior Consultant/Business Analyst

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

Perris, CA 92570

C 949-***-****

ac0snj@r.postjobfree.com

Professional Experience Summary:

Microsoft AX Financial Certified

PeopleSoft Financials expert with over 17 years’ experience with accounting and real estate systems, including several implementations as Project lead analyst and Project manager.

Expert report developer with PeopleSoft nVision and Crystal reports. Designed and built hundreds of reports for the various PeopleSoft Modules. Expert with Query tool.

Financial systems process integration expert for PeopleSoft’s release testing. Responsible for testing the cross-functional process flow between all modules involved in Accruent and Lucernex Real Estate/Lease Administration suite through accounting.

Highly experienced in change management, requirements definition, gap analysis, functional analysis, system configuration, process design, integration with 3rd party software and external sources, quality assurance testing, system reconciliation and balancing, training and post production support.

Strong communicator with developing and presenting end user training.

Relevant Project Experience:

12/2016 to 5/2017 A&E Auto Wholesales, LLC

CONSULTANT/CONTROLLER

Consulted on new policy and procedures for the back office.

Efficiency training in accounting

Implemented procedures for the handling of Cash for down payments to guarantee the deposits are made in a timely fashion.

Daily Bank Reconciliations

Analysis on Revenue vs. Spend

Improvement on transparency where we spend money and if we are getting an acceptable ROI.

Revised reporting for upper management to safeguard accuracy and understanding.

Onsite training for the Accounting and Sales Departments to certify groups understanding of the flow of the car business.

1/2015 to 6/2016 Junction Solutions (Pleasanton, CA)

SR CONSULTANT

Consulted on the rollout of 5 warehouses’ performing configuration and training on Microsoft AX.

Back-end support of AP/PO/GL and FA modules, handling tickets and bug fixes.

Troubleshooting performance issues with the technical team.

Lead financials consultant responsible for the configuration of 5 Microsoft Dynamics AX (DAX) companies for a dairy processor and grocery distributor.

Financial modules configured include General Ledger (including intercompany), Procurement and Sourcing, Accounts Payable, Accounts Receivable, Fixed Assets, and Organization Administration.

Responsible for application testing, user training delivery, financial data conversion, rollout and support of 5 distribution “companies”.

9/2014 to 1/2015 24-Hour Fitness (Carlsbad, CA)

SR BUSINESS SYSTEMS ANALYST – CONSULTANT (5 MONTHS)

Consulting on the 9.2 upgrade from 9.0 and Tools from 8.52 to 8.53

Rewrite of financial nVision reports to make certain of the alignment with the new business model.

Extensive weekly/monthly financial meetings to review and budgets analysis.

Back-end support of AP/PO/GL/KK and PC modules, handling tickets and bug fixes.

Troubleshooting performance issues with the App Admin.

7/2013 to 7/2014 Tango Management Consulting (Irving, TX)

SR CONSULTANT – LUCERNEX IMPLEMENTATIONS

I worked on the implementation team performing all of the same duties on each engagement.

Clients include:

Smash Burger

Reitman’s (Canadian Retail Company)

Bridgestone

O’Reilly Auto Parts

Daily meetings with CFO, Management of each department on Initial system configuration (requirements).

Integrations with several ERP systems including PeopleSoft, Oracle and JD Edwards.

Data conversion

Page design and configuration

Best practice consulting in the retail industry

To-Be Visio’s

Go-Live support for the users and then would meet with the CFO and Manager to discuss issues and prioritize the change/fixes.

4/2006 to 2/2013 24-Hour Fitness (Carlsbad, CA)

SR BUSINESS SYSTEMS ANALYST – PEOPLESOFT/ACCRUENT (IT DEPT)

Upgraded People Tools from v 8.49 to 8.52 in January 2013.

Recently completed PeopleSoft Financials 9.0 upgrade as Sr. BA on project in 2012.

Performed daily general system support for PeopleSoft modules v 8.8, including General Ledger, Accounts Payable, Purchasing, Projects, Commitment Control and Asset Management.

Integration specialist for all Accruent/PeopleSoft financial data.

Conducted environment testing and analysis of all patches, fixes, and modifications for PeopleSoft financials modules and Accruent Suite.

Lead Business Analyst on a 2 year implementation which was released to our 450 clubs in 3 phases: Real estate in 2007, Lease Administration in Mid-2008 and Facilities Management in 2009. (Accruent Application) v 7.2.1 as of 2012.

Lead BA for all Accruent environment and module changes for bug and Hot fixes.

Requirements gathering, Functional and Tech Documentation through implementation.

Evaluate best practice reporting structures and make recommendations to management.

Lead monthly security meetings with the director and Management of each department to discuss segregation of duties and access rights within the applications we support.

Served as mentor to our Jr BA’s designing training docs.

Troubleshooting system issues and communication with the Business partner (Accounting).

Development/testing of all internal and external interfaces to other applications which rely on Accruent/PeopleSoft for daily transactional information.

System and reporting documentation (manuals) As-Is and To-Be for Accruent and PeopleSoft.

11/2002 to 4/2006 24-Hour Fitness (Carlsbad, CA)

SR. ANALYST – FINANCIAL SYSTEMS

Maintain the financial system from an accounting perspective to keep the existing reporting environment current with monthly Organizational changes.

Troubleshoot system issues in conjunction with the accounting staff.

Provide support for patch and other system testing –worked as lead power user on the 8.8 upgrade.

Proposed innovative solutions to keep the systems efficient and functioning with the highest integrity.

Develop new GAAP financial reports as needed by accounting management and staff.

Reorganized existing reporting for organizational changes, while minimizing integrity issues.

Write all nVision layouts for monthly financial reporting.

Function as the central migration point for all accounting reports to the production environment.

Lead a monthly quality control meeting to discuss issues and propose solutions to improve the business process.

Provide in-depth training for all new PeopleSoft users.

Maintain up-to-date reference and training manuals for each staff member.

FINANCIAL SYSTEMS ANALYST - PEOPLESOFT

Performed upgrade and general system support for PeopleSoft modules (8.x), including General Ledger, Accounts Payable, Purchasing, Projects and Asset Management.

Troubleshooting system issues and performed meetings with Information Technology (IT) Department. All of the heads of the departments and a director were always present.

Create, review, and approve testing scripts from co-workers.

Conduct environment testing of all patches, fixes, and modifications.

Development and testing of interfaces.

Responsible for the training of End-Users.

System and reporting documentation (manuals).

Maintain department project log(s).

Document and notify users for all system updates.

8/1999 to 5/2002 Ballantyne, Inc. (BCSI)

INTERNAL CONSULTANT

Planned, managed and executed the implementation of PeopleSoft ERP Applications, which included project management, report design (nVision and Crystal), functional and technical specifications, trouble-shooting and debugging programs.

Lead functional consultant on internal PeopleSoft Financial implementation (BI, AR, AP, GL, T&L and PC).

Financial Report Design using Query, Crystal reports, nVision and Adobe.

Developed Security and Reporting Trees within PeopleSoft for PC, AR and GL.

Responsible for technical “Process Flow” documentation using Visio and MS Word from Time and Labor in HR to the GL in the Financials module.

Designed “How to” end-user manuals for Billing, Projects, AP and AR modules using MS PowerPoint and Word.

Responsible for the design and disbursement of all internal reporting to upper management, Project Job Costing, P&L statements, Inventory, COGS and Variance Analysis.

Coordinated user-end support, documentation, testing and training as required with CFO and Corporate Controller.

ACCOUNTING MANAGER

Responsible for all corporate accounting functions using MAS 90 - PeopleSoft v 7.52

Managing the G/L, period and year-end closings, commissions and rebate programs, accounting transactions (i.e. journal entries, account analysis, fixed assets/capital acquisitions and the monthly reporting process).

Monthly forecasting, budgeting and financial analysis.

Responsible for hiring, training and supervision of the Billing, A/P, A/R and Collections staff.

Coordination of year-end financial audits and other compliance reviews.

1/1997 to 8/1999 Richard A. Blithe, CPA, APC

STAFF ACCOUNTANT

Managed and materially participated in the preparation of Corporate, Estate and Individual income tax returns.

Corporate financial statement Compilations and Reviews.

Quarterly/Annual Payroll and Sales Tax Returns.

Budget variance analysis preparation and monthly management review write-ups.

Education:

1997 San Diego State University

B.S., Business Administration / Accounting

Training:

1999 to 2009 PeopleSoft/Oracle Financials ERP –

Query/Crystal/nVision Reporting, People Tools, Projects, General Ledger, AP (v 8.4) and Purchasing and commitment control.

2007 to 2009 Accruent Real Estate and Facilities Software –

Site Selection, Lease Administration, Project Management, FM Management and Asset Management

2013 Lucernex Technologies-

Retail Administrative Training

Contracts Administrative Training

2015 Microsoft Dynamics ERP-

Financial Fundamentals

Financial Close

Capabilities:

PeopleSoft v 8.0 - 9.2 modules: AP, PO, GL, AM and PC

PeopleSoft v 7.5 modules: AR, Billing, Projects, Tree Manager, General Ledger, HR (Time & Labor), AP and Expenses,

People Tools 7.5, 8.49 and upgraded to 8.52 in January 2013

People Tools upgrade to 8.53 in November 2014

Security, Query, Crystal Reports, TOAD – SQL Qry Analyzer

Accruent, MS Office Professional Suite (VISIO, Projects, Excel, Word, Outlook and PowerPoint)

Lucernex Technologies v 9.2.2

Microsoft Dynamics AX ERP

Contact this candidate