Programmer Analyst
Current• Experience in development/enhancement of the PL/SQL Packages/Stored Procedures with Dynamic SQL,Collections,Bulk Upload,Record Type,Table Type,Functions & Exception Handling.•Experienced in preparing training manual and providing Hands on Training during UAT/Post Production Support.•Regression testing and fix any bugs identified during the testing cycle.•Handled performance tuning and break/fix of existing SQL code.•Reviewed code to identify SQL changes to improve system performance.•Troubleshot complex queries and stored procedures.•Implemented and enforce best practices, standard operating procedures, etc.•Created and implemented data models into a SQL DB.•Implemented RESTful APIs that communicated with an EBS to manipulate data.•Software Used: SQL Developer, Oracle DB 11g,Post-man