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