Stephen Cannell Email & Phone Number

Unit A3, Fleets Corner Industrial Estate, Fleetsbridge, Poole, Dorset, Bh17 0Hl

• Design and plan BI solutions, delivered via web browser• Create and deploy reports and visualisations• Develop and maintain the BI Admin System Portal• ETL from core business systems into the SQL BI Data WarehousesLogiINFO (business analytics platform for creating interactive applications that include dashboards, reports and self-service analytics).HTML5CSS3JavaScriptMS SQL ServerT-SQLSSAS with MDX queriesOLAP cube design & development (multidimensional database modelling)SSISMS Excel data functions (Pivot tables from OLAP cubes)

Poole, Dorset

I managed the IT systems within this small educational book distribution business, working closely with publisher clients and internal staff. This included active directory administration within a partly virtualised server environment, and close support at intermediate/advanced level for all Microsoft Office applications, software packages and desktops. I maintained the back office ERP system, Access Dimensions, running on a SQL Server 2014 platform, and provided a comprehensive reporting function both internally, and externally, through VPN, to clients using a variety of tools including MS Query, Crystal Reports and MS Access.I developed an email alerting system using ORBIS Taskcentre triggers and tasks, enabling immediate action to be taken when business-critical situations and events occurred on the database. I also automated various procedures, for example daily data feeds to wholesale customers, back order reports to customers etc using the ORBIS system.I also set up Business Intelligence data visualisation dashboards showing real-time KPIs, charts and reports, using Insight Dashboard, a proprietary BI tool supplied with the Access Dimensions system.

Central Store Support, Bournemouth, Dorset

I worked in a team supporting and developing the IT infrastructure and the users within head office and across eleven stores in the UK, of this busy and successful retail chain based in Bournemouth. There was an on-going installation, implementation and commissioning of a new EPOS system across the business which was based on Microsoft Dynamics running on Microsoft SQL Server 2005. There were new tills in all the stores, and data fed between these, the store server and the head office servers using Navision data directors. We provided and deployed management reports using Microsoft SQL Server Reporting Services (SSRS). The team also managed and implemented an upgrade from MS Exchange 5.5 to MS Exchange 2007 across the business, including a migration of legacy Novell systems to Windows 2003 with Active Directory, successfully keeping downtime to a minimum.

Southbourne, Bournemouth

Support of a Windows 2003 domain network infrastructure, including Windows 2003 servers with Active Directory and ISA Server to staff and students across the campus of a college affiliated to the University of Bournemouth. Windows XP desktop support including fault finding and resolution. Roll-out of PCs to clinic treatment rooms for digital X-ray system. Support of campus printers. Preparation of library laptops for issue on short-term loan. Responsible for the daily tape backup using Veritas software and for occasional restores of files from the backup sets. Close support of standard software such as Office 2003 to staff and students. Setting up and supporting computers and audio-visual equipment in teaching theatres, classrooms and business presentations, and support of audio-visual software and hardware whilst covering full time staff sickness

Head Office, Ferndown, Dorset

Reported to the Head of IT. My main responsibility was to provide management information from a newly installed state of the art EPOS (WinRetail) and Accounts (Cedar OpenAccounts) system to the business. Assisted with historic data take-on from the KPOS system to WinRetail, including cleansing and transformation of old data into the new structure so that comparative like-for-like reports (This Year vs. Last Year etc) could be produced. Maintained an extensive suite of Microsoft Access reports linked to the SQL Server database and provided the means of delivery to the end users. Analysed user’s requirements from request to finished deliverable. Wrote a series of maintenance routines using Access and Excel integration to enable data take-on and amendment, for example to allow batch price changes for defined ranges of stock items. Supported and reported off all other in-house systems such as Payroll and Personnel

Merley, Dorset

Member of a small support team in a busy multi-client environment, providing a help desk function servicing the needs of the legal profession, to firms in the Southeast and Southwest of England. Occasionally I was involved in new client set-up and configuration projects, travelling to client sites when necessary

Hurn Airport, Bournemouth, Dorset

Part of a team responsible for the day to day support, administration and maintenance of an NT 4 network which included a number of Windows 2000 and 2003 servers in an operational aviation environment across two main sites at Bournemouth and Teesside Airports. Provided support for role-specific IT systems – Aircraft Maintenance, Flight Operations, Target Towing, Quality Assurance etc. including Microsoft Access database development, support and reporting. Administered a BT Meridian telephone switchboard. I was HMG security cleared to SC level whilst in this post.

Whitchurch, Hampshire

Working in a team of two, managed and supported the IT function across two sites in the south of England including all desktops and servers. . Administration of an ERP manufacturing and accounts system running on a MS SQL Server platform, including management reporting using Crystal Reports and MS Access.

Member of a team within Head Office responsible for the day to day maintenance, support and administration of the IT systems at the bank’s offices and branches. Provided a help desk function directly to the users of the system across the business. Provided data interchange mechanisms with mainframe computers of the parent bank (now RBS). Developed and wrote complete database solutions for the bank, including two systems that enabled the bank to monitor fund manager’s compliance with statutory requirements.

London, United Kingdom

Responsible for the maintenance, support, and administration of the Network Division’s LAN, standalone desktop systems, peripherals and office software packages This included support of a satellite office in Manchester.

Responsible for the maintenance, support and administration of the IT systems used by a busy Administration section within a Headquarters department. Developed computer based solutions to replace or supplement manual business procedures. Wrote reports from the Sperry mainframes using MAPPER DBMS

Bsc, Jnt Hons Science

Education record