SUMMARY

• Oracle e - Business Suite Functional expert with 10 years of IT Experience including 10 years’ in-depth experience in design, support and implementation of software applications.
• Expertise in Order Management, Shipping, Cost Management, BOM, ASCP, Inventory, Inventory Optimization, Purchasing modules.
• Extensive experience in the Functional aspects of Oracle Applications Release 12
• Worked across different modules of the Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, Oracle Receivables, Oracle Order Management, General Ledger, Cost Management and Oracle Shipping.
• Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD)
• Extensive experience with Sub Ledger Accounting.
• 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 Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
• Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
• Strong communication & leadership skills with an ability to interact with business users and lead business projects.

TECHNICAL SKILLS

Oracle E-Business Suite: Financials and Supply Chain Management (SCM) Applications - 11i, Release 12.0 and Release 12.1

Database: Oracle 8i/9i/10g

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Oracle SCM Functional Consultant

Responsibilities

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for Order Management, Cost Management, BOM, SLA, ASCP, Inventory, Purchasing modules.
• Worked on Inventory Optimization module - defining the inventory plans, defined the plan options, cumulative demand distribution, setup constraints, configuring service level and fulfillment lead times, defined lead time variability, plan level default service level, service level sets, in transit lead times, setup performance indicators, setting query preferences, worked on the Analysis workbench, worked on integration with demand management.
• Worked on Oracle Cost Management - defined the cost elements, worked on Cost rollups, defined cost types, cost sub-elements, cost groups, overheads, associate expenditure types with Cost elements, defined category accounts, associate WIP account classes with category accounts.
• Worked on Oracle Bill of Material - defined the BOM Structures, BOM Item Types.
• Worked on Sub Ledger Accounting rules to customize the account derivation rules.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for SCM Modules (Order Management, Cost Management, BOM, SLA, ASCP, Inventory, Purchasing) to make sure flow is working without any issues.
• Conducting Pre-Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Order Management, Cost Management, BOM, SLA, ASCP, Inventory, Purchasing modules

Confidential, Marlborough, MA

Oracle Manufacturing and SCM Functional Consultant

Responsibilities

• Worked on defining the inventory plans and plan options.
• Defined the lead times, in transit lead times, cumulative demand distribution
• Configured lead times constraints
• Configuring service level and fulfillment lead times, defined lead time variability, plan level default service level
• Defined Service level sets, in transit lead times, setup performance indicators, setting query preferences, worked on the Analysis workbench, worked on integration with demand management.
• Worked on defining the Approval Hierarchies in Purchasing module
• Worked on the Procure to Pay Business flow enhancements
• Worked on setting up the Document Control and Security
• Developed the Back to Back and Drop Ship Order process involving OM and PO modules
• Configured the Auto Create functionality in Purchasing
• Configured the Buyers Work center in Purchasing
• Worked on setting up a centralized receiving process in Purchasing.
• Configured the cost structure.
• Worked on Standard Costing and Average costing setups
• Defined the cost elements and cost rollups
• Defined the material, material overhead, resource, overhead and OSP costs
• Defined the Sub Elements of material, material overhead, resource, overhead and OSP sub elements
• Setup the activity types
• Defined the resource value and units
• Setup the valuation accounts and cost elements for average costing
• Worked on retroactive cost adjustments
• Worked on Landed Cost Management
• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop Shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Worked on the setups of Modifiers
• Worked on defining Qualifiers
• Worked on setting up primary and secondary price lists
• Worked on setting up formulas
• Worked on custom attributes and attribute mapping
• Worked on configuring the Outside processing in WIP
• Setup the WIP Parameters
• Defined BOM Parameters for Phantom routings
• Defined Item Tolerance Types
• Defined WIP Accounting classes
• Setup Discrete execution workstation
• Setup the workday calendar in BOM
• Setup the BOM Item types of Models, Options, Option Classes
• Defined the mutually exclusive rules
• Configured the BOM Parameters
• Defined resources, department classes, simulation sets, defined locations, defined BOM Components and alternate BOM

Environment: Order Management, Inventory, Advance Pricing, WIP, BOM, Cost Management, Accounts Receivables, Shipping, Purchasing module.

