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.
Development of a new Access database to import a set of Excel Spreadsheets. The new system reduced the weekly admin task from a 2-day process down to a 2-hour routine.
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.
Developed new modules for their Excel-based BioSolve analysis product. Wrote an interface to PowerPoint and designed a conversion routine to migrate old data into their new format.
Travelport market services that connect 63,000 travel providers worldwide. This project Used VBA, SQL and XML to enhance sales pipeline data from the Seibel CRM system.
Applied urgent changes to existing VBA / Access system involving the documenting and flowcharting of the existing system and identifying to understand the dependencies.
BBC Monitoring translates feeds from foreign broadcasts, press and the internet. The Word VBA macro suite required enhancing and undocumented legacy code reworking.
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.
Barclays Capital Barclays Capital HR required an Access database modified to produce comparison reports and for their appraisal process. This involved SQL queries and VBA automation.
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.
Built enhancements to Excel Scheduling Worksheets. Interfaced Excel with SQL database to provide real-time feeds. Built Excel VBA system controlling cabin crew schedule planning.
Berwin Leighton PaisnerOctober 2006 - November 2006
Consultancy on suite of Word Templates. These VBA-automated contract templates needed close scrutiny to ensure they complied with new brand and legal requirements.
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.
My stack
XML, VBA, SSRS, SQL Server Reporting Services, SQL, Project Management, Power BI, Microsoft Word, Microsoft SQL Server, Microsoft SharePoint, Microsoft PowerPoint, Microsoft Excel, ETL
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.
A Pentalog account allows convenient access to our global price catalog featuring competitive prices for top software engineering and digital profiles.
Our catalog contains everything you need to build and scale a high-performing agile development team.
Why create a Pentalog account?
View transparent pricing for world-class developers
Build and price your development “dream team”
Compare prices across 3 continents & 8 countries
Receive updates on available devs and special offers
Pro tip: Talk to a Pentalog Solution Specialist for help with technical profiles not listed in the catalog.
The first step in joining the challenge is signing up.
After you’ve created your account, you will start the competition right away. Make sure to dedicate the necessary time to assessing your technical skills.
Why SHOULD you join the challenge?
Discover your value through self-evaluation
Benchmark your technical skills against the community
Feed your curiosity
Sharpen your technical toolset
Prepare for interviews
And of course, to win AMAZING prizes!
Pro tip: The winners of the challenge will be announced after the competition is over, in six weeks' time. For more details, keep an eye on your email and our social media channels.