SUMMARY

• 7 years of experience as anOracle EBS Application Developer.
• Worked on projects in Implementation and Customization ofOracle e - Business Suite Applications(R12, 11i).
• Technically Proficient in RICE components
• Proficient Experience inAOL and Oracle Financials, SCM, HRMS modules such as General Ledger, Fixed Assets, Accounts Payables, Accounts Receivables, Purchasing, AME, Order Management (Order, Shipping, Advance Pricing and Quoting), BOM, WMS, Inventory, iProcurement, I Expenses, Employees, Grades, Positions etc.
• Expertise in development ofInterfacesandConversionprograms to integrate Oracle Applications modules to import data from various sources into Oracle Applications usingPL/SQL, SQL*Loader.
• Extensive knowledge on Oracle Application Framework (OAF) with hands on in customization, extension of CO, VO, EO, personalization and creation of pages.
• Extensively worked on OraclePL/SQLDevelopment I.e.Stored Procedures, Packages, Functions, and Triggers. Development of complex SQL queries.
• Expertise on designing and implementingOracle Alerts.
• Dexterous in Customizing Oracle reports and developing new reports by using XML Publisher(BI Publisher).
• Possess knowledge and worked on POC's (Security Matrix and Student Info) in Application Development Framework (ADF).
• Knowledge and hands on in P2P (Procure to Pay) cycle, O2C (Order to Cash) and TCA(Trading Community Architecture).
• Worked on Forms Personalization.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Effectively used Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Certified in Oracle OUM and expertise in developing Technical OU standard documentation and well versed in Oracle coding standards.
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS

Programming Languages: SQL/PLSQL, Core JAVA, UNIX, C.

Database/ERP: OracleApplications 11i and R12, Oracle 9i/10g/11g.

Methodology: Agile PLM, Agile RMW

Tools: Reports Builder, BI Publisher/XML Publisher, Form Builder, Workflow Builder, Oracle Application Express (APEX), Oracle J Developer, SQL*Loader, SQL Developer, Putty, ODI (Oracle Data Integrator), MySQL, TOAD, WinScp.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Oracle Apps Developer

Responsibilities:

• Extensively worked on Development of XML Publisher Customer Reports for WIP WMS implementation to track the Printing & Warehousing of Student Study Material, Jobs Received, Delayed jobs etc.
• DevelopedOrder Import Interfacefor business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into theOrder Import (OE) headersandline interface tables and then toOEbase tables.
• Developed Event Alerts as well as Periodic Alerts in Oracle Applications for Lecturer Notifications and alerts for exams.
• Worked on Personalization of forms for disabling menus based on query results.
• Developed AP Invoices, Supplier Conversion to load invoices and vendor details from legacy system into Oracle Applications base tables using SQL Loader.
• Generated SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, view, materialized views, packages, sequences, grants and synonyms.
• Involved in writing PLSQL procedures, functions, triggers and packages.
• Created Test scripts and was involved in Unit and Integration testing.
• Developed standard OUM documents DS140, TE020, TE030 and IM090.

Environment: SQL, PLSQL, UNIX, SQL*Loader, TOAD, OAF, Oracle EBS R12 (12.1.3)

Confidential, Phoenix, AZ

Oracle Apps Developer

Responsibilities:

• AR Customer conversion program using TCA model.
• Created conversion programs in Supplier, Fixed Assets and Purchase Orders to migrate data from EBS 11.5.0 to EBS 12.1.3 using data links.
• Created Revenue Source Report in General Ledger using XML Publisher.
• Created Sales Order Report using XML Publisher.
• Involved in creating HOST program that fetches CSV files from server and insert into custom table.
• Worked on personalization and extension of I Expenses on update expense report page for restricting reimbursement currency.
• Modified existing and created new SQL, PL/SQL Packages as per the business requirement.
• Transferred Custom Concurrent programs, executable, request groups, profile options using Oracle FNDLOAD utility.
• Developed various Oracle Alerts to inform internal users of certain events, or to send notifications.
• Developed standard OUM documents DS140, TE020, TE030 and IM090.

