SUMMARY

• Oracle Financials Functional Consultant with more than 7 years of aggregate Experience.
• Extensive experience with being a Functional Expert in Financials modules of AR, AP, FA, Cash Management, AGIS, SLA, e - Business Tax, i-Expense and GL Worked with reputed Clients from different countries Domain expertise spans across Manufacturing, Materials, Logistics, and Distribution Worked with various teams successfully across multiple projects globally Good at building and managing customer relationship.
• Passionate to achieve goals with profitability and customer delight in mind
• Over 7 years of experience in Supply Chain Management and IT Consulting.
• Core Team-member during Oracle Application Implementations for several clients
• Extensive experience with functional tracks
• Developed Functional specification Documents (FSDs), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
• Developed the following AIM Documents BR100, MD050, RD020, RD030, TE030, TE040, etc.
• Primary Skill set: Excellent Functional experience in AR, AP, FA, Cash Management, AGIS, FAH, SLA, e-Business Tax, i-Expense and GL
• Extensive experience with Approval Manager Engine (AME)
• Good knowledge and a high level of expertise in the functional aspects of the Oracle Apps Purchase, Inventory, Advance Pricing, Order Management, MRP and Daily Business Intelligence Modules
• Strong in Oracle Apps Implementation - Business Process Mapping, Gap Analysis, Test cases, Data Migration, Localization setups
• Proven ability to develop creative solutions to Material flow/Supply Chain management challenges

TECHNICAL SKILLS

Oracle Applications: AR, AP, FA, Cash Management, AGIS, SLA, e-Business Tax, i-Expense and GL modules

Others: Toad, MS Office (Word/Excel/PowerPoint), Minitab 12

PROFESSIONAL EXPERIENCE

Confidential, NY

Financials Functional Analyst

Environment: Oracle Release 12.1.3

Responsibilities:

• Actively involved in implementation of E-business suit for SGP Operating Unit including gathering the requirements from the user and understanding their business model the modules worked on includesAR, AP, FA, Cash Management, AGIS, SLA, e-Business Tax, i-Expense and GL
• Worked on all the Business Analysis of developing the GAP Analysis, Business Requirement Documents (BRD’S), Functional Specification Documents (FSD), MD050, BR100, TE020, Te030, etc.
• Gathered Requirement for Conversion programs Invoice, Receipts, Journals Conversion, and Customer Addresses Conversion.
• Performed all of the setups for AME - setting up AME Rules, Attributes, Conditions, Notifications, Parallel Approval process, etc.
• Developed the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of the customizations and data conversions.
• Worked on the Sub Ledger Accounting module - setting up custom sources, events, account derivation rules, account mapping.
• Reviewing Functional Specifications / Change requests with the client.
• Worked on the Revenue Recognition process in AR Module.
• Communicating the requirements to the technical team
• Preparing design document as per the functional requirements
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting the users with the User Acceptance Testing (UAT)
• Taking part in the review of test cases and giving necessary inputs.
• End-user training
• Updating the client on the status of the project at offshore, almost everyday.
• Reviewing and giving inputs on all the developed components, Unit test Plan and Unit test report.
• Taking care of the Resource Allocation

Confidential, San Diego, CA

Financials Functional Analyst

Environment: Oracle Release 12.1.1

Responsibilities:

• Conducted meetings with Super users/SME’s to gather requirements for Procure to pay and Order to Cash cycles and documented in BR-30.
• Responsible for the complete setup and implementation of AR, AP, FA, Cash Management, FAH, AGIS, SLA, e-Business Tax, i-Expense and GL
• Developed all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Functional Specification MD050, Testing Documents TE030 and TE040, etc.
• Worked on all the setups for the Revenue Recognition, OM, and INV modules.
• Performed all the setups for the Quoting Module in relation to Order Management.
• Worked on the Configuration of the AME module including setting up of the Approval Rules, Security rules, parallelization process, attributes, conditions, etc.
• Performed Purchasing set-ups. Set up the approval hierarchies and workflow in Purchasing.
• Performed MRP planning set ups for different organizations.
• Worked closely with CRM team on spares management and Depot-Repair modules to understand and implemented repair planning and min-max planning.
• Participated in RICE component activities and created functional design documents for conversions and interfaces. (CV040 and MD050).
• Worked closely with Client finance user team and Oracle finance consultant on issues like intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
• Worked closely with on site and off site technical team on Master and Transactional data conversion and validation issues.
• Also, designed functional documents for various Gaps and interfaces such as SFDC forecast interface and PDM to Oracle interface.

Confidential

Financials Functional Business Analyst

Environment: Oracle 11.5.10.2

Responsibilities:

