Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Ashok Kumar

Bangalore

Summary

Dynamic ODI Technical Architect with extensive experience at Capgemini, specializing in Oracle Data Integrator (ODI) and SQL. Proven track record in optimizing ETL processes and resolving complex data integration issues. Adept at collaborating with cross-functional teams, demonstrating strong problem-solving skills to enhance operational efficiency and drive successful project outcomes.

Overview

12
12
years of professional experience
1
1
Certification

Work History

ODI Technical Architect

Hexaware India Pvt.
Bangalore
09.2021 - Current
  • Company Overview: Hexaware is a global provider of IT, BPO, and consulting services.
  • Monitoring the ODI jobs and workflows to ensure timely execution and completion of load processes as per scheduled.
  • Responding to alerts, notifications and incidents related to ODI jobs errors and failures.
  • Proactively monitoring on long running session, taking the appropriate action, and involving DB team to kill these sessions.
  • Investigating and diagnosing data integration issues, identifying root causes, and implementing resolutions and fixing the issues.
  • Troubleshoot errors, analyze log files, and implement solutions to prevent reoccurrence.
  • Documenting production support processes, troubleshooting procedures, and resolutions for future reference.
  • Involved in ODI upgradation version from 12.2.1.3.2 to 12.2.1.4.0 version.
  • Collaborating with data architects and business analysts to understand business requirements and based on ETL mapping sheets provided by data analysist designing the ODI code solutions.
  • Experience and working on exception handling at load plan level.
  • Creating and maintaining ODI mappings, interfaces, packages, and procedures to extract, transform, and load (ETL) data.
  • Participating in all phases of code development, testing and production deployments.
  • Working knowledge on LKM,IKM,CKM and JKM knowledge modules.
  • Good hands-on experience in performance tuning at ODI and DB level.
  • Performing wellness checks on the Oracle Data Integrator (ODI) environment during the maintenance activity and patches essential to ensure its smooth operation and optimal performance.
  • Hexaware is a global provider of IT, BPO, and consulting services.

ODI Consultant

Capgemini Technology Services India Pvt Ltd.
Hyderabad
05.2019 - 09.2021
  • Company Overview: Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
  • Understanding functional document and design flow based on that I have prepared Technical Design Documentations.
  • Monitoring Full and incremental load from ODI Console and Operator.
  • Debug the sessions by utilizing ODI session logs & web services logs files to diagnostic infrastructure level issues.
  • Responsible in monitoring the jobs and providing immediate analysis on root cause of failures.
  • Coordinating with team members in business requirement Analysis, system analysis, and development of the application.
  • Running and monitor the load plan by using designer and operator.
  • Involved in export the generated scenarios and deploy the code in different Testing cycle repository.
  • Utilized the PL/SQL packages, procedures, triggers cursors and various database objects.
  • Experience on ODI Knowledge Modules like LKM, IKM and JKM, CKM.
  • Experienced in Working with Load Plans and Scenarios.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (XML, UCM, Hyperion Servers and Files) in Topology.
  • Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
  • Good Hands-on experience on creating ODI failures alerts mechanism.
  • Debug, troubleshoot, and resolve ODI-related issues and errors.
  • Provide documentation and training to users and team members as necessary.
  • Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.

Senior ODI Developer

Capgemini Technology Services India Pvt Ltd.
Hyderabad
10.2017 - 05.2019
  • Company Overview: Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
  • Involved in Extraction, Loading (Implement business logic) and Transformation of data into RMS application base Tables using ODI.
  • Modified and maintained rms, rpm application databases in order to accomplish the business requirement.
  • Developed and employed automation scripts.
  • Utilized the plsql packages, procedures, triggers cursors and various database objects.
  • Performed the analysis necessary to design and architect solutions that meet identified client requirements.
  • Development of integration which integrate with oracle soa for a near real time response.
  • Development of interfaces to read data from complex files such as , xml.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (XML, UCM, Hyperion Servers And Files) in Topology.
  • Good knowledge in creating File to Database, and Database to Database related interfaces.
  • Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
  • Experienced in Working with Load Plans and Scenarios.
  • Experience in implementing end to end flow which connects various sources and targets.
  • Experienced in Working with Exception Handling in load plans.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
  • Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.

Senior ODI Developer

