Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact

Hello, I am

Aryan Pokhriyal

Data Analyst
Resume
Aryan Pokhriyal

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About

Me

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
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
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
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
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

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Scam Awareness Course

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

Hackerrank SQL Basic

Hackerrank SQL Basic