Most software developed by us encompasses the full systems development life cycle, including planning, analysis, design, implementation and maintenance.

Financial

• Application to capture data for financial reporting on IT equipment leasing clients transactions, depreciation of equipment, revenue streams using SQL Server 7 with Access 2000 project GUI. OLAP features used for reporting and data feed to Cognos reporting.
• Application to identify and mitigate Year 2000 problems in Access databases, Excel spreadsheets and Visual Basic code.
• Interface to exchange data with Algorithmics Reconciliation and Collateral system for a UK hedge fund. Also added required scheduling functionality.
• ASP application and SQL Server database to monitor a complex General Ledger application for a US investment bank.
• An XML and Excel reporting system for the emerging markets division of a UK investment bank.
• VB6, COM and MTS application to allow user-generated reporting in an existing trading system.
• Market data storage application using SQL Server, C# and Excel. Stored FX rates, security prices, vol surfaces and more.
• Data warehouse system for Murex trade entry application. Used SQL server and C#, designed to store and report on millions of records.
• Market data republishing system written in C# and C++, using Reuters Tibco-Rendezvous bus, included RTD server for data access in Excel.
• Credit database in SQL server to store and consume Markit data.

Health

• Migration of Mental Health Care data from legacy Unidata system into normalised tables in SQL Server 2000 database.
• Lithium usage database using SQL Server 2000 with Access project front-end.
• Data warehouse for legacy and current PCT data using SQL Server 2000. Data migrated from MUMPS PAS system into warehouse using  CACHE ADO tools. Application used both  Access Project GUI and ASP.net intranet technology. Secure ASP.net developed for sharing data with outside agency.
• Application to track and report on Foundation Trust membership using SQL Server 2000 with Access 2003 Project GUI.
• Application to record and report on Trust staff training using SQL Server 2000 with Access 2003 Project GUI.
• Application to record and report on Trust Record Inventory and Retention using SQL Server 2005 with Access 2003 Project GUI.
• Staff and services directory application to feed data to Intranet web site using SQL Server 2005 with Access 2003 Project GUI.
• Tools to migrate legacy data from PAS, flat files, Access and Excel into warehouse database after cleansing, verifying and normalising using SQL Server 2005 with Access 2003 Project GUI.
• Tools to migrate legacy data into BT hosted Rio mental health care system using SQL Server 2000 with Access 2003 Project GUI.
• Tools to migrate data from legacy application to BT hosted Child Immunisation data application  after cleansing, verifying and normalising using SQL Server 2005 with Access 2003 Project GUI.
• SSIS tools to migrate data from legacy application to Sollis commissioning application  after cleansing, verifying and normalising using SQL Server 2005 with Access 2003 Project GUI.

Other

• Application and database to capture and analyse millions of invoices for a fraud investigation at a government organisation using SQL Server and Visual Basic. Several successful prosecutions resulted.
• Access 97 database application that captures and reports on soil, types, field location and size, crops grown, fertilizer usage, crop type, yields and productivity.
• Parts lookup system for a motor manufacturer parts supplier in Excel and Access.
• Manifest control system for an international shipping company in Excel.