SUMMARY

• 10+ years of experience in Information Technology, as an Oracle Apps Consultant for successfully in implementing Oracle Applications E - Business Suite R12/11i for Distribution, Manufacturing and Financial clients.
• Extensive noledge in Oracle EBS Distribution Modules including Inventory (INV), Order Management (OM), Advanced Pricing (QP), Purchasing (PO), Accounts Payables (AP),Bill of Materials (BOM), Work in Process (WIP), Cost Management (CST), iProcurement (ICX), iStore(IBE), Oracle Alerts and Approval Management Engine (AME)
• Good understating of Data warehousing ETL process using Informatica Power Center 8.1
• Good understanding of Oracle CRM on demand
• Expert in Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles along wif cross functional modules
• Demonstrated excellent management skills in handling full life cycle implementation going through Development, Conference Room Pilot (CRP), User Acceptance (UAT), training, Go-live and Post Production support in Multi-Org Environment
• Developed business scenarios as per the requirement
• Hands on experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents
• Created RD-020, BR-30, BR-100, TE-040, MD-050, CV-040 and BP-080
• Created service requests(SRs) and follow up, conducted Oracle Web Conference(OWC) wif oracle support for speedy resolution for all high prioritized issues
• 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.
• Expertise in business process analysis, requirement analysis (AS-IS) system, (TO-BE) mapping, CRP testing, Integration testing, UAT, system configuration, data conversions, master data loading, regression testing, Go-live support, production support.
• Proficient noledge of Application Object Library (AOL).
• Working noledge of Integrating Oracle wif 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 wif good interpersonal skills, hardworking and a good team player
• SDLC (Software Development Life Cycle)
• Business Process Improvements and Project Management

TECHNICAL SKILLS

Oracle Applications: 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) 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

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Enhanced procurement approval process using AME
• Integrated online Ordering system wif Oracle to create Customers and Invoices
• Perform 3rd line Production support and sustaining tasks to analyze defects, produce enhancements specifications and provide solution recommendations to business leads as needed
• Provided support to resolve issues wif R12 Upgrade.
• Manage SDLC end-to-end process
• Provide end-user instructions, training and support
• Conducted and facilitated CRP & UAT wif the end users

Confidential, FL

Sr. Oracle Apps SCM Functional Analyst

Responsibilities:

• Gather and Analyze Business requirements to roll out Oracle Application to the newly acquired business
• 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 and Procure to Pay cycles
• Provided the solution for the electronic Orders(PO and SO) received from the major fuel pipelines via SOA composites
• Responsible for Order to Cash and procure to Pay cycle R12 upgrade including custom engines for Pricing and costing
• As part of the design enhance and Test New Solutions related to Order Management, Advance Pricing, Costing, Inventory, BOM, WIP, Shipping and AR
• 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 wif option based pricing
• Implemented Average costing
• Implemented AME for Requisition and Quoting approval process
• Manage SDLC end-to-end process
• Provide end-user instructions, training and support
• Conducted and facilitated CRP & UAT wif 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

Oracle Apps SCM Functional Analyst

Responsibilities:

• Analyze Business requirements of enhancements for 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

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

Confidential, FL

Oracle Business Systems Analyst

Responsibilities:

• Analyze Business requirements of enhancements for Applications.
• Enhance and Test New Solutions related to Order Management, 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 Application and resolve 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 wif 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
• 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 wif 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 training 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 wif 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 TEMPeffective 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 wif 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 wif the Old Order Reference 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 wif DBA in Tuning SQL queries using EXPLAIN PLAN, SQL TRACE and TKPROF
• My responsibilities also include providing Production Support.
• Involved in Post Production 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

Confidential

Oracle Apps Techno- Functional Consultant

Responsibilities:

• Worked as a Software Engineer and Team Member.
• Worked on the Oracle e-Businesses Suite 11i ERP Implementation, involving inbound and outbound interface designs, reports upgrade, and forms upgrade and testing.
• Worked on the interface design that involves the design of the new study of Dependencies and the design of the program coding
• Worked in the development team responsible for the following technical components.
• Importing of Sales Orders of two Operating Units from the Legacy system into Oracle in Booked status.
• Conversion of the entire Legacy Items into Oracle Apps along wif its Revisions and Attachments using the Item Import program.
• Report on status of all Order from certain date.
• Report to show all the open backlog orders-order type and warehouse, will display values from all Operating Units.
• Customization of Sales Order Form (OEXOEORD) to populate territory in the DFF in Order Headers block based on salesperson entered.
• Loaded data using SQL*Loader.
• Involved in Web Enabling, Performance Tuning and Import/Export activities
• Developed HTML Pages, Java Script and PL/SQL HTP Procedure for Web Access.
• Developed User-friendly Interfaces using HTML, XML, and Java Script for Web accessing.

Environment: Oracle Application 11.5.7, Oracle 8i (SQL, SQL*PLUS, PL/SQL, Forms 4.5, Reports 2.5), Windows 98/NT, UNIX

Confidential, IL

Oracle Apps Consultant

Responsibilities:

• Participated in weekly meetings wif client and appraised the work status.
• Analyzed the requirements of enhancements for Applications.
• Design, create and modified test cases in Excel and converted accordingly using Application Implementation methodology (AIM).
• Interact wif Business Analyst, Developer to clarify the issues related to test date and Test cases design and business rules, workflow and functionality of application.
• Creating and executing test cases for validating data in OM, INV and AR tables before and after Up-gradation process.
• Created test cases to check the Inventory Organization, Sub-Inventories Setup’s including the locator definitions (Staging lanes and Dock Doors).
• Created and tested Sales order in OM by defining Pricelist, Customers, Items and Transaction types.
• Tested validation process such as Processing Constraints while processing the Sales Order, creating value sets, Entering New segment values, create new DFF’s and Security rules
• Create and execute test cases for AR interface tables to test whether the stating data loaded matches wif that of data in the legacy system data.
• Tested the BOM setups and Routings and Operations for Configuration.
• Create and execute test cases for Account Analysis, Account Analysis reports-Standard, Receivables details standard, Sub-Ledger standard.
• Executed the test case to check and validate process for Form Personalization for PO form (“NO PO will create less than $1000”)
• Create and execute test cases for reports like VDS reports, Cancelled Orders, RMA Orders and testing the basic functionality of the Items in Inventory.
• Performed end-to-end testing by executing the SQL queries to monitor the Order to Cash cycles during the entire Business flow (Order from Entered to Invoice).
• Analyzing the data errors by executing the SQL queries after conversion using Toad in QA instance.
• Attended code review, project status meetings, walkthrough and inspections.

Environment: Oracle Application 11.5.7, Oracle 9i (SQL, SQL*PLUS, PL/SQL, Forms/Reports), Windows 2000/NT, UNIX, MS-Excel.