David Staples Email & Phone Number

Wellington Region, New Zealand

⦁ Identify & analyse overnight fraud and set fraud blocks⦁ Run daily SQL looking for fraud, create stored procedures as required.⦁ Create and maintain new Excel sheets and VBA components as required.⦁ Create audit & management reports in SQL, Excel & Power BI.⦁ Create Visa, Mastercard and Internet Banking rules to detect fraud in SQL.⦁ Create and modify Microsoft Access apps using forms and VBA.⦁ Find information through large & complex systems for Police requests⦁ Review phishing emails and scams and send to a third party for web pages to be removed. ⦁ Identify vendor APIs to implement new processes or replace an existing manual task.

Brisbane, Australia

Ensure the Integrity of Findur version 14 system by reviewing any new contract templates or system changes made by Front, Middle and Back office. Working with the Front, Middle, Back office & technical team to deploy new versions of FINDUR releases for testing and deployment to Production. Creating FINDUR audit reports for compliance.

London, United Kingdom

BA\Developer / Sirius Consultancy to Federal Home Loans Bank, CincinnatiTest and identify any implementation\operational issues with the FINDUR V14 upgrade from FINDUR V11.Analyse and code a solution to pass Marketwire information back in to FINDUR.

London, United Kingdom

Developer / On Demand Team / Sirus Consultancy to AXPO Trading, ZurichBuilt in JVS - Archiving system for use by back office enabling the issue of cancellations and credit notes using Crystal ReportsBuilt data extractions from Endur to external systems via databases or filesLocated and resolved performance & stability issues in back office documentation process

London, United Kingdom

BA\Developer / Sirius Consultancy to Federal Home Loans Bank, CincinnatiUser Data Worksheets (UDW) - Developed monitoring page allowing transparent identification of failed processes/ interfacesSwap Exchange Facility (SEF) - Implemented & improved open source Java FIX messaging engine (Quick Fix). Built plugins to communicate FIX messages from Findur to Swap exchange through quick fix and update status in Findur accordinglyUpdated several Connex methods to enhance functionalityCreated Trade Process Management (TPM) processes to map business functionality.

London, United Kingdom

Trader Support for Base & Precious MetalsRan and ensured EOD batch completedEnhanced APM system by building new client pages or resolved issues around existing pages.Investigated and resolved support for BAUWrote scripts and documented the system for Front, Middle & Back OfficeSupported back office settlements process.

London, United Kingdom

Provided Level 3, 24/7 support for Base Metals and Energy EOD batch runsInvestigated and resolved Level 3 support for BAUWrote scripts and documented system for trade migration to new systemSupported back office settlements processDesigned and implemented critical enhancements pre system move.

London, United Kingdom

Worked primarily on Base Metals OpenLink system, responding to trader queries and requests, monitoring daily and end of day processesWorked in partnership with an ‘around the sun’ support team in multiple global locations and time zonesHelped teams external to the OpenLink product gather information from OpenLink likewise through a file, stored procedure or OpenLink API’sReviewed EOD process and implemented process fixes and enhancementsSole technical resource on OpenLink upgrade from V80 to V91, including parallel testing against existing version, supported user tests and ran the EOD and compared data Installed latest versions of key software (Oracle, TIBCO, Crystal etc.), upgraded database and implemented new OpenLink versionAided implementation of server probe based messaging service for EOD errorsUpgraded OpenLink Active Position Manager (APM) from 1.6 to 2.6, including rewriting of APM pages, which were incompatibleInvestigated PnL breaks including proving trade values and checking prices on the LME\CME or other possible discrepanciesProvided expertise in OpenLink to help business users clarify requests and subsequently coded fixes\enhancements through a formal testing and release procedureLevel 1 & level 2 support for OpenLink and subject matter expert for problem resolutionRaised and managed issues sent to OpenLink and tested and implemented new cut when sent from OpenLink.

London, United Kingdom

Implemented EMEA physical Gas trading through an AVS script to capture daily positions and pass these through to custom system for balancing daily positionsDeveloped various power reports including physical position reports and trade reportsSupported BAU model including timely code fixes through a documented release procedureWorked with the Service Delivery manager to improve performance of EOD processFixed and enhanced OpenLink document release module written in AVS for confirms and invoices that were ultimately sent to Scrittura document tool.

London, United Kingdom

Lead developer on the EMEA Gas implementation in to OpenLink, including a daily position extract to make sure notifications and positions are as expected.Lead developer on the implementation of the UK & European power module in to OpenLinkSupport the BAU model including timely code fixes through a documented release procedure.Provide analysis, design and coding for the Emissions project .

London, United Kingdom

Sole developer on the OpenLink oil implementation.Design, develop and implement an ICE power deal booking system in to OpenLink.Support BAU fixes and release through a documented release procedure.

London, United Kingdom

Traveled to client sites providing AVS scripting supportAssisted training other developers and helped develop coding practices & release proceduresAnalysed, designed, coded and implemented new scriptsMaintained, through enhancements and fixes, the existing scriptsDeveloped new scripts including Real Time Position Engine (RTPE), Pre & Post processing scripts, accounting scripts, interface scripts, simulation result scripts including custom result scripts, reporting scripts and deal import\export scriptsCreated and modified Crystal Report templates based on user or business requirementsProvided technical advice to external scripters working on client sitesWorked with support team to give technical advice and help in recreating customer reported problems.

Knutsford, Great Britain

Designed and implemented COBOL programs for offshore business teamTested through unit, system and integration testing following the SDLCBacked up the DB to tape and clearly documented to enable future recovery

Wellington & Wairarapa, New Zealand

Provided 24x7 support to the overnight batch run in regards to financial management reportsLiaised with external bank WestPac to ensure EOD refunds process worked effectivelyCoded financial reports for management

National Diploma In Business Computing

National Certificate In Business Computing

Intermediate Certificate In Business Computing