Kannadasan A

Senior Database Developer.

A.KANNADASAN                                                        Email: Kannasql@gmail.com

                                                                                             Mobile: +971-555062317

CAREER OBJECTIVE

  Dynamic and self-motivated Software Professional to work in a competitive environment, using my skill sets and analytical approach, to the best of my abilities, to help the organization achieve its targets thereby enhancing my overall development as an individual.

PROFESSIONAL SUMMARY

• Possesses 6+ years of experience in Database Modeling, Development and Support of MS SQL Server 2008 R2, 2012 & 2014 for development & production.
• Proficient in Relational Database Management Systems (RDMS).
• Sound Knowledge in designing the Database tables using Normalization Concepts.
• Expertise in Transact-SQL Statement Such as DDL, DML, DCL.
• Experience in implementing business logic using Functions, Triggers, Indexes, Views and Stored Procedures.
• Intensive Experience in Monitoring, Tuning SQL Server and analyzing database performance using SQL Profiler and Database Engine Tuning Advisor.
• Experience in automated process of Scheduling the Jobs and alerts using SQL Server Agent.
• Responsible for Rebuilding & Reorganizing the Indexes as a part of Performance tuning.
• Experience in SQL Server Database Maintenance activities such as Backup and Restore database. 
• Experience in creating and maintaining MS SQL Server Installation.
• Experience in Importing & Exporting the data from SQL Server to Excel, CSV files and vice versa.
• Knowledge in creating reports using SQL Server Report Service (SSRS).
• Knowledge in Database Mirroring and Replication of Database as a part of Disaster Recovery.
• Knowledge in creating packing using SQL Server Integration Service (SSIS).
• Basic Knowledge in dashboard tool such as Power BI.

PROFESSIONAL EXPERIENCE

Nov 2015 – Till Date              Designation    : Database Developer

Organization   : Business DNA

Responsibilities: Involved in the database developing activities such as database creation, modifying the database objects, creating backups via SQL jobs and support for the production database.

Jan 2015 – Nov 2015              Designation    : Software Engineer

Organization : Telstra Pvt Ltd, Chennai (Formerly IdeaObject Software Pvt Ltd)

Job Summary   : Involved in the creation of database, data model changes and database maintenance activities and Involved in the Enhancement of product and Bug fixing activities to ensure the Bug free product.

May 2013 – Dec 2014              Designation    : Software Trainee

Organization  : IdeaObject Software Pvt Ltd, Chennai

Job Summary: Involved in the creation of database, data model changes and creating triggers, views and stored procedures and creating automated process such as scheduling jobs and alerts.

Software Platform

Database                            : Microsoft SQL Server 2008, 2012, 2014

IDE Tools                             : SQL Server Management Studio 2008 R2, 2012, 2014, SQL Profiler,

                                            Database Engine Tuning Advisor (DTA), Power Architect, SSDT

PROJECT DETAILS

Title                 : BusinessCore - iSupply

Module          : Retail Management software

Client              : National Catering Company (NCC), Abu Dhabi

Technologies   :C# and MSSQL Server

Team Size        : 8

Duration          : Jan 2017 to till date

Description      : iSupply is Retail management software which provides the solution to maintain the process of inventory management activities such as Local purchase order (LPO), Goods Received Note (GRN), Transfer IN & OUT, Purchasing & Receiving and Purchase return etc. It is also integrated with Point of Sales (POS) to maintain the stock activities.

Roles & Responsibilities :  

• Involved in the Data modeling
• Involved in the creation of backup automation
• Involved in maintaining SQL script for creation of database objects
• Involved in the creation database base object such as triggers, cursors etc.
• Involved in the configuration of database mail system and alerts
• Involved in the creation of linked servers
• Provide 24 X 7 dedicated support to all production environments

Title                 : iSell

Module          : Restaurant Management system

Client              : Tarfeeh, Abu Dhabi

Technologies   :C#.Net and MSSQL Server

Team Size        : 2

Duration          : Dec 2015 to Dec 2016

Description      : ISell is restaurant management software which provides the end to end solution for the restaurant to take the Dinning, delivery and take away orders. It is also integrated with tablet and kitchen display unit (KDS) to make the kitchen activities easier. It also provides the user to take the reports such as department summary, item wise history, shift close and day close.

Roles & Responsibilities : 

• Involved in the Database design and development
• Involved in the creation of tables , stored procedures ,views and functions
• Involved in the enhancement and bug fixing activities

Title                 : Patient Portal

Module          : Online Portal for Doctor Appointment

Client              : Rainbow Hospitals, India 

Technologies   :C#.Net and MSSQL Server

Team Size        : 2

Duration          : Jul 2015 to Nov 2015

Description      : Portal is an online patient appointment booking which enable the user to book the appointments in online and also have the option to reschedule and cancel the appointment. It composed of options like patient management system, Electronic Medical Records for the patients, lab module, inventory module and reports.

Roles & Responsibilities : 

• Involved in the creation of stored procedures and data model.
• Involved in the enhancement and bug fixing
• Involved in the Manual Testing

Title                 : ARCUS

Module          : Hospital Management System (HMS)

Client              : Rainbow Hospitals, India 

Technologies   :C#.Net and MSSQL Server

Team Size        : 3

Duration          : Jan 2015 to Jun 2015 

Description      : ARCUS is an end-to-end enterprise hospital management suite that covers all aspects of operations and management of hospitals. HealthObject is an automation for Healthcare Industry and is composed for various modules like patient management system, Electronic Medical Records for the patients,lab module, inventory module and reports.

Roles & Responsibilities : 

• Installation and configuration of SQL server in development, testing and production environments
• Involved in the development of the new features of the product
• Involved in writing complex T-SQL queries
• Involved in the creation & maintenance of database modeling relation diagrams.
• Involved in the Manual Testing and code debugging.

Title                 : HealthObject

Module           : Hospital Management System

Client               : MIOT Hospital, India

Technologies   :C#.Net and MSSQL Server 

Team Size        : 3

Duration          : Jan 2014 to Dec 2014 

Description     : HealthObject is a hospital management Software which provides enterprise healthcare IT solution to the hospitals across the globe.

 B.E, Electronics and Communication  Engineering,         

 RVSCET, 

Coimbatore

Anna University