VICKY RAJENDRA RANA

VICKY RAJENDRA RANA

Data Analyst | Power BI Developer | BI Engineer

Mumbai, India

#OpenToWork

About

Results-driven Data Analyst with 1.5+ years of experience delivering actionable business insights through Power BI dashboards, SQL-based data pipelines, and advanced DAX modeling. Proven track record in reducing manual reporting effort by 40% and accelerating decision-making across enterprise environments. Skilled in Power Query ETL, Azure Data Factory, MS Fabric, and Python (Pandas, NumPy). Adept at stakeholder collaboration, data modeling, KPI development, and automating reporting workflows to drive data-driven decision-making.

What I'm looking for

Open for Power BI Developer , Data Analyst , BI Analyst

Experience

Self-Employed

Freelance Data Analyst

Self-Employed

Jan 2026 – Present

• Developed interactive Power BI dashboards integrating SQL, Excel, and Python for sales, profit, and inventory analysis. • Performed data cleaning, KPI creation, DAX optimization, and business insight generation on 50K+ sales records.

Power BISQLPython
Team Computers Pvt. Ltd.

Business Intelligence Developer

Team Computers Pvt. Ltd.

May 2024 – Nov 2025

• Delivered end-to-end sales analytics dashboards for 5+ business units, reducing manual reporting effort by ~40% and improving decision turnaround time. • Developed optimized DAX measures for revenue, profitability, YoY growth, and variance analysis. • Built and maintained scalable data models integrating SQL Server sources via Power Query-based ETL pipelines. • Implemented Row-Level Security (RLS) and incremental refresh strategies to enhance data security and report performance. • Collaborated with business stakeholders to translate requirements into actionable KPIs and dashboards. • Automated dataset refresh and report distribution using Power BI Service and Power Automate. • Interpreted machine learning model outputs and translated statistical results into actionable business insights delivered through Power BI dashboards. • Mentored and guided junior team members on Power BI development, DAX best practices, and data modelling techniques. • Captured and translated business requirements from stakeholder discussions and requirement documents into analytical dashboards and KPI frameworks. • Conducted data validation and profiling to ensure accuracy and consistency of analytical outputs across reporting pipelines.

Power BIDAXSQL ServerSQL
Aivariant

Data Science & Machine Learning Intern

Aivariant

Sep 2023 – Dec 2023

• Conducted EDA on real-world datasets using Python (Pandas, NumPy) to identify trends and generate actionable insights. • Built and evaluated ML models including regression and classification algorithms; improved prediction accuracy through feature engineering and model tuning.

PythonPandasMachine Learning

Education

University of Mumbai

University of Mumbai

B.Sc. Information Technology

2019 – 2022
VIVA Institute of Technology

VIVA Institute of Technology

HSC (Higher Secondary Certificate)

2017 – 2019

Certifications

Python Crash Course

Google

Data Science Certification

ExcelR

IBM Data Science Professional Certificate

IBM / Coursera

Skills

Power AutomateSales AnalyticsMachine LearningNumPyPandasPythonRLSData ModellingSQLSQL ServerPipelinesIncremental RefreshMS FabricAzure Data FactoryETL DevelopmentPower QueryKPI DevelopmentDAXPower BI ServicePower BI

Languages

English (Full professional proficiency)