Senior Oracle Cloud PPM Consultant

Venkata Phani Sai Nukala

SENIOR ORACLE CONSULTANT

Email: ******************@*****.*** Phone: 913-***-****

PROFESSIONAL SUMMARY:

Over 10 years of extensive Oracle enterprise application experience encompassing Oracle Fusion Applications, Oracle ERP Cloud, enterprise integrations, business-process automation, Oracle Database, implementation, enhancement, and production-support initiatives.

Strong functional and techno-functional knowledge of Oracle Cloud Project Portfolio Management (PPM) covering Project Costing, Project Billing, Project Execution Management, Project Financials, Project Contracts, Resource Management, and Task Management.

Strong understanding of end-to-end Oracle Cloud PPM business processes spanning project creation, project planning, task structures, resource assignments, expenditure processing, costing, accounting, billing, revenue generation, invoicing, and project close.

Experience supporting Oracle Cloud implementation lifecycles from requirements gathering and discovery workshops through solution design, configuration, integration, testing, cutover, go-live, stabilization, and post-production support.

Strong knowledge of Oracle Project Costing including expenditure types, expenditure categories, transaction sources, project costs, cost distribution, burdening concepts, capitalization, cost adjustments, accounting, and project-cost reconciliation.

Strong understanding of Oracle Project Billing covering project contracts, contract lines, billing controls, bill plans, revenue plans, invoice generation, revenue recognition, billing events, adjustments, and integration with Accounts Receivable.

Functional knowledge of Project Execution Management including project plans, tasks, milestones, deliverables, progress tracking, project-team collaboration, project status, and execution monitoring.

Strong knowledge of Project Financial Management covering project budgets, forecasts, actual costs, commitments, revenue, billing, financial plans, project performance, and financial reporting.

Experienced in requirements-gathering workshops with project accounting, finance, billing, operations, project managers, business stakeholders, technical teams, integration resources, and enterprise architects.

Proven ability to perform fit-gap analysis and translate business requirements into Oracle Cloud PPM configurations, functional designs, process flows, integration requirements, reports, controls, and test scenarios.

Knowledge of Oracle Resource Management processes including resource pools, resource requests, project-resource assignments, utilization, availability, staffing, and resource planning.

Strong understanding of Task Management covering work plans, task hierarchies, task assignments, milestones, dependencies, progress updates, completion tracking, and project execution.

Experience supporting Time & Labor integration patterns for project-based time capture, employee time cards, project/task charging, expenditure creation, validation, costing, and downstream project accounting.

Understanding of Grant Management processes including sponsored projects, awards, funding sources, budgets, project costs, compliance, billing, reporting, and financial controls.

Strong integration expertise using Oracle Integration Cloud and REST APIs to connect Oracle ERP Cloud with enterprise applications, external systems, reporting platforms, and downstream business processes.

Experienced in developing functional design documents, configuration workbooks, business-process flows, integration specifications, test scenarios, UAT scripts, cutover plans, deployment documentation, and production-support procedures.

Strong testing experience covering configuration validation, functional testing, SIT, UAT, regression testing, end-to-end process validation, integration testing, defect management, and production-readiness assessments.

Experienced in go-live and post-production activities including cutover validation, configuration verification, integration monitoring, transaction reconciliation, defect resolution, user support, issue triage, and production stabilization.

Strong Agile/Scrum and Waterfall delivery experience collaborating with functional, technical, integration, QA, finance, project management, infrastructure, and business teams across enterprise Oracle programs.

Strong analytical, communication, stakeholder-management, documentation, leadership, and problem-solving skills with ability to translate complex project-financial requirements into scalable Oracle Cloud solutions.

CORE SKILLS

Oracle Cloud PPM: Oracle Project Portfolio Management, Project Financial Management, Project Execution Management

Project Costing: Project Costs, Expenditure Types, Expenditure Categories, Transaction Sources, Cost Distribution, Cost Adjustments

Project Billing: Project Billing, Bill Plans, Revenue Plans, Billing Events, Invoice Generation, Revenue Generation

Project Contracts: Project Contracts, Contract Lines, Billing Controls, Contract Billing, Revenue Management

Project Financials: Budgets, Forecasts, Actual Costs, Commitments, Revenue, Billing, Project Performance

Project Execution: Project Plans, Tasks, Milestones, Deliverables, Progress Tracking, Project Status

