Rohan Raj

I bring 10.7 years of experience in the IT industry, specializing in ODI 12c/11g and BIAPPS. My background includes extensive work with OBIEE 11g and OAC reporting, FDI, supported by strong proficiency in SQL and PL/SQL. Additionally, I have hands-on experience with Snowflake, Shell Scripting, and foundational knowledge of Python

Senior Consultant - Deloitte

(2025-03)

Consultant - Accion Technologies PVT. LTD. (Contractor to Deloitte)

(2023-09 - 2025-03)

The Securitas has the onsite and mobile guarding services. LYFT is a car pooling service company.

• Fixed complex Production incidents and enhancements on GL, AP, AR, Finger2
• Gather requirement from business and created plsql complex procedure to calculate the idle time, inspection time, route profitability using the procedure. Finally merged the data into the main load plan and data set
• Performance optimization to reduce the execution time to less than 50% saving client more than 500 hours yearly
• Created BICC connection in ODI and object storage in OCI to pull data into ODI
• Resolved production issues for BICC jobs
• Analyzed the OAC reports to find issues and fix at the ETL and reporting side using the logs at the reporting side

Specialist data engineering - LTIMindtree

(2022-07 - 2023-09)

This Agile project maintains the fleet and the dealers of the client. Processing data for digital dealer and fleet care using ODI 12c. Also working as snowflake developer as a beginner.

• Gather requirement from business architect and develop the mappings
• Query optimization for better CPU utilization
• Performance optimization
• Production issues resolution and Load plan monitoring
• Also working on Snowflake and taking trainings on it
• Create and load tables, create integrations, stage, snowpipe, file format in snowflake

Associate - Cognizant Technologies Solutions

(2019-05 - 2021-02)

The scope of the project was that the source system was going through an upgrade so because of that the impact on Data mart had to be studied and changes had to be incorporated for all the mappings wherever required. Along with this there were new modules as part of new development activities requested by client.

• Design and develop ODI Mappings, Packages, Procedures, load plans as per the requirement
• Installing ODI 12C, configuring master and work Repositories
• Created shell scripts to move files from windows to AWS sftp
• Debugging all the issues and fixing them
• Involved in unit testing and integration testing
• Playing the role of individual contributor
• Interacting with other team members for understanding and gathering existing system behavior

Software Engineer - Accenture technology solutions ltd.

(2015-11 - 2019-05)

Bachelor of Technology - Electrical and Electronics Engineering - SMVIT, Bangalore