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