- Sandwell, GB
- £25 /hr
- Available now
I am a widely experienced Direct Marketing, Customer Marketing, Business Systems, Business Intelligence, Business Solutions, Data Analysis professional.
I have worked in themore...I am a widely experienced Direct Marketing, Customer Marketing, Business Systems, Business Intelligence, Business Solutions, Data Analysis professional.
I have worked in the Business Intelligence sphere for over 15 years and has experience from many diverse business sectors including NHS, Tele-coms, Food-Service, Hospitality and FMCG.
I have a holistic knowledge of business with commercial experience in Finance, Operations, Marketing, IT, Sales, Customer Service, Consulting, Purchasing, Pub and Restaurant Menu Engineering and Process Review.
I am also very cost-orientated fully understanding that all business improvements need to improve the bottom-line and that unprovable ROI isn\'t ROI
Area Covered: West Midlands
Work Experience Summary: Summary Of Employment
Mobile Fun Limited. December 2007 âï¿½ï¿½ January 2009
Business Intelligence and Web Analyst Developer:
Business Process Mapping; BI Development; Report Development; Senior Executive Dashboard Development; Operational Departmental Dashboards; Stock Flow Modelling; Web analytics; MySQL BI Database Design and Optinisation; MS Excel Power Developer; IT first line Desktop Support (MS Office, inhouse .Net applications, BI Suite and Hardware); ETL Design, Maintenance and implementation; XML Data Transfers; OLAP Querying
Pentaho V1.6/1.7; Pentaho Report Designer; Pentaho WorkBench; Pentaho ETL; Pentaho MetaData; MySQL 4/5; MS Access; MS Excel; MS Outlook; Thunderbird; Crystal Reports; Omniture; Google analytics; VBA; MS SQL Server 2000.
Xchanging Ins-sure Insurance Service. August 2006 âï¿½ï¿½ November 2007
Production Team Manager (Reporting): Mar 2007 âï¿½ï¿½ Nov 2007
Team Management; System/Process Review and Modernisation; Implementation of Monitoring and Review Processes; Customer Liaison; Issue Resolution; Process automation; MS Excel Power User; MS Access Senior Developer; Overhaul of Existing Legacy MS Access system; Writing Departmental Standard Operating Procedures;
Senior Data and Information Analyst: Aug 2006 âï¿½ï¿½ Apr 2007
Bespoke Report Development; Business Requirement analysis; Customer Acceptance Testing; Data Mapping of Legacy System DataBases; Development of Unified Data Source (MS Access); OLAP Querying
Business Objects XI; Business Objects V4.5; Crystal Reports;BRIO V6.5; Accusend; Talisma V6.0; MS Excel; MS Acess; In house legacy Databases;
Employer: Brake Bros Foodservice Ltd. July 1999- July 2005
Senior Marketing Business Intelligence Analyst: Jan 2000 âï¿½ï¿½ July 2005
Bespoke Report Development; Business Requirement analysis; Customer Acceptance Testing; Data Mapping of Legacy System DataBases; Customer Modelling; Strategic Business Analysis; Statistical Modelling; Qualitative and Quantitive Sales and Marketing Analysis; Departmental Budgets; Bespoke System Development to meet changing business needs.; Customer Pricing Migration Project Management and Design; Siebel CRM Data Modelling; Legacy Data Migration; Siebel CRM Marketing Data Structure Design;
Bespoke Group wide Loyalty Marketing Database system (Based in SQL with access front end); Strategic Unified Marketing Customer Database (SQL); Customer reporting and Sales force monitoring system (Access); Pricing Migration Solution Concerto/Sap4.5 to Siebel/Sap 4.7 (SQL/.NET); Complaints Management System (SQL Server, MS Access); Customer Basket Analysis (SQL Server); ; Purchase Order Management System (MS Access + HTML)
SQL Server 2000; SSRS; DTS; MS Access; MS Excel; Siebel CRM; SAP Business Warehouse; SAP V4.7; SPSS; MS Excel;MS MapPoint; MS Access; 7 In house legacy Databases; Seibel CRM; MS FoxPro; MatchIT; VBA;
Consultant Marketing Business Intelligence Analyst: July 1999 - Dec 1999
Short term contract to prove value to company.
Employer: Viatel Global Communications LTD July 1998 - July 1999
Sales Business Intelligence Analyst Developer: July 1998 - July 1999
Sales Management report Development; Business analysis for Sales function developments on core systems; Improve use of data to monitor and manage contracts; Interdepartmental Liaison to standardise working practices; Develop Bespoke MS Access and MS Excel Solutions as required by Sales Force and Sales Management.
Oracle; Business Objects; Crystal Reports; MS Access Power User; MS Excel Power User; VBA; OLAP Querying
Employer: Information Resources October 1997 - March 1998
Account Manager âï¿½ï¿½ Marketing Services (to Cadburys): October 1997 - March 1998
Monthly Data Analysis; Data Cleansing; Training Client Staff (1-2-1, and Classroom) on Oracle Sales Analyser; Bespoke Sales Analysis; Team Mentor; Identify other opportunities for client to leverage value from data provided; Presenting Analysis Results to Clients Executive.
Oracle Sales Analyser; Oracle; MS Access; MS Excel; MS PowerPoint ; VBA;
Achievements: Several well respect pieces of analytical work for Client.
Employer: Allied Domecq Restaurants and Bars February 95 - September 97
Restaurant and Bar Branded and Non Branded Managed Estate.
Marketing Analyst: November 1996 - September 1997 (Internal Promotion)
Achievements: Company Employee of the month
Purchasing Analyst and Junior Purchaser: February 1995 - November 1996
Information Builders Focus 7; MS Access; Lotus Approach; Lotus Notes; Lotus 123; Lotus Amipro;
Employer: University Hospital Birmingham NHS Trust October 91 - February 95
Monitoring and Information Officer: April 1994 - February 1995
Management Accounts Assistant: August 1993 - March 1994
Accounts Assistant(Temp): October 1991 - May 1993
MS FoxPro; Courier and Connect Fleetway Systems; SSL (Patient Transport Systems) 2000; Tetra Financial Systems; MS Access; MS Excel; VBA;
Employer: Aston Business School
Research Assistant: August 1991 - September 1991
Computer Lab Installer: August 1990 - September 1990
Education Summary: Post University Training
Microsoft MCTS SQL Server 2008 BI Development and Maintenance Certification (2009);
Accusend Advanced Administrator Course (2007);
Accusend Administrator Course (2007);
Business Objects Explorer Course (2007);
Oracle Siebel CRM Sales and Marketing Data Integration and Migration (2004);
MS 2071b Querying MS SQL Server 2000 with Transact-SQL (2004);
Microsoft Access Advanced User (2003);
Visual Basic for Applications (Excel, Word and Access) (2003);
Non Technical Telecoms and Wide area Networking Courses(1998);
Oracle Sales Analyser intermediate (1997);
Introduction to MS Access (1995);
Introduction and Intermediate Lotus Approach (1995);
Introduction and Intermediate Lotus 123 (1995);
Introduction and Intermediate AmiPro (1995);
Lotus cc:Mail (1995);
Tetra Purchasing and Receipting Modules (1993);
Customer Marketing and Business Intelligence specialist