Sql Server Manager

AMAL ADHARSH RAJ A

Email id: ********@*****.*** Plot No: 84, Flat F3, 1st Floor,

Mobile:+91-995**-***** Akshaya Apartments, 2nd Main Road

Alwarthirunagar Annexe,

Chennai, Pin code: 600087

TamilNadu(State),

India(Country)

Objective

Intend to build a career with leading corporate of hi-tech environment with committed & dedicated professionals, which will help me to explore myself fully and realize my potential. Willing to work as a key player in challenging & creative environment.

Professional Summary

5.3 Years of total work experience in SQL Server 2005,2008 R2,2012.

As Technical Consultant for HRMS & Payroll Modules in

Ramco 3X Application.

Very good experience in Installation, configuration and maintenance of SQL Server.

Excellent T-SQL programming skills. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

Knowledge of Data Migration & Transformation, Reporting Services and SQL Server Clustering.

Experience in writing complex SQL queries and optimizing the queries in SQL Server 2005,2008 R2.

Knowledge and good work experience in RDBMS concepts, Tables, Views, Stored Procedures, Indexes, and User defined data types & Functions and Constraints.

Work Experience

Company Name : Ramco Systems Limited

Designation : System Analyst

Duration : April 01, 2011 to Till Date

Project -1 Ramco Systems Limited

Client - 1 : ASEAN Specific Clients

Technology : SQL Server 2000, 2005 and 2008 R2

Tools : Ramco Report Writer, RVW 3.0

Role : Database Developer and Support Engineer for technical issues

Team Size : 4

Duration : April 2011 – Till date

Functional Areas : HRMS, Payroll & Leave Modules

Description

Creating Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, user defined data types and functions.

Optimizing the Existing procedures and functions.

Trouble shooting problems by using SQL Server Profiler.

Provided production support for the Database and application issues.

Statutory changes can be done in yearend activities.

Involving in Client call and provide the resolutions.

Since it is an ERP application and the aim is to develop and Support the Human Resource Management based module such as leave, Payroll, Personnel, Time management by using Dot Net, Html as front end and SQL Server as back end connection.

Involved in support activities based on the client’s request such as:

End to End support to Ramco HRMS application for ASC, they are utilizing our Ramco Payroll application to process payroll to their vendors.

Vendors are from various parts of Asia pacific region namely: Singapore, Malaysia, China, Indonesia, Thailand, Philippines, Taiwan, Brunei and India. Based on the issues raised, we provide either clarification or fixes on priority basis

Project - 2 @ Ramco Systems Limited

Client – 2 : TYCO International-Singapore

Technology : SQL Server 2000, 2005 and 2008 R2

Tools : RVW 3.0

Role : As a Team Member worked as Analyst at Client Site, Complete live

Database handling, Data Migration, Updating with history table and Report generation.

Team Size : 2 members

Functional Areas : HRMS, Payroll

Duration : September 2014 to January 2015

Description

Web Based Application enabling following tasks:

The leave administration processes such as Leave definition, Leave entitlement, Leave requisition / approval, Leave encashment and carry over.

It also provides employee availability information to other modules in Ramco Personnel based on leaves approved.

The Ramco Employee Self Service (ESS) module would enable employees to request and submit leave application for approval. Supervisors / Managers, or HR admin users can approve or reject the employee’s applications using the Manager Self Service (MSS) screens or HR Self.

Project - 3 @ Ramco Systems Limited

Client – 3 : IBM International-Singapore

Technology : SQL Server 2000, 2005 and 2008 R2

Tools : RVW 3.0

Role : As a Team Member worked as Analyst at Client Site, Complete live

Data Migration, Construction, Testing Activities and Go Live Setup in Client Servers

Team Size : 4 members

Functional Areas : HRMS, Payroll

Duration : September 2014 to May 2015

Description

Web Based Application enabling following tasks:

The leave administration processes such as Leave definition, Leave entitlement, Leave requisition / approval, Leave encashment and carry over.

It also provides employee availability information to other modules in Ramco Personnel based on leaves approved.

The Ramco Employee Self Service (ESS) module would enable employees to request and submit leave application for approval. Supervisors / Managers, or HR admin users can approve or reject the employee’s applications using the Manager Self Service (MSS) screens or HR Self.

Education Details

Course

Institute

Duration

Marks

M. Sc - IT

Annamalai University

2005 – 2010

86%

HSC

Vaidheeswara Hr. Sec School

2003 – 2005

73%

SSLC

Vaidheeswara Hr. Sec School

2002 - 2003

90%

Technical Skills

Business Tools : Ramco\ e.Applications 3x, Ramco ESS

Operating Systems : Windows XP, Windows 7 & 8, Windows XP Service Packs

Database : RDBMS, SQL Server 2000, 2005, 2008, 2008 R2

Strengths

Honest & Patience

Hard working

Good Interpersonal Skills and Communication

Personal Details

Passport Number : Z3036037

Date of Birth : August 29, 1987

Gender : Male

Marital Status : Single

Linguistic Skills : English & Tamil

Father’s Name : Mr. T. Arokia Raj

Permanent Address : A – 22, Ghatam Street, Block 11, Neyveli Township

Pin code: 607 803.

Tamil Nadu, India

Declaration

I consider myself familiar with information technology aspects. I am also confident of my ability to work in a team or as an individual. I hereby declare that the information furnished above are true to the best of my knowledge and belief.

Date: Yours Truly,

Place: Chennai

(Amal Adharsh Raj. A)

Contact this candidate