Portfolio - Dar faraz rashid

1

Excel
Project

2

PowerBI
Projects

About

Data Analyst skilled in leveraging SQL, Excel, and Power BI to analyze operational performance, optimize workflows,
and drive data-driven decision-making. Experienced in integrating data from multiple sources (Excel/CSV, SQL databases)
to create interactive dashboards and KPI reports that improve process visibility and efficiency. Proven success in supporting
cross-functional teams, streamlining reporting systems, and contributing to measurable gains in productivity and cost
savings through actionable insights.

Key

Skills

Advanced Microsoft Excel

Airlines operations and planning analytics

MySQL

Power BI

Business Analytics

Data Modelling

Project Management

My

Projects

AtliQ sales and finance analytics, AtliQ Hardware's .

Domain/Function: Sales and finance analytics.

Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables
and DAX to provide granular insights into revenue streams and expense categories while applying data analysis frameworks and
critical thinking skills.

Business Insights 360, AtliQ Hardware's.

Domain/Function: Sales, finance and supply chain analysis.

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by
gathering data from 2 different sources (Excel/CSV files and a SQL database), integrating spreadsheets and programming
languages for accurate data analytics.

Airlines operations and planning Analysis

Domain/Function: Airline Operations and planning

Airline Operations and Planning Analysis Using MySQL, Microsoft Excel, and Power BI.
This project gave me a deep, practical understanding of operations analytics, especially in performance measurement, resource planning, and process optimization—all essential for data-driven business environments.

My

Experience

EXPERIENCE
Atliq Technologies
Data Analyst Intern Oct '25—Nov '25 Remote, India

1. Designed and deployed Power BI dashboards for telecom and insurance clients, including Wavecon Telecom’s 5G impact analysis and Shield Insurance’s customer & revenue intelligence dashboard, featuring segmentation by age group, city, sales mode, and policy performance to support strategic decision-making.

2. Performed end-to-end data cleaning, modeling, and SQL query debugging to deliver accurate reporting on total customers, total revenue, daily revenue & customer growth rates, month-over-month policy changes, sales-mode contribution, and age-based revenue behavior, improving analytical reliability.

3. Enhanced reporting efficiency by implementing slicers, drill-through pages, and KPI view switches (revenue and customer growth), and automated Power BI refresh and distribution via Power Automate, increasing stakeholder access to real-time operational insights and boosting dashboard adoption.

Tech Mahindra

Associate Trainee Nov '24—Jan '25 Noida, India

Enhanced data accuracy by standardizing Power Query data transformation processes; lowered reporting errors by 20% and freed up 5 hours per week for value-added data analysis and problem solving.
Standardized data cleaning procedures with Power Query, removing inconsistencies across three large datasets and ensuring alignment with reporting requirements, knowledge sharing practices, and improved data governance frameworks for future projects.
Delivered monthly PowerPoint presentations summarizing key performance indicators and actionable insights that supported strategic decision-making.

Caddex India

Data Analyst Intern May '24 — Aug '24 Srinagar, India

Spearheaded data cleansing and modeling of student demographic information using Advanced Excel and Google Spreadsheets, generating reports on student performance and attendance that enhanced data integrity by 99% while strengthening digital skills and critical thinking.
Generated reports on student performance, attendance, and other academic metrics using Advanced Excel, Power BI, MySQL, and programming languages, providing summarized insights for strategic decision-making and supporting business units with practical data analytics solutions.
Contributed to a 30% improvement in academic performance through actionable data insights and recommendations.