SUMMARY:

• 7 years of experience in Oracle E - Business Suite,Experince in Design, Development, Production support Implementation and Customization of business applications usingOracle Applications.Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions
• Oracle Procure to Pay P2P Implementionaiton and Production support.
• Oracle Order Management Production Support.
• Oracle SQL, PLSQL Queries to meet business Requirment
• .Possess excellent communication skills, good team-management and leadership qualities and can work independently or collaboratively in teams.
• Expertise in RICE - Reports, Interfaces, Conversions and Extensions.
• Experience in developing and customizing Oracle reports using XML Publisher
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Future Business Mapping Document (BP-80) and Business Requirements Mapping Documents (BR-100) user manuals, test procedures document preparation.
• Extensive Experience in Business requirements gathering, gap analysis, software design, development, enterprise integration, data migration, conversion, interface, Fast Formulas, development/customization of forms and reports, development of custom modules and integrating them with Oracle applications, developing test plan and test cases, testing, implementation and support.

TECHNICAL SKILLS:

Oracle Applications: Oracle Purchasing, Oracle order management, Oracle Payables, Oracle I procurement, Oracle I, Oracle Inventory

Tools: Oracle SQL developer, TOAD

Operating Systems: Windows XP/2000/98, UNIX, Sun Solaris

Languages: SQL, PL/SQL

WORK EXPERIENCE:

Confidential, Seattle, Washington

Functional Analyst -SCM

Responsibilities:

• Inventory Synchronization in Oracle and source system and resolving all Internal IR, SO, Order import, Pick release, order shipment, PO release, ASL, sourcing rules, ASN, sub inventory transfer and Dock receipt error transactions.
• Addition of new customer to IMM program by setting up new OU, inventory org, shipping networks, customer account and sites, setting sourcing rules and ASL for items and addition of new blankets, supplier, supplier sites and all purchasing and order management setups before placing any PO or SO in system.
• Process improvement and optimization for Boeing Gold care, REP program which involves improving better compatibility of Non oracle system ( customer facing) with Oracle and maximum utilization of Order Management for capturing order information and order fulfillment process.

Confidential, Fargo, North Dakota

Functional Analyst - Procurement

Responsibilities:

• Supporting Oracle Purchasing, Oracle Payables, I procurement.
• Testing for P2P cycle on deployment of Patches and working with Oracle with Oracle support group on SCM related Service requests.
• Provides Automation of PO, Blanket approval process to value add to Business and handling expired Users.
• Supporting Client build Custom supplier portal which interacts with Supplier to raise ASN, Warranty claims, Sales order etc.
• Resolving all PO workflow, Drop ship order flow, Return to supplier, Return from customer and all receiving error transactions issues.

Confidential

Functional Analyst - Procurement

Responsibilities:

• Oracle Purchasing and Inventory management- India Localization
• ASL, Sourcing Rules, price breaks in BPA, Inventory setup, Purchasing Setup, Automatic Release creation, New org setup
• Create Inter-org transfer, pay on receipt (ERS) Invoice.
• Receipt creation, inspection, return and correction.
• Oracle Order management setups for internal transfer.
• Prepare Business Requirement document and High level document to prepare the Sales Reporting Tool for Panasonic India.
• Prepare interface document with IBM congas to fetch the data from Oracle database and do data normalization as the fundament step for building Sales Report.
• Helping Business to understand Oracle Customer TCA architecture and probing Sales team to capture the requirements accordingly.

Confidential

Functional Analyst

Responsibilities:

• Oracle Order management- and Procurement- India Localization
• Oracle Purchasing Approval Hierarchy setup, PO approval process customization (auto approval).
• Drop ship order and raise internal or Purchase requisition to procure material.
• Oracle warehouse management (Pick slip, Pick confirm and ship confirm) a SO.
• Interface and report design for Canada Implementation.
• Excise and Commercial Invoice design and report building in XML publisher Report.

Confidential

Functional Analyst

Responsibilities:

• E2E Regression Testing for every month release.
• Preparation of ETP (estimates), WSR (weekly status Report), GWR (Group Work Request).
• Understanding the High Level Document and carry out the regression testing for that functional domain and supporting the Users to carry out UAT successfully.
• P2P cycle, I Procurement, Supplier and supplier site creation.
• Shopping cart, requisition, express receiving, expense Reports imports to Payables etc.
• Oracle Receivables and Oracle GL overview
• Inbound and outbound Interfaces to Oracle apps application.

Confidential

Techno-Functional Analyst

Responsibilities:

• The project included the Development and implementation of various extension and gap processes, Design and preparation of Test Plans and resolving the technical and design issues and unit testing of developed code..
• Basis of P2P and O2C cycle and knowledge of Oracle TCA architecture.
• Standard PO, Receipts and 2 and 3 way matching, Receiving, Invoice generation, validation, accounting and Payment process.
• Requirement analysis, design and code Development for complex requirement of Supplier and customer merge.
• Regular monitoring of client specific reports.
• Identifying the Business Requirements gaps and testing various components (Interface and Reports) for P2P cycle.
• Forms personalization and customization.
• Production support for the Arrow ECS MOCA goes live system.
• RFQ, Quote, Requisition and BPA and release creation for testing the custom components and Defect Fixing and Code development for change requests
• Code Revamp
• Analysis of Change request.
• UAT and SIT Support.
• Conversion Process (Customer Forecast conversion Via Oracle data integrator).

Confidential

Software Engineer

Responsibilities:

• During this period, I went through the Initial Learning Program at Confidential and learning the Oracle RDBMS, Oracle PLSQL, Oracle APPS functional Modules introduction and various other computer basics. The role in the first project for BT was to aim at implementing BPEL as a Middle tier between the Seibel order management and Clarify Order Fulfilment system.The project involved supporting the already designed BPEL middle ware and upgrading and implementing the new business processes on BPEL
• Understanding existing XML, XSLT, DTD, WSDL, SOA architecture and fixing the bug in the middleware and try to process source order data to destination location.