We provide IT Staff Augmentation Services!

Oracle Functional Analyst Resume

4.00/5 (Submit Your Rating)

IllinoiS

SUMMARY

  • Oracle Supply Chain Professional with a total of around 14 years of experience that include
  • Over Eight years of experience in Oracle Applications Distribution Modules as a Functional Consultant with successful contribution to various projects that include • Full life cycle implementations involving requirement analysis, design, configuration, development and testing • Post production / extended support • Solution Consulting • Product Training • Regression Testing
  • Over Seven years of Experience in Material management and Logistic Domain areas of Material Procurement, Planning and Inventory Control.
  • Application Implementations - Business requirements gathering, GAP analysis, preparing solution architecture, business process configuration, application setups and configuration for CRP, UAT and production instances, project documentation, customization analysis and design, master and transactional data conversion, reporting requirements, applications testing, key / end user training and post production support
  • Application Support - Business process analysis, customizations analysis, pre and post upgrade testing, GAP and fitment analysis, application version differences presentation, data conversion, feature enhancements configuration, application setups, support process coordination, ticket handling process, raising and monitoring SRs with oracle, analysis and recommendation of best business practices / enhancements and user training
  • Project Documentation - Existing and future business processes, application module setups, data conversion templates, functional designs for form / report customizations, detailed designs for custom development components, standard operating procedures, User training documents, test scripts and test cases, Issue register templates and user training templates
  • Training’s - Application Overview presentations, key and end user training, process / support based training and product training
  • Testing - Regressive testing with Test scenarios design, Test plan preparation with negative and positive test cases, Test lab execution with test steps and Defect tracking, Integration Testing.

TECHNICAL SKILLS

Primary Modules: Inventory, Purchasing (PO), Order Management (OM), EDI, iProcurement, O2C, P2P

Secondary Modules: AP, AR, BOM, WIP, Costing, Sourcing, iSupplier

Development and QA Tools: HP Application Life Cycle Management (ALM), TOAD, Data Loader

Operating Systems: Windows

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Illinois

Oracle Functional Analyst

Responsibilities:

  • Requirement analysis and solution design for One SCM project. The basic idea of One SCM project is to build a common platform for the Supply chain users to track the various inbound and outbound documents processed to various Trading partners through XML gateway in a more efficient manner.
  • Coordination between the Supply Chain business users and the One SCM development team during the various phases of the project for the activities involving requirement gathering, solution design and Prototype evaluation
  • Ensuring the One SCM development approach is in line with the requirements by testing each and every transaction being processed through the common XML platform.
  • Identifying gaps and analyze new reporting requirements based on the users experience
  • Analyze different Pricing and Product attributes required based on the inputs from CPQ design team
  • Create MD50s for analysis and Design phase related to Parts and their attributes required for integration with Oracle CPQ
  • Create MD50s for analysis and Design phase related to Pricing and different attributes required for integration with Oracle CPQ
  • Coordinating the data conversion activities if any for the transactional and master data
  • Coordinate with development team by explaining the mapping details in MD50 and help them with any queries in building the necessary views required for Product and Pricing attributes required for CPQ integration

Confidential, Englewood, Colorado

Oracle Functional Consultant

Responsibilities:

  • Requirement analysis for purchasing, Inventory and Order Management with respect to new projects
  • Key contributor in driving various phases for one of the major integration projects for Return Orders which replaced a third party system called Encompass for Sling Reversal logistic business.
  • Configured the whole setups for Inventory, Purchasing and Order Management modules for one of the major Hardware move projects from Dish servers to EchoStar servers
  • Coordination between the client and development team during the various phases of the project for the activities involving solution design presentations, solution piloting (CRP), user training and user testing.
  • Execution of Business process analysis, solution design, solution build and configuration, user training, user acceptance testing and post production support for the purchasing, Inventory and Order management with Pricing and shipping modules of oracle applications.
  • Identifying and design of reporting requirements
  • Coordination and documentation of the functional designs (MD50) for the custom solution and development of interfaces and reports.
  • Provide functional support and resolution for the issues with O2C and P2P
  • Testing the EDI 850o, 850i, 810o, 810i with new SOA environment
  • Implemented and tested EDI 860i with the new requirement for DISH PO changes
  • Analyze and design interfaces for integration with UPS for work orders, kit files and ASNs
  • Detailed testing with multiple iterations for the integrated environments with different happy and unhappy path scenarios.
  • Handling of day to day issues and providing the resolution within the specified SLA.
  • Maintaining a log of the issues encountered and resolution process.
  • Setting up any additional configurations, bug fixes, application of recommended patches, providing workarounds and follow ups with Oracle support for SR’s raised.
  • Preparation of Test Plan with detailed test cases in ALM.
  • Execution of Test cases with all positive and negative scenarios in Test lab
  • Tracking the testing issues with defects and concerns during the UAT and integration testing
  • Providing functional presentations and trainings to key and end users
  • Coordinating with the Key business users and stake holders for phase completion approvals and sign-offs.
  • Coordinating the data conversion activities if any for the transactional and master data

