Data Analyst · Business Intelligence Specialist · SQL & Power BI Expert

Transforming raw data into actionable business insights. Available for freelance projects and full-time roles.

Aman Sharma in a grey three-piece suit with a maroon tie, standing in a modern office
Aman Sharma in a navy business suit with arms crossed, standing in a bright office

Introduction

About Me

Results-driven Data Analyst with an 8.2/10 GPA (BCA, Kalinga University 2023). Specialized expertise in building interactive Power BI dashboards, writing optimized SQL queries, and automating Excel workflows. Certified by Deloitte, TATA, and Coding Ninjas. Multilingual professional (English C1/C2, Portuguese B1/B2, Hindi Native) passionate about transforming complex datasets into compelling business narratives.

English C1/C2Portuguese B1/B2Hindi Native

Capabilities

Technical Expertise

Data Visualization

  • Power BI (Advanced)
  • Tableau (Basic)
  • DAX Measures
  • Executive Dashboards

Database & SQL

  • MySQL (Advanced)
  • SQL Server
  • Query Optimization
  • JOINs, CTEs, Window Functions

Excel Mastery

  • Pivot Tables
  • VLOOKUP & INDEX-MATCH
  • Macros / VBA
  • Power Query & Power Pivot

Data Processing

  • ETL Pipelines
  • Data Cleaning
  • Statistical Analysis
  • Data Governance

Tools

  • Microsoft Office Suite
  • Google Workspace
  • Git
  • Jupyter Notebook & Anaconda

Python for Analytics

  • Pandas & NumPy
  • Data Cleaning with Python
  • Matplotlib & Seaborn
  • Automation Scripts

AI Automation

  • AI-powered Excel insights
  • ChatGPT / Copilot for analytics
  • Automated reporting workflows
  • Prompt engineering for data tasks

Credentials

Professional Certifications

Deloitte Data Analytics Job Simulation

July 2026

Hands-on business analytics: forensic data review, dashboard building and translating findings into client-ready recommendations.

TATA Data Visualization Certification

July 2026

Designing insight-led visuals for executive audiences, choosing the right chart for the question and framing data stories for leadership.

Coding Ninjas Excel Excellence — Top Performer

June 2026

Advanced Excel workflows: nested lookups, Power Query transformations and macro automation, finishing as a top-performing participant.

Selected work

Portfolio Projects

Deloitte Data Analytics Simulation

Analyzed complex business datasets, developed interactive Power BI dashboards with advanced DAX, delivered strategic recommendations resulting in 15% simulated cost reduction.

Power BIDAXBusiness Analysis

TATA Data Visualization Project

Designed executive-level dashboards and created automated reporting solutions reducing manual generation time by 40%.

VisualizationReportingDashboard Design

MySQL Data Analytics Portfolio

Built a comprehensive relational database with 10+ normalized tables, wrote complex SQL queries (JOINs, CTEs, Window Functions) and optimized query performance by 30%.

MySQLDatabase DesignQuery Optimization

Dashboard Projects

Interactive Power BI Dashboards

Three real dashboards I designed and built end to end — from data modeling to the final interactive report.

FIFA World Cup Analytics 1930–2026 — Power BI dashboard preview

FIFA World Cup Analytics 1930–2026

A full tournament intelligence dashboard covering 22 World Cups, 964 matches and 2,720 goals. It tracks the most successful nations, average attendance and goals evolution since 1930, and previews the 2026 edition with matches by stage, stadium distribution and the full match schedule timeline. Six slicers (stage, stadium, year, host country, match date, champion) make every visual fully interactive.

Power BIDAXData ModelingSports Analytics
View full dashboard
Amazon Sales Performance Dashboard — Power BI dashboard preview

Amazon Sales Performance Dashboard

An executive retail performance dashboard tracking 2K customers, 2.5K orders and 261M in sales with 5.2% growth and a 4.27 average rating. It breaks down quantity by category, orders by payment method, delivery days vs. seller rating, monthly sales trends, top products and sales by category across four regions — with category, month and region filters for drill-down analysis.

Power BIRetail AnalyticsKPI TrackingTrend Analysis
View full dashboard (PDF)
IPL Analysis 2008–2025 — Power BI dashboard preview

IPL Analysis 2008–2025

A season-deep cricket analytics dashboard covering 74 matches across 10 teams and 14 venues. It highlights the 2025 season winner and runner-up, Orange Cap and Purple Cap leaders, highest fours and sixes, and a complete points table with played, won, lost and net-result breakdowns per franchise.

Power BISports AnalyticsData StorytellingVisual Design
View full dashboard (PDF)

Impact

What I've Accomplished

15+

Interactive Power BI dashboards built

50+

SQL queries optimized

20+

Hours saved monthly via Excel macros

40%

Reduction in report generation time

Get in touch

Let's Work Together

Open to Data Analyst and BI roles — including freelance projects — all over the world.