Chennai , India

Experience: 2 Years


Chennai , India


60000 USD / Year

  • Immediate: Available

2 Years

Now you can Instantly Chat with VARALAKSHMI!

About Me

Nearly 3 years of experience in the Oracle PL/SQL Developer/Production Support experience in software analysis, design, development, testing and implementation of full life cycle web based software applications. Created Tables, Views, Constraints, In...

Show More

Portfolio Projects


LLC TRADEPROApplication provides ultra-low latency, stable, and customizable technology so you can always trade your best. Send orders to over 100 order routing destinations through our multi-threaded servers. Customize your trading screens, set alerts with advanced scanners and filters, and be sure your trades have the greatest chance of success. You can do all your trading from a single Lightspeed account whether you’re trading equities or options, trading to multiple destinations, or trading for multiple funds. It brings you the latest in authentication technology. Our 2-step verification adds an extra layer of protection to your account settings and fund transfers by sending one-time-use pass codes to your mobile device.

Roles and Responsibilities

  • Involved in Analysis, Design, Data Modeling ( Logical and Physical), and Implementation of Business Applications using the Oracle Relation Database Management System(RDBMS).
  • Responsible for the designing the advance SQL queries, procedure, function, package, cursor, triggers, scripts.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Developed SQL*loader scripts to load data in the custom tables
  • Created Materialized views & normal views where business requirements needed
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Worked on XML along with PL/SQL to develop and modify web forms.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Show More Show Less