SABMiller PLC November 2004 – May 2005
Hyperion Enterprise v6.3 Consultant
Updated application for IFRS requirements. Identified and documented opportunities for improvement of systems utilisation.
Advised and built additional COA & formulas to capture IFRS adjs into 2006 Budget category excercise.
SGS GMBH, Geneva, Switzerland October 2004
Hyperion HFM v3.5/Enterprise v6.2 Consultant
Mapped and integrated complex data migration for 4 years historical data from Enterprise to HFM using HAL.
GEO LOGISTICS July 2004 - August 2004
Hyperion Enterprise v6.3 Consultant
Build of Hyperion and Excel budget reports to strict deadlines.
UCB GROUP S.A., Brussels, Belgium January 2004 - June 2004
Hyperion HFM v3.4 Consultant
HFM built project that replaced Comshare MPC and provided post installation support through in-service training.
Contributed to the development of HFM and upgraded system from 3.04 to 3.4
Formulated updates of Metadata, Rules & Security and built dynamic WDEFs utilizing linked forms & AddMembers.
Created reports using Hyperion Reports 2.6
Trained and mentored 25+ representatives in excel HFM retrieve.
GE HEALTHCARE PLC April 2004 - May 2004
HAL / Hyperion Enterprise v5.5 Consultant
Responsible for design and build of individual HAL projects. Set up mapping for each project. Designed, developed and implemented effective HAL routines to ensure easy and trouble-free maintenance by the client.
GATE GOURMET GMBH, Zurich, Switzerland August 2003 - December 2003
IAS Accountant / FDC v5.4 Consultant
Develop proposals and on-site presentations for global implementation of new consolidation system that would result in dramatic improvement in company’s international financial system. Established division’s goals, objectives and priorities with direct involment in various projects and monitored project progress.
Converted current FDC application into Hyperion Enterprise.
Resolved LATIN investment journal issues.
AMERSHAM PLC March 2003 - April 2003
HAL / Hyperion Enterprise v5.5 Consultant
Build and manage implementation of HAL projects to load data into Hyperion Enterprise over Citrix for each of 10 Divisions.
Successfuly solved client’s ongoing problem getting HAL to run on Citrix
Created and introduced mapping for each project. Each project had between 2,000-15,000 lines.
Built new reports and drafted specification on how to respec division’s Hyperion Enterprise system.
SYNGENTA (ex Zeneca Agrochemicals) November 2000 - November 2002
Hyperion Enterprise v5.1 Project Manager
Design, produce and implement the build of the IAS accounting and Hyperion Reporting Systems project. Provided ongoing systems maintenance and support for domestic and international offices. Provided on-site and post installation support during rollouts, upgrades and optimisation projects.
Production, implementation and deployment of a separate new synergy application on a Citrix server.
Built complex consolidation logic utilizing the percentage ownership in the organization hierarchy.
Integrated strategic improvements in the systems e.g. implemented the intercompany module, input schedules, group reports, rollovers, Autopilot routines, Data Extend.
Trained, coached and managed staff and provided end-user support.
BRISTOL-MYERS SQUIBB CO – CLAIROL April 2000 - October 2000
Hyperion Pillar Consultant
Design and implement 4 Hyperion Pillar applications to strict deadlines. These applications had over 1600 products, to 46 customers in 28 countries.
Successfully loaded data from SAP & AS400 using HAL and the end results were then loaded into Hyperion Essbase to be viewed using Hyperion OLAP.
BRITISH AMERICAN TOBACCO PLC December 1998 - January 2000
Hyperion Enterprise v4.3 Consultant
Spearheaded a project team to develop and implement Hyperion Enterprise 4.3 SE Management Application. Assisted on complete system re-build following merger between BAT and Rothmans.
Built Hyperion Enterprise v4.3 application.
Designed reports, migrated data, retrieve & HPLNK spreadsheets.
Trained staff and provided post implementation support of Global Hyperion Application to over 80 countries.
SIR ROBERT MCALPINE PLC January 1997 - January 1999
Group Financial Accountant
Group Consolidations of 6 Divisions - monthly accounts and annual budgets.
KVAERNER PLC January 1995 - January 1997
Group Financial Accountant
Designed and constructed the 1995 statutory Hyperion application. Designed and constructed the interim 1995 account formats using Excel. Loaded them into Hyperion and produced the interim results.
JOHN BROWN PLC May 1992 - January 1995
Group Management Accountant
Active member in the implementation of Hyperion Enterprise and conversion from Micro Control.
TRY GROUP PLC April 1984 - April 1992
The production and consolidation of the monthly management accounts and financial presentations for the board.
SENIOR INDEPENDENT HYPERION CONSULTANT
15 Years Diverse International Financial Project Experience
Well-Versed In Global Business Market Specialising in Hyperion
Certified Accountant, FCCA
PROFILE
BI Systems-focused Senior Financial Consultant with a career demonstrating visionary leadership, expertise and outstanding performance in all areas of GAAP/IFRS and financial management accounting of nationally and internationally based operations. Demonstrated track record of consistently combining leadership with sound business practices to ensure bottom-line revenues and better business for total client satisfaction. Valuable combination of financial acumen integrated with extensive Hyperion skills. Reputation as a self-directed professional with excellent problem solving, communication, analytical and management skills. Expertise within:
Hyperion Enterprise Hyperion Reports & Reporting
Hyperion Financial Management (HFM) HAL, Hyperion Ledgerlink & Hyperion Autopilot
Hyperion Essbase Hyperion Retrieve & Pivot
Hyperion Planning Hyperion Data Extend & Hyperion Analyst
Hyperion Pillar Comshare FDC
CLIENTS
“Colin understands Hyperion backwards. He has very strong financial and accounting skills and is extremely committed and dedicated. Dealt with all questions thrown at him. He is a good team member and works well under pressure.
Did not want to let him go.” PR, Syngenta
“The system you helped us develop went live in full, delivering all we had specified and was a raging success. In fact the Business intelligence solution was a finalist in the IM2001 industry awards! They said it couldn't be done, but we proved them wrong. Thank you so much for your professional help.” RD, Bristol-Myers Squibb Co
Amersham PLC GE Healthcare PLC SGS GMBH
Bristol-Myers Squibb Co Geo Logistics Sir Robert McAlpine PLC
British American Tobacco PLC John Brown PLC Syngenta
Financial Times Ltd Kvaerner PLC Try Group PLC
Gate Gourmet GMBH SABMiller PLC UCB Group S.A.
OTHER COMPUTING & IT SKILLS
VBA, Access, MS Office, Excel & Lotus 123, Micro Control, SunSystems, AS400, Sage, Pegasus, Citrix,
Dreamweaver 4 & HTML