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
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.
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.
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.
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.
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.
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
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.
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.
(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
(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
(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
(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
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.
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.
(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
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.
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.
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
(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
(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.
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
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.
(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.
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.
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
Customer relationship management, Problem Solving, Fusion, Data processing, Data Migration
GroupWise, Microsoft Word, MS Excel, Microsoft Excel, Microsoft PowerPoint
Jet SQL, Risk Reporting, Microsoft Transact-SQL, Origination, Data Modelling, Data Cleansing, OLE DB, CSMA/CD, MS Excel VBA, MS Access VBA, Microsoft Excel 2000, IBM Mainframe Hardware, Microsoft Outlook, Microsoft Office 2007, Microsoft SQL Server 2000, Microsoft Internet Explorer, Microsoft Foundation Classes, Microsoft Windows 2000 Professional, Visual Basic for Applications, Microsoft Office, Microsoft Access, Microsoft Windows, OTBI analysis, MS-Access XP
Windows Server, Microsoft Windows 2003 Server
Microsoft SQL Server, Microsoft SQL Server 2005, Oracle, MS Access, Microsoft SQL Server 7.0, Sybase
Mes études et formations
Bsc, Electronic and Electrical Engineering - University of Surrey1981 - 1986
Vous avez besoin de ce profil dans un mois?Contactez-nous!
Talent sourcing specialist de la plateforme Pentalog, SkillValue s’appuie sur un pool de +400 000 Experts Tech & Marketing, dont +15 000 freelancers. Évaluations de compétences, missions, offres d’emploi : les consultants SkillValue vous aident à accélérer votre carrière.
Restez informé de l'actualité tech avec la newsletter Pentalog
À propos de Pentalog
Pentalog est une plateforme de services IT qui accompagne les entreprises dans leur production digitale et leur transformation en fournissant des ingénieurs et développeurs de classe mondiale. Ses 16 Delivery Centers et Agences dans le monde comptent plus de 1600 ingénieurs, développeurs, product designers et spécialistes marketing.