Prakash Chatla

Design, build Tabular Models in SSAS. Design, build Power BI reports. Migrate cubes from IBM to SSAS Tabular Models

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