Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ankit Barve

Pune

Summary

Over 12 years of total experience as a Data Analyst, have core development experience on multiple tools and technologies.

Rich experience in stakeholder management, agile, team leadership as a Technical Product Owner.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Lead Data Analyst

UBS
Pune
04.2022 - Current
  • Align with stakeholders, understanding requirements, and prepare reports to help them with numbers and key performance indicators.
  • Designed and developed multiple MS Power BI Reports from scratch.
  • Fetching data from Azure Data Lake Gen2 and preparing it further for reporting in Jupyter notebooks using Python and Pyspark.
  • Manage Databases: PostgreSQL, Cosmos DB
  • Managing ad hoc business requests for data and numbers
  • Head of Power BI Community India

Power BI Admin & Specialist

ABN Amro
Amsterdam
01.2020 - 03.2022
  • Leading MicroStrategy to Power BI migration.
  • Setting up reporting governance (Implementation of principles, policies, and processes).
  • Enabling a Self Service Business Intelligence culture in the bank.
  • As a Power BI Admin, assigning Power BI resources (Power BI Pro License, Premium workspace) to BI Teams.
  • Solving difficult development or administration problems of Business Intelligence Teams.
  • Deployment Pipelines, connecting Power BI with Azure, exploring Data Lakes, Data Factory.
  • Azure DevOps, Deployment Pipelines for future roadmap, data clean-up using Powershell
  • Planning Future roadmap for Power BI in the bank..

Data Analyst (HR Department)

ABN Amro
Amsterdam
08.2019 - 12.2019
  • Setting up Power BI in Grid (Installing Data Gateway, making connections, creating Workspaces & Security Groups)
  • Creating Reports in Microsoft Power BI, creating views and tables in Teradata & SQL Server
  • Training teams to skill up in Power BI, Power BI services
  • Administrating Performance in Power BI at entire grid level
  • Managing Premium Capacity, gateways, Reports, Dashboard, Dataflows in Power BI Services

Data Analyst (ALM Department)

ABN Amro
Amsterdam
03.2016 - 12.2018
  • Determine operational objectives by studying business functions, gathering information, evaluating output requirements and formats
  • Collaborate with different Tech & business teams to ensure quality and stability of data feeding the operational metrics supported
  • Querying SQL Server DB, creating tables, views and writing Stored Procedures
  • Designed & developed multiple risk reporting reports, dashboards and delivered to business in MicroStrategy & Power BI
  • (Book Equity, Risk reports (Interest rate, market risk and etc based on QRM)
  • Developed multiple Ad Hoc reports on the fly for analysis
  • Sourcing of Data from different sources (Countries) in to one harmonized master table in Data Warehouse
  • Designing and writing business rules for data reconciliation checks and handling in SQL Server
  • Designing ETL workflows in SSIS (SQL Server Integration Services)
  • Developed a reusable application in Power BI for developers as well as for Business Users which got highly appreciated

Junior Data Analyst

Tata Consultancy Services
Mumbai
06.2013 - 02.2016
  • Research, learning and analysis of new BI technologies and keep updating self with latest technologies to provide best possible solution to sales team and customer
  • Involved in multiple training programs (Instructor led and self-learning) and cleared certifications & exams for Business Intelligence technologies & Data Mining & Data Analysis
  • Worked on multiple research projects like :
  • Project 1: Human Chain Capital Management System (Tableau, SQL Server)
  • Project 2: Real Time Airlines Management System (Tableau, MicroStrategy, SQL Server, Internet of Things)
  • Project 3: Real Time Disruption Management system for utilities(Tableau, Python, SQL Server, Internet of Things)
  • Project 4: Original Equipment Manufacture Management System (Tableau, Python, SQL Server, Internet of Things)
  • Involved in multiple demo of mentioned solutions to pre sales team and business leadership

Education

Bachelor of Engineering - Computer Science & Engineering

01.2012

Skills

  • Power BI, Tableau, MicroStrategy, SAP BO
  • Alteryx, SSIS
  • SQL, Python, PySpark
  • Azure Data Factory
  • Azure Data Lake Gen 2
  • Databricks
  • Exploring Artificial Intelligence and Machine Learning

Certification

  • UBS Certified Engineer
  • UBS Certified Data Analyst
  • Microsoft Certified Data Analyst DA-100
  • Microsoft Certified Azure Fundamentals AZ-900
  • Microsoft Certified Data Fundamentals DP-900
  • MicroStrategy Certified Report & Dashboard Developer
  • MicroStrategy Certified Project Designer
  • MicroStrategy Certified Project Architect

Timeline

Lead Data Analyst

UBS
04.2022 - Current

Power BI Admin & Specialist

ABN Amro
01.2020 - 03.2022

Data Analyst (HR Department)

ABN Amro
08.2019 - 12.2019

Data Analyst (ALM Department)

ABN Amro
03.2016 - 12.2018

Junior Data Analyst

Tata Consultancy Services
06.2013 - 02.2016

Bachelor of Engineering - Computer Science & Engineering

Similar Profiles

CREATE PROFILE
Ankit Barve