SUMMARY

• 11+ Years of Oracle Applications functional experience (11i and R12.1.3).
• Expertise in wide range of Oracle Applications modules which includes Oracle Purchasing(PO), INV(Inventory), BOM, WIP, Quality, Oracle MRP, Advanced Supply chain planning(ASCP), OM(Order Management), Advanced Pricing (QP),Iprocurement, Isupplier, isourcing, Applications.
• Extensive experience in Requirements gathering, AS - IS Business Process reviews, Proposing/Designing To-Be Process, Requirement Analysis &Definition, Gap Analysis, Customization Analysis, Configuration/Setup Documents, Functional Designs (MD50), Technical Designs (MD70), Data Conversion, Pilot Planning, Preparation of Test Strategies, Test Scenarios, Test Plans, Test Scripts using AIM methodology.
• Excellent business knowledge on Manufacturing, Procure to Pay, Order to Cash, B2B and Drop ship, IR/ISO business flows. Involved in Oracle India localization, Canada, UK, Europe, Israel, Japan, Taiwan and China implementation/rollout projects.
• ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region.
• Hands-on involvement in iSourcing, iSupplier and iProcurement implementations for India and US Ledgers.
• Expertise knowledge on R12 implementation and upgrades in oracle SCM and Manufacturingmodules.
• Expertise experience on AME Setup and implementations in 11i and R12.
• Experienced in using AIM methodologies with thorough understanding of As-Is Process, designing To-Be Process, building RICE (Report, Interface, Conversion, Extension) Components
• Good practical knowledge on HP Quality center to raise defects and modify/execute the test scenarios.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows
• Provided the training to the users on R12 new features on SCM & MFG modules.
• Involved the R12 CRPs /SIT/UAT and helped the users to execute the scenarios.
• Excellent knowledge on to preparing the configuration setup documents on iProcurement, PO,BOM,WIP,MRP and Inv (System Setup)
• Have strong technical knowledge in SQL & PL/SQL Programming and developing Adhoc-Reports by using SQL and Oracle Applications 11i tables.
• Translate business needs into technical deliverable solutions.
• Have extensive skills in communication, excellent team player and aggressive in acquiring new skills.
• Worked in multiple vendor environments and managed/lead large teams across different geographies in onsite-offshore model.

TECHNICAL SKILLS

ERP: Oracle AppsR12/11i (INV, Purchasing, iProcurement,AP, OM, BOM, Quality, WIP,MRP,ASCP,iSourcing,iSupplier, AR)

RDBMS: Oracle 8i/9i/10g, MS Access

Tools: & Utilities: SQL, PL/SQL, Data Loader, TOAD, PL/SQL Developer, SQL * Loader, SSH, PVCS Version Controller, HP Quality Center

GUI Tools: Oracle Forms 6i/10g, Reports 6i/10g, Workflow builder, Discoverer 4i,10g XML Publisher,Discoverer/noetix,BI

Methods: Oracle Application Implementation (AIM) methodologies, TTM methodologies

PROFESSIONAL EXPERIENCE

Confidential, Mountain view, CA

Sr.Oracle SCM Functional Consultant

Environment: Oracle Applications R11i/R12.2.4 (OM, QP, INV, Purchasing, iProcurement, iSupplier, BOM, WIP, iPayments, AR)

Responsibilities:

• Requirements gathering from business, AS-IS Business Process reviews, Requirement Analysis & Definition, Gap Analysis, Customization Analysis, Configuration/Setup Documents, Functional Designs, Technical Designs, Data Conversion, Pilot Planning, Preparation of Test Strategies, Test Scenarios, Test Plans, Test Scripts using AIM methodology.
• Profile setups as part of the system configuration.
• Loading the customer, contact and transaction files in the system by running the interface programs.
• Executing the CRPs/SIT/FAT and UST by the business used and resolving the issues.
• Executing the test scenarios and validating the same by business.
• Co-coordinating with offshore team to clarify the business requirements.
• Inventory setup, configuration and implementation involving all the mandatory and optional steps. Implementation is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
• Go-live activities and post-implementation support. Supported production environments and users on a daily basis by responding to emergency requests.
• Troubleshooting and fixing the issues on Oracle Standard- Month end, Quarter end, Year-end processes.

