Mohanabalan N
Summary
A highly skilled SQL Developer with an extensive experience of 7+ years in the IT field. Proven ability to design, develop and maintain complex databases while ensuring data integrity and security.
Overview
7
7
years of professional experience
Work History
Software Developer
Quintessence Business Solutions & Services(QBSS)
04.2021 - Current
- Involved in performance tuning using Indexes and Query execution plans.
- Involved in the creation and execution of complex stored procedures.
- Extensively used joins and sub queries. Worked in CTE, global and temp table.
- Traced and fixed bugs in the stored procedures using SQL Profiler.
- Working with database and support team to perform data migration, code
automation and production support. - Discussed issues with team members to provide resolution and apply best practices.
Technical Engineer
Novac Technology Solutions
10.2017 - 03.2021
- Used SQL Profiler to monitor SQL Server activities, provide insights on the overall health and identified elements that affect the performance of SQL instances
- Identified the bugs using SQL Profiler and resolved the bugs within the given time.
- Provided exceptional technical support, addressing client concerns and ensuring their needs were met.
- Helped the business team with the weekly and monthly report generation.
- Collaborated with the product development team to identify and resolve recurring software bugs and improved product stability.
- Documented the standard procedures in the form of notes and manuals.
Education
MCA -
Institute of Road And Transport Technology (IRTT)
Erode01.2016
B.SC (CS) -
Kongu Arts & Science College
Erode01.2013
HSC -
Carmel Matriculation Higher Secondary School
Erode01.2010
SSLC -
Sengunthar Higher Secondary School
Erode01.2008
Skills
SQL
MySQL
T-SQL
Performance Tuning
SQL Profiler
Production Support
Complex Stored Procedure
Linux
Technical Summary
- Ability to guide and mentor the team in the critical issues.
- Ability to do performance tuning to increase the performance.
- Created and executed the complex stored procedures based on the requirement.
- Used SQL Profiler to monitor SQL Server activities, provide insights on the overall health and identified elements that affect the performance of SQL instances. Traced and fixed bugs in the stored procedures using SQL Profiler.
- Worked with database and support team to perform data migration, code automation and production support.
Languages
English
Tamil
Personal Information
- Date of Birth: 06/25/1993
- Gender: Male
- Marital Status: Married
Timeline
Software Developer
Quintessence Business Solutions & Services(QBSS)
04.2021 - Current
Technical Engineer
Novac Technology Solutions
10.2017 - 03.2021
MCA -
Institute of Road And Transport Technology (IRTT)
B.SC (CS) -
Kongu Arts & Science College
HSC -
Carmel Matriculation Higher Secondary School
SSLC -
Sengunthar Higher Secondary School
Similar Profiles
Naveenraj PNaveenraj P
Team Leader - Quality Department at Quintessence Business Solutions & ServicesTeam Leader - Quality Department at Quintessence Business Solutions & Services
Ananthi NagarajAnanthi Nagaraj
AR Analyst at Quintessence Business Solutions & ServicesAR Analyst at Quintessence Business Solutions & Services
Pooja Udayan KPPooja Udayan KP
Senior Medical Coder at Quintessence Business Solutions & ServicesSenior Medical Coder at Quintessence Business Solutions & Services