MIHIR DOBARIYA
Data AnalystAI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 1+ years in SQL, Excel, Python & Power BI
Results-driven Data Analyst with hands-on experience in SQL, Excel, Python, Power BI, and Business Intelligence, specializing in KPI reporting, data extraction, cleansing, and normalization to transform raw data into actionable insights that drive strategic decision-making. Skilled in identifying and quantifying the impact of key business drivers on KPIs, defining and communicating key metrics and trends to both technical and non-technical stakeholders, and delivering measurable business impact. Proven ability to develop stakeholder-ready dashboards and reports, optimize reporting workflows, and support data-driven decision-making across cross-functional teams. Strong foundation in problem-solving, business performance analysis, process optimization, and analytical thinking.
360DigiTMG
Course · Professional Data Science & AI
May 1, 2025 – June 1, 2026
The State University of New York at Potsdam
Post Graduate Diploma · Artificial Intelligence
March 1, 2025 – June 1, 2026
Bhakta Kavi Narsinh Mehta University
Bachelor of Computer Applications · Information Technology
July 1, 2022 – March 1, 2025
AISPRY Technologies
Data Analyst Intern
April 1, 2025 – Present
Bengaluru, Karnataka, India
Customer Shopping Analysis
June 19, 2026 – Present
Architected and delivered an end-to-end data analytics pipeline spanning raw CSV ingestion, ETL processing, MySQL database loading, exploratory analysis, and Power BI dashboard development. Performed data cleaning, preprocessing, and transformation using Python (Pandas, NumPy), resolving missing values, duplicates, and data inconsistencies to improve analytical readiness. Applied feature engineering techniques to derive customer-centric metrics including purchase frequency, average basket size, and customer lifetime value (CLV). Designed a normalized MySQL database schema and developed advanced SQL queries (JOINS, GROUP BY, Subqueries) for customer segmentation, revenue analysis, and cohort analysis. Conducted Exploratory Data Analysis (EDA), regression analysis, and correlation analysis to identify purchasing trends, customer behavior patterns, and revenue-driving factors. Identified Clothing and Electronics as the highest revenue-generating categories, while weekend transactions significantly outperformed weekdays, supporting promotional and inventory planning decisions. Built a multi-page interactive Power BI dashboard using DAX measures, KPI scorecards, trend analysis, customer segmentation, and business performance reporting. Generated stakeholder-ready business insights and recommendations that supported customer retention, marketing optimization, and data-driven decision-making.
View ProjectNetflix SQL Analysis
June 19, 2026 – Present
Performed large-scale SQL-based analysis on a dataset of 8,000+ Netflix titles across 190+ countries using PostgreSQL. Developed and optimized 15+ advanced SQL queries using CTEs, Window Functions, CASE Statements, Correlated Subqueries, and Array Operations for data transformation and analysis. Conducted multi-dimensional content trend analysis across genres, countries, ratings, release years, and content types to generate business intelligence insights. Performed data wrangling on complex unstructured fields, transforming cast and genre information into structured datasets for reporting and analytics. Built a rule-based content classification system using SQL CASE expressions and identified regional content trends, supporting localization and content strategy decisions. Delivered stakeholder-ready insights on content distribution, regional production trends, market opportunities, and year-over-year growth to support data-driven decision-making.
View ProjectGoogle Data Analytics Professional Certificate
February 1, 2026 – Present
Data Visualization using Power BI
360DigiTMG
July 1, 2025 – Present
Deloitte Australia Data Analytics Job Simulation
Deloitte
July 1, 2025 – Present
Career Essentials in Data Analysis
Microsoft
June 1, 2025 – Present
Cultural Fit Analysis
The candidate's diverse project portfolio, including customer shopping analysis and Netflix content analysis, shows a broad interest in applying data analytics across different domains. Their current internship as a Data Analyst Intern aligns directly with the target role, indicating a clear career path and commitment. The breadth of technical skills (SQL, Python, Power BI, Excel, various BI tools) and soft skills (stakeholder management, problem-solving, team collaboration) suggests a good cultural fit for a data-driven and collaborative environment.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving, analytical thinking, and attention to detail through their project descriptions and internship responsibilities. Their experience in an Agile/Scrum environment and stakeholder management indicates good operational fit and collaboration skills. The automation of reporting processes highlights an efficiency-driven mindset.