Oracle ERP Functional Consultant Cloud & EBS Specialist

DHANUSH KUMAR YADLAPALLI

Florida, USA 656-***-**** *****************@*****.*** LinkedIn

SUMMARY

• Oracle Functional Consultant with 4 years of experience implementing, configuring, and supporting Oracle Cloud ERP and EBS modules, including GL, AP, AR, FA, PO, CM, iProcurement, and HCM.

• Expertise in gathering requirements, performing GAP analysis, and preparing functional design (BR100, MD50) and process documentation using AIM and OUM methodologies to deliver scalable Oracle solutions.

• Skilled in end-to-end Oracle Cloud ERP implementations, encompassing process design, configuration, data migration, integration, reporting, testing, and go-live support across multiple business units and regions.

• Hands-on experience in data migration and validation using FBDI, ADFdi, LDT, and HCM Extracts, ensuring data consistency and integrity while consolidating legacy systems into Oracle Cloud.

• Experienced in integrating Oracle Cloud ERP with legacy systems and third-party applications using OIC, APIs, and SOAP/REST, enabling seamless business processes.

• Flexible in configuring approval workflows using BPM / AME, streamlining business approvals and enhancing process efficiency.

• Expertise in reporting and analytics using Oracle OTBI, BI Publisher, and Excel-based tools, delivering actionable insights and enabling business users to monitor financial, procurement, and operational KPIs.

• Participated in CRP, SIT, UAT, and regression testing phases for multiple Oracle Cloud modules, creating traceability matrices and detailed test scripts to ensure end-to-end process validation.

• Adept at user acceptance testing, process validation, and end-user training, preparing detailed test scripts, executing functional testing, and conducting knowledge transfer sessions to ensure smooth adoption of Oracle solutions.

• Experience working in cross-functional and global teams under Agile and Waterfall methodologies, coordinating with business users, IT, and external vendors to deliver Oracle ERP solutions that enhance operational efficiency and streamline end-to-end processes.

SKILLS

ERP Modules: Oracle Financials (GL, AP, AR, FA), Oracle Procurement (PO, iProcurement), Oracle Order Management (OM), Oracle Inventory (INV), Oracle Projects (PA), Oracle HCM (HRMS, Payroll)

Functional Expertise: Requirement Gathering, Business Process Analysis, GAP Analysis, Functional Design Documentation (FDD), Configuration & Setup, Workflow Design, User Acceptance Testing

(UAT), Business Process Re-engineering

Technical Tools: SQL, PL/SQL, Oracle Reports, Oracle BI Publisher, Oracle OTBI, Oracle BPM, Oracle Cloud Integration (OCI), Excel (Advanced), MS Visio, MS Project Integration & Middleware: Oracle SOA, Web Services (SOAP/REST), Oracle Integration Cloud (OIC), APIs, Data Migration Tools (FBDI, ADFdi, LDT, HCM Extracts)

Reporting & Analytics: Oracle OTBI, Oracle BI Publisher, Discoverer, Tableau, Power BI, Advanced Excel (Pivot Tables, Macros, VLOOKUP, Data Analysis)

Project & Methodology: Agile (Scrum/Kanban), Waterfall, SDLC, Business Requirement Analysis, Change Management, End-to-End Implementation, Support & Production Rollouts, Jira, Confluence, SharePoint, Slack, Teams

WORK EXPERIENCE

PwC, Florida Jan 2024 – Present

Oracle Functional Consultant

• Collaborated with 5 business units to document As-Is and To-Be processes for Finance and Procurement using MS Visio and Confluence, performing GAP analysis to streamline workflows, reducing manual steps by 30%.

• Designed and configured GL, AP, AR, FA, PO, iProcurement modules, including multi-level approval hierarchies, chart of accounts, and asset lifecycle setup, ensuring compliance with internal controls and reducing post-implementation exceptions by 20%.

• Drafted functional design documentation (FDD) and prepared detailed UAT and SIT test scripts, validating workflows across Finance and Procurement processes and supporting smooth end-to-end testing cycles.

• Migrated 500K+ historical financial and procurement transactions from legacy ERP to Oracle Cloud using FBDI, ADFdi, and LDT tools, achieving 99% data accuracy across GL, AP, AR, and fixed asset records.

• Implemented integrations between Oracle Cloud ERP and legacy systems using Oracle Integration Cloud (OIC) and REST/SOAP APIs, enabling automated data synchronization and improving reporting accuracy by 25%.

• Developed OTBI and BI Publisher dashboards for finance and procurement, providing real-time insights into KPIs, accelerating month-end close by 20%, and supporting strategic decision-making.

• Configured sandbox customizations and used Page Composer to enhance user interface layouts, streamline approval forms, and optimize transaction flows in Oracle Cloud ERP.

• Implemented and tested Oracle Redwood pages, including Finance and Procurement landing pages, to provide an intuitive, modern user experience for end-users.

• Executed 200+ UAT scenarios using Jira for test management, validating functional workflows, and ensuring end-to- end accuracy, which reduced post-go-live support issues by 25%.

• Conducted training sessions for 30+ finance and procurement users, prepared process documentation in Confluence, improving adoption and reducing dependency on support teams by 30%.

• Managed cross-functional collaboration using Agile methodology, Jira, and Slack, ensuring timely delivery of milestones and achieving a 6-month accelerated ERP rollout without compromising operational continuity. Deloitte, India Jul 2020 – Dec 2022

Oracle EBS/Cloud Functional Consultant

• Conducted workshops with finance, treasury, and procurement teams across multiple regions to gather requirements for Oracle Cloud Financials (GL, AP, AR, FA, Cash Management), mapping P2P, O2C, and R2R cycles and identifying key process gaps.

• Designed and configured multi-ledger and multi-currency structures for 10+ entities, implementing intercompany accounting rules, currency revaluation, and Subledger Accounting (SLA) rules, ensuring accurate financial reporting and compliance.

• Managed migration of 2 million+ legacy transactions using FBDI, ADFdi, and HCM Extracts, validating data with SQL/PLSQL scripts, achieving 99.5% data accuracy across GL, AP, AR, and fixed asset records.

• Configured GL, AP, AR, FA, and Cash Management modules, automating recurring journals, intercompany settlements, and bank reconciliations, including 2-way and 3-way invoice matching in Procure-to-Pay to optimize validations and reduce month-end close cycles.

• Developed 50+ OTBI and BI Publisher reports, including AP aging, AR collections, and GL variance, integrating Excel analytics to enhance visibility across R2R, O2C, and P2P processes and reduce manual reporting.

• Implemented AP and AR approval workflows, automating 10,000+ monthly transactions and enforcing SLA rules to strengthen compliance and audit readiness.

• Led UAT across six regions, preparing 200+ test scripts, resolving issues, and conducting 30+ end-user sessions, ensuring smooth adoption of P2P, O2C, and R2R cycles.

• Coordinated integration between Oracle Cloud Financials, Risk Management Cloud, and HCM Cloud using Oracle Integration Cloud, enabling seamless end-to-end process execution and post-go-live support for 100+ transactions.

• Conducted process optimization sessions with business teams to standardize P2P, O2C, and R2R workflows across regions, reducing manual intervention and improving process efficiency.

• Provided training materials, process guides, and documentation in Confluence, enabling consistent knowledge transfer, improving user adoption, and reducing dependency on support teams by 30%. EDUCATION

Master of Science in Computer Information System - Rivier University, Nashua, New Hampshire, USA.

Contact this candidate