Oracle Financials Functional Consultant - 5+ yrs Experience

VENKATA PRAVEEN

Oracle Financial Functional Consultant

Dallas-Fort Worth, TX 708-***-**** ******.*****@*****.*** linkedin.com/in/venkata-p13

PROFESSIONAL SUMMARY

Results-driven Oracle Financial Functional Consultant with over 5+ years of hands-on experience in Oracle EBS (R12) and Oracle Fusion Cloud Financials, specializing in General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), Expense Management, and Subledger Accounting (SLA). Proven track record of successfully delivering 2+ full life cycle implementations and multiple upgrade/migration projects across financial services, logistics, and hospitality industries.

Adept at translating complex business requirements into actionable Oracle configurations, leading end-to-end implementations from requirements gathering and gap analysis through configuration, data migration, SIT/UAT testing, go-live, and post-production support. Skilled in process optimization across Procure-to-Pay (P2P) and Order-to-Cash (O2C) business cycles, with deep expertise in AIM/OUM documentation, FBDI/ADFDI data loading, OTBI/BI reporting, and cross-module integration. Strong communicator with proven ability to partner with business stakeholders and drive Oracle transformations.

CORE COMPETENCIES & TECHNICAL SKILLS

•Oracle ERP: Oracle EBS R12 (Versions 11.5.10.2, 12.1.3, 12.2.4, 12.2.5, 12.2.6), Oracle Fusion Cloud Financials (Releases 12 & 13)

•Functional Modules: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Expense Management, Project Accounting, Purchasing, Inventory, Order Management, iSupplier, Cost Accounting

•Business Processes: Procure-to-Pay (P2P), Order-to-Cash (O2C), Record-to-Report (R2R), Period Close & Reconciliation, Intercompany Transactions, Multi-Org Architecture, Budgets

•Subledger & Tax: Subledger Accounting (SLA) Customization, AGIS (Account Generator), Vertex Tax Integration, Advanced Collections, Dunning, AutoInvoice, Lockbox

•Reporting & Analytics: OTBI, BI Publisher, SmartView, Financial Reporting Studio, Oracle Discoverer, Custom SQL Queries

•Data & Integration: FBDI, ADFDI, WebADI, SQL Loader, Data Loader, REST APIs, ESS Jobs, Payment Process Profiles, Bank Statement Reconciliation

•Methodology & Docs: AIM/OUM, Agile, Waterfall BRD, FRD, MD.050, MD.070, CV.040, TE.040, Training Materials

•Tools: SQL Developer, Toad, JIRA, ServiceNow, MS Office 365 (Excel, Visio, PowerPoint), SharePoint, PuTTY

PROFESSIONAL EXPERIENCE

Charles Schwab, Dallas, TX Feb 2024 – Present

Role: Oracle Financial Functional Consultant (Contract)

Environment: Oracle Fusion Cloud Financials (Release 13) – Accounts Payable, General Ledger, Cash Management, Fixed Assets

Project: Oracle Fusion Cloud Financials Implementation and Production Support

Charles Schwab is a leading American financial services company offering banking, investments, wealth management, and advisory services, managing billions in client assets with a broad national branch network.

•Partnered with business stakeholders across finance, accounting, treasury, and IT to understand current financial processes, identify pain points, and recommend process improvements aligned with Oracle Fusion Cloud best practices.

•Served as the primary functional resource for Accounts Payable (AP) implementation: configured invoice processing, payment terms, supplier management, holds management, payment methods, AP accounting rules, and Fusion Payments (Check, EFT, Wire Transfer, PPR batch processing).

•Configured General Ledger (GL) including chart of accounts structure, ledger sets, cross-validation rules, intercompany accounting, journal approval workflows, allocation rules, and revaluation setups for multi-entity financial reporting.

•Led Cash Management (CM) configuration including bank account setup, bank statement import and reconciliation, cash positioning, payment process profiles (PPF), and integration with AP and AR for automated payment and receipt processing.

•Supported Fixed Assets (FA) configuration: asset categories, depreciation methods, asset books (corporate and tax), capitalization thresholds, mass additions from AP, asset transfers between business units, and CIP management.

