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
Lead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIALead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIA