
Prakash Chatla
Fähigkeiten und Kenntnisse
Werdegang
Berufserfahrung von Prakash Chatla
- 9 Monate, Feb. 2024 - Okt. 2024
MSBI Developer and Modeler
ADAC
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 a data warehouse.
- 1 Jahr und 10 Monate, Mai 2022 - Feb. 2024
Senior Power BI Consultant
AB-InBev
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
- 1 Jahr und 1 Monat, Juni 2022 - Juni 2023
Senior DW/BI consultant
Munich Re, Munich
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.
- 2 Jahre, Mai 2018 - Apr. 2020
Freelance DW/BI Architect,Modeller, Developer
Robert Bosch
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.
- 4 Monate, Dez. 2016 - März 2017
DW/BI Expert
Rapidcubes
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
- 6 Jahre und 11 Monate, Sep. 2008 - Juli 2015
Senior DW/BI Architect
KING ICT
- 2 Jahre und 1 Monat, Sep. 2006 - Sep. 2008
Lead .NET Developer
Softpro Tetral
Ausbildung von Prakash Chatla
- 1 Jahr, Jan. 1999 - Dez. 1999
Diploma in Advance Computing
C-DAC
- 4 Jahre und 1 Monat, Aug. 1992 - Aug. 1996
Mechanical Engineering
Anna University, Chennai
Sprachen
Englisch
Muttersprache
Deutsch
Grundlagen
Croatian
-
Tamil
-
Telugu
-
XING Mitglieder mit ähnlichen Profilangaben
XING – Das Jobs-Netzwerk
Über eine Million Jobs
Entdecke mit XING genau den Job, der wirklich zu Dir passt.
Persönliche Job-Angebote
Lass Dich finden von Arbeitgebern und über 20.000 Recruiter·innen.
22 Mio. Mitglieder
Knüpf neue Kontakte und erhalte Impulse für ein besseres Job-Leben.
Kostenlos profitieren
Schon als Basis-Mitglied kannst Du Deine Job-Suche deutlich optimieren.