•Designed and configured Subledger Accounting (SLA) rules for AP, AR, FA, and CM modules, ensuring accurate journal entry creation and seamless GL posting with full audit trail transparency and SOX compliance.

•Configured AP invoice validation rules including 2-way, 3-way, and 4-way matching with tolerance definitions and automated hold resolution workflows. Set up supplier management including registration, sites, bank accounts, withholding tax groups, and 1099 reporting.

•Configured the end-to-end Procure-to-Pay (P2P) cycle from purchase requisition through purchase order, receipt, invoice matching, payment, and GL posting with full SLA traceability.

•Built and optimized OTBI reports and dashboards for AP Aging, Invoice Holds, Uninvoiced Receipts (GRNI), Cash Position, Bank Reconciliation Status, and GL Trial Balance. Reduced AP invoice resolution time by approximately 40% through daily AP Hold Dashboard implementation.

•Oversaw data migration from legacy systems using FBDI templates for suppliers, open invoices, balances, bank accounts, asset records, and GL journal balances, ensuring reconciliation accuracy.

•Designed enterprise structures: Business Units, Legal Entities, Ledgers, Chart of Accounts segments (Company, Cost Center, Account, Intercompany, Future), and accounting calendar aligned with fiscal year requirements.

•Conducted Conference Room Pilots (CRP), SIT, and UAT testing; created test scripts, executed scenarios, logged defects via JIRA, and drove resolution. Provided change management support, user training workshops, and comprehensive documentation.

•Delivered ongoing production support including issue resolution via ServiceNow, monthly close support, root cause analysis, and continuous process optimization. Collaborated with technical team on ADFDI integrations, REST APIs, ESS jobs, and custom workflow extensions.

•Identified and implemented solutions to bridge gaps between on-premise legacy systems and Oracle Fusion Cloud, including custom conversion programs, interface designs, and workaround configurations for unsupported legacy features.

•Applied strong communication and analytical skills to coordinate cross-functional meetings, present status updates to finance leadership, facilitate requirement workshops, and interpret complex financial data for technical and non-technical audiences.

•Worked on ADFDI spreadsheet integrations for journal uploads and AP invoice creation, enabling finance users to leverage familiar Excel-based workflows within the Oracle Fusion Cloud environment.

Bahri (National Shipping Company of Saudi Arabia) Mar 2022 – Aug 2022

Role: Oracle Financial Functional Consultant (Contract)

Environment: Oracle Fusion Cloud Financials (Release 13) – General Ledger, Fixed Assets, Expense Management

Project: Oracle Fusion Cloud Financials Full Life Cycle Implementation

Bahri is one of the world’s leading logistics and transportation companies, operating a diverse fleet for oil, chemical, dry bulk, and logistics across global operations.

•Participated in full life cycle implementation from requirements gathering (Fit-Gap analysis) through design, configuration, testing, data migration, go-live, and post-production stabilization.

•Served as functional lead for General Ledger (GL): configured Chart of Accounts (6 segments – Company, Division, Department, Account, Intercompany, Future), ledger creation, accounting calendar, journal categories and sources, cross-validation rules, and GL intercompany accounting for multi-entity, multi-country transactions.

•Configured Fixed Assets (FA): asset categories, corporate and tax books, depreciation methods (Straight Line, Declining Balance, Units of Production), asset key and location flexfields, capitalization thresholds, mass additions from AP, asset retirements, reclassifications, transfers, and CIP capitalization processes.

•Set up Expense Management module: expense categories, policy enforcement rules, approval workflows, corporate card integration, per diem rules, and mileage reimbursement configurations for global employee expense processing.

•Designed Subledger Accounting (SLA) rules for GL, FA, and Expense modules defining journal line rules, account derivation rules, and mapping sets for accurate and auditable journal generation.

•Conducted detailed Fit-Gap analysis sessions with stakeholders from finance, accounting, and fleet operations. Prepared comprehensive AIM documentation (BRD, MD.050, MD.070, CV.040, TE.040).