Confidential, Canton, Ohio

Module Lead

Responsibilities:

  • Understanding and supporting the Diebold procurement and Sales process and Oracle Applications setup and transaction configuration through knowledge transition and interaction with the other core IT SCM team members and procurement key business users.
  • Business process understanding in terms of high level business flow documents, functional design documents, test scripts, implementation documents and presentations, customization design.
  • As a part of IT team, coordination with the business project management team for review and approval of the business process understanding documents, business process test scripts, list of custom components for Rollout of new Businesses onto Oracle.
  • Documentation of the As-Is Process (RD50), future process designs (BP80), setups, user training manuals, test scripts and conversion templates for the SCM Modules during new Roll outs.
  • Execution of Business process analysis, solution design, solution build and configuration, business user training and production support for the Order Management, Procurement suite (PO, iProcurement, iSupplier) and Inventory Modules.
  • Coordination between the business and development team during the various phases of the new Rollouts and enhancement projects for the activities involving requirements, solution design presentations, solution piloting (CRP), conversion strategy and data, user training and user testing.
  • Handling of day to day issues and providing the resolution within the specified SLA.
  • Maintaining a log of the issues encountered and resolution process.
  • Coordination with the team for the test execution and issue resolution processes and providing the status update to the business project management team during the daily status calls.
  • Setting up any additional configurations, bug fixes, application of recommended patches, providing workarounds and follow ups with Oracle support for SR’s raised.
  • Participation in the daily status review meetings to update the project management team on the status of open, in-process, closed tickets with the appropriate analysis of each ticket status.
  • Preparation and presentation of a weekly support process presentation providing the trend of the key indicators like volume of tickets, resolution index, performance index etc.
  • Providing functional presentations and trainings to key business users and coordinating with the business for phase completion approvals and sign-offs.

Confidential

Oracle SCM Functional Lead

Responsibilities:

  • Requirement analysis for purchasing, Inventory and Order Management with respect to procurement and sales areas of business operations.
  • Coordination between the client and development team during the various phases of the project for the activities involving solution design presentations, solution piloting (CRP), conversion strategy and data, user training and user testing.
  • Execution of Business process analysis, solution design, solution build and configuration, user training, user acceptance testing and post production support for the purchasing, Inventory and Order management modules of oracle applications
  • Solution design for inventory, OM and purchasing including configuring the employee jobs and positions, purchase approval hierarchy, sales transaction types, categorizing commercial and infrastructure equipment, item codification in additional to the functional flows of oracle applications
  • Documentation of the As-Is Process (RD50), future process designs (BP80), setups, user training manuals, test scripts and conversion templates for the SCM Modules.
  • Coordination with the technical teams for scheduling the instance configuration for the development, test and production instances.
  • Provided the workarounds for freight to cost conversion at shipping
  • Coordination and documentation of the functional designs (MD50) for the custom developments for interfaces, reports and form customizations.
  • Testing of the integrated environment with different positive and negative test cases.
  • Used AIM methodology documentation to create various design documents (RD50, BR100, To-Be design (BP80), CRP & UAT (TE40) scripts, Training Manuals, MD50 and Data Migration templates).
  • Identifying and design of reporting requirements.
  • Providing functional presentations and trainings to key and end users
  • Coordinating with the client management for phase completion approvals and sign-off’s.
  • Coordinating the data conversion activities for the transactional and master data which include master data for items, Opening Balances, Employees, price list and transactional data for open purchase orders, open purchase agreements, open requisitions, open inventory receipts etc, open sales orders
  • Involved in Post production support and period end activities

