Summary
Overview
Work History
Education
Certification
Major Responsibilities
Timeline
Generic

Bala Veera Ravisankar Yanamadala

Hyderabad

Summary

Oracle Cloud & Data Integration Consultant with 14+ years of IT experience, including 10+ years working on ETL and Data Warehousing and 4+ years working with Oracle Fusion Cloud Applications and Reporting. Skilled in Oracle Fusion ERP/SCM/HCM, OIC integrations, BI Publisher/OTBI reports, ODI/OBIA ETL development, and Cloud data migration activities. Experienced in building scalable data pipelines, improving integration performance, and supporting large analytics and reporting projects across pharma, retail, insurance, banking, manufacturing, and gaming industries. Known for strong problem-solving skills, teamwork, and the ability to manage end-to-end delivery in global projects.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Manager - Projects

Cognizant
06.2023 - Current
  • Delivered a BI modernization program by extracting Oracle Fusion Cloud data via BICC into OCI Object Storage, orchestrating ETL pipelines through ODI 12c, and integrating processed data into the Enterprise Data Warehouse and OBIEE reporting layers.
  • Gathered BI requirements and designed BICC → OCI → ODI → DWH data flow architecture.
  • Configured BICC full/incremental extracts, filtering, partitioning, and scheduling via FSM.
  • Set up ODI Topology for OCI/SFTP integrations and created ETL mappings for CSV/XML Fusion extracts.
  • Customized LKM/IKM knowledge modules and built reusable mappings for staging and transformation.
  • Implemented data validations, reconciliation, error handling, and audit frameworks.
  • Improved ETL throughput via parallel load processing and JVM tuning.
  • Supported UAT, prepared technical documentation, and resolved extract/load failures.
  • Automated BICC → ODI data pipelines, minimizing manual effort and improving reliability.

Principal Consultant

CES Global IT Solutions Pvt ltd
02.2022 - 03.2023
  • Developed Custom ETL for Data Extraction, Data Mapping using In Oracle Data Integrator 12c.
  • Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
  • Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Essbase, Relational Database Management servers including Oracle RDBMS, SQL Server, and IBM DB2 and flat files including CSV, Excel, XML file formats.
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
  • Enhancing and Maintaining OOB and Custom reports for Oracle BI Apps (OBIA) - Financial Analytics, Project Analytics, HR Analytics, Procurement Analytics and Spent Analytics.
  • Good experience on Deploying Scenarios from one environment to another environment.
  • Experience working with Multiple Source/Target systems in ODI such as Oracle, DB2, JMS Queues, MS SQL Server, DBF Files, Complex Files, XML files, Flat files, MS access/excel documents.
  • Knowledge on creating ODI procedures to create and populate in target systems. Having idea about KM customization. Knowledge on Deployment from DEV to SIT to UAT and PROD.
  • Worked with Business Users to understand requirement and perform gap analysis before starting development.
  • Created technical documentation related to development work and submit it to Manager for approval.

Lead Consultant

Capgemini
10.2021 - 01.2022
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
  • Increased performance of loads by applying proper Hints, Indexes, and Analysing master tables and explain plans to check cost.
  • Having good experience on Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
  • Worked on slowly changing dimensions SCD, Change data capture CDC as part of data warehousing concepts.

Senior Software Engineer

Birlasoft
02.2021 - 10.2021
  • Involved in the Installation of ODI 11.1.1.7 and ODI 12C Up gradation. Used ODI 11.1.1.7 and ODI12c designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
  • Good working knowledge with ODI Operator for debugging and viewing the execution details of interfaces and packages, Created Interfaces to implement one time as well as Incremental loads.
  • Used Interface Variables, Interface Parameters and Session Parameters to increase the re-usability of the Interfaces.
  • Implemented performance tuning logic on targets, sources, interfaces, sessions to provide maximum efficiency and performance.
  • Developed load plans using Load Plan Generator and monitored the results using ODI Operator.
  • Good experience on Deploying Scenarios from one environment to another environment.

Senior Software Engineer

Conduent Business Services India LLP
04.2019 - 02.2020
  • Developing in Extraction, Loading, and Transformation data to warehouse using ODI.
  • Configuring in Topology, Operator, Master repository and work repository creation as per the client environment.
  • Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups, Aggregate, Expression, Split, Pivot and Unpivot etc.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (File, Oracle SQL Server and Excel files) in Topology.
  • Very much involved in understanding the source system and target systems.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.

Senior Software Engineer

Franklin Templeton Investments
07.2018 - 02.2019
  • Involved in Extraction, Loading, and Transformation data to warehouse using ODI.
  • Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
  • Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
  • Created multiple Interfaces for full load and incremental loads and executed them accordingly.

ODI Developer

Dell International India
09.2017 - 05.2018
  • Primary responsibility includes installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse.
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Extensively involved in production issues.
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.

Software Engineer

Refer2win Consulting Pvt ltd
01.2011 - 09.2017
  • Setting up Connection parameters in the topology Manager of ODI.
  • Creating several reverse engineering Models as per the requirements.
  • Developed several Interfaces as per the requirements.
  • Created and scheduled in ODI scenarios as per the requirements.
  • Created ELT workflows in the package by using ODI Tools.
  • Monitor interfaces and execution logs as per the requirements.
  • Created Knowledge Modules for extraction and loading the data from source to target database.
  • Scheduled scenarios and executed load plans to load data only in scheduled time.
  • Worked in SCD and CDC implementation and Used CDC features for Incremental data loads.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.

Education

Master of Computer Applications (MCA) -

Osmania University
India

Bachelor’s in mathematics BSc - Maths

Andhra University
India

Certification

  • Oracle Cloud Infrastructure – Application Integration Professional, 2023
  • Snowflake Pro Certification, 2022
  • ADF Internal Technical Training

Major Responsibilities

ERP, SCM, HCM, Order Management, Inventory, Procurement, Pricing, Projects, Subscription Billing, BI Publisher, OTBI, OBIEE 11g/12c, OBIA 11g, Power BI, OACS, OIC, REST/SOAP APIs, XSLT, UCM, FBDI, HDL, ADF, FDI, SOA Suite, VBCS, ODI 10g/11g/12c, OWB, Informatica, Ab-Initio, DIPC Marketplace, SQL, PL/SQL, Python, Shell Scripting, ADF, Java; Oracle, SQL Server, IBM DB2, Snowflake, Control-M, Cron, Zena, Git, SVN, TFS, CVS, JIRA, ServiceNow, HP Remedy, S-Max, MFT/SFTP, SCD, CDC, Star/Snowflake Schema, Fact/Dimension Modelling, Parallel ETL, Error-Handling Frameworks

Timeline

Manager - Projects

Cognizant
06.2023 - Current

Principal Consultant

CES Global IT Solutions Pvt ltd
02.2022 - 03.2023

Lead Consultant

Capgemini
10.2021 - 01.2022

Senior Software Engineer

Birlasoft
02.2021 - 10.2021

Senior Software Engineer

Conduent Business Services India LLP
04.2019 - 02.2020

Senior Software Engineer

Franklin Templeton Investments
07.2018 - 02.2019

ODI Developer

Dell International India
09.2017 - 05.2018

Software Engineer

Refer2win Consulting Pvt ltd
01.2011 - 09.2017

Master of Computer Applications (MCA) -

Osmania University

Bachelor’s in mathematics BSc - Maths

Andhra University

Similar Profiles

CREATE PROFILE
Bala Veera Ravisankar Yanamadala