Sql Server Management

Mobile : (+**) **** **** Rivervale Drive

E-mail : ***********@**********.*** Singapore - 543116

Sivasankaran Karthikeyan

Career Summary

Having 12+ years of experience in CRM application - Window & Web Application.

Diploma in Project Management Certified from ALISON.

Got rich experience in database designer, analyst, and application developer

Good knowledge on MS SQL Server 2008.

Solid understanding of SDLC processes including Business Analyze Requirements

Experienced in writing complex and simple SQL queries for the CRM related applications and databases

Comfortable in SQL queries, using joins, sub queries and grouping

Good in Manual Testing and by giving solution provider.

Work closely with client and identify business objectives needs and establish their requirements

Experience in Backend (data) systems and Client Server applications testing using SQL queries

Strong communication skills with an ability to grasp new things quickly

Good team player with strong interpersonal skills

Career Objective

To seek a challenging career in a professional environment where I can utilize my skills, talent and knowledge in the field of software Engineer to have twin benefits of professional and personal growth.

Excellent Communication Skills

Good Business Analytical Skills, Able to handle multiple assignments

Share my knowledge, experience and ideas in the growth of the company

Problem Solving Skills, Commitment to continuous learning, skill development

Achievements

Received Professional certification in Project Management, in 2016

Commitment in work, passion for quality and dedication towards work

Received appreciation from clients for delivering the projects successfully on time without any defects with exceptional quality

Professional Experience

Senior System Analyst April 2010 - Present

Evalley Pte. Ltd. Singapore

Senior Software Engineer September 2008 - March 2010

Symetrix Technologies Pvt. Ltd. Chennai - India

Analyst Programmer / Senior Analyst Programmer July 2004 – June 2008

Columbus Circle Technologies Kuala Lumpur – Malaysia

Programmer April 2003 - June 2004

Crozier Technology (Pvt) Ltd. Chennai - India

Accountant / Programmer June 1999 - July 2000

Baskaran & Ramesh Charted Accountant Pvt Ltd. Chennai – India

Projects Handled

Biometric System:

Biometric Fingerprint Attendance system is business attendance system for employees. System records attendance data of employees based on registered fingerprints. It is interactive GUI for adding efficiency and for automating organization procedures

a. Biometric security, b. Fingerprint reader, c. Attendance system

d. Tracking employee hours. e. Tracking wages paid. f. Automating payroll processes.

g. Complying with government regulations. h. Ensuring that employees receive proper compensation for overtime. i. Minimizing errors in bookkeeping

Environment : VB.Net, Crystal reports and SQL Server (Maintenance)

Duration : March 2016 – Till date (Maintenance Project)

Client : Mohamed Mustafa & Samsuddin Co Pte ltd

Mustafa Forex Exchange Application

Remittance System - refers to a financial service that accepts cash from the Customer,

Get the customer info, beneficiary info, and cash is transferred to the beneficiary branch Bank as early as possible. Send money to the beneficiary is a nation-wide, this Remittance system that holds individual’s records in to electronically format and transfer of funds to the beneficiary bank. Remittance System got all confidential information about the customers, beneficiary info and Bank details information, in one secured Data Base. Recommends Change Requests or enhancements for the better performance of the application

Responsibilities:

Worked on the Financial Statement module. This system goes on continuous up gradation were by every there will changes to the existing Modules and new requirements will be added.

Involved in the Implementation of the application.

Business Analyze Requirements & Written user documents.

Assisted in the Application performance analysis and tuning

Coordinate with QA Manager for any issues or problems encountered during Production execution support

Environment : VB.Net, Crystal reports and SQL Server (Maintenance)

Duration : June 2013 – Till date (Maintenance Project)

Client : Mohamed Mustafa & Samsuddin Co Pte ltd

Queue Management system:

The primary purpose of this window based system is to improve the good customer service by providing proper queue management Basic Solution, Our innovative solutions have helped to change the way in which our clients conduct their customer, and this queue system is designed to be installed in the environment within the shortest time. This application helps to monitors, the number of people entering the Travel office or Remittance office, Queue Length, Average Wait Time, Idle Time, and Total Wait Time.

Responsibilities:

Business Analyze Requirements and Scope of the Project growth

Recommends Change Requests or enhancements for the better performance of the application

Coordinate with QA Manager for any issues or problems encountered during test execution

Environment : Lead .NET Developer, VB.Net, Crystal reports and SQL Server.