Confidential

Module Lead - Inventory

Responsibilities:

  • Coordination between the client and development team during the various phases of the project for the activities involving requirements, CRP and solution design presentations.
  • Execution of Business process analysis, requirement gathering and solution design.
  • Documentation of the As-Is Process (RD50).
  • CRP0 and CRP1 presentations with P2P and O2C cycles.
  • Documentation of the As-Is Process (RD50), future process designs (BP80), setups, user training manuals, test scripts and conversion templates for the SCM Modules

Confidential

Module Lead

Responsibilities:

  • Coordination between the client and development team during the various phases of the project for the activities involving requirements, solution design presentations, solution piloting (CRP), conversion strategy and data, user training and user testing.
  • Execution of Business process analysis, solution design, solution build and configuration, user training, user acceptance testing and post production support for the Procurement suite and Inventory modules of oracle applications
  • Documentation of the As-Is Process (RD50), future process designs (BP80), setups, user training manuals, test scripts and conversion templates for the SCM Modules.
  • Coordination with the technical teams for scheduling the instance configuration for the development, test and production instances.
  • Coordination and documentation of the functional designs (MD50) for the custom developments for interfaces, reports and form customizations.
  • Providing workarounds to business scenarios to the utmost satisfaction of users, workarounds include automatic item code generation, Material Request to PR conversion and LCM.
  • Solution design for Integration of Oracle Inventory with the business third party system (EATEC).
  • Testing of the integrated environment with different positive and negative test cases
  • Used AIM methodology documentation to create various design documents (RD50, BR100, To-Be design (BP80), CRP & UAT (TE40) scripts, Training Manuals, MD50 and Data Migration templates).
  • Coordinating the data conversion activities for the transactional and master data.
  • Identifying and design of reporting requirements.
  • Providing functional presentations and trainings to key and end users coordinating with the client management for phase completion approvals and sign-off’s.
  • Involved in data conversion for UAT and Production which include Master data collection and data conversion like Outstanding (Open) PO conversion, Item Conversion, Item Opening Balances Conversion.
  • Involved in Post production support.

Confidential

Consultant - Inventory and Procurement suite

Responsibilities:

  • Preparation of bi-traceability matrix showing the complete implementation status by going through all the implementation documents.
  • Review the current oracle system and finding the solution gaps.
  • Exploring the pain areas of the current system by coordinating with the actual system end users.
  • Coordinating with the actual process owners of Procurement and Contracts department to lay down the actual business requirements.
  • Recommendations to correct the current solution and meet the actual expectations and business requirements.
  • Submission of final Health Check Report to the business with the recommendations for solution enhancement to meet their business requirements.

Confidential

Module Lead - Distribution and Manufacturing

Responsibilities:

  • Understanding the business process and Oracle Apps setup and transaction configuration through knowledge transition and interaction with the support team and business users
  • Business process understanding in terms of high level business flow documents, functional design documents, test scripts, implementation documents and presentations, customization designs
  • Interaction with business users for understanding the business process followed for the functional areas of procurement, storage, material transfers, manufacturing, order handling, shipping in accordance with the business practices
  • Coordination with the client’s project management team for review and approval of the business process understanding documents, business process test scripts, list of custom components for Rollout of their new Business unit
  • Maintaining a log of the issues encountered and resolution process.
  • 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
  • Resolution of about 65 issues / tickets in the purchasing, inventory, BOM, WIP and order management functional areas that involved additional setup configurations, bug fixes, application of recommended patches, providing workarounds and follow ups with Oracle support for SR’s raised
  • Participation in the daily status review meetings to update the project management team on the status of open, in-process, closed tickets with the appropriate analysis of each ticket status
  • Preparation and presentation of a weekly support process presentation providing the trend of the key indicators like volume of tickets, resolution index, performance index etc.

Confidential

Module Lead - Distribution

