$15.0 per Hour
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
Strong RDBMS concepts including expertise in using DDL, DML, DCL, TCL Statements in
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
Oracle 11G,Oracle 12C,Oracle 10G,Oracle5 Years
- January 2015 - July 2023 - 8 Year
- October 2022 - July 2023 - 10 Months
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
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.
- October 2019 - September 2022 - 36 Months
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.
Analyzed the business requirements of the project by studying the Business Requirement
Created Indexes on the tables for faster retrieval of the data to enhance database
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.
- May 2017 - September 2019 - 29 Months
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.
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.
in Bachelor of Technology Civil Infrastructure EnginTamil Nadu University
- June 2011 - June 2014