Stuart Goodship

Stuart Goodship

location of Stuart GoodshipAtlanta Metropolitan Area

Connect with Stuart Goodship to Send Message

Connect

Connect with Stuart Goodship to Send Message

Connect
  • Timeline

  • About me

    Senior ETL Developer at DealerOps

  • Education

    • Exeter College

      1998 - 2001
    • St Thomas High School (West Exe) Exeter

      1994 - 1998
  • Experience

    • Sports Direct International

      Jul 1998 - Oct 2004

      I joined Sports Direct International initially as a part time sales assistant whilst attending College and progressed to a full time position as the assistant manager of the Exmouth branch. My ultimate objectives where to provide high levels of customer service to our customers, ensure the branch’s profitability and lead a professional and motivated Team of sales assistants. As assistant manager, I had the additional responsibilities for security of cash and premises, the health and safety of employees and customers, recruitment, training and merchandising. Show less

      • Assistant Manager

        May 2004 - Oct 2004
      • Sales Assistant

        Jul 1998 - May 2004
    • EDS Group

      Nov 2004 - Jan 2007
      Software Tester / Administration Assistant

      User acceptance tested systems for a range of products as part of an outsourcing contract with Liverpool Victoria, a financial services companyDeveloped test plans and assisted in the creation and maintenance of supporting documentationFulfilled administrative duties including data entry, cleansing, and servicing

    • Devon County Council

      Jan 2007 - May 2013

      Provided first, second, and third line support for 500+ schools' and other organizations' ICT services' incidents and problemsDealt with a wide variety of issues, including problems in Active Directory, correct use of schools' administration software, and hardware and network problemsUsed appropriate and clear language, whether via an email or telephone callExceeded or met all personal/organizational Key Performance IndicatorsAccumulated maximum possible points throughout all phases of career progression schemeComposed numerous technical and FAQ articles for internal and external useOversaw end user testing for logging software and a customer-facing self service portalMentored colleagues, imparting technical skills and building successful relationshipsHelped the organization gain its first Customer Service Excellence Award (UK) Show less Developed numerous databases using Microsoft Access without prior knowledge of the software, which have been instrumental in improving the administration process and are still in use todayCoded the databases to generate formatted Word documents, Excel spreadsheets, and emailsWrote and maintained an audit log of users' activities and provided reports for management Managed the testing of the systems and promptly corrected errorsCreated guidance notes and trained new users Show less

      • Service Desk Analyst

        Sept 2010 - May 2013
      • Software Developer / Project Support Assistant

        Jan 2007 - Sept 2010
    • Moffatt & Nichol via Robert Half Technology

      Jun 2013 - Dec 2013
      Helpdesk Technician (Temp)

      Providing software and hardware support via phone, email, instant message, and face to face for a global engineering firm, reporting directly to the CIO. I helped to bring the ticket numbers down to a manageable level.

    • Freudenberg IT LP via Robert Half Technology

      Dec 2013 - Feb 2014
      Consultant (Temp)

      Providing IT support for a global provider of IT services including hosting services.• Monitoring mission-critical SAP systems for errors and escalating critical issues for urgent attention• Resolving trouble tickets

    • University of North Carolina at Chapel Hill

      Feb 2014 - May 2017
      Lead Tech Support Technician

      Working in the PID (Personal Identification) Office to resolve technical issues and ensure clean and accurate data is present in the combined HR and student ERP system, ConnectCarolina (PeopleSoft) and related systems. The system houses 1.3 million individual PIDs, one record for each person affiliated with the University and the associated Hospital. • Promoted to team lead in May 2016 and won awards for achievement and work ethic• Direct the PID Office team in its day to day running and provide regular reports to the Director of Campus Card Services and Person ID, as the Team Lead• Manage multiple projects that improve both the quality of bio-demographical data in the University’s systems as well as working practices and procedures• Determine complex update feed rules and produce audit reports and ad-hoc searches with developers; carry out testing, and give final approval to move code into production• Collaboratively with the Director of Campus Card Services and Person ID I produce campus wide policies, including the introduction of a Name and Social Security Number change policies and forms• Increased the accuracy of the daily reporting Excel workbook by 97% and speed of daily processing and distribution by 98% by using VBA and formulas (VLOOKUP, INDEX, MATCH etc)• Identify, research and take ownership of duplicate records; consolidate data down to one record and ensure other departments move their data associated with the record to be merged• Create and update the office user/policy technical guides and training materials Show less

    • RUSKIN MILL TRUST LIMITED

      Aug 2017 - Dec 2020
      Data and Management Information Manager

      Data management and reporting from multiple student web front end MIS systems, covering funding, student progress, attendance, behavior and staff engagement. • Introduced and created Power BI dashboards and reports for senior management. • Crafted automated emails and Excel reports, querying from multiple databases, cleansed data to ensure a coherent and uniform dataset.• Increased speed of MIS user account creation by 80% by standardizing security groups and using SQL to automate ETL of staff data from the HR database into the MIS system• Developed T-SQL queries, views, functions, stored procedures, and DDL/DML• Cleaned, prepared, and analyzed using T-SQL and Excel (VLOOKUP, INDEX, MATCH, Pivot etc)• Designed and built reports with visualizations in Excel (enhanced with VBA) and Power BI• Created and updated rules, processes, and procedures for data entry• Collaborated with colleagues on joint projects and acted as technical expert within the team • Transfer of datasets to new tables, when new functionality has been made available or improved to meet our needs• Troubleshot end user issues and communicated technical details of bugs to software vendor• Creation of Modern SharePoint sites for user guides. Created custom color schemes using PowerShell• Creation of Power Apps and Forms for use on SharePoint Show less

    • Harry Norman Realty via Robert Half Technology

      Jan 2021 - May 2021
      Database Developer (Temp)

      Create Access databases and processes to extract, transform and load (ETL) data from flat files, and design automated reporting outputs to Excel

    • DealerOps

      May 2021 - now
      • Senior ETL Developer

        Mar 2022 - now
      • SQL Database Administrator

        May 2021 - Mar 2022
  • Licenses & Certifications

    • ITIL v3 Foundation Certificate in IS Service Management

      ITIL
      Oct 2011
    • ECDL Level 1 & 2

      Nov 2008
    • Level 2 Diploma for IT Users - Web design, ITP and multi-media

      Oct 2006
  • Honors & Awards

    • Awarded to Stuart Goodship
      Star Heel Award for Employee Excellence - 2015 University-wide award for achievement and work ethic
    • Awarded to Stuart Goodship
      UNC’s Auxiliary Services Division Job Well Done Award - 2015
    • Awarded to Stuart Goodship
      Star Heel Award for Employee Excellence - 2014 University-wide award for achievement and work ethic