SUMMARY

• Around 10 Years of ERP functional experience which includes expertise in Oracle Inventory (INV), EBS,MFG, Order Management (OM), Bills of material (BOM), Work in Process (WIP), Procurement, iprocurement and Support as Functional Consultant.
• Having enriched experience as ERP analyst, setups, testing, gap analysis, delivery and deployment in Supply chain, Manufacturing business processes.
• Strong Expertise in Advance Pricing, Advanced Supply chain Planning(ASCP), Shipping (WSH), Purchasing (PO),SME, Sourcing, iSupplier Portal, iProcurement, AP, AR, GL,FA (fixed Assets).
• Good understanding about SDLC and requirements gathering.
• Ability to work with Cross - functional teams including Users, Business Analysts and Technical Consultants. Good Inter-personal, Reporting, and Communication skills.
• Expertise in preparation of business requirements and functional specifications for conversion of master data & transactional elements such as items, categories, transactions, on hand, bills, routings, customers, Sales orders, purchase orders, & discrete jobs.
• Developed functional specifications for application Extensions, Interfaces and Custom reports.
• Extensively worked on business requirements gathering, Solution design, business mapping, configuration, set-ups, testing (Unit & Integrated) etc.
• Worked on Order to Cash (O2C) and Procure to Pay (P2P) processes.
• Demonstrated ability to facilitate system review, data analysis, Conducting CRP & UAT and situation assessment.
• Through understanding of As-Is Process, designing To-Be Process, gathering business requirement, performing gap analysis, building RICE (Report, Interface, Conversion, Extension), Configurations throughout all phases i.e. CRP’s, Testing.
• Writing or reviewing the test cases to test the requrimens.
• Experience in Procure to pay Modules i.e iprocurement, iReceivables, Purchasing, Accounts Payables, Accounts Receivables.
• Experience with the Lockboxes in Receivables module.
• Experience in Teaching.

TECHNICAL SKILLS

ERP Software: Oracle Applications 11i, Oracle 11.5.8 to 12.1.3, 12

Supply Chain: Order Management (Order Entry, Pricing, shipping), MRP

Core Mfg: Inventory, BOM, WIP, OPM,MFG, Costing

Procurement: Purchasing, iprocurement

Finance: AR,AP,GL, FA (fixed Assets)

Databases: Oracle, SQL Server

Languages: PL/SQL, Visual Studio

Operating Systems: Sun Solaris 2.5,Windows (XP/2000/NT/98/95),MS/DOS

Industry Knowledge Areas: Supply chain planning, ASCP,EBS, Inventory Management, Engineering / BOM / Cost, iReceivables, Order Management, Manufacturing, Procurement

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Senior Oracle Financial /Business System Analyst

Responsibilities:

• Gathering requirements and come up with a formal BR100 and MD50.
• Coordinate with Technical team and B2B teams and get the development done.
• Once the product or changes are Released ; Perform the Regression testing.
• Debug the Issues and code if required and Convey the same to Tech or B2B team according to Resolve the issues
• Coordinate with Uses and add any more requirements or changes to any of the functionalities.
• Provide the Overall status and Coordinate with different groups to finish the tasks and fulfill the requirements.
• Perform the required setups in Oracle apps
• Go through the log files and code to understand the flow or logic to match up with the requirement.
• Take the ownership of the deliveries and clarification on requirements.
• Worked on E2Open application and debugged the issues
• Worked on Network console of E2open and identified the issues and resolved the same with the tech teams.
• Trained the users with data and any validations
• Worked on Oracle apps Modules Sourcing, ASCP, Purchasing, Receiving, Order Mangement, shipping, AR, AP, Planning and Outsource Manufacturing (MFG), iProcurement, MRP Planning.
• Worked on full cycle of P2P and O2C and handled any implementations for Phase 2.
• Worked on Manufacturing Modules BOM, WIP, Configurator.
• Functional Lead to support Inventory, iReceivables, Purchasing, Advanced Purchasing, Order Management,SME, EBS, BOM, & WIP, Install base, pricing, Planning, GL,AR,AP,FA, O2C, OPM,P2P cycles
• Implemented to R12.1.3 and worked on sql developer, writing different queries and extract the data as required.
• Overall lead for the implementation project and enhancements.
• Performed Gap analysis and defined Custom Components, Setup and Conversions.
• Took the responsibility for regression testing ; delegate work to Offshore team.
• Lead Offshore calls to explain the functionality and expected output.
• Get the status from Offshore team.
• Provide the status to the Client with daily emails and weekly deck presentation.
• Regular updates to MD50 and get approvals from Business users for the same.
• Overall responsible Team lead and Team Player accordingly.

