Shamoon Ansari

Data Analyst

[email protected] +91 8369259981

Resume

Hello, I am

Shamoon Ansari.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

With a passion for data analytics and a background in computer science, I am a dedicated professional adept at leveraging analytical tools and programming languages to derive actionable insights from complex datasets. My experience includes conducting comprehensive sales analyses, optimizing business processes through innovative dashboard solutions, and generating insightful reports to drive informed decision-making. I thrive in dynamic environments where I can apply my expertise in tools like Power BI, Excel, SQL, and Python to unlock valuable insights and drive organizational growth. I am committed to continuous learning and strive to stay updated with the latest trends and technologies in the field of data analytics. My goal is to contribute my skills and knowledge to impactful projects that drive business success and innovation.

Key Skills

Sql

Python

EFFECTIVE COMMUNICATION

STAKEHOLDER MANGEMENT

Problem solving

Power BI

Excel

My Projects

Music Store Analysis

Business Insights 360

Sales and Finance Analytics

Electronics Sales Analysis

Domain/Function: Supply chain

Hospitality Industry Revenue Insights: A Detailed Overview

My Experience

Data Analyst Intern – AtliQ Technologies Live Dashboard
May 2024 – Jun 2024

Executed in-depth analysis using Power BI, revealing crucial insights into revenue, customer behavior trends, city-specific trends, sales modes, and age groups.
Produced 2 reports, leading to a substantial 10% surge in active users and a 15% profit increase, fortifying market standing and financial results.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Tableau Mini

IBM Data Analyst Professional Certificate - Coursera

Python Basics for Data Science - edX

SQL (Basic) Certificate - HackerRank

Letter of Experience I Internship

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/shamoon-ansari/

Call Me

+91 8369259981

GitHub

https://github.com/Shamoonansari

SQL Project

Music Store Analysis

The SQL-based music store analysis project offers strategic insights for business growth by examining geographical expansion, revenue, genre performance, and band popularity.

View Project
on GitHUB

Music Database Schema

Project Overview

Project Details

This SQL project explores music industry insights using a comprehensive dataset. It addresses diverse aspects such as sales analysis, customer behavior, and genre preferences through PostgreSQL and pgAdmin 4, facilitating informed decision-making.

PowerBI Project

Business Insights 360

AtliQ Hardware, a leading consumer electronics company, encounters stiff competition with restricted data utilization, primarily dependent on Excel for reporting. My goal is to introduce a robust Power BI analytics solution, empowering the company to acquire essential insights for more intelligent

View Project
Engagement

View Project
on GitHUB

Other Tools

Sql

Excel

Dashboard's Home Page

Finance View

Project Details

This project seeks to develop a unified, adaptable report accessible to stakeholders across sales, marketing, finance, and executive teams. Emphasis is placed on meeting the diverse needs of each department while ensuring comprehensive insights and user-friendliness.

**Key Focus Areas:**
1. Robust Data Modeling
2. User-Centric Report Design
3. Detailed Drill-Down Insights

**Key Learnings:**
1. Mastery of Power Query (Basic and Advanced Operations)
2. Proficiency in Basic and Complex DAX Formulas
3. Advanced Data Modeling with over 10 Tables
4. Selection of Appropriate Visuals and Formatting Techniques
5. Understanding Principles of Effective Dashboard Design
6. Application of Bookmarking for Enhanced User Experience
7. Deployment Strategies in Power BI Service
8. Integration of Stakeholder Feedback for Continuous Improvement
9. Metrics Analysis in Sales, Marketing, Finance & Supply Chain domains.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

This project encompasses Sales and Finance Analytics aimed at empowering businesses through detailed customer performance reports, market performance comparisons, and comprehensive P&L analyses. The project highlights the significance of data-driven decisions, financial benchmarking.

View Project
on GitHUB

Market Performance vs. Target Report: Helps stakeholders evaluate how well a country is doing compared to set targets over the years.

Customer Performance Report

Project Details

Sales and Finance Analytics project empowers businesses by providing comprehensive reports on customer performance, market comparisons, and financial health. The project focuses on data-driven decision-making, uncovering sales patterns, and facilitating strategic planning. Key objectives include effective discount determination, streamlined negotiations, and market expansion opportunities. It leverages ETL methodology, Power Query, Power Pivot, and DAX for robust data analysis. Additionally, the project emphasizes crafting user-centric reports and optimizing report generation processes.

Python Project

Electronics Sales Analysis

Domain/Function: Supply chain

Explore the Electronics Sales Analysis project, which delves into customer buying patterns and product associations to optimize advertisement display times and enhance cross-selling strategies. Investigating the time of day with the highest order counts, conducting product association analyses.

View Project
on GitHUB

A bar chart illustrating the quantity of various electronic products sold, highlighting high sales for AAA Batteries, AA Batteries, and Lightning Char

A line graph depicting the number of orders placed at each hour of the day, showing peaks around 12 PM and 8 PM.

Project Details

-Time Analysis: Investigated the time of day with the highest order counts to optimize advertisement display times.
-Product Association: Conducted a product association analysis to identify items frequently sold together, aiding in cross-selling and marketing strategies.
-Popular Products: Determined the most popular products based on the quantity ordered, providing insights into customer preferences and market trends.

PowerBI Project

Hospitality Industry Revenue Insights: A Detailed Overview

Created a dynamic Power BI dashboard analyzing RevPAR, ADR, and other key metrics. Explore the interactive dashboard and project details on GitHub. Visit my portfolio for more data-driven projects.

View Project
on GitHUB

Home

Data Model

Project Details

The AtliQ Hospitality Dashboard is a comprehensive data visualization tool designed to provide detailed insights into the performance of various hotel properties within the AtliQ group. The dashboard integrates data from multiple dimensions, allowing users to analyze key metrics and trends that drive business decisions in the hospitality sector.
Key Areas of Focus
1. Interactive Dashboard Development: Created an interactive Power BI dashboard for real-time data analysis.
2. Hospitality Metrics Implementation: Integrated crucial metrics such as RevPAR, ADR, DBRN, DSRN, and DURN.
3. Historical Data Analysis: Analyzed historical data to uncover revenue-enhancing opportunities.
4. Actionable Insights: Provided insights to guide pricing and occupancy decisions.

Skills and Knowledge Acquired
1.Power BI Proficiency: Gained expertise in Power BI for data visualization and analysis.
2.Effective Data Presentation: Improved skills in presenting data to aid strategic decision-making.