Resource Management: Resource Pools, Resource Requests, Staffing, Assignments, Availability, Utilization

Task Management: Task Hierarchies, Task Assignments, Dependencies, Milestones, Progress Updates

Time & Labor: Project Time Capture, Time Cards, Project/Task Charging, Expenditure Integration

Grant Management: Awards, Sponsored Projects, Funding, Budgets, Costs, Billing, Compliance Concepts

Oracle ERP Cloud: Oracle Fusion ERP, Financials Integration, Accounts Receivable, General Ledger

Implementation: Requirements Gathering, Workshops, Fit-Gap Analysis, Solution Design, Configuration

Functional Design: FDDs, Configuration Workbooks, Process Flows, Functional Specifications, Integration Requirements

Integrations: Oracle Integration Cloud, REST APIs, Web Services, JSON, XML, Enterprise Interfaces

Data & Reporting: Project Data, Reconciliation, Operational Reporting, Financial Reporting, Data Validation

Testing: Functional Testing, SIT, UAT, Regression Testing, Integration Testing, E2E Testing

Deployment: Cutover Planning, Go-Live, Hypercare, Production Stabilization, Release Management

Production Support: Incident Management, RCA, Transaction Troubleshooting, Defect Resolution, Reconciliation

Technical: SQL, PL/SQL, Python, Oracle Database, SQL Developer, Postman

DevOps: Git, CI/CD, Version Control, Deployment Automation

Methodologies: Agile, Scrum, Waterfall, SDLC

Leadership: Workshop Facilitation, Stakeholder Management, Functional Leadership, Team Collaboration, Documentation

PROFESSIONAL EXPERIENCE

Client: UPS – Parsippany, NJ

Role: Senior Oracle Consultant

Duration: Jan 2024 – Present

Supported Oracle Fusion ERP transformation initiatives with focus on project-oriented business processes, enterprise integrations, financial transactions, automation, reporting, and scalable Oracle Cloud solution delivery.

Conducted requirements-gathering and discovery workshops with finance, project accounting, operations, business stakeholders, technical teams, integration resources, and enterprise architects to define future-state Oracle Cloud processes.

Supported Oracle Cloud PPM solution design across Project Costing, Project Billing, Project Execution Management, Project Financials, Project Contracts, Resource Management, and project-related integrations.

Defined Project Costing requirements covering project structures, expenditure classifications, transaction sources, project/task charging, cost processing, adjustments, accounting, and project-cost reconciliation.

Supported Project Billing design covering project contracts, contract lines, billing controls, bill plans, revenue plans, billing events, invoice processing, revenue generation, and Accounts Receivable integration.

Worked with project stakeholders to define Project Execution Management processes encompassing project plans, task hierarchies, milestones, deliverables, project status, progress tracking, and execution monitoring.

Supported Project Financial Management requirements involving budgets, forecasts, actual project costs, commitments, revenue, invoices, project profitability, and project financial-performance reporting.

Facilitated fit-gap analysis to compare business requirements against standard Oracle Cloud capabilities and identify configuration, integration, reporting, workflow, and controlled extension requirements.

Translated business requirements into functional design documents, configuration workbooks, process-flow diagrams, integration requirements, validation rules, test scenarios, and implementation deliverables.

Supported Resource Management requirements including resource requests, project-team assignments, availability, utilization, staffing processes, resource pools, and project-resource planning.

Defined Task Management requirements covering work breakdown structures, project tasks, task assignments, dependencies, milestones, progress updates, and project completion tracking.

Supported project Time & Labor integration requirements for employee time capture, project/task charging, time-card validation, expenditure creation, project costing, and downstream financial processing.

Collaborated with Oracle Financials teams to define project-accounting integration with General Ledger and Accounts Receivable, including accounting, invoice transfer, reconciliation, and financial controls.

Designed OIC and REST API integration requirements connecting Oracle Fusion applications with external project, financial, operational, reporting, and enterprise systems.

Supported configuration and functional validation by reviewing business rules, application behavior, project transaction processing, security dependencies, integration outcomes, and reporting requirements.

Led functional testing, SIT, UAT, regression, and end-to-end validation covering project creation, costing, billing, revenue, invoicing, project execution, integration, and accounting scenarios.

Coordinated defect management by analyzing functional issues, validating configuration, reviewing transaction data, collaborating with technical resources, retesting corrections, and tracking defects through closure.

