Portfolio - Aryan Pokhriyal

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About

Step into my digital realm! I'm a data enthusiast on a mission as a Data Analyst. Armed with Excel, PowerBI, and MySQL, I dive into data like an explorer in uncharted territory, uncovering its hidden treasures.

Despite earning my Computer Science and Engineering degree, I found my true calling in data analysis. Through my portfolio projects, I've mastered the art of turning numbers into stories that make sense for businesses.

Currently, I'm interning as a Power BI Developer @ Techtonica where I work with custom Power BI visuals. But now, I'm itching to leap into the thrilling world of data analysis full-time.

Join me on this exciting journey where every click and calculation unlocks new insights. Let's decode the data puzzle together, transforming numbers into actionable strategies that drive success.

Key

Skills

Stakeholder Management

Business Acumen

DAX

Data Visualization

SQL

Power BI

Advanced Excel

Python

Data Modelling

Data Preparation

Deployement and Maintenance of assets

Power BI Service

Business Statistics

requirement gathering

requirement elicitation

My

Projects

Resume Project Challenge 4

Participated in the challenge to write Ad-Hoc queries for Management team of AtliQ Hardwares, deriving insights and helping them to make smart & quick "Data-informed" decisions

Resume Project Challenge 1

Created a Dashboard for the Revenue team of AtliQ Hotels to analyze their position in the Industry and help regain their Market Share and Revenue by providing them with the relevant insights about their hotels business

Business Insights 360

Implementing Power BI for AtliQ Hardware enables advanced analytics, transforming Excel data into actionable insights for informed decision-making, empowering rapid expansion and competitive edge in the consumer electronics market.

Customer Performance Report

Created 2 reports for the Sales department which will help in evaluating Customer Performance and understand their Market Performance with respect to their targets.

My

Experience

Executive Data Analyst, Love In Store Techologies, Gurugram Dec 2025 - Present

Built BI dashboards and reports in Excel to track product availability, visibility, pricing, sales, and in-store metrics
Transformed raw data into structured information for reporting, analysis, dashboard generation, and client consumption
Tools: Excel, Power Query, Excel Dashboards

Power BI Developer Intern, Techtonica, Mumbai Oct 2024 - Aug 2025

Developed and deployed interactive dashboards and custom Power BI visuals to support cross-functional teams in decision-making.
Conducted regression testing to ensure visual and functional integrity of Power BI reports across versions.
Collaborated with Dev and QA teams to document test cases and troubleshoot issues, improving report reliability by 20%.
Tools: Power BI Desktop, Power BI Service, Cusom visuals, Excel

SQL Server Developer, Lannet Infotech LLP, Noida Feb 2024 – May 2024

Wrote efficient SQL queries using DDL, DML, CTEs, subqueries, and various types of joins to support data extraction, transformation, and reporting needs across the team.
Executed and optimized stored procedures in a project involving API database interactions, leading to a 50–60% improvement in application performance and data retrieval speed.
Strengthened understanding of relational database design and performance tuning while collaborating closely with senior developers on production data tasks.
Tools: SQL Server Management Studio (SSMS), Stored Procedures, API Integration, Performance Optimization