Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kalpesh Bhalerao

Royal Leamington Spa

Summary

Over 10 years of experience in Business Intelligence across diverse roles. This includes development, production support, team leadership, and technical leadership in reporting and analytics. I'm proficient in various BI tools like MS Power BI, Tableau, Qlik, and Business Objects (XI 3.x & BI 4.x Universe design). Additionally, I possess expertise in database querying and performance tuning across platforms like Azure, GCP, Snowflake Oracle, Teradata, and SQL Server. My experience spans projects for clients in the financial, transportation, and manufacturing services across the US, Latin America, and Europe/UK. Efficient business intelligence and reporting solutions architect with comprehensive understanding of company database roles. Accessibility-focused data synthesizer with deep history of establishing well-organized and approachable information systems. Flexible program problem solver with collaborative outlook and agility in designing effective databases.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Data Warehouse Developer

TCS - Jaguar And Land Rover
08.2022 - Current
  • Extensive experience in building data architectures: This includes enterprise data lakes, data warehouses, and self-service analytical platforms.
  • Proven ability to deploy Tableau Server on Google Cloud Platform (GCP)
  • Management of entire project lifecycle: From requirement gathering to final delivery, ensuring successful implementations. (focuses on ownership and project management)
  • In-depth knowledge of Snowflake storage operations: Possess hands-on experience for efficient data storage and retrieval.

Senior Data Analyst

TCS - Belgium Railways
03.2019 - 07.2022
  • Requirement gathering for new developments and enhancements.
  • Develop, modify, maintain and support custom reports or Dashboards of Power BI for both ad-hoc and ongoing needs.
  • Proven experience in delivering solutions to challenging business requirements for project initiatives that involves Power BI solutions.
  • Hands on experience on Azure storage operations: Azure storage and AD data Factory.
  • Deploy new solutions and maintain production environment.
  • Resolve issues within the Service Level Agreement (SLA) defined by the business.
  • Communicate project status to team members and project stakeholders on weekly basis.

BI Reporting SME

TCS - GE Capital Americas
10.2017 - 09.2019
  • Lead RTS (Real Time Support) reporting Team. Team activities involves below mentioned tasks related to Business Objects reporting
  • Provided Real Time Support to Business users by fixing there problem real quick.
  • Worked with the data team to bring in the required information into Business Objects Universe to make it available for super users to create Adhoc reports
  • Worked on the tickets raise by users through Service –now ITIL and solved them.
  • Worked with the users to know there need and the problems they are facing and solve them.
  • Fixing the existing report, busing new reports and Enhance universe as per the requirements.

SAP BI Reporting Analyst

TCS - GE Capital Americas
12.2013 - 09.2017
  • Generate effective reports by using all available function of Webi and Rich client 4.0 environment based on the report creation requirements.
  • Provided Real Time Support to Business users by fixing there problem real quick.
  • Worked extensively on Universe design tool and Introduced 4 new universe in BO 4.0 environment based on the Eclipse BIRT reporting source.
  • Creation of a robust and user-friendly Business Objects 4.0 universe and corresponding design documents for Adhoc reporting purposes and helping users understand the tips and techniques for efficient reporting.

Education

Bachelor of Science - Information Technology

Mumbai University
05.2013

Skills

  • ETL development
  • SQL Expertise
  • Data Migration
  • Data Governance
  • Data Warehousing
  • Business Intelligence
  • Agile Methodologies

Certification

  • Six Sigma Green Belt certification in 2013
  • Six Sigma Black Belt Certification in 2016
  • Microsoft Power BI Data Analyst certification in 2021
  • Microsoft Azure Data Scientist Associate in 2021
  • Google Cloud Digital Leader Certification in 2023
  • Professional Scrum Master I Certified in 2023

Timeline

Senior Data Warehouse Developer

TCS - Jaguar And Land Rover
08.2022 - Current

Senior Data Analyst

TCS - Belgium Railways
03.2019 - 07.2022

BI Reporting SME

TCS - GE Capital Americas
10.2017 - 09.2019

SAP BI Reporting Analyst

TCS - GE Capital Americas
12.2013 - 09.2017

Bachelor of Science - Information Technology

Mumbai University
  • Six Sigma Green Belt certification in 2013
  • Six Sigma Black Belt Certification in 2016
  • Microsoft Power BI Data Analyst certification in 2021
  • Microsoft Azure Data Scientist Associate in 2021
  • Google Cloud Digital Leader Certification in 2023
  • Professional Scrum Master I Certified in 2023
Kalpesh Bhalerao