We provide IT Staff Augmentation Services!

Senior Oracle Ebs Developer Resume

SUMMARY

  • Having 18 + years of IT experience in Software development, design, analysis and project management in which 18 years of experience using Oracle E - Business Suite Applications with expertise in Oracle HRMS (HR, Payroll, Advance Benefits)
  • Develop, validate, and maintain large, enterprise class, applications written in Oracle PL/SQL
  • Oracle database full life cycle development including data modeling, SQL and PL/SQL development, unit testing and support.
  • Tune application SQL queries for performance optimization
  • Evaluate existing database structures and recommend improvements.
  • Convert user stories into application logic, reports, printed outputs, and interfaces with other systems.
  • Experience with relational database and Oracle PL/SQL concepts
  • Experience in Development of PL/SQL Packages, Stored Procedures, Functions and Triggers
  • Experience with Performance Tuning and optimizing SQL, PL/SQL code to reduce execution time or improve efficiency.
  • Experience with database design, data migration and data modeling
  • Expertise in using Oracle PL/SQL Collections, Bulk techniques, Analytical Functions to increase performance.
  • Experience analyzing complex business applications, developing logic flow charts, and translating detailed design into software.
  • Experience with development life cycle; requirements gathering, analysis, design, coding, unit testing, and acceptance testing.
  • Experience with enterprise level software development tools
  • Understanding of software development processes and methodologies including, Agile, Scrum
  • Experience working with source control management tools.
  • Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
  • Worked with end users/customers to understand business requirements.
  • Ability to provide weekly status update to Project Director and Project Stakeholders.
  • Experience in Managing Development team, Testers and Business Analysts.
  • Experience in implementation, support, upgrade, rollout, migration, and application Enhancement projects.
  • Experience in using application of Agile-Scrum and Waterfall Methodologies.

TECHNICAL SKILLS

Packages (Including Versions): Oracle E-Business Suites Rel. 10, 11, 11i, R12, 12.1 and Rel.12.2.*

Modules: Oracle Applications HRMS, Employee/Manager Self Service, Payroll

Tools: Workflow, SQL Loader, Oracle Forms, Oracle Reports, Oracle AlertDiscoverer(10g), XML Publisher, OAF, Fast Formula, TOAD

Databases: ORACLE (8i, 9i, 10g, 11g, 12.1. 12.c)

Languages: PL-SQL, SQL*PLUS

Operating Systems: Linux, MS-WINDOWS

Version Control: PVCS, SVN

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle EBS Developer

Responsibilities:

  • Supported AP Supplier Conversions (Vendors, Vendor Sites and Vendor Contacts) and Invoice interface using AP Interface Tables, PL/SQL packages, API’s.
  • Technical lead for R12 upgrade project.
  • Upgrade of the Oracle Apps from 11i (11.5.10.2) to R12 (12.1.3). Involved heavily in both Functional and Technical development during the upgrade.
  • Work in the Agile development environment in CA Agile Central Rally and Jira.
  • Worked on designing and generating XML files using Oracle PL/SQL, Oracle AR, BI Publisher
  • Developed many reports in Finance in BI Publisher 11g
  • Enhanced the Payment selection program to automatically select the invoices for a Payment Process Request.
  • Extended and personalized Oracle Customers Online screens using Oracle Application Framework (OAF).
  • Work extensively on AP Invoice Approval and PO Approval Workflow to customize as per business requirement.
  • Single point of contact for all Oracle related issues for business users and offshore team.
  • Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40).
  • Involved in customization of several standard reports to serve important business processes very specific to the client.

Environment: Oracle Applications (R11, R12.1 and R12.c), BI Publisher, OA Framework, JDeveloper, XML Publisher/BI, Forms, Form personalization's, Reports, Work flow, Custom PLL, Sql Plus, PL/SQL, Putty, PVCS, SQL Navigator, Jira, TOAD

Confidential

Senior Oracle EBS Developer/ Associate Information Officer

Responsibilities:

  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance.
  • Production Support in HRMS, Payroll, Self Service.
  • Developed several HR Alerts and Workflow notifications.
  • Developed several Payroll and Benefits Fast Formulas.
  • Designed and Developed Payroll Payment Processing for International Staff.
  • Designed and Developed custom Education Assistance System.
  • Developed and re designed HRMS and Payroll Reports using XML/BI Publisher
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Involved in the continuous enhancements and fixing of production problems.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in the business meetings with client/users at all stages of implementation.
  • Worked with teams to implement upgrades on Oracle E-Business Suite R12 HRMS Modules HR, Advance Benefits, Self Service, Employee Self Service and Manager Self Service, Payroll
  • Worked with the project team members and development leads responsible for developing reports, interfaces, data conversion programs, application extensions and ensures compliance with standards for development, testing and documentation.
  • Worked with other teams to ensure that all ongoing data conversion, extraction and load functions are correctly done.
  • Development of Various data conversions scripts to migrate data from Legacy to Oracle E- Business Suite.
  • Designed and Developed Payroll interfaces program to load the Employee additional income and deduction to Oracle Payroll.
  • Designed and Developed Fast Formulas to compute for different Oracle Payroll processes.
  • Facilitator of the daily triage meetings which includes project managers, business analysts and team members to analyses project plan and business requirements.
  • Facilitator of the weekly project status meeting with selected Project Management and Committee members.

Environment: Oracle Applications (R11, R12.1 and R12.c), BI Publisher, OA Framework, JDeveloper, XML Publisher/BI, Forms, Form personalization's, Reports, Work flow, Custom PLL, Sql Plus, PL/SQL, Putty, PVCS, SQL Navigator, Jira, TOAD

Confidential

Oracle EBS Developer

Responsibilities:

  • Resolve issues around Oracle Applications HRMS/Payroll, Self Service and Oracle Self Service
  • 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
  • Actively supported in resolving production related issues with Business Users.
  • Designed and Developed Payroll interfaces program to load the Employee’s deduction to Oracle Payroll.
  • Performed tuning for various PL/SQL scripts.
  • Loading the AP, GL spread sheets data into APPS using web ADI.
  • 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:

  • Resolve issues around Oracle Applications E-Business Suite HRMS and Oracle Payroll.
  • Created workaround procedures and customized Oracle EBS standard business processes when standard procedures do not work.
  • Provided production support in Oracle Application HRMS/Payroll
  • Designed, developed and implement the Timekeeping System (TKS) which monitors the daily attendance of company staff.
  • Build and Develop 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

Hire Now