RESUME

S.S.Lakshmanan ***, New Kumaran nagar Sholinganallur,

E-mail id : adm4q2@r.postjobfree.com Chennai-600119.

Contact no.: +91-984*******

Experience Summary:

8+ years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using SQL (MSSQL).

Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, Cursors, Derived tables, Common Table Expressions (CTEs) and Complex Queries on Microsoft SQL Server 2016/2014/2012/2008R2/2008/2005.

Preparing reports using SSRS,SSIS and Tableau.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Finding Queries Slowness and Tuning The Stored Procedures.

Established knowledge in SQL, stored procedures and functions.

Experience in working at all stages of project life cycle and advancement of project goals, including development, testing.

An ambitious and confident individual, with drive to achieve and excel on given targets.

Sound communicator with good analytical, problem solving & organizational abilities.

Be optimally utilized towards the growth of the organization and myself with unanimous strength and moral fiber.

Seeking assignments in Software Testing with leading IT companies.

EDUCATIONAL QUALIFICATIONS:

Post Graduate : MCA

AVC College (Autonomous)

University of Bharathidasan

Year of passing: 2011

Aggregate : 69

Under Graduate : BSC(CS)

Meenakshi Ramasami Arts & Science College

University of Bharathidasan,

Year of passing: 2008

Aggregate : 68

Higher Secondary : DVC.Higher Secondary School, Srimushnam

State Board of Tamilnadu,

Year of passing: 2005

Aggregate : 75

S.S.L.C : DVC Higher Secondary School,

Srimushnam.

Year of passing: 2003

Aggregate : 80

Technical Skills

Languages

MS SQL,SSRS,SSIS,Tableau, HTML,MS Excel

Databases

SQL Server-2018,

IDE Tools

Eclipse3.1

Servers

Tomcat5.5, WebLogic

Operating Systems

Windows 98/2000/XP,Unix.

PROFESSIONAL EXPERIENCE

HDFC Bank Pvt Ltd, Chennai Sep 2019-Present

Deputy Manager

Responsibilities

Writing SQL Queries, Stored Procedures, Functions and Views.

Developing Reports using SSRS,SSIS and Tableau.

Performance Tuning Application Performance.

Creating Data models for new Requirements.

Maintaining Data Base (Backup, Archive Records)

Maintaining Server (Tracking Driver and DB Spaces, Service configuration)

Caredata InfoMatics Private Ltd, Chennai Sep 2016 – Sep 2019

MS SQL Developer

Responsibilities

Writing SQL Server Queries, Stored Procedures.

Performance Tuning Application Performance.

Creating Data models for new Requirements.

Maintaining Data Base (Backup, Archive Records)

Supporting for Live Customers

Project:

CAREDATA Infomatics, a leading healthcare technology organization that offers solutions to enhance patient care and optimize clinical processes in laboratories and hospitals.

CARE LabTrak (LABORATORY INFORMATION SYSTEM)

Cloud based Lab Management system CARE LabTrak helps you to bring orderliness into your workflow and enables you to monitor and take corrective actions and continuous improvement at all the stages of lab process right from sample collection to dispatch of results. Every feature is designed with the intent of improving the clinical accuracy, improving the revenue/efficiency & reducing the cost.

Emporis Academy Private Limited(Microsoft Partner), Chennai Jul 2015 – Jun2016

SSRS Report Developer

Client: DarRiyal, Saudhi

Responsibilities

SSRS,SSAS Report developer.

Writing SQL Server Queries, Stored Procedures.

Tuning reports Performance.

Writing procedures and triggers for integration process.

Project:

DarRiyal Report developed

We are developing SSRS Reports using MS SQL Queries, Performance tuning and Maintaining developed Reports.

Bartronics Global Solutions, Chennai Sep 2014 – May 2015

MS SQL Developer

Client: Ramco Systems, Chennai (On Contract)

Responsibilities

Performing Query Performance Tuning.

Writing SQL Server Queries, Stored Procedures, Triggers.

Writing distributed Queries across the databases.

Writing procedures and triggers for integration process.

Project:

Ramco on Demand ERP (HCM):

We developing and Integrating Human Capital Management module into the Ramco ERP Product. We developed various modules under the Capital Management Systems such as Payroll, Tax, Finance, Employee Self Service etc.

First Source Solution Ltd., (Chennai) Dec 2011 – Sep 2014

SQL Developer

Client: Bharathi Airtel Ltd.

Responsibilities

Create the Form and Application, Design the dashboard and share to client through mail.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

Also created, modified, maintained and optimized SQL server database.

Maintained the documents and create reports for the business analysts and end-users.

Responsible for the management of the database performance, backup, replication, capacity and security.

Project:

AIRTELMONEY - U&R

U&R means User and Revenue. Here we have to analyses the customer’s transactions and top up. Find the first and last transaction of every month if they did transactions means which transaction they have done like prepaid recharge or postpaid recharge or movie etc. Then find first cash in and last cash in if they did then find the retailer who has done the recharge customer. Etc…

PERSONAL PROFILE:

Name : S.S.Lakshmanan

Fathers Name : Mr.S.Selvarasu Date of Birth : 02.04.1988

Sex : Male

Nationality : Indian

Languages Known : English and Tamil

Strengths : Positive Attitude and Smart Working

Hobbies : Reading Books and Listening to Music

DECLARATION

I (Lakshmanan.S.S), here by declare that the above furnished information is true to the best of my knowledge.

Date: Signature

Place: [LAKSHMANAN.S.S]

Contact this candidate