Mohd Ashfaq Ahmed

Data analyst

[email protected] +971 0506086930

Resume

Hello, I am

Mohd Ashfaq Ahmed.

3

PowerBI
Projects

2

SQL
Projects

About Me

I'm Mohd Ashfaq Ahmed, your go-to Data Analyst with a passion for uncovering insights within data. With a toolkit including Excel, SQL, Power BI, and Python, I transform raw information into actionable intelligence.

Over my journey, I've evolved from a seasoned Quality Analyst at Sutherland, reducing advisor opportunities by 35%, to a Data Analyst working on exciting projects. I've crafted Power BI dashboards that aggregate millions of records seamlessly and optimize report efficiency. My expertise extends to visualizing dynamic revenue insights for the hospitality industry and conducting comprehensive market analyses.

I excel in Excel, thrive in SQL, and harness Power BI's potential. My goal is to drive data-driven decision-making and foster business growth.

Let's connect and explore how my analytical skills can make a significant impact. Here's to a future powered by data. Cheers!

Key Skills

pandas

SQL

Snowflake

AWS

My Projects

Business 360 Insights

HR Analytics

Insights to Management in Consumer goods domain

Comprehensive Business Analytics and Forecasting with SQL

Hospitality Insights: Unraveling Revenue and Guest Metrics with Power BI

Awards & Certificate

Excel Skills Virtual Experience Program

Building Interactive Dashboard using Google Looker

Foundations: Data, Data, Everywhere

Pwc Switzerland - Power BI Virtual Case Experience

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

Call Me

+971 0506086930

GitHub

https://github.com/ashfaqark

PowerBI Project

Business 360 Insights

A power BI dashboard for AtliQ Hardware: Empowers data-driven decision-making by analyzing 1.8M records. Provides real-time insights into Sales, Finance, Marketing, and Supply Chain, aiding executives in reviewing market performance and optimizing business strategies.

Finance Dashboard: Track net sales trend over time with a line chart. Analyze gross margin %, net profit %, and PnL statement for insights. Identify

Sales Dashboard: Uncover customer performance with net sales, gross margin, and GM%. Dynamic scatter plot compares net sales and gross margin for las

Project Details

AtliQ Hardware's Power BI project is a robust data-driven solution transforming 1.8 million records into actionable insights. Utilizing Power Query and DAX, it creates department-specific dashboards (Sales, Finance, Marketing, Supply Chain) and an executive-level overview.

Through data cleaning and calculated columns, the dashboards offer real-time analytics, evaluating performance across departments. Dynamic PnL statements provide insights into revenue, expenses, and profitability, aiding market trend analysis and informed decisions.

Interactive visualizations enable effortless data exploration, identifying critical performance indicators. The project's flexibility adapts to evolving business needs, driving growth and operational optimization.

Consolidated and visually engaging reports empower resource allocation, identifying improvement areas for market leadership.

Improved data visibility enhances data-driven decisions, fostering success in a dynamic business landscape.

Live Interactive Dashboard

PowerBI Project

HR Analytics

HR Analytics Dashboard: Track Present %, WFH %, and Sick Leave % KPIs. Employee-wise insights and trends over months for data-driven decisions. Identify top weekdays with the highest KPI %.

Major KPI's for employee attendance insights that are very helpful for the HR.

Main dashboard showcasing the important KPI's along with other insights. Such as, Trend over time of different KPI's. Impacted weekdays for KPI's.

Project Details

The HR Analytics Dashboard is a powerful solution that consolidates data from three Excel files into a comprehensive view. Leveraging DAX measures, it computes Present %, WFH %, and Sick Leave % KPIs, providing real-time insights into workforce performance.

By presenting employee-wise insights and trends over months, the dashboard facilitates data-driven decision-making for HR teams. Identifying top weekdays with the highest KPI % enables focused strategies to optimize attendance and productivity.

This project streamlines HR analytics, simplifying complex data for actionable takeaways, enhancing workforce management, and fostering a productive work environment.

Live Interactive Dashboard

SQL Project

Insights to Management in Consumer goods domain

SQL Project: Utilized SQL queries to analyze 10 ad hoc requests for Atliq Hardwares, presenting valuable insights that drive data-informed decisions and optimize business strategies.

View Project
on GitHUB

For AtliQ Hardwares ((imaginary company)), I successfully tackled 10 ad hoc requests using MySQL to gain valuable data insights. The objective was to

Queries that showcase the list of markets and Unique products.

Project Details

Throughout the project, I honed my SQL skills, data analysis techniques, and communication abilities. The main challenge was handling complex data queries efficiently to derive meaningful insights for various business scenarios. My work on the Atliq Hardwares SQL project demonstrated my proficiency in SQL and data analysis techniques. By successfully handling 10 ad hoc requests, I showcased my ability to make data-informed decisions for top-level management. This project has been a valuable learning experience, enhancing my technical and communication skills as a data analyst. I am excited to contribute my expertise to future projects and drive data-driven success for organizations.

SQL Project

Comprehensive Business Analytics and Forecasting with SQL

This SQL project analyzes a fictional database, generating reports on product sales, forecasting accuracy, top-performing markets, customers, and products based on net sales. It also includes a stored procedure to assign badges to markets based on total quantity sold in a specific fiscal year.

View Project
on GitHUB

Track monthly individual product sales for Croma India customer in FY-2021 to analyze performance and conduct product analytics using SQL.

Designed a database system with stored procedures, functions, and views to streamline data management and enable efficient querying and reporting.

Project Details

This project involves working with a fictional database to perform various data analysis tasks using SQL queries. It includes generating reports on individual product sales for a specific customer, forecasting accuracy, top-performing markets, customers, and products based on net sales. Additionally, the project includes the implementation of stored procedures to assign badges (Gold or Silver) to markets based on the total quantity sold in a specific fiscal year. Overall, the project showcases SQL skills for data manipulation and provides valuable insights for decision-making and business analysis.

PowerBI Project

Hospitality Insights: Unraveling Revenue and Guest Metrics with Power BI

Powerful Hospitality Dashboard: Analyzing KPIs, Revenue, and Trends with Data Insights. Empowering Hotels to Optimize Performance and Drive Informed Decisions.

View Project
on GitHUB

Powerful Hospitality Dashboard: Analyzing KPIs, Revenue, and Trends with Data Insights. Empowering Hotels to Optimize Performance and Drive Informed D

This is a data model for hotel bookings with DAX measures and table relationships.

Project Details

Enhanced Hospitality Dashboard: Leveraging Data Insights to Track KPIs, Revenue, and Trends in the Hospitality Industry. Empowering Hotels to Optimize Performance, Enhance Customer Experience, and Drive Informed Decisions. A showcase of advanced data analysis, visualization, and DAX calculations skills. Valuable tool for hotels to monitor their operations and make data-driven strategies.