Oracle Developer
MAC
Total years of experience :9 years, 11 Months
Formulated SQL queries, functions and processes as per customization requirement for APEX.
- Understand the existing application, gathering new requirements, and business rules.
-Designed application framework and developed Oracle APEX Application
-Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
-Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass -update as performance improvement process.
-Developed various backend application programs, such as views, functions, Procedures, Packages using SQL and PL/SQL languages.
-I prepared Unit test cases for Business purpose
-Created SQL*plus reports as per client's various needs, and developed business objects
-Created Views on multiple Tables.
-Loaded the data into database tables using SQL*loader from text and excel files
-Designed and developed various custom packages triggers and forms.
-Performed unit level testing. Worked on CRs assigned by onshore team.
-Development of Code based on the approved Technical Specifications.
-Migrated data from flat files to tables using SQL*loader.
-Developed UNIX Shell scripts to automate table creation, execute procedures.
-Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
-Developed Stored Procedures, Functions and Packages.
-Created Views on multiple Tables. Used Oracle APEX 4.0 for designing application structure
-Created indexes on some columns of tables to increase the application's performance.
-Responsible for SQL tuning and optimization using explain plan and also responsible for --writing test plans and unit testing for the application modules.
-Analyzing tables and indexes for performance tuning.
-Worked with Global Temporary Tables.
-Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
-Involved in updating procedures, functions, triggers, and packages for validation and loading of
-Data int target table based on the current requirement
• Oracle Taleo Recruiting Cloud
• Oracle Payroll
• HRMS Self Service
• OLM (Oracle Learning Management R12)
• 6i, 10g Oracle Forms & Reports
• J developer JSP
• Oracle Workflow
• I Recruitment
• Oracle SQL and PL/SQL
• Oracle SOA Suite 10g/11g
bachelor degree