shanmugapriyan Ponnadai

- Analysed the business requirements of the project by studying the Business Requirement Specification document. - Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules. - Created database objects like packages, procedures, and functions according to the client requirement. - Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL_FILE, SQL*Loader and External Tables.

- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, DPA, SQL TRACE and DBMS_SQLTUNE. - Worked with Bulk Collect to improve the performance of multi-row queries by reducing the context switching. - Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. - Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

- Collaborated with the application developers in data modeling and E-R design of the systems. - Also created, modified, maintained and optimized SQL database. - Maintained the documents and create reports for the business analysts and end-users. - Created Materialized views & views where business requirements needed. - Developed scripts for checking oracle errors in alert log and trace files.