API's, Engines, and Libraries

SSIS, SSRS, Monogame, Git, MonoGame, Unreal Engine 4

Senior Analyst Programmer, Edinburgh Woollen Mill

01/2022 - Present

Achievements:

• Successfully deployed SQL server installations and configuration of SSRS. 

• Lead development of upgrading from an on site ERP system to cloud based (Aptos) and integrating into the current reporting stack. 

• Integrated new accounting software (ERPx) to automated exports from ERP system. (C# application calling ERPx API)

• Ported and improved ecommerce server processes to new modern SQL Server including rebuilding SSIS packages from DTS packages.

Responsibilities:

• Managing and mentoring 2 members of staff.

• Day to day dev ops issues handled through ticketing system including:

  • SSRS report creation and debugging.

  • DBA level tasks to keep SQL databases healthy.

  • Investigative works to find and fix issues with data.

• Project management including talking to stakeholders and designing solutions to requests from the business.

• Creation of any new ETL processes using SSIS and batch scripts for FTP.

Analyst Programmer, Edinburgh Woollen Mill
11/2016 - 01/2022
Achievements:

• Lead data and process recovery after a disaster recovery situation.

• Created new Stocktaking software for stores to use that integrates Denso Scanners with a C# program that stores stocktaking data and reports on a central server.

• Created system to manage the integrations between website and till system for a loyalty program. This included creating an API that was hosted on AWS. Managed the AWS configuration and syncing of data between local and systems.

Responsibilities:

• Day to day dev ops issues handled through ticketing system including:

  • SSRS report creation and debugging.

  • DBA level tasks to keep SQL databases healthy.

  • Investigative works to find and fix issues with data.

• Creation of any new ETL processes using SSIS and batch scripts for FTP.

• Creation or integration of any other processes or programs that the business requires.

IT Service Desk Analyst, Edinburgh Woollen Mill
01/2016 - 11/2016

Achievements:

• Increased the accuracy of footfall data for the company by fixing store based issues and creating checks and warnings that allow for problems to be identified quicker. 

• Assisted in rollout of new till system with store visits to replace hard drives and other hardware.

Responsibilities:
Responsible for store support mainly focusing on footfall reporting and hardware in stores.
Helped stores over the phone or through email for any IT issues they were having.
Performed checks through the day to ensure the figures reported to the business were accurate.

Sales Assistant, Spar

07/2011 - 01/2016

Responsibilities & Achievements:

Worked on tills and the shop floor.

Helped customers with their requests.

Kept on top of shelf replenishment and tidying to ensure an inviting store.

Performed stocktakes, date checking of products as requested. 

University of Teesside (2008 - 2011)

Computer Games Programming

Modules: Games Development, Middleware, AI Programming, Tools for Programming Games, Multiplayer Games Programming, Algorithms and Data Structures