Nick S.

Database Developer

690 dollar
Freelancer
19 ans
Brighton and Hove, ROYAUME-UNI

Mon expérience

Voir plus

Direct Line GroupMay 2018 - Présent

For their Data Team, delivered from scratch as sole developer: Systems as sole Developer:
* 2 Access databases, Morgan and Oscar, to replace all commercial reporting. Delivered un-support-needy tools with specs screens for users to define all importing and reporting specs. Sped up one report that previously ran overnight and now takes under 10 minutes 
Voir plus

Change GroupAugust 2018 - January 2019

Delivered from scratch as sole developer:
• Access database to report on agents’ client portfolios, comparing income generated per client in the current year and previous year.
Did this on the train commuting to DLG, shown above.
Voir plus

Kier GroupJanuary 2018 - March 2018

Kier delivered from scratch as sole developer: Basingstoke 8 weeks
* Excel reporting tool to import from Excel and SQL Server and report to Excel. Delivered an un-support-needy tool that allows setting up of new reports by adding rows to specs sheets, without having to change any VBA. The requirement had been to create 4 reports.
Voir plus

Legal & GeneralJuly 2016 - July 2017

VBA/SQL Developer (SQL Server 2012, Access 2010, Excel 2010, Word 2010) Legal and General
For their Mature Savings Division, delivered from scratch as sole developer: Hove
* AEOI Database (CRS, FATCA): a SQL Server database and Access frontend to produce an XML file that will pass the HMRC website's validation process, to satisfy requirement to submit details of reportable expats with cash value insurance contracts.
* 5 Excel systems connecting to an IBM mainframe via PComm.
* Carried out bug fixes and changes to existing Excel systems.
Voir plus

Clarksons PlatouFebruary 2016 - June 2016

For their Marketing and Events team, delivered from scratch as sole developer:
• SQL Server database and Access frontend for Corporate Events spending reporting.
• 2 x Access databases as data cleansing tools.
Voir plus

Legal and GeneralJuly 2015 - January 2016

For their Risk Solutions and Analytics Department, delivered from scratch as sole developer: Kingswood
* SQL Server database and Access frontend, named RIFLE, to produce monthly Reinsurance Floating Leg accounts, importing from and reporting to Excel. Surrey
* Excel tool for downloading Bank of England real and nominal spot curves over the web using XMLHTTP requests.
Voir plus

GAIN CapitalSeptember 2014 - May 2015

For their Finance department, delivered from scratch as sole developer:
an Access database called ‘Morgan’ to produce Rebate Statements for their institutional partners as well as MI reporting.
in Excel: a Transaction Reporting Validation Tool, 2 Transaction Reconciling Tools, a Client Money calculating tool, 2 bulk file downloaders using WinHTTPRequest, an XML file editing tool using XMLDocument and XPath
Voir plus

UBSJuly 2014 - August 2014

* As part of a change of their HRi system from PeopleSoft to Fusion, created 2 OTBI analysis objects using `Logical SQL' and amended 2 Access Databases to use them as new data sources London
Voir plus

Chubb Insurance Company of EuropeApril 2014 - July 2014

For their CMS department (Chubb multi-national solutions) Fenchurch St.
Delivered from scratch as sole developer: London
* 2 Access claims transactions tracking tools for 2 client accounts.
* 1 Access complaints logging database. 
Voir plus

CSMA ClubOctober 2013 - February 2014

Access/Excel/VBA/T-SQL Developer
For the COO
• Delivered an Access MI reporting tool which imports from a CRM database (SQL Server) and a SunSystems database (SQL Server) and wrote 7 Transact SQL (T-SQL) stored procedures for it to import from.
• Delivered an Access frontend to another developer’s SQL Server backend, 9 pieces of ad-hoc Excel automation for other managers, and set up a Word mail merge and gave user training for HR.
Voir plus

Lloyds Banking GroupJune 2013 - September 2013

(Access 2003/2007, Excel 2003/2007) Lloyds Banking Group,
For their SIP project (Strategic Investment Platform) for the Reconciliations Team in Group Operations within LBG Wealth Asset Finance and International, UK Wealth Holborn Bars and Old Broad St,
* Delivered from scratch as sole developer, a `Stock Reconciliations Support Tool'. London 
Voir plus

