Portfolio - Mohammad Ayaan alam

Mohammad Ayaan alam

MIS Analyst

Resume

1

Excel Project

1

SQL Project

2

PowerBI Projects

1

Python Project

About Me

A passionate Data Analyst with strong experience in transforming raw data into meaningful insights that support informed business decisions. Currently working as a MIS Executive at AuthBridge, designing interactive Excel dashboards, automating reports using SQL, and performing data analysis with Python to improve accuracy and efficiency.
Also working as a Data Analyst at Arnav Engitech, managing large datasets and delivering actionable insights to support cross-functional teams. Previously completed a Data Analyst Internship at AtliQ Technologies, where Power BI dashboards were developed, SQL reports optimized, and DAX used to track KPIs effectively.
Actively engaged in continuous learning through real-world projects such as Business Insight 360, Hospitality Revenue Insights, and Diwali Sales Analysis, focused on solving business problems using data.
Skills: Power BI, Python (Pandas, NumPy), MySQL, Advanced Excel, QuickSight
Expertise: Data Visualization, Dashboarding, BI

Key Skills

MySql

Problem Solving

C Language

Python

Data storytelling

Numpy & Pandas

Advance Excel

QuickSight

Power BI

Power Query

My Projects

📊 𝐒𝐚𝐥𝐞𝐬_𝐀𝐧𝐝 𝐅𝐢𝐧𝐚𝐧𝐜𝐞_𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 📊

📤𝐒𝐐𝐋-𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 📤

🎉𝐒𝐡𝐢𝐞𝐥𝐝 𝐈𝐧𝐬𝐮𝐫𝐚𝐧𝐜𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜🎉

🎉𝐇𝐨𝐬𝐩𝐢𝐭𝐚𝐥𝐢𝐭𝐲 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐚𝐭 𝐀𝐭𝐥𝐢𝐐 𝐆𝐫𝐚𝐧𝐝 🎉

🎯𝐃𝐢𝐰𝐚𝐥𝐢 𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 -𝐏𝐲𝐭𝐡𝐨𝐧🎯

My Experience

Management Information System (MIS) Executive

AuthBridge | Gurugram, Haryana
Jul 2025 – Present

Designed and maintained interactive Excel dashboards to track key business metrics and performance trends.
Automated data extraction and reporting workflows using SQL, reducing manual effort and errors.
Performed data cleaning, transformation, and analysis using Python (Pandas) to ensure data accuracy.
Collaborated with stakeholders to deliver actionable insights supporting strategic decisions.
Improved reporting efficiency and data reliability through process optimization.

Data Analyst

Arnav Engitech
Jun 2025 – Jul 2025

Managed and analyzed large Excel datasets to support data-driven decision-making across departments.
Optimized reports and dashboards to improve clarity, usability, and business impact.
Identified trends and patterns to support operational and management-level insights.

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

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

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

Power BI Virtual Case Experience

Data Analytics and Visualization Virtual Experience

SQL

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/mohammad-ayaan-alam-473187232

Call Me

+91 6202741771

GitHub

https://github.com/mohammadayaan07

Excel Project

📊 𝐒𝐚𝐥𝐞𝐬_𝐀𝐧𝐝 𝐅𝐢𝐧𝐚𝐧𝐜𝐞_𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 📊

Excited to share the Sales Report of Atliq Hardware, offering key insights into yearly product sales. Leveraged advanced Excel, Pivot Tables, DAX Measures, and Power Query for data transformation. Committed to Atliq Hardware's success!

View Project
Engagement

View Project
on GitHUB

Analyzing the Growth of Top 10 Products: 2020 to 2021

Highlighting the Top 5 and Bottom 5 Products Sold - Quantity.

Project Details

📊 **Marketl Analysis** 📊
Sales Report of atliq hardware yearly wise. To give hard-ware atliq hardware to understand their growth and downfall of their products.

🖇️Key highlights:
🔝 **Top 10 Net Sale Products (2020-2021)** 🔝
📊 **Division Report** 📊
📈 **Top 5 and Bottom 5 Product Sold (Quantity)** 📉
🆕 **New Products began selling in 2021** 🆕
🌍 **Top 5 Countries by Net Sales in 2021** 🌍

📚 **Skills Utilized** 📚
- This is a report that involves sophisticated excel skills.
- Pivot Tables for data summarization
- DAX Measures for calculated metrics
- Power Query for data transformation.

🚀 We're committed to helping Atliq Hardware achieve greater success! 🚀

SQL Project

📤𝐒𝐐𝐋-𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 📤

Presenting the Finance Analysis Report for Atliq Hardware's Croma Product. Developed product-wise sales reports, implemented sophisticated SQL procedures, and leveraged advanced SQL techniques for powerful data analysis. Our commitment to delivering comprehensive financial insights.

View Project
Engagement

View Project
on GitHUB

Croma FY2021 Sales Report: Uncover Key Business Trends!

Croma India's Annual Sales Report: A Year in Review

Project Details

