Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic
Prakash Kavar

Prakash Kavar

Senior Manager - Data & Analytics
Dubai

Summary

Over 15 years of expertise in Data Analytics, Data Warehousing, Large scale BI Projects, AI, Data Science, and Predictive Analytics. Specialize in creating AI-driven strategies and scalable analytics solutions for digital transformation. Collaborate with stakeholders to uncover high-impact opportunities and translate insights into actionable strategies. Excel in managing large and complex data storage systems and leading teams of data engineers, BI architects and PowerBI developers for successful outcomes.

Overview

14
14
years of professional experience
2010
2010
years of post-secondary education

Work History

Senior Manager - Data & Analytics

Dubai Holding Entertainment
06.2023 - Current
  • Led the development of a unified data lake system that integrated multiple data sources across the organization, facilitating comprehensive access to application data and supporting advanced data modeling initiatives.
  • Designed and implemented data marts and self-service analytics solutions, empowering business users to gain insights and make data-driven decisions effectively.
  • Created Power BI business performance dashboards for top management and department heads, enabling real-time monitoring of key metrics, including revenue, profit, inventory, and marketing KPIs.
  • Successfully migrated Cognos and Netezza-based BI applications to Power BI and Azure Synapse Analytics, enhancing reporting capabilities and optimizing data processing for improved performance.
  • Collaborated with cross-functional teams to ensure seamless integration of data systems and alignment with business objectives, driving strategic initiatives through effective data management.

Sr. Business Analyst

Elcome International LLC
06.2017 - 06.2023
  • Designed technical solutions to address business challenges by establishing a Data Warehouse and developing BI reports to monitor sales efforts and drive business growth.
  • Created Power BI dashboards and reports tailored for management and department heads based on the data structure within Azure SQL Database.
  • Implemented real-time replication of Dynamics ERP and CRM data to Azure SQL Database for accurate and up-to-date reporting.
  • Set up Power BI Embedded solutions for customer-specific analytics needs.
  • Generated finance reports, sales matrices, and predictive analysis reports using Power BI to support informed decision-making.
  • Integrated Power Platform technologies, including Power Automate and Power Apps, to optimize business processes.
  • Led the development of IoT and AI-based analytics projects to leverage cutting-edge technology for enhanced insights.

BI-TechLead

CloudFronts Technologies
03.2016 - 06.2017
  • Collaborated with business users and subject matter experts to gather and analyze requirements for reports, views, and BI query objects, focusing on productivity-related KPIs and various data sources.
  • Conducted comprehensive analyses of web analytics and external data to derive actionable insights, while also leading key internet marketing initiatives for client acquisition and retention through email campaigns and social media.
  • Recently served as a Microsoft Services Architect with experience in pre-sales for Business Intelligence, Databases, and Data Warehousing, crafting innovative architectures for industry-specific solutions and facilitating risk computation for Basel II compliance.

Data Architect and MSBI Developer

KUONI Destination Management
08.2014 - 03.2016
  • Analyzed Business Requirement Documents (BRD) to design a conceptual model for implementation using T-SQL, SSIS, SSAS, and SSRS, creating complex stored procedures and SQL Agent jobs while adhering to RDBMS rules.
  • Developed and supported ETL processes using SSIS packages in SQL Server 2008, including incremental data loads from various sources and optimization of OLAP processes to maintain the Data Warehouse and enhance reporting capabilities.
  • Played a key role in server migration and QlikView installation, successfully creating and implementing dashboards for booking, revenue, financial P&L, and balance sheets in QlikView to support business insights.

Sr. SQL Developer

Market Track, LLC
08.2012 - 01.2014

Software Developer

Paramatrix Technologies
01.2011 - 08.2012

Education

B-Tech -

DDU
India
05-2010

Skills

  • Analytics
  • Azure Data Lake
  • Databricks
  • PowerBI
  • GA
  • Big Query
  • Power Platform Technologies
  • Synapse Analytics
  • Microsoft Fabric
  • Microsoft Dynamics CRM & ERP

    Salesforce Sales & Marketing Cloud

  • Azure Logic Apps
  • Python
  • R Script
  • Copilot Integration

Personal Information

Date of Birth: 10/27/89

Timeline

Senior Manager - Data & Analytics

Dubai Holding Entertainment
06.2023 - Current

Sr. Business Analyst

Elcome International LLC
06.2017 - 06.2023

BI-TechLead

CloudFronts Technologies
03.2016 - 06.2017

Data Architect and MSBI Developer

KUONI Destination Management
08.2014 - 03.2016

Sr. SQL Developer

Market Track, LLC
08.2012 - 01.2014

Software Developer

Paramatrix Technologies
01.2011 - 08.2012

B-Tech -

DDU
Prakash KavarSenior Manager - Data & Analytics