Stuart Goodship Email & Phone Number

Roswell, Georgia, United States

Atlanta Metropolitan Area

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

Nailsworth, England, United Kingdom

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

Chapel Hill, North Carolina, United States

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

Raleigh-Durham, North Carolina Area

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

Raleigh-Durham, North Carolina Area

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.

Exeter, United Kingdom

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)

Exeter, United Kingdom

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

Exeter, United Kingdom

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

Exmouth, United Kingdom

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.

Exeter, United Kingdom

Education record

Education record