RESUME VARALAKSHMI K
Kottur, Chennai – 600085.
Mobile : 892-***-****
Aspirant for a position in an organization where I can contribute my skills for organization’s success and synchronize with new technologies while being resourceful, innovative and flexible.
•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, Index (B Tree, Bitmap and Function Based).
•Work experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
•Exposure writing complex SQL Queries.
•Bulk data Collecting, Performance tuning of huge data with use of PLSQL collections and records.
•Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
•Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
•Expert in query optimization and exposure using Hints, GTT.
•Tuning of SQL Queries, Explain plan, DBMS_Profiler.
•Expertise in loading data using SQL*Loader.
•Export and Import Database level or Schema level by using SQL Loader.
•Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS,
TOAD and SQL DEVELOPER.
•Worked as Programme Assistant in Anna University, Chennai from May 2010 to June 2014.
•Worked as Assistant Professor in Ethiraj College for women, Chennai from June 2014 to Jan 2017.
•Working as a PLSQL DEVELOPER for “STERLING SOFTWARE PRIVATE LIMITED” from JAN ‘17 to till date.
Awards for Excellence
On The Spot Awards
Awards for Excellence
•Oracle Certified Associate (OCA).
•Completed MASTER OF COMPUTER APPLICATIONS from Ethiraj College for Women, Chennai (2007- 2010) with 80%.
•Completed B.Sc., COMPUTER SCIENCE from Government College for women (2004-2007) with 72%.
•Completed HSC from Sri Saraswathi Patasala Girls Higher Secondary School during 2004 with 68%.
•Completed SSLC from St. Joseph’s Girls Higher Secondary School during 2002 with 72%.
Client Name : Lightspeed Trading.
Project Name : LLC TradePro.
Role : Oracle PL/SQL Developer. Duration : Jan 2017 to Till Date.
Application 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.
•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.
•Languages : Oracle SQL, PLSQL
•Database : Oracle 10G,11G
•Tools : SQL Developer, Toad, SQL*Plus,Mysql
•Operating System : Windows, Linux
•Spouse name : Balachandar Mohan
•Gender : Female
•Marital Status : Married
•Languages Known : English, Tamil.
•Date of Birth : 03/04/1987
I hereby declare that all the details furnished above are true to the best of my knowledge.
PLACE : CHENNAI