SUMMARY:

• Been a member of the Functional focus team and about 8.7 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Functional Consultant specializing in Oracle Application implementations, specifically Financials.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, OM, Advance Pricing (QP), i-Procurement, PO, INV, AP, AR combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
• Worked on Oracle Process Manufacturing (OPM) - Modules of OPM INV, OPM OM, OPM Quality and OPM Formula Management, OPM Production.
• Extensive experience with the Order to Cash (O2C) and Procure to Report (P2R) business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i

Modules: Quoting, I-Procurement, OM, Advance Pricing (QP), PO, BOM, WIP, MRP, INV, AP, AR, Oracle Process Manufacturing (OPM) - Modules of OPM INV, OPM OM, OPM Quality and OPM Formula Management, OPM Production

Databases: DB2 and Oracle 7.x./8.0.5/8i/9i/10g.

Oracle Tools/ Utilities: TOAD, PL/SQ: developer SQL * Loader, Export, Import, SQL & Monitors.

Operating Systems: UNIX, Windows 95/98/2000, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential, Columbus - OH

Forecast to Delivery Lead

Responsibilities:

• Represented Capgemini as the onsite lead for the forecast to delivery stream in application management/production support team for the Confidential Farm's Oracle EBS application. My key responsibilities were:
• Analyzing and resolving the issues that occurs in the Oracle application during the day to day operations of the manufacturing plants and warehouses.
• Work closely with Oracle through service requests to get required data fixes or patched to fix the issues and to get the file version of the application to an optimum level.
• Educating the users regarding the physical inventory and cycle count process.
• Streamlining the physical inventory process and suggested good practices to help users in the plant perform the process effectively.
• Handling OPM period closes by identifying, analyzing and resolving the pending transactions that could stop the period close process.
• Coordinate the implementation of enhancement/customization requests raised by customers or suggested by the team.
• Create the required AIM documents like MD50 and BR100

Confidential, Minneapolis, MN

Functional Consultant

Responsibilities:

• Created Functional design documents using Data Flow Diagrams and Use Cases and developed Test scripts using Oracle AIM Methodology as part of Bookings- ETM integration project to apply sales rep and territory information from an external system (ETM) to Oracle OM.
• Responsible for driving data conversion/migration and interface planning activities to integrate ETM with Oracle PO and i-Procurement modules.
• Worked on the setup of Oracle Process Manufacturing (OPM) - Modules of INV, OM, Formula Management and Production
• Responsible for driving project meetings with various stakeholders from internal Oracle Business teams to external teams (downstream and upstream) to discuss gaps in application design, develop solutions, and formulate testing strategies.
• Study AS-IS Business Process of Oracle OM Territory Assignment.
• Analyze the external Enterprise Territory Management System (ETM) to be integrated with Oracle OM.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Confidential, Louisville, KY

Oracle SCM Functional Consultant

Responsibilities:

• Created Inventory setups - defined Key Flex fields, Organizations, Inventory Parameters, UOM, Sub Inventories, Item Attribute controls, Categories, Category Sets, Item Statuses, Item Types, Item Templates, Customer Items and Customer Item Cross References, and performed Item Conversion for CRP1, CRP2, and UAT instances for Arco.
• Created OM and Pricing Setups - defined Descriptive Flex fields, Profile Options, System Parameters, Lookup Codes, Order Sources, Transaction types, Document Sequencing, Document Categories, Shipping Parameters, Defaulting Rules, Processing constraints, Order holds, Blanket Sales Agreements, Workflow background process, Price Lists, Modifiers, and Qualifiers for various Arco instances.
• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for PO, INV, Production modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Designed and Developed the Test Scripts for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
• Involved in the Testing of the OPM PO, OPM INV, OPM Production modules including developing Test Cases, Conducting UATs and CRPs as well as logging defects in the Mercury Quality Center tool.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Created Users, Responsibilities, Menus, Request Groups, and System Profile Options using System Administrator responsibility.
• Created Test scripts for Inventory, OM, and Pricing for scenarios including and excluding customized Order Interface program which linked legacy Order creation system to Oracle OM.
• Created Data Load scripts for loading various forms like Modifiers, Value sets, Lookup codes, Item categories, Items etc.
• Created user training manuals like Customer setup and Supplier setup documents and conducted training sessions for users

Confidential, FL

Functional Consultant

Responsibilities:

• Study AS-IS Business Process.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Worked on the setups and configurations for Advance Pricing (QP), i-Procurement, PO, INV, AP, AR modules.
• Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
• Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Confidential

Oracle Functional Consultant

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in Advance Pricing (QP), i-Procurement, PO, INV, AP, AR.
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
• Played an important role on Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
• Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.
• Handling a team of 4 members and responsible for their productivity, efficiency & quality.

Confidential, San Diego, CA

Oracle Applications Business Anlayst

Responsibilities:

• Prototype the business process by mapping against the functionality of the modules in a test database installed as a part of the Oracle Applications installation process.
• Set up OM Transaction Types, OM Parameters.
• Set up Inventory Organization for OM related items.
• Defined time limit for Booking of Order, Scheduling of Order, Closing Order Lines and Order Headers.
• Set up pricing parameters/list.
• Inventory On hand availability Checking, Pick Release Rules, and Back Ordering decision.
• Set up Shipping Parameters/Rules, Containers, and Granting Roles to Users.
• Document sequencing for Order Numbering.
• Modification/cancellation of Orders/Order lines.
• Created MD050 based on RD020 and RD050.
• Prepared TE020, TE040 based on MD050.
• Developing test scenarios and testing the code units developed
• Testing the system for specific scenarios after upgrade to 11.5.9
• Coordinating with the client for requirement related discussions.

Environment: Oracle Applications 11.5.9(AP, OM, GL, Oracle Workflow 2.6, PL/SQL)

Confidential

Oracle Applications Analyst

Responsibilities:

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
• Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management, WIP, BOM and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Conducted CRP and Integration testing for related modules
• Maintain issue tracker and coordinated with the team for debugging
• Involved with user acceptance testing (UAT) and end user training
• Prepared and provided comprehensive training materials and practice exercises

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts), Oracle 8i(SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and HP-UNIX, Discoverer