Abhijeet Anand

Data Analyst

SQLPythonPower BITableauAdvanced ExcelData VisualizationData CleaningData Modeling

Professional Summary

Detail-oriented Data Analyst with hands-on experience in SQL, Power BI, Excel, Tableau, and Python. Skilled in data ETL, data cleaning, DAX, Power Query Editor, and building interactive dashboards to generate actionable insights.

Developed end-to-end projects including FMCG Supply Chain Analytics, E-commerce Sales Dashboard, Retail Analysis, and Customer Churn Prediction, focusing on KPI tracking, trend analysis, and business decision support. Experienced in writing optimized SQL queries, creating data models, and designing visually compelling reports.

Location

Noida, Uttar Pradesh, India

Availability

Open to Data Analyst | BI Developer Roles

Core Technical Skills

SQL

Data extraction, Joins, CTE, Aggregations & Window Functions, Query Optimization, MySQL

Power BI

Import Data, DAX, Power Query, Data modeling, Calculated Columns, Interactive Dashboards, Drill-through Reports

Excel

Data analysis, Data Cleaning, Pivot Tables, Pivot Charts, VLOOKUP, INDEX-MATCH, Conditional Formatting

Tableau

Data visualization, Dashboard creation, Parameters, Table Calculations, Filters & Actions, Interactive Reporting

Python

Pandas, NumPy, Data Cleaning, Data Manipulation, EDA, Data Visualization, Matplotlib, Seaborn

Advanced Tools

Google Sheets, Looker Studio, Data Modeling, ETL Processes

Professional Experience

1. Data Analyst

Xapotech Systems Pvt. Ltd. | October 2024 - Present

Detail-oriented Data Analyst with hands-on experience in SQL, Power BI, Excel, and Tableau. Built 5+ interactive Power BI dashboards with DAX and drill-through reports. Executed complex SQL queries for data extraction, validation, and business reporting. Performed ETL processes to clean and integrate data from multiple sources.

2. Operations & Data Support Associate

Shanti Eco Green | February 2022 - January 2024

Managed inventory datasets and prepared weekly and monthly Excel reports. Assisted with data operations and reporting workflows. Supported business decision-making through organized data tracking and analysis.

3. Data Operations & SQL Associate

Exclusife Techosoft | February 2017 - January 2020

Supported data operations and SQL-based reporting workflows. Helped maintain accurate datasets and deliver reliable outputs for internal use. Gained foundational experience in data processing and reporting.

Project Portfolio

Developed end-to-end dashboards and analytics solutions across multiple domains, focusing on KPI tracking, trend analysis, and business decision support.

1. FMCG Supply Chain Analytics

End-to-end analytics on 100,000+ retail records across 3 interactive dashboards. Analyzed ₹39.3M+ revenue, ₹7.87M+ profit, 99.9K orders, 299K+ units sold. Tools: MySQL, Python, Power BI, Tableau

2. E-Commerce Sales & Profit Dashboard

6-page Power BI dashboard tracking ₹28.4M revenue, 99K orders, 95K customers. Analyzed customer behavior, sales trends, logistics, payment methods, and sentiment. Tools: Power BI, DAX, Power Query, SQL

3. Sales & Customer Analytics (Decathlon)

Interactive Excel dashboard on 30K+ records using 15+ Pivot Tables. Automated data transformation, KPI reporting, and customer segmentation with advanced Excel techniques.

4. Customer Churn Prediction

Analyzed 7,043 telecom customer records using Python. Performed data cleaning, EDA, feature engineering, and customer segmentation. Identified key churn drivers and retention strategies.

5. Web Scraping & Data Analysis

Scraped 1,000+ book records using Selenium and Python. Performed data cleaning, EDA, and feature engineering. Extracted insights on titles, prices, ratings, and availability.

Key Achievements

End-to-End Project Development

Built interactive Power BI & Tableau dashboards and performed exploratory data analysis (EDA) to support data-driven decision making across multiple business domains.

Data Pipeline Expertise

Experienced in working with large datasets, building data pipelines, and transforming raw data into meaningful insights to support business decisions.

Optimized Query Performance

Skilled in writing optimized SQL queries, creating data models, and designing visually compelling reports in Power BI & Tableau with strong understanding of data visualization best practices.

Business Impact

Analyzed 39.3M+ in revenue, processed 100K+ records, and built 5+ interactive dashboards that directly supported business decision-making and KPI tracking.

Education

01

Bachelor of Science in Information Technology

Kuvempu University | 2014

02

Diploma in Software Engineering

NIIT | 2010

03

Data Analytics & Data Science Program

Croma Campus | 9 months, 2024

Comprehensive training in SQL, Python, Power BI, Tableau, Advanced Excel, Data Modeling, ETL Processes, and Machine Learning fundamentals.

Technical Expertise

Data Engineering

  • Data pipeline development
  • Large dataset processing
  • ETL processes
  • Data transformation
  • Query optimization

Data Analysis

  • Exploratory data analysis (EDA)
  • Trend identification
  • KPI tracking
  • Business intelligence
  • Statistical analysis

Data Visualization

  • Power BI dashboard creation
  • Tableau reporting
  • Data storytelling
  • Interactive visualizations
  • Report design

Programming & Tools

  • SQL querying and optimization
  • Python (Pandas, NumPy, Matplotlib, Seaborn)
  • Excel pivot tables and automation
  • DAX and Power Query
  • Google Sheets and Looker Studio

Professional Approach

Data-Driven Decision Making

Passionate about turning raw data into meaningful insights to drive business growth. Strong understanding of data visualization best practices and business intelligence concepts.

Problem-Solving Mindset

Focusing on improving analytical and problem-solving skills. Actively looking for opportunities to contribute to business decision-making through data.

Continuous Learning

With a strong technical background in Data Analysis and growing expertise in analytics, aiming to bridge the gap between data and business insights. Committed to staying updated with latest tools and methodologies.

Let's Connect

Available to join immediately. Open to Data Analyst, BI Developer roles.

Phone

+91 8789462118

Location

Noida, Uttar Pradesh, India

Made with