Confidential, Eden Prairie, MN

Sr. Oracle SCM & P2P Functional Consultant

Environment: Oracle Applications R11i/R12.1.3 (OM, PO, INV, BOM, WIP, Quality, Advance Pricing, iSupplier, Supplier Management, Configurator, iProcurement, and AP)

Responsibilities:

• Client interaction for requirement and SRS validation.
• Working with the business users to resolve the daily business activities and providing the guidance to the users on regular business process.
• Functional responsibilitiesinclude:requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Go-live activities and post-implementation support. Supported production environments and users on a daily basis by responding to emergency requests.
• Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Year-end processes.
• Expertise knowledge on R12 implementation and upgrades inoracle SCMand Manufacturingmodules.
• Having good knowledge on Engineering change order process (ECO).
• Resolving the issues on implementing from one version to other version and adding new components in ECO.
• Having excellent knowledge on oracle configurator (OCD).
• Suggesting to business to add BOM components if required to resolve sales order config issues.
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle.
• Resolving the Invoice issues while matching the PO’s.
• Prepared and executed the test scripts and test scenarios on R12Oracle SCMand MFG modules.
• Business Configuration setups on Order to cash (O2C), Procure to pay (P2P), Drop Ship, IR/ISO, B2B process flows.
• Troubleshooting and fixing the issues on Oracle Advanced Supply chain planning
• Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle MetaLink and Oracle Applications Patch Management.
• Gathering requirements and implementing change requests.
• Develop, perform, and code review and customization according to the business requirements.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Handled RICE components for manufacturing modules and wrote several functional specification documents.
• Inventory setup, configuration and implementation involving all the mandatory and optional steps. Implementation is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
• Deliverables included need analysis, functional mapping, gap analysis, finding solutions, setup and testing.
• Resolving the month end issues and prepared a setup document for Month-end closing.
• Resolving Physical Inventory and Cycle Count Issues in Inventory Application.
• Training the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application.
• Gathered and analyzed the business requirements, Process Mapping and carried out gap analysis.
• Responsible for implementing Order Management, Inventory and Procure to pay cycle.
• Implemented Approval Hierarchy and Employee/Supervisor relationship for approval of PO.
• Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications.
• Performed setups for inventory and purchasing.
• Preparing checklists, templates, estimation guidelines and documenting the processes.
• Work allocation and team management and Effort estimation and staffing.
• Ensuring the quality in the project.
• Reviewing/preparing the unit/integration testing.
• Preparing system test scripts and documenting the test results.

Confidential, San Diego

Sr.Oracle P2P & SCM Functional Consultant& Lead

Environment: Oracle Apps R12/11i (iProcurement, PO, Procurement Contracts, Inventory, OM,Quality, BOM, WIP, ASCP, AP, iSourcing and iSupplier,XML publisher,Discover reports).

Responsibilities:

