User

Oracle Developer

BMT Score
86
86%
  • Remote

Available for

About Jaya H

Developed complex database objects like Stored Procedures, Functions, Packages and Triggers.  

Created and maintained Tables, Views, Materialized views, Constraints and used Predefined and advanced Data types.  

Extensively worked on Cursors and Ref-Cursors for processing the data.  

Proficient in using Bulk Collect with Bulk Bind to efficiently process large volumes of data.  

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.  

Used Bind Variables while writing Dynamic SQL to improve performance.  

Participated in Performance enhancing activities such as PL/SQL block tuning, Application tuning and Query tuning.  

Loaded bulk amount of data into database tables using SQL*Loader from Flat files.  

Having good experience in Level 1 and Level 2 support and worked in both Incident and Problem management.  

Tech Stack Expertise

  • Tech Stack Expertise

    Repository Tools

    Git,JIRA

    4 Years

Work Experience

Images

Oracle Developer

  • January 2019 - June 2023 - 4 Year
  • India

Projects

Images

Account Processing System (APS)

  • March 2021 - July 2023 - 29 Months
Technologies
Role & Responsibility
    This project module will cover retail and corporate banking where we manage and process customer accounts and transactions and responsible for maintaining and updating the account system, fixing bugs and errors as per business requirements and ensuring that it provides fast and accurate account processing even under heavy traffic             loads.  

      
    RESPONSIBILITIES:  

      Coordinated with the front-end and testing team to analyze the defects and resolve the defects raised.  

    Optimize the system's performance by fine-tuning the database queries using indexing, caching and other optimization techniques.  

    Created the Jobs and Procedure to generate reports according to the business requirements.  

    Conducted code reviews and implemented code improvements.  

    Provided Production Support for the tickets raised by the end users.  
...see less
Images

Pricing And Quotation

  • August 2019 - February 2021 - 19 Months
Technologies
Role & Responsibility
    This module will generate prices and quotes for shipping and transportation services based on different transport modes, travel distances, shipment sizes and other related items. We managed it by routinely maintaining and updating services based on requirements, fixing bugs and ensure that module remains up-todate with evolving logistics requirements.  
    RESPONSIBILITIES:  

    Maintain and update it as per requirements to ensure it is functioning correctly and providing accurate pricing and quotes.  

    Work with other developers to ensure that it is scalable and can handle increased user demand.  

    Written complex SQL queries using Joins, Sub-Query, Group and Analytical functions to retrieve data from the database to generate reports based on user requirements.  

    Used Triggers to update the pricing information when there are changes to the shipment details.  
...see less

Industry Expertise

Education

Education

in Bachelor Degree in Engineerin

Pune University
  • May 2016 - June 2018

Our Suggestions