Pavan Poreddy

Background

About Pavan Poreddy

PROFESSIONAL SUMMARY • 14 years global oriented professional experience in Information Technology experience in Software Design and Development, which includes Customization of various Business Applications. • Having extensive implementation experience in Oracle PL/SQL, Oracle 9i,10g/11g DBA Oracle Forms and Oracle Reports. The versions of Oracle that I have worked on includes 8i, 9i, 10g and Oracle 11g Technical Summary : • Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers. • Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL) • Exporting data using expdb and Importing data using impdb • Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc. • Experienced in UNIX shell programming • Experienced in Database Optimization by making use of various Performance Tuning techniques. • Proficient in database and SQL tuning using HINTS and EXPLAIN PLAN. • Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes. • Very good knowledge and experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc. • Very good working knowledge in TOAD. • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling. • Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and plans. • Developed ad hoc reports for better management decision-making as needed