Oracle Fusion & EPM Developer with 5+ Years Experience

SAI KOLLI

+1-414-***-****,MEMPHIS TN, **************@*****.***

SUMMARY

Oracle Fusion & EPM Developer with 5 years of experience in Oracle Fusion Cloud, Oracle Integration Cloud (OIC), and enterprise reporting solutions. Skilled in designing and developing BI Publisher reports, OTBI dashboards, PL/SQL-based data models, and ERP integrations across Finance and Supply Chain domains. Strong experience in SQL, data modeling, ETL processes, and performance tuning. Hands-on exposure to Oracle EPM-style reporting, analytics, and financial data structures with ability to support budgeting, forecasting, and enterprise reporting needs.

SKILLS

ERP Technologies: Oracle EBS R12, Oracle Fusion Cloud, Oracle APEX, OIC, VBCS, SOA Suite

Programming: PL/SQL, SQL, Java, Shell Scripting, TOAD/SQL, TOAD/JDeveloper/SQL

Integration Tools: REST APIs, SOAP, OIC, FBDI, HDL, HCM Extracts, BI Publisher, XML Publisher,JSON,SOA SUITE

Reporting: BI Publisher, OTBI, OBIEE, Oracle Reports, Tableau, Power BI

Database: Oracle 11g/12c/19c, SQL Loader, AWR, ADDM

Development Tools: Oracle Forms, Reports, JDeveloper (OAF), Git, SVN

Cloud and Other: Oracle SaaS, Oracle PaaS, Oracle Cloud Infrastructure (OCI), AWS (basic), WinSCP, Role-Based Access Control, SOX Compliance

Security & Compliance: RBAC, SOX, SECURE DATA HANDLING

Tools: Git, SVN, JDeveloper, APEX

Database Development: PL/SQL Packages, Procedures, Functions, Query Optimization, Performance Tuning, Data Modeling & Schema Design, Tablespace Management, AWR, ADDM, SQL Trace

ETL & Data Integration: Data Migration (FBDI, HDL), ETL Pipelines (Batch & Real-time),Oracle to External System Integration

Reporting Tools:

Oracle EPM Cloud (Planning – exposure, FCCS – reporting concepts),Essbase (ASO/BSO cube concepts – theoretical + reporting exposure),Smart View (Excel-based reporting – exposure),BI Publisher (Advanced report development),OTBI (Oracle Transactional Business Intelligence),Financial Reporting (Management Reports, KPI Dashboards),Data Integration (FBDI, HDL, OIC-based ETL),Metadata & Data Modeling (Oracle Fusion / reporting structures),SQL for Financial Reporting & Analysis Budgeting & Forecasting Data Structures (supporting role)

WORK EXPERIENCE

Oracle Fusion Reporting & Integration Developer AUG 2024 – Present ARIZONA DEPARTMENT OF WATER RESOURCES Remote

•Designed enterprise integration architectures using OIC, REST, and SOAP APIs to connect Oracle Fusion with external systems.

•Leveraged OCI, JSON/XML, and middleware orchestration to enable scalable and secure data exchange.

•Developed real-time and batch integrations using Oracle Integration Cloud and RESTful services for ERP data flows.

•Utilized PL/SQL, ATP DB, and API gateways to ensure high availability and performance.

•Built API-driven data pipelines supporting finance and supply chain modules across cloud platforms.

•Applied data transformation using XSLT, JSON parsing, and secure transmission protocols.

•Created OTBI dashboards and BI Publisher reports to monitor KPIs and operational performance.

•Used TOAD /SQL, data modeling, and analytics tools like Power BI for visualization.

•Implemented RBAC security and access controls for enterprise integrations and reporting systems.

•Ensured compliance using SOX standards, secure authentication, and audit logging.Integrated cloud services using OCI and AWS components for hybrid system architecture.

•Applied cloud networking, IAM roles, and API integrations for secure communication.

