Senior Database Developer
Rakuten Advertising
Keywords
Skills
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
Project history
07/2020
-
07/2020
* 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.
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.
07/2020
-
07/2020
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.
* 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.
07/2020
-
07/2020
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).
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).
07/2020
-
07/2020
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.
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.
07/2020
-
07/2020
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
* Designing and programming a relational database for the photo-library (Filemaker Pro)
* Co-organising an 8 minute slideshow presentation for the AGM
07/2020
-
07/2020
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.
* Responding to membership enquiries by telephone and by post
* Clerical work pertaining to all new memberships and membership renewals.
09/2014
-
05/2018
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
by the Rakuten Marketing Group in 2014)
Apr
2011
Sep 2014
06/2009
-
04/2011
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.
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.
05/2007
-
08/2007
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
* 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
03/2005
-
03/2007
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
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
04/2004
-
03/2005
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
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
03/1998
-
09/1998
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.
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.
Local Availability
Only available in these countries:
Portugal
