Programming experience as an Oracle Developer PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
Experience working with SQL Server Database and SSIS (ETL) for loading data from one database to another.
Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers and using the advanced features to optimize performance (Bulk binds, collections, Global Temporary Tables) and Developer 2000(Oracle Forms, Oracle Reports. Experienced in debugging the code and Analysis the data for various reporting and analysis purpose.
Experience in create, modify and monitor batch jobs in Control M. Experience in creating change tasks in Service Now to push the code from SAT regions to Production.
Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL.
Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN_PLAN, SQL Trace, Tkprof, Oracle hints, DBMS_PROFILER, DBMS_STATS.
Proficient in Oracle Tools and Utilities such as TOAD, SQL*Loader, PL/SQL Developer, SQL Developer, External tables and UTL_FILE.
Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
Experience in development of applications using Oracle 10g/9i/8i, SQL, PLSQL