View Bench List Portal

Similar candidates

• Abbu Nagaya Sriraman
• Joseph Moregon
• Cyrus Davijani
• Kapil Satija
• Sathish
• Vlad
• Prasanth Kumar Saduneni
• Vlad
• Mahankali suresh

• Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.

• Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin.

• Analyzed the functional specs provided by the data architect and created technical specs for all the projects.

• Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts.

• Formulated SQL queries, functions and processes as per customization requirement for APEX.

• Supported APEX applications and contributed with database designs and assisted in increasing response time for APEX reports.

• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.

• Defined relationships using primary keys and foreign keys for the entities and normalized the entities.

• Created test cases and test reports and worked with QA team to validate the data and scenarios.

• Troubleshouted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan.

• Worked on various backend Procedures and Functions using PL/SQL.

• Coordinated with the frontend design team to provide them with the necessary stored package and procedures and necessary insight in to the data.

• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.

• Involved in Unit Testing Stored Procedures and Functions.

• Development of C modules for activation, deactivation and modification of these plans in Clarify Front End.

• Created SQL*Loader scripts to load data into the temporary staging tables.

• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

• Used TOAD, PL/SQL developer tools for faster application design and developments.

• Developed procedures using Dynamic SQL.

• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.

• Created Materialized Views and partitioning tables for performance reasons.

• Resolving the issues on priority basis.

• Responsible for Analyzing and Implementing the Change Requests.

Environment: Oracle 11g, SQL Plus, SQL Navigator, SQL*Loader, TOAD, Oracle forms and reports developer, UNIX, Shell Scripting, Microsoft Office.