SUMMARY:

• 1 6+ years of experience in Information Technology, as an Oracle Apps Consultant for successfully in implementing Oracle Cloud, Oracle Applications E - Business Suite R12/11i for Distribution, Manufacturing and Financial clients.
• Expertise in business process and requirement analysis (AS-IS) system and mapping (TO-BE) them to system process.
• Hands on Experince in Oracle Cloud Procurement and Order Orchestration process with Pricing Strategies.
• Extensive knowledge in Oracle EBS Distribution Modules including Inventory (INV), Order Management (OM), Advanced Pricing (QP), Purchasing (PO), Accounts Receivables (AR), Accounts Payables(AP), Bill of Materials (BOM), Work in Process (WIP), Cost Management (CST), iProcurement (ICX), iStore(IBE), Oracle Alerts, Oracle incentive Compensation (OIC), Advanced Supply Chain Planning (ASCP) and Approval Management Engine (AME)
• Expert in Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles along with cross functional modules
• Demonstrated excellent management skills in handling full life cycle implementation going through Development, Conference Room Pilot (CRP), User Acceptance (UAT),, Go-live and Postproduction support in Multi-Org Environment
• Hands on experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents.
• Indepth knowledge of Agile process
• Worked closely with Oracle Support to resolve system issues via service requests (SRs) and Oracle Web Conference (OWC) for speedy resolution
• Functionally managed the project from concept through completion - defined Project Goals and scope, managed project deliverables and dependencies, played a key role in developing documentation and implementation requirements.
• Implemented Configure to Order process for PTO and ATO models with in PTO using configurator.
• Implemented KIT process for pick Items across multiple Orgs.
• Worked on the ASCP Setups - setting up the Item planning attributes, planners, planning parameters, defining the plan options, collection parameters, setting up Instances.
• Have complete understanding of Collection Methods.
• Implemented Unconstrained Planning.
• Created use cases based on the day in the life of Planners and Schedulers, then demonstrated the day to day activities using the planning Workbench in ASCP.
• Elaborated Horizontal and Vertical plan features for gross demand and supply.
• Proficient knowledge of Application Object Library (AOL).
• Working knowledge of Integrating Oracle with third party Ordering system
• Proficient in ER between tables in, Order Management (OM), Inventory (INV), Purchasing (PO), and AR Modules.
• Very Good understanding of RICE components
• Good understanding of Trading Community Architecture (TCA).
• Excellent communication skills with good interpersonal skills, hardworking and a good team player
• SDLC (Software Development Life Cycle)
• Business Process Improvements and Project Management

SKILLS DETAILS:

Oracle Applications: Oracle Cloud R13, Oracle Applications Versions: R12.X, 11i (11.5.10, 11.5.9, 11.5.7, 11.5.5) Inventory (INV), Order Management (OM), Shipping (WSH), Bills of Materials (BOM), Work In Process (WIP),iStore(IBE),Costing (CST), Purchasing (PO),iProcurrement(ICX), Receivables (AR), Advanced Supply Chain Planning (ASCP) and Approval Management Engine (AME)

RDBMS (Databases): Oracle 10g/9i/8i/7.x, MS Access 7.0/00/97, SQL*Loader, SQL*Plus, Oracle Forms 6i, Oracle Reports 6i, Kintana, Data Loader, UTL file

Other Tools: TOAD 9.7.2/8.5/8.0/7.5 , Query Analyzer, SQL*PLUS, SQL*Loader, MS VISIO.

Operating Systems: UNIX (HP-UX 11.0, Solaris 2.7/2.6, AIX), MVS 390, Windows NT/2000, Windows Server 2003/XP

Languages: C, SQL, PL/SQL

EXPERIENCE PROFILE:

Confidential, FL

Sr Oracle SCM Functional Analyst

Responsibilities:

• Migrated Job, location and Employee creation and updating from EBS to Fusion
• Migrated Suppliers, Sites, Contacts from EBS to Fusion and acknowledgement back to EBS via FBDI
• Implemented iProcurement for IT and office supplies using Catalog and non - catalog stores
• Configured Inventory and costing modules (Costing valuation unit at subinventory level)
• Migrated Items from EBS to Fusion
• Migrated Inventory transactions from EBS to Fusion using FBDI
• Created custom reports using OTBI leveraging Subject areas, Data templates
• Used OTBI reporting to extract data from Fusion to EBS by leveraging FTP feature
• Payables invoices integration from EBS to Fusion
• Currently Working on Customer and Order import process from EBS to Fusion
• Gathering and Analyzing Business requirements for Oracle Application to the newly acquired divisions
• Assist project leaders by scoping the proposed solution leading to accurate cost and time estimates
• Performed Map and Gap analysis of Business requirements to the system functionality in the area of Order to Cash (OM, INV and AR) and Procure to Pay cycles (PO, INV and AP)
• Implemented Intercompany Procurement and Shipping process using Transfer pricing with intercompany Advanced Pricing process using Custom Attributes
• Developed New process for Turfview to export and transfer data to BP lubricants
• Developed Custom Order capturing system and integrated into Oracle Order Management with Advanced Pricing Modifiers and Qualifiers using custom Attributes
• Imported Order from external systems using the Process Order API
• Designed Pricing Process by loading the Prices into Formulas and Modifiers
• In the process of upgrading to Oracle Fusion and gathering requirements for Inventory and Costing
• Currently working on Fusion Procurement, Inventory and Costing modules