Duration : Dec 2012 - April 2013

Client : Mohamed Mustafa & Samsuddin Co Pte ltd

Jewel Soft:

Jewel Soft is a Window based application which allows you to keep strict control of your overall stock, and use information to buy better, sell better and avoid wasting of money on purchasing stock that just doesn’t move. You will be able to view the style and design of stock that is currently selling and plan your purchasing on Fixing/unfixing the Gold price.

This Jewel Soft, provide exact Stock in each department, We help to record comprehensive details about all types of stock, including stones, metal components, pearl, manufacturing and design details.

Jewel Software is tightly integrated with inventory and accounts and delivers both Inventory and generates financial reports for auditing purpose.

Responsibilities:

Developed application logic using VB.Net

Worked on the Inventory Module and Job sheet processing module and also on the administrator module

Extensively involved in the production support of this application

Created reports Interface for detailed Inventory report

Environment : VB.Net and SQL Server 2008.

Duration : July 2011 – Jan 2012

Organization : Mohamed Mustafa & Samsuddin Co Pte ltd

Automated Remittance Reconciliation:

This is a windows based system to Reconciling as the remittance transactions is a critical task for financial Firms. Accurate and efficient reconciliation is essential to the success of the organization this application reduces risk and helps minimize work load by confirmation matching and reconciliation with integrated exception processing (Bank Statement), automating matching for any type of data, and achieving the highest auto-match rates for large volume, high-speed reconciliation.

Developed application logic using VB.Net

Worked on the Inventory Module and Job sheet processing module and also on the administrator module

Extensively involved in the production support of this application

Created reports Interface for detailed Inventory report

Environment : VB.Net, Crystal reports and SQL Server.

Duration : Dec 2010 – May 2011

Client : Mohamed Mustafa & Samsuddin Co Pte ltd

Mustafa Singapore:

Discussion with web team, device team & the client for the requirement changes/issues, business logic. Experience gained from other project, it is my passion to build a healthy web site & Implemented the Web Service, XML Service for data interaction for this client as they request. It’s user friendly for the Admin. Only admin has the right to change the details content of the pages.

Responsibilities:

Extensively involved in the production support of this application

Involved in development as well whenever there is new requirement on the existing module

Created Technical specification document,

Apart from development there is direct interaction with client for requirement gathering and system study

Role : Lead .NET Developer, Analysis, Design & Coding. (Maintenance)

Environment : ASP.Net, Java Script and SQL 2008.

Duration : April 2010 - Oct 2010

Client : Mohamed Mustafa & Samsuddin Co Pte ltd

Website : www.mustafa.com.sg

Web Site Projects:

I’m specialize in producing a fresh look and feel for our clients Web pages and I work with clients to move their marketing, to the next level growing their need.

Major specializations are in software development solutions and services for all types of businesses by provide valuable services while engaging in a good relationship with our customers. I’m flexible and highly attuned to your needs.

This is a website Australian Over 50s Living & Lifestyle Guide is a complete information resource for the Over 50's to enjoy a great lifestyle. This site also has a good database of Directors & Auditor’s articles. The purpose of the project was to gain experience developing in the ASP.Net environment

Apart from development there is direct interaction with client for requirement gathering and system study.

Environment : ASP.Net, ASP, Java Script, Html and SQL 2005.

Duration : Nov 2008 – Jan 2010

Client : Symetrix Technologies Private Limited.

Website : www.australianoverfifties.com.au, www.stglobalsoft.com

www.alliedmedix.com

Audit Solutions Generator [ASG]:

I’m responsible in the development of the modules such as Risk Analysis, Audit Management Tools, Audit Field work Tools and Reporting & Advisory. Implemented web service to communicate systems between each other. ASP.net was used as the Backend Code. Written procedures and functions which are required for each and every module. Written client side scripting for form validations (JavaScript). ASG is the product of CCT. ASG is web-based information solution for internal auditors as it integrates many aspects of their strategic functions and roles and bridges the gaps they currently have. It provides access to up-to-date industry risk information and it provides the tools need to monitor company’s Key Performance Indicator (KPI), controls and risks. The salient features include the Industry Risk online Updates, Risk Analysis and Assessment, Automatic Customized Audit program Generation, Annual and Project Planning, Corporate governance, KPI Monitoring, Focused Risk Assessment, Report Archiving and Monitoring, Issue Tracking, Best of class methodology, Control Objectives and Control Assessment.

