Sign in

Customer Care Analyst

Coimbatore, Tamil Nadu, India
September 23, 2020

Contact this candidate




•Overall *.* years of experience in IT Industries.

•Extensive experience with SQL server 2005, 2008, 2012 and 2017.

•Strong knowledge in complex query design, stored procedures, views.

•Strong knowledge in writing functions.

•Strong knowledge in migrating Oracle to SQL.

•Expertise in Performance Tuning.

•Excellent understanding of database structure, principles, theories and T-SQL Coding.

•Experienced in using SQL Server Profiler and SQL Server Agent.

•Responsible for day to day tasks like backup and recovery.

•Basic knowledge in SSRS.

•Basic knowledge in Oracle.

•Working Knowledge in Software development tool like Jira and GIT repository like Source tree.

•Hands on experience in C# and Web API.

•Great expertise in Requirement analysis, Functional specification, Data model creation and Project planning.

•Hands on experience in MongoDB and MySql.

•Great problem solving and analytical skills.

•Willing to learn new technologies.

Working Experience

Sep 2010 – Jan 2013 - Analyst programmer - Ramco Systems Ltd, Chennai

Sep 2014 – Sep 2017 - Senior System Analyst - Lantrasoft, Coimbatore

Jul 2019 onwards - Senior Programmer Analyst - GoAugment Pvt Ltd, Coimbatore


Project 1:

Project Name : WSL (Integrated Forestry information system - IFIS)

Client : Switzerland

Environment : RVW 2.0, SQL Server 2005

Tool : Visual Source Safe

Duration : June 2011– January 2013

Role : Analyst Programmer

Team Size : 4

Company : Ramco Systems Ltd.

Project 2:

Project Name : IMO (Electronic Money Orders)

Client : Indian Postal Department

Database : SQL Server 2005

Duration : December 2010 to June 2011

Role : Developer

Team Size : 3

Company : Ramco Systems Ltd.


•Involved in analysis, design, coding, Implementation and testing.

•Designed new User Interface as per the customer requirements.

•Involved in developing new stored procedures, functions, triggers & performance tuning for better results.

•Involved in customer online support and scheduled SQL jobs periodically as per their needs.

•Prepared documentation like Business Requirement document and Unit Test case document.

Project 3:

Project Name : Esurance

Client : United States

Database : SQL Server 2012

Role : System Analyst, Senior System Analyst

Team Size : 7

Company : Lantrasoft Inc.


•Accountable maintenance in the quality of a defined set of data.

•Worked on Business Intelligent Request raised by other departments like Sales, Billing, Claim and Customer care etc.

•Cleared transaction level errors for a policy.

•Worked on SQL Server 2008 and 2012.

•Developed complex stored procedures, Functions.

•Handled incidents.

•Worked on Ghost policies.

Project 4:

Project Name : CCMC water management (Iot technology)

Client : TWAD Board, Coimbatore

Database : MongoDB 1.3

Role : Database Administrator

Team Size : 6

Company : Lantrasoft Inc.


•Schema design.

•Index rebuilds and Maintenance.

•Database migration by means of changing the document level structure in a large manner

•Query fine tuning.

•Worked closely and efficiently with all levels of management to satisfy project and productivity requirements, offered logical, forthright thinking and is able to provide effective solutions to solve difficult problems.

Project 5:

Project Name : Rally for River

Client : ISHA

Database : MySql

Role : Developer

Team Size : 5

Company : Lantrasoft Inc.


•Organizing the requirement analysis, functional specification, data model creation, Project planning, release planning.

•Schema design

•Writing best practices query level documents for dev/App teams.

Project 6:

Project Name : National Council on Crime and Delinquency (NCCD)

Client : USA

Database : MSSQL 2019, PL/SQL

Tool : Tortoise GIT, Source tree

Role : Developer

Team Size : 8

Company : GoAugment Private Ltd.


•Worked in migration of existing PLSQL objects to TSQL (SQL server).

•Worked in agile methodology.

•Analysing and solving the Migration Requirement assigned to me in JIRA.

•Doing manual coding migration for stored procedures, functions, cursors and arrays with SSMS developing tool.

•Worked with all objects -table, index, procedures, functions, TVF, scalar function.

•Used JIRA -SC board for requirement tracking.

•Used Bitbucket for repositories and Version control.

•Used Bitbucket confluence for gathering information about existing issue, project description and common issues in detail.

•Used Source tree, GIT bash and tortoise git for version control activity.

•Worked in aggregate and analytical function based query like MAX, Keep dense rank, Row_number over partition by.

Education Details

•MCA – P.S.N.A College of Engineering & Technology – 2010 (87%)

•B Sc. (Maths) – Gandhigram Rural Institute – 2007 (83%)

•HSC – St. Joseph Girls Higher Secondary School – 2004 (90%)

•SSLC – St. Joseph Girls Higher Secondary School – 2002 (96%)

Personal Details

Mobile : +91 – 956-***-****

Email :

Address : No.56 KPS Residency IInd Floor, Railway line -2, Lakshmipuram, Ganapathy, Coimbatore-641 006, Tamil Nadu


I consider myself familiar with the Information Technology aspects. I am also confident of my ability to work in a team.

I hereby declare that the information furnished by me above is true to the best of my knowledge.

Place : Coimbatore

Date : 23.09.2020 (P.T. Umadevi)

Contact this candidate