Shireesha TR

Developed custom Data Migration Tool for enterprise clients transitioning from Oracle EBS to Oracle Fusion Cloud.

EBS to Fusion Data Migration Tool Project

• Part of the core team developing a custom Data Migration Tool for enterprise clients migrating from Oracle EBS to Oracle Fusion Cloud.
• Designed and developed extract packages for master and transactional data: Invoices, Suppliers, and Customers using PL/SQL.
• Built robust OIC integrations to handle Staging → Transformation → Loading of data into Fusion using REST adapters and Scheduler-based invocations to automate end-to-end data flows..
• Implemented inbound REST integrations with Oracle Fusion Applications, leveraging Fusion REST APIs and JSON payloads for seamless, incremental data imports.
• Designed and developed an interactive ETL Dashboard using Oracle VBCS, allowing end-users to easily run and monitor extract, transform, and load (ETL) processes, streamlining data migration operations.
• Created BIP reconciliation reports to validate migrated data and ensure consistency across source and target systems.
• Built a VBCS dashboard to track ETL progress, displaying the status of extracts, transformation, and load processes, along with detailed insights on success and error records for each phase.
• Optimized a time-consuming integration, reducing data load duration through efficient redesign and improved OIC implementation.
• Collaborated with functional teams and business users, providing ongoing support, error resolution, and training on tool usage.

Oracle Integration Cloud & Document Understanding

• Designed and built the integration SFTP to Oracle-Cloud GL-Interface pipeline using OIC, moving files from partner SFTP into OCI Object Storage, and orchestrating validation, mapping, and import steps integration flow.
• Developed and deployed the GL Import integration in OIC: automated FBDI file upload to Oracle Cloud ERP, invoked the “Import Journals” ESS job, and processed callback responses to update audit statuses and trigger notifications
• Built a Document Understanding integration that processes AR invoices by extracting header and line details and loading them into database tables for further processing.

Oracle Cloud Managed Services Support

• Handled support tickets and enhancements related to Oracle BI Publisher (BIP), including layout modifications, data model changes, and bursting configurations.
• Implemented enhancements to integrations as per changing business requirements, ensuring solution scalability.
• Diagnosed and resolved failures in Oracle Integration Cloud (OIC) integrations, ensuring seamless data flow.
• Interacted directly with clients to gather requirements, analyze issues, and deliver efficient technical solutions in a timely manner.
• Resolved OTBI reporting issues, improving report accuracy and delivery timelines.