Graham Hamilton Email and Phone Number

Client - Skanska PlcDesign and implement a database solution to manage timesheets and budgets for the design phase of the IPC HS2 Contract

Client: John Lewis plcOnline Customer OrderingTo build and develop multi-context, aggregate-aware universes over both DB2 datawarehouse and Oracle databases to service both developer produced standard reports and Ad Hoc business user reports.To develop a suite of scheduled and ad hoc prompted reports from these universes to provide comprehensive management and operational control

Weekly Trading Pack DevelopmentSAP Business Objects v4.2- Web Intelligence- Universe Designer- Information Development Tool- Design StudioAnalysis and Reporting Support- RFID Stock Management- Space Management- Online Customer Ordering- Returns Analysis- Fit for the Future Business Intelligence Project-

Financial Times DashboardingSAP Business Objects v4.2- Design Studio- Information Development Tool- SAP Lumina

Project Business Analyst/Business Objects Developer Shrinkage Management Information Project: - Stock Movement- Online Return Merchandise Authorisations- Stock Loss

Business Analyst/Business Objects Developer Omni-Channel Reporting Project

Evaluation of Business Objects implications of migrating their data warehouse from DB2 to Netezza.

Client - John Lewis PlcProvide Business Objects universe and report writing expertese on a variety of Business Intelligence projects. - Insurance Reporting- Clearance Reporting- Flash Daily Sales Report- Finance Forecasts- Customer Order- Supplier Management- Supporting business and systems users:

Client - Skanska Balfour Beatty Joint VentureProvided database support on M25 Upgrade Project- Developed MS Access database to analyse contracted designers timesheet entries and costs- Developed Excel spreadsheets to present Access data in presentation formats

Client - John Lewis PlcDesigned Proof of Concept database, built universe (using Aggregate Awareness) and produced sample reports.Wrote Metadata (Excel) documents to scope live system, capture data sources and design DB2 database.Consulted with business users to specify 100 key reports via a bespoke Report Specification Document (Excel) giving details of Layout, Variants, End Users, Delivery method and Scheduling requirements.Built and Tested reporting BO Universes (8) utilising up to 13 levels of Aggregate Awareness to improve performance.Designed Report Level Formulae Document in VBA backed Work Document to standardise calculations in Web Intelligence and Desktop Intelligence.Report Writing (Web Intelligence) - Wrote complex Standard Reports from Report Specification Documents. Reviewed, tested and improved agency written reports. Co-ordinated UAT with Business team.Co-ordinated delivery of live reports during Implementation of system. Assisted in Business user training and support.Provided full documentation of Universe Design, Metadata and various specific solutions and procedures.

Client - Electricity AllianceA two month consultation contract working for the Surveying Manager to review and recommend solutions for a number of reporting and forecasting issues:- Designing and building VBA controlled Excel spreadsheets.- Designing and building Access Databases using Forms, Reports,VBA.- Advising on information available in the SAP Financial System.- Reviewing Forecasting requirements.- Advising on the options for reporting solutions.

Designed and constructed complex Business Object reports using multiple data sources and data providers, complex formulae and a variety of output tables, graphs and report tabs.Provided First and Second line support for business users which involved:- debugging and refining user created reports- running workshops to help the users develop their own specific reports and skills- running initial training courses for business users focussing on the best practices for using the company’s ad hoc reporting system- designed advanced business user training courses concentrating on specific reporting issues and solutions (formatting, formulation and avoiding data conflicts)- writing freehand SQL in Business Objects queries to refine datasets and produce reports not possible using the pre-designed universes - managing Broadcast Agent Scheduler, used to refresh and print up to 2,000 reports before the start of business week - using Business Objects Supervisor to manage and maintain users’ rights and securityDesigned and constructed bespoke B.O. solutions for specific requirements, which involved building universes, testing and delivering reports.Managed migration from Business Objects 5.1.8 (ZABO) to v6.5 Full Client.

Successfully co-ordinated and supported installation of Business Objects to provide ad-hoc reporting system (Trading Reports), allowing business to design and schedule their own reports with data selected from 200 data measures and 150 reference dimension objects.Project Manager responsible for designing and deploying Markdown Model application, which is now standard tool for planning promotional activity in all divisions.Responsible for managing use of company’s data warehouse through specific “Power Users” across Finance, Store Planning and Logistics as well as providing ad-hoc data extractions and task specific database routines for all other areas of the business. Co-ordinated smaller projects such as Personal Shopper System, Availability, Week 53 implementation and data warehouse Data Integrity.

B&M Reporting Manager – Finance Division (March 1996 - November 2000)Systems Support Manager – Finance Division (September 1994 – March 1996)Warehouse Liaison Manager – Stock Control (March 1993 – September 1994)Assistant Manager – Stock Control (August 1987 – March 1993)

Merchandiser – Womenswear (September 1986 – August 1987)Assistant Merchandiser – Womenswear (March 1984 – September 1986)Trainee Merchandiser – Womenswear (January 1983 – March 1984)Administration Assistant – Womenswear (September 1982 – March 1983)