Adam C.

BUSINESS ANALYST

732 dollar
Freelancer
31 years
London, UNITED KINGDOM

My experience

More

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.
More

New CenturyMay 2010 - October 2018

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.
More

Reed Business InformationJanuary 2010 - May 2010

Project to improve the trading spreadsheets and the Excel VBA to automate the publishing processes.
More

Ford Motor Co.October 2009 - November 2009

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.
More

NHS PCTAugust 2009 - October 2009

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.
More

BioPharm ServicesJuly 2009 - August 2009

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.
More

CHC AviationMay 2009 - July 2009

CHC, the world’s largest provider of helicopter services, required Excel solutions in their establishment planning division based in Aberdeen.
More

Selfridges & CoMarch 2009 - April 2009

Excel VBA system for Selfridges IT department.
More

TravelportJuly 2008 - February 2009

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.
More

e-bay / GumtreeFebruary 2009 - February 2009

Applied urgent changes to existing VBA / Access system involving the documenting and flowcharting of the existing system and identifying to understand the dependencies.
More

BBC MonitoringJune 2008 - June 2008

BBC Monitoring translates feeds from foreign broadcasts, press and the internet. The Word VBA macro suite required enhancing and undocumented legacy code reworking.
More

Argos-HomebaseApril 2008 - May 2008

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.
More

Barclays CapitalMay 2008 - May 2008

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.
More

Cognisco LtdNovember 2007 - March 2008

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.
More

easyJet, LutonDecember 2006 - September 2007

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.
More

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.
More

Teletopia LtdApril 2003 - November 2006

Designed, built and managed statistical analysis package to identify trends and anomalies in phone-line caller behaviour.

OFSTED / Immersive Education / Allen & Overy (Law Firm)January 2003 - April 2003

More

NatWestJanuary 1987 - January 2002

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