Arbin Sree

Oracle Integration Cloud Developer

Cognizant Technology Solution

Bangalore

09.2022 - Current

Designed and implemented end-to-end integration solutions using Oracle Integration Cloud (OIC) for multiple inbound/outbound integrations for both SaaS and PaaS applications to connect diverse applications and systems
Developed and maintained integration interfaces, leveraging adapters and connectors, such as REST, SOAP, ERP Cloud, Oracle EBS, ATP, File, and FTP, to facilitate data exchange between on-premises and cloud applications
Collaborated with business stakeholders to gather integration requirements, analyze legacy system data, and create mappings and specifications
This ensured alignment with organizational goals and seamless data flow across multiple systems and processes
Automated OIC support team's ticket resolution procedure with machine learning model using Python, OIC, and process automation to handle recurring Service Now incidents based on historical tickets and logs
Developed end-to-end outbound integration that will trigger the HCM extracts (hosted in the Oracle Fusion application) using SOAP calls, after which the HCM job will extract the payroll data, create a file, and place it in the SFTP location
OIC will check for the HCM extraction job status using a soup call once the job is successful
It will list the extracted file from SFTP and push it to the target system by encrypting it
Developed end-to-end inbound integration where we will get the encrypted payroll file from an external vendor in a CSV format, decrypt the file, and load the data to the stage table (ATP Database) after we push it to the main table
The pushed data will be validated, and then we will call the BIP report for each record using the Soup service, wherein the particular employee ID will pull some more data from HCM cloud and create a DAT file, after which the DAT file will be loaded into the object storage bucket using a rest API, for which we will pull a structured file from the object store and load it into HCM cloud using the Soup service
Once the file is loaded into the HCM cloud, we will generate a BI report by passing the required parameters that will show the total number of success and error records after HDL, which will be sent to the vendor via email notification for verification
Resolved Bulk data processing through ATP response using batch processing
Created integrations linked to audits that retrieve all integration and connection data upon refresh and store it on an SFTP server as a .csv file
Developed a downtime integration tool that can be used to submit ad-hoc requests with parameters, stop, start, and schedule when there is an application outage
Worked on the OIC Gen2 to Gen3 migration, where I modified the integration according to Gen3 requirements and closely worked with Oracle on different types of issues that came after the Gen3 migration and were resolved in its production
Provided technical guidance and mentoring to junior team members facilitating their understanding of OIC concept and best practices.

Similar Profiles