See our Blog

Prepaid Credit Card MIS

Client: TransSend (Conister Bank)

Project Brief
Devise an MIS suite of applications to assist with the day to day analysis, transactional and reporting requirements for the newTransSend venture. The solution should where possible be supplier neutral and be capable of being rapidly extended.

Users need to a variety of ways of accessing the information in a format that is both accessible and meaningful to them and the task they need to action.

Solution Implemented

To meet the client's requirements, we first designed a "Common Cards Database" to centralise all transactional information. A custom Windows Service acted as a framework around a "Black Box" application. The Windows Service is vendor neutral with all vendor specified data import functions wrapped within the "Black Box". This approach allows for further "Black Boxes" to be added in as and when required.

The Common Cards Database can be accessed via a variety of methods:

  • Cards Intranet Site - IIS based ASP.Net website, implements advanced AJAX functionality to provide the end users with the optimal user experience. This intranet site has been designed to extensible and allow for adding additional functionality with relative ease.
  • Several secured SQL Views of the data for the users to perform ad-hoc queries within Excel etc.  
  • Financials / Sun Accounts Integration. Custom Excel 2003 plug-in was developed to take the financials, transforming into a format suitable for importing directly into Sun Accounts

Going forward a suite of Microsoft Reporting Services will also be provided to complete the custom MIS requirements of the new venture.

What The Client Thought

Antelle IT were our service provider of choice to develop an MIS Database that centralised all of our transactional information. Having been provided with a basic requirements specification, Antelle developed and implemented software which has proven robust and automated processes that has greatly reduced manual reconciliation times. The intellectual and flexible approach to this project by Antelle staff has ensured that a successful delivery was completed both punctually and within budget.

John Tottenham, Chief Operating Officer

Built Using

  • Custom Controls and Libraries
  • Microsoft ASP.Net
  • Microsoft Excel
  • Microsoft Office Automation
  • Microsoft Reporting Services
  • Microsoft SQL Server
  • Microsoft Visual Basic .Net
  • Microsoft Visual Studio
  • Windows Service Application
  • XML

Services Provided

  • Data Conversion
  • Database Design
  • Development
  • Management Reporting
  • Requirements Analysis and System Design
  • Setup and Distribution Kit

Our Commitment

We strive to deliver a level of service that exceeds the expectations of our customers.

If you have any questions about our products or services, please do not hesitate to contact us

Stay Connected

Antelle IT Ltd
Unit 17b
Carrs Lane
Tromode Estate
Isle of Man

Phone: +44 (0)1624 660613
skype: antelleit