Harsh Raj
Business Analyst | Power BI Expert | Data-Driven Problem Solver
Get In Touch
Transforming Data Into Strategic Business Solutions
I'm a finance-educated business analyst who bridges the gap between complex data and actionable business insights. With a BBA in Finance from Dr. Shyama Prasad Mukherjee University and specialized training in business analysis, I bring a unique perspective that combines financial acumen with technical expertise.
My approach centers on deeply understanding business challenges and translating them into data-driven solutions. I leverage advanced analytics tools such as SQL, Power BI, and Excel to analyze data, uncover insights, and deliver solutions that drive measurable results. I am passionate about process optimization, data visualization, and enabling organizations to make smarter, faster, and more informed decisions.
Quick Connect
Mobile: 9693129632
Location: Dhanbad, Jharkhand, India
GitHub: Harshraj-0202
Core Competencies
Business Analysis
Requirements gathering, process mapping, stakeholder management, and solution design that aligns technology with business objectives.
Data Visualization
Expert in SQL , Power BI and Excel for creating compelling dashboards and reports that transform complex data into clear insights.
Financial Analysis
Strong foundation in financial management, forecasting, and business strategy from comprehensive BBA Finance education.
AI & Automation
Leveraging generative AI tools and advanced prompting techniques to streamline business processes and enhance analytical capabilities.
Technical Toolkit
Data Analysis & Visualization
  • Microsoft Power BI: Advanced dashboard creation, DAX formulas, data modeling
  • Microsoft Excel: VLOOKUP, HLOOKUP, pivot tables, advanced formulas
  • Data Analysis: Statistical analysis, trend identification, predictive modeling
  • SQL: Database querying and data manipulation
Business Analysis Tools
  • Requirements Engineering: Documentation, user stories, acceptance criteria
  • Process Mapping: Workflow optimization and process improvement
  • AI Tools: Generative AI for business analysis and prompt engineering
  • Project Finance Modeling: Financial forecasting and scenario analysis
