Lightship Consulting - Clive Harlow - Assignments

Client, dates	Jarvis plc (Stevenage and York), Dec 00 to May 02
Role	Lead Consultant in developing the Cost Value Reconciliation system, which was built within a very tight deadline. The system allows Quantity Surveyors to update their projected Costs and Revenues in Web data forms. The information is consolidated centrally and undergoes a hierarchical approval and adjustment process. Web reports allow detailed analysis of results and can be customised by the users.
Key skills	Project Management, Analysis and design, client relations, team leading, express development
Software	OES 631, OFA 631 and 632, SQL
Hardware, OS	HP Unix

Client, dates	Direct Line Group Services (Croydon), Aug to Nov 00
Role	Change of Financial Year. Used formulas to provide Management accounts against the ‘old’, ‘new’, and ‘interim’ years.
	Allocation Model.
Key skills	Oracle Express, OFA design and development.
Software	OFA 6.1
Hardware, OS	NT Server 4

Client, dates	Ntl (Hook), Jun 00 to Aug 00
Role	Developing a new Budgeting system to replace many spreadsheet based systems.
Key skills	Client relations, OFA design and development, team leading.
Software	OFA 6.3.0.1.0
Hardware, OS

Client, dates	Lloyds TSB (City), Feb 00 to May 00
Role	Lead consultant in developing the OFA model for the General Efficiency Program (GEP). This project (in conjunction with PriceWaterhouseCoopers) collected and consolidated Project Business Cases, and allowed forecast revisions and monitoring against actuals.
Key skills	Project Management, team leading, OFA design and development.
Software	OFA 6.2.1
Hardware, OS	NT Server 4

Client, dates	GE Consumer Finance (Leeds), Dec 99 to Feb 00
Role	Various short-term assignments, including complex reporting.
Key skills	OFA design and reporting
Software	OFA 6.2.1
Hardware, OS	Unix

Client, dates	Allders (Croydon), Sep 99 to Dec 99
Role	Actuals via GL link, Budgeting and Forecasting using custom models.
Key skills	OFA design, complex reporting.
Software	OFA 6.2.1
Hardware, OS	[SYST=215 UNIX Type: L8 Version: DEC Alpha, Digital UNIX V4.0 (Rev. 878)]

Client, dates	GE Capital European Equipment Finance (Hounslow), May 99 to Aug 99
Role	Transfer and re-design/-build of OFA 6.0.1.1, OES 6.1.0.1.3 on Windows NT4 to OFA 6.2
Key skills	OFA design, data conversion
Software	OFA 6.0.1.1, OES 6.1.0.1.3 to OFA 6.2
Hardware, OS	NT Server 4

Client, dates	GE Capital Insurance Holdings (Chiswick), Nov 98 to May 99
Role	Lead consultant for a new OFA implementation for Budgeting, Planning and Management Reporting. Multiple currencies were supported for data entry and reporting.
Key skills	OFA implementation, design and development.
Software	OFA 6.2, OES 6.2 (build 60233), GL link.
Hardware, OS	Sequent PTX Dynix, Sun Solaris SunOS 5.5.1

Client, dates	Direct Line Insurance (Croydon), Apr 99
Role	Initial implementation (1999).
Key skills	OFA installation, design and development.
Software	OFA 6.1
Hardware, OS	NT server 4

Client, dates	Freemans (London), Jun 98 to Oct 98
Role	Implementation of OFA for Actuals reporting and Budgeting.
Key skills	OFA installation, design, development.
Software	OFA with GL Link, incl Budget upload. Load budgets from Lotus 123. Unix. OFA 6.0.1.1
Hardware, OS	Sun OS 5.6

Client, dates	Alliance and Leicester (Liverpool), Jun 98 to Aug 98
Role	Pure consultancy assignment, mainly to assist with complex reports on data cubes from GL.
Key skills
Software	OFA 4.8.1
Hardware, OS	Sequent Dynix 4.4

Client, dates	Sainsburys, (Blackfriars), Apr 98 to Jun 98
Role	Lead Consultant, developing a Staff Costs and Overheads budgeting system.
Key skills	Express multi-dimensional reporting.
Software	OFA 4.8
Hardware, OS	Unix

Client, dates	H P Bulmer (Hereford), Aug 97 to Jan 98
Role	Additional Customisations on Budgeting and Planning system.
Key skills	OFA design and build
Software	OFA 4.8
Hardware, OS

Client, dates	Unilever, (Richmond), May 97 to Aug 97
Role	Project Manager in developing a new release of the “Abacus” system, a customisation of OFA for roll-out across all European countries.
Key skills	Project Management
Software	OFA 4.8
Hardware, OS	NT4

Client, dates	Aggregate Industries (Leics), Jan 97 to May 97
Role	LAN implementation of OFA 4.8. Management accounts from GL. AW and BW users across WAN. Budgets
Key skills
Software	OFA 4.8.1.1
Hardware, OS

Client, dates	Post Office Counters Ltd, (Blackfriars), Sep 96 to Jan 97
Role	Testing and documenting an Activity Based Costing system built around OFA.
Key skills	Documentation, testing.
Software	OFA 4.6
Hardware, OS

Training other Oracle Consultants
OFA	Brussels, Sep 97 (2 weeks)	Co-Tutor
Express	Budapest, Nov 97 (3 weeks)	Co-Tutor
OFA	Reading, Mar 98 (2 weeks)	Lead Tutor

Assignments under 2 weeks
Cap Gemini	3 days investigation of OFA as possible option in Time Card entry and aggregation. Negative outcome
Coopers & Lybrand	3 days assistance with pcExpress Central Budgeting model.
Reed Elsevier	2 days assistance with installation of OFA 6.3.2 and OES 6.3.1 on Windows 2000
Friskies	2 weeks, developing Y2K test plan for OFA.
ICL	1-day consultancy

[Home] [Services] [OFA] [Express] [Profile] [Career] [Assignments] [Education] [Contact]