SUMMARY

• Oracle Business Analyst with more than 7.8 years of aggregate Experience.
• Extensive experience with being a Functional Consultant in Supply Chain modules and Manufacturing modules of Quoting, OM, Procurement, Inventory, Service Contracts, Install Base, Shipping, Advance Pricing, BOM, AR
• Over 7 years of experience in Supply Chain Management and IT Consulting.
• Core Team - member during Oracle Application Implementations for several clients
• Extensive experience with functional tracks
• Developed Functional specification Documents (FSDs), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
• Developed the following AIM Documents BR100, MD050, RD020, RD030, TE030, TE040, etc.
• Primary Skill set: Excellent Functional experience in Inventory, Oracle Channel Revenue Management (OCRM), Order Management, WIP, BOM, Shipping, Quoting, Service Contracts, Install Base, Advance Pricing, AR
• Good knowledge and a high level of expertise in the functional aspects of the Oracle Purchasing, Advance Pricing and Daily Business Intelligence Modules
• Strong in Oracle Apps Implementation - Business Process Mapping, Gap Analysis, Test cases, Data Migration, Localization setups
• Proven ability to develop creative solutions to Material flow/Supply Chain management challenges

TECHNICAL SKILLS

Oracle E-Business Suite: Oracle Applications R12.1.3, 11.5.10.2, 11.5.8, 11.5.5 & 11i

Oracle ERP Modules: Extensive Experience: OM, Oracle Channel Revenue Management (OCRM), Procurement, Service Contracts, Install Base, Quoting, Shipping, Advance Pricing, Inventory, WIP, MRP, WIP, BOM

Oracle E-Business Components: Oracle Financial Statement Generator (FSG), Oracle Approval Manager (AME), Oracle Hyperion Finance Management and OBI.

Databases: Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools: Oracle SQL, PL/SQL

General Tools: Toad, Microsoft Office, MS Visio, MS Projects

OS Platforms: Sun Solaris, Oracle Linux, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

Quote to Cash Business Analyst

Responsibilities:

• As a Functional Analyst implemented the following modules: OM, Shipping, Advance Pricing, Quoting, Channel Revenue Management, Install Base, Service Contracts, INV, PO
• Worked on the Functional mapping of data Conversions & Enhancements for OM, Quoting, Service Contracts, Install Base, INV modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on the Channel Revenue Management - worked on the supplier ship and debit, channel rebate and point of sale, price protection process, AR Deductions Settlement, etc.
• Worked on Channel Revenue Management APIs to develop inbound and outbound interfaces to POS system
• Worked on Inventory setups - defining the Organization Structure, defining the Sub Inventories, Catalogs, Categories, Planning (Min Max and Re Order Point Planning), Defining Cost Groups, ABC Analysis, Cycle Counting, Physical Inventory
• Worked on the setups of OM Module - Defining the order and line workflows, defining the transaction types, setting up Processing constrains and Defaulting rules.
• Involved in troubleshooting issues on Item Import Program In oracle INV module
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in Inventory, Order Management, BOM, Shipping and Advance Pricing, AR Modules.

Environment: Oracle Apps Release 12.1.3/11.5.10 e-Business suite (Inventory, Order Management, BOM, Shipping, Advance Pricing, AR)

Confidential, Chicago, IL

Functional Consultant

Responsibilities:

• Implemented the following modules: Inventory, Order Management, Service Contracts, Install Base, Quoting, Oracle Channel Revenue Management (OCRM), AR
• Worked on the Functional mapping of data Conversions & Enhancements for Inventory, Order Management, Channel Revenue Management (OCRM), AR, Service Contracts, Install Base, Quoting, Shipping, Advance Pricing modules
• Worked on the Inventory module - defining the System Items, Category, Catalog, Sales Order, Account Alias flex fields.
• Worked on setting up Min Max and Re Order Point planning in Oracle INV module
• Worked on the ABC Analysis, Cycle counting and Physical Inventory of INV Module
• Worked on the setups of Transaction Types and Move Order process in Oracle INV module
• Worked on the setups of OM Module - defining Processing Constraints, Credit Check rules, setting up defaulting rules, Transaction Types, Header and Line workflows, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Inventory, Order Management, BOM, Shipping, Advance Pricing modules from scratch and simultaneously created BR100 documentation for the setups.
• Involved in troubleshooting issues on Transaction Import Program in Oracle INV module.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in Inventory, Order Management, BOM, Shipping, Advance Pricing modules

Confidential, Germantown, TN

Quote to Cash Business Analyst

Responsibilities:

• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the functional design for customizations, in Processes, Programs, and Reports.
• Performed all of the setups and configurations for Inventory, Channel Revenue Management, Order Management, Service Contracts, Install Base, Quoting, BOM, Shipping, Advance Pricing Modules.
• Worked on the Channel Revenue Management module - worked on channel rebate and point of sale management including quota allocation, budget management, worked on the account manager dashboard, chargebacks, third party accruals, soft funds, etc.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 12.0.6 instance from end to end including enhancements and extensions.
• Worked on rectifying error transactions in Auto Lock Box Interface Table.
• Developed test scripts for testing the order to cash process.
• Tested several patches that were applied to the 12.0.6 instance for functionality as well as performance.

Confidential, Jersey City, NJ

Quote to Cash Business Analyst

Responsibilities:

• Functional team member for supporting and managing the Oracle Inventory, Order Management, Service Contracts, Install Base, Quoting, BOM, Shipping, Advance Pricing for a Global Rollout for US, Canada, Mexico and UK
• Designing of functional and technical specs which included working with customer to set priorities and develop specifications for changes to the applications and reports
• Gathering business requirements and doing gap analysis
• Doing setups in oracle purchasing pertaining to operating unit and inventory organization level
• Inventory organization setup including average costing parameters, shipping networks, cycle and physical counting cycles, transaction types, sub inventories, catalogs and categories.
• Analyzing business requirement to setup receiving options and purchasing options
• Worked with development meet to upload items, shipping networks and resolve issues.

Confidential, Kansas City, MO

Quote to Cash Business Analyst

Responsibilities:

• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the customizations, in Processes, Programs, and Reports.
• Performed all of the setups and configurations for Inventory, Order Management, BOM, Shipping, Advance Pricing Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Tested several patches that were applied to the 11.5.10 instance for functionality as well as performance.

Confidential

Team Member

Responsibilities:

• Identifying the specific report requirements and functional specifications, the information
• Exchanges between various modules and firming the customization specifications.
• The reports included Order Booking, Order Status Details, Ordered Entered Details, and Shipping Details after confirmation and Return Details.
• Preparing the plan for development of various reports including the input and output parameters for the reports
• Reviewing the developed reports.
• Unit Testing the Reports through use of Unit Test cases.
• Providing Offshore support to the implementation team on site.

Confidential

Oracle Functional Consultant

Responsibilities:

• Collaborated with casting suppliers, analyzed gear demand data and built demand forecast model to ensure material availability.
• Introduced inventory control model based on the replenishment time of raw material and demand of finished product. Reduced the inventory from 10,000 to 4,000 and saved $15,000 per annum.
• Prepared Master Production Schedule (MPS) depending upon the production plan and inventory level. Planned material requirements for the 15 components according to MPS. Adjusted production and inventory quantity according to holiday events for the workers.
• Designed database to automate employees, workers and supplier record keeping. Reduced and eliminated the non-value added activities to make lean manufacturing.