•Automated workflows using Power Automate and scheduling tools for business process efficiency. Reduced manual effort by integrating event-driven triggers and workflow orchestration.

•Collaborated with stakeholders to gather requirements and design scalable integration solutions.

•Used Agile methodology, Jira, and documentation tools for project tracking.

•Led UAT testing, deployment, and release management for enterprise integration projects.

•Ensured smooth rollout using CI/CD practices and version control tools like Git.

•Optimized PL/SQL queries and integration logic to improve performance and reduce latency.

•Utilized Oracle performance tuning tools like AWR and SQL Trace. Monitored and resolved production issues in real-time integration environments.

•Used logging frameworks, alerting tools, and debugging techniques.

•Documented technical architecture, workflows, and API specifications for enterprise systems.

•Explored AI integrations using REST APIs to enhance automation and decision-making processes.

•Evaluated AI services, API endpoints, and workflow integration patterns.

•Developed and optimized PL/SQL packages, procedures, and functions for enterprise data processing.

•Designed and maintained Oracle database objects (tables, views, indexes).

•Built and supported ETL pipelines for data movement between Oracle and external systems.

•Performed query tuning and performance optimization using AWR, execution plans, and indexing strategies.

•Supported data integration between Oracle, APIs, and external databases (SQL Server).

•Supported database backup, recovery, and security practices .

•Assisted in database deployments, migrations, and upgrades.

•Monitored database performance, availability, and integrity.

•Designed and developed complex BI Publisher reports and OTBI dashboards for Oracle Fusion Cloud modules (Finance & Supply Chain).

•Experience working with Oracle Fusion Cloud reporting data models for Finance, SCM, and ERP analytics.

•Worked with financial reporting data models aligned with Oracle Fusion EPM structures (Finance & SCM analytics)

•Developed management-style reports and dashboards supporting budgeting and operational reporting requirements

•Designed data transformation layers similar to EPM data integration workflows using SQL and PL/SQL

•Supported forecasting and KPI reporting datasets used by finance stakeholders

•Applied data validation and reconciliation techniques similar to EPM data load processes

•Built reusable reporting frameworks supporting enterprise financial analytics and decision-making

•Participated in requirements gathering for finance and operational reporting similar to EPM Planning use cases

Oracle Database Developer JUN2020 – May 2022 Accenture Solutions Pvt Ltd Hyderabad, India

•Developed 10+ Oracle Integration Cloud (OIC) orchestrations integrating Fusion Financials, SCM, and third-party apps.

•Developed OIC integrations connecting ERP modules with external applications using REST/SOAP APIs.

•Utilized middleware orchestration, JSON/XML processing, and cloud adapters.

•Designed and implemented APIs for enterprise data exchange and system interoperability.

•Applied API lifecycle management, authentication, and versioning strategies.

•Implemented FBDI and HDL processes for large-scale data migration and transformation.

•Used SQL, file-based loaders, and data validation techniques.

•Built BI Publisher reports and OTBI dashboards for financial and operational reporting.

•Leveraged SQL queries, data modeling, and visualization tools.

•Managed end-to-end SDLC including requirement gathering, development, testing, and deployment.

•Followed Agile practices and used tools like Jira and Git.

•Tuned PL/SQL queries and optimized integration workflows for improved system performance.

•Used Oracle tuning tools and indexing strategies.

•Integrated cloud and on-premise systems using Oracle middleware and APIs.

•Built BI Publisher and OTBI reports for financial and operational analytics.

•Worked with Oracle EBS/Fusion reporting structures and datasets .

•Developed SQL-based reporting logic for business KPIs.

•Ensured seamless communication using secureprotocols and adapters.Automated workflows and scheduling

Processes streamline business operations.

•Used cron jobs, OIC scheduling, and automation tools.

•Developed financial reporting solutions aligned with Oracle EPM reporting structures

•Worked on data mapping and transformation supporting budgeting and operational analytics

