PROFESSIONAL SUMMARY:

• Around 7+ years of experience in IT industry as Oracle Apps Functional Consultant with exposure to Financial, Supply Chain (SCM), HRMS Oracle Functional Modules
• Experience includes execution of 4 full lifecycle Oracle Applications implementations including the exposure to e - Business Suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Over 6 years of extensive experience on Oracle Supply Chain Manufacturing Applications consulting including Quote to Cash and Procure to Pay
• Executed critical projects as Business Analyst, Functional Lead, Onsite lead, Designer on Functional & Techno-Functional roles.
• Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, WIP, BOM, WMS, OM, Advance Pricing (QP), PO, INV, GL, AP, AR.
• Extensive experience with the Order to Cash and Procure to Pay business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, scripts, Functional Documentation, User Documents and Customization Documents.
• Knowledge of SQL, relational database query tools (e.g. TOAD).

TECHNICAL SKILLS:

Domain: Financial, Supply Chain, Discrete Manufacturing

Oracle Apps Modules: Order Management, WMS, WIP, BOM, Inventory, Shipping, Advance Pricing, Accounts Payables (AP), Accounts Receivables (AR), Purchasing, Payroll, General Ledger (GL), Fixed Assets (FA) and Purchasing.

Databases: Oracle data base 8/9i/10g/11g/12g

Software Tools: OAF, Developer 6i/10g(Forms & Reports), Discoverer, XML,SQL, TOAD, SQL2 PL/SQL, Oracle SQL*Loader, Workflow, Informatica and Webmethods,170 KOFAX Systems

Operating Systems: Sun Solaris, Windows, Unix, Linux

Business Skills: Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD Sessions, Gap Analysis, and Impact Analysis. Epicor experience.

Methodologies: Waterfall, Agile

Requirement Gathering Tool: Caliber and Team Forge.

Modeling & Designing Tools: Rational Rose and MS Visio

Operating Systems: Windows 95/2000/NT/XP/ and MS-DOS

Programming Languages: C, C++, Java

PROFESSIONAL EXPERIENCE

Confidential

Oracle SCM Consultant

Responsibilities:

• As a SCM Functional Consultant implemented the business flows including OM, INV, Shipping, Advance Pricing, WIP, BOM modules.
• Worked in the configuration of the OM modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for OM, INV, WIP, BOM, Shipping, Advance Pricing modules
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on the setups and configurations of WIP, BOM module
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across OM and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle E-Business Suite 11.5.10.2/12.1.3, Oracle DB 10.2.0.3.0, Load Runner, Win Runner, Quality Center, Sabrix Tax Software, QTP, Windows XP, UNIX, Ms-Office

Confidential

Oracle Functional Consultant

Responsibilities:

• Worked in the configuration of OM, WMS, INV, PO and AR modules.
• Performed Requirement and GAP analysis.
• Configurations and Setups for OM, WMS, WIP, BOM, INV, Shipping, AR, AP and GL
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Involved in the Item Master Setups in Inventory module including setting up of Item templates, defining Item Attributes, Enabling the items in various orgs, defining Item Attribute change controls, Worked on the Item Import mapping for item data coming in from external legacy system, etc.
• In Advance Pricing, Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks
• Worked on the setups of WIP, BOM modules
• Worked in a team in understanding the integration of Advanced Pricing with OM process
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.

Environment: - Oracle Applications Release 12.1.3 Upgrade from Release 11.5.10.2 Rollout for US and Canada INV, ADVANCE PRICING, OM, WIP, BOM, WMS, INV, PO, i-Procurement, AOL, System Administrator

Confidential

SCM Functional

Responsibilities:

• As a Functional Consultant implemented the following modules: OM, INV, PO, BOM and WIP modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP and GL modules.
• I-Procurement - Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle GL, AP, AR, OM and PO from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WYSE by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful to the users in OM, INV, PO, BOM and WIP Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential

Functional SCM Lead

Responsibilities:

• Involved - setup of item cross- to suppliers.
• Worked on the implementation of the OM, INV, PO, BOM and WIP modules
• Involvement in registration of DFFs, value sets, creation of executable and concurrent program setup in PO using Oracle AOL.
• Led off-shore development team, perform code review to provide quality product under tight timeline.
• Testing of the functionality along with UAT.
• Responsible for providing on-going and mentoring to business users and the operation support team.
• Involved - setup of item cross- to suppliers.
• Involvement in registration of DFFs, value sets, creation of executable and concurrent program setup in PO using Oracle AOL.
• Led off-shore development team, perform code review to provide quality product under tight timeline.
• Testing of the functionality along with UAT.
• Responsible for providing on-going and mentoring to business users and the operation support team.

Confidential

SCM FUNCTIONAL

Responsibilities:

• As a Functional Consultant implemented the Order to Cash Business flows including OM, Shipping, Pricing, INV, WMS and GL modules.
• Worked in the configuration of the i-Procurement modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for OM, i-Procurement, Shipping, AR, WMS and GL
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Setup WMS Module including defining of all of the warehouse, warehouse orgs, items, lots, serial control, Interfacing WMS with an external warehouse.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential

 Functional Consultant

Responsibilities:

• As a Functional Consultant in the Procure to pay business flows, implemented financial modules: i-Expense, GL, AP, AR, i-Procurement, INV, Service Contracts, Install Base, PO and OM of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Created the Collections Administrator, Collections Manager, Collections User profiles in AR module
• Implemented internal control features using Form Personalization’s for modules GL, Service Contracts, Install Base, FA, AP, and AR.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• Customization done on Customer Facing Documents like AR Customer Invoice for pre-printed stationery and using XML feature, inter Company Customer Invoice, AP -Remittance Advice.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, Service Contracts, Install Base, PO, AR, AP and GL modules as part of User Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Environment: Oracle E-Business Suite 11.5.10, Manual Testing, Windows XP, UNIX, Ms-Office, Load Runner, QTP and Test Director.