Rishikesh Borse
SQL Developer
Pune
Summary
Results-driven SQL Developer with over 7 years of progressive experience in designing, developing, and optimizing SQL Server databases and applications. Expert in crafting complex SQL queries, stored procedures, and performance tuning to enhance data retrieval efficiency. Proficient in aligning technical solutions with business objectives, ensuring scalable and reliable database architectures. Recognized for strong analytical skills, critical thinking, and a commitment to delivering high-quality, customized solutions that drive operational excellence.
Overview
7
7
years of professional experience
16
16
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
SQL Developer
Peninula Petroleum Data Services
Pune
01.2022 - Current
- Analyzed existing SQL queries to identify opportunities for improvements.
- Performed Query optimizations using query plans.
- Monitored different servers using tools like Red Gate, Solar Winds.
- Developed Stored procedures for CDC(Change Data Capture) that is SQL inbuilt for tracing Audit log on UI.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Refactored SQL codes for performance improvement.
- Designed new tables according to requirement with Normalization.
- Refactored and Rebuild various types of indexes according to fragmentation values.
- Supported projects enabling delivery efficiencies and technical resolution.
- Performed regular database backups to prevent information loss.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Deployed SQL Code in Azure DevOps.
- Followed Coding DBA Standard for SQL code development.
- Followed standard practices for migrating changes to test and production environments.
- Developed reusable components for exploitation in coding and documentation.
- Developed custom database objects, stored procedures and delivered application support.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Designed and implemented TSQL queries for complex solution development.
- Helped plan data extraction and processing tasks, aiding in eventual deployments.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Documented technical database document, analysis results and provided performance improvement feedback.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Developed custom database objects, stored procedures, and delivered application support.
SQL Developer/MSBI Developer
Claptek Pvt Ltd
Mumbai
02.2018 - 12.2021
- Tools like SQL Server Integration Services, Reporting Services for process Automation
- Implemented SSIS data, created maintenance procedures in SQL server and provided data integrity strategies.
- Created SQL Server Agents job for calling Stored procedures according to requirement.
- Queried Logic In PLSQL for Fraud and Risk management reports.
- Created ETL packages using SSIS to move data from various heterogeneous data sources.
- Created logs for ETL load at package level and task level to log number of records processed by each package and each task in package using SSIS.
- Developed custom database objects, stored procedures, functions, views and triggers.
- Implemented error handling and roll back process in SQL Server and Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
- Supported projects enabling delivery efficiencies and technical resolution.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases,
- Developed Reports using efficient data retrieval techniques In sql server and PLSQL
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Worked with major clients like Oriental Bank of Commerce, HDFC Bank, AXIS Bank, Yes Bank Ltd, United Overseas Bank Singapore, Karnataka Bank Ltd, Corporation Bank, SBI Life Insurance Ltd,
- Helped plan data extraction and processing tasks, aiding in eventual deployments.
- Automated routine maintenance tasks through scripting, freeing up valuable time for higher-priority projects.
Education
Bachelor of Engineering (B.E) - Bachelor of Engineering
JSPM’s TSSm COE Pune University
Pune 05.2014 - 06.2017
Diploma -
KBP POLYTECHNIC COLLEGE
Kopargaon 06.2011 - 06.2014
SSC -
Seva Niketan Convent School
Kopargaon 04.2001 - 03.2011
Skills
- Database Development: SQL Server, T-SQL, Stored Procedures, Functions, triggers
- Database Development: Oracle Database (procedures, functions, packages, triggers)
- SQL & Procedural Extensions: T‑SQL, PL/SQL scripting, Dynamic SQL, Exception Handling, Cursors
- Performance Optimization: Query Tuning, Indexing, Execution Plans
- Data Integration: ETL Processes, SSIS Packages, Data Migration
- Data Modeling: Normalization, ER Diagrams, Schema Design
- Reporting & Analysis: SSRS
Certification
MSBI Microsoft Partner Certification
Timeline
SQL Developer
Peninula Petroleum Data Services
01.2022 - Current
SQL SERVER Microsoft Partner Certification
06-2021
MSBI Microsoft Partner Certification
03-2021
SQL Developer/MSBI Developer
Claptek Pvt Ltd
02.2018 - 12.2021
Bachelor of Engineering (B.E) - Bachelor of Engineering
JSPM’s TSSm COE Pune University
05.2014 - 06.2017
Diploma -
KBP POLYTECHNIC COLLEGE
06.2011 - 06.2014
SSC -
Seva Niketan Convent School
04.2001 - 03.2011
Similar Profiles
SANDEEP SUGATHANSANDEEP SUGATHAN
Rotating Equipment Technician at Deladi Petroleum Services Sdn Bhd (Under Brunei Shell Petroleum)Rotating Equipment Technician at Deladi Petroleum Services Sdn Bhd (Under Brunei Shell Petroleum)
BASSAM BAKR MOHAMMEDBASSAM BAKR MOHAMMED
Electrical Technician at Saudi Petroleum Services PolytechnicElectrical Technician at Saudi Petroleum Services Polytechnic
Abdulhakeem Al DhafeeriAbdulhakeem Al Dhafeeri
OPERATIONS SUPERVISOR at National Petroleum ServicesOPERATIONS SUPERVISOR at National Petroleum Services
Komal SatputeKomal Satpute
Azure Data Engineer at Motifworks Inc. – An Accion Labs CompanyAzure Data Engineer at Motifworks Inc. – An Accion Labs Company
MOHIT SINGHMOHIT SINGH
Fiber Network Planner at Tech MahindraFiber Network Planner at Tech Mahindra