MAHATA MOU

Project Details

Project :CareSource-BI reporting 2.0 Trans

Client :CareSource Management Group

Skills : PowerBI, Databricks, SQL

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.
• Get the data from Databricks using inline query.
• 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

Project : Bank Details Management

Skills : MySQL , Teradata

About Project : Creating a database on bank details Management including all the necessary requirement of the project like data modelling, creating schemas, tables, entities and logically relating all the tables.

Roles and Responsibilities :

• Understand the schema and relationship between the tables and importing the raw data into Teradata
• Extracting and manipulating the required data from the database by using SQL commands