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: Business Intelligence

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

Building Business Intelligence Capability

April 11, 2018

Client:

Provincial authority overseeing installation and operation of technical systems

Employees:

400

Developed a business intelligence capability through the introduction of formal data governance, the creation of a cross organizational business intelligence team and the development of a data warehouse and reporting infrastructure.  Directed the building of operational dashboard for iPad and client history reports for clients.

Business Intelligence, Public Sector Agile, Data Warehouse, MicroStrategy, Selection/RFP

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

Business Intelligence Charter

March 18, 2018

Client:

Provincial health authority

Employees:

22,000

Developed Project Charter and made recommendations for a quality performance management system encompassing performance scorecards developed using MicroStrategy on the front end, and a SQL Server data warehouse on the back end.

Business Intelligence, Health Care, Public Sector Data Warehouse, MicroStrategy

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