Kent County CouncilMarch 2013 - March 2013

(Excel 2003/2007/2010) For their `School's Personnel Service'
* Delivered from scratch as sole developer a fully scalable Excel system to automate the design and issuing of job application forms. West Malling
* Fixed bugs in a pre-existing Excel automated application form. Kent 
Voir plus

Powermax ITJanuary 2013 - February 2013

Delivered an automated system to aid in streamlining the recruitment process.
Voir plus

Ford Motor Co.February 2012 - December 2012

(Access 2010, Excel 2010) For the `Issue to Issue' project within Finance:
* Delivered 2 Access databases from scratch as sole developer - `Linear Volumes' and `Product Costs' - with user friendly screens for users to design unlimited reports (selecting roll-up granularity, subtotals rows, writing new calculations in a shorthand of my own creation, formatting the Excel) and save designs to a favourites list. Warley
* Delivered three complex Excel upload tools. Brentwood
* On 6 existing Access Databases: converted one to Access 2010 and wrote ribbons to replace menubars: wrote import processes: fixed existing queries and added new ones: freed one to work on other machines: added a custom security feature. Essex
Voir plus

BarclaysJuly 2011 - January 2012

(Access 2003, Excel 2003) For the Global Resourcing Team: Global Retail Banking
* Delivered a KPI reporting tool that imports from external Access databases and Excel and CSV files and outputs reports into Excel. 1 Churchill Place
Canary Wharf
London
Voir plus

State StreetFebruary 2011 - July 2011

Delivered two Trades Order Management Systems to produce deal slips and trade instructions from fund level instructions from two differently modelled clients.
Voir plus

MWBNovember 2010 - February 2011

Delivered a Forecasting Tool to the Yield Management Team
Voir plus

Lloyds Banking GroupSeptember 2010 - October 2010

For the Retail Footprint Team:
* Worked with users to design a data model for their reporting data as well as specifications for 18 Excel data feeds and delivered an Access system that implemented 18 corresponding import processes. 
Voir plus

FTSEJune 2010 - September 2010

Creating reporting tools using Access VBA, Access SQL, Excel VBA and T-SQL stored procedures in Sybase and SQL Server.
Voir plus

JB KitesurfingMay 2010 - June 2010

Delivered client course bookings database

Voir plus

Shell Trading and Shipping CoOctober 2009 - May 2010

MI Reporting Database (P&L)
Voir plus

Mobile Interactive GroupJune 2009 - October 2009

For the Finance Dept: London
Delivered from scratch as sole developer their Billing System in Access to replace an existing Excel system.
* Imports call data from and exports Client Statements to Excel. Manages storage of historical Statement runs.
* Manages archiving of backend to get round Access's 2GB file size limit - allowing simple user switching between limitless archives and the current backend, achieving seamless historical navigation.
* As with most other contracts, also wrote and performed the data migration from the old system.
Voir plus

Watson WyattDecember 2008 - March 2009

Assist conversion from Office 2002 to 2007, writing WIKI articles for VBA Developers
Voir plus

eSolutions DeptDecember 2008 - March 2009