•Executed data migration using FBDI for Chart of Accounts, opening balances, asset records, and supplier data with thorough source-to-target reconciliation across all dimensions.

•Configured GL period close procedures: subledger transfer, journal posting validation, reconciliation checks, revaluation, translation, and consolidation for multi-currency, multi-entity reporting.

•Designed and executed SIT/UAT test scenarios covering journal posting, period close, asset capitalization, depreciation runs, expense report submission and approval, and intercompany transactions.

•Provided 4-week post-go-live hypercare support, resolving production issues, supporting first month-end close, and delivering knowledge transfer documentation to the client’s support team.

•Worked closely with the technical team on custom integrations, scheduled processes (ESS jobs), and workflow configurations to meet business-specific requirements not addressed by standard Oracle Fusion functionality.

Broadridge Financial Solutions, New York, NY Apr 2018 – Feb 2022

Role: Oracle Financial Functional Consultant (Contract)

Environment: Oracle EBS R12 (12.2.5 / 12.2.6) – Accounts Receivable, General Ledger, Advanced Collections, AGIS

Project: Oracle EBS R12 Upgrade, Full Life Cycle Implementation, and Production Support

Broadridge is a global fintech leader providing investor communications, technology-driven solutions, and data analytics to banks, broker-dealers, asset managers, and corporate issuers.

•Participated in full life cycle implementation and upgrade of Oracle EBS R12 Financials from discovery and requirements analysis through configuration, data conversion, testing, go-live, and 3+ years of production support.

•Primary functional resource for Accounts Receivable (AR): configured transaction types, transaction sources, receipt methods and classes, AutoInvoice (line ordering, grouping, validation rules), customer profiles and profile classes, collectors, AR system options, and receivables activities.

•Configured General Ledger (GL): Chart of Accounts structure, accounting periods, journal approval hierarchies, allocation rules, recurring journals, MassAllocation, cross-validation rules, intercompany setup, and GL period close procedures.

•Designed and implemented AR revenue recognition rules, credit memo and debit memo workflows, on-account payments, unapplied receipt management, and lockbox processing for automated bank receipt import.

•Configured Advanced Collections: scoring engines, collection strategies, dunning plans and letters, promise-to-pay tracking, collector assignment rules, and aging bucket definitions to optimize DSO reduction.

•Set up Account Generator (AGIS) workflows for automatic GL account derivation during AR and AP transactions based on transaction type, customer classification, and business unit.

•Configured Subledger Accounting (SLA) rules for AR defining accounting event classes, journal line types, and account derivation rules for revenue, receipts, adjustments, and write-offs. Managed full O2C cycle: order entry, shipping, AR invoicing via AutoInvoice, receipt application, and GL posting.

•Designed and implemented Vertex tax integration with Oracle AR for automated multi-jurisdiction tax calculation, reporting, and compliance across federal, state, and local jurisdictions.

•Built custom reports (AR Aging, Customer Balance, Receipt Application, Collection Effectiveness Index dashboards) using BI Publisher and Oracle Discoverer for finance leadership decision-making.

•Executed data conversion via WebADI, SQL Loader, and PL/SQL scripts for customer master data, open invoices, open receipts, and GL journal balances. Set up customer hierarchies, credit limits, and credit check rules.

•Conducted SIT, UAT, and regression testing covering AR transactions, receipt processing, lockbox, collections workflows, GL journal posting, period close, and intercompany transactions with comprehensive test scripts and defect tracking.

•Provided 3+ years of production support handling 500+ service requests: month-end and year-end close support, root cause analysis for GL/AR discrepancies, and continuous process improvement recommendations.

•Configured receivables activities including adjustment approval workflows, write-off limits, receipt write-off rules, finance charges, and late charges to automate receivables management and improve operational efficiency.

•Set up customer hierarchies, customer merge processes, credit limits, and credit check rules for Broadridge’s complex multi-entity client structure spanning broker-dealers, asset managers, and corporate issuers.

•Mentored junior consultants on Oracle EBS AR/GL configuration, testing methodology, and AIM documentation. Prepared comprehensive AIM documentation (BRD, FRD, MD.050, MD.070, CV.040, TE.040, training materials).