Birlasoft India Pvt Ltd.
Hyderabad
10.2017 - 05.2019
  • Company Overview: Birlasoft is a global technology services company that provides IT services and solutions.
  • Involved in Extraction, Loading (Implement business logic) and Transformation data into EPMI Tables using ODI.
  • Modified and maintained Hyperion Essbase applications and databases to incorporate new business requirements.
  • Developed and employed calculation scripts.
  • Utilized Excel Spreadsheet Add-in and SQL server reporting tools to help meet the reporting needs of business and management.
  • Performed the analysis necessary to design and architect solutions that meet identified client requirements.
  • Create/Maintain/Administration Essbase, & Planning Application.
  • Create/Maintain/Administration Planning forms & business rules.
  • Create/Maintain/Administration Essbase Cubes, load rules, & calc scripts.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (Hyperion Servers And Files) in Topology.
  • Good knowledge in creating File to Database, and Database to Database related interfaces.
  • Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
  • Experienced in Working with Load Plans and Scenarios.
  • Experience in resolving the tickets (RITM Tickets & Change Request Tickets).
  • Experienced in Working with Exception Handling in load plans.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
  • Created multiple Interfaces for full load and incremental loads and executed them accordingly.
  • Birlasoft is a global technology services company that provides IT services and solutions.

Senior ODI Developer

TechMahindra
Pune
10.2016 - 10.2017
  • Company Overview: Tech-Mahindra is a provider of IT services and solutions.
  • Involved in Extraction, Loading (Implement business logic) and Transformation data into Flat files using ODI.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (File, Oracle SQL Server and Excel files) in Topology.
  • Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups.
  • Good knowledge in creating File to Database, and Database to Database related interfaces.
  • Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
  • Experienced in Working with Load Plans and Scenarios.
  • Experienced in Working with Exception Handling in load plans.
  • Participated in all phases of project development, testing, in deployment and support activities.
  • Used ODI commands like ODI-files move, ODI-files append, ODI-files copy etc.
  • Worked in SCD and CDC implementation and Used CDC features for Incremental data loads.
  • Hands on experience in configuration of agent such as standalone agent, collocated agent.
  • Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
  • Created multiple Interfaces for full load and incremental loads and executed them accordingly.
  • Harjai Computers is a provider of IT services and solutions.

ODI Developer

Tata Consultancy services
Pune
09.2013 - 10.2016
  • Company Overview: Tata consultant Pvt Ltd
  • Involved in Extraction, Loading, and Transformation data to warehouse using ODI.
  • Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups.
  • Created Data servers, Physical and Logical schemas for multiple technologies like (File, Oracle SQL Server and Excel files) in Topology.
  • Good knowledge in creating File to Database, and Database to Database related interfaces.
  • Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP.
  • Experienced in Working with Load Plans and Scenarios.
  • Participated in all phases of project development, testing, in deployment and support activities.
  • Used ODI commands like Odi-files move, odi-files append, odi-file copy etc.
  • 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.
  • Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
  • Worked in SCD and CDC implementation and Used CDC features for Incremental data loads.
  • Created multiple Interfaces for full load and incremental loads and executed them accordingly.
  • Enhancement of ELT code/design, defect fixing- code fixes and data fixes.
  • Utilizing the log of the sessions.

Education

M.Tech - Electronics & Communication Engineering

JNTU-Kakinada

Skills

  • Oracle Data Integrator (ODI) 12c/11g
  • SQL
  • PL/SQL
  • Oracle 11g
  • Oracle 12C
  • SQL Developer
  • SQL plus
  • Toad

Certification

  • 1Z0-448 - Oracle Data Integrator 12c Essentials
  • 1Z0-1085-20 - Oracle Cloud Infrastructure Foundations 2020 Associate

Accomplishments

  • For my outstanding performance & dedication, I got Best employee recognition and awarded for the year 2021

Timeline

ODI Technical Architect

Hexaware India Pvt.
09.2021 - Current

ODI Consultant

Capgemini Technology Services India Pvt Ltd.
05.2019 - 09.2021

Senior ODI Developer

Capgemini Technology Services India Pvt Ltd.
10.2017 - 05.2019

Senior ODI Developer

Birlasoft India Pvt Ltd.
10.2017 - 05.2019

Senior ODI Developer

TechMahindra
10.2016 - 10.2017

ODI Developer

Tata Consultancy services
09.2013 - 10.2016

M.Tech - Electronics & Communication Engineering

JNTU-Kakinada
Ashok Kumar