User

Oracle Developer

BMT Score
86
86%
  • Remote

Available for

About Bala V

Having 6+ Years of experience in Oracle Development and L1 Production Support.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design,
development, testing, implementation and maintenance with timely delivery against
aggressive deadlines.

Strong RDBMS concepts including expertise in using DDL, DML, DCL, TCL Statements in
Oracle SQL.

Strong Knowledge in writing complex queries which includes joins, sub query, group
functions, set operators and analytical functions.

Design, Develop and maintain Oracle database objects like Stored Procedures, Functions,
Packages, Dynamic SQL, Records and Triggers using SQL and PLSQL.
Experience in retrieving data from external data files and loaded into oracle tables using
tools like SQL Loader and External Tables.

Extensively used Cursor to fetch multiple records from table inside the PL/SQL block and
exceptions to handle the error.

Experience in application development using various advanced features of Oracle like
Collections, Pragma Autonomous Transactions and Exception handling.

Having good knowledge in bulk collections (FORALL, LIMIT, BULK EXCEPTION HANDLING) for
better performance and easy retrieval of data, by reducing context switching between SQL
and PL/SQL engines.

Good Knowledge in data performance tuning and Optimization of SQL statements using
Explain plan, Index, Oracle Hints, Table Partitioning.

Having good knowledge in Supplied Packages (UTL_FILE, DBMS_MVIEW, DBMS_PROFILER,
DBMS_UTLILITY, DBMS_RANDOM, DBMS_STATS).
Having Experience in Debugging by using Error Log.
 

Tech Stack Expertise

  • Tech Stack Expertise

    Repository Tools

    JIRA

    0 Years
  • Tech Stack Expertise

    Operating Systems

    Window

    0 Years
  • Tech Stack Expertise

    Oracle

    Oracle 11G,Oracle 12C,Oracle 10G,Oracle

    5 Years

Work Experience

Images

Oracle Developer

  • January 2015 - July 2023 - 8 Year
  • India

Projects

Images

XYZ

  • October 2022 - July 2023 - 10 Months
Technologies
Role & Responsibility
    FXO (or FXO admin) is the BO application for FOREX (FX) and Money Market (MM) products for
    ALM and Fixed income departments. The system is available for back office 23 hours a day. It is
    fully integrated real – time settlement system covers the four big steps that a Back Office
    system need to do:
    Announcements, Confirmations, Payments, Accounting
    Hence, through FXO Webfx (User interface), user can:
    Consult transactions booked by Front Office (FO)
    Manage trade confirmations
    Manage trade payments
    Manage trade accounting
    Manage counterparty static data

     
    RESPONSIBILITIES: 

    Analyze the business Process flows, Gathering requirements, Design and documents the requirements. Create different format reports as per user requirements. 

    Experience with Cursors, Collections, Arrays, Views, triggers, SQL Loader, Merge, links, Set Operations, Loops and Exception Handling.

    Migrated data from flat files to Oracle using SQL*Loader or import and export utilities. Fine Tuning and Increase the performance of the Queries.
    Effectively made use of Tables, Views, Materialized Views, Index, Synonyms and Sequences. Manipulated data effectively to identify key weakness and suggested improvement areas.

    Experience in creating and maintaining Table Partitioning, Collection and records, Analytical functions, Materialized Views and Query re-write. 

    Deployed and troubleshoot for reported issues, following established methods for integrating different systems to prevent unexpected failures.
     
...see less
Images

XYZ

  • October 2019 - September 2022 - 36 Months
Technologies
Role & Responsibility
    Kyocera is a brand name used primarily by the Japanese multinational ceramics and Electronics Company for industrial ceramics, solar power generating systems, telecommunication equipment, office document imaging equipment and electronic components. ERP is an enterprise resource planning software. It is a cloud-based and cost effective application and it empowers to optimize business process. This software provides business management like HR management, inventory management, order management and supply chain management.
     
    RESPONSIBILITIES: 

    Analyzed the business requirements of the project by studying the Business Requirement
    Specification Document.

    Created Indexes on the tables for faster retrieval of the data to enhance database
    performance.

    Used Pragma Autonomous Transaction to commit the child transaction without affecting
    the parent transaction commit status.

    Wrote complex SQL queries for faster data retrieval from multiple tables.
    Involved in Performance Tuning of Complex Queries.

    Analyzed and Computed statistics to improve response time for queries.
    Used Raised Application Error to handle exceptions.

    Created PL/SQL Scripts to extract data from the operational database into simple flat text
    files using UTL_FILE package.

    Created tables, collections (nested tables and varray) for improving Query Performance.
    Involved in explain plan for query optimization.

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

    Used Bulk Collection for better Performance and easy retrieval of data, by reducing context
    switching between SQL and PL/SQL engines.

    Identified several SQL and PL/SQL bottlenecks using PLSQL Profiler (DBMS_PROFILER), Explain
    Plan, Auto trace.

     
...see less
Images

XYZ

  • May 2017 - September 2019 - 29 Months
Technologies
Role & Responsibility
     X-Trade Brokers is a European brokerage company, based in Poland. XTB started offering its stock brokerage services to retail investors, giving them online access to security exchanges to worldwide. Investors can buy and sell such securities as common and preferred stocks, forex, indices, crypto and ETFs via an electronic trading platform or by phone. Though one platform, all XTB investors gain access to products and markets worldwide. This means that private investors can spread their investments much better. XTB fits perfectly with the investor who manages his online.

    RESPONSIBILITIES: 

    Involved in L1 Support to maintain various UNIX servers. Regularly did monitoring activities by using autosys.

    Interacted with clients to understand their requirements to implement changes in PLSQL Procedures, Functions and Packages.

    Strong in Service Delivery and Support activities Troubleshooting , Analytical Skills, Client Focused, Applications Health Checks, Automations by using UNIX Shell Scripting, Maintenance and Change Related Activities. 

    Responsible for Interface about Monitoring issues and ticket solving with in SLA. 

    Should be able to implement and maintains policies and procedures on application support services.
...see less

Industry Expertise

Education

Education

in Bachelor of Technology Civil Infrastructure Engin

Tamil Nadu University
  • June 2011 - June 2014

Our Suggestions