09/06/2022 updated

**** ******** ****
100 % available

Database Developer, Demand Analyst, MIS Reporter

Lagos, Portugal
Portugal
Lagos, Portugal
Portugal

Microsoft AccessASP.NETMicrosoft ExcelMicrosoft WindowsData AnalysisAtlassian ConfluenceAtlassian JiraCustomer Relationship ManagementMicrosoft OutlookComputer ProgrammingData ProcessingDatabasesData CollectionData EntryExtract Transform Load (ETL)Relational DatabasesDebuggingLinuxOracle DiscovererFilemakerIBM SPSSPostgreSQLMicrosoft Visual StudioMicrosoft OfficeMicrosoft SQL ServersVisual Basic .NET (Programming Language)Query OptimizationRemote Desktop ServicesRaiser's EdgeMicrosoft Visual SourceSafeSAP APOSQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesTransact-SQLExtensible Markup Language (XML)Data ProtectionDatabase MigrationSlackVba Programming LanguageOperational SystemsSoftware Version Control
Microsoft Excel, Microsoft Access, SQL, MS SQL Server, SSIS, SSRS, PostgreSQL, VSQL, MS Access, XML, Linux, Remote Desktop, Visual Basic 6, MS Visual Basic, VBA, JIRA, Confluence, Slack, FogBugz, MS Excel, MS Windows, MS Office, Outlook, IE, CRM, database, Visual Source Safe code management and version control, ASP.NET 2.0, code behind, data driven websites, VB.NET, debugging, SQL Server, data processing, analytics, query optimization, ICCube systems, ETL, Oracle Discoverer, Excel, Access, APO, SQL Server 2005, T-SQL, MS SQL Server databases, VB6, Database migration, VB6 and SQL, Data Analysis, SPSS, Raiser's Edge database, data capture, Data Protection, o/s, data entry, programming, relational database, Filemaker, CCD

Experience

Professional experience10+ years

Project history

Senior Database Developer

Rakuten Advertising
* Building, debugging, optimizing SQL Server data processing functionality of a proprietary market
leading, internet marketing and attribution, data analytics platform. This included a fair amount
of query optimization and occasionally working with Linux, PostgreSQL, VSQL and ICCube systems.

* Scoping and developing complex ETL pipelines to import datasets for small, medium and large
national and international clients. These could be online and offline sales data or various
customer touchpoints, in order to further enrich marketing and attribution analyses and
reporting.

* Building new business critical SQL based processes . Eg. A novel automation process which
increased reporting capacity dramatically - a necessity prior to the sun-setting of our data
platform which ensured all clients were satisfied at this difficult time. They all received the
necessary historic reports prior to termination of service, despite this requiring a reporting
capacity and capability previously unavailable.

Demand Analyst

Palmer & Harvey
* Fully optimized regular KPI reporting using Oracle Discoverer, Excel, Access and the SO99+ APO.

* Initiating and developing promotion uplift analysis systems enabling supply chain optimization
in order to attain acceptable 98% Service Levels.

* Rationalizing and structuring large and diverse data and information systems enabling effective
use and analysis.

* Development of analysis and reporting solutions working across MS Access, MS Excel (including
effective use of VBA in both) and SQL Server 2005.

Developer

CFP Software
* Live maintenance and development of new functionality for Estate Agency Database and Accounting
Applications (in VB6 and SQL).

* Database migration from numerous database formats to CFP data formats, liaising with clients
when necessary.

* Creating bespoke 'debug' applications to identify and fix database inconsistencies (in VB6 and
SQL).

Database Analyst

Sense Deafblind and Rubella Association
* Data Analysis to determine the effectiveness of different Direct Marketing appeals and
strategies utilising MS Access, MS Excel and The Raiser's Edge database. Reporting the findings
(including data exceptions and suggestions for future analysis) to management and colleagues.

* Developing (in MS Access, VBA and SQL) user-friendly applications enabling efficient importing
of data and the administration of Direct Debit donations.

* Developing (in MS Access, VBA and SQL) a 'live' analysis suite for profiling 'face to face'
recruited donors and their DD donations, monitoring the effectiveness of the street fundraisers
and providing headline results for the campaign.

* Providing full documentation detailing the straightforward procedures required to operate any
applications developed.

Assistant Photo Librarian

Friends of the Earth
(Voluntary - 15hrs/wk)

* Designing and programming a relational database for the photo-library (Filemaker Pro)

* Co-organising an 8 minute slideshow presentation for the AGM

Assistant Membership Officer

Friends of Saddler's Wells Theatre
(Voluntary - 15 hrs/wk)

* Responding to membership enquiries by telephone and by post

* Clerical work pertaining to all new memberships and membership renewals.

Database Developer

(Role was as above, but the job was with DC Storm - a Brighton based company subsequently purchased
by the Rakuten Marketing Group in 2014)
Apr
2011
Sep 2014

MIS Reporter

Sussex Coast College Hastings Archery Road Campus
* Regular and Ad-Hoc SSRS, MS Access and MS Excel reporting, querying in T-SQL from the back-end
of MS SQL Server databases.

* Fit for purpose reporting and analysis including: performance analysis and profiling of
curriculum, staff and students; financial risk analysis; success, retention, achievement and
attendance data; all meeting the executive level demands of senior managers, OFSTED inspectorate
and other external bodies.

* Development of VBA software solutions for reporting, document production, and performing
back-end updates of proprietary database applications.

Data Analysis

Sense Deafblind and Rubella Association
(freelance contract)

* Lifetime Value Data Preparation - Analysis and Cleansing of Supporter Data to a brief in
preparation for in-house Sense SPSS Lifetime Value (LTV) Data Analysis.
May 07
Aug 07

Donor Care Coordinator

Sense Deafblind and Rubella Association
* Data analysis utilising MS Access, MS Excel and The Raiser's Edge database including thorough
analysis of 'drop-out' rates of committed givers. Reporting the findings (including data
exceptions and suggestions for future analysis) to management and colleagues.

* Financial projection utilising MS Access, MS Excel and The Raiser's Edge database. Reporting the
findings (including data exceptions) to management and colleagues.

* Set-up of the administration and data capture (d/c) requirements for all DM appeals, liaising
with the DM team and outsourced d/c companies

* Importing data captured by the d/c companies, and Standing Order donations from the bank, to the
Raiser's Edge database

Donor Care Assistant

Sense Deafblind and Rubella Association
* Departmental Data Protection officer
Apr 04
Mar 05



Sense
Deafblind and Rubella Association

Donor Care Assistant

* Set-up of the Gift Aid Claim Systems (d/c, adherence with IR rules, donation form requirements
and claim selections) from scratch, with the Database Manager and the Head of DM and Legacies.

* Initial set-up of the outsourcing of d/c and banking (with the Database Manager and the Donor
Care Team Leader) including: Admin systems performed both by o/s company and in-house, financial
reconciliation systems, d/c requirements, systems for importing the data once captured,
relationship management.

* Supervising and training temporary staff and volunteers and prioritising their work load which
consisted mainly of data entry.

* Making data selections for various mailings and producing the final mailings ready for in-house
'fulfilment'

* General Admin including data entry and other basic database tasks
Sep 98
Apr 04

Delicatessen

(under contract to Big Life Records and Viper Records)

Guitarist and Flautist
(full time then part time)

* With the band 'Delicatessen' I recorded four singles and three albums of music, playing and
writing for guitar, flute and various other instruments.

* I provided creative input into the design and marketing of the records, including the
development of promotional videos.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in