Bala Veera Ravisankar Yanamadala

[email protected] • 919676470207

LinkedIn: https://www.linkedin.com/in/ravisankarelt/

PROFESSIONAL SUMMARY

Dynamic Oracle Cloud & Data Integration Consultant with over 14 years of IT experience, including 10+ years specializing in ETL and Data Warehousing. Proven track record of enhancing data integration performance by 30% and successfully leading cloud migration projects that improved reporting efficiency by 25%. Expertise in Oracle SQL, PL/SQL, and Snowflake, complemented by 4+ years of hands-on experience with Oracle Fusion Cloud Applications. Recognized for building scalable data pipelines and delivering impactful analytics solutions across diverse industries such as pharma, retail, and banking. A collaborative problem-solver committed to driving end-to-end project success in global settings.

WORK EXPERIENCE

Manager - Projects

06/2023 - Present

Cognizant

• 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

Manager - Projects

06/2023 - Present

Cognizant

• Responsible for security provisioning using shared services across the entire Hyperion environment

• Knowledge and experience in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications

• Key involvement in editing Calc Scripts, developing MaxL scripts for automation

• Worked extensively on data loads, load rules, Calc scripts and UDAs

• Involved in preparing Unit and integration test cases and technical standards, Quality testing, performance tuning, data conversion

• Created ODI jobs for loading data from .csv to Hyperion tables and reports as per client requirement

Manager - Projects

06/2023 - Present

Cognizant

• Built complete metadata-driven ETL flow from RAVE EDC → DMW

• Automated generation of study metadata files (study, forms, items, measurements)

• Packaged metadata ZIPs and delivered via SFTP with ODI-controlled processes

• Executed LSH utilities for automated model install and update in DMW

• Designed ETL to load CTMS, CDA, EDC, and IRT into replication staging

• Maintained versioned datasets in replication target layer

• Loaded curated datasets into CDA Warehouse final tables

• Established complete auditing, version control, and ETL recovery mechanisms

Manager - Projects

06/2023 - Present

Cognizant

• Led complete ODI 10g → 12c upgrade, resolving design-time and runtime issues

• Developed ODI load plans, KM customizations (LKM/IKM), packages, and scenarios

• Built multi-layer ETL pipelines: Source → Staging → Dimensions → Facts → Target

• Designed DB Links, PL/SQL packages, and optimized cross-schema data transfers

• Coordinated requirement analysis, design walkthroughs, SIT/UAT, deployments

Principal Consultant

02/2022 - 03/2023

CES Global IT Solutions Pvt ltd

• 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

10/2021 - 01/2022

Capgemini

• 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

Lead Consultant

10/2021 - 01/2022

Capgemini

• Delivered a BI modernization program leveraging BICC to extract Oracle Fusion Cloud data into OCI Object Storage, processed via ODI 12c, and integrated into 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

Senior Software Engineer

02/2021 - 10/2021

Birlasoft

• 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

04/2019 - 02/2020

Conduent Business Services India LLP

• 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

07/2018 - 02/2019

Franklin Templeton Investments

• 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. Very much involved in understanding the source system and target systems

ODI Developer

09/2017 - 05/2018

Dell International India

• 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

01/2011 - 09/2017

Refer2win Consulting Pvt ltd

• 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

Software Engineer

01/2011 - 09/2017

Refer2win Consulting Pvt ltd

• Worked with Partition components like partition by range, Partition by Round Robin, partition by Expression efficient use of Multi file system, which comes under Data Parallelism

• Performing transformations of source data with Transform components like De-normalize, Redefines, Reformat, Filter-by-Expression, and Rollup etc.

• Used Lookups with Reformat component to fetch matching records based on for the downstream process

• Used Rollup component to populate monthly, quarterly and annual summary tables

• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose

• Worked with DE partition components Gather, Merge which will be used for adding the files which is done partition for fast process of data files

• Unit testing of New and existing Graphs

EDUCATION

Master of Computer Applications (MCA)

Osmania University , India

Bachelor’s in mathematics BSc (Maths)

Andhra University , India

SKILLS

CERTIFICATIONS

Oracle Cloud Infrastructure – Application Integration Professional

01/2023

Snowflake Pro Certification

01/2022

ADF Internal Technical Training