SUMMARY

• Oracle Financials Functional Consultant with more than 9 years of aggregate Experience.
• Extensive experience with being a Functional Consultant in AR, AP, GL, FA, Cash Management, OM, i - Expense, INV, PO 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
• Extensive experience with Production Support, Supporting Month End, Quarter End activities, experience with closing the period and closing of books.
• 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.
• Extensive experience with writing Financial Statement Generator (FSG) reports in GL module.
• Primary Skill set: Excellent Functional experience in AR, AP, GL, FA, i-Expense, OM, INV and PO
• 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
• 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
• Experience with the return process in Order Management, Reverse Logistics flow and integration to Depot Repair.
• Extensive experience in CRM Modules of Service Contracts and Install Base.
• Extensive experience with the Order to Cash and Procure to Pay 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.

PROFESSIONAL EXPERIENCE

Confidential

Financials Functional Consultant

Responsibilities:

• Study AS-IS Business Process of Fidelity Investments.
• 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.
• Developed several different FSG Reports - Defined Row Sets, Column Sets, Row Set Account Assignments, Row Set Calculations, Column Set Account Assignments and Calculation, Content Sets.
• Defined more than 50 financial reports and also created FSG report sets.
• Go through the process of SDLC- Software Development Life cycle. Requirement gathering developed Functional Specifications for new development/enhancements/Change requests
• Created and maintained FSG Financial Reports critical to company’s business process.
• Consolidation and mapping of reports between different instances
• Transferring reports to different instances
• Running and publishing of reports for User Acceptance Testing.
• 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 AR, AP, GL, i-Expense, FA modules.
• Worked with business users on planning and executing data conversion activities like AR Invoices, AP Invoices, GL Journals, Suppliers and Customers, etc.
• 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, Los Angeles, California

Oracle Financials Functional Analyst

Responsibilities:

• Worked on the configurations of AR, AP, GL, i-Expense, FA modules.
• Worked with end users to document the business processes & functional requirements also providing them with training materials
• Worked in parallel with the client is resolving the CRP 2 and post go-live testing issues with offshore support.
• Worked on developing around 25 FSG reports - including defining the row sets, columns sets, content sets, sort options, formatting options, etc.
• Performed all the Testing for AR, AP, GL, i-Expense, FA Modules
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications from BAAN & D1.
• Implemented TCA - for AR customer master conversions.
• Worked extensively on Oracle User Productivity Kit (UPK) and Oracle Tutor to train the users on Oracle Financials and Distribution.
• Establish the best practices and controls in Oracle like. - Security, Segregation of duties.
• Unit & Integration testing on all Cross modules.

Confidential, Raleigh, NC

Financials Functional Consultant

Responsabilities:

• Responsible for understanding the Business Processes and Knowledge Transition
• Responsible for Testing and documentation
• Responsible for Training to the Operations Team
• Involved in modules AR, AP, GL, i-Expense, FA
• Participated in System analysis and gathered requirements.
• 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.
• 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.

Confidential, Los Angeles, CA

Financials Consultant

Responsibilities:

• Been part of the Scope analysis for supply chain domain
• Collated the issues in the current version and requirements in the latest version
• Prepared AS IS and TO BE process documents.
• Configured additional Setups in the upgrade version.
• Developed Test scripts and successfully completed CRP 1 with Localization.
• 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
• 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.

Confidential, Phoenix, AZ

Functional Consultant

Responsibilities:

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• Review other functional Specifications.
• Worked on the set ups all the modules in Order to cash cycle.
• Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management and AR
• Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
• Prepared high-level technical design document.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing, training, documentation and implementation of modules.
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Confidential, Boston, MA

Oracle Apps Functional consultant

Responsibilities:

• As a Functional Consultant in the Procure to pay business flows, implemented financial modules: i-Expense, GL, AP, Advance Collections, and AR, i-Receivables & FA of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in iExpense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc.
• Advance Collections - Setup the Scoring Engine, Strategies, Work Items, Universes, Filters, Defined the delinquency status range in Advance Collections.
• Created the Collections Administrator, Collections Manager, Collections User profiles in Advance Collections.
• Implemented internal control features using Form Personalization’s for modules GL, FA, AP, and AR.
• I-Receivables - Performed all the setups for i-Receivables module, tested it and performed the rollout and training on i-Receivables module.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• Implemented VERTEX Quantum tax software and D&B integration with oracle.
• Customization done on CFD’s like AR Customer Invoice for pre-printed stationery and using XML feature, inter Company Customer Invoice, AP -Remittance Advice.
• Designing and executing ‘Data migration’ strategy for Master and Transactional data. Migrated GL Balances, Budgets, Suppliers, AP open Invoices, Customers, AR open Invoices, Fixed Assets by using ADI tools and loader scripts.
• Creating Purchase Orders for Capital Projects, Charging Supplier Invoice Lines to Projects, Charging Expense Reports to Capital Projects, Charging Labor, Usages, and Miscellaneous Transactions to Capital Projects, Placing CIP Assets in Service, Creating Fixed Assets from Capital Projects, Defining and Processing Assets
• Developed different reports as per the client’s requirement.
• Developed custom interface between Order Management and Projects.
• Customized the PO account generator and the Payables workflow.
• Prepared documentation to supplement the implementation Project Costing.
• Trained business owners and business end-users on Capital Projects Costing as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Confidential, Schaumberg, IL

Oracle Apps Functional Consultant

Responsibilities:

• Interacted with Business System Analyst for requirement Gathering.
• Prepared Functional specification document and High level Design document.
• Exhibited good coordination with Technical team for Design and Development.
• Prepared Unit test plan and scripts for verifying the conversions
• Conversion and verification together done within the timelines.