Mayur Pawar
Mumbai
Summary
Self-motivated, peak-performing, with 5.10+ years of relevant experience in the IT industry, and strong knowledge and experience in development and database management. Experience in interacting with various business stakeholders and being able to gather business specifications and translate them into platforms.
Overview
6
6
years of professional experience
Work History
Sr. MS SQL Developer
IKS HealthCare
Mumbai
08.2022 - Current
- Developed stored procedures, T-SQL scripts, functions, and triggers to support application requirements.
- Performed backup and recovery of databases on a regular basis.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Implemented data migration from legacy systems to new databases.
- Worked on Dedlock issues in databases/server in real-time basis.
SQL Developer
Nelito Software Solutions
Mumbai
07.2021 - 08.2022
- Configuring and using SQL Agent and other tools for constant, latest data updating and data processing, for giving accurate, live market data output on the front end.
- Developing and maintaining reports and menus on the front end.
- Creating DML and DDL queries for importing bulk data with high time efficiency.
- Performance tuning and error solving.
SQL Developer
TechExcel Software Solution
Mumbai
11.2020 - 07.2021
- Database migration.
- Developing stored procedures for performing huge bulk data conversion from Fincraft CBS to Pinnacle CBS.
- Performance tuning and error solving.
- Catering and solving logic-based queries.
- Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
Data Analyst
Ugam Solutions
THANE
01.2019 - 11.2020
- Participated in software evaluation and selection, business requirements analysis, and application integration. Functional and technical document preparation.
- Database migration.
- Creating API based on client requirement.
Education
Bachelor of Science - Computer Science
B.N. Bandodker College of Science
Mumbai07-2018
HSC - Science Education
Janana Sarita School And Jr Clg
Mumbai04-2015
SSC -
Raja Shivaji VidyaMandir
Thane03-2013
Skills
- Relational databases
- Performance Improvements
- Data Validation
- Data Migration
- Performance Tuning
- Database Development
- SSMS, SSIS, SSRS
- Database Design
Accomplishments
- In IKS healthcare I received employee of the year award.
Languages
Hindi
First Language
Marathi
Advanced (C1)
C1
English
Advanced (C1)
C1
Timeline
Sr. MS SQL Developer
IKS HealthCare
08.2022 - Current
SQL Developer
Nelito Software Solutions
07.2021 - 08.2022
SQL Developer
TechExcel Software Solution
11.2020 - 07.2021
Data Analyst
Ugam Solutions
01.2019 - 11.2020
Bachelor of Science - Computer Science
B.N. Bandodker College of Science
HSC - Science Education
Janana Sarita School And Jr Clg
SSC -
Raja Shivaji VidyaMandir
Similar Profiles
MADHUMATHI RAJESHMADHUMATHI RAJESH
Director Data Science at IKS HealthcareDirector Data Science at IKS Healthcare
Jonathan LamechJonathan Lamech
Director - Client Relations (Revenue Cycle Management) at IKS HealthcareDirector - Client Relations (Revenue Cycle Management) at IKS Healthcare
Sachin Sachin null
Payment Posting Process at IKS Healthcare Insurance Pvt LimitedPayment Posting Process at IKS Healthcare Insurance Pvt Limited