Prakash Chatla

Design, model and build the DWH in Azure Synapse Analytics on Data Vault modeling Design, model and build data mart in Azure Synapse Analytics Design, model and build semantic models in Power BI Service Write SQL queries and Python (PySpark, Pandas) scripts to consolidate the data in Data Warehouse. Design and implement data pipelines to extract, transform, and load data from various sources into DWH. Design and build data pipelines to extract, transform, and load data from various sources into a DWH

Design and model the staging and final databases in Azure Databricks Write SQL queries and PySpark scripts in Azure Databricks notebooks Design and implement data pipelines to extract, transform, and load data from various sources into Databricks databases Extract data from data flows, Azure SQL Server, Postgre Sql, Azure data explorer, Azure Databricks using Power Query and build Power BI data flows, datasets, and reports. Write SQL queries to extract data Implement DAX measures inside the Power BI model

Design and implement the data layer (MSSQL database) & performance layer (SSAS Tabular models) used by Power BI. Migrate the existing Power BI reports from Import Mode to live connection. Maintain and extend the loading procedures from TM1(IBM) to middleware (MSSQL). Writing SQL stored procedures, Views, and functions (UDF) to consolidate the data in Data Warehouse. Design, build SSAS tabular Models, Power BI Models. Implement DAX measures inside the SSAS model. Optimize the DAX measures for fast response.

Design, build reports in SAP Business objects, Power BI, Excel. Migrate reports from SAP Business objects, Excel to Power BI. Migrate SAP BO Universe to Power BI model Extract data from Oracle, SQL Server, Excel, CSV files using Power Query and build Power BI data flows, datasets and reports. Design, Model Power BI data sets using star schema (Kimball) Write SQL queries to extract data. Implement DAX measures inside the Power BI model based on the business needs. Optimize the DAX measures for fast response

Design, build data warehouse on SQL Server based on Kimball dimension modeling. Design, create and develop SSIS packages and SQL queries, SQL Views, Automate the process using the metadata information from the SQL server database tables. Design, build and Performance tuning of SSAS tabular Models, Power BI Models. Design, build reports and dashboards in Power BI, SSRS. Implement DAX measures inside the SSAS model Manage and work closely with the teams in India, Swiss, Canada, South Africa and Australia.

Design and build data warehouse on SQL Server based on Kimball dimension modelling. Design and build data warehouse on SQL Server Create logical and physical data models for the metadata, data warehouse and tabular models. Experience using advance Power Query editor for creating partitions and functions inside SSAS Models. Implement DAX measures inside the SSAS tabular model, Power BI datasets based on the business needs.

Re-designed SQL server data warehouse to optimize the ETL operations cutting the overall load time to one-third. Implemented slowly changing dimensions. Implemented logging on all levels (Package, steps and procedures). Design, create, develop and test data warehouse and cubes working closely with team members and business users and eliminating the Unknown member(s) in the dimensions and matching the fact measures with the source values.

Involved in interacting with business users for requirements gathering and analyzing source data for enterprise DW/reporting. Responsible for translating the Business requirements into technical specifications. Involved in the Technical field mapping of source systems (SAP – Reinsurance, SAP - CD, SAP – GL, and SAP - BP) to Direct Reinsurance Data warehouse based on the functional specification