Eurostop Singapore Pte Ltd– Singapore

Database Administrator, June 2018 – Since

Working with the development teams in Singapore, UK and China, providing Database Support on all the areas including Database Design/ Query Optimization and Administrating

Key Results:

•        Responsible person of the database design/ Administration and performance of all the live servers 

EYEPAX IT Consulting (Pvt) Ltd. — Colombo 03, Sri Lanka

Tech Lead / Functional Lead – Database, June 2014 – May 2018

Working with the development teams in Australia, Sweden and Sri Lanka, providing Database Support on many areas including Database Design and Query Optimization

Key Results:

•        Responsible person of the DB Team and their deliveries

•        Designing and Modification of the schema / Providing the architect of the database 

•        Analyzing / tuning and monitoring performance on the live databases 

•        Ownership of the Schema / data patches of live deployments 

•        Develop and Review SQL Scripts developed by the Developers 

 Pearson Lanka (pvt) Ltd. — Colombo 09, Sri Lanka

Database Administrator, September 2008 to June 2014

Working with the development teams both in Sri Lanka and US providing Database Support on many areas including Database Design, Query Optimization, DB Auditing on Microsoft SQL Server 2008 and above systems.

Key Results:

•        Designing and Modification of the schema

•        Analyze and improving the performance

•        Ownership of the Schema patches

•        Develop and Review SQL Scripts developed by the Developers 

Senior Software Engineer

Provided developments and enhancements on following sub systems of fully integrated online education system with following technologies.

•        Learning Outcome Management System (ASP .Net C# 3.5, Monorail, iBatis and SQL Server 2005).

•        Personalized Learning Path System (ASP .Net C# 3.5, Monorail, iBatis, SQL Server 2005).

•        Course Activity Reporting (ASP.Net C# 3.5, Monorail, iBatis, SQL Server 2005).

•        Maintenance of all other sub systems. (ASP .Net 2.0/3.5 and SQL Server 2005)

Programus Lanka (PVT) Ltd— Colombo 02, Sri Lanka.

Senior Software Engineer, July, 2006 to September, 2008

Working as a senior member of the development team of sale-star- advanced sales management software for mobile communication networks, distributors, retailers and call centers in UK. http://www.salestar.co.uk

Involved to design and develop salestar phase 2 (Salesstar Connect) working as a team leader.

Zillione Systems Solution (Pvt.) Ltd. — Colombo 05, Sri Lanka.

Senior Software Engineer, July, 2004 to February, 2006

Report Wizard for ACCPAC

This System is used to centralize reports and allow users to create simple reports based on their own selection criteria

Sales system for MTN (Dialog GSM)

This system is mainly used to download required data from ACCPAC, Invoice, Pass data to Customer Billing system, and export data to ACCPAC                               

PO System for Millennium IT and MTN (Dialog GSM)

This system is used to generate PR, Invoice with user define approval levels, Import data from XL files and export the data to ACCPAC

Sales System for Sierra

This system is used to create orders, invoice, deliver, Transfer items and Post relevant data to ACCPAC  

Softlogic Information Systems (Pvt) Ltd. — Colombo 05, Sri Lanka

Senior Software Engineer, June, 2002 to July, 2004

MIS System for Finance Commission of Sri Lanka

This system contains of several modules, which focuses on different activities such as budgeting, funding, and revenue collection. This is to be implemented throughout the country  

•  Human Recourse Module

•    This system maintains employee posts, carders, transfers, promotions, salary scales, additions, deductions, budget and salaries. This system is capable of estimating the annual budget for employee payments, and transfers the figures to recurrent budget module

•  Socio Economic Indicators Module

•    This module is used to create and maintain socio economic indicators and provide the facility to create formulas using existing accounts

•  Advance Account Module

•    This is a simple GL system, which used to enter receipts, payments and set limits for the existing accounts

•  Data Transfer and Abstract Module

•    This module is used to transfer date from one center to another center where each center has one database server. The module creates a script using data, which has to be transferred to the effecting center. From the receiving end the script will be abstract and the relevant database will get updated. This module enables the parent center to modify data belonging to their child centers

POS & Inventory Control System

The system is integrated with the inventory system and promotion system. This system has a central database server and a local database which enables when any network problems and when the connection is establish again it will transfer the data and reconnect to the main database.

Promotion System

This system is integrated with the POS system. User define promotional schemes can be created where a promotion scheme can be a condition or a collection of condition, which will execute when the POS system is in use 

Dotcom (Pvt) Ltd. — Ratmalana, Sri Lanka

Software Engineer, November, 2000 to June, 2002

Media Implementation and Scheduling System

(Grant McCann Erickson, Phoenix Advertising)

Features- Creating Media station, creating programs, entering of rate card, scheduling, reconciling, rescheduling, creating publication orders, invoicing.

Client Service and studio billing System

(Grant McCann Erickson)

Features- Creating clients, Creating Job bags, assigning Jobs for employees Monitoring the performance and target days, Generating estimates and invoice.

Inventory Control System

(Hydramany Garments /Desmond Mercury Garments/Grant cable TV)

Accounting System

(Grant McCann Erickson, Grant cable TV and Interlink International)

This system consist of four Modules

•      Accounting Receivable 

•      Account Payable

•      General Ledger

•      Cash Book

IIS Billing System

Features – Maintaining a Calendar to keep track of peak hours and off peak hours, maintaining packages, abstracting the log file, which is created by the IIS Server, Customer Billing.

Employee Attendance System and Payroll System

Features- Maintain Employees attendance, Maintain a monthly calendar to keep track of holidays, handling employee payment transaction such as additions and deduction, Generating pay slips.

 Education & Certifications

Microsoft Certified Solution Associate in SQL Server 2012.

Passed Querying Microsoft SQL Server 2012 Exam (70-461) with 906 marks.

Currently Preparing for the Administering Microsoft SQL Server 2012 Databases (70-462) Exam

 10Gen Certified Mongo

Passed Mongo DB certification conducted by 10gen 

IDM Computer Studies — Colombo 04.

Obtained the Diploma in Computer Studies

GCE Advanced Level — 1999 — Mathematics Stream

St Peter’s College, Colombo 04

GCE ORDINARY Level — 1996

St Peter’s College, Colombo 04

Passed with 1 Distinction and 7 Credit Passes.

Colombo Institute of Technologies — Colombo 04.

Successfully Completed the Mastering In Visual Basic Programming Course.

Other information

Personal Information

•         Date of Birth               – 22 – Sep – 1980

•      Nationality                  – Sri Lankan

•      Sex                              – Male

•      Religion                       – Roman Catholic

•      School Attended          – St Peter’s College, Colombo 04

Extra-Curricular activities and Sports

•      Played Cricket for St Anthony’s Youth Club, Mount Lavinia

•      Participated Junior National Badminton Tournament  

•      Swimming, Athletes, Rugby, Basket Ball, Chess and Soccer (St Peters College – House Level)

•      Vice Precedent or Anthony’s Youth Club, Mount Lavinia for the  Year 2000

•      Member of the school Oriental Band

•      Member of the school Science Society