Confidential, Schaumburg, IL

Oracle Apps Financial Functional/BSA

Responsibilities:

• Gathering the Requirements and involved in the design sessions
• Working on a ongoing implementation project.
• Work on implementing Oracle R12 system from different 11i and legacy systems.
• Involved in usecase meeting and creating the usecases.
• Have drawn the Visio diagrams for the As is and To be system.
• Providing Functional inputs / clarification to the Technical Teams
• Period review and reporting of Case Analysis, Case Statistics
• Providing inputs on functional process improvements as required.
• Identifying different types of possible errors when interfacing with Legacy
• Modification in Picking Release rule to overcome some of the issues with Legacy
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks, Transaction Sources.
• Set up of Order Management with Order Cycles, ASCP, Order Types, RMA types with various classes, Order Holds
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Performed Thorough Analysis of the company’s Supply Chain and Manufacturing (MFG).
• Assisted Lead in requirements gathering process from the Business SMEs and prepared as-is, To-Be documents.
• Assisted lead in the process of interfacing various legacy systems with Supply Chain and Manufacturing modules.
• Developed the System Requirements Documents and configured system by mapping the BR with Oracle EBS Standard functionality.
• Assisted SCM and Manufacturing consultants in module related setups.
• Involved in various setups in SCM such as Replenishment setups, Cycle Counting, ABC analysis, Item setups etc.
• Involved in manufacturing setups such as Defining Bills and Routings and Scheduling rules for Flow Manufacturing.
• Involved in Interfacing Inventory and Manufacturing modules with Order Management and Purchasing Modules.
• Performed Gap analysis and defined Custom Components, Setup and Conversions.
• Involved in System Integration Testing (SIT1,SIT2,SIT3) UAT .
• Resolved the issues and did a end to end implementation for the Phase1.

Confidential, Duluth, GA

BSA Lead SCM/Manufacturing Functional Consultant

Responsibilities:

• Functional Lead to support Inventory, Purchasing, Advanced Purchasing, Order Management, BOM, & WIP, Install base, pricing, Planning, ASCP, GL,AR,AP,FA, OPM,O2C, P2P cycles
• Handling tickets and application support to the end-users. When an issue is received, analyzed and resolved
• Worked with Oracle Support team in case of any bugs.
• Worked with technical team for implementing or any change request
• Run diagnostics requests, SQL’s or any other required to identify or resolve the issue, then run those required (data fix SQL’s when Required) and update SR’s and co-ordinate with oracle support team till closure
• In case, if the issue requires the support of Database Technical Consultants/DBA, then Describe and transfer the issue to Technical Consulting team with the inputs. Monitor and help Technical team to complete the task
• Prepared MD050/MD060 documents for any customizations
• Prepared Test Cases, Test Data & testing.
• Interacted with client/end users & updating the issue status.
• Trained the end users and preparing end user training material.
• Involved actively in quarter end and month end related issues
• Prepared the frequently occurring issues and solutions documentation.
• Worked to fix the frequently occurring issues by doing the root cause analysis and fixing the issue.
• Performed Data flow & Gap analysis with UML using MS Excel, MS Visio, Rational Rose
• Translated business requirements into functional specifications for communication to technology team
• Developed source to target data mapping for the source elements and created transformation rules as per the business need
• Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application
• Performed Data flow & Gap analysis with UML using MS Excel, MS Visio, Rational Rose
• Designed solutions in shortage management, kanban in shop floor, workorderless completions, repairs, outside processing cycles.
• Have prepared documentation as Oracle’s AIM Methodology, taken business Sign-Offs on various test results and have provided approvals for further progression of upgrade activities
• Perform Gap analysis between business requirements and Standard functionalities of Oracle ERP application.
• Worked with the end-users and management to resolve issues and bridge business process gaps.
• Designed WIP Interfaces for Discrete Manufacturing invoking Oracle SOA based web services
• Discussed with various business units to gather required information and setting up of locations and Employers Approval groups, Purchase orders approval hierarchy, and Receiving options.
• Training the users on order entry, pick release, ship confirm, Invoicing processes. Trouble shooting shipping issues and reservation issues.
• Have Conducted onsite solution reviews, UAT, and sign-offs for new RICE Components development, solution delivery, and production cutover.