Projects
1st Excel Project - F&P Sales Analysis
Analyzed over 10,000 sales records from FNP to uncover trends in product performance, customer behavior, and regional sales.
Identified Flowers and Cakes as top categories contributing 73% of total revenue, with Delhi, Mumbai, and Bangalore as leading regions.
Discovered strong seasonal demand spikes during Valentine’s and Diwali, where sales rose up to 2x the monthly average.
Built an interactive Excel dashboard using Pivot Tables, Charts, SUMIF, and VLOOKUP for clear visualization of KPIs.
Delivered insights that improved inventory planning, marketing timing, and drove an estimated 18% year-over-year sales growth.
2nd Excel Project Coffee Shop Sales
Analyzed 12 months of coffee shop sales data to understand product performance, customer preferences, and time-based sales trends.
Identified Espresso and Cappuccino as the top-performing products, contributing 58% of total revenue, with peak sales during January–July.
Discovered strong seasonal patterns, with weekend and morning hours driving 65% of daily sales volume.
Built an interactive Excel dashboard using Pivot Tables, Charts, SUMIF, COUNTIF, and Conditional Formatting to visualize KPIs and trends.
Delivered actionable insights that helped improve menu planning, staffing schedules, and marketing campaigns, resulting in a 15% increase in monthly revenue.
3rd Excel Project - Vrinda Store Anuual Report 2022
Analyzed one year of Vrinda Store sales data to evaluate product performance, regional growth, and customer purchase patterns.
Identified that Clothing and Accessories were the top-selling categories, contributing 64% of total revenue, with peak sales in November and December.
Discovered that online sales accounted for 70% of total transactions, and repeat customers contributed 25%, indicating strong customer retention.
Built an interactive Excel dashboard using Pivot Tables, Charts, SUMIF, COUNTIF, and VLOOKUP to track KPIs like total sales, profit margin, and order trends.
Delivered data-driven insights that helped improve sales forecasting, inventory planning, and marketing strategies, resulting in a 12% increase in annual revenue.
1st Power Bi Project - Amazon Prime Video Analytics Dashboard!
This dashboard provides a 360° view of Prime Video’s content library, covering: (i) Total titles, genres, directors & ratings (ii) Movies vs TV Shows split (iii) Top genres like Drama & Comedy (iv) Global content distribution by country (v) Release trends from 1920–2021
Key Insight: Drama and Comedy dominate the library, while there’s a huge surge in content production post-2015 – reflecting Prime Video’s aggressive expansion in the streaming industry.
This project helped me strengthen my data visualization, storytelling, and business analysis skills using Power BI.
2nd Power BI Project - HR Analytics Dashboard!
Analyzed employee data to track attrition rate, performance, department-wise headcount, and employee demographics across the organization.
Identified key trends — overall attrition rate of 16%, with the highest turnover in the Sales and Operations departments.
Discovered that employees aged 25–35 and those with 1–3 years of experience had the highest attrition, highlighting the need for better retention programs.
Developed an interactive Power BI dashboard using DAX measures, slicers, KPIs, and data modeling for real-time HR insights.
Delivered actionable insights that helped HR teams improve employee engagement, retention strategies, and workforce planning, reducing potential attrition by 8%.
3rd Power BI Project - Amazon Products Sales Analysis
Analyzed Amazon sales data across multiple categories to monitor revenue trends, top-selling products, and regional performance.
Identified that Electronics and Home Appliances were the highest revenue-generating categories, contributing over 55% of total sales.
Discovered seasonal and promotional trends — peak sales during festive months (October–December) and during special promotions like Prime Day.
Developed an interactive Power BI dashboard using DAX measures, KPIs, slicers, and trend charts for real-time business insights.
Delivered actionable insights that helped optimize inventory, plan marketing campaigns, and improve category-level revenue, resulting in a 12% uplift in sales performance.
4th Power BI Project - Electric Vehicle Analysis
Analyzed EV sales data across brands, models, and regions to track market trends, customer preferences, and sales growth patterns.
Identified that Tesla and Tata EV models contributed the highest revenue and units sold, accounting for over 60% of total sales.
Discovered regional adoption trends — metro cities like Delhi, Mumbai, and Bangalore led in sales, while tier-2 cities showed emerging growth potential.
Developed an interactive Power BI dashboard using DAX measures, KPIs, slicers, and trend/heat maps to visualize monthly sales, market share, and growth metrics.
Delivered insights that helped stakeholders optimize inventory, plan promotional campaigns, and target high-potential regions, supporting strategic market expansion.
5th Power BI Project - Blinkit Sales Analysis
Analyzed Blinkit’s sales data across categories, regions, and time periods to track order volume, revenue trends, and customer behavior.
Identified that Grocery and FMCG categories contributed the highest revenue and order count, accounting for over 65% of total sales.
Discovered peak demand periods — weekends and festival seasons drove 1.5x higher sales compared to regular days.
Developed an interactive Power BI dashboard using DAX measures, KPIs, slicers, and trend charts to visualize sales, top-performing products, and regional performance.
Delivered actionable insights that helped optimize inventory, improve delivery efficiency, and plan targeted promotions, resulting in a significant uplift in order fulfillment and revenue.
1st SQL Project Online Book Store
  • Designed and queried an Online Book Store database using SQL to manage books, customers, and orders, performing data retrieval, filtering, sorting, and aggregation across multiple tables
  • Implemented business-driven SQL queries to analyze sales performance, total revenue, popular genres, top-selling books, high-value customers, and stock availability using JOIN, GROUP BY, HAVING, and aggregate functions
  • Gained hands-on experience in real-world SQL problem-solving, including inventory management, customer behavior analysis, order tracking, and revenue calculation for decision-making support
