Retour à la liste
Adam C.

Business Analyst

690 dollar
Freelancer
31 ans
Londres, ROYAUME-UNI
Access EXCEL Power BI SQL SSRS VBA

Mon expérience

Voir plus

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.

Voir plus

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.
Voir plus

Reed Business InformationJanuary 2010 - May 2010

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

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

Selfridges & CoMarch 2009 - April 2009

Excel VBA system for Selfridges IT department.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.

Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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

Voir plus

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.

Mes compétences

Application servers

Microsoft SharePoint

Databases

Microsoft SQL Server

Languages

VBA, XML, SQL

Computer Tools

Microsoft Word, Microsoft PowerPoint, Microsoft Excel

Others

Project Management

Other

Back End, MS Excel VBA, End User Training, Security Cleared Development, SQL Seibel, Internet Access, Excel VBA Development, Access VBA development, Cyber Essentials Certification, Report Writing, MS Access VBA, Visual Basic for Applications, Microsoft Office, Data Collection, Microsoft Access, Front End, GDPR, BBC Monitoring, Access, EXCEL, GUI Applications

Business Intelligence

SSRS, ETL, SQL Server Reporting Services, Power BI