Summary
Overview
Work History
Education
Skills
Additional Information - Rewards
Timeline
BusinessDevelopmentManager
Kshiyama Thirumaran

Kshiyama Thirumaran

ODI DEVELOPER
Bengaluru

Summary

Kshiyama is an ODI Developer and application Manager. She has 11+ years of experience in IT in which 8 years into Oracle Data Integrator(12c) and PL/SQL and 2 years of experience in GCP.

Overview

12
12
years of professional experience

Work History

ODI developer

CAPGEMINI (PROJECT-IKEA)
07.2016 - Current
  • Responsible for Developing Application in ODI, as per HLD and LLD provided by customer, and integration of all components, working on orchestration of ODI flow.
  • Analyzing the Functional Specifications and changing necessary modifications required through designer interaction
  • Creating Unit Test Cases, Unit Test Review documents as per requirements
  • Analyze defects raised in testing cycle, provide fixes as applicable and influence testing team for closure of defects once fixes are provided
  • Discuss with testing team for analyzing defects raised in testing cycle for assigned Work
  • Maintain regular communications with onsite team for requirements understanding and aid in design.
  • Reviewing on work and progress from team as required.
  • Developed several Mappings with Transformation Logics like Filters, Joins and Lookups, expressions
  • Participated in all phases of project development, testing, in deployment activities.
  • Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata
  • Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
  • Strong working experience with Data migration and Data integration projects
  • Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing


Tableau /Teradata Developer/ODI 11G

CAPGEMINI (PROJECT-UNILEVER)
07.2014 - 06.2016
  • Performed data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis
  • Created Logical Data flow Model from the Source System study according to Business requirements on MSVisio
  • Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data
  • Worked on optimizing and tuning to improve the performance of batch and response time of data for users
  • Worked closely with analysts to come up with detailed solution approach design documents
  • Provided initial capacity and growth forecast in terms of Space, CPU for the applications by gathering the details of volumes expected from Business
  • Have strong knowledge in data mover for importing and exporting of data
  • Creating and maintaining source-target mapping documentsforETL development team
  • Providing requirement specifications and guide the ETL team for development of the ETL jobs through ETL tool
  • Development of test cases and testing
  • Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another
  • Analyze business requirements, designs and write technical specifications to design/redesign solutions
  • Involved in complete software development life-cycle(SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment
  • Developed technical design documents (HLD and LLD) based on the functional requirements
  • Coordinate with Configuration management team in code deployments.

Specialized Infrastructure Engineer

HP
12.2012 - 07.2014
  • Provide Solution to the (Target system) with the Products and applications
  • Loading the Data from source to target Warehouse
  • Analyzing the Functional Specifications and changing necessary modifications required through designer interaction
  • Provide update on work progress to Project Manager and Technical Lead as required.

Education

B-Tech - Computer Science Engineering

Kalasalingam University
06.2012

Skills

Data Integration Techniques

undefined

Additional Information - Rewards

Recognized as the best performer of business unit(IKEA)for the year 2021

Timeline

ODI developer

CAPGEMINI (PROJECT-IKEA)
07.2016 - Current

Tableau /Teradata Developer/ODI 11G

CAPGEMINI (PROJECT-UNILEVER)
07.2014 - 06.2016

Specialized Infrastructure Engineer

HP
12.2012 - 07.2014

B-Tech - Computer Science Engineering

Kalasalingam University
Kshiyama ThirumaranODI DEVELOPER