Summary
Overview
Work History
Education
Skills
Certification
Area Of Expertise
Work Availability
Work Preference
Languages
Software
Timeline
Generic

Tirupathiraju Ottukulla

Sr ODI consultant
Hyderabad

Summary

I have 9+ years of experience as an Oracle Data Integrator and you likely have a deep understanding of ETL processes, data migration, and integrating data from various sources into databases.

Experienced with coordinating cross-functional teams to achieve project milestones efficiently. Utilizes critical thinking and strategic planning to drive project success. Track record of enhancing team productivity and meeting project goals within set timelines.

Overview

10
10
years of professional experience
2010
2010
years of post-secondary education
2
2
Certifications

Work History

Project - CSI - Prince George's County Public Schools

PGCPS
05.2024 - Current
  • Company Overview: Prince George's County Public Schools (PGCPS), one of the nation's 25 largest school districts, has 208 schools and centers, more than 130,000 students and nearly 19,000 employees
  • CSI stands for Critical Success Indicators
  • These are key metrics used to measure and track the progress of the district's schools in various critical areas, especially related to student achievement and overall school performance
  • CSI provides a framework for assessing the effectiveness of schools and their programs
  • Prince George's County Public Schools (PGCPS), one of the nation's 25 largest school districts, has 208 schools and centers, more than 130,000 students and nearly 19,000 employees

Sr ODI Consultant – Technology

Cotelligent India Pvt Ltd
09.2019 - 02.2025
  • Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
  • Managed client relationships through regular check-ins and updates on project progress.
  • Evaluated client needs and expectations, establishing clear goals for each consulting engagement.
  • Designed tailored training programs for employees at various levels within the organization, boosting overall skillsets.

Project - PGCPS HCMDS

PGCPS
09.2019 - 04.2024
  • Company Overview: Prince George's County Public Schools (PGCPS), one of the nation's 25 largest school districts, has 208 schools and centers, more than 130,000 students and nearly 19,000 employees
  • Involved in Extraction, Transformation, loading data to warehouse using ODI
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components
  • Creating the Technical design documentation for ETL
  • Involving in Data modelling and Preparing the Technical documents
  • Extracted data from different source systems like oracle, Microsoft Sql server and flat files implemented Business logic and loaded into target warehouse (Oracle)
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences and Procedures in ODI
  • Working knowledge of Knowledge Modules (LKM, IKM, RKM and CKM)
  • Creating Mappings to load data from source to target and maintained current and historical data on year wise in all dimensions
  • Worked on performance tuning of ODI And monitoring the ODI production Jobs
  • Migrating the code from a lower environment to a higher environment along with database objects
  • Implementing the daily target tables backup process in Oracle data integration
  • Implementing the email notifications process setup in ODI by using the ODI Tools
  • Scheduling the ODI jobs from Cronjob Shell script and performing the ODI admin Support activities
  • Prince George's County Public Schools (PGCPS), one of the nation's 25 largest school districts, has 208 schools and centers, more than 130,000 students and nearly 19,000 employees

Project - ETHIO-TELECOM-Data Warehouse

ETHIO-TELECOM
10.2017 - 09.2019
  • Company Overview: Ethio telecom, previously known as the Ethiopian Telecommunications Corporation (ETC), is an integrated telecommunications services provider in Ethiopia, providing internet and telephone services
  • Involved in Extraction, Transformation, loading data to warehouse using ODI
  • My 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, and developing ETL
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components
  • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database
  • Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
  • Extracted data from different source systems like oracle, Microsoft Sql server and flat files implemented Business logic and loaded into target warehouse (Oracle)
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences and Procedures in ODI
  • Working knowledge of Knowledge Modules (LKM, IKM, RKM and CKM)
  • Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintained current and historical data on year wise in all dimensions
  • Developed packages for ordered execution of interfaces
  • Worked on performance tuning of ODI
  • Experience in configuring ODI Agent on and creating new agents and testing them in ODI
  • Ethio telecom, previously known as the Ethiopian Telecommunications Corporation (ETC), is an integrated telecommunications services provider in Ethiopia, providing internet and telephone services

ODI Developer

Techno Brain India Pvt Ltd
04.2015 - 09.2019

Project - TRA-EDWH

