Lawrence Campbell Our Work

Lawrence Campbell – our work

The following is a synopsis of some of our work. Lawrence Campbell has undertaken this work in the last year and, whilst it is representative of our work, it does not cover the entire breadth of activities we undertake. If you click on the “more” buttons below, you can find out more details. And you can always contact us to find out more about our work and how we can help you.

Type of Client Scope of Work
Oil Trader Systems Development > More
Technologies / Software
Commissioned by Finance Director
Comments Development of a solution to replace legacy, bespoke solutions.

Software House Solution Delivery > More
Technologies / Software
Commissioned by Sales Director
Comments Acting as an independent mediator concerning the configuration and delivery of solution concerning complex functional requirements.

Media Upgrade of Accounting Solution > More
Technologies / Software
Commissioned by Finance Director
Comments Project Manage and deliver upgraded Accounting Solution including the rationalisation and rewriting of interfaces.

Media Development of Debt Management System > More
Technologies / Software SAP and various other software solutions
Commissioned by Finance Director
Comments Linking of various Accounting Solutions across the world to deliver timely global debt data managed within a SAP Data Warehouse.

Hotel Group Accounting system selection > More
Technologies / Software
Commissioned by Finance Director
Comments Delivery of Business Requirements Specification and Request for Information.  Circulation to suppliers and selection of solution.

FX Broker Integration of Till Solutions With Middle Office and Accounting Solutions > More
Technologies / Software SQL
Commissioned by Finance Director
Comments SQL Server and Integrations Services Solution used to enrich the Middle Office solution by implementing more effective controls and interface with accounting solution.

Media Replication of data between different solutions > More
Technologies / Software A range of differing software solutions
Commissioned by Finance Director
Comments Replication of static masterfile data between different solutions.

Money Broker Integration of Wholesale Trading Solution > More
Technologies / Software A range of Trading and Accounting software
Commissioned by Managing Director
Comments Linking of Trading Solution to Accounts  and other solutions.

Commodity Broker Automated reconciliation of Trades > More
Technologies / Software
Commissioned by Head of Brokerage
Comments Link of solutions to automate the process of matching brokerage receipts to charges.

Media Implementation of out-sourced solution > More
Technologies / Software Based on Salesforce.Com
Commissioned by Finance Director
Comments Integration of SalesForce.Com with other business solutions primarily using integration services and bespoke interfaces.

Media Implementation of Accounting Solution > More
Technologies / Software A range of accounting software
Commissioned by Finance Director
Comments Implementation of Accounting Solution together with ERP Solutions including the conversion of legacy data, training of users and configuration.

Charity Selection and upgrade of accounting solution > More
Technologies / Software Upgrade of Accounting Solution
Commissioned by Finance Director
Comments Selection and upgrade of Accounting Solution with additional integration with other solutions.

Hotel and Members Club Single Business Intelligence Portal > More
Technologies / Software SharePoint Development
Commissioned by Managing Director
Comments Single Business Intelligence Portal binding data from underlying systems including room bookings, membership, till systems and accounting.

Oil Company Portal for Finance Department > More
Technologies / Software SharePoint Development Management Information Solution
Commissioned by Finance Director
Comments Portal for Finance Department serving the business using a single “Finance Window”

Financial Services Insurance Investment Accounting Solution. Integration and revision of existing accounting solution and enhancement to address the complexities of Investment Accounting for a major UK insurer. > More
Technologies / Software INFOR SunSystems; SQL Server: Integration and Database Services; Excel 2010 and VBA.
Commissioned by Finance Director
Comments Turned a generic accounting solution into a investment accounting solution to maintain an inventory of investments, their historic cost and current value at market rates along with cash positions along with the ability to calculate profit/loss and determine profit/loss in terms of currency rate movement; the value of underlying position and margin calls on forward positions.

Major Japanese Multi–national Manufacturer and Distributor Consolidation and Treasury Management. Consolidation of accounting information at entity, currency and product level for over 120 trading entities throughout the world. > More
Technologies / Software SAP; INFOR SunSystems; SQL Server: Integration and Database Services; .net.
Commissioned by Finance Director
Comments Data is extracted from SAP and other sources, consolidated into a single entity where intercompany eliminations are processed and inter-company balances are reconciled. Currency exposure is analysed and profit and loss on currency rate movement calculated. Data is reformatted and aggregated into extracts used for financial accounting and consolidation into the accounts of Japanese Holding Company. This is an automated process that has to run according to demanding and limited time frames.