Environment: Fusion R13: Procurement, Inventory and Costing Oracle Application 11.5.10.2-Modules Order Management, Oracle Inventory, Costing, Advanced Pricing, Oracle Purchasing and Oracle Receivables.

Confidential, FL

Oracle Functional Analyst

Responsibilities:

• Conduct requirement gather session with business users to Understand and capture the AS IS business process
• Performed fit gap analysis based on the AS IS process on the Quotes, Orders, Incentive Comp pay, Install base, Service contract creation process
• Setup the system with Quoting, Order management, Incentive compensation Install base and Service contract modules
• Conduct CRP with the business with the initial process flows

Confidential, MA

Lead Oracle Functional Analyst

Responsibilities:

• Enhanced procurement approval process using AME
• Pay commissions the sales reps using Oracle Application, Incentive compensation module (OIC)
• Integrated online Ordering system with Oracle to create Customers and Invoices in AR
• Work closely with onsite and offshore development team
• Review design documents
• Provide design inputs to the development team
• Perform 3rd line Production support in sustaining tasks to analyze defects
• Develop enhancements specifications and provide recommendations to business leads as needed
• Provided support to resolve issues with R12 Upgrade.
• Manage SDLC end - to-end process
• Conducted and facilitated CRP & UAT with the end users
• Oracle Application R12 -Modules purchasing, iProcurement, AME, Oracle Inventory, Oracle Receivables and Account Payables

Confidential, FL

Lead Oracle SCM Functional Analyst

Responsibilities:

• Gather and Analyze Business requirements for Oracle Application to the newly acquired divisions
• Assist project leaders by scoping the proposed solution leading to accurate cost and time estimates
• Performed Map and Gap analysis of Business requirements to the system functionality in the area of Order to cash (OM, INV and AR) and Procure to Pay cycles (PO, INV)
• Provided the solution for the EDI Orders (PO and SO) received from the major fuel pipelines via SOA composites and generate Invoice in AR
• Responsible for Order to Cash and procure to Pay R12 upgrade including custom Pricing and costing engine
• Optimized system processes for Order entry, Pricing, Costing, Inventory, BOM, WIP, Shipping and AR modules
• Implemented AR Credit invoice feature to have Due date on Credit Invoices as it will help in the custom EFT process
• Implemented Retro Active pricing process for BPA releases to accommodate the additional cost incurred in procurement process
• Implemented advanced pricing functionality in the Procurement and Order fulfillment process with option based pricing
• Implemented Average costing
• Implemented AME for Requisition and Quoting approval process
• Manage SDLC end - to-end process
• Provide end-user instructions, and support
• Conducted and facilitated CRP & UAT with the end users
• Lead system enhancements initiatives and support to resolve application issues

Environment: Oracle Application 11.5.10.2-Modules Order Management, Oracle Inventory, Costing, Advanced Pricing, Oracle Purchasing and Oracle Receivables.

Confidential, TX

Sr. Oracle SCM Functional Analyst

Responsibilities:

• Analyze Business enhancement requirements for Order to cash process in Oracle Applications
• Enhance and Test New Solutions related to Order Management, Advance Pricing, Inventory, BOM, WIP, Shipping and AR
• Implemented Audit trail on Order lines to track the changes in the process of Order creation and fulfillment
• Manage SDLC end - to-end process in the area of procurement and Order Fulfillment area
• Implementing Blanket Purchase agreements, Blanket Releases, Sourcing rules and Approved Supplier lists. once the planner releases planned order from Planning board, it should create blanket releases automatically.

Environment: Oracle Application 11.5.10.2-Modules Order Management, Advanced Pricing, Oracle Purchasing and Oracle Receivables.

Confidential, FL

Sr. Oracle Business Systems Analyst

Responsibilities:

• Analyze Business requirements to fit them into system processes
• Enhance and Test New Solutions related to Order Management, Cofigurator, Advance Pricing, Inventory, BOM, WIP, Shipping and AR
• Implemented FIFO costing and customized to attain the special purchase to consume a specific layer instead of FIFO layer for costing
• Provide Support for the Custom Applications and Order Management, Advance Pricing and Shipping Production Issues
• Manage SDLC end - to-end process in the area of procurement and Order Fulfillment area.
• Enhanced and tested Order fulfillment process to fit business requirement
• Integrated Order fulfillment process with custom application and Mobility devices
• Supported and Maintained AME for Quote Approval process
• Back to Back Order flow was implemented to reduce the operating cost of the products
• Implemented iProcurement module to have the division to raise requisition, which in turn are converted into standard PO based on CPA
• Implemented Intercompany process for centralized Procurement process
• Implemented Service contracts with Install based and Field services module
• Customized the PO Output communication and transmitted in EDI850 format to the trading partners
• Implemented custom functionality to pay installers payment based on the amount of work performed
• Integrated Installer payment process to third party application WorkBrain
• Designed and developed Key custom report to analyze business trend and help in making key business decisions
• Implemented Advanced Pricing for Sales process by customizing the QP Custom to meet the business pricing requirements
• Support production system with daily and month end closing issue

