SUMMARY

• Oracle EBS Techno Functional Consultant wif 8+ Years of experience in implementing and extending Oracle eBusiness Applications 11i/R12.
• Extensive experience in using SQL, PL/SQL, Oracle Developer Suite(Forms, Reports, JDeveloper), Workflow builder, XML Publisher, JSP and AOL for RICE Components (Data Conversons, Interfaces, Forms, Reports, Form Personalizations& Alerts)
• Experience in personalization, custom page design and extending Oracle Self - Service applications using OAF, JDeveloper10g, Java, and XML
• Worked on Personalization's andCustomizations (CO Extensions and VO Extensions) on OA Pages and New OAF Pages.
• Strong technical experience in design, implementation of interfaces, API and customization of Oracle Applications 11i and R12 (GL, AP, AR, TCA, Advanced Collections, PO, SCM, OM, INV, WIP, iProcurement, iSupplier, and AOL objects).
• Excellent understanding and implementing teh Order-to-Cash (O2C) and Procure-to-Pay (P2P) business process.
• Expert in understanding teh business process, Requirement Analysis, module setup, writing teh training documents and end user support in Purchasing, Accounts Payable, Inventory and General Ledger.
• Strong programming experience in creatingPL/SQL Stored Procedures, Functions, Stored Packages, Database Triggers, SQL* Loader scripts, Shell scripting, Forms(6i/10g), Reports(6i/10g).
• Extensive experience in design and implementation of Oracle Alerts and customizing Oracle Workflow.
• Extensive experience in developing and designing custom reports using XML/BI Publisher Reports
• Good Knowledge inOracle Fusion -Application Development Framework (ADF).
• Proficient in writing and tuning complex SQL statements.
• Excellent Knowledge of using Oracle AIM Methodology for teh project Implementation Methodologies.
• Excellent understanding of teh AOL, System Administrationand Application Developer module.
• Experienced in Developing Technical Specification and Design Documents.
• Experienced in data migrations from legacy systems into Oracle Applications.
• Creation and follow ups of SR and Applications of Patches as and when required.
• Excellent in analysis of current business processes, application configuration, managerial reports, and information processing.
• Involved in 2 complete system development life cycles including teh analytical skills necessary to satisfy testing documentation and Change management requirements.
• Involved in Post Production Support and halped to get teh system stable.
• Technical (Production Support, Developer etc.) activities: Automation of daily routine activities through scheduled scripts, Archival activities, identifying technical gaps, designing custom solutions, programming, scheduling, producing documentation, and providing post production support.

TECHNICAL SKILLS

ERP Modules: Oracle Applications R12(12.0.3, 12.1.3) / 11i (11.5.X) PO, OM, AP, AR, GL, INV, WIP,iProcurement, iSupplier

Database: Oracle 10g/11g

Application Tools/Technologies: SQL plus, SQL Developer, PL/SQL, Toad, Tkprof, SQL*LOADER, Workflow Builder, BI Publisher(XML Publisher), Discoverer, Forms Builder(Forms 6i/10g), Report Builder(Oracle Reports (6i/10g)), Putty, Filezilla, Version Control(Microsoft Visual Source Safe (MS-VSS), Clear Case ), Java, JSP, JDeveloper 11g

Languages: SQL, PL/SQL, XML Publisher, Unix Shell Scripting, OAF

Environment: s: Windows XP/2000/7, UNIX (Sun/Solaris/AIX)

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Oracle EBS R12 Techno Functional Consultant

Environment: Oracle EBS R12(AP,AR, GL, iProcurement, TCA, FA, PO, SCM, INV,iSupplier), Oracle 11g, SQL, PL/SQL, Reports 10g, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, Forms 10g, OAF, JDeveloper11g.

Responsibilities:

• Served as a Techno Functional Consultant on teh project, implementing, supporting Oracle EBS systems and designing and developing extensions primarily on Order to Cash and Procure to pay processes.
• Involved in teh following areas in Oracle EBS R12 Modules such as AP, AR, FA, GL, iProcurement, Purchasing and iSupplier.
• Prepared MD050, MD070 for technical and functional documents.
• Created Oracle alerts for major concurrent program failures and custom specific programs.
• Involved in teh business meetings for gathering teh requirements for all teh objects assigned.
• Developed interface between PO and Marketing system for details exchange like PO and invoice information.
• Customized reports in AR such as: Customers Profile Report, Aging Report.
• Designed, developed and documented for Conversion of Purchase Requisitions,
• Purchase Orders, Suppliers, Supplier Sites, and Items.
• Involved in implementing teh assets directly using teh Additions API via Invoices and cost adjustments to teh assets through API.s
• Modified AP, AR and PO module reports as per teh business requirement.
• Registration of concurrent programs, defining value sets and parameters for customer reports specific to Applications.
• Interfaced legacy system GL data using Journal Import. Ran Journal Import to load data into GL base tables.
• Provided teh functional and technical level support to resolve AR, AP, FA and PO related issues.
• Wrote custom program to import data from temporary table directly into vendor base tables (AP). Uploaded data into teh staging tables using Direct Path SQLoader.
• Performed System Administrator functions like registering of new reports, forms, functions, validation sets, request sets and concurrent programs.
• Prepared test cases for major impacted components.
• Support provided for UAT and postsGo- live issues.
• Developed Unixshell scripts for archiving of teh files for inbound/outbound folders and also developed program to handle teh files from inbound.
• Worked on Customizations of OAF Pages.
• Worked on Personalization’s of OA Pages.
• Excellent knowledge wif calling stored procedures from OA Framework. creation of LOV’s, pick lists, and advance tables for different pages.
• Experienced wif creation of BC4J components like AM,VO and EO.
• Designing MD070,MD120 and TE020 documents as per AIM Methodology.
• Involved in client discussions for resolving teh issues.
• Preparation of technical design document in OA Framework.
• Calling teh D2K forms into OAF Pages.
• Calling teh BI Publisher Report into OAF Page.
• Calling Concurrent Programs into OAF pages.
• Development of new OAF Pages, Regions and deployed into ORACLE EBS.
• Extensions in Standard Oracle I module pages.
• Extensions of VO, EO, CO in Custom Module and Standard Oracle pages.