Confidential, Boston, MA

Oracle SCM/Manufacturing Functional Consultant

Responsibilities:

• Onsite Lead to coordinate with Business analyst of the Client and the offshore team
• Working on various issues related to the SCM modules ( Inventory, OM, Purchasing and CDQ)
• Worked on Upgrades Oracle 11.5.8 to 12.1.3 and some of the support technical issues.
• Supporting the project by solving the issues raised by talking to the end users on call and coordinating with Onsite and Business analysts.
• Mapped the existing system with the Oracle Applications, defined various Order cycles for different business purposes and involved in setups, implementation and train users of the Oracle Inventory system
• Analyzed the business requirements for INV, Order management, BOM, FA (fixed Assets and WIP and business process in the area of OPM.
• Closing the tickets related to inventory, Planning, CDQ, purchasing or Order management
• Providing Functional Assistance to the team in modules on SCM related modules
• Triaging the tickets to the respective queue.
• Interacting with technical team with the Business requirements and Business understanding.
• Interacting with the Business analyst of the client to understand the business and with the suggestions for the Improvement.
• Monitoring the similar kind of issues and building a permanent solution for the same
• Identifying the root causes for the issues and implementing the proposed solution.
• Get the required patches moved to production after complete testing on test instances.
• Closely worked with Business analysts and team members for analysis and changes.
• Responsible for Understanding existing Processes and suggesting good business practice. Production support for Manufacturing and Inventory modules.
• Responsible for Month end period closure. Periodic monitoring of pending transactions to close the inventory accounting periods.
• Resolved Transaction open interface and pending transaction issues. Working on issues related to pick release, pick confirm, deliveries, reservations. Resolving the issues on ticket basis.
• Assisted in the setting up the preference for workbench and personalized folders in workbench for viewing MRP output. Helped Planning super users in Troubleshooting and solving the issues related to MRP, WIP and Inventory. Interacting with super user for developing user required reports.
• Creating the setup for plans, planning parameters, MPS and MDS input for a new organization and new release. Worked with planning super users to train them on the MPS/MRP flow in Oracle Applications and Helping Planning super users interpret the exceptions and suggestions from MRP runs Understanding the present (AS-IS) process and Defining and Documenting To-Be Processes for the company based on good business practice. Production support for Manufacturing and Inventory modules.
• Assisted in the setup for Forecasting demand, profile options and MRP planner workbench setups. Helped Planning super users interpret the output from workbench and training them on MRP module.
• Creation of BOM, resources for Sub-assemblies and Finished Goods and also Created Routings, Standard operations for routings. Worked on INV replenishment methods Min-Max and Kanban replenishments
• Status calls with onsite with the status reports of the project.
• Taken the Lead role and allocated the tickets to the team members.
• Mentored and conducted training in the SCM modules and in soft skills for the new joiners.
• Participated in SCM COE meetings
• Conducted the knowledge sharing sessions on the support issues.
• Proactively monitored the month end preventing related issues and cleared the records accordingly.
• Documented the repetitive issues with the data fixes and worked on root cause analysis and worked with Oracle and got the permanent resolutions.
• Documented the solution documents for the new issues resolved and P1 related issues.
• Participated in CMMI documentations and meeting.
• Conducted CRP sessions for the ATO / PTO models & configured the systems for ATO and PTO models.

Confidential, Hopkinton, MA

SCM Functional Consultant

Responsibilities:

• Mapped the existing system with the Oracle Applications, defined various Order cycles for different business purposes and involved in setups, implementation and train users of the Oracle Inventory system
• Defined and maintained ABC classification of items and Cycle counting procedures.
• Played a crucial role in streamlining the business process in the area of OPM.
• Resolving the day-to-day issues in PO, INV, OM and OPM modules.
• Providing functional support to the team
• Involved in upgradation and implemented the oracle apps for other branches.
• Analyzing and working on various functional issues
• Research on various new functionality and features in R12
• Worked closely with technical team to explain the Business related functionality.
• Regression testing for existing functionality over new fixes.
• Conducted knowledge sharing sessions on the setups required for Order management
• Assisted in creating Physical inventory operational instructions defining business process requirements and Oracle techniques necessary to conduct the physical inventory process in multiple warehousing and manufacturing facilities
• Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration
• Worked on completion order cycle setups from, order entry in order management to ship confirm in shipping execution modules and invoicing.
• Worked on O2C and PTP cycles related issues and implementing few modulus related to Order Management.
• Successfully implemented Standard Purchase Order, Blanket PO and PO releases. Implemented internal sales order using internal requisitions / standard PO and Sales Order processing.
• Defined Inventory organizations, parameters, sub inventories and picking rules in Inventory
• Maintained purchasing locations, buyers, and approval groups
• Conducted comprehensive user training on Oracle Purchasing, shipping Execution, development of training materials and practice exercises.
• Handled back flush related issues in both discrete manufacturing and flow manufacturing

Confidential

Oracle Supply Chain Functional (SCM) Consultant

Responsibilities:

• Providing Functional inputs / clarification to the Technical Teams
• Period review and reporting of Case Analysis, Case Statistics
• Providing inputs on functional process improvements as required.
• Identifying different types of possible errors when interfacing with Legacy
• Modification in Picking Release rule to overcome some of the issues with Legacy
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks, Transaction Sources.
• Set up of Order Management with Order Cycles, Order Types, RMA types with various classes, Order Holds
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Performed Thorough Analysis of the company’s Supply Chain and Manufacturing.
• Assisted Lead in requirements gathering process from the Business SMEs and prepared as-is, To-Be documents.
• Assisted lead in the process of interfacing various legacy systems with Supply Chain and Manufacturing modules.
• Developed the System Requirements Documents and configured system by mapping the BR with Oracle EBS Standard functionality.
• Assisted SCM and Manufacturing consultants in module related setups.
• Involved in various setups in SCM such as Replenishment setups, Cycle Counting, ABC analysis, Item setups etc.
• Involved in manufacturing setups such as Defining Bills and Routings and Scheduling rules for Flow Manufacturing.
• Involved in Interfacing Inventory and Manufacturing modules with Order Management and Purchasing Modules.
• Performed Gap analysis and defined Custom Components, Setup and Conversions.
• Conducted user training and created user manual for End-Users and Business Representatives.

Confidential, Houston, TX

Oracle SCM / Manufacturing Consultant

Responsibilities:

• Involved in Design, Develop and Implementation of Manufacturing (WIP, BOM, INV) and Fulfilment (OM)
• Analyzed and configured major Setups in Order Management, Inventory modules
• Prepared Test Case Document as per process defined for Functional, Integration Testing and Business Scenario Testing
• Prepared As/Is, To-Be, MD050 and BR100 documents
• Designed MD50s for interfaces with various Legacy Systems.
• Participated in activities for Developing the Project Plan, GO-Live Plan and Master Setup Plan
• Develop the System Requirements Documents and configure system by mapping the BR with Oracle EBS Standard functionality
• Performed Gap analysis and defined Custom Components, Extensions, Setup and Conversions
• Completed configuration and setup of with custom components to meet the needs. (System Setup)
• Integrated system testing, performed user acceptance testing (UAT)
• Trained end users. Designed training materials (UM) to bring users up to speed with the standard System Functionality and Custom Components
• Supported all go-live activities and post-production troubleshooting. It includes data migration, System configuration issues

Confidential, Irving, TX

Oracle Finance and Supply Chain QA Analyst

Responsibilities:

• Tested Order Management (OM) functionality such as Enter/Book, all Sales Order Types such as Standard, Mixed and RMA
• Involved in testing all type of Order Holds and Releases such as Quantity, Amount and Credit.
• Involved in testing various standard & custom solutions within Oracle Supply Chain Planning & Logistics department. Creating systematic solutions mainly within Order Management (OM), Purchasing (PO), Inventory (INV), & Accounts Receivables (AR) modules.
• Involved in performance testing to revolve response time for all concurrent program and reports
• Involved in performance testing of EBS/ERP application using OATS.
• Involved in performance testing solution for a web application using OATS.
• Involved in testing custom sales order such as Advance Exchange and Repair and Return orders.
• Involved in testing end to end transaction in P2P and O2C cycle.
• Verified bottleneck issues and eliminate performance bottleneck issues using OATS.
• Verified all sales order Line and Header Level information, Verify On hand/Reserve quantity, Pick Release, Perform Ship Conform, Perform Auto Receipts Process and Receiving Receipts.
• Tested outbound interface of on-hand quantity from Oracle EBS to legacy system Prowess.
• Tested interface between Cyber Source and Oracle EBS for customer credit card payment processing.
• Tested Auto Lockboxes
• Involved in testing inbound interface of credit check for customers from 3’rd party tools into Oracle EBS.
• Involved in Functional, SIT, Regression, Performance, Automation and UAT testing.
• Tested Inter-Org transfer related issue and problems in INV, face due to invalid locator.
• Prepared Test Strategy, Test Plan and Test summary documents. Involved in BR100 setup testing.
• Coordinated with offshore on daily work.

Confidential

SCM Functional Consultant

Responsibilities:

• Providing functional expertise on Purchasing (PO), Inventory (INV) Oracle Applications 11.5.8 for an offshore client as well as a local client.
• Post Implementation Support
• INDIA Localization Setup
• Creation of Sub-Inventories as per Excise Rule
• Outside Processing Pos with PO move resource Type operation in WIP when operation is move to Queue to Move, and then generated Import Requisition,
• Auto Generation of Pos based on Outside Process Requisition And raised PO for Sub Contractor so it will be available for Out-Source Operation Completion
• Various receiving transactions.
• Sub-Inventories Transfer As per INDIA Localization Required for Sub Contractor
• OSP Challans, 57F4 Dispatch and Receipt Against Sub Contractor PO
• INDIA Localization Setup For Excise, Custom Duty, Third Party Taxes
• Knowledge of documenting requirements, definition through AIM Documentation
• Corporate Training
• Item Definitions
• Organization set up
• Shipping networks
• Sub-inventory and locator set-up
• Identifying different types of items and making the required templates
• Define Item category to generate different report
• Inter-org Transfer/Sub-inventory Transfer
• Min-max Planning/Reorder point planning
• Document approval workflow using job/supervisor relationship
• Creation of suppliers
• Creation Approved Supplier List
• Creation of line types & Document types
• Profile Options for Auto Sourcing and Defaults
• Defined Transaction type, Documents sequencing
• Defaulting Rules
• Process Constraint
• Define Ship Confirm Rules
• Define Rules & Grants
• Define Pick Slip Grouping Rule
• Define Release Sequence Rule
• Define Release Rule Form
• Defining Qualifiers & Modifiers
• Defining Pricing Attributes on basis Item Attributes qualified for Discounts
• Define Setup for Mapping & Linking DFFs to Pricing attributes
• Define Defaulting rules for Price List
• Defining Manufacturing calendar with shift information and exception template
• Define department, standard operation
• Define Routing and Bill of Material, common bill of material
• Mass changes Bill of Material
• Defining accounting class for standard and non-standard jobs and WIP parameters
• WIP assembly return, negative component return
• Move Transactions
• Assembly Completion
• Resource Transaction
• Managing Discrete Jobs
• Excessive OSP Jobs.
• Managing MDS
• Running MRP and Automatic creation of Internal sales order
• Planner Workbench
• Defining Sourcing Rule for auto creation of requisition & Blanket Release along with ASL
• Cost set up using standard costing
• Define cost element, sub-elements like resources and overhead.
• Defining Material Overhead and defaulting rule