2.8+ years of expertise in application development and implementing data integration solutions. Experience in Oracle ODI 12c and Proficient in data movement and transformation. Experience of having worked with ETL Tool ODI against different between various source and Target system (Oracle DB , DB2, Flat files , XML , EBS ,Sales force etc.) Troubleshooting ODI job failures. Extensive development experience in extraction, transformation and loading of data from multiple sources such as Retail POS system database, Core ODS database, Falt files , Workday , and XML files into multiple target system like Xstore, AWS DB, Rest API etc. Worked extensively with complex interfaces using ODI. Expertise in implementing complex business rules by creating ODI interfaces. Conducted performance tuning and optimization of ODI mapping and workflows to enhance overall system efficiency. Within single account worked on multiple Projects and got associated with discrete aspects of the life - cycle of the project from inception to completion. Along with ODI 12c have basic knowledge about SOA suite 12c and oracle MFT 12c,OCI. Team-oriented professional with strong Communication, Analytical and Problem-solving skills.
Chennai, India
Oracle Cloud Infrastructure 2023 Certified Application Integration Professional
ODI Developer
Selfridges:
Selfridges, 08/2021 - 10/2023, Selfridges is a chain of upscale department stores in the United Kingdom.Tools used in this project ODI 12C (PL/SQL), GIT, JIRA, Sharepoint. This Project is about ODI integration development for new till software. Inbound and outbound flow related to till application has been developed in ODI. Development includes the Integration like RMS, RPM (Flat file), Mission (Fixed length file), RJPOS (xml), EBS, Salesforce, Rest API call, etc., ODI 12c , PL/SQL, Unix, Understand design approach based on the mapping document which was signed off and start the build work based on the mapping sheet. Design the technical specification document for the developed code based on the mapping sheet. To mention the working nature of the code to larger audience. Understanding the existing code and added the additional functionality based on the requirements. Based on the Project requirements build various reusable components like common SFTP services which reduces the additional work for the future integrations using that target system as target. Involved extensively in the error handling for the integration to handle business scenarios for reprocessing. Extensive worked on XML based build which includes complex business logic and dynamic changing XML based on the Source system operations. Done the performance tuning and optimization of ODI code by index rebuilding and gather stats for the stg tables which drastically increased the ODI processing performance. Accountable for delivering complete integrations for Development, Test, and Production environments following clients process and prepare the support documents as mandated by the client. Responsible for providing proactive help to the support team and resolving issues.
7-Eleven Inc:
7-Eleven Inc, 10/2023 - Present, 7-Eleven, retailer that operates more than 60,000 convenience stores mostly in north America and asia. Tools used ODI 12C (PL/SQL),ODI 11g, GIT, JIRA, Sharepoint. This Project is about ODI integration support and enhancement for existing Inbound and outbound flow which has been developed in ODI. Support includes both monitoring and enhancement., ODI 12c ,ODI 11g, PL/SQL, Unix, Understand existing ODI code and do the monitoring for the ODI code which are running in production. Applying the DE fix and enhancement to the existing code which running in the production to reduce the performance and existing various errors. Understanding the existing code and added the additional functionality based on the requirements. Responsible for providing proactive help to the support team and resolving issues.