Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Area Of Expertise
Timeline
Generic

Kapil Khot

Kolhapur

Summary

Experienced and detail-oriented Database Developer with 5 years of expertise in SQL Server Management Studio (SSMS), database design, optimization, and T-SQL development. Seeking to leverage my skills in database architecture, performance tuning, and data integrity to contribute to innovative and data-driven solutions within a dynamic organization.

  • Lead team in all phases of Development, implementation and support cycle.
  • Having good knowledge and experience of RDBMS concepts
  • Experienced in phases of the Development Lifecycle (Design, Development, Testing, Issue Resolution).

Overview

5
5
years of professional experience
1
1
Certification

Work History

Sr. Database Developer

D2K Technologies
Mumbai
06.2023 - Current
  • Company Overview: We are seeking a highly skilled and detail-oriented Database Developer with experience in the banking domain, particularly in Non-Performing Assets (NPA) management systems.
  • Supported UAT and production deployments, ensuring data consistency, backup readiness, and rollback mechanisms.
  • As a Database Developer, I was responsible for designing and implementing database solutions as per the bank's Business Requirement Documents (BRDs) for the Change Order Raiser module.
  • Monitored and resolved real-time production issues, including failed jobs, data mismatches, and performance slowdowns.
  • Analyze and diagnose root causes of data inconsistencies, query performance degradation, and system errors using tools like SQL Server Profiler, execution plans, and error logs.
  • Designed and developed user interface screens incorporating a 2-level Maker-Checker workflow to ensure robust internal control and regulatory compliance, aligned with the bank's specific requirements.
  • We are seeking a highly skilled and detail-oriented Database Developer with experience in the banking domain, particularly in Non-Performing Assets (NPA) management systems.

Software Engineer

CitiusTech Healthcare Technology Solutions
Pune
09.2022 - 03.2023
  • Company Overview: BI Clinical is a product of CitiusTech which is used by Provider Markets i.e., individual health professional or a health facility organization.
  • Creating and monitoring all SQL server agent jobs, check overlapping jobs and change run time as needed.
  • Initiated deployment to QA and production environments, post required testing evidence and approvals.
  • Writing complex SQL queries, Unions, Multiple tables Joins, Creating Tables, Views, and Stored Procedures.
  • Working with the development team for bug fixes and debugging.
  • BI Clinical is a product of CitiusTech which is used by Provider Markets i.e., individual health professional or a health facility organization.

Database Developer

DSoft Infosystem
Pune
08.2019 - 08.2022
  • Company Overview: Enterprise resource planning (ERP) refers to a type of software those organizations use to manage day-to-day business activities such as accounting, purchase, order, billing, salary, attendance, stock, and supply chain operations etc.
  • Implement various simple SQL Query.
  • Co-ordinate with customer related query.
  • Extract data from SQL server as per the business requirement.
  • Create complex functions, scripts, stored procedures and triggers to support application development.
  • Fix any issues related to database performance and provide corrective measures.
  • Enterprise resource planning (ERP) refers to a type of software those organizations use to manage day-to-day business activities such as accounting, purchase, order, billing, salary, attendance, stock, and supply chain operations etc.

Education

Mechanical Engineering -

W. I. T. Soalpur
Solapur, India
05.2015

Skills

  • T-SQL
  • Stored Procedures
  • MSBI-ETL Tool (SSIS)
  • SQL Reporting services
  • Git-GitHub
  • Microsoft Excel
  • tableau

Certification

  • Certification in Data Science, 02/01/22
  • Data Visualization using Tableau Program, 03/01/22

Personal Information

  • Title: Sr. Database Developer
  • Date of Birth: 08/12/92
  • Marital Status: Married

Area Of Expertise

  • Experience in using sub-query, CTE, temp tables, Table Variable.
  • Expertise in writing T-SQL queries, sub-queries, joins for generating, Stored Procedures, Functions, Views.
  • Experience in SQL indexes, SQL server query execution plan, and SQL query optimization.
  • Supported team in resolving SQL Reporting services.
  • Created and modified ETL packages to extract and Load data from different source system.
  • Git-GitHub

Timeline

Sr. Database Developer

D2K Technologies
06.2023 - Current

Software Engineer

CitiusTech Healthcare Technology Solutions
09.2022 - 03.2023

Database Developer

DSoft Infosystem
08.2019 - 08.2022

Mechanical Engineering -

W. I. T. Soalpur

Similar Profiles

CREATE PROFILE
Kapil Khot