International Car Dealership BPM Processes. Management of ordering, purchasing, sales stock and commissions for multiple car manufacturers > More
Technologies / Software Ultimus; Kerridge; SQL Integration Services, Reporting and Database Services.
Commissioned by Finance Director
Comments Automation of manual processes based on legacy systems (Kerridge) leading to significant cost savings, efficiencies and transparency of management data.

International Off Shore Lawyers BPM Process. Compliance. Management of KYC (Know Your Client) > More
Technologies / Software Ultimus BPM, SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange
Commissioned by Managing Partner and IT Manager
Comments Management of new take on process concerning the validation of approval of matters and the undertaking of appropriate client checks.

FX Brokers Documentation of existing processes. Procurement and selection of accounting solution and Electronic Order Requisitioning System. Project management, configuration of, integration of, and deployment of solution. > More
Technologies / Software Process Mapper, SQL Server, IIS, INFOR SunSystems; QA; IPOS, Microsoft CRM
Commissioned by Board
Comments Issue of request for information and Business Requirements Specification. Included the evaluation of six accounting solutions and associated products. Negotiation with suppliers and implementation of solution in multi-country, multi-location, company. Inclusive of generating daily Profit & Loss accounts and detailed balance sheet analysis of positions and exposure to Exchange Rate movement.

Retail Currency Dealer Integration of a till-based trading system with GL to ensure accuracy and completeness of accounting data alongside control over cash positions and bank movements. > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange
Commissioned by Finance Director
Comments Requirement to process dirty and complex data against a rules engine to generate accounting entries for circa 30,000 transactions a day. Need to reconcile IT data generated from stock systems and prove accuracy and completeness of data load on an automated and daily basis.

Wholesale Money Brokers Project Management of Dealing and Stock Control Solution. > More
Technologies / Software Intrafin, Oracle
Commissioned by Board
Comments Requirement to deliver a solution at breakneck speed in a complex and difficult environment.

FX Group Interview and selection of System Accountants. > More
Technologies / Software
Commissioned by Finance Director
Comments Evaluation of Systems Accountant candidates to ensure they had appropriate technical and accounting knowledge to manage a complex solution.

FX & Commodity Brokers Allocation and Matching Routines. > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; INFOR Sun Systems
Commissioned by CFO
Comments Need to match settlements and contra deals generated in different source solutions that are unmatched in GL.

FX & Commodity Brokers Integrate GL with middle office, Trading Solutions and common corporate permanent data repositories. > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; INFOR Sun Systems
Commissioned by CFO
Comments Process over 120,000 transactions daily matching and validating data on an automated basis alerting users to issues and required corrections.

FX & Commodity Brokers Extract Summary GL Data and enrich it with Trading Data to provide complete and accurate Compliance Data. > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; INFOR Sun Systems, QA
Commissioned by CFO and the Compliance Officer
Comments Generates snapshot data views every 20 minutes enriched to meet daily FSA and Bank of England reporting requirements. The requirement included validation of data and consistency checks. The approach of enriching the GL Balance Sheet ensured that data could be reconciled to the financial accounts.

FX & Commodity Brokers Upgrade Accounting Solutions > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Oracle Financials
Commissioned by Board
Comments Extract and enrich data from existing GL for use within Oracle Financials.

Oil and Commodity Trader Consolidation of Accounting Data, implementation of security model and build of Excel front end to load data into user Pivot Tables requiring a significant performance improvement and enrichment of data. > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; INFOR Sun Systems; Microsoft Exchange, Windows Server, Excel VBA
Commissioned by Chief Operating Officer
Comments Generates and populates Pivot Table data from user form ensuring that users have rights to read the data. Ensures the selection of valid data, eliminating the user requirement to make complex selections from accounting and other databases.

NHS Management Reporting and BPM > More
Technologies / Software SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; SharePoint
Commissioned by Finance Director
Comments Integration of SharePoint, Reporting Services and user-defined Web Parts to distribute management reports to over 7000 NHS Staff. Solution monitored report usage and promoted users to read reports by email, identifying if they had been read and logging user’s comments that were added to reports.

