David Lee-Smith Email & Phone Number

London, GB

London, England, United Kingdom

London, United Kingdom

Corporate Services Company of very large investment firm2020-2022 Ran the Alation Implementation, and migration of content into AlationHelped develop and implement Data Quality capabilityWorked with the client to embed their Data Management Operating Model, and document their metadata in an interim sharepoint data catalogue.Tier 1 Investment BankJan-2016.

• David wrote the technical specifications, developed and unit tested: -­ AR Customer Migration: using Trading Community Architecture APIs. - AR Customer Report, Template, and Schema Definition and setup within XML.
• E-Business Suite Development Framework: He created framework to produce more maintainable and reusable code and to reduce overall development time and cost.
• Installed and configured an Oracle E-Business Suite Vision environment (Release 12.1.1) on a Linux 5.3 platform. Technologies: Oracle E-Business Suite 12.1.1 (AP, AR, GL, FAH), Oracle 11g, PLSQL, SQL, Forms 10g.
• He wrote the technical specifications, developed and tested:- Project approval matrix: Loaded approvers against projects using Projects APIs.- Approval Matrix: Loaded approvers against cost centre values, and setup.

• David wrote the functional and technical specifications, developed and unit tested the following data loads of files received from JP Morgan into Aviva Investors’ middle office data hub:- Intraday Cash Positions.
• He liaised with the business, wrote the technical specifications, developed, and unit tested the following real time interfaces to transfer data from Aviva Investors’ middle data hub to Oracle AQ, where it was.
• He wrote the technical specifications, developed, unit tested:- Trade Order Load: To process and load an XML trade order file into Aviva Investors’ middle office data hub.- Middle Office Local Copy Refresh: Automated.

• David solely designed, wrote the technical specifications, developed, unit tested, implemented and supported:- HR Personnel Interface to Armed Forces Pension system: This involved an initial one off data load of around.
• David wrote the technical specifications, developed, unit tested, implemented and supported:- Long Service Advance of Pay Questionnaires: involved creating a workflow to send notifications to service personnel with.
• He planned and managed the data initialization of all the Armed Forces 3rd party systems from the new Oracle E-Business Suite instance which included the transfer of over 27 million records to around 20 3rd party.

Bison, Slough. (Technical Manager)Developed the following code and data migration scripts:- HR Employee load using HR APIs.- Inventory item and stock level loads, and item locator’s migration, using the material transactions interface.Gold Group, Whyteleafe. (Technical Consultant)Developed a stock replenishment algorithm to automatically generate PO.

EMEA GL Technical owner, responsible for all 2nd & 3rd line support, the development of all new GL code and all enhancements to existing code. Code developed includes:SUN Balance Restatement: restates NCU balances of the Euro countries to EUR, uses the GL Interface.SUN Update PO Account and Subdetails: Updates account and subdetail segment values against.

Involved in the creation of a bespoke assets system, including Forms development and responsible for the setup of the application within Oracle Financials.Responsible for all Financials code development and enhancements, including Reports 2.0, PL/SQL, shell scripting and Forms 2.3.1st and 2nd line support AP / AR / GL.System administrator (registering.