Environment : ASP.Net, C#, JavaScript, IIS, Crystal reports and SQL Server

Duration : July 2007 – June 2008

Client : United Overseas Bank, Singapore

Knowledge Bank:

This is a web based search solution, which has an intelligent database product that gives an instant access to the laws, regulations and compliance requirements for financial institutions. Searching function in Knowledge Bank is categorized under Simple search and restricted search. As a programmer my job involves in the development of function for SCOPE, CONTAINS and FREETEXT. The SCOPE function allows us limit our query to a particular directory or directories, and whether or not we want subdirectories included in search. The CONTAINS predicate to search for the existence of such keywords or the FREETEXT predicate for natural language searches. The Concepts being used in this are Automatic Text Analysis and Search Algorithm.

Environment : ASP.Net, JavaScript, IIS and SQL Server

Duration : Nov 2006 - June 2007

Client : Maxis Sdn Bhd. Malaysia

(CSA) Control Self Assessment:

CSA is a generic tool used to check Self Assessment between data sources like database Table and Excel. It is now mainly used to check assessment between various regional Corporate Risk. It provides the following functionalities.

Consistency process & identifying the inconsistency details for the shared source.

Overall registration process for (potential) corporate risk and control Assessment.

Maintaining Master and shared source details (Server Name, DB Name and User details).

Column Mapping between Master and shared source.

Showing what type of corporate risk they are currently involved in.

Apart from development there is direct interaction with client for requirement gathering and system study.

Environment : ASP.Net, JavaScript, IIS and SQL Server

Duration : May 2006 - Oct 2006

Contact Management System:

The modern content management system is a computerized tool born of less technical sources (address books, encyclopedias, etc.). The idea is to take information and organize it so that it's easily retrievable, updatable, and flexible in how it can be reformatted and retransmitted, and searchable. Today's content management systems are elaborate software/database applications designed to store and process large amounts of complex information.

Any application which manages information could technically be considered a CMS, such as Help Desk software, Address/contact management systems.

Environment : VB.Net, Crystal reports and SQL Server

Duration : Aug 2005 - April 2006

Client : Columbus Circle Technologies, Malaysia.

Columbus Circle:

This is a website intended to share information between the Columbus Circle professionals and members. This site provides forums for wide range of discussions and has bulletin boards for message postings. This site also has a good database of Auditor’s articles. The purpose of the project was to gain experience developing in the ASP.Net environment.

Environment : ASP, ASP.Net, Java Script.

Duration : Jan 2005 - June 2005

Client : Columbus Circle, Malaysia.

Website : www.cct-global.com, www.decalais.com

Supply Chain Management:

Jomed Health Care is a leading surgical goods distributing company. They are dealing with most of the Hospitals, Nursing Homes and Pharmacies in Chennai. The Inventory Software controls the inflow and outflow of surgical goods. Masters involved are Customer, Supplier, Bank and Item. Receipts against Supplier Invoices, Delivery Notes and Customer Invoices are prepared. Payments to Supplier and Payments from Customer are tracked. Various reports generated are Monthly Stock Report to Bank, Tax Report to Sales Tax Dept, Supplier Payables, Customer Payments, and Monthly Sales etc.

Client : Jomed Health Care Pvt ltd, Chennai

Environment : VB.Net and SQL.

Duration : May 2003 - June 2004

Education

Master of Computer Application (M.C.A) 2003

Sri Ram Engineering College

Certifications

Diploma in Project Management 2016

ALISON

Professional Diploma in Network Centered Computing 2000

NIIT. [National Institute of Information Technology] – Certification

Technical Skills

Category Software/ Tools / Technology

Frameworks : .Net Framework

Web Programming : ASP.Net, Ajax, ASP, CSS

Database : SQL Server

IDE Tools : VisualStudio.NET

Scripting Languages : JavaScript and VBScript

Markup Languages : XML and HTML

Office Tools : MS-Office Packages

Platform : Window Vista, Window 7

Middleware : Telerik Controls, Adobe Photoshop, Flash.

Personal Details

Date Of Birth

27th Nov, 1977

Marital Status

Married.

Languages Known

English, Tamil, Hindi

Nationality

Indian

Visa Status

Singapore FIN Number

Employment Pass

G6215350X

Declaration

I hereby declare that all the information given above is true to the best of my knowledge. References will be provided upon request.

Contact this candidate