Rohit Gaikwad

PL/SQL Developer

• Job Details:Developed and optimized PL/SQL stored procedures, functions, and packages to enhance system performance by 30%. Collaborated with cross-functional teams to gather requirements and design database solutions that align with business needs. Implemented database triggers and complex queries to automate data processing tasks, reducing manual effort by 40%. Conducted performance tuning on existing SQL queries and PL/SQL code, achieving significant improvements in execution times. Created ETL process to load clean data from external sources like relational table, flat files, etc. Developed new SSRS report to reduce manual efforts by 100% as per client requirement. Converted Oracle report to SSRS report to provide the multiple file format option to user. Enhanced, debugged and analyzing the Oracle form and Oracle report to fulfill user requirement. Developed SSRS subscription on SSRS report to reduce the manual effort by 100%. Analysis of business requirement, share impact analysis and require changes, create the estimated time for changes. Involved in code validations with junior developer to ensure the database integrity. Prepared audit document for user to reduce the efforts as part of quarterly or monthly audit. Prepared test case documents for user to reduce their effort by 10%. Ability to work effectively as a member of a team and make decisions including the prioritize tasks effectively.