WH Smith is one of the largest retailers in Britain which operates a chain of high street, travel
shops across UK. To improve the business, leopard is helping them in building database, BI reports to
analyses the sales, stocks etc.

Farnaby is the future cheque clearing system. Currently, UK cheque clearing process would take 6 days for the receiver to receive the funds; now this 6 days process will be reduced to 2 days, which means the receiver would receive the funds within 2 days. To achieve this we have a proposed system called as FCM (Future Cheque clearing Module). Image Archive is one among the components in the FCM, which has Web UI, services and Databases. Image Archive is a centralized database in which audit will be maintained throughout the cheque clearing process. Each component interacts with other components using SQL server service broker queue.

The project provides consultative and analytically-based promotional effectiveness solutions to the Healthcare industry. The physicians capture data with the help of EDC application (IOS app) in IPhone/IPad. The data captured from EDC application will be saved in the form of XML files and later on physician can send it to the upload server. ImpactRx Nightly ETL process loads the data provided by physicians (XML files) into Data Warehouse and Data Marts. End user reports will be generated from Warehouse/Data Marts.

Liquidity Risk Management (LRM) Group, part of Corporate Treasury Group of RBC provided liquidity management solutions and end-to-end strategic solution for Basel III Compliance Reporting. LRM generated daily/weekly/monthly/quarterly reports which were submitted to Basel III Committee from Corporate Treasury (CT) Group of RBC Bank. It involved obtaining data from 50+ source systems including Canada, US and other international locations.

The SQL upgrade for InfoNet project was an upgrade from the MS SQL 2000 to new MS SQL 2008 for all the InfoNet related database& applications. The application changes included applying schema connection strings changes, calling stored procedures, as well as converting DTS packages to SSIS packages.