Summary
Overview
Work History
Education
Skills
Certification
Hobbies and Interests
Accomplishments
Software
Websites
Languages
Timeline
Ishan Dwivedi

Ishan Dwivedi

Senior Analyst - BI
Bengaluru

Summary

Detail-oriented and analytical Data Analyst with 4.5+ years of experience in transforming raw data into actionable insights. Proficient in Power BI, Python, SQL, Databricks, Azure Data Lake, and Excel, with a strong passion for developing impactful visualizations and optimizing data-driven decision-making. Seeking a challenging role to apply my expertise in data analysis, dashboarding, and financial insights while continuously expanding my knowledge in the evolving field of analytics.

Overview

5
5
years of professional experience
2
2
Certification

Work History

Senior Analyst - BI

Tiger Analytics
Bengaluru, Karnataka
11.2023 - Current
  • Designed and developed interactive dashboards in Power BI, integrating Azure Data Lake, Databricks, and SharePoint as data sources to deliver patterns, trends, and insights for strategic decision-making.
  • Utilized DAX and Power Query to perform complex calculations, optimize data models, and enhance report performance in Power BI Service, ensuring efficient data processing and transformation.
  • Implemented Custom Visuals and leveraged advanced analytics techniques to meet specific client requirements, improving data storytelling and enhancing user experience.
  • Conducted in-depth requirement analysis with clients to provide timely and scalable data-driven solutions, utilizing scheduled refresh and API-based refresh for seamless data updates.

Technology Analyst

Infosys Limited
Pune, Maharashtra
10.2020 - 10.2023
  • Extracted, cleaned, and analyzed datasets from different client projects to generate meaningful business insights for the Region Head, supporting strategic planning.
  • Utilized Power BI, MySQL, and Excel to create interactive visualizations, helping stakeholders identify key trends, anomalies, and performance metrics.
  • Managed the migration of Excel-based reports to Power BI, streamlining data processing, automation, and dashboarding for improved reporting efficiency.
  • Collaborated with cross-functional teams to understand business needs and deliver customized analytics solutions within strict timelines.

Education

Bachelor of Technology - Computer Science and Engineering

PSIT College Of Engineering, Kanpur, Uttar Pradesh
08.2016 - 07.2020

Skills

  • Power BI
  • MySql
  • Azure Databricks
  • Azure Datalake
  • Python
  • Excel
  • DAX
  • Power Query
  • Data Modelling
  • Data Visualization

Certification

  • PL - 300 Microsoft Certified: Power BI Data Analyst Associate
  • Azure Databricks & Spark For Data Engineers Udemy Certification

Hobbies and Interests

  • Playing Cricket and watching different Worldwide leagues.
  • Travelling new places and exploring different cuisines
  • Singing and Listening Bollywood Songs.

Accomplishments

  • Enhanced Data Driven Decision Making: Designed and developed interactive Power BI dashboards, enabling leadership to make informed strategic decisions based on real-time insights and trends.
  • Streamlined Reporting Efficiency: Successfully led the migration of 20+ Excel-based reports to Power BI, automating workflows and reducing manual reporting efforts by 50%.
  • Automated Data Pipeline Management: Implemented scheduled refresh and API-based updates, ensuring consistent data synchronization and reducing report refresh failures.
  • Client Satisfaction & Solutions: Delivered custom data visualizations to meet client-specific requirements, achieving a Higher satisfaction rate.

Software

Power Bi

Databricks

PyCharm

MySql Workbench

Excel

Jupyter Notebook

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Timeline

Senior Analyst - BI - Tiger Analytics
11.2023 - Current
Technology Analyst - Infosys Limited
10.2020 - 10.2023
PSIT College Of Engineering - Bachelor of Technology, Computer Science and Engineering
08.2016 - 07.2020
Ishan DwivediSenior Analyst - BI