Back to Developers
Aayush Rana

Aayush Rana

Data Analyst

Zirakpur, Punjab, India 3+ yrs exp 91 · Outstanding

About

Results-driven Data Analyst with 2+ years of experience in business intelligence, analytics, and AI-assisted workflows. Specializes in Power BI, SQL, Python, Excel. Transforming complex datasets into actionable dashboards and leveraging generative AI tools to accelerate reporting, automate insights, and empower data-driven decision-making. Proven track record of measurable impact across cross-functional teams.

Skills & Expertise (38)

Power BI Advanced
8.7/10
2
Years Exp
SQL Advanced
8.5/10
2
Years Exp
DAX Advanced
8.0/10
2
Years Exp
Python Intermediate
7.1/10
2
Years Exp
ETL Team Collaboration Data Pipelines Agile Scrum Requirement gathering UAT ChatGPT Claude Microsoft Copilot Prompt Engineering AI-assisted data analysis Machine Learning Stakeholder Management Analytical Thinking Problem-solving Client Management Seaborn Data Modeling Tableau Advanced Excel Pivot Tables Power Query Pandas NumPy Matplotlib Confluence SQL Server MySql SAP HANA Azure Synapse Analytics Power Automate Power Apps Jira

Work Experience

Data Analyst

Orbit & Skyline Semiconductor

May 2023 - Present

Gathered and analyzed business requirements from stakeholders, translated them into scalable BI solutions deployed across leadership teams. Designed, developed, and deployed interactive Power BI dashboards, improving decision-making speed for senior leadership. Optimized data models, DAX measures, and query performance - achieving a 40% improvement in dashboard load time. Led User Acceptance Testing (UAT) with business users to ensure accuracy, usability, and full alignment with requirements. Automated workflows using Power Automate and Power Apps, reducing manual effort by 80%+. Designed and optimized SQL queries for large-scale data processing and enterprise reporting pipelines. Leveraged AI tools (ChatGPT, Copilot) to accelerate DAX formula writing and SQL query optimization, reducing development time by approximately 50%.

Education

Master of Business Administration (MBA) - Business Analytics - Chandigarh University

2025 - 2027 · Afghanistan

Bachelor of Science (B.Sc.) - Statistics - Panjab University

2019 - 2022 · Afghanistan

Certifications

Data Science with Python

Techedo Technologies Pvt. Ltd. · 2023

Machine Learning

Kaggle · 2023

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 11/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 91/100

Profile Overview

Member sinceMay 2026