Confidential, Santa Ana, CA

Oracle Manufacturing and SCM Functional Consultant

Responsibilities

• Worked on the setups for the PO, i-Procurement, OM, Shipping (Logistics/Reverse Logistics), Advance Pricing, INV, BOM, WIP Modules
• Preparing BR30, 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 following EDI Interfaces - 850 - PO Inbound and Outbound, 855 - PO Acknowledgement, 856 – Advance Shipment Notice inbound and outbound and 860 – PO Change inbound and outbound
• Worked on the setups of the Inventory module.
• Worked on the Reverse Logistics - Return Material Authorization (RMA) process in Oracle OM module
• Worked on the configurations of Order Management module – defining the Order and Line Transaction Types, defining the processing constraints, defaulting rules, setting up pricing attributes, etc.
• Worked on the shipping transaction file to be transmitted to the 3PL Logistics system using EDI transmissions
• Worked on the AR/AP netting process in AP module.
• Worked on the AP Processes of Retainage, Recoupment, etc.
• Worked on the defining the transaction types, financial options, tax rules in Oracle AP module
• Involved in understanding the existing business process & conducted meetings on client business overview
• Performed Gap Analysis so as to integrate the business requirements to oracle applications
• Prepared business requirements document for Purchasing and Order Management

Environment: Order Management, AR, Shipping, INV, i-Procurement, Purchasing modules

Confidential

Oracle SCM Functional Consultant

Responsibilities

• Performed solution pilot covering prototyping of “To Be” business process flows by analyzing the gap in the business requirements & then mapping it to oracle functionality
• Worked on setting up order verification holds and new customer credit check holds in OM
• Performed setups & did integration testing for split shipment, drop shipment process, RMA process, shipping parameters with Quoting, Order Management & custom made ‘Scheduling & Dispatch’ modules
• Worked on the Item Master setups including setting up of Inventory Orgs, Defining Item Attributes, Item Catalogs, Item Categories, Item Attribute controls, etc.
• Perform on-site deployment activities for oracle solution for Inventory, Order Management, quoting modules & custom solutions including ‘Scheduling & Dispatch’.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories
• Performed configuration setup of custom module ‘Scheduling & Dispatch’ & facilitated user validation.
• Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module
• Developed test scripts & conducted CRP testing for the Order 2 Cash cycle
• Involved in the deployment cycle for Item Mapping, Production Cutover activities, helping the Pilot divisions to Go-Live, & user support in live phase
• Documented new procedures & Involved in training the business users on the new processes and assisted them during their on-job training exercise

Confidential

Oracle SCM Consultant

Responsibility

• Provided analysis, design, installation, setup and rollout of Oracle 11i Order Management Logistics, Manufacturing module and established proof-of-concept.
• Setups included Multi Language, Multi Reporting Currency, Multi Organization
• Worked extensively on TCA architecture and was involved in migration of customers from various legacy systems into Oracle TCA architecture.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
• Developed interfaces and data conversion programs for applications
• Addressed operational problems, concerns, and questions posed by users
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Setting up profile options values (standard and custom), set up for OM, AR and PO.
• Involved in Inventory org setups.
• Was involved in the 4-D methodology (Discover, Design, Develop and Deploy).
• Preparing technical specifications for the sub modules like (Customers, OM, Shipping, Interfaces, etc).
• Implementation methodology documentation including technical specs and functional specs.
• Liaising with client key users and technical team, conducting CRP/testing
• Ensuring order Processing/Booking (OM) during month/quarter/year end and resolving inter-company accounting issues.
• Responsible for transfer of data from External systems like Web, EDI, PO to OM.
• Responsible for transfer of data from OM to AR and ensuring no records are stuck in the interface.
• Resolving issues related to flex fields and sysadmin setups.
• Design and development of custom reports and FSG reports.
• Design of custom forms and extensions for OM and PO module.

Environment: Oracle 8i, Developer 2000(6i), PL/SQL, SQL, Oracle Financial Applications 11i(11.5.10.1), AP, AR, PO, OM (Functional & Technical – AOL, Sys admin), SQL Net, Oracle Workflow, Oracle Discoverer, Designer 2000, TOAD, SQL Loader, Unix.