Debasmita Das

Oracle Fusion Technical Consultant with 4 years of experience in Oracle Cloud ERP implementations, integrations, reporting, datamigration, and automation across HCM, Financials, and SCM modules. Experienced in Oracle Integration Cloud (OIC), HDL, HCM Extracts, BI Publisher, OTBI, REST/SOAP APIs, SQL, and PL/SQL. Skilled in end‑to‑end implementation lifecycle activities including development, testing, cutover, go‑live support, production support, and technical documentation for Oracle Fusion Cloud projects.

Oracle Technical Consultant - Ernst & Young - Hyderabad

(2025-06)

• Worked extensively on Oracle Fusion HCM modules, supporting integrations, data migration, reporting, and automation requirements.
• Prepared and processed HDL (HCM Data Loader) files for bulk data migration and business data updates across Oracle HCM Cloud.
• Developed SQL‑based automation solutions to dynamically generate HDL files and integrated the process with Payroll Flow for scheduled and automated execution.
• Designed and developed outbound integrations to securely transmit employee data files to third‑party systems after applying ETL and transformation logic.
• Implemented secure file transfer and encryption mechanisms to ensure compliance with enterprise security and audit requirements.
• Performed integration monitoring and troubleshooting using OIC activity streams, logging frameworks, and implemented retry mechanisms, and fault handling processes.
• Built and maintained HCM Extracts to retrieve and transform Oracle Fusion HCM data for downstream integrations and reporting requirements.
• Contributed to cutover planning and successfully supported go‑live activities for an audit and compliance project involving historical data purge for employees and contingent workers based on retention policies.
• Supported production environments by troubleshooting and resolving critical incidents, integration failures, and business process issues within defined SLAs.
• Developed custom Spreadsheet Loaders enabling business users to perform bulk uploads for Learning module data and mass assignment updates for workers.
• Assisted in development activities using Oracle Application Express (APEX) for a Leave Management System designed for contingent workers, enabling clients to efficiently track and manage leave records.
• Collaborated with functional consultants, business users, and cross‑functional teams during implementation, testing, deployment, and post‑production support activities.
• Participated in unit testing, SIT, UAT support, and technical documentation preparation for Oracle HCM Cloud implementations.
• Worked in Agile delivery environments with participation in sprint planning, defect tracking, and release activities.

Analyst - Deloitte - Hyderabad

(2022-08 - 2025-06)

• Experienced in OIC as a middleware platform for integrating Oracle Cloud applications.
• Designed and developed OIC solutions, implementing inbound and outbound integrations using REST API, SOAP services, FBDI, and file‑based methods for seamless data exchange.
• Developed and optimized PL/SQL packages across Financials, HCM, and SCM modules.
• Developed custom and customized seeded BI Publisher (BIP) reports using RTF, E‑Text, and Excel templates, enabling automated report generation and delivery via SFTP, printer, email.
• Developed ad‑hoc and scheduled reports using OTBI for financial analytics.
• Developed, optimized, and supported custom ESS jobs and jobsets to streamline and automate business processes.
• Extensive experience in drafting technical design documents (TDDs), defining integration strategies, and conducting unit testing for end‑to‑end Oracle Fusion Cloud implementations.
• Automated bulk data loads using SQL‑Loader scripts and configured email notifications for job status updates through Shell scripting.
• Implemented and consumed REST and SOAP web services, leveraging OIC's expression builder, XSLT transformations, and conditional logic to process and validate data dynamically.
• Familiar with Oracle Visual Builder Cloud Service (VBCS), with experience in minor UI customizations, page modifications, and Oracle Fusion application extensions.

Bachelor's in Computer Applications - Computer Applications - Institute of Engineering & Management (2019 - 2022) Kolkata