Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations.
Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
Created applications in MSDOS to dynamically call the relevant stored procedures and generate the handoff files which will be automatically ftp to the destination and uploaded through another stored procedure in the destination system.
Good knowledge on joins, which are inner join, Left outer join
Implemented various UNIX scripts to generate the data in CSV format.
Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.
Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
Developed Database Triggers for audit and validation purpose.
Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
Analyze AWR reports to point out performance issues in the system.
Create table indexes to reduce query cost and performance optimization.
Use top command to identify performance bottlenecks and resource utilization through HPOV.
Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
Knowledge of handling non ASCII data.
Generating Flat files using util_file package.
