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
Analytical Problem Solving
Continuous Improvement Mindset
Business Process Analysis
Project management experience
Software Development Lifecycle
Data Validation Techniques
Performance optimization techniques
Database Management Abilities
Agile Methodology Adoption
Root Cause Analysis
Business Relationship Development
Teamwork and Collaboration
Problem-Solving
Problem-solving abilities
Excellent Communication
Decision-Making
Critical Thinking
Active Listening
Team building
Task Prioritization
Cloud services
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