• Designing Solution for Supplies Management Processes
• Re-designing Solution for Master Data Registry
• Developed all of the Functional Design Documents (MD050), Functional Requirements Document (FSD), Business Requirement Documents (BRD), TE030 and TE040, BR100, etc.
• Responsible for Setup and Configuration of all Distribution modules including AR, AP, FA, Cash Management, i-Expense and GL
• Responsible for Testing and documentation
• Designed a solution to manage Inventory Items for the entire flow from Requisition-to-Receipt and Receipt-to-Expense for 5 different Inventory Organization
• Designed an automated replenishment process using Oracle’s Replenishment count process. Replenishment Count Data is fed to the Inventory Interface tables using handheld scanners
• Designed the process for UOM definition and conversion for the Items. CHP had a requirement for 297 different package combinations, which required UOM conversions.
• Reviewed and extended the use of purchasing data (e.g., Requisition templates, categories, BPAs, ASL, etc) and made these data structures available to i-Procurement
• Trained the OM Users on OM Search(Quick and Advanced) functionality in order to quickly identify the Item to Sales order match B2B
• Business process modeling integrating AESM with Factory.
• Data Flow Model.
• Monitored the interface between OM and Ecommerce site.
• Functional design to Capture the Data, Outbound / Inbound Programs processes
• Design necessary B2B Notifications
• Oracle updates process design from B2B response of Factory.
• Functional design of the B2B Reports thro Business Objects.

Confidential

Financials Functional Consultant

Environment: Global Roll Out of Oracle Release 12

Responsibilities:

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Worked on the localizations for Brazil, Span and US and UK.
• Implemented financial modules: i-Receivables, i-Expense, Advance Collections, AP, AR, FA & CE along with PO integrated with internal e-Procure system, Release 11i of oracle (11.5.10.2).
• I-Expense - Configured i-Expense for Multi Currency capability, implemented Mileage and Per Diem, setup all mandatory configurations for i-Expense, Implemented p-Card functionality in i-Expense.
• Implemented 14 SOB’s (20 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Experience with Vertex Integration for Sales Tax.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Implemented Party Relationships in the TCA.
• Implemented the Data Quality Management in TCA.
• Implemented the D&B Integration for TCA.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created New FSG Reports, using mutli-currency features including foreign currencies for multi org structures.
• Implemented internal control features using Form Personalization’s for modules GL, AP, AR.
• Implemented Inbound Regular Invoice interfaces for AP & AR using XL spread sheet.
• Implemented Automatic upload & Bank Reconciliation functionality in CM.
• Implemented Auto Lock box Functionality in AR.
• Implemented Outbound interfaces for AP for creating bank payment outbound file

Confidential

Financials Functional Consultant

Environment: Oracle 11.5.10

Responsibilities:

• Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time
• Setup Advanced Pricing system to simplify the Pricing process using automatic modifiers, Discounts and Promotions
• Defined several custom Modifiers and Qualifiers in Advance Pricing.
• Setup Dynamic Formulas for Advance Pricing.
• Simplified the Freight Charge application process by setting up formula to convert Freight Cost to Charge and modifiers along with associated qualifiers
• Available to Promise(ATP) and Auto-Scheduling functionality configuration reduced the Scheduling process time and enhanced customer service level
• Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
• Internal Sales Order/Internal Requisition process was configured to establish a simplified Inter company sales across operating Units
• RMA and Approval Management functionality setup reduced the process time in Customer Returns management
• Designed and developed all the setups and configurations for Inventory management.
• Setup all the planning functionality for Inventory.
• Performed all the Organization setups for Inventory.
• Performed all the setups for Cycle Counting in Inventory
• Performed all the setups for ABC Analysis.
• Performed all the setups for Items, Categories, Catalogs, etc.
• Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization
• Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases
• Configured Auto-Sourcing rules, Approved Supplier List (ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench
• Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process

Confidential

Functional Consultant

Environment: Oracle 11.5.10

Responsibilities:

• Responsible for understanding the Business Processes and Knowledge Transition
• Responsible for Testing and documentation
• Responsible for Training to the Operations Team
• Involved in modules OM, INV, Advance Pricing and AR.
• Participated in System analysis and gathered requirements.
• Worked on Order to Cash Process, Internal orders process.
• Creating the items, shipping Network, Locations, Conducted Miscellaneous transactions, internal customers, price list, Requisitions, pick release against sales orders, ships confirms for sale orders. Defined Sales Credits setups.
• Designed general setups like defaulting rules, processing constraints, pick release rules, shipping setups, DFFs and Transaction types.
• Designed price lists for different currencies, Modifiers and qualifiers.
• Define pricing formulas. Attaching pricing attributes to modifier lines.
• Define a price list and adding items to price list. Define a multi currency conversion list. Define modifiers list.
• Worked on Order Cycle, which includes Booking, Pick Release, Ship Confirming and Interface to Receivables, Invoice/Credit memo generation.
• Performed unit testing & integration testing along with test data preparation.
• Used AIM methodology for project documentation.
• Worked closely with technical team and given inputs for integration testing.
• Functional/Integration Testing/System Testing and User Acceptance Testing.
• Analyzed 3rd Party applications which are integrating with oracle apps and provided solutions to the integration points.
• Business study and Prepared Process Analysis Questionnaire.
• GAP analysis and resolution for Order Management Modules with respect to the service contracts. Also documented the entire Gaps and its Resolution/Recommendation.