Accounting.
Resume:
John E. Pawlowski, MBA, BSIE, PMP
**** ****** ***** *********, ** 60102
*******@***.***
EXECUTIVE SUMMARY
Successful hands-on Program Management of 6 - 8 projects concurrently ($1 million - $22 million each). Experienced in Agile and Waterfall methodologies.
Hands on design, installation, and implementation of over one hundred EPM financial consolidation, planning and analysis, executive/management/financial dashboard/reporting, accounting, and ERP systems, personally managing more than half of those projects.
Diverse expertise in most areas of accounting (as Accountant, Controller and Consultant) including general accounting – Manually maintained General Ledger and Sub-ledgers, converted to computer system
Designed and implemented new policies and procedures; revamped internal controls and audit programs, performed SOX compliance reviews and testing for financial, retail, manufacturing, service, healthcare, pharmaceutical and not for profit entities.
Degreed and experienced in Industrial Engineering (Operations Management), including business process review, analysis, improvement, and documentation.
As Controller of a West African Joint Venture of a Fortune 200 telecommunications equipment manufacturer, converted a manual accounting system to a computerized system. Resident of Nigeria.
Trained and experienced in Oracle, Sybase, MS SQL Server, and Essbase DBs, MS Windows Client/Server, NT, UNIX, AIX, HPUX OS, Baan, Cognos Impromptu, Powerplay, TM1, Hyperion (Enterprise, Essbase, FDM, HFM, Brio, Pillar, Planning, FCCS, PBCS), Planful (Host Analytics), Adaptive Insights, MS Dynamics, Great Plains, QuickBooks, OneStream, Oracle Cloud Financials, SAP ECC/S4 Hana, BPC (formerly OutlookSoft), ServiceNow, Power BI and SharePoint.
EDUCATION AND PROFESSIONAL AFFILIATIONS
BS – Operations Management/Industrial Engineering (Minor - International Business) – DePaul University, Chicago, IL
MBA – Concentration in Accountancy - DePaul University, Chicago, IL
Certified Tower and General Project Installation Engineer - Alan Dick and Company, Cheltenham, England
Member of the Project Management Institute (PMI)
Certified in Oracle Financials, Microsoft Windows Server, Microsoft SQL Server, Hyperion, SAP BPC, Host Analytics (Planful), Adaptive Insights, Vena Solutions
Certificate in Designing/Implementing OLAP Solutions with MS SQL Server - IMG University
EMPLOYMENT HISTORY
CTech International, LLC– Tinley Park, IL Founder and Managing Director Dec 2001 – Present
Ultimate administrative, financial, and operational responsibility for a startup consulting firm, including business and relationship building, staffing, strategy, and direction, etc.
Hands on project implementation and management of Hyperion Enterprise and HFM consolidation systems, Application Link, Essbase, FDM, Pillar and Planning budgeting, forecasting and analysis systems, and desktop/web based financial dashboard and reporting systems.
Client Engagements
Mead Johnson Nutrition, Evansville, IN (contracted through IBM) - 6 months
Hands on Project Manager SAP BPC implementation of Finance and Allocation applications with integration with all SAP Modules.
Timberland, Statham, NH 1 Year
Interim Hyperion System Administrator - Upgrade and support of Hyperion Enterprise and Planning systems, including interfaces, logic and report development and maintenance. 13 applications in 13 locations around the world.
Fidelity Bank, Wichita, KS 3 Months
Senior Consultant - Hyperion System Implementation - Application implementation, reporting and system administration for Hyperion Essbase Planning System.
U.S. AgBank, Wichita, KS 3 Months
Senior Consultant - Hyperion System Implementation - Application implementation, reporting and system administration for Hyperion Enterprise Consolidation System.
Johnson Outdoors, Racine, WI 6 months
Interim Hyperion System Administrator - Application upgrade, data conversion and reporting for a Hyperion Enterprise Consolidation System.
GDX Automotive, Farmington Hills, MI 6 months
Interim Hyperion System Administrator - Application upgrade/conversion, reporting and system administration for Hyperion Enterprise Consolidation System.
GE Capital ITS, Newport, KY 6 months
Interim Hyperion System Administrator - Application upgrade/conversion, reporting and system administration for Hyperion Enterprise Consolidation System.
Kemin, Des Moines, IA 3 Months
Senior Consultant - Hyperion System Implementation - Application implementation, reporting and system administration for Hyperion Enterprise Consolidation System.
Mattson Technologies, Fremont, CA 6 months
Senior Consultant - Hyperion System Implementation - Application implementation, reporting and system administration for Hyperion Enterprise Consolidation System.
Cignet, Troy, MI, 6 months
Senior Consultant - Hyperion System Implementation - Windows Server and application installation, implementation, reporting and system administration for Hyperion Enterprise Consolidation System.
NCCI, Boca Raton, FL 3 months
Team member - Installed and implemented OutlookSoft 4.1 (Everest), which later became SAP BPC.
Katalyst Group - Chicago, IL Contract Consultant Sep 2023 – Feb 2024
Client Engagements
BlueScope North America, Kansas City, MO
Hands on Project Manager – HFM to OneStream Migration - Assisted in getting the project started including:
Requirements gathering
As-is process documentation
RFP creation/management
Implementation partner selection
Messina Group - Chicago, IL Contract Consultant Jun 2022 – Jun 2023
Client Engagements
Mars Wrigley, Hackettstown, NJ 2022 - 2023 - Interim Hyperion System Administrator/Hands on Project Manager–HFM, FDM.
Supported Global Accounting in Data Integration, Consolidation, Planning, Reporting and Close Processes.
Managed Oracle Hyperion Financial Management and FDMEE (ETL) implementation.
Led reconciliation project for the addition of a new entity.
Robert Half/Protiviti Chicago, IL Contract Consultant Sep 2021 – Mar 2022
Client Engagements
Save A Lot, St. Ann, MO
Interim Hyperion System Administrator - HFM, Planning and FDM. Supported Corporate and Global Accounting in the Data Integration, Consolidation, Planning, Reporting and Close Processes.
Fairbanks Morse, Beloit, WI 3 Months
Interim Hyperion System Administrator - HFM, Planning and FDM. Supported Corporate and Global Accounting in the Data Integration, Consolidation, Planning, Reporting and Close Processes.
Technip FMC, Houston, TX 3 Months
Hands on Project Manager – HFM to OneStream Migration Contract Consultant - Hands on Project Manager
Oracle Cloud S4 HANA support (ServiceNow Helpdesk and System Administration/Maintenance)
OneStream implementation, report writing and support.
RGP - Oakbrook Terrace, IL Contract Consultant Jul 2019 – Jun 2021
Client Engagements
Basic Energy Systems, Fort Worth, TX 6 months
Hands on Project Manager – Completed previously attempted Host Analytics implementation.
Assisted in getting the project back on track, as well as documenting the client’s requirements of the new system and identifying reports necessary for day 1 of Go Live.
Tenneco, Lake Forest, IL 3 months
Hands on Project Manager – HFM to OneStream Migration - Assisted in getting the project back on track, as well as documenting the client’s requirements of the new system and identifying reports necessary for day 1 of Go Live. Even though the project had begun a year before my, requirements and reports had not been previously gathered, nor had an agreed upon scope or list of deliverables been determined.
Delivered:
Documentation of the current and future state of the consolidation system, with intermediate steps
A list of client requirements
A list of deliverables expected
Scope document
Sample Statement of Work
Review of other consulting company’s estimate and SOW for Phase 2, including recommendations
SolomonEdwards – Wayne, PA Director of Business Intelligence Dec 2012 – Jun 2019
Client Engagements
American Thoracic Society, New York, NY 2019 - 1 Year
Interim CFO and Financial System Administrator – Microsoft Dynamics, Host Analytics and SAP. Supported HQ and Chapter Accounting in the Close Process and Management/External Reporting, Dashboarding, External Audit, Data Integration, Consolidation, and Budgeting/Planning.
FMC, Philadelphia, PA 3 months
Lead - SAP BPC implementation of Finance and Allocation applications with integration of all SAP Modules
Unisys, Blue Bell, PA 2017 – 2018 - 1 Years
Hyperion System Administrator - HFM, Planning and FDM. Supported Corporate and Global Accounting in the Data Integration, Consolidation, Planning, Reporting and Close Processes. Modified SaaS products for divestiture and downsizing. Migrated HFM and Planning to Oracle Hyperion FCCS and BPCS. Created reports and dashboards using Power BI.
Fay Servicing, Chicago, IL 6 months
Lead – Host Analytics post implementation support.
Marianjoy Rehabilitation, Wheaton, IL
Lead - Business and Data Process documentation and improvement project.
Kish Healthcare, DeKalb and Sycamore, IL
Lead - Business and Data Process documentation and improvement project.
Evicore Healthcare, Franklin, TN and Bluffton, SC
Lead – Business and Data Process documentation and improvement project.
AbbVie, Abbott Park, IL 3 months
Lead – Business Intelligence System Selection project.
National Grid, Syracuse and Garden City, NY 2 Years total
Lead – Interim SAP ECC System Administrator
Lead – SAP Payroll reconciliation and correction project.
Senior Consultant – SAP Account Reconciliation and Financial Report restatement.
Five Point Partners (formerly Turnpoint Solutions) - Atlanta, GA Director Dec 2010 – Nov 2012
Client Engagements
Cliffs Natural Resources, Cleveland, OH 2012 - 1 Year
Business Analyst – Responsible for Process Analysis and Design, governance, product training and documentation during a global Chart of Accounts redesign, Hyperion Planning and HFM upgrade, Hyperion FDM upgrade and report migration project.
VIA Metropolitan Transit, San Antonio, TX
Hands on Project Manager – Ellipse ERP implementation.
The Glenture Group – Northbrook, IL Senior Manager – SAP BPC Practice Nov 2008 – Nov 2010
Client Engagements
Fortune Brands, Deerfield, IL 6 months
Supported SAP BPC applications and data integrations.
The Pampered Chef, Addison, IL 9 months
SAP BPC implementation of Finance, CapEx and HR applications. Managed project, developed and supported Finance, Budgeting, Planning, Forecasting, HR and Capital Expenditure applications and data integration with Oracle databases. Trained Administrators and Users
Jim Beam Global, Deerfield, IL 3 months
SAP BPC Upgrade and report conversion of Consolidation, OpEx and FPA applications.
Heico Companies, Downers Grove, IL 6 months
Developed and supported SAP BPC implementation of Finance, CapEx and HR applications including data integration with various source databases.
Zions Bancorporation, Salt Lake City, UT 6 months
SAP BPC implementation of Finance, Budgeting, Forecasting and Allocation applications and data integration with Oracle databases and Business Objects (BOBJ).
Freeport McMoRan formerly Phelps Dodge – Phoenix, AZ Apr 2006 – Nov 2008
Lead Architect – and System Administrator - Key Financial Systems
Responsible for all key financial systems for a leading global mining company.
Hands on project implementation, management and system administration with Hyperion Enterprise consolidation system, Application Link, Hyperion Essbase, Hyperion Planning budgeting, forecasting and analysis systems, and desktop/web based financial dashboard and reporting systems.
System design, implementation, integration and upgrade of Hyperion Enterprise and Hyperion Planning, HAL (interface tool), Essbase, CorpTax, FAMS (Fixed Asset Management) and Ellipse ERP systems. Converted Ellipse ERP system to SAP.
Vision BIA, L.L.C. – Oakbrook Terrace, IL Vice President – Professional Services Feb 1999 – Nov 2001
Ultimate administrative, financial, and operational responsibility for a consulting firm, including business and relationship building, staffing, strategy, and direction, etc.
Tripled Vision’s staff, service offerings and revenue within 1 year.
The BaaN Company – Oakbrook Terrace, IL Senior Consulting Manager May 1997 – Feb 1999
Hands on Project Manager - All Baan Beta ERP implementations
Client Engagements
Standard Register, Dayton, OH
Zebra Technologies, Lincolnshire, IL
Hyperion Solutions – Stamford, CT Director - Advanced Applications Group Apr 1993 - May 1997
Hand on design, sale and management responsibility of consulting projects involving prototypes, project management, implementation, and user training.
Products supported include administrative, distribution, manufacturing and financial software and services for domestic and international clients.
Responsible for developing, marketing, and performing Management Advisory Services (Feasibility Studies, Internal Control.
Reviews, Policy and Procedure Design, Staff Selection and Project Management) outside the software environment.
Hands on Project Manager - All Hyperion ERP implementations (Alpha, Beta and General Release versions)
Client Engagements
Mattel/Fisher Price, El Segundo, CA
Levy Restaurants, Chicago, IL
Michael Reese Health Plan, Chicago, IL
Chicago HMO, Chicago, IL
AutoSource, Indianapolis, IN
Signature Group, Schaumburg, IL
US Gypsum, Chicago, IL
Contact this candidate