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 to May-2020Data Architect responsible for the - Credit Risk Domain Logical Data Model- Credit Risk Data Vault Physical Data Model - Onboarding External Ratings feeds - Onboarding Instrument reference data - Book reference data- Traceability of data models to the Business Glossary- Data lineage from Source systems, through staging to data vaultGlobal Investment Bank May 2014 – Dec-15Large Retail BankMay 2013 – April 2014 (1 year)Data Architect working with the Head Of Finance Data Architecture to improve transparency and understanding of the bank's data estate.Tier 1 Investment BankOctober 2011 – June 2013 (1 year 9 months)Data Architect working within Global Technology helping to redefine the bank's finance and risk data architecture for the purposes of financial, risk and regulatory reporting. Key responsibilities include defining data requirements, data modelling (conceptual, logical, physical and XML) and advising on best practice for data infrastructure.

• 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 Publisher. - AP Invoice Load: using the AP invoice open interface tables.• 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, Reports 10g, XML Publisher, Linux 5.3, VMware Server.This period included onsite from Jun-Sep at London Borough Of Barking and Dagenham Council, where I did the following:• 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 approval rules/conditions in Oracle AME.- Purchase Order XML Gateway setup: to transfer Purchase Orders electronically via the Oracle Supplier Network.- Purchase Order Print: Customised standard PO Print using BI Publisher.- PO Account Generator workflow modifications: Generate charge account for requisitions and purchase orders.- PO Create Document workflow changes: Auto-create purchase orders from approved requisitions below a certain amount.- Requisition Notification: Modified to display charge account and charge account segment descriptions.Technologies: Oracle E-Business Suite 11.5.10 (PO, iProcurement, PA), PLSQL, SQL, OAF, BI Publisher, XML Gateway, Workflow, JDeveloper.

• 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- Intraday Cash Transactions- Overnight Deposits- FX Suggestions- Unsettled Transactions• 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 subsequently loaded into Latent Zero:- Counterparty- Benchmark- Portfolio• 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 mechanism to create and refresh copies of Aviva Investors’ middle office data hub on developers’ local desktop PCs.Technologies: Oracle 10g, PLSQL, SQL, Tuning, Data Pump, AQ, XML, XE, External and Partitioned Tables.

• 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 200,000 personnel (including all of their assignment, address, periods of service, salary and telephone number records), and then an ongoing automated nightly delta load to maintain integrity between the two systems. The intelligent interface applied business rules and would report on and retain any data that failed these rules, until corrected within the source application which would trigger that data to be re-extracted that night. • 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 attached word documents and HR APIs to update Person Extra Information Type.- GL Costing Data Extract.- HR Data Extracts: 10 daily and 1 monthly outbound extract to migrate people, assignments, pensions, salaries, addresses, attendances, absenteeism and contracts to a 3rd party system.- CRM Service Requests Interface: to load Military Police incidents as service requests, using standard CRM APIs to create the service requests, tasks, notes, and relationships between service requests.- Payroll Interface: to process payments from the Armed Forces Pension system.• 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 systems.Technologies: Oracle E-Business Suite 11.5.10 (CRM, FND, GL, HR, Payroll), Oracle 9i, PLSQL, SQL, Tuning, SQL*Loader, External Tables, Workflow, Reports, Shell scripting, Data Modeling, Data Migration, Interfaces.

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 requisitions.Built VAT derivation program to automatically derive the tax type to assign to sales ordersModified PO Change workflow so an update to need by or promise date would not require full re-approval of the PO.Developed a form to reconcile boxes loaded onto a truck with the driver’s sheetITV, Waterloo. (Technical Consultant)Data migration:- Sales invoices (using autoinvoice tables) - Unapplied receipts (using receipts API) - Customer calls (using Customer Call API and FND APIs to attach documents)Modified AP Invoice Approval workflow to identify the approver from a descriptive flexfield against the invoice.Vanco, Isleworth. (Technical Consultant)Developed an interface to extract journal details from GL, validate and map the data, populate bespoke tables, create extract file and then write to a descriptive flexfield that the journal has been extracted. Wrote an Oracle Projects billing extension to create billing events.Pilot Clothing, Winchester. (Technical Lead)Created daily sales/takings interface, which included extracting the data from CIMS (Oracle based) via a database link and then populating the General Ledger interface table.Purchase Order InterfacePickfords Removals, Enfield. (Technical Consultant)AR invoice interface, which would create AR transactions from ‘fee plus cost’ AP invoices using data stored in descriptive flexfields.Technologies: Oracle 9i, Oracle E-Business Suite 11.5.7 – 11.5.10 (AP, AR, GL, FND, INV, OM PO), PLSQL, SQL, Tuning, SQL*Loader, Workflow, Reports 6, Forms 6, Shell scripting.

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 POs and Requisitions to align them with the Corporate US instance.SUN Move and Merge Replication: Replicates Move and Merge parameters to all sets of books. EMEA AP/PO Technical owner, responsible for all 2nd & 3rd line support, the development of all new AP/PO code and all enhancements to existing code, along with technical ownership of ‘Procure to Pay’ systems including SunTEA (Sun custom expenses system), custom invoice assurance processing, custom Human Resource interfaces, custom bulk pay processing, and EDI invoicing.Successfully completed R11i (re) implementation Oracle GL / FA / AP / PO NOV-2001. Project role: AP / PO Technical Owner responsible for:Initial AP / PO setup including all HR organization setup (business groups, legal entities, operating units and inventory organizations).Specifying and developing a solution to convert and reconcile HR data from R10.7 to R11i (including employees, assignments, locations, and bespoke HR tables) using R11i APIs.Developing bespoke HR forms (using Forms 6i) to control the bespoke HR interface.Modifying bespoke HR interface code to run under 11i environment.Technical specification of R10.7 -> R11i data migration scripts and management of third party development team.Managing User Acceptance Test period, assisting the users with test plan development, liaising with business (system) owners and end users. Fixing code bugs or return to third party developer as appropriate. Re-implement and organize retest. Promote to production.

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 conc. programs, adding users, responsibilities, printers, menu changes etc).Responsible for liaising with Oracle support and applying Oracle Financials patches on both development and production environments. Business Objects first line support and trainer on AP / AR and GL universes.Technologies: Oracle E-Business Suite 10.4 – 10SC (AP, AR, GL, FND), PLSQL, SQL, Tuning, Forms, Reports, Shell scripting.