ROHIT SAHANI
Software developer
Navi Mumbai,Maharashtra
Summary
Experienced PL-SQL developer with 2.7 years of progressive expertise in Oracle, databases, and application programming. Committed to developing customized technical solutions that align with operational needs and objectives. Recognized as a critical thinker, analyst, and problem solver, consistently delivering high-quality products in diverse business environments.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
PL-SQL Developer
FIGMENT GLOBAL SOLUTIONS Pvt Ltd
NAVI MUMBAI
12.2023 - Current
- Database Development: Designed, developed, and maintained efficient PL-SQL scripts, stored procedures, functions, collections, and triggers, improving database performance.
- Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
- Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
- Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
- Increased application stability by troubleshooting and resolving complex PL/SQL issues in timely manner.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed custom database objects, stored procedures and delivered application support.
- Improved database performance by optimizing PL/SQL code and implementing best practices.
Database Developer
LIGHTHOUSE INFO SYSTEMS PVT LTD
NAGPUR
02.2022 - 09.2023
- Assisted senior developers in creating, optimizing, and maintaining PL/SQL scripts, stored procedures, and packages.
- Developed scripts and processes for data integration and maintenance.
- Built databases and table structures for web applications.
- Wrote complex SQL queries and PL/SQL procedures for data extraction and manipulation from various sources.
- Optimized database performance by implementing efficient indexing strategies and query optimizations.
- Identified issues within databases, performed troubleshooting and implemented effective solutions.
- Debugged and resolved database issues in production environment, improving system uptime and reliability.
- Evaluated, designed, implemented, and modified databases and database applications.
Education
Bachelor of Science - Information Technology
Renaissance College of Information Technology
Nagpur, India 05.2019 - 05.2022
Master of Science - Computer Science
Seth Kesarimal Porwal College
Nagpur, India 05.2023 - 05.2024
Skills
Advanced PL and SQL programming
Triggers and functions
Performance Tuning Techniques
Agile development methodologies
SQL Query Optimization
Error Handling and Debugging
Materialized Views Management
PL and SQL Collections Handling
Partitioning and Indexing
Stored procedures development
Dynamic SQL Expertise
XML and JSON Processing
SQL development
Database Development
RDMS Development
Code debugging
Software development proficiency
Problem-Solving
Projects
TAXCPC, is a TDS return filing utility online system that helps to manage TDS return preparation & filing and ensure that every TDS return filed is processed multiple levels so that no default or Errors are committed during a post-filing. TAXCPC provides smart solutions for enterprises to simplify their tax filing. Started in 2012 by three chartered accountants, today, TAXCPC has gone to become a leader in consulting, technology, and taxation services.
Timeline
PL-SQL Developer
FIGMENT GLOBAL SOLUTIONS Pvt Ltd
12.2023 - Current
Master of Science - Computer Science
Seth Kesarimal Porwal College
05.2023 - 05.2024
Database Developer
LIGHTHOUSE INFO SYSTEMS PVT LTD
02.2022 - 09.2023
Bachelor of Science - Information Technology
Renaissance College of Information Technology
05.2019 - 05.2022