Shailaja Panjakadi
Email: **********@*****.***
Contact: 571-***-****
Summary:
ØOver 6+ years of experience in Information Technology (IT) environment.
Ø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.
ØExcellent working experience in Oracle Database, Advance
PL/SQL 11g, Performance tuning excellent command over SQL, PL/SQL.
ØExcellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
ØExpertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
ØEffectively made use of Tables, Functions, Indexes, Collections, Triggers, Analytical functions, Materialized Views.
ØStrong experience in Data warehouse concepts, ETL.
ØDeveloped Complex database objects like Stored Procedures, Functions, Packages and Triggers.
ØExcellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
ØExperience in Oracle supplied packages, Dynamic SQL, Ref Cursor, External Tables, Collections, Records, Exception handling and PL/SQL Tables.
ØPartitioned large Tables using range partition technique.
ØExperience in SQL performance tuning using Cost-Based Optimization (CBO).
ØGood knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, HINTS and Indexes.
ØDeveloped custom ETL solutions using Shell Scripts, SQL Loader and PL/SQL Routines.
ØExperience in Agile methodology.