SUMMARY

• Oracle Developer with 20+ years of IT experience, and around 18 years of experience in development, interfaces, conversion, and enhancement of Oracle EBS Suite (HRMS, Payroll, Self Service, OAB, AP and GL).
• Good technical development skills in development using Oracle SQL, PL/SQL, Oracle Forms and Reports, Oracle Workflow, Oracle XML Publisher, Oracle Application Framework, Interfaces, Conversions and Enhancements / Extensions
• Experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in implementation, support, upgrade, rollout, Migration and Application Enhancement projects.
• Experience working in an Agile Scrum environment and Waterfall Methodologies.
• Excellent team player, Quick learner, and team builder with strong interpersonal skills.

TECHNICAL SKILLS

Packages: (Incl Versions)Oracle E - Business Suites 11i and R12

Modules: Oracle Applications HRMS, SSHR, Payroll, OAB, AP, GL

Databases: Oracle (8i, 9i,10g,11)

Languages: PL-SQL, SQL*PLUS

Operating Systems: Linux, MS Windows

Version Control: PVCS, SVN

Tools: Workflow, SQL Loader, Oracle Forms, Oracle Reports, Toad, Oracle Alert, Discoverer(10g), XML Publisher, OAF, Fast Formula

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Developed and modify existing Oracle applications using Oracle SQL, PL/SQL, XML Publisher, Workflow builder, Reports, Custom Forms, OA Framework, Conversions, Interfaces and Extensions.
• Developed SQL queries, Views, Materialized views, PL/SQL Packages, Procedures, Functions, triggers, Cursors and Collections.
• Developed Forms Customization as per business requirements through CUSTOM.pll and Form Personalization.
• Developed script to load Legacy data into Oracle INTERFACE tables using SQL*LOADER.
• Performed code tuning and recommends code improvements to existing program codes.
• Handled errors using Exception Handling to ease the debugging and displaying the error messages in the application.
• Designed and Developed interface programs for different legacy sources.
• Expertise in using the PVCS tools for version control and migrating objects from instance to instance.
• Worked with business Users to collect requirements and converting into functional specification.
• Worked with teams to implement upgrades on Oracle E - Business Suite R12 HRMS Modules HR, Advance Benefits, Self Service and Payroll, General Ledger and Accounts Payables.
• Production Support for Oracle Business Suites (HRMS / Payroll / Advance Benefits)
• Design, and develop, Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets, Request sets, functions, Menus, and Application Developer.
• Worked with other teams to ensure that all ongoing data conversion, extraction, and load functions are correctly done.
• Experience in leading of developers and QAs to Implement custom oracle applications using agile scrum delivery.

Environment: Oracle 11g, Oracle Applications R12.2, BI Publisher, OA Framework, JDeveloper, XML Publisher/BI, Forms, Form personalization's, Reports, Workflow, Custom PLL, SQL Plus, PL/SQL, Putty, PVCS, SQL Navigator, TOAD, Jira

Confidential

Oracle EBS Developer

Responsibilities:

• Develop various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, Oracle Alerts, Fast Formula and Application Object Library.
• Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications HRMS/Payroll.
• Designed and developed Payroll interfaces program to load the Employee’s deduction to Oracle Payroll.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Designed and Developed Custom Staff Time Records and Absence info using Oracle Forms and Reports.
• Designed and developed custom programs like API's using PL/SQL for Oracle Payroll, GL and Oracle AR
• Experience in fixing the issues using PL/SQL, performance tuning and enhancements with the ability to support environment processing large volumes of data required in financial systems.

Environment: Oracle Applications 11.5, Oracle Workflow Builder, Forms 6i, Reports 6i, SQL Plus, PL/SQL, Putty, PVCS, TOAD

Confidential

Oracle Application Programmer / Analyst

Responsibilities:

• Resolved issues around Oracle Applications E-Business Suite HRMS and Oracle Payroll.
• Created workaround procedures and customized Oracle EBS standard business processes when standard procedures did not work.
• Provided production support in Oracle Application HRMS/Payroll
• Designed, developed, and implemented the Timekeeping System (TKS) which monitors the daily attendance of company staff.
• Built and developed interfaces and custom objects for Oracle Applications HRMS
• Performed system testing, prepares test data, debugging and optimize existing systems for better performance.

Environment: Oracle Applications 11i, 11.5.10, Oracle Workflow Builder, PL/SQL, Forms 6i, Reports 6i, TOAD, SQL Plus, PL/SQL

Confidential

Oracle Developer

Responsibilities:

• Developed Payroll System
• Developed Database triggers for business rules.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 4.5, Reports 4.5, SQL*Loader, TOAD.