Supported cutover and go-live activities covering configuration readiness, integration deployment, project-data validation, transaction reconciliation, production verification, rollback considerations, and business readiness.

Provided post-production support by troubleshooting project transactions, integrations, financial-processing exceptions, API failures, data discrepancies, and configuration-related issues.

Provided functional leadership across Oracle Cloud delivery by coordinating stakeholders, reviewing solution designs, supporting developers and testers, maintaining documentation, and driving production stabilization.

Client: Barclays – Whippany, NJ

Role: Senior Oracle Consultant

Duration: Jan 2022 – Dec 2023

Supported enterprise Oracle applications and project-financial processes through functional analysis, database development, transaction processing, integration, reporting, testing, and production support.

Collaborated with business analysts, finance stakeholders, application teams, and project resources to gather requirements and translate project-accounting needs into Oracle application and database solutions.

Supported project-cost-oriented processing by developing backend validation and transaction logic for cost transactions, financial data, accounting information, adjustments, and reconciliation.

Developed PL/SQL packages supporting business-rule validation, project/financial transaction processing, exception handling, data conversion, accounting data, and enterprise reporting.

Created SQL queries and reporting structures supporting project costs, budgets, financial transactions, accounting data, project performance, reconciliation, and operational analysis.

Supported project-billing-oriented data flows involving financial transactions, invoice information, customer/account data, accounting interfaces, validation, and downstream financial-system processing.

Worked with functional teams to translate project-financial requirements into data structures, validation rules, interfaces, scheduled processes, reporting solutions, and technical specifications.

Developed ETL processes supporting project and financial data extraction, transformation, validation, migration, synchronization, and reconciliation across Oracle environments.

Supported integration between project-oriented application data and enterprise financial systems through database interfaces, PL/SQL APIs, data exchange mechanisms, and downstream processing.

Developed scheduled Oracle jobs supporting recurring financial processing, data interfaces, reconciliation, reporting, batch processing, and operational automation.

Created data-validation routines comparing source and target transactions, project values, accounting information, processing statuses, and financial totals to identify discrepancies.

Supported functional and integration testing by preparing project-oriented test data, executing backend validations, analyzing transaction results, investigating defects, and supporting retesting.

Participated in SIT, UAT, regression, and release validation by collaborating with business users, QA teams, developers, DBAs, and functional consultants.

Performed performance tuning on high-volume project and financial transactions using SQL optimization, execution-plan analysis, indexing, partitioning, statistics, and database diagnostics.

Troubleshot production issues involving transaction failures, financial-data discrepancies, batch-processing errors, integration failures, database exceptions, and application-performance problems.

Supported migration and deployment activities including data conversion, schema changes, environment refresh, interface validation, release implementation, and post-deployment reconciliation.

Applied enterprise security controls to project and financial data through user privileges, role management, auditing, controlled database access, and secure enterprise connectivity.

Prepared functional/technical specifications, database designs, interface documents, test evidence, deployment instructions, reconciliation procedures, and production-support documentation.

Collaborated with functional, technical, QA, database, finance, infrastructure, and support teams throughout requirements, development, testing, deployment, and stabilization.

Provided senior techno-functional guidance on Oracle project-financial processing, PL/SQL solutions, integrations, data validation, testing, performance, and production issue resolution.

Client: Bharat Heavy Electricals Limited – New Delhi, India

Role: Oracle Consultant

Duration: Nov 2018 – Dec 2021

Supported enterprise Oracle environments hosting project-driven operational, financial, transactional, reporting, and integration workloads requiring high availability and reliable processing.

Worked with application and business teams to understand project-related transaction requirements, financial-data flows, reporting dependencies, database-processing needs, and operational support requirements.

Supported project-cost processing through SQL and PL/SQL routines used for transaction validation, financial calculations, cost-data reconciliation, reporting, and backend business logic.

Developed SQL-based validation and reconciliation processes for project-oriented financial transactions, accounting data, transaction statuses, source/target totals, and exception reporting.

Supported project-billing and financial-interface data by maintaining reliable backend processing, transaction integrity, scheduled jobs, database interfaces, and downstream system connectivity.

Assisted with project financial reporting by developing and optimizing SQL queries for transactional data, cost information, financial balances, project-related metrics, and operational analysis.

