Lawrence Moore

Lawrence Moore Email and Phone Number

Product Owner Equities Reference Data System (IB) @ UBS
England, United Kingdom
Lawrence Moore's Location
Essex, England, United Kingdom, United Kingdom
Lawrence Moore's Contact Details

Lawrence Moore work email

Lawrence Moore personal email

n/a
About Lawrence Moore

Summary of Managment Experience:Team Lead of Global team, with resources in UK, US, India, Poland, and Singapore. (3 years - 12 direct reports) Senior Management Insight teamLarge and varied book of work across multiple programme streams and Business and IT stakeholders.Software Component Manager and Product Owner member of Agile Scrum Team. Summary of Investment Banking Experience:Reference Data (3 years) Cash EquitiesETD (Options, Futures, Multilegs including Option Combos) Fixed Income and Bonds Brexit STO and Venue SplitMIFID RegsRegulatory and Market Mandatory work (FCA, ESMA) Summary of Tech Experience:SQL Server Developer (15+ years).Net C# (5 years) including ASP.Net MVC, Winforms, SQLCLR, and WPFSQL Server DBA and infrastructure (7 years) inc. Clustering/Replication/AlwaysOn/VLDBs.SSIS (15+ years)SSRS (10+ years)SSAS (1 year)XML/XSD (3 years)MCP Transcript: ID=959943, Access Code=lozzamoore(https://mcp.microsoft.com/authenticate/validatemcp.aspx)Specialties: SQL Server DeveloperData Warehouse, BI, SSIS,SSRS.Net (C#) ASP.Net MVC, Winforms, and WPFBroad skillset including TCP/IP stack, DNS, WINS, AD etc..Development "wisdom" learned over the years.1) Beware of talk of temporary, tactical, interim solutions. They always hang around far longer than anyone anticipates, and frequently become the permanent solution that become painful to support and maintain.2) Systems that you understand are probably more complicated than you realise. Systems that you don't understand are probably simpler than you realise.3) Solutions should always be designed as generic, modular and re-usable. Beware of hidden assumptions and ensure key component logic is driven by config and parameters. Try not to hard-code anything. Requirements that stakeholders tell you in good faith are immutable very often turn out to be changeable.4) It is impossible to put too many comments in a piece of code, and very common to not put enough. This helps you when you come back to it, and others when they come to it for the first time.5) A database does not constitute the source control of your schema!

Lawrence Moore's Current Company Details
UBS

Ubs

