Ronald Schulz, CPA, CGMA

Experience

• 

  Rehabilitation Institute of Chicago

  Aug 1993 - Mar 1996

  Financial Analyst

  • Prepared annual operating budgets and responsible for the capital budget • Maintained the entire charge master file for the hospital and affiliated institution• Assisted Controller with feasibility studies and modeling of new ventures

• 

  Kemper Reinsurance Company

  Mar 1996 - Apr 1999

  Account Analyst

  • Setup and maintained insurance contracts on AS400 in accordance with underwriting terms• Analyzed monthly and quarterly accounts related to assigned workload• Interaction with underwriting department, brokers and clients worldwide in researching problems and resolving issues

• 

  Océ N.A.

  Apr 1999 - Oct 2009

  • Management of the cost accounting department which included hiring, objective setting, performance evaluations and other functions involving personnel management.• Performed all regular duties in general accounting management including the monthly and quarterly closing activities, inter-company activities and leading all aspects of the financial management and valuation of inventory• Prepare and analyze income statement, balance sheet schedules and other mgmt reports • Prepare/analyze trending reports and profitability analysis and investigate variances• Preparation of audit schedules for internal and external audits• Assist directors with annual budget development and budget compilation• Finance representative for company projects Show less • Performed all regular duties of a financial analyst at the corporate level including closing activities, trend and variance analysis, account reconciliations and schedule preparation. • Periodically assigned to projects and called upon to produce special reports for all levels of management• Performed all regular duties of a financial analyst in the service division including developing the service division budgets, tracking actual and latest estimates overall and by product line, preparation of the three-year strategic business plan and assist with the preparation of the service division’s operations package Show less

  • Supervisor Financial Controlling

    Feb 2004 - Oct 2009

  • Senior Financial Analyst

    Apr 1999 - Feb 2004
• 

  Océ N.A. a Canon Group Co.

  Oct 2009 - Dec 2012

  CPA / Supervisor Financial Controlling

  • Océ was acquired by Canon, Inc. and Internal Audit reorganized and needed a dedicated auditor to manage the Sarbanes-Oxley program. In this position duties included:• Redesign internal SOX program to incorporate the Canon R&C matrix with the Océ program (e.g. to comply with SOX Act of 2002 and the PCAOB).• Perform new annual Test of Design and monthly Testing of Effectiveness for as many as 15 key processes and organize the documentation for the SOX and financial statement external audit reliance.• I was promoted not only because of my credentials but for my experience and reputation as well. I have been involved with reorganization meetings and senior management discussions as Océ is combined and the audit department function becomes re-defined.• Involved with operation level and top-level external audit during the interim and year-end SOX and financial audits. This audit also requires interaction with senior Canon and Océ management.• Involved in performing various other Show less

• 

  Various Companies

  Jan 2013 - May 2015

  Various Contract work
• 

  Moffitt Cancer Center

  Feb 2018 - Oct 2019

  Financial Reporting Administrator

  Financial Reporting Administrator• Once the accountants complete the financial closing process responsible for completing as many as 10 monthly reports for use in the PowerPoint presentation to senior management as well as assembling full presentation and forwarding this to the Director of Accounting• Responsible for the monthly Account Variance Analysis and related explanations to the various levels of management for use in the monthly executive management meeting• In addition to monthly reporting, quarterly duties are to prepare the Balance Sheet Analysis with explanations as well as comparative Income Statement, Balance Sheet and Cash Flow Statement including notes and sub-schedules to the financial statements • External reporting duties each quarter and YE include sending financials to the SEC and other governmental entities• Other duties include working with the Sr. Business Analyst and Accounting Manager to automate processes and develop new reports upon request Show less

• 

  One10 Property Mgmt LLC

  Aug 2021 - Oct 2021

  Acounting Consultant

  Accounting Consultant with Taylor White LLC Consulting• One10 is a consulting partnership offering accounting and CFO services to other firms who outsource these functions. Their largest client owns apartment complexes and other commercial real estate and employs property managers to manage these properties. This client was doing a system conversion from Allvue to Yardi (two ERP systems geared toward real estate operations) • As the first consultant hired I led this system conversion. This entailed:O Downloading the 2020 & 2021 monthly data out of Allvue, reformatting this into .CSV files and uploading this into Yardi.O Once uploaded each month was reconciled using ExcelO Once the final month was reconciled the cash accounts were then reconciled within Yardi to the bank balances for each month collectively at September 2021 This process was performed over approximately 70 properties. • After completing the project the client now has a more reliable ERP system and an accounting basis at which to record its monthly operations and prepare financial reports for all its properties going forward Show less

• 

  Gallagher Flooring LLC

  Jan 2022 - Apr 2022

  Senior Consultant

  - Brought on after a system conversion to reconcile the new Chart of Accounts. The conversion did not go well and the project entailed downloading records from both systems then using Excel to match and create inventory level journal entries my material. - Part II involved creating audit schedules for external auditors in order to establish an unqualified audit opinion.- Part III was to create a full-scale national budget from a prior model that was out-of-date. Worked directly with the CFO, National Sales Manager and Corporate Controller. Built up this budget over 8+ versions presenting progress using Google Meets with CEO on final version.- Over the course of the engagement also managed approx. 8 other small/mid-size projects.- Heavy Excel using pivots, lookups,, SUMIF and other complex IF formulas, conditional formatting, etc Show less

• 

  Private company

  May 2022 - now

  Semi-Retired