SUMMARY:

• 10 Years of Oracle Applications functional experience (11i and R12) - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, Upgradition and implementation.
• Expertise in wide range of Oracle Applications modules which includes Oracle Purchasing, Oracle Inventory, BOM, WIP, Quality, Oracle MRP, Advanced Supply chain planning (ASCP/VCP), Order Management, Iprocurement, Isupplier and isourcing Applications.
• Extensive experience in Functional Analysis, Application Implementation and Upgrades Including understanding Business Process reviews and Requirement Definition, Gap Analysis, Customization Analysis, Configuration Documents, Preparation of Training Material, Data Conversion, Pilot Planning, Preparation of Test Strategies and Test Plans, Training and Post Implementation Support..
• Expertise experience in R12 Upgrade, 11i Implementation, Upgrade and Support of Oracle E-Business Suite.
• ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology
• Excellent business knowledge on Procure to Pay, Order to Cash, B2B and Dropship business cycles
• Involved in iSourcing, iSupplier and iProcurement implementations for India and US Ledgers.
• Excellent knowledge on oracle configurator
• Involved in Oracle India localization, Canada, UK, Europe, Israel, Japan, Taiwan and China implementation project on procurement modules and helped to the users to understand the application and provided the hands-on training.
• Expertise knowledge on R12 implementation and upgrades in oracle SCM and Manufacturing modules.
• Review various functional designs being developed by the team for Supply chain RICEF objects
• 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
• Prepared and executed the test scripts and test scenarios on R12 Oracle Procurement/ Quality/BOM/WIP/ASCP modules. Good practical knowledge on Quality center to raise defects and modify/execute the test scenarios.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows
• Handled RICE components for manufacturing modules and wrote several functional specification documents
• Prepared and executed the test scripts and test scenarios on R12 Oracle SCM and MFG modules.
• Provided the training to the users on R12 new features on SCM & MFG modules.
• Involved the R12 CRPs and helped the users to execute the scenarios.
• Expertise knowledge on QA activities and Quality Center tool.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).
• Excellent knowledge on to preparing the configuration setup documents on iProcurement, PO,BOM,WIP,MRP and Inv (System Setup)
• Extensively worked on Interfaces and conversions.
• 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.
• Extensive skills in communication, excellent team player and aggressive in acquiring new skills.
• Good knowledge on RICE customization
• Worked in multiple vendor environments and managed/lead large teams across different geographies in onsite-offshore model.
• Expertise knowledge on interfaces, form personalization and custom.plls

TECHNICAL SKILLS:

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

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

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie

Sr. oracle apps SCM & MFG functional consultant

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 responsibilities include: 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 in oracle SCM and Manufacturing modules
• Having excellent knowledge on oracle configurator (OCD).
• Suggesting to business to add BOM components if required to resolve sales order config issues.
• Writing the logical rules to replace the CP items in OCD.
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
• Prepared and executed the test scripts and test scenarios on R12 Oracle SCM and MFG modules.
• 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.
• Experienced in using AIM methodologies with thorough understanding of As-Is Process, designing To-Be Process, building RICE (Report, Interface, Conversion, Extension) Components
• 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.
• Have good knowledge on RICEF customization
• 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
• Effort estimation and staffing
• Worked on R12 implementation and upgrades in oracle SCM and Manufacturing modules and on RICEF components
• Ensuring the quality in the project.
• Reviewing/preparing the unit/integration testing.
• Preparing system test scripts and documenting the test results.

Environment: Sun Solaris, Oracle Apps R12/11i ( iProcurement, PO, Inv, iStore, ISupplier, Quality, BOM,WIP,ASCP, Configurator and OM)

Confidential, San Diego

Sr.Oracle Functional Consultant & Lead

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.
• Full CRP1,CRP2 testing cycles, with issue trackers and SME’s sign of.
• Full 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 and ABFmethodologies 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 R12 Oracle SCM and 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 Manufacturing areas ( 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.

Environment: Oracle Apps R12 (iProcurement, PO, Procurement Contracts Inventory, Quality,BOM,WIP,ASCP iSourcing and iSupplier).

Confidential

Oracle Functional Consultant

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.
• 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.

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

Confidential

Oracle Apps Techno Functional Consultant

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.
• Reduced raw materials cost for forgings by procuring directly from direct manufacturers resulting in cost of saving of Rs.4.5 Million per annum.
• Reduced cost of worm gear and worms with improved quality by changing from conventional machining process to CNC machining process, cost saving per annum Rs 3.6 Million.
• Increased inventory-turn over ratio from 6 to 13.

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