Skip to content

Frank Russell Consulting

Project Management

  • PMO
  • ERP
    • Financials
    • HRIS/Payroll
    • TIme & Labour/Resource Planning
    • CRM
    • Other
  • Process Improvement
  • Business Intelligence
  • Development
  • IT Infrastructure
  • Industry
    • Retail
    • Apparel
    • Interactive Entertainment
    • Manufacturing
    • Public Sector
    • Travel & Tourism
    • Forestry & Wood Products
    • Health Care
    • Publishing
    • Automotive
  • Contact

Category: Financials

Program: Financial Reporting

April 18, 2018

Client:

Developer and publisher of video games

Employees:

8,000

Program objective:

  • Implement the systems and processes to support more efficient financial forecasting and reporting.
  • Projects
    • Forecasting System (Clarity, Hyperion Essbase)
    • Financial Data Warehouse and ODS (Oracle)
    • Financial Reporting (Cognos)

The program goals were achieved through:

  • Securing commitment from senior executives to standardize the chart of accounts.
  • Setting common definitions for key terms critical for project accounting.
  • Successful management of internationally dispersed team including external developers.
  • Close involvement of Finance stakeholders.

Key accomplishments:

  • Provided the systems and means to produce the company’s first automated consolidated financial reports, aggregating data from 13 independent financial systems (and charts of accounts). Quarterly close was reduced by 4 days.
  • Initiated the replacement of 13 different charts of accounts with a single corporate standard.
  • Established the basis for effective project accounting across all studios
Business Intelligence, Development, ERP, Financials, Interactive Entertainment Agile, Cognos, Data Warehouse, Financials, Oracle EBS

Program: Scaling to $1 Billion

March 18, 2018

Client:

Developer and publisher of video games

Employees:

8,000

  • Put in place the systems and processes to support the studio’s growth to 1,000 employees and revenue of $1Billion.
  • Projects
    • Accounting (Oracle Financials)
    • Budgeting (Oracle Financial Analyzer)
    • Human Resources (PeopleSoft)
    • Payroll (ADP)
    • Asset Management (Wisetrack)

The program goals were achieved through:

  • Close working relationship with stakeholders including senior executives.
  • Establishing common language for terms across departments.
  • Integrating all systems to eliminate redundancy and ensure data integrity.
  • Re-engineering processes to optimize efficiencies across departments.
  • Successful management of cross-functional team and external consultants.

Key accomplishments:

  • Efficiency gains from streamlined processes and an integrated application architecture succeeded in reducing the monthly close cycle by 2 days.
  • Re-engineered on-boarding process for new hires resulting in greatly improved data integrity through elimination of redundant data entry across several departments.
  • Managers had on-demand, up-to-date, reliable view of key performance measures, including headcount and budget performance, for the first time.
  • Studio consolidation and relocation of three offices to a new building resulted in no reported losses of key assets.
ERP, Financials, HRIS/Payroll, Interactive Entertainment, Other, Process Improvement ADP, Financials, HRIS, Oracle EBS, Payroll, PeopleSoft

Financial and Maintenance Systems Selection

March 18, 2018

Client:

Operator of vacation packages and tours

Employees:

700

Managed and mentored Project Managers through the evaluation and selection of a replacement financial system and a new maintenance system.  Developed the implementation plans and budgets.

ERP, Financials, IT Management, Other, Travel & Tourism Financials, Selection/RFP

Oracle iExpense

October 7, 2017

Client:

International athletic wear manufacturer & retailer

Employees:

12,000

Led the rollout of Oracle EBS iExpenses to the company’s international operations including Australia, New Zealand and the UK.  The purpose of the project was to make the processing of expenses in international locations more efficient by moving from manual and Excel based processes to iExpense.

Apparel, ERP, Financials, Retail Financials, Oracle EBS

Turnkey ERP Systems for Automobile Dealerships (Multiple)

April 29, 2016

Implemented over 40  turnkey & custom systems at French and English automobile dealers across Canada representing all the major automobile manufacturers.

  • Service Merchandising
  • Parts & Inventory
  • New & Used Sales:
    • Leasing
    • Sales Management
    • Finance & Insurance
    • Vehicle Inventory
    • Showroom Control
  • Back Office:
    • Accounting  – GL, Accounts Receivable, Accounts Payable, Financial Reporting
    • Payroll
  • Custom:
    • Auction
Automotive, Financials, HRIS/Payroll, Other, Retail ADP, Financials, Payroll

Tags

ADP (3) Agile (6) Ceridian (2) Cognos (3) Data Warehouse (5) Dayforce (1) Digital Asset Management (1) Financials (5) GDPR (1) HRIS (6) Kronos (1) Marketo (1) MicroStrategy (2) Modatech (1) Oracle EBS (3) Payroll (4) PeopleSoft (1) PMO (4) Privacy (1) Project Server (1) Real Estate (1) SaaS (6) Salesforce (1) Selection/RFP (8) SharePoint (3) SuccessFactors (2) Time & Labour (4) Ultimate (1) Workday (1)

Idealist by NewMediaThemes