Experience

James Hall & Co. Ltd.

• United Kingdom
• Retail
• 100 - 200 Employee

• Office 365 Change Advocate

  • Jun 2022 - Present

• Data Warehouse Developer

  • Jan 2017 - Present

  I work as part of a small development team which focuses on defining and developing processes to import data from operational sources to populate the company's data warehouse.

• Desktop Support Technician

  • Jan 2022 - Jun 2022

  As a result of the cyber attack James Hall suffered in December 2021 which had a devastating impact on IT systems and many of our customers it also resulted in the total loss of the Data Warehouse. During this time I was seconded into working as part of the Central IT team in order to help ease the workload of my colleagues. The six months I spent in this role were enjoyable, as well as challenging. It also allowed me the opportunity to learn a host of new skills and develop relationships around the business.



Capita Customer Management

• United Kingdom
• Outsourcing and Offshoring Consulting
• 100 - 200 Employee

• BI Developer

  • Sep 2015 - Jan 2017

  I worked as part of the MI & Insight Team within Capita Customer Management Dixons Carphone Contract where my main duties involve:-Developing new SQL queries and the maintenance of existing ones-Supporting existing data transfer processes, including the investigation and resolution of failures.-Administering and maintaining the current MI Solution-Creating new and maintaining existing SSIS packages-Fulfilment of Change Requests, including the creation of new databases, data import processes and reports.



BSS

• United Kingdom
• Outsourcing and Offshoring Consulting
• 700 & Above Employee

• SQL Developer

  • Nov 2014 - Jul 2015

  Prior to the company going into Administration on July 17th 2015 I worked as part of a team within a client focused environment performing the following duties:-Using Microsoft SQL Server versions 2005, 2008, 2008 R2 and 2012 perform ad-hoc data extracts-Writing new SQL queries and maintaining existing ones-Acting as technical representative in client meetings-Managing client requests data requests-Performing basic database administration, including controlling user access, creating user logins and performing database back-ups-Supporting existing data import and export processes-Development new and maintenance of existing SSIS Packages



Convergys Intelligent Contact

• United Kingdom
• Outsourcing and Offshoring Consulting
• 500 - 600 Employee

• SQL Data Analyst

  • May 2013 - Nov 2014

  I was part of a small team within a fast-paced environment, primarily on the Vodafone account where my main duties involve:--Loading client supplied data files into various outbound telemarketing campaigns.--Development and maintenance SSRS reports designed to support the Client Services Teams.--Development of SSIS Packages to automate regular data loads--Development of new and maintenance of existing SQL queries and stored procedures I was part of a small team within a fast-paced environment, primarily on the Vodafone account where my main duties involve:--Loading client supplied data files into various outbound telemarketing campaigns.--Development and maintenance SSRS reports designed to support the Client Services Teams.--Development of SSIS Packages to automate regular data loads--Development of new and maintenance of existing SQL queries and stored procedures



The University of Bolton

• United Kingdom
• Higher Education
• 700 & Above Employee

• Graduate Intern - Business Intelligence

  • Sep 2012 - May 2013

  My core responsibilities included: -- Developing reports to support University decison makers.-- Amending and improving existing reports-- Assisting with the development of data warehouse-- Designing and developing databases to facilitate ad-hoc reporting-- Administration of the SSRS Report Manager environment, including granting users access to reports and folders as necessary.This role provided me with a fantastic opportunity to begin developing a database focused career. As part of this role I learned to write queries against the student record management database, which was a highly complicated in structure that utilises multiple keys across multiple tables. I also had the opportunity to learn and further develop my knowledge of SQL Server Reporting Services, Microsoft SQL Server and the SQL language.