UMADEVI P T +91-956*******

Senior Software Engineer adnxk6@r.postjobfree.com, Coimbatore

Summary

Overall 6.5 years of experience in SQL development. Well versed in writing complex stored procedures, Function, Views, and Performance Tuning. Ability to work independently and manage multiple tasks concurrently. Fast or Quick learner & easily get attached to any circumstances.

Skills

•SQL server 2005, 2008, 2012, 2017 and 2019.

•Basic knowledge in SSRS and Oracle.

•Hands on experience in C# and Web API.

•Hands on experience in MongoDB and MySql.

•C, C++

Tools

•SQL Profiler and SQL Server Agent.

•JIRA.

•Visual Source Safe

•GIT

Working Experience

GoAugment Private Ltd, Coimbatore.

07/2019 Onwards

Evident Change (National Council on Crime and Delinquency), USA

Responsibilities:

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

•Worked in agile methodology.

•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.

Lantrasoft Inc. Coimbatore.

09/2014 to 09/2017

Esurance, USA

Responsibilities:

•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.

CCMC water management (IOT technology), TWAD Board

Responsibilities:

•Schema design.

•Index rebuilds and Maintenance.

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

•Query fine tuning.

Rally for River, ISHA

Responsibilities:

•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.

Ramco Systems Ltd, Chennai.

09/2010 to 01/2013

WSL (Integrated Forestry information system - IFIS), Switzerland,

IMO (Electronic Money Orders), Indian Postal Department

Responsibilities:

•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.

Education Details

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

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

Awards

•Best Performer Award – Got this award for Esurance in the year 2016

•University Rank Holder – Got 7th place in Trichy Anna University zone in MCA.

Declaration

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 : 13.03.2021 (P.T. Umadevi)

Contact this candidate