• Coordinate with the Oracle production support team by providing solutions to business issues in Oracle applications, fixes and enhancements to custom components. Prepared and executed the test scripts and test scenarios on R12 Oracle SCM and MFG modules.
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Material Management business flow to meet the business needs of the company.
• Carried out User Acceptance Tests (UAT).
• Prepared business requirement, functional design documents and worked with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances
• Setting up of ASL, Sourcing Rules, and Assignment Set for Inventory Min Max Planned Items with release generation method "Automatic Release" for auto generation of Blanket Releases and Standard Purchase Orders.
• Impact analysis in current business process due upgrade changes/enhancements.
• Business process mapping with all standard and customized modules.
• Fulfilled CRP1,CRP2 testing cycles, with issue trackers and SME’s sign of.
• Fulfilled UAT testing Cycles, with issue trackers and SME’s sign of.
• Designed the BR100,MDO50,MDO60,CMO10 Documentation and Testing the Object
• Provided Trained & Conducted Practice & Additional Business Requirements sessions on R12 new features
• Experienced in using AIM methodologies with thorough understanding of As-Is Process, designing To-Be Process, building RICE (Report, Interface, Conversion, Extension) Components
• Supported production environments and users on a daily basis by responding to emergency requests
• Worked on R12 implementation and upgrades in oracle SCM and Manufacturing modules
• Analyzed user needs, conferring with users to improve procedures and identifying and solving problems
• Prepared and executed the scenarios in for R12 in Quality Center.
• Completed configuration of PO, BOM, WIP and Inv setup of with custom components to meet these needs. (System Setup)
• Prepared Functional and Technical Documents (FDDs&TDDs) for Development.
• Interacted with onsite for the getting the requirements clarified and develop accordingly in the development environment.
• Involved in Oracle India localization implementation project.
• Involved in procurement contracts setups
• Prepared and executed the test scripts and test scenarios on R12Oracle SCMand MFG modules.
• Provided training to the users on procurement contracts functionality.
• Involved in UK,Europe, China and Taiwan Oracle implementation Projects
• Interacted with clients for the getting the requirements clarified and develop accordingly in the development environment
• Raised TAR to get resolution from Oracle on product bug
• Assisted customer on Functional areas particularly in Manufacturingareas ( PO, RCV, iProcurement, Inventory, ASCP, Oracle Quality, BOM and WIP) and Prepare detailed Work plan and activities
• Interaction with different team lead of the project including the third party
• Gather business requirement and CRP execution.
• Assisted UAT and production instance and monitoring the user activities
• Provided functional support in Procurement, iProcurement, Receiving and AP.
• Worked with the users on Serv 1 issue and providing the solution.
• Provided the guidance to the users on regular business process.
• Handled the system setups as per business requirements.
• Responsible for the Material Planning
• Responsible for the Vendor development and New Product Development
• Co-ordinate with other Departments for smooth material inflow.

Confidential

Oracle Techno-Functional Consultant

Environment: Sun Solaris, Oracle Apps 11i (iProcurement, PO, AP, Quality, BOM and WIP) and XML Publisher Reports.

Responsibilities:

• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company Prepared Functional and Technical Documents (FDDs&TDDs) for Development
• Business Requirements Mapping for Purchasing and Accounts Payable modules
• Prepared user training manuals.
• Supported production environments and users on a daily basis by responding to emergency requests
• Co-ordinated with onsite team to get the requirements.
• Preparation of Functional and Technical Document
• Prepared detailed Work plan and activities
• Monitored the user activities
• Analyzed user needs, conferring with users to improve procedures and identifying and solving problems
• Provided functional support in Procurement, iProcurement, Receiving and AP.
• Knowledge on XML Publisher Reports.
• Worked on custom.plls.
• Tested with available data in the modules.
• Worked on R12 implementation and upgrades in oracle SCM and Manufacturing modules
• Handled RICE components for manufacturing modules and wrote several functional specification documents
• Understanding the requirements from client for the development to be done.
• Designed the MDO50,MDO60,CMO10 Documentation and Testing the Object
• Developed Multiple Line Restrictions on PO & Auto Create Form.
• Developed Open qty& Auto Population of Vendor shipment number on Receiving Form.
• Solution mapping, documentation of BR-30 and identify the Gap and Record the Gap in the BR-10 Document.
• Product configuration and setup including documentation of BR-100.
• Preparation of MD-50 for the custom built components
• Prepared User Manuals for the Distribution modules.
• Prepared test scripts documentation of TE-40.
• Coordination on the development of the custom Component and interface
• Support and Maintenance.
• Post Implementation Support for Distribution module-one month-Offshore.

Confidential

Oracle Apps Techno Functional Consultant

Environment: Sun Solaris, Oracle Apps 11i (iProcurement, PO, AP,Quality,OM), Forms, Reports, XML Publisher reports

Responsibilities:

• Responsible for gathering user requirements, data conversions, customizations and testing.
• Supported production environments and users on a daily basis by responding to emergency requests
• Business Requirements Mapping for PO and AP
• Generated Ad-hoc reports as per the user requirements and providing them with in short time.
• Responsible for Preparing and Reviewing Technical Documents.
• Responsible to test the required reports in multiple instances.
• Communicate with the Users to get the vital information for providing exact solution.
• Interacted with onsite for the getting the requirements clarified and develop accordingly in the development environment
• Raised TAR to get resolution from Oracle on product bug
• Preparation of the Project Plan.
• Track the closure of each activity against project Plan
• Quality compliance and audits
• Material requirement planning for long term and short term.