Mitali Kate

Project Details

Project 1: Purchase Analytics for Leading Auto Manufacturer in

Europe

Team size: 10

Project 2: Sustainability reporting for global materials science

and digital identification solutions company.

Team size: 5.

Roles and Responsibilities:

· Used ODI 12c for extraction, loading and transformation ETL of data in the data warehouse.

· 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.

· Extensive Experience on Topology Navigator with developing Physical and Logical Architecture.

· Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

· Extensively used ODI to load data from Oracle, flat files, SQL Server as a source.

· 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 brand dimensions.

· Used SQL tools like SQL developer to run SQL and PL/SQL queries and validate the data loaded into the target tables.

· Extensively involved in root cause analysis and resolution of production issues incidents.

· Involved and conducted scrum ceremonies.

· Provided a walkthrough regarding the developed work artifacts to the client.

· Provided training to the peers regarding ODI 12C

· Extensive knowledge in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation. Exposure to version tracking control systems.

Project Details

Project 1: Claim Analytics for a Leading Insurance Company

Team size: 15

Roles and Responsibilities:

· Used ODI 12c for extraction, loading and transformation ETL of data in the data warehouse.

· 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.

· Extensive Experience on Topology Navigator with developing Physical and Logical Architecture.

· Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

· Extensively used ODI to load data from Oracle, flat files ,SQL Server.

· 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 brand dimensions.

· Used SQL tools like Sql developer to run SQL queries and validate the data loaded into the target tables.

· Involved in requirement gathering with the clients. Converting those requirement into sql queries and present a prototype report as a part of pre production phase and for customer's approval.

· Extensively involved in root cause analysis and resolution of production issues incidents.

· Provided a walkthrough regarding the developed work artifacts to the client.

· Extensive knowledge in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation . Exposure to version tracking control systems.

Project Details

Project 1: Retail Analytics for the largest supermarket chain in the United Kingdom

Team size: 7

Roles and Responsibilities:

· Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse.

· 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.

· Extensive Experience on Topology Navigator with developing Physical and Logical Architecture.

· Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

· Extensively used ODI to load data from Oracle, flat files, SQL Server.

· 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 brand dimensions.

· Used SQL tools like Sql developer to run SQL and PL/SQL queries and validate the data loaded into the target tables.

· Extensively involved in resolving production incidents.

· Raising a deployment request using HP manager change management tool.

· Provided a walkthrough regarding the developed work to the third party.