Environment: SQL, PLSQL, XML Publisher, UNIX, TOAD, Oracle EBS R12 (12.1.3), (11.5.0)

Confidential

Oracle Consultant

Responsibilities:

• Worked on customization of Standard OTL page in Oracle Applications Framework. The customization included CO extension to add a calculated column, VO substitution for adding a new transient attribute and Personalization of the page for adding new columns.
• Created Custom approval process for purchase requisition approval transaction type in AME.
• Developed custom Supplier XML/BI Reports.
• Worked on Outbound Interfaces using java concurrent program for AP Invoices.
• Worked onSQL*Loaderto load data from flat files to Oracle database staging tables for Sub-Inventory data migration.
• Created PL/SQLstored procedures, functions and packagesfor migrating data staging area to Oracle database standard tables.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object types and Dynamic SQL.
• Developed standard OUM documents DS140, TE020, TE030 and IM090.

Environment: SQL, PLSQL, UNIX, SQL*Loader, TOAD, OAF, Oracle EBS R12 (12.2.4)

Confidential

Oracle Apps Developer

Responsibilities:

• Worked on CO extension in iProcurement for validation of project and corresponding project approvers. Validation of requisition creations in different responsibility.
• Personalization of page in iProcurement module by creating new flex and creating tip and hiding the project region for selected responsibilities.
• Worked on creation of PLSQL conversion programs for data migration from Zain 12.0.4 to Zain Kuwait in 12.1.3 in standard modules Inventory, Purchase Orders, AR Invoices, Custom Contracts, Customers, Grades and Positions.
• Creating data mapping templates for loading data from 12.0.4 and using external tables to load data into 12.1.3 instance using conversion programs.
• Created Purchase Order and General Ledger custom reports using XML/BI Publisher.
• UsedFNDLOAD to migrate Concurrent Programs and Data Definitions to Various Instances. Creation of users, responsibilities, values sets, lookups, flex fields and request sets.
• Developed standard OUM documents DS140, TE020, TE030 and IM090.

Environment: SQL, PLSQL, OAF, UNIX, TOAD, XML Publisher, Oracle EBS R12 (12.0.4 to 12.1.3).

Confidential

Oracle Apps Developer

Responsibilities:

• Creating custom OA Pages in custom modules in Inventory. Personalization of existing pages.
• Development of PL/SQL scripts for data conversions in custom Accounting module and Inventory module.
• Resolved code related issues and query tuning in PLSQL and layout and code fixes in OAF pages for issue tickets raised in Red Mine System during UAT.
• Followed OUM Documentation standards and created DS140, TE020, TE030 and IM090.
• Involved in reviewing process of PLSQL scripts and creating RCL’s.

Environment: SQL, PLSQL, UNIX, TOAD, OAF, Oracle EBS R12 (12.1.3)

Confidential

Oracle Apps Developer

Responsibilities:

• Worked on Development of interfaces for migration of various objects for end to end implementation between Agile RMW and Agile PLM and configurations of Agile PLM and Agile RMW system.
• Created Recipes, Work Orders, Equipment, Inventory Lots, Material Allocations, and Notifications in RMW system.
• Involved in developing SOAP web-services in order to load data from Agile PLM system to Agile RMW system and vice-versa.
• Created reports using BI Publisher for products that contained BOM.

Environment: Agile PLM, Agile RMW, Core Java, XML, XSL

Confidential

Oracle Apps Developer

Responsibilities:

• Worked on Purchase Order Conversion in the P2P cycle.
• APEX was used to create an upload page and make changes for the same which was used by experts to load KM data.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package for upload in APEX. Worked on design of Repository for Conversion and Interfaces which would be ideal for Knowledge sharing.
• Scheduling of mails in APEX for sending notification everyday regarding the KM usage by users.
• Created complex SQL queries to fetch historical data from OSO system.
• Formulated functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.

Environment: SQL, PLSQL, UNIX, TOAD, OAF, Oracle EBS R12 (12.1.3), APEX 4