Black & McDonald  – Success Story

Black & McDonald, a privately owned multi-trade company with revenues of approximately $2 billion, operates across Canada and the US. The company engages in various lines of business, including construction, mechanical and electrical services, utilities work, facilities management, and HVAC system servicing.

FXI  – Success Story

FXI is a leading producer of comfort innovation for the Home, Healthcare, Electronics, Industrial, Personal Care and Transportation markets. Their products include finished goods, sub-assemblies, services and raw materials for OEMs, fabricators and retailers

REIT – Success Story

 Leading Commercial and Residential REIT company in Canada.

Designed and Developed Hyperion planning application to achieve the following:
• Ability to multi-year forecast and budget at the same time
• Improved scenario analysis capability
• Reduced manual activities performed by FP&A team, reducing the budget cycles
• Stream lined the business rules, and eliminated use of attributes
• Planning application designed P&L, and workforce information
• Instituted Change management for stability and reliability
• Ownership management functionality
• Same Store Analysis
• Data movement automations from and to ERP and HFM

Plumbing, Waterworks, Industrial and HVAC Products Supplier – Success Story

Canada’s largest integrated distributors of products for the construction industry. Company offers products in the distinct categories of plumbing, waterworks, industrial and HVAC. They strive to satisfy the needs of their customers with a focused product assortment, transported and sold through an extensive network of Profit Centres, distribution warehouses and showrooms across Canada.

Designed and Developed Oracle EPM Cloud – FCCS to achieve the following:

• Implemented and setup FCCS application for hundreds (500+) of entities.
• Loaded data from multiple data sources.
• Migrated data from Oracle Hyperion Legacy systems to new FCCS system on cloud.
• Automated daily load processes.
• Created monthly profitability reports from FCCS.
• Created Financial reports and data grids to load data.
• Created Financial packages in Excel using Smart View and Excel VBA.
• Created email packages/reports functionality using excel VBA.
• Extract Data to upload to other systems.
• Multi GAAP and Multi currency application.
• SSO (Single Sign on) setup.

Our client is able to produce Financial Statements within a few days after month end close using Oracle EPM Cloud – FCCS ( Financial Close and Consolidations).

Producer of Comfort innovation for the Home, Healthcare, Electronics, Industrial, Personal Care and Transportation markets – Success Story

Producer of Comfort innovation for the Home, Healthcare, Electronics, Industrial, Personal Care and Transportation markets.

Hyperion Upgrade:  Hyperion 11.1.2.4 to Hyperion 11.2.5

• Setup and installed Hyperion 11.2.5 on 2 environments and 4 servers configuration in each environment.
• Installed, Migrated and Tested following Hyperion components:
– HFM and Planning, Essbase applications.
– FR Reports.
–  FDMEE Processes.
– Setup New DRM application.
• Converted EPMA metadata to DRM. DRM is the metadata management tool going forward.
• Prepared Installations and configurations documents for all environments.
• Prepared DRM and updated existing user documents.
• Setup Automated daily LCM back up processes.
• Setup automated and on demand system stop and start scripts.
• Setup and enabled firewall inbound and outbound rules.

Metals and Industrial Products Manufacturer, Processor and Distributor – Success Story

Canada’s largest and leading metals and industrial products manufacturer, processor and distributor of high quality products company.

Hyperion Upgrade:  Hyperion 11.1.2.4 to Hyperion 11.2.5

• Setup and installed Hyperion 11.2.5 on 2 environments and 4 servers configuration in each environment.
• Installed, Migrated and Tested following Hyperion components:
– HFM and Planning applications.
– 500+ FR Reports.
– 30+ FDMEE Processes.
– Setup New DRM application.
• Converted EPMA metadata to DRM. DRM is the metadata management tool going forward.
• Prepared Installations and configurations documents for all environments.
• Prepared DRM and updated existing user documents.
• Setup Automated daily LCM back up processes.
• Setup automated and on demand system stop and start scripts.
• Setup and enabled firewall inbound and outbound rules.

Chemical, Plastic Resin & Synthetic Fiber Manufacturing Industry – Success Story

Leading Plastic Resin & Synthetic Fiber Manufacturing Industry. Custom Manufacturing – Distillation and Reaction Technologies, Their custom manufacturing processes include: Reactive Distillation, Hydrolysis, Hydrogenation, EO/ PO Alkoxylation, and more.

Implemented Oracle EPM Cloud -PBCS (Planning and Budgeting Cloud) for profitability and cost reporting:

• Loaded data from 4 ERP Systems with different COA.
• Setup Cubes for Budgeting, Forecasting.
• Setup Sales cube for profitability and Cost reporting cube.
• Multi Currency Financial Reporting.
• Setup Drivers based allocations.
• SmartView / Board Packages / Excel VBA Programming.
• Customized SmartView and PBCS Training.
• Leveraged SQL Server for data and metadata mapping / Daily data loads.
• Provided Managed Support Services

After  Oracle EPM Cloud PBCS implementation, Client was able to produce consolidated reporting from distributed ERP systems on daily basis with accurate and reliable results.

This reporting was manually done on quarterly basis before but results were not consistent and it was very time consuming work.

Orica – Success Story

Orica (ASX: ORI), one of the largest global providers of commercial explosives and blasting systems to the mining and infrastructure markets, was looking for consolidating information from three separate ERP platforms into a single “source of truth” for all reporting and analysis.