Navigation überspringen

Prakash Chatla

Available for Microsoft BI roles

Bis 2020, Freelance DW/BI Architect,Modeller, Developer, Robert Bosch
Kornwestheim, Deutschland

Fähigkeiten und Kenntnisse

SSAS (MD TABULAR)
Data Architect
Data Modelling
Power BI
SQL Server
T-SQL
MDX DAX
Data Warehousing
Dimensional modeling
SSIS
SSRS
Tableau Software
Business Intelligence
ETL
Snowflake Schema
C#.NET
Star Schema
CA Erwin
PowerDesigner
Cube (OLAP)
Visual Studio
SAP
Microsoft Azure
SSDT
BIDS
SharePoint
MDM
DQS
ODS
Meta data
PowerPoint

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

  • 1 Jahr und 8 Monate, Mai 2020 - Dez. 2021

    Senior Power BI Consultant

    Sky Deutschland GmbH

    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

  • 7 Monate, Mai 2021 - Nov. 2021

    Data/BI Architect

    Glencore International AG

    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.

  • 1 Jahr und 2 Monate, März 2017 - Apr. 2018

    Senior DW/BI Consultant

    mytheresa.com GmbH
  • 4 Monate, Dez. 2016 - März 2017

    DW/BI Expert

    Rapidcubes

  • 10 Monate, Jan. 2016 - Okt. 2016

    Senior DW/BI Consultant

    Schustermann & Borenstein

    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.

  • 5 Monate, Aug. 2015 - Dez. 2015

    DW/BI Technical Expert

    Gen Re / General Reinsurance AG

    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 – 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.

21 Mio. XING Mitglieder, von A bis Z