IHG Hotels & Resorts, Atlanta, GA Oct 2017 – Jan 2018

Role: Oracle Business Analyst

Environment: Oracle EBS R12 (12.1.3) – General Ledger, Accounts Payable, Accounts Receivable

Project: Oracle EBS Production Support and Process Optimization

IHG Hotels & Resorts is one of the world’s leading hospitality companies with iconic brands including InterContinental, Holiday Inn, and Crowne Plaza, operating across 100+ countries.

•Provided Oracle EBS R12 Financials production support for GL, AP, and AR modules, handling daily operational issues, service requests, journal posting validation, subledger reconciliation, and trial balance review.

•Gathered and documented business requirements from finance stakeholders for process improvement initiatives, translating needs into functional specifications for Oracle EBS enhancements.

•Assisted in GL period close activities including journal posting, subledger reconciliation, trial balance review, and intercompany elimination entries.

•Supported AP invoice processing (invoice entry, holds resolution, payment batches, supplier setup, payment terms) and AR transaction processing (invoice creation, receipt application, aging analysis, credit memo processing).

•Analyzed As-Is and To-Be processes using Visio to identify automation and standardization opportunities. Created test scripts for enhancements, coordinated UAT with business users, and prepared functional documentation.

•Gained exposure to multi-currency transactions, multi-org architecture, and financial reporting requirements of a global enterprise operating across 100+ countries.

•Collaborated with the DBA and technical team on performance tuning, custom report development, and interface troubleshooting for financial data feeds from property management systems.

EDUCATION

Valparaiso University, Valparaiso, IN Aug 2022 – Dec 2023

Master of Science (MS) in Information Technology

Relevant Coursework: Database Management Systems, Enterprise Resource Planning, Business Intelligence, IT Project Management, Systems Analysis & Design

PROJECT SUMMARY

Client

Duration

Role

Modules

Environment

Charles Schwab

Feb 2024 – Present

Functional Consultant

AP, GL, CM, FA

Oracle Fusion Cloud R13

Bahri

Mar 2022 – Aug 2022

Functional Consultant

GL, FA, Expense

Oracle Fusion Cloud R13

Broadridge

Apr 2018 – Feb 2022

Functional Consultant

AR, GL, Adv Collections

Oracle EBS R12

IHG Hotels

Oct 2017 – Jan 2018

Business Analyst

GL, AP, AR

Oracle EBS R12

CERTIFICATIONS & PROFESSIONAL DEVELOPMENT

•Oracle Fusion Cloud Financials – Accounts Payable Implementation (Oracle University)

•Oracle Fusion Cloud Financials – General Ledger Implementation (Oracle University)

•Oracle EBS R12 Financials Functional Training – GL, AP, AR, FA, CM

•Agile/Scrum Methodology Training

•Continuous learning through Oracle Cloud quarterly release notes, Oracle LiveLabs, and professional development courses

KEY ACHIEVEMENTS

•Successfully delivered 2+ full life cycle Oracle implementations (Broadridge EBS R12 & Bahri Fusion Cloud) on schedule and within budget, managing concurrent workstreams across multiple functional modules.

•Reduced AP invoice resolution time by approximately 40% at Charles Schwab through implementation of daily AP Hold Dashboard and automated exception workflow routing, significantly improving month-end close efficiency.

•Improved collections efficiency at Broadridge via Advanced Collections scoring engine and dunning strategies, contributing to a measurable reduction in Days Sales Outstanding (DSO) and improved cash flow.

•Migrated 10,000+ master data records (suppliers, customers, open transactions, GL balances, asset records) across multiple projects with 99.5%+ data accuracy through rigorous three-layer reconciliation frameworks.

•Recognized by project leadership for comprehensive AIM documentation quality and clear, effective stakeholder communication across all engagement levels from C-suite finance leaders to end users.

•Maintained 98%+ SLA adherence during 3+ years of production support at Broadridge, handling 500+ service requests while supporting monthly and year-end close cycles without disruptions.

Contact this candidate