Sivateja Rajaneni

Projects Details

Project :CareSou-BI reporting 2.0 Trans

Client :CareSource Management Group

Skills :SQL, Databricks SQL, PowerBI

About Project

This Project objective is to migrate the On- Prem SSRS and SSIS

Reports to cloud by transforming SSRS and SSIS Reports into PowerBI Services and ADF pipelines respectively using Databricks SQL to obtain data from the Data lake

Roles and Responsibilities :

• Analyze the Legacy reports to understand the requirements
• Replicate the Reports in Databricks with same functionality
• Validate the data with the Legacy system to check if the same functionality is replicated
• worked with DA team to understand the Legacy and cloud system to Understand the required tables in the cloud Platform

This is an Intership program I did with the Cognizant during which i have gone through learning like SQL, Data Warehousing and Informatica PowerCenter

and at the end done a project

Project Details:

Tournament Details Database with ETL tool Informatica Power,enter

About Project

In this project we have to extract the data from the files and transform the data in the Informatica PowerCenter and then load the data into Oracle DBMS. Then create a data warehouse in the Oracle to replicate star schema and implement SCD with Informatica PC