SUMMARY

• Over all 7years of extensive experience as a Functional Analyst working on Oracle EBS (R12/11i) in the domain of Supply Chain Management(SCM), Manufacturing(MFG) and Distribution modules
• Multiple implementation of Oracle ERP Application and part of full project life cycle experience with strong business analytical skills
• Expertise in analyzing business requirements as a part of Implementation, Up gradation projects and provide extensive functional support for Post - Production Support projects in the domain of SCM and MFG Modules in both R12 & 11i versions of Oracle Application
• Extensive knowledge in Oracle EBS Distribution Modules including Inventory (INV), Order Management (OM), Advanced Pricing, Purchasing (PO) and knowledgeable in Bill of Materials (BOM), Work in Process (WIP), Cost Management (CM) and iProcurement (iProc)
• Ability to handle full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT), User training and Go-live and Post Production support in Multi-Org Environment
• Experience in working on cross functional modules in the environment of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles
• Experienced in work environments requiring direct client interaction during requirement gathering, gap analysis, and product implementation & customization phases
• Expertise in Fit-Gap analysis and providing solutions as per business requirement within the limits and purview of business process transactions recording under proper internal control mechanism
• Provided functional impact analysis as a part of change management process for the proposed changes by the business with existing configuration
• Experienced in preparing User Scripts, User Manuals, test scripts and provide User training
• Hands on experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents such as RD-020, BR-30,BR-100, TE-040, MD-050, CV-040 and BP-080 (Expertise in Analysis, design and documentation of client’s business requirements)
• Created service requests(SRs) and follow up, conducted Oracle Web Conference(OWC) with oracle support for speedy resolution for all high prioritized issues
• Exceptional ability in coordinating the onsite and off-shore resources, while achieving milestones and deliverables within time limits
• Development of data conversion strategy, master data and transaction data conversion from legacy system
• Experience in organizing status meetings including co-ordination with the business team, preparing and presenting project status reports
• Proficiency in implementation process mapping, functional requirement analysis, train end users
• Excellent communication skills with good interpersonal skills, hardworking and a good team player

TECHNICAL SKILLS

Oracle Applications: R12.1.3, R12.1.1, R12.0.6, R12.0.5, R12.0.3, 11.5.10.2, 11.5.10, 11.5.9, 11.5.8

Modules: INV, PO, OM, BOM, WIP, Advanced Pricing, MRP, MPS including O2C and P2P Cycles

Other Tools: Data Loader, SQL*Loader, TOAD, OBIEE, Discoverer, Visio, Microsoft Project, Hyperion, ADI, Web ADI, MS Word/Excel/Power Point, MS Access

QA Tools: Test Director, Win Runner, HP Load Runner

Databases: Oracle 9i, 10g, 11g, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle SCM Functional Analyst

Responsibilities:

• Involved in Full-Cycle Implementation of Oracle Modules: Inventory, and Purchasing, conducted several meetings with business teams for business overview
• Performed AS IS Analysis and Identified GAPs
• Creation of gap analysis document BR-150 and customization requirement specifications
• Analyzed business requirements and performed fit-gap analysis to map user requirements to R12 functionality/transactions using Oracle’s AIM Methodology
• Conducted extensive business workshops to understand RD-20 and prepare document CV-40 for data conversions
• Implementation Project Planning and scheduling the various phases of the project with appropriate timelines, coordination, resource scheduling, work allocation and reporting
• Responsible for the functional configuration of Inventory and Purchasing modules with the co-ordination of the project team and end-users
• Responsible for the receipt processing customization to synchronize with the fulfillment receipt systems used against purchase orders
• Conducted business workshops/trainings to explain INV and purchasing modules, workflows and review end-user and super-user feedback for improvements
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, shipping networks.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Conducted CRP (Conference Room Pilot), integration testing and performed extensive UAT
• Responsible for reviewing module setup document BR100
• Regular coordination to get clarifications from users/technical consultants over components developed and coordination among teams of other modules
• Involved in preparation of training material and training setup, coordination between the client and delivery teams during the various phases of the project for the activities involving requirements, solution design presentations, Conference room pilot (CRP), conversion strategy, user training and user testing
• Designing documents for the Reports, Interfaces, Conversions and Interfaces as a part of customizations fulfillment
• In the process of performing extensive UAT, integration testing and preparation of Test Scripts and User Manuals as a part of training
• Co-ordinate with Oracle Support to resolve the existing open issues
• Responsible for mapping and cleansing of customer data to convert from legacy format to Oracle
• Provided support in raising Service request(SR), applying patches and problem-solving
• Performed debugging of the applications and helped team members in troubleshooting and debugging

Confidential

Oracle SCM Functional Analyst

