Sign in

VB6,Mssql,Reporting,Scada,Bms,Project Management 2013,Advanced Excel,C

Chennai, Tamil Nadu, India
August 01, 2020

Contact this candidate




H/P: +91-978*******


Career Recital

~ Project Management ~ Project Planning & Execution ~ Requirement Analysis ~ Application Designing & Development ~ Unit Testing ~ Technical & Functional Calls Monitoring ~ Maintenance ~ Enhancement ~ Functional Support ~ Estimation & Scheduling ~ QA Migration ~ Production Support ~ Customer / User AcceptanceTesting ~ Training ~

Professional Contour

Quantum Automation Singapore Pvt Ltd (June ‘07 – March ‘19)


Lead Application Engineer/Asst Engineering manager

lios Systems (P) Limited, Chennai (March ‘05 – Apr ‘07)

Senior Software Engineer

Swaram Medicare and Research Centre PVT Ltd,Chennai (Feb ‘03 – March ‘05)

Software Development Engineer

RKM SOFTWARE, INDIA (Jan ‘01 – Jan ‘03)

Programmer/Senior Developer


Worked as Lead Engineer /Assistant Engineering manager in QUANTUM AUTOMATION PVT LTD., SINGAPORE, since June 2007 to March 2019

Having about 12 years of Singapore experience in both of multifaceted experience in Analysis, Design and Development of Database Application and Handling Programming with Operation maintenance in Automation Projects Like in HVAC systems and Configuration of Networking operation for the Government of Singapore Transport Department centralized Hub.

Extensive experience in Software application development in Visual Basic’s with MS SQL Server 2012 & SQL Integration Services (SSIS & SSRS), Replications, Store Procedures,Triggers, MS-Access and reporting tool in Crystal Report X1 and Microsoft Project Management 2013

Automation of SSIS package execution using Sql Server Agent Jobs and Active Batch server Jobs,Database Backups and Restoration.

Good experience in MIS Reporting with Business Analyst and Team Management handing of 20 Team members and preparation of Project documentation and schedule through Microsoft Project Management.

Participated in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, UAT, implementation, and maintenance with timely delivery against aggressive deadlines.

Extensive experience in Software application development in Visual Basic’s with MS SQL Server 2012 & SQL Integration Services (SSIS & SSRS), Replications, Store Procedures,Triggers, MS-Access and reporting tool in Crystal Report X1 and Microsoft Project Management 2013

Good Experience in advance Microsoft Micros & Excel such as Pivot Table, VLOOKUP, Power Query and Dashboard and Microsoft Visio

Good Experience in Building Automation Application Programming and Facility management system using SCADA Programming with BACNET, LONWORKS, MODSCAN Communication Protocol and DDC Controllers.

Good Experience in on CCTV, Public address system, Fire detection system, Access control

Good Knowledge & Work Experience in Agile Testing in SDLC and Automation Software worked as “Scrum Master for all BMS projects”

Good Experience in Manual Testing & writing Test Case and Test Scenario and in Various Testing tools like Black Box and White Box testing with full in-charge as “Business Analyst”

Experienced on BMS Interfacing of HVAC Units, Chiller System, Fire Alarm System, Gas-Detection System, Security System and Sanitary and Plumbing Units.

Experience in hospital management and health care domains

Good Experience in Networking and established full Network Topology Architecture in Google Data Centre for setup entire Two or three architecture for our Whole facility building Management System at Singapore.


Master of Computer Application (MCA) june-2000, First class (66.4%), Madurai Kamaraj University College, Madurai, Tamilnadu, India (Physics), june-1997, First class (65%), Bishop Heber College, Tamilnadu, India


Languages : script, ASP

Automation tools : Backnet, Lon works and DDC Controllers

Graphical user Interface : SCADA (Pcvue ARC Informatics software) & InTouch

Microsoft Technologies : Visual Basic & VB.Net & MS Project Management Tool.

Reporting tools : Crystal Report XI, Data report

RDBMS : MS-Access, MS SQL Server 2005, MYSQL



Design, Develop, Engineering, manage, testing & commissioning of various Building Automation Projects and Software development Using Microsoft Visual Basic with MSSQL include SSIS and Business Objects Crystal Report 11.0 for the automate of the reporting

