Back to Developers
Yassir Arafath

Yassir Arafath

Financial Analyst

Bangalore 85 · Excellent

About

MBA Finance professional with hands-on experience in financial analysis, MIS reporting, budgeting, forecasting, and variance analysis. Strong expertise in Advanced Excel, Power BI, Tableau, and dashboard automation to support management decision-making. Experienced in KPI tracking and data-driven financial reporting.

Skills & Expertise (23)

Power BI Advanced
8.9/10
3
Years Exp
Tableau Advanced
8.3/10
3
Years Exp
Financial Analysis Advanced
8.1/10
3
Years Exp
Pivot Tables Attention to Detail Business Communication Analytical Thinking Financial Statement Analysis Financial Reporting Data Consolidation PowerPoint Dashboards Power Query HLOOKUP VLOOKUP Advanced Excel Management reporting KPI Tracking Variance Analysis Forecasting Budgeting MIS Reporting FP&A

Work Experience

Sales & Profitability Dashboard Developer

E-Commerce

Present - Present

Built an interactive Power BI dashboard analysing ₹438K+ total sales, 5,615 units sold, and ₹37K profit, providing a consolidated view of business performance. Created KPI cards for Sales, Quantity, Profit, and ₹121K Average Order Value (AOV) to support quick management decision-making. Conducted monthly profit trend analysis, identifying 4 loss-making months (May–August) and recovery trends in Q4, enabling profitability insights. Analysed payment mode distribution, revealing COD dominance at 43.7%, followed by UPI (20.6%) and Cards (25%+), highlighting cash-flow risk areas. Delivered category-level insights, identifying Clothing as the top category (62.6% of quantity sold), supporting product-mix optimisation.

Financial Performance Dashboard Developer

McDonald’s

Present - Present

Developed an end-to-end Tableau dashboard to evaluate 20-year financial performance (2002–2022), focusing on growth, margins, capital structure, and shareholder returns. Performed trend and variance analysis, identifying Revenue CAGR-driven growth of 50.6% and EPS expansion of 370.5%, reflecting pricing power and operating leverage. Evaluated profitability ratios, observing Operating Margin improvement from 10.7% to 39.3%, indicating strong cost control and efficiency gains. Analysed balance sheet and capital allocation, comparing Total Assets growth ($23.9B → $50.4B) with debt levels to assess financial leverage, liquidity, and ROIC improvement.

Sales & Customer Analytics Dashboard Developer

Retail

Present - Present

Analysed 31,000+ transactions covering 12 months of retail sales and order data using Power BI. Tracked monthly sales vs order volume, identifying peak performance during Q1–Q2 and toward year-end. Identified customer gender contribution, with women accounting for 64% of total orders and revenue. Assessed order fulfilment efficiency, where 92% of orders were successfully delivered, with the remaining 8% comprising cancellations, returns, and refunds. Evaluated 6 sales channels, with Amazon (35%), Myntra (23%), and Flipkart (22%) contributing the majority of orders, and identified the Top 5 states and cities driving overall sales.

Education

MBA in Finance & Business Analytics - Reva University

2023 - 2025 · Afghanistan

Certifications

Managing Clean Core for SAP S/4HANA Cloud

· 2025

Microsoft Power BI for Data Analysis and Visualization

· 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceApr 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation