Description
PROFESSIONAL SUMMARY * More than 2 years of analysis, design and development experience in the IT industry. * Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing pl/sql stored procedures, functions and Packages. * Excellent skills in Application Development using Oracle 10g, 11g and Developer Suite 10g. * Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages, Database Triggers and External Tables. * Strong knowledge in Oracle Cursor management, Exception Handling and also had Experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints. * Expertise skills in using the tools TOAD 10.6, Sql * Loader, Oracle Sql Developer and Oracle utilities like UTL_FILE, Exp, Imp and Data pump and also had Experience in Java and UNIX Shell Scripting. * Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Handled Production issues with high pace and efficiency. Optimized existing queries for better performance and less impact on database. * Used Materialized views in places where the data does not change very frequently and good understanding of the star schema. * Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables. * Used Ref cursors and Collections, Bulk Collect and Bulk Binding for accessing huge volume of data. * Worked with the users to identify the business requirements and integrated them into the front-end Applications. * A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.