Responsibilities:

• In charge of all SCM and Manufacturing Modules INV, BOM, WIP.
• Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Performed AS IS Analysis and Identified GAPs
• Analyzed the business functions for implementing a standard workflow across the organization.
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• Responsible for developing and maintaining documentation like BR-100, CV-40, test scripts and results
• Developed the requirements and design specifications for the entire workflow
• Perform inventory setups including inventory organizations, Inventory controls, item categories, product catalogs, locations, freight carriers, item parameters etc.
• Responsible to design a process to create WIP Discrete Jobs, create requirements, issue the material to the jobs and complete Jobs
• Responsible to design a process to populate schedule start dates based on planning done in other systems.
• Worked with Custom Development team for analyzing the custom programs interfacing with Virtual Factory, Data Match, Custom Min-Max and Production Reporting and AS400 system
• Responsible to coordinate with technical team for resolving the defects and/or for enhancing the functionality which were identified at each phase of testing
• Involved in Physical count and sorted out inventory stock issues with oracle and third party systems
• Responsible for providing specifications, and test custom reports and programs
• Responsible for validation of data and coordinating data conversion activities with conversion team
• Provided extensive user support during UAT and Post Production phases
• Responsible for post production support and enhancements

Confidential

Oracle SCM Functional Consultant

Responsibilities:

• Involved in planning & implementing the up gradation from Oracle 11.5.10.2 to 12.0.6
• Analyzed user requirements, functionalities and mappings within the BOM, Inventory, PO, WIP and OM Modules
• Provided manufacturing functional expertise during development of manufacturing execution system
• Setting up the Order Management, Shipping Execution modules after finalizing on the requirements
• Provided Super User and End User support for respective modules
• Provided support and coordinated with the Financial team for O2C process
• Helped continuously adapt OM’s business process and Oracle ERP System to support a dynamic business environment
• Coordination with the team for the test execution and issue resolution processes and providing the status update to the project management team during the daily status calls
• Worked collectively with other business areas including, planning, and finance to ensure that manufacturing function fully integrates with other business process
• Extraction of Skip lot data from Legacy system using SQL
• Trained end users on Inventory, Order Management modules with more prominence given to Order to Cash cycle (O2C)
• Restructured manufacturing processes to support the new E-commerce business processes
• Coordination with the client team for review and approval of the business process understanding documents, business process test scripts, list of custom components and delivery schedule
• Worked on making Test scripts and performed testing procedures for various oracle apps modules (like: Inventory & Order Management)
• Moved business organizations systems, data and processes from the west coast multi-organization to the east coast multi-organization Oracle environment
• Conducted CRP’s (Conference Room Pilots) to ensure that the e-commerce business processes were defined for all major business processes and could be performed successfully using Oracle Applications

Confidential, Evansville, IN

Oracle SCM Functional Support Analyst

Responsibilities:

• Conduct numerous business meetings to identify and assess the impact of production issues and provide solutions along with functional impact analysis
• Coordinated with the functional and technical consultant teams, for the business process understanding, unit and integration test script documentation, on-time delivery of documents, and identification and documentation of the custom objects
• Responsible for the tracking of all issues and prioritize depending on the key business areas and time sensitive process constraints
• Execution of the modified test scripts with custom components as part of post upgrade testing of the cloned instance, for the purchasing, inventory and order management functional areas
• Responsible for providing the technical team with data mapping and communicating requirement changes from business users for Items, Bills, Routings, Purchase Orders
• Maintained documentation for each issue and followed the change management process wherever there is a functional configuration change is proposed by the business; and /or provide functional extension (RICE components) in the production environment
• Conducted extensive research on each issue and raised Service Requests (SR’s) for and coordinated with the Oracle Technical Support team for a speedy solution
• Created Service Requests (SR’s) and prioritized as SEV1 and SEV 2 and conducted Web Conference to resolve the issues
• Responsible to coordinate with technical team for resolving the defects and/or for enhancing the functionality
• Proposed new solution for the existing interfaces
• Provided knowledge transfer to end users in resolving user errors
• Provided post implementation support on day to day application problems

Confidential, Secaucus, NJ

Oracle SCM Functional Analyst

Responsibilities:

• Gathered RD-50 and acquired process flow diagrams with knowledge transfer on extension of its functionality
• Worked with BSA team and Business Team for developing BR-100
• Established and maintained clear communications on status, issues, and progress with business sponsors and IT management
• Developed test scripts & conducted CRP testing for the Order to Cash(O2C) cycle
• Documented new procedures & Involved in training the business users on the new processes and also assisted them during their on-job training exercise.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories
• Involved in complete end to end functional configuration of Inventory and Order Management
• Prepared TE-40 and executed the key test scenarios which include both inbound and outbound interfaces with external systems
• Handled production support responsibilities in recognizing and troubleshooting concurrent managers and concurrent requests