Engineering Configurations such as create databases, Programming & Graphics and Network setup for the Entire Singapore data Centers and Government Offices and Malls.

Onsite system startup, Testing and commissioning support to engineers

Factory Acceptance Test & Site Acceptance Test in Automation Projects

Prepare project schedule using project tool & testing reports for the ongoing and new upcoming projects and arranging Work allocation and completion of the project

Liaise with Client’s, Main Contractors and Inspectors on on-going projects and Singapore Government clients for the UAT.

Attend management & onsite project meetings; to do action as per requirement

Onsite support for troubleshooting and problem solving.

Generate PO to vendors and contract terms to vendors and sub-contractors

Communicate with various departments such as service, sales, procurement for smooth project execution as per planning.

Monthly report for every equipment’s in Graphical representation, Trending & reports for KWH

Preparing KPI and MIS Reports in excel like and graphics Reports using VB and Dot Net framework Architecture application.

Preparing Energy Management report for all Green Mark Building’s in both Trending Graphical Presentation and in Auto Export to Excel for the easy reference to the Management or Vendors.

Testing of all engineering application through testing tools and preparing test case for each and every projects.

Configure High Level Interface BTU/Power Meters like RODUF, ABB, Schneider

Database creation using is MS SQL server 2005 and Third party Vendor system.

Advanced Report Software called “ Crystal Report IX Business Object “

Handing Green Mark achievement as per “Building Construction Authority” Singapore.

Business Analyst for the new Upcoming HVAC and Software Engineering Projects.

Supporting Service Manager in all service Projects through SLA and A&A works

Technical Support for all Service projects like CCTV, card Access, Networking


Project 1: LTA Underpass Equipment Monitoring System

This project can monitor all the LTA Escalator, pedestrian underpass, lighting and all FMS signal over all in Singapore, Which is monitor under in one roof at LTA Singapore Government Data Centre for all 130 Zones in Singapore

Client : LTA Hub (land Transport Authority)

Front End Graphics : SCADA (inexus) & Visual Basic Application

Communication Device : PLC

Database : MS SQL Server 2005

Reporting Tool : Crystal Report 11

Role : Application Engineer with Operation Maintenance.

Team Size : 5

Duration : 10 years with Operation and Maintenance.


Testing and Commissioning, Engineering Documents & SCADA Graphics of BUILDING MANAGEMENT SYSTEM using Lon works Protocol. High Level interface with CARLO GAVAZZI power meter using MODBUS protocol and auto report generation of total running hours for all the equipment, billing system for individual customer using visual basic software and

Preparing EMS report presentation and generate Auto reporting method, Setup Entire Network Configuration of whole data Centre in place for the Monitoring to the Management

Connecting with Third party Vendor system for the monitoring of data through our application and monitoring of Network port/Switch/Hub and Auto generation of SMS Paging system, if any fault happen in the building.

Client : Google Data Centre –Singapore

Front End Graphics : SCADA (INexus) & Visual Basic Application, SNMP System

: SMS Alert Paging system, Auto excel reporting generation.

Database : MS SQL SERVER 2012

Reporting Tool : Crystal Report 11.0 and Excel Automation

Role : Senior Application Engineer

Team Size : 20

Duration : 1.5 years

Few Lists of Big SDLC & Building Automation System projects Handle

Nanyang Technical University

PWC Building (PricewaterhouseCoopers, LLP) @ Raffles

Traders Hotel @ Orchard

Google data Centre @ Ayer Rajah Crescent

Traders Hotel @ Orchard

Most of the Shopping Malls and Government Building like MHA, MFA, Singapore Transport Hub and National Libraries in Singapore

PSA Marine Building

All the building Under CBRE


Role : Software Engineer

Environment : VB, Access, SQL SERVER 2000

Operating System : Windows XP

Duration : April 2005 to May 2007

Client : Log Win Tech -Italy

COSMACS is a unique system specifically designed for the cosmetic world. All kind of companies involved in a cosmetic activity can take plenty of benefits from COSMACS: raw materials manufacturers, finished products manufacturers, consultants, third party companies, all of them can take the higher benefit today available from information technology.

Product Module

Research & Development