2nd SQL Project Hospital Data Analysis
  • Built and analyzed a Hospital Management database using SQL to track patients, doctors, departments, admissions, discharges, and medical expenses across multiple hospitals
  • Developed analytical SQL queries to calculate total patients, average doctors per hospital, department-wise patient load, longest hospital stays, city-wise patient distribution, and monthly medical expenses using JOIN, GROUP BY, ORDER BY, and aggregate functions
  • Applied real-world healthcare data analysis concepts such as operational efficiency, resource utilization, and cost analysis to support data-driven decision-making in hospital operations
Professional Experience
Stock Market Analyst Intern
CLIFF MEDIA | July 2023 - August 2023
Ranchi, Jharkhand, India
Gained hands-on experience analyzing market trends, financial data, and investment opportunities in a fast-paced financial services environment. Developed analytical skills through research, data interpretation, and reporting on equity market movements.
  • Conducted market research and analysis on equity performance
  • Created financial reports and presentations for internal stakeholders
  • Utilized Excel for data analysis and trend identification
  • Collaborated with senior analysts on investment recommendations
Education & Academic Foundation
1
Bachelor of Business Administration (BBA) - Honours in Finance
Dr. Shyama Prasad Mukherjee University (DSPMU), Ranchi
October 2021 - July 2024
Comprehensive business education focusing on financial management, business strategy, accounting principles, and data-driven decision-making. Developed strong analytical and problem-solving capabilities through case studies and projects.
2
12th
DAV Public School Kusunda, Dhanabad
Learned Analytical thinking, Problem - solving, Teamwork, Communication, and comuter skills.
3
10th
DAV Public School,Kusunda , Dhanbad
Learning Adaptability.Creativity, Time management .
Professional Certifications
Committed to continuous learning and staying current with industry best practices, I've completed specialized certifications that enhance my business analysis and technical capabilities.
Generative AI for Business Analysts
Advanced training in leveraging AI tools to enhance requirements gathering, process documentation, and analytical workflows.
Modelling for Project Finance
Specialized skills in building financial models for project evaluation, forecasting, and investment decision support.
Data Visualization with Microsoft Power BI
Expert-level training in creating interactive dashboards, data modeling, and storytelling through visual analytics.
AI Chat Prompts for Business
Mastery of prompt engineering techniques to maximize productivity and extract valuable insights from AI tools.
Data Querying with PostgreSQL
Experienced in optimizing queries, handling large datasets and ensuring data accuracy and performance.
Data Analysis with Microsoft Excel
Certified in Microsoft Excel, with advanced expertise in formulas, Pivot Tables, Power Query, and data analysis.
What Sets Me Apart
Finance-First Thinking
My BBA in Finance gives me unique insight into business drivers, allowing me to connect data analysis directly to revenue impact and ROI.
Self-Taught Technical Excellence
I proactively built expertise in Power BI, advanced Excel, and AI tools beyond my formal education, demonstrating adaptability and drive.
Business-Focused Communication
I translate complex technical findings into clear, actionable recommendations that resonate with both technical and non-technical stakeholders.
Ready to Drive Business Impact
I'm actively seeking opportunities to apply my combined finance and business analysis expertise to help organizations optimize processes, unlock insights from their data, and make strategic decisions with confidence.
My ideal role involves collaborating with cross-functional teams, working with large datasets, and delivering solutions that create measurable business value. Whether it's building Power BI dashboards, mapping complex processes, or identifying efficiency opportunities, I'm ready to contribute from day one.
What I Bring
  • Finance background + technical skills
  • Strong problem-solving abilities
  • Passion for continuous learning
  • Results-driven mindset
What I'm Seeking
  • Business Analyst positions
  • Data Analyst opportunities
  • Process improvement projects
Let's Connect
Open to Opportunities
I'm eager to bring my analytical skills, finance knowledge, and technical expertise to a forward-thinking organization. Whether you're looking for a business analyst, data analyst, or someone who can bridge finance and technology, I'd love to explore how I can contribute to your team's success.
Preferred locations: Open to opportunities across India, remote positions, or relocation for the right role.
Phone: 9693129632
Made with