Confidential

Oracle SCM Oracle Functional Analyst

Responsibilities:

• Understanding of business processes in Supply Chain Planning, Manufacturing and Distribution areas.
• Working with DBA to finish Pre Upgrade and Post Upgrade tasks in before and after upgrade
• Business Process reengineering to offer R12 flexibility
• Managing and improving manufacturing and distribution processes in client facility within limited scope.
• Testing of each processes and modules in version 12.0.5
• Raising SR and working with Oracle in resolving upgrade issues.
• Working with development in debugging and testing of custom solutions.
• Cutover and post production support
• Assisting in preparation and keeping track of project plan.
• Managing functional and technical people offshore

Confidential, Galesburg, MI

Oracle SCM and MFG Functional Counsultant

Responsibilities:

• Responsible for supporting the Manufacturing process of the business.
• Involved in discussing, analyzing and finalizing requirements with the end users of the system for designing the user interface of MSF application.
• Involved in Application System administration activities like user creation, responsibility creation etc.
• Defined custom menus & responsibilities for various user roles.
• Designed and modified the reports to better suit the needs of the business.
• Developed forms for ease of user interaction with custom schemas and manufacturing modules.
• Extended functionality of standard forms by modifying the custom library and using ‘Zoom’ feature of Oracle Applications 11i.
• Compiled Inventory and Order Management interfaces with Oracle Inventory and Oracle Order Management modules.
• Worked closely with the DBA to improve the performance of the system by tuning various reports, optimizing SQL’s by studying the explain plan, and restructuring PL/SQL program units for optimum performance.
• Prepared MD-050 Documentations and followed up with technical team for the design and development parallel
• Responsible for unit testing of all developed modules and also involved in helping the users test the application by organizing power user meetings and preparing extensive test documents.
• Worked with Oracle support by opening TAR’s (Technical Assistance Requests).
• Responsible for providing 24/7 production support for all Supply Chain modules.

Confidential

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed the current business process and did the requirement gathering for Work In Process (WIP) and Bills of Material (BOM) modules
• Reviewed the implication of the functional decisions being made during the setup processes
• Perform GAP Analysis to map user requirements to Oracle apps features
• Carry out inventory organizational setups, define units of measure and assign the shipping networks
• Performed a walkthrough of the To-Be business process flows
• Documented the functional requirements for data conversion and historical data incorporating industry best practices and standards
• Worked with full life cycle like creation of Items, creation of BOM structure, assembling in WIP and copying to Multi-Org
• Setups of Bills of Material parameters, department classes, resources, locations, WIP accounting classes and options
• Mapping the transactions relevant for client and ascertaining workarounds
• Application setups review to make existing business processes work
• Documented the AS-IS, training material and operating procedures
• Conducted Integration Testing and User Acceptance Testing
• Setup the training in the area of Oracle Order Management, Oracle Inventory with focus on customization needs of the client.

Confidential, Santa Clara, CA

Functional Consultant

Responsibilities:

• Provided project support for the upgrade of Oracle Inventory, Order Management, Planning/MRP, Bills of Material, Work in Process and Engineering
• Interacted with customers for the collection of requirements.
• Analyzed the business functions for implementing a standard workflow across the organization.
• Created different hold options per client specific requirements
• Replicated and created transactions for different kind of test scenarios like purchasing, returning of items and ordering to simulate the actual business flow executed by the user community
• Coordinated with functional analysts and users to resolve and fix bugs identified in the testing process
• Communicated with super users in resolving business issues
• Developed functional specifications for shipping document set reports and Pick list reports
• Documented and maintained the setup and revisions
• Developed the requirements and design specifications for the entire workflow.
• Tested the functionalities as per the requirements, before the system went live
• Provided post production support and troubleshooting, helping the user community use the system efficiently and effectively

Confidential, San Jose, CA

Oracle Functional Analyst

Responsibilities:

• Performed business analysis, process design, requirements analysis, and solutions design using Oracle AIM methodology.
• Was responsible for doing inventory setups such as defining locations, organizations, sub inventories, units of measure and items.
• Determined and defined the workday calendar.
• Defined and created the shipping networks.
• Determined the process for Min-Max planning.
• Performed application setups for WIP module.
• Responsible for configuration of the Bill of material module.
• Was responsible for system administrator functions including setting up users, defining responsibilities, determining request groups, and setting menus.
• Involve with user acceptance testing (UAT) and end user training
• Handled Severity One (Most Critical) issues and escalated issues in production environments to resolve problems in a timely manner.