TRA (TANZANIA)
09.2015 - 08.2017
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
  • Extracted data from different source systems Sql server and flat files implemented Business logic and loaded into target warehouse (Oracle)
  • Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load into Oracle data warehouse
  • Worked in Interface creation, Packages, Scenarios, Variables, Sequences and Procedures in ODI
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, and integrating it
  • Working with knowledge of Knowledge Modules (LKM, IKM, RKM and CKM)
  • Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintain current and historical
  • Developed packages for ordered execution of interfaces
  • Monitoring the Execution Logs in operator navigator
  • Loading metadata data from flat file source system into RDBMS target system
  • Create the Scenario’s and Test the Development Server with sample data
  • Involved in data vault model, to find out the relationships of tables, and to create the log in users for developers

Project - ODI Support

TRA Motor vehicle Registration Services
04.2015 - 08.2015
  • Executing Load plans and fixing the bugs
  • Creating load plans as per client requirement
  • Starting standalone agent and stopping it
  • Re-scheduling Jobs and removing schedule jobs as per client requirement
  • Created Mappings and used Projector and selector components (POC)
  • Worked with backend tables of repositories to monitor the ODI jobs
  • Created Scenario which waits for file to arrive in ODI

Education

B. Tech -

S.V.I.T

P.G - undefined

Malla Reddy Institute of Technology

Skills

Oracle data integrator

Certification

1Z0-448 - Oracle Data Integrator 12c Essentials

Area Of Expertise

  • 9+ years of experience in the IT industry on Data warehousing using Oracle data integrator, Oracle SQL, PLSql and Linux.
  • Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse Environment.
  • Worked with multiple sources such as Relational database, Oracle, Mysql, Excel, XML, CSV, Flat files for Extraction Transformations and Loading data into target Schema.
  • Creating Variables, Sequences, User functions, Scenarios, Procedures, Interfaces and Packages in ODI.
  • Having good experience in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, and Dimensions and facts identification.
  • Used Topology Manager to define data servers and physical schemas for various sources and target databases.
  • Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
  • Having knowledge of working with Excel, Flat file and oracle as source.
  • Debugged the Mappings, Scenarios, Package and Procedure by setting Breakpoints to change the variables values.
  • Used various ODI tools like File Copy, Move, File wait, And Created load plans parallel and serial jobs in execution environment.
  • Good experience on Deploying Scenarios from one environment to another environment.
  • Having good experience on Upgrading from ODI 11g to ODI 12c environment.
  • Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
  • Sound knowledge on Standalone agent and Java-EE agent creation and configuration.
  • Strong knowledge of ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment.
  • Creating tables, taking backups, writing stored procedures, triggers, packages and views for the front-end grid display.
  • Handling and managing both the development and live databases and fixing defects in backend.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full TimeContract Work

Work Location

HybridRemoteOn-Site

Important To Me

Career advancementWork-life balanceCompany CultureFlexible work hoursHealthcare benefits

Languages

English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Telugu
Bilingual or Proficient (C2)

Software

ETL & Data Integration: Oracle Data Integrator (ODI) 12c, 11g, 10g SQL & PL/SQL (Stored Procedures, Triggers, Packages, Views, Query Optimization) Databases: Oracle 19c, 11g MySQL SQL Server Data Warehousing & BI: Dimensional Modeling (Star & Snowflake Schema) Data Extraction, Transformation, and Loading (ETL) MicroStrategy (Reporting) OBIEE & Power BI (Basic Knowledge) Scripting & OS: Linux & Shell Scripting Windows Server ODI Administration & Deployment: ODI Agent Configuration (Standalone & Java EE) ODI Repository Setup (Master & Work Repository) Scenario Deployment & Version Control Other Tools & Technologies: SQL Developer, Toad (Database Management) UI Path (Basic Knowledge)

Timeline

Project - CSI - Prince George's County Public Schools

PGCPS
05.2024 - Current

Sr ODI Consultant – Technology

Cotelligent India Pvt Ltd
09.2019 - 02.2025

Project - PGCPS HCMDS

PGCPS
09.2019 - 04.2024

Project - ETHIO-TELECOM-Data Warehouse

ETHIO-TELECOM
10.2017 - 09.2019

Project - TRA-EDWH

TRA (TANZANIA)
09.2015 - 08.2017

ODI Developer

Techno Brain India Pvt Ltd
04.2015 - 09.2019

Project - ODI Support

TRA Motor vehicle Registration Services
04.2015 - 08.2015

P.G - undefined

Malla Reddy Institute of Technology

B. Tech -

S.V.I.T

Similar Profiles

CREATE PROFILE
Tirupathiraju OttukullaSr ODI consultant