Building Industry Regulator Evaluation of existing solution, documentation of requirements and issue to suppliers. > More
Technologies / Software Microsoft CRM
Commissioned by MD
Comments Complex requirement to resolve problems of existing solution by putting requirements out to alternative suppliers.

Oil Company Deployment of world-wide Accounting Solution based on alternative products. Use Business Intelligence Solutions to return financial data. > More
Technologies / Software Citrix, INFOR Sun Systems; Oracle Financials, QA
Commissioned by Financial Director
Comments Complex requirements to deal with joint venture accounting concerning multiple locations across the world using different accounting systems, languages and different accounting standards.

Oil Company Move of Accounting Solution. > More
Technologies / Software INFOR Sun Systems; Oracle Financials
Commissioned by Financial Director
Comments Transfer from Oracle Financials to Infor Sun Systems.

Off Shore Out Sourcing Company BPM Process Management, Accounting and Virtual Private Network. > More
Technologies / Software Ultimus BPM, SQL Server Integration Services, Reporting and Database Services; Microsoft Exchange; SharePoint
Commissioned by MD
Comments Transfer of solution based in the Channel Islands to out sourcing base in Mauritius. Creation of VPN Linking Clients, UK Data Centre and Mauritius. Deployment of web based BPM solution to meet client needs.

International News Agency Accounting Solutions Integration. > More
Technologies / Software INFOR Sun Systems; SAP, FTP. Net
Commissioned by Financial Director
Comments Creation of Web Based Interface to manage the integration of two Accounting Solutions with different and inconsistent rule sets to facilitate the production of consolidated accounts.

Private Equity Firm Business Intelligence and Accounting Consolidation > More
Technologies / Software INFOR Sun Systems, QA
Commissioned by Financial Director
Comments Complex process of accounting for investments where there is partial or joint ownership and loan agreements.

Oil and Gas Development Training and Accounting Solution Consolidation > More
Technologies / Software INFOR Sun Systems
Commissioned by Financial Controller
Comments Multinational Accounting Consolidation and Training requirement.

Marine Security Documentation of existing processes. Procurement and selection of Accounting Solution and Electronic Order Requisitioning System. Project Management of installation, design and integration, and deployment of solution. > More
Technologies / Software CODA
Commissioned by Finance Director
Comments Issue of RFI and BRS and selection of CODA to service a venture based both in the UK and Dubai.

Magazine Publisher Implementation of Accounting Solution > More
Technologies / Software INFOR Sun Systems
Commissioned by Finance Director
Comments Implementation of Accounting Solution.

Magazine Publisher Automated production of invoices > More
Technologies / Software .NET, Web Services, , SQL Server Integration Services, Reporting and Database Services
Commissioned by Finance Director
Comments Generation of advertising and WEB invoices from source management solutions. Automation of invoice generation and forwarding of invoices to customers.

Software House FX Excel add in > More
Technologies / Software Excel VBA, Web Services, SQL Server, .Net
Commissioned by Sales Director
Comments Commission to build an Excel add in to manage FX Balance Sheet reconciliations and analysis of position and rate risk.

Online Broker Documentation of existing processes. Procurement and selection of Accounting Solution and Electronic Order Requisitioning System. Project management of installation, design and integration, and deployment of solution. > More
Technologies / Software INFOR Sun Systems
Commissioned by MD
Comments New Business start up with a need for an immediate system and one that would scale to as the business grows.

Online Broker Build and deployment of interim Middle Office solution > More
Technologies / Software .NET, Web Services, , SQL Server Integration Services, Reporting and Database Services
Commissioned by MD
Comments Configuration and enhancement of GL to act as a middle office solution.

Broker Integration Between GL, Dealing and Middle Office system > More
Technologies / Software FSS .NET, Web Services, SQL Server Integration Services, Reporting and Database Services
Commissioned by Finance Director
Comments Linking of solutions to ensure the automatic flow of accurate and complete data.

"I know that the twelve notes in each octave and the variety of rhythm offer me opportunities that all of human genius will never exhaust."
— Igor Stravinsky