Rohan Peter Dabre

Data Analyst

Mumbai, IN.

About

Results-driven Data Analyst with a robust foundation in SQL, Python, Excel, and Power BI, adept at transforming complex datasets into actionable business intelligence. Proven ability to clean, analyze, and visualize data to generate critical insights, enabling data-driven decision-making and contributing to strategic initiatives in fast-paced environments.

Work

Data view Analytics

|

Data Analyst Intern

Remote, Global, Global

→

Summary

Contributed as a Data Analyst Intern, leveraging SQL, Excel, and Power BI to process, analyze, and visualize data, enabling business teams to track KPIs and improve reporting efficiency.

Highlights

Streamlined data processing by standardizing a 100,000+ row dataset from diverse regions, enabling business teams to accurately track KPIs across geographies and timeframes.

Automated reporting workflows by designing advanced Excel templates with lookup and pivot functions, reducing reporting time by 40% across four departments.

Developed and maintained intuitive Power BI dashboards, providing critical visualizations of revenue trends, customer mix, and monthly performance utilized by managers and analysts for data-driven decisions.

Enhanced data integrity and strategic alignment by collaborating with 4 analysts and 2 senior managers to define and validate 6 key performance indicators (KPIs).

Education

ITM IHM

Mumbai, Maharashtra, India
→
B.A. Hospitality and Tourism Management

Certificates

Data Analytics Job Simulation

Deloitte

Data Science and Analytics

HP

Data Analytics – One Roadmap

Online Course

Skills

Programming & Querying

SQL, Python.

Data Visualization Tools

Advanced MS Excel, Power BI, Tableau.

Analytical Abilities

Data Cleaning, Exploratory Data Analysis (EDA), Insight Generation, Descriptive Statistics.

Projects

Customer Churn Analysis

→

Summary

Conducted a comprehensive customer churn analysis using Python, focusing on identifying key patterns and developing strategies to mitigate churn for a telecom client.

Sales Dashboard for Regional Performance

→

Summary

Developed an interactive sales dashboard for regional performance analysis using SQL and Power BI, providing actionable insights for marketing and sales strategies.