Supported project and task-oriented enterprise data structures through relational database objects, transaction tables, reference data, history, audit information, indexes, and partitions.

Developed scheduled database processes supporting project-data movement, financial processing, reporting, reconciliation, application interfaces, and recurring operational workloads.

Supported integration between Oracle databases and enterprise applications by maintaining connectivity, validating application/database interactions, and troubleshooting transaction-processing failures.

Performed SQL performance tuning using execution plans, AWR/ASH reports, optimizer statistics, indexing, partitioning, query optimization, and workload diagnostics.

Maintained high-availability Oracle RAC environments supporting business-critical project and financial application workloads with minimal service disruption.

Supported environment preparation for functional testing, integration testing, regression cycles, upgrades, releases, and project-related application enhancements.

Performed database cloning and environment refreshes across development, test, and staging environments to support project implementation and testing activities.

Supported data migration through RMAN, Data Pump, database comparison, transaction validation, source/target reconciliation, and post-migration verification.

Participated in release and cutover activities by performing technical readiness checks, database validation, deployment support, reconciliation, issue resolution, and post-release monitoring.

Investigated production incidents affecting financial transactions, application performance, data processing, connectivity, scheduled jobs, and project-related enterprise services.

Implemented security controls using TDE, auditing, password policies, privileged access management, and secure database connectivity to protect sensitive financial data.

Collaborated with functional teams, application developers, DBAs, infrastructure resources, QA teams, finance stakeholders, and business users to resolve project-system issues.

Prepared operational procedures, database documentation, reconciliation instructions, testing evidence, deployment guides, monitoring procedures, and production-support runbooks.

Provided advanced technical and application support for enterprise Oracle systems requiring transaction accuracy, financial integrity, performance, scalability, availability, and reliable project-oriented processing.

Client: Dalmia Bharat Group – New Delhi, India

Role: Oracle Analyst

Duration: Aug 2017 – Oct 2018

Supported Oracle application and database environments processing project-oriented transactions, financial information, operational data, reporting workloads, and scheduled business processes.

Assisted business and application teams with analysis of project-related data requirements, transaction flows, financial-processing issues, and backend application behavior.

Developed SQL and PL/SQL routines supporting project and financial data validation, transaction processing, reporting, reconciliation, and application troubleshooting.

Supported project-cost-oriented data by validating financial transactions, accounting attributes, processing statuses, project/task-related information, and backend processing results.

Created SQL queries to identify missing transactions, duplicate records, incorrect financial values, invalid statuses, processing exceptions, and source/target inconsistencies.

Assisted with financial-data reconciliation by comparing source information, database records, transaction totals, processing results, and downstream application data.

Supported scheduled database processes used for financial transaction processing, reporting, data movement, housekeeping, and enterprise application operations.

Monitored batch jobs and recurring processes, analyzed failures, coordinated reruns, validated corrected transactions, and documented operational recovery steps.

Supported integration testing by preparing test data, executing backend validations, comparing expected and actual outcomes, and assisting application teams with defect analysis.

Participated in UAT and regression support by validating database transactions, financial data, application results, and post-fix behavior for business scenarios.

Supported application deployments by performing database-object validation, executing controlled scripts, confirming configuration dependencies, and validating post-release processing.

Assisted with environment refresh and migration activities using Data Pump while validating project and financial data integrity after environment synchronization.

Performed SQL performance analysis using execution plans, database statistics, indexing, partition maintenance, session information, and system diagnostics.

Investigated application issues involving transaction failures, locking/blocking, long-running SQL, data inconsistencies, connectivity problems, and scheduled-processing errors.

Maintained Oracle Net Services configurations supporting secure and reliable connectivity between application servers, Oracle databases, and enterprise systems.

Supported security requirements through database privileges, access controls, auditing, secure connectivity, password management, and controlled production access.

Collaborated with senior consultants, developers, DBAs, QA resources, infrastructure engineers, finance teams, and business analysts during enhancements and issue resolution.

Prepared documentation covering database processes, financial-data validation, testing procedures, deployment steps, troubleshooting, monitoring, and production-support activities.

Supported post-release stabilization through transaction monitoring, database validation, defect investigation, data reconciliation, and coordination with application-support teams.

Built foundational experience in Oracle enterprise applications, project-oriented financial processing, requirements analysis, PL/SQL, integrations, testing, deployment, reconciliation, and production support.

Contact this candidate