Sales & Purchase


Quality Assurance


Master Dossier

Product Extension

Multi Language Supporting


Health Care Domain

Role : Designer & Programmer

Operating System : Windows XP

Duration : June 2004 to Nov 2004

Environment : Visual Basic .Net, MS-Access 2000, Crystal report 8.5

Client : Swaram Home Health care and Balaji Polyclinic -Trichy

Project 1: home health care

This project provides the information about the home health care in which the Doctor treats the Patients at their door steps round the clock for both routine and Emergency check-ups. It has various other schemes also for the members of home Healthcare.

The major areas dealt in the project are:

Collecting details of new and old patients

Collecting details of patient complaints

Details of Treatment given to the patients

Follow up treatment due for both member and non-members

Documenting patient records on an ongoing basis.

Billing details towards visit, consultation and treatment.

Report generation by retrieval of patient records.


Involved in the whole system analysis, design and development.

Develop online Help with in the system

Involved in database design.

Design and Develop reports with periodic given data

Designed and developed case module includes preliminary instructions.

Involved in complete documentation.

Project 2: Hospital Management

Role : Designer & Programmer

Environment : Visual Basic .Net, MS-Access 2000, Crystal report 8.5, ADO,

Visual Basic 6.0, MS-SQL Server2000, Crystal Report 8.5

Operating System : Windows XP

Duration : February 2003 to May 2004

Client : Swaram Nursing Home, Padma priya Hospital

The project Package provides solution for the hospital management covering all the major functions of the hospital. This software is a multi-user system operating on local area network (LAN) spread across the hospital. It has the capability of handling the activities of the following major areas like Outpatient Consultations, Out Patient Investigations, In Patient Admission, details of treatment given to patients, documenting patient records, billing details and report generation by retrieval of patient records.


Involved in the whole system analysis, design and development.

Involved in database design.

Designed and developed estimation module.

Designed and developed the out patient consultations & in-patient modules.

Designed and developed out put bills & reports to patients and management.

Designed and developed consultant payment module and complete documentation.

Provided complete training at client’s site.

Designed and developed patient payment detail reports.


Project 1: Implementation and Support Management System

Role : Programmer

Operating System : Windows NT

Environment : Visual Basic 6.0, SQL Server 2000

Team Size : 2

Client : RKM Software, Chennai

The project envisages complete information about the RKM Software work done by Implementation Executives such as (Support Requirement, Basic Information, Installation Report, Payment Details, Journey cycle Plan etc) and also it covers all Pending Jobs and day-to-day Operations. The Project aims at Computerization of Support and Implementation.

Involved in the whole system analysis, design and development.

Involved in database design.

Designed and developed customer and client modules with report.

Designed and developed payment and work due module.

Involved in whole system unit testing and integration testing.

Imparted training to customer support executives.

Involved in complete documentation.

Project 2: Stock Maintenance

Role : Programmer

Operating System : Windows 98

Environment : Visual Basic, Oracle 8.0

Team Size : 2

Client : M/S .SunFish Electricals Ltd, Trichy

The Project aims at Computerization of Stocks of M/S SunFish Electricals Ltd. In this project, 10 categories of materials were taken for the Study. The stock entries, Sales and update maintenance of stock registers have been investigated.

Using this project, stock list can be taken.

It is also used to see Daily, Monthly and Yearly sales Reports.

It is also used for bill Preparation.

Involved in the whole system analysis, design and development.

Involved in database design.

Designed and developed sales and stock module.

Designed and developed report module like sales and inventory.

Involved in whole system unit testing and integration testing.

Imparted training to customer support executives.

Involved in complete documentation.

Project 3: Dealers and Distributors

Role : Programmer

Operating System : Windows 98

Environment : Visual Basic, MS-Access/MSSQL, AD0, ActiveX

Team Size : 10

Client : Philips Lighting, Amar Raja Batteries

The Software is specially designed for Philips Lighting Division Distributors to manage their Complete Business

Activities and Report to M/S Philips India, Regional Office with their Periodic Data.

Designed and developed stock and invoice module.

Designed and developed user management forms.

Designed and developed client ad


I hereby declare that the information provided above are true and confide to the best of my Knowledge


Contact this candidate