View
Product Owner Equities Reference Data System (IB)
England, United Kingdom
Website:
nyftyfitness.com
Employees:
28
Lawrence Moore Work Experience Details
  • Ubs
    Product Owner Equities Reference Data System (Ib)
    Ubs
    England, United Kingdom
    View
  • Ubs
    Product Owner Equities Reference Data System (Ib)
    Ubs Jan 2019 - Present
    London, United Kingdom
    Responsible for Reference /Static Data across the whole of the BlueZone trading platform.Management of a large global team of Developers from UK, US, Poland, and APAC.
    View
  • Ubs Investment Bank
    Equities Sql Team Lead
    Ubs Investment Bank Aug 2014 - Jan 2019
    London, United Kingdom
    SQL Server specialist role in the Equities IT division, responsible for all "Blue Zone" SQL Servers underpining the firm's Equities Trading platforms.* Development and performance tuning of VLDBs (>2TB growth per month)* Development of SSRS reports and SSIS packages.* Support and enhancement of operational batch processing.* Assisting in investigations into a Big-Data Cloudera Hadoop cluster with Tableau reporting.* Investigations and design of new SQL Server technology such as SQL 2012 AlwaysOn Availability Groups and SQL 2014 in-memory tables, and clustered columnstore indexes.* Creation of bulk-insert XML shredding CLR interface stored procedures for DBDumper Java stream layer ingestion. Providing high performance ingestion layer and XSD based data format "contract".
    View
  • Deutsche Bank
    Sql Server Datawarehouse And Bi Developer
    Deutsche Bank Jul 2012 - Aug 2014
    London, United Kingdom
    Design and implementation of a Bank wide Expense Management Data warehouse System, allowing senior managers to explore and report on group wide costs and consumption.SQL Server 2008 migration to SQL 2012, SSIS ETL Loaders, and SSRS Dashboard reports/charts.Recommended and implemented VS2012 Database Project turn-key deployments, and version control management using Git..
    View
  • Barclays Capital
    Sql Developer, Mi Centre Of Excellence
    Barclays Capital Jul 2011 - Jul 2012
    London, United Kingdom
    Specialising in the development of a KPI reporting data warehouse. SSIS loader packages and complex SQL Server processing and interface stored procedures.* Loading and reshaping KPI data from a range of disparate data sources into Dashboard reports delivered via Web/SSRS/Sharepoint.* Dimension drill-down stored procedures providing OLAP style slice and dice reporting across series of KPI fact tables in the data warehouse.* Agile development approach. SDLC control using VS2010 database projects and Perforce source control, including automated database unit testing and continuous integration.* Delivering solutions in close liaison with business stake-holders.
    View
  • Lloyds Banking Group
    Sql Server Developer
    Lloyds Banking Group Dec 2008 - Jul 2011
    Responsibilities:1. PARIS Team Developer: "Profit and Loss And Risk Integrated System". Middle Office P&L and Risk aggregator. VLDB (5TB, 2+ Billion rows Risk)Re-write of P&L Adjustment Module for Middle Office posting of daily adjustments to PARIS. Winforms C#, grid based, delivered through ClickOnce. Delivered stability, performance and memory optimisations.Creation of optimised Interface Stored Procedures to feed MO EUC (Excel) reporting tools.Creation of various SSIS packages to feed downstream systems.Loader Job Dependency framework using Broker Services. 2. GCT Team Developer: "Group Corporate Treasury".Hedge Accounting Optimisation Tool. Large scale SQL 2005/C# ASP.Net MVC project to enable Banking Volatility Management Team to more efficiently manage Banking Book Derivative volatility through IAS39 Hedge Accounting practices.Development of SSIS and SP Loader jobs.Development and support of various Hedge Accounting models.
    View
  • Allen & Overy
    Team Leader App/Db Support Team
    Allen & Overy Mar 2001 - Dec 2008
    Projects:1. Technical lead for hierarchical security inheritance SQL Server trigger and stored procedure coding for firm's flagship DM portal system "Omnia". Adding functionality not provided by vendor. Validated up to ISO27001 security specification grade.2. Technical lead for "Virtual File Audit" SQL Server trigger and global reporting system to underpin the firm's Market Abuse Directive counter-measures. Validated up to ISO27001 security specification grade.3. Technical lead in externally facing case management project (FTIRingtail Legal 2005), involving liaison with Penetration testers and vulnerability investigations (SQL Injection, Post Data injection)4. Technical lead in Autonomy based "Enterprise Search Project", providing single search portal across firm's disparate data stores: DM, SQL DBs, Exchange, Notes, Know-How systems.5. Technical lead in "SQL Server 2005" migration project migrating firm's 300 SQL Server 2000 servers to the SQL 2005 platform.6. Technical lead in introducing Microsoft Reporting Services (SSRS) reporting infrastructure within the firm, plus RDL report authoring.* Awarded "Exceptional Contribution to the Firm" rating 3 years running in formal performance reviews.Admin/Maintenance Responsibilities:1. Support of 300 SQL Servers globally in 26 offices, including HP Proliant EVA SAN based SQL 2000/2005 MSCS clusters.2. Support of SQL Server based core applications including OpenText DM, CarpeDiem, Elite Billing system.3. Coordination of firm's regular SQL Server based Global schema upgrades, insuring consistent database schema across distributed application.4. Set-up and maintenance of automated data feeds and cost capturing systems.4. Team leader of team of 10 permanent and contractor DBAs: mentoring, governance, task allocation, interviews, management liaison.
    View
  • Fleetboston Financial
    Network Services Analyst
    Fleetboston Financial Jul 1999 - Mar 2001
    Projects:1. Development of Intranet DB applications, using ASP/ADO with SQL 7.0 backend.2. Terminal Server with Citrix Metaframe Total Desktop Integration' Project-pilotto production. Single-handed installation and maintenance of Load BalancedFarm of 9 servers.3. IBM RS6000 Network Storage Manager with TSM. Primary technicalresource-creation of operator procedures for business resumption.4. Exchange 5.5 Global Organisation installation (21 Sites). Migration fromCcmail.Admin/Maintenance Responsibilities:1. DBA of MS SQL 6.5/7/2000 Servers.2. NT4 Admin. Multiple master domain structure.3. Exchange 5.5 Admin.4. IIS 4,0 and 5.0 Servers (incl. ASP/ADO)6. Novell 4.11 File and Print Servers.7. Maintenance and installation of Compaq Proliant Servers (rack mounted).
  • Rotch Property Group
    Network Administrator
    Rotch Property Group Apr 1998 - Jul 1999
    1. Installation and configuration of MS SQL server.2. Migration of Novell 3.11 file servers to NT4.3. Installation and configuration of Bay Access Node routers, Marlin/Clam ISDNrouters connecting sites and Cisco routers to internet.4. Installation and configuration of Exchange 5.5 Organisation with Outlook 98.5. Installation and configuration of MS Proxy server.
  • Linpac Automotive
    Systems Support Engineer
    Linpac Automotive Feb 1997 - Apr 1998
  • Ck Industrial Engineering
    System Administrator
    Ck Industrial Engineering Nov 1994 - Feb 1997

Lawrence Moore Skills

Ssis Ssrs C# Winforms Sql Server T Sql Business Intelligence Data Warehousing Sql .net Database Design Etl Databases Itil Software Development Ssas Banking Wpf Microsoft Sql Server Analysis Services Sdlc Dts Agile Methodologies Servers Visual Studio Business Objects Iis Requirements Gathering Asp.net Mvc Performance Tuning Data Modeling Olap Stored Procedures Data Migration Transact Sql Sql Server Integration Services Sql Server Reporting Services Software Development Life Cycle

Lawrence Moore Education Details

  • Leeds University
    Leeds University
    Chemical Engineering

Frequently Asked Questions about Lawrence Moore

What company does Lawrence Moore work for?

Lawrence Moore works for Ubs

What is Lawrence Moore's role at the current company?

Lawrence Moore's current role is Product Owner Equities Reference Data System (IB).

What is Lawrence Moore's email address?

Lawrence Moore's email address is la****@****alk.net

What schools did Lawrence Moore attend?

Lawrence Moore attended Leeds University.

What skills is Lawrence Moore known for?

Lawrence Moore has skills like Ssis, Ssrs, C#, Winforms, Sql Server, T Sql, Business Intelligence, Data Warehousing, Sql, .net, Database Design, Etl.

Who are Lawrence Moore's colleagues?

Lawrence Moore's colleagues are Ethan Harro, Flloyd Rewa.

Not the Lawrence Moore you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.