•Built BI Publisher reports for financial consolidation and KPI tracking

•Supported data integration workflows similar to EPM data load and validation processes

•Implemented SQL-based financial data models supporting reporting and analytics layers

•Worked with Fusion Finance & SCM datasets used for enterprise performance reporting

•Applied RBAC, encryption, and audit logging practices.Developed reusable integration components and templates for delivery.

•Promoted modular design and code reusability.Conducted testing, debugging, and validation of enterprise applications.

•Used unit testing frameworks and QA processes.

•Created technical documentation for APIs, workflows, and integration processes.

•Maintained version-controlled documentation repositories.

•Assisted in AI and automation proof-of-concept implementations using APIs.

•Explored integration of intelligent services with enterprise workflows.

Electronics Corporation of India (ECIL) Hyderabad, India

Oracle Database Developer (EBS) May2019 – May 2020

•Developed and customized Oracle EBS modules (Financials) to meet client requirements using PL/SQL, Forms, and Reports.

•Developed custom Oracle EBS modules using PL/SQL, Forms, and Reports to meet complex business requirements.Implemented business logic through packages, triggers, and procedures ensuring system efficiency.

•Utilized Oracle 11g/12c features and debugging tools to enhance application stability and performance.Designed database objects including tables, views, and stored procedures for enterprise applications.

•Applied performance tuning techniques such as indexing, query optimization, and execution plan analysis. Leveraged SQL and PL/SQL to ensure efficient data processing and integrity. Built integrations using XML, JSON, and REST APIs to connect Oracle EBS with external systems.

•Performed data transformation and validation using structured formats and middleware concepts. Ensured secure and reliable data exchange using API protocols and error handling mechanisms.

•Created Oracle Reports and BI Publisher reports to support operational and analytical needs. Developed complex SQL queries and data models for accurate reporting outputs.

•Enabled business decision-making using reporting tools and visualization techniques. Automated business processes using concurrent programs and workflow configurations.

•Scheduled batch jobs and implemented process automation to reduce manual effort. Improved system efficiency using Oracle Workflow Builder and PL/SQL-based automation.

•Performed system performance tuning and query optimization for large datasets. Used AWR reports, SQL Trace, and indexing strategies to improve execution time.

•Enhanced database performance and reduced system latency. Conducted unit and integration testing to ensure application reliability and accuracy.

•Developed test cases and validation scenarios aligned with business requirements. Ensured defect-free deployment through structured QA processes.

•Resolved production issues and system defects in Oracle EBS applications. Applied debugging techniques, log analysis, and root cause analysis for quick resolution.

•Maintained system uptime and stability in critical production environments. Implemented data validation and error-handling mechanisms in integration workflows.

•Ensured data consistency and integrity across multiple systems. Applied exception handling and logging strategies for reliability.

•Developed approval workflows and automated business processes using Oracle tools.Integrated workflow logic with PL/SQL and application modules.

•Streamlined approval cycles and reduced processing time.

•Migrated legacy Oracle Forms applications to Oracle APEX for modern UI development.Built responsive web applications integrated with REST APIs.

•Maintained technical documentation for system processes, integrations, and workflows.

•Used documentation tools and version control systems for knowledge sharing.Supported long-term maintenance and onboarding of new team members.

•Supported system upgrades, patches, and enhancements for Oracle EBS environments.Conducted impact analysis and regression testing for system changes.

•Ensured minimal downtime and seamless transitions during upgrades.Ensured compliance with enterprise security and data governance standards.

•Implemented RBAC, secure coding practices, and audit controls.Maintained data confidentiality and regulatory compliance across systems.

EDUCATION

The University of Memphis, Memphis, TN Master of Science in Data Science GPA: 3.65 / 4

Jawaharlal Nehru Technological University Hyderabad, Hyderabad, India Bachelor of Technology in Computer Science GPA: 3.36 / 4

Contact this candidate