(Excel 2002, Excel 2007, Access 2002, Access 2007) Watson Wyatt
- Global conversion from Office 2002 - 2007:
* Investigated issues arising and published analysis, solutions and 2007 training material in a knowledge base called the ``Wiki''. Surrey
* Delivered five Excel data migration and gathering tools.
* Performed Excel ribbon customisations using Ribbon XML.
* Wrote `Best Practice' guide for Access Developers for Quality.
For eSolutions Dept - Insurance and Investment projects:
* Performed fixes to existing VBA arising from conversion.
* Wrote a C++ DLL to speed up a VBA function

(Access * Excel) 
Voir plus

Legal and GeneralSeptember 2008 - December 2008

For Actuarial Dept: Kingswood
* Replaced, entirely, existing VBA in an Excel calculation engine, in order to speed it up and improve ease of maintenance. Successfully reduced run time from ``several hours'' to less than half an hour. Surrey
* Delivered three Excel data cleansing tools. 
Voir plus

UBS Wealth ManagementApril 2008 - September 2008


Key Client Reporting System to produce monthly statements to go to their Key Clients.

Voir plus

Barclays Asset & Sales FinanceJanuary 2008 - April 2008

For Asset Management, delivered from scratch as sole developer: and 3 Months
* an Asset Management Tracker with Excel frontend and Access backend. Barclays Commercial Working 7 days a week
For Risk & Recoveries, delivered from scratch as sole developer:
* a Collections Database using MS Access to import from CSV, Excel, Access and provide screens for users to design imports and reports.
For Credit Origination, delivered from scratch as sole developer: Churchill Plaza Basingstoke
* A `Review Document' for secure risk review of credit applications in Excel.
* a UK Banking Risk Reporting Tool in MS Access. 
Voir plus

Carphone WarehouseOctober 2007 - November 2007

For Group Procurement: 6 Weeks
* Given a draught table structure by my line manager, proposed and implemented changes to it and then delivered, as sole developer, a complete system around it. As is typical, replaced an Excel system of workbooks, but provided reports out into Excel. These included facilities to reproduce the original and a very user friendly screen to allow users to design their own Excel reports within the Database. 1 Portal Way
London
W3 6RS 
Voir plus

Royal Bank of ScotlandApril 2007 - June 2007

(Access 2003, Excel 2003, Outlook 2003) For the Collateral Debt Obligation & Fund Investments team in RBS Asset Management: 135 Bishopsgate 6 Weeks
* Delivered from scratch as sole developer an Access reporting system for the European Leveraged Debt Fund Extended to 10 weeks
* Delivered from scratch as sole developer an Excel tool for the European Leveraged Debt Fund
Voir plus

VodafoneOctober 2006 - January 2007

(Excel 2003, Access 2003, Powerpoint 2003, SQL Server 2000)
For the TBM (Technology Business Management) Dept: 3 Months
* Delivered from scratch as sole developer three reporting tools, one Excel and two Access, variously importing from CSV and Excel files and SQL Server and Oracle backends, and exporting reports to Excel and Powerpoint. The Connection
* Automated and debugged existing Excel reports. Newbury extended
* Debugged existing T-SQL using SQL Server's Query Analyser.
Voir plus

ABN AMROJuly 2006 - October 2006

For the Business Continuity Management Dept: 3 Months
* Automated issuing new designs of a reporting template, importing and consolidating returns and creating reports. 199 Bishopsgate
London (28 * 32)

Access/Excel VBA Developer (Access 2003, Excel 2003, Outlook 2003) Change UK July 06
* Delivered as sole developer, a Timesheets-Payroll-Invoicing and Revenue Reporting database, which imports Clients, Candidates, Positions and Placements from an existing Outlook database and outputs to Excel. Fixed price
St Martins Ho
16 St Martins Le Grand
London (28 * 31)
EC1A 4EN
Voir plus

Barclays CapitalMay 2006 - June 2006

