• Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
• Designed and developed Database Objects and packages for GST Implementation.
• Working with XML creation and Extraction related to implementation of business logic.
• Involved in the continuous enhancements and fixing of production problems.
• Involved in performance Tuning process and made system faster.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Packages and Procedures for Auto Mail Generation and SMS to the customers.
• Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
• Having 3 years of Programming Experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using Relational Database Management System (RDBMS).
• Involved in all phases of the Software Development Life Cycle from analysis, design, development and maintenance with timely delivery against aggressive deadlines.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong knowledge of SQL, PL/SQL Stored Procedures, Packages, Functions and Triggers.