Confidential, Minneapolis, MN

Oracle EBS Techno Functional Consultant

Environment: Oracle Applications Release 12.1.3 (AP, AR, GL, PO, SCM, WMS, WSH, INV, OM, TCA, iStore, iProcurement, iSupplier, Costing, Pricing,), Oracle 11g, SQL, PL/SQL, Forms 10g, Reports 10g, SQL * Loader, Oracle Workflow Builder, XML/BI Publisher, Unix Shell Scripting, OAF, JDeveloper11g.

Responsibilities:

• Prepared detailed functional and technical specifications for various conversions and interfaces objects.
• Involved in teh business meetings for gathering teh requirements for all teh objects assigned.
• Designed and Developed interfaces in SCM modules for various Third Party Logistics (3PL’s) clients based out in Europe, South America and South-East Asia.
• Involved in teh data conversion from teh legacy system of items, customer accounts and service contracts into Oracle EBS using standard API’s.
• Worked on teh development of custom process for Project Costing and Accounting.
• Involved in teh team responsible to integrate teh modules of iProcurement and iStore wif other EBS modules of SCM like Order Management (OM), Inventory (INV).
• Involved in teh unit testing and also conducted teh UAT for all teh conversion and interface objects.
• Created Unix shell scripts for teh data conversion from teh legacy system to Oracle EBS.
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities.
• Created AOL objects for teh development work using Oracle Applications System Administration
• Utilized various public API’s for teh development of inbound/outbound interfaces in teh process of Order-to-Cash business process.
• Involved in teh team implementing teh Order-to-Cash business process.
• Created migration files using FNDLOAD and prepared teh migration list of all teh objects assigned.
• Developed custom reports as per client requirement
• Customization of various reports as per client requirements.
• Developed XML Publisher Reports
• Worked on GL interface to load journals from legacy flat file to GL base table.
• Worked on item interface
• Developed Outbound Interfaces
• Worked on Customer Conversion
• Developed Forms as per Client requirement.
• Involved in teh areas of Customization of Oracle apps forms.
• Worked on form personalization.
• Extension of OAF pages & OAF Personalization's
• Created AM, VO, EO, LOV’s and pick list setting co as per client configuration
• Involved in page deployment from one instance to another instance

Confidential, Dallas, TX

Oracle Apps Consultant

Environment: Oracle Applications Release 11.5.10.2 (AP, AR, PO, SCM, WSH, INV, OM, Sourcing), Oracle 10g, SQL, PL/SQL, Java, Forms 6i, Reports 6i, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting.

Responsibilities:

• Created and checked teh order submission process from different customers for different items and groups.
• Extensively worked on materialized views, materialized view logs to replicate teh data from teh master tables.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Created parallel queries for teh optimization of teh SQL queries.
• Involved in teh implementation of Order to Cash modules: SCM, OM, Inventory, Warehouse, Purchasing, Receiving and module integrations wifOM, AP, AR, PO, INVinEBSSystem.
• Developed Custom Packages which in turn were used for reporting purposes.
• Responsible for custom program maintenance during teh production support.
• Created SQL queries to check teh information of Vendors, Customers, and Account payable, Account receivable to different vendors and from different customers using Toad.
• Created AOL objects using Oracle Applications System Administration for migrating objects from one instance to another.
• Responsible for teh day-to-day operations and direction of teh project planning and status reporting, scope management, documentation and facilitation between teh technical and functional team.
• Documented Processes and User Training Manuals for Maintenance Purposes.

Confidential

Oracle ApplicationsDeveloper

Environment: Oracle Applications Release 11i(OM, PO, AP, AR), Oracle 9i, SQL, PL/SQL,Forms 6i, Reports 6i, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting.

Responsibilities:

• Analyzing, Designing, Development and Implementation of various software’s systems and applications, researching delivering and enhancement in OM/PO applications.
• Involved in requirements gathering and analysis.
• Development of teh Solution to fulfill teh business requirements in Oracle E-Business Suite.
• Preparation of Technical Design Solutions.
• Preparation of Unit Test Cases for teh components developed.
• Optimize teh performance of teh deliverables.
• Development and customization of various PL/SQL procedures to validate teh data coming from Legacy systems as per customer requirement.
• Development & Supporting of PL/SQL, Workflow process, Interface, Forms and Reports.
• Involved in Form personalization.
• Fixing of technical and functional related bugs.
• Preparing Technical Design Documents.
• Implementation of Purchasing, Order Management modules in teh current Oracle ERP Applications environment.
• Registering various procedures and programs as Concurrent Requests.
• Involved in developing teh Unix shell scripting.
• Has done performance tuning for teh complex queries by using EXPLAIN PLAN and TKPROF.