Finance Analysis Report: Improving Atliq Hardware’s Croma Product Sales. Sophisticated SQL expert procedures for powerful data insights. Ready to bring financial mastery to your team!
🖇️ **Key Highlights** 🖇️
➡️Developed a product-wise sales report for Monthly Product Transactions in
Croma India for FY 2021.
➡️Crafted a sophisticated stored procedure to categorize markets as "Gold" or
"Silver" based on total sold quantity (Gold for > 5 million, Silver otherwise).
➡️Implemented User-Defined SQL Functions to extract fiscal year information
from date columns.
➡️Conducted joins between 'fact_gross_price,' 'dim_product,' and
' fact_sales_monthly' tables, yielding essential fields.
➡️Calculated the total sold quantity for a given market in a specific year by
multiplying Sold_qty with Amount.

📚 **Skills Utilized** 📚
- Advanced SQL Functions
- Stored Procedures
- Joins
- SQL for Business Analytics

PowerBI Project

🎉𝐒𝐡𝐢𝐞𝐥𝐝 𝐈𝐧𝐬𝐮𝐫𝐚𝐧𝐜𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜🎉

I am very thrilled to unveil my #codebasicsvirtualinternship project. Design powerful dashboards for Shield Insurance, enhancing client communication, mockup construction, instant modifications, dashboard innovation, and refining Power BI expertise, and ability.

View Project
Engagement

View Project
on GitHUB

Insights into Shield Insurance's Overall Performance

Analyzing Age Demographics: Key Insights for Shield Insurance

Project Details

📈 Objective: Pivotal dashboards on revenue (📊), age groups (👥), and sales (🚀) driven from large datasets. Clear business understanding based on exact data-driven decisions.

💡 Key Insights:
- 📊 March 2023: Peak revenue and customer surge.
- 👥 31-40 age group: Important for revenue growth and customer addition.
- 🌆 Delhi NCR: Leading by revenue and customer metrics.
- 🤝 Offline agents: Champions in customer generation.
- 📈 Offline-direct and online app modes: Showcasing consistent growth.
- 🏆 POL4321HEL policy: A customer favorite, propelling success. 🚀

🌟 Key Skills Gained:
Efficient communication with clients, effective mockups creation, smooth flow of progress updates, artistic designs for dashboards, eye-catching presentations to clients, and proficient power BI dashboard development. Providing data visualization to take business above.

Project video

Live Interactive Dashboard

PowerBI Project

🎉𝐇𝐨𝐬𝐩𝐢𝐭𝐚𝐥𝐢𝐭𝐲 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐚𝐭 𝐀𝐭𝐥𝐢𝐐 𝐆𝐫𝐚𝐧𝐝 🎉

The Codebasics’ Resume Challenge and Dynamic Data Analysis Journey at AtliQ Grands. Developing metrics, dashboarding using PowerBI & deriving insights of a famous consumer brand operating in a tough environment. Let us get down to Business Intelligence so their market share & revenue is re-energized

View Project
Engagement

View Project
on GitHUB

🏨Unveiling Business Insights at AtliQ Grands 🏨

Revenue Breakdown: Analyzing Income Streams

Project Details

AtliQ Grands, it is my pleasure to welcome you into my 🚀 hospitality data analysis in Codebasics ‘s Resume Challenge.

**AtliQ Grands Background:**
- Facing problems caused by fierce rivalry and some missteps of upper management at a well-established company known globally for over 20 years.

**Business and Data Intelligence Initiative:**
- To combat declining market share and revenue, the managing director aims to incorporate Business and Data Intelligence.

**Task Overview:**
- 🎯 Hired as a data analyst to analyze sample data and create insights using Power BI and Power BI App.

**Key Responsibilities:**
- 🔍 Create metrics based on the provided list.
- 📊 Design a mockup dashboard based on stakeholder needs.
- 🔍 The additional insight on what lies beyond the requirement is uncovered by this project manager.
**Tools Used:**
- 🛠️ Leveraging the power of Power BI and Power BI App for efficient data analysis.

Project video

Live Interactive Dashboard

Python Project

🎯𝐃𝐢𝐰𝐚𝐥𝐢 𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 -𝐏𝐲𝐭𝐡𝐨𝐧🎯

Unveiled Diwali sales trends using Python, Pandas, and NumPy. 🚀 Key insight: Married women (26-35) in IT, Healthcare, and Aviation from UP, Maharashtra, and Karnataka are prime consumers. 🎯 Top choices: Food, Clothing, Electronics. 🛒 Female buyers dominate with robust purchasing power.

View Project
Engagement

View Project
on GitHUB

"Unveiling the Impact of Customer Age Groups on Business Success"

"Revenue Insights: Unveiling the Power of Top 10 States in Driving Total Sales Performance"

Project Details

1. **Data Transformation:
- Utilized Python with JupyterNotebook.
- Transformed raw data into an insightful full report.
- Employed pandas and numpy for efficient data handling.
2. **Data Cleaning:
- Executed thorough data cleaning using pandas and numpy.
- Addressed missing values, outliers, and inconsistencies.
3. **Conclusion:
- 🎉 Married women (26-35 yrs) from UP, Maharashtra, and Karnataka in IT, Healthcare, and Aviation sectors are the primary consumer base.
- 💼 These professionals are inclined towards purchasing products from Food, Clothing, and Electronics categories
4. **Insights:
- Identified key demographic insights:
- Target audience: Married women.
- Age group: 26-35 years.
- Regions: Uttar Pradesh, Maharashtra, and Karnataka.
- Industries: IT, Healthcare, and Aviation.
5. **Consumer Behavior:
- Preferred product categories: Food, Clothing, and Electronics
6. **Tools Used:
- JupyterNotebook for interactive data analysis