Responsibilities:

  • Conducted scope study, gathered and analyzed business requirements for GE WIND (India). Documented functional requirements pertaining to Inventory, Purchasing, Order Management, BOM and WIP modules
  • Gathered and analyzed business requirements. Documented functional requirements pertaining to PO and AP module for Expense Purchases.
  • Modules Setup and Configurations have been done in the system to meet the business needs based on the oracle PO and AP Module functionality.
  • Created custom responsibilities set with the specific menus, functions, report groups and profile options to restrict the access of application security. Defined users and assigned responsibilities and profile options.
  • Mapping of business requirements to Oracle SCM Applications including the study of business requirement for Interface development for some of the GE India Businesses.
  • Documented functional requirements, Solution design and logic pertaining to Interface development.
  • Conducted training sessions to users across different locations in India.
  • Used AIM methodology documentation to create various design documents (BR100, To-Be design, CRP & UAT scripts, SOP, MD50 and Data Migration templates).
  • Involved in development of interfaces like PO Inbound, Receipt Inbound and PO closure Outbound Interfaces.
  • Involved in rigorous testing of Interfaces functionality.
  • Provided the functional specifications and logic for PO print Report.
  • Prepared the Test scenarios and conducted User Acceptance Test
  • Involved in data conversion and other go-live activities like Outstanding PO conversion, Employee, Buyer data etc.
  • Involved in Post production support and supported the period end activities.

Confidential

Module Lead- Distribution

Responsibilities:

  • Coordination between the client and development team during the various phases of the project for the activities involving requirements, solution design presentations, solution piloting (CRP), conversion strategy and data, user training and user testing
  • Execution of Business process analysis, solution design, solution build and configuration, user training, user acceptance testing and post production support for the purchasing, Inventory and Order management modules of oracle applications
  • Documentation of the As-Is Process, future process designs, setups, user training manuals, test scripts and conversion templates for the purchasing, Inventory and Order management modules
  • Coordination with the technical teams for scheduling the instance configuration for the development, test and production instances and maintaining a log of the installation setup steps
  • Coordination and documentation of the functional designs for the custom developments for interfaces, reports and form customizations
  • Coordinating the data conversion activities for the transactional and master data
  • Identifying and design of reporting requirements
  • Contributed to the design and development of OM and Shipping interfaces
  • Providing functional presentations and trainings to key and end users Coordinating with the client management for phase completion approvals and sign-off’s
  • Involved in data conversion for UAT and Production which include Master data collection and data conversion like Outstanding PO conversion, Outstanding SO conversion, Item Conversion, Item Opening Balances Conversion, Price List Conversion etc.
  • Involved in Post production support and supported the period end activities.

Confidential

SCM functional consultant

Environment:Oracle Applications Release 11.5.10.2

Responsibilities:

  • Requirement analysis for the purchasing, Inventory and Order Management functional areas with specific business operations
  • Solution design for inventory and purchasing including configuring the employee jobs and positions, purchase approval hierarchy, categorizing commercial and infrastructure equipment, item codification and maintenance strategy, in additional to the functional flows of oracle applications
  • Provided workarounds to business scenarios to the utmost satisfaction of users, workarounds include COGS Workflow Customization and Tax on Freight.
  • Configuring the solution for the CRP phase
  • Preparation, collection and data cleanup for conversion that included master data for items, Opening Balances, Employees, price list and transactional data for open purchase orders, open purchase agreements, open requisitions, open inventory receipts etc., open sales orders
  • Identifying and design of reporting requirements and providing custom reports for oracle inventory, purchasing, and Order Management
  • Training the key and end users on Inventory, Purchasing Order Management Modules
  • Preparation of project documents (As-Is process, To-be Solution Design, Setup, User Manuals, Unit and Integration test scripts, data transition templates, issue / support logs, etc.)
  • Involved in Post production support and supported the period end activities
  • Involved in the materials management function to cater to the needs of the various stores onboard viz., Naval Stores, Engineering Stores, Electrical Stores, Canteen Stores, Office stores etc.,
  • Involved in requisitioning the material for the various stores from base establishments and external agencies which included Material Requests, RFQs, Quotations, Approvals and material Receipts
  • Maintenance, Planning and Replenishment of the various stores on a periodic basis.
  • Involved in material requirement analysis, tracking and control during the ships refit periods. In addition, liaising with the dockyard workshops and ancillary units as part of the refit project
  • Involved in the EDP activities of the ship in maintaining and using the SLMS (Ship’s Logistic Management System), training ship’s personnel on usage of the software applications and preparing presentations for National and International Delegates visiting the facility.
  • Involved in Stock taking and replenishment
  • Involved in SLMS user testing and support
  • Maintaining SLMS data and updating the Bin Cards for stock count.

We'd love your feedback!