Consultant specialist • September-2024 to February-2025
Description: Creating Indexes for performance issues to search the data quickly.Creating Triggers for enhanced validation and business logic management.Creating Functions, Procedure and sequences when ever used. Writing Queries, Sub- queries,Joins.Used Pragma Autonomous Transaction to avoid mutating Problem in database Trigger.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.Using set auto trace on and explain plan for query optimization.Skilled in creating ODI interfaces, packages, scenarios, and integrating with PL/SQL-based validations and workflows.
Lead support Engineer • November-2023 to March-2024
Majesco
Description: Developed and optimized stored procedures, functions, triggers, and views for core banking modules.Handled large-scale data migration using SQL Loader and automated backend jobs with UNIX shell scripts.Improved query performance using Explain Plan, Oracle Hints, and indexing strategies. Implemented business logic through stored procedures and used Pragma Autonomous Transaction for exception handling.Participated in Agile ceremonies, sprint planning, and collaborated with cross- functional teams.Hands-on experience in Oracle Data Integrator (ODI) for designing and implementing ETL solutions including data extraction, transformation, and loading between
Lead consultant • December-2021 to April-2023
Genpact
Description: Designed PL/SQL packages for banking data workflows and validations. Implemented exception handling and optimized query performance. Developed triggers, materialized views, and procedures for finance modules. Worked in Agile mode with Jira for daily stand ups and sprint cycles. Automated data loads using SQL Loader and optimized data flows using Explain Plan and indexing strategies. Integrated UNIX shell scripts for batch j o b e x e c u tio n a n d ale r tin g.W o r k e d in A gile s p rin t s h a n dle d U A T issue fixes and production releases.
Senior PLSQL Developer • March-2021 to July-2021
Wipro
Description: Involved in all day to day activities related to database like data consolidation, data migration scripting.Worked on PL/SQL queries for creating data validation rules.Created complex views, materialized views on multiple tables as per customer requirement.Involved in creating Indexes for faster retrieval of data.Created PL/SQL stored procedures, functions and packages for calculation and database tables joins.Modified existing procedures, functions as per the Project requirements.Worked on SQL* Loader to load data from flat files obtained from various facilities every day.Created Cursors for dynamic operations at various levels as per the requirement.Used bulk collect for mass
Software Engineer • March-2019 to February-2021
TCS
Description: Creating Cluster tables along with index those columns are common in all the tables.Creating Indexes for performance issues to search the data quickly.Creating Triggers for enhanced validation and business logic management Creating Functions, Procedure and sequences whenever used. Writing Queries, Sub-queries, Joins.Using Optimization Hints to improve the query performance. Monitoring the jobs in UC4 Tool. Checking log files in the WINSCP Tool. Creating HPSM
Software Developer • October-2017 to February-2021
Cognizant
Description: Monitoring and Handling the errors and incidents and do further Investigation.Ordering the certificates in ServiceNow for the client’s authentication Purpose. Track the incident Activities and communicating with other teams which is related to the problem. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application Using set auto trace on and explain plan for query optimization Using Optimization Hints to improve the query performance.Resolved production issues by modifying backend code as and when required. Extensively used bulk collection, for all statement in PL/SQL objects for improving the performing.