Location: Pan India Experience: 3-8 years Education: Graduate Job Description:
Analysed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
Worked as part of the development team along with the Systems Analysts/Business Analysts.
Created PL/SQL Stored Procedures Functions Packages and Triggers extensively used Cursors REF cursors User-defined object types Records in PL/SQL programming.
Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds Bulk Collects to improve performance.
Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN TKPROF and DBMS_PROFILER.
Handled PL/SQL compile-time run-time errors debugging of Stored Procedures for business logic modification and responding to system events through triggers.