Ministry of Housing Communities & Local GovernmentOctober 2018 - November 2019
Reporting systems for the Brexit Strategy. VBA automation of monthly departmental reports. Design of ETL data collection into a unified database for analyse across time and projects. Integration into SharePoint and production of graphical dashboards using Pivots and Power BI.
SQL database maintenance and Report writing. Built record-keeping systems for, and supported staff in, Afghanistan and Botswana. Integrated SQL to MS Access with VBA Front End. Designed Template Suites for Letterheads and Reports with VBA Menus. Led the organisation on GDPR compliance and Cyber Essentials Certification. Provided training and user assistance on MS Office Suite products. SharePoint Administrator.
The NHS Primary Care Trust at Mile End Hospital required over 100 different reports generated from a new database. Used Access as a front end to SQL Server which then populated Excel spreadsheets and automatically sent emails to selected recipients.
Designed and built a new Access database that automatically imported the relevant sections of each contributing spreadsheet. Built a user-friendly GUI was to produce Access reports in PDF format to be distributed across the 350 Homebase stores.
Contract to redevelop customer reports using Excel & VBA. Thousands of these reports are generated every day – each one is populated from the SQL back-end and automatically formatted in Excel for delivery by e-mail.
Over 15 years’ experience across a wide variety of IT departments. • Developed spreadsheets and databases for use in the Branch and operations environments • Telephone and on-site support to Bank employees with PC problems.
Microsoft SQL Server
XML, SQL, VBA
Microsoft Word, Microsoft Excel, Microsoft PowerPoint
Internet Access, Report Writing, Data Collection, GDPR, Front End, Back End, MS Excel VBA, MS Access VBA, Access VBA development, GUI Applications, EXCEL, Visual Basic for Applications, Microsoft Office, Microsoft Access, Access, Excel VBA Development, SQL Seibel, Security Cleared Development, End User Training, BBC Monitoring, Cyber Essentials Certification
Power BI, ETL, SSRS, SQL Server Reporting Services
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.