SUMMURY:

• Having 8 years of IT experience In Oracle Applications (ERP) as a Technical consultant.
• Responsible for understanding and analyzing the provided RICE component specifications and developing solutions.
• 10g Forms/Reports, XML Publisher Reports and ORACLE ALERTS
• Expertise in 10g Forms Development, Personalization, Extension.
• Having good knowledge in Shell Scripting.
• Expertise in Developing Procedures, Packages, Triggers, Cursors in PL/SQL and maintaining the Instances.
• Expertise in Inbound Interfaces using SQL*Loader and Outbound Interfaces using UTL FILE packages.
• Worked on Workflows, Business Events.
• Having good hand on experience technically/Functionally to work with O2C and P2P Flows.
• Outstanding Technical/Functional Knowledge in Oracle Applications with Supply Chain Management (SCM) Modules like OM - Order Management, INV-Inventory, PO-Purchasing, WSH-Shipping),
• Financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, FA-Fixed Assets), I Expense
• Strong familiarity with AIM methodology in creating MD-50, MD-70, MD120, CV 40, CV 60 and also Testing documents.
• Having good hands on experience on OA Framework, ADF (Application Development Framework), APEX and JAVA.
• Expertise in Design and development of ADF application that integrate with Oracle E-Business Suite using SOA.
• Expertise in Business Process Integration, Service Orchestration, and Routing using Oracle SOA Suite Fusion Products (BPEL, Human Task, Business Rules, Mediator and Web Services).
• Having good communication skills, interpersonal relations, hardworking and result oriented as an individual and in a team.

TECHNICAL SKILLS:

ERP: Oracle Apps 11i, R12

Modules: PO, AP, GL, OM, INV, AR, AOL, Sys Admin and HRMS-PAYROLL.

RDBMS: Oracle 11g.

Fusion Middleware: ADF and Oracle BPEL SOA 11.1.1.6.0

Front End Tool: Forms 6i&10g, OAF

Servers: Web Logic 11g 10.3.4.0

Reporting Tool: Forms 10g, Reports 10g, XML Publisher.

Tools: SQL * Loader, SQL * PLUS, TOAD.

Languages: SQL & Pl/SQL

EXPERIENCE:

Confidential

Customer Service Billing Applications Specialist

Responsibilities:

• Developed notifications for different payment plans.
• Worked on Queue Processing and Shell Scripting.
• Web Service integration with oracle
• Batch process designing.
• Bulk data loading process creation.
• Data mapping process initialized and Architect the internal data structure for reporting.

Environment: Oracle 11g, Forms6i, Tuxedo, Java Web services

Confidential, Houston, TX

EBS Technical Developer & Architect /OAF and Inventory Integration Lead Developer

Responsibilities:

• Developing the OAF Applications for integrating Seibel and Alfresco third party applications and with Oracle Inventory and Assets Module
• I’m the only OAF Developer and lead for Integrations team
• Developed eAM Custom application for line users.

Environment: Oracle Apps R12, SQL, PL/SQL, Oracle 11g, Reports10g, Toad, XML publisher, UNIX

Confidential, Pittsburgh, PA

Sr. Technical Developer /OAF & ADF Architect and Developer/Onsite Lead

Responsibilities:

• Open Purchase and Requisition Reports (Shell Scripting and mailing functionality involved).
• Account Analysis with Sub-ledger (SLA) details (Consolidating AP, AR, EAM, and Inventory with SLA).
• Expected receipts report in PO and I worked on other reports in AP, AR, INVENTORY.
• Developed AP Checks Format, Bank Format using BI Publisher
• XML Publisher Reports Development.
• Migrations, Interfaces and Customizations developed in PL/SQL:
• Items Conversion with different languages description for UK, Netherlands and Bahrain.
• Item Category conversions and assigning to items on country basis.
• Sub inventory and locators conversions.
• On-Hand for inventory items conversions
• Handel Overall O2C Conversions (Sales Order Conversions, WSH Picking Conversions, OE Holds Release Conversions, AR Interface Conversions, AR Receipt Conversions)
• Enhancement to ensure ASL/Sourcing rules are automatically ended in BPA(Blanket Purchase Agreement)
• Sales Order, Purchase Order, AP Invoice, GL Batches Conversions.
• Suppliers Conversion (Suppliers, Sites, Account, Banks, Header Contact Information, Localization for Brazil) (TCA).
• To migrate the value sets, Lookups, Forms by using FNDLOAD Shell Script from CRP instance to UAT Instance successfully.
• Create Business Events and subscriptions for AR Lockbox.
• OAF Customizations in I-procurement for PO Requester.
• OAF Customizations in EAM Work Order Page, Print Work Orders
• OAF Page’s Development for Sales Contracts and integrated with mailing documents functionality.
• Forms Developed from scratch for EAM, OM, and Financial Modules.
• Form and OAF Personalization’s for Work order Page in EAM.
• Build Fusion Middleware Integration for Inventory and TCA Applications Using ADF & BPEL
• Developed MDM Supplier Creation/Amendment ADF Web Application
• Designed and developed an ADF Application for Master Data Management (MDM) team to create and amend Suppliers in E-business Suite in an easily accessible single screen layout.
• Developed an Approval chain interface using Oracle SOA(Human Task and Business Rules) to get buyer/finance approval before creating a supplier in E-business Suite.
• XSLT Data mapping from ADF Application to Oracle using.
• Developed MDM Item Creation and Organization Assignment Request ADF Application
• Designed and developed an ADF Application for Master Data Management (MDM) team for Item Master request and assigning the Items to Organizations request from user.
• Developed an Approval chain interface using Oracle SOA (Human Task and Business Rules) to get buyer/finance approval before creating an Item in E-business Suite and assigning them to requested organizations.
• Developed and ADF Application for Cardex (Item Translations for OPM Items at Org level).
• Involved in other activities:
• Advise functional people at requirement time regarding custom components finalization.
• Preparation of Technical Documents like MD70, CV 60 using AIM.
• Developed different types of Value sets for reports as per the Requirement.
• Worked with SQL loader to load data from flat files.
• Worked on several functions aspects to in corporate them in the integration code.

Environment: Oracle Apps R12, SQL, PL/SQL, Oracle 11g, Reports10g, Toad, XML publisher, UNIX

Confidential

Sr. Technical Consultant

Responsibilities:

• PLSQL Migrations and Interfaces:
• Developed PLSQL Items Conversion, Suppliers, Customers Conversions.
• PO Creation from Bond Management Custom Form.
• SO Creation from OTS (Open Tender System) Cost Templates (OTS White-Oil, OTS Crude-Oil, Private Import).
• Sub inventory Transaction from Local and Transit Bonds Custom Form.
• Release Sales order holds with custom program.
• To migrate the value sets, Lookups, Forms by using FNDLOAD Shell Script from CRP instance to UAT Instance successfully.
• Forms Development from scratch in SCM, Inventory, AP,AR Modules
• Requirements gathering from client.
• Used SQL*Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• Involved in Report development using XML Publisher.
• Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, forms and reports.
• Worked on Form Personalization for Different Requirements.
• Preparation of Technical Documents like MD70 using AIM.
• Developed different types of Value sets for reports as per the Requirement.
• Preparing the MD070 Documents based on MD050 for each component.
• Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, triggers, Alerts, forms and reports

Environment: Oracle Apps R12, SQL, PL/SQL, Oracle 11g, Reports10g, Toad, XML publisher, UNIX

Confidential

Oracle R12 Technical Consultant

Responsibilities:

• Integrations and Migrations
• Customers with multiple site and extra information migration using API.
• Item Conversion.
• Employees Migration with Assignment details Using API
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Imported Open Payables Invoices from legacy system into Oracle AP using Interfaces
• Customization Oracle forms & Reports in PO Module.
• Developed the reports and Forms as per the current requirement by using in Reports10g and Forms10g
• Design technical documents MD-70 for conversions, extensions, interfaces, and reports.

Environment: Oracle Apps R12, SQL, PL/SQL, Oracle 11g, Reports10g, Toad, XML publisher, UNIX

Confidential

Oracle Technical Consultant

Responsibilities:

• Worked on Suppliers & Supplier Sites Conversion.
• Worked on Form Personalization for Different Requirements.
• Involved in Preparing the Technical documentations.
• Maintaining the Oracle Coding Standards and reviewing the Code and testing the Components.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.

Environment: Oracle Apps 11i, SQL, PL/SQL, Oracle 9i, Reports6i, Forms6i, Toad, XML publisher, UNIX.

Confidential

Oracle Technical Consultant

Responsibilities:

• Employees Migration Using API.
• Raw Material Control Template.
• Maintaining the Oracle Coding Standards and reviewing the Code and testing the Components.
• Worked on Form Personalization for Different Requirements.
• Involved in Preparing the Technical documentations.

Environment: Oracle Apps R12, SQL, PL/SQL, Oracle 11g, Reports10g, Toad, XML publisher, UNIX