Environment: Oracle Application 11.5.10.2-Modules Order Management, Oracle Inventory, Advanced Pricing, Oracle Purchasing, Oracle Payables and Oracle Receivables.

Confidential, WI

Sr. Oracle Business Systems Analyst

Responsibilities:

• Worked as Business Analyst.
• Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.
• Involved in gathering requirements from user s and design functional documents and project management.
• Prepared functional Design MD 050 as per the business requirement.
• Resolved issues relating to the Drop ship Orders.
• Raise SR (Service Request) to Product Support for resolving production issues.
• Involved in testing the Functionality after applying the one - off patch as requested in SR.
• Used Form Personalization to customize the Order Form (OEXOEORD) to achieve complex business logic.
• Involved in cleanup of Resource and stuck Inventory transactions during month end period closing.
• Defined Defaulting rules in Order Management.
• Defined Pick Release and Pick Slip Grouping rules for picking and grouping the eligible Order lines as per the Business rules.
• Did Transaction, Transaction source and customer profile setups in AR
• Resolving the production issues related to Order to Cash flow.
• Thoroughly Tested the Order to Cash functionality as a post release step.
• Designed SRD (Service Required Document) using AIM Methodology for Enhancements.
• Involved in weekly meetings to implement any CRT (Change Request Template) on completion of approval process.
• Performed Root Cause Analysis for certain issues where Drop Ship Order Lines used to get closed when partial quantity has been shipped (as the Under Shipment Tolerance was set to 100%).
• Conducted user after implementing the new enhancements.
• Suggested and Implemented work around solutions as necessary based my per experience
• Always accomplished the SLA (Service Level Agreement) for the production issues based on the priority of the case raised in Remedy Ticketing System (Third Party Application).

Environment: Oracle Application 11.5.10.2, Oracle 10g (SQL, SQL*PLUS, PL/SQL, Forms 6i, Reports 6i), Windows 2000/NT, Linux, MS-Excel.

Confidential, PA

Sr. Oracle Apps Functional Consultant

Responsibilities:

• Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.
• Understand dependencies, time lines and Project Scheduling.
• Resolution of Functional and Technical Issues in Order Management, Purchasing and Inventory modules
• Create and Manage TAR s with Oracle Support.
• Period End closing support, Critical Support during Period close, Q - Close, Year End Close and during Release.
• Systematic approach towards problem solving and Understanding of user s Requirements through effective communication and suggested workarounds accordingly.
• Done various setups that arise due to Critical Business requirements Maintain Incremental Documentation revisions for Setups.
• Participated in Change Control calls to move the setups and fixes from Test to Production instance.
• Created complex folders and creating Item Classes.
• Exporting the business areas from Development instance to testing instance and testing instance to production instance.
• Performed Order Functionality testing after monthly migration in QA instance and suggesting if any changes based on the test cases.
• Maintaining scheduled workbooks.
• Solving CRP and UAT issues System Testing
• Go Live support
• Post Production User Support.
• Executed SQL Queries for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environment: Oracle Application 11.5.10, Oracle 9i (SQL, SQL*PLUS, PL/SQL, Forms 6i, Reports 6i), Windows 2000/NT, HP-UNIX

Confidential, CA

Oracle Apps Techno- Functional Consultant

Responsibilities:

• Worked as a Techno - Functional consultant.
• Designed Technical Spec s (MD70) for the Sales Order Conversion based on the provided Functional Spec.
• Tested the setups required for Order Conversion s such as Transaction Type s, Pricelist, Customer, Processing Constraints and mapping of Old Org s to New Org s based on test script provided as per the Business.
• Checked all the lookups required for the Order and Attachments and Dffs.
• Conversion of BOM along with the Routing and Operations using the Open interface from the Legacy application to Oracle Applications
• Developed the concurrent programs to migrate the Sales Order from Old Operating Unit to New Operating Unit calling the Order Import program with the Old Order to the new Order by Using the Order Number in the Orig sys document ref Column.
• Developed custom interfaces to convert Attachments and DFF s from Old Sales Order, to New Order using the standard and custom API s.
• Created ITG packages for the migration lines for all the packages, concurrent programs and Values sets.
• Checked the functionality of the Order Status and functionality after migrating into QA Instance.
• Worked closely with DBA in Tuning SQL queries using EXPLAIN PLAN, SQL TRACE and TKPROF
• My responsibilities also include providing Production Support.
• Involved in PostProduction Support after Go Live

Environment: Oracle Application 11.5.10, Oracle 9i (SQL, SQL*PLUS, PL/SQL, Forms 6i, Reports 6i), Windows 2000/NT, HP-UNIX