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

Tag: Cognos

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

Marketing Data Warehouse & Analytics

March 18, 2018

Client:

Developer and publisher of video games

Employees:

8,000

Built a data warehouse and reporting environment for external market data that enabled Marketing to produce reports and analysis in minutes or hours instead of days or weeks.

Business Intelligence, Development, Interactive Entertainment Agile, Cognos, Data Warehouse

Human Resources Data Warehouse

March 18, 2018

Client:

Developer and publisher of video games

Employees:

8,000

Led the design and build of a data warehouse and reporting environment to consolidate data from multiple PeopleSoft instances and other systems.  Provided self-serve manager and employee reporting.  Produced the company’s first global view of human resources data.

Business Intelligence, Development, Interactive Entertainment Agile, Cognos, Data Warehouse, HRIS

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