Software Engineer Senior

UMADEVI THANGAVEL

Senior Software Engineer * 956-***-**** * *******@*****.***

*https://linkedin.com/in/umadevi-thangavel-bb611310b/

SUMMARY

Highly Skilled Senior SQL developer with over 10 years of experience in designing, developing, and optimizing SQL-based solutions for large-scale, high-performance systems.

Expertise in MSSQL, MySQL, and MongoDB and hands on experience in C#.

Databases: MSSQL, PL/SQL, MySQL and MongoDB

Tools & Software: SQL Profiler, SQL Redgate, C# and Power BI (Certification Completed).

ETL: SSIS.

PROFESSIONAL EXPERIENCE

Kloud Portal, Hyderabad (Health Edge Hyderabad) May 2021 – Present

Projects: Supported nearly 40 Health Care clients. (UCare, VCare, CareSource, CareFirst, Humana etc.,)

Responsibilities:

Design, develop and optimize complex SQL queries, stored procedures and triggers for large scale data processing.

Collaborate with business analysts and product managers to understand requirements and deliver effective database solutions.

Mentor junior developers, conduct code reviews and ensure adherence to best practices.

Handles Escalated incidents and problems.

Provided Data Extracts as per Client Request.

Production Support – Worked on L2 tickets

GoAugment Private Ltd., Coimbatore July 2019 - Apr 2021

Projects: WILMIC - USA, Evident Change (National Council on Crime and Delinquency)- USA

Responsibilities:

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

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.

LantraSoft Inc. Coimbatore Sep 2014 to Sep 2019

Projects: Esurance, USA, Rally for River, ISHA

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.

•Schema design, Index rebuilds and Maintenance.

Ramco Systems Ltd., Chennai Sep 2010 to Jan 2013

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

Contact this candidate