For Human Resources: 5 North Colonnade, 5 Weeks
* Delivered as sole developer, an `Exit Interview Database' for HR, to create Excel Questionnaires and send them to leavers via Outlook, import the returns from a group inbox and report into Excel Charts and Pivot Tables. Canary Wharf
* Reworked an existing 'Talent' database to free it from year dependency hard-written into its design (there were field names containing '2005' for instance). The turn of each year is now simply a data issue, not an engineering issue needing IT support.
Voir plus

Transport for LondonFebruary 2006 - April 2006

(Excel 2002) * Delivered as sole developer, an Excel form to mimic Microsoft Access form functionality, which it was specified must not be used. 2 Months
The system had to output filtered versions of the sheet's data, also form controlled, and import the edited returns. 25 Eccleston Place
* Performed automated data cleansing of legacy data sets. SW1W 9NF
* Also delivered a separate tool, in Excel VBA, to produce CSV files for the onward data migration to the future ORACLE system.
* Also automated a process in a separate Excel workbook, in which entering a database-style record as a row in a data sheet resulted in corresponding, colour coded entries in calendar-style sheets.

SWIFTJune 2005 - October 2005

Voir plus

ABN AMROAugust 2004 - June 2005

Access VBA Developer (Access 2002, Excel 2002, Outlook 2002, Lotus Notes, DHTML, XML, VBScript) EDS * ABN AMRO account
Working mainly from home.
Delivered as sole developer, from scratch, an inventory tracking tool called `OSCAR', which was used in worldwide conversion from 97 to XP.
Replaced an in-house developed system, which was delivered unusable - the last in a line of attempts dating back 18 months. Mine went live after 6 weeks and I stayed to support it throughout the conversion project, supplying extra features on request, with a consistent turn-around time of less that 24 hours. My contract was extended 4 times for this purpose. Also on site in London, Paris, Amsterdam and Frankfurt.
* Also delivered a timesheet reporting database.
Voir plus

WWAV Rapp Collins MediaJune 2004 - June 2004

Access/Excel VBA Developer (Access 2002, Excel 2002, Outlook 2002, Groupwise 6) * Delivered `Media Reporting Database' as sole developer from scratch. Imports from Excel files and attachments in emails in Groupwise and Outlook mail boxes. Reports are output to Excel. 4 weeks
Voir plus

AMEY plcApril 2004 - June 2004

* Delivered `Order Validation System' as sole developer from scratch. Imports from csv files and Oracle. Outputs to Excel. Hartshead house 10 weeks

The Labour PartyFebruary 2004 - February 2004

YellNovember 2003 - December 2003

Capital RadioJune 2003 - September 2003

American ExpressApril 2003 - May 2003

Nationwide Building SocietyMarch 2003 - April 2003

Capital RadioFebruary 2003 - March 2003

Xchanging LtdDecember 2002 - January 2003

Magpie RecyclingSeptember 2002 - October 2002

Standard Chartered BankFebruary 2002 - August 2002

BPAugust 2001 - January 2002

CitigroupJanuary 2001 - July 2001

GlaxoWellcomeJune 2000 - September 2000

MagpieFebruary 2000 - April 2000

Ecovert SouthFebruary 1997 - June 1999

Mes compétences

Languages

XPATH, Excel Macro (VB macro), VBA, VBScript, XML, ODBC, T-SQL, C++, SQL, DHTML

Other

Jet SQL, MS-Access XP, MS Excel VBA, Microsoft Windows 2000 Professional, MS Access VBA, Microsoft Excel 2000, IBM Mainframe Hardware, Microsoft Outlook, Microsoft Office 2007, Microsoft SQL Server 2000, Microsoft Internet Explorer, Microsoft Foundation Classes, Visual Basic for Applications, Microsoft Office, Microsoft Access, Microsoft Windows, CSMA/CD, OLE DB, Data Cleansing, Data Modelling, Origination, Microsoft Transact-SQL, OTBI analysis, Risk Reporting

IT Infrastructure

Microsoft Windows 2003 Server, Windows Server

Databases

Microsoft SQL Server 7.0, Microsoft SQL Server, Sybase, Microsoft SQL Server 2005, MS Access, Oracle

Technologies

ADO

Others

Problem Solving, Fusion, Data processing, Customer relationship management, Data Migration

Computer Tools

MS Excel, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, GroupWise

Software testing

Debugging

ERP&CRM

PeopleSoft

Protocols

SIP

Mes études et formations

Bsc, Electronic and Electrical Engineering - University of Surrey1981 - 1986