Prathibha Teju K





Valencia, CA

Education Level:


Will Relocate:



Professional Summary: About 4 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Development of client/server and multi tired applications using the Oracle Relational Database Management System (RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, TK- Prof and Explain Plan. * Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types. * Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer. * Knowledge on data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory. * Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning. * Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level. * Ability to coordinate several tasks at a time and excellent decision-making skills, demonstrated excellent problem solving and active listening skills. * Experienced in Dynamic SQL, PL/SQL Collections and Exception handling. * Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle. * Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Records, Types and Dynamic SQL for DML operations for better performance. * Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database. * Well-versed with different stages of Software Development Life Cycle (SDLC). * Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules. * Experienced in Tuning Queries for better performance with large volume of data.


CollapseWork Experience


Amway Oracle Pl/Sql Developer 11/2016 - 10/2017
Mphasis Oracle Pl/Sql Developer 9/2015 - 10/2016
Attra Infotech Oracle Pl/Sql Developer 6/2014 - 8/2015
Isomite Technologies Jr.Oracle Sql Developer 11/2013 - 4/2014