Bruce Strachan

Berufserfahrung von Bruce Strachan

• Bis heute 2 Jahre und 5 Monate, seit Feb. 2022

  Ops Improvement & Automation Analyst

  St James's Place Wealth Management

  Working on behalf of St James’s Place Wealth Management to provide for their client investors, in developing automated varied software solutions on the fly, as required.

• 3 Monate, Nov. 2021 - Jan. 2022

  Excel VBA - Automation Developer

  UK Government BEIS

  Re-contracted to redesign the current data capture templates into new user interface forms, for easy input of end user data for submission of statistical information returns in the department for business, energy, and industrial strategy. Extensive use of text-boxes, combo-boxes for dropdown listings, powered by buttons for submission, scrolling for navigation, and validated data entry for standardization control.

• 10 Monate, Jan. 2021 - Okt. 2021

  VB6 migration to VB.net Developer

  Semblesoft

• 3 Monate, Okt. 2020 - Dez. 2020

  Excel VBA - Automation Developer

  Trinity Fire & Security

  Contracted to automate many different business processes and reports currently being done manually to a large degree, due to staff constraints, enabling them to be less reliant on human resources to complete critical weekly/monthly tasks in admin, clerical, and accounting business processes...

• 2 Monate, Sep. 2020 - Okt. 2020

  Excel VBA - Automation Developer

  UK Government BEIS

  Contracted to redesign the current data capture templates into new user interface forms, for easy input of end user data for submission of statistical information returns in the department for business, energy, and industrial strategy. Extensive use of text-boxes, combo-boxes for dropdown listings, powered by buttons for submission, scrolling for navigation, and validated data entry for standardization control.

• 7 Monate, März 2020 - Sep. 2020

  VB6 Software Engineer

  Semblesoft

  On contract for the design and development of a ‘Point of Sale’ Desktop application for running a shop, incorporating stock control, Invoicing, Product database, Customer database, all dynamically linked.

• 9 Monate, Juni 2019 - Feb. 2020

  Excel VBA - Automation Developer

  Worldwide Flight Services

  (SC) cleared for this role, my contract involved business process automation software app engineering, working together with finance to map out and capture the business requirements in order to enhance and automate all manner of business accounting processes, report generation procedures and reconciliation automation within the finance team. From a process that involved several days, this process automation application has reduced this time to a mere hour or so, saving an enormous amount of man hours.

• 2 Monate, Apr. 2019 - Mai 2019

  Graphic Designer

  Semblesoft

  On contract for the design and artwork of all their advertising and giant banner creation for their expo stands. This involves complex drawing and design work employing all techniques of graphic design to achieve this. Created their website together with business video presentations for their advertising, example URL and video here, www.semblesoft.com...

• 3 Monate, Jan. 2019 - März 2019

  Excel VBA - Automation Developer

  Aegon Cofunds

  Specifically, this contract involved the interception and processing of multiple data downloads each month end, progressing these into reports after detailed manipulation and separation of applicable transactions using multiple algorithms custom developed for this automation process. These are then fed into a very large expense report Excel costing model (150+ sheets), then these are in turn collated into cost center group summaries, finally being emailed out to relevant departments for final analysis.

• 4 Monate, Sep. 2018 - Dez. 2018

  CRM Software Developer

  Semblesoft

  With Semblesoft on contract for the full stack development of a stand-alone Customer Relationship Management (CRM) software application in VB, off the back of the success I had previously in developing their MRP System software application. Software product aimed specifically at the busy company, where managing of customers is critical to their operation. A lot of careful thought and provision has gone into the development of this business solution, fully customized to their specific business operation

• 3 Monate, Juni 2018 - Aug. 2018

  Excel VBA - Automation Developer

  Enterprise Holdings

  Development of data and report processing automation applications for this company in Excel VBA, responsible for development of various software applications within the Excel VBA environment, for different areas of finance and HR. Essentially automation of routine tedious tasks reducing time from hours in a day to seconds in a button click, using custom designed user interfaces and auto emailing of completed reports inter-departmentally.

• 11 Monate, Juli 2017 - Mai 2018

  VB.Net Software Engineer

  Semblesoft

  Full Stack development of a stand-alone Manufacturing MRP software desktop application development UI (Winforms), handling all stages of general manufacturing, food & beverage, and catering production, it is designed to make the running of any factory, assembly, or production line scheduling administration much more efficient.

• 8 Monate, Dez. 2016 - Juli 2017

  Excel VBA - Automation Developer

  Nissan (NTCE)

  Contracted by Nissan Europe to reverse engineer and fully automate their Excel VBA specialist parts matrices software application for the car wiring harness department, which was originally developed in Japan in around 2002. Working together with a large team of car design engineers, I developed new software apps and tools in Excel VBA, required in this environment and inter-departmentally, for coordinating parts MRP Bill of Materials ordering with main assembly lines for Nissan Europe.

• 11 Monate, Jan. 2016 - Nov. 2016

  VB6 Software Developer

  Semblesoft

  I was commissioned to produce from the ground up, a full life cycle software application in Visual Basic 6, based on the clients requirements and specification, for the staff and client management for this Pest Control company, incorporating dashboards, electronic filing system for clients, automated invoice and job sheet generation, fully integrated calendar with automated posting of appointments for the various technicians.

• 11 Monate, Dez. 2014 - Okt. 2015

  Excel VBA - Automation Developer

  Oxford AHSN

  Having worked across more than a dozen NHS trusts, I was contracted as part of the team at Oxford Academic Health Science Network, working together with high standing Oxford academics. I worked for Professor Gary A Ford, CBE, and Professor Charles Vincent, the Professor of Psychology of Oxford University, together with the Patient safety Collaborative team in Informatics in the design and development of a scalable automated suite of reports covering all areas of the Patient Safety initiative.

• 4 Monate, Aug. 2014 - Nov. 2014

  Excel VBA - Automation Developer

  World Vision UK

  I undertook data automation for this charity, was responsible for the development of a software application where all HR backing data is collected and formatted automatically into a central summary report, enabling quick and effective Management Information analysis. Successfully trialed and completed.

• 10 Monate, Apr. 2013 - Jan. 2014

  Software Consultant

  Semblesoft

• 7 Jahre und 8 Monate, Juni 2005 - Jan. 2013

  Excel VBA - Automation Developer

  NHS - Thirteen Trusts - Jun 2005 - Jan 2014

• 3 Jahre und 8 Monate, Okt. 2001 - Mai 2005

  Various jobs between 2001 and 2004

  Arrival in UK

• 9 Monate, Jan. 2001 - Sep. 2001

  Excel VBA - Automation Developer

  Advance Wealth Management