Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Fardeen Alam Khan

North Strathfield,NSW

Summary

Skilled and detail-oriented Business Administration graduate from Macquarie University, specializing in data analysis and visualization with advanced proficiency in SQL, Tableau, Excel, and Power BI. Possessing strong analytical thinking, ETL processes, and data-driven decision-making skills. Seeking to leverage expertise in data manipulation, insights generation, and strategic analysis in a Business Analyst role, aiming to contribute to informed decision-making and business optimization

Overview

2
2
years of professional experience

Work History

Console Operator

7-Eleven
Wynyard, NSW
04.2023 - Current
  • Performed routine maintenance on the console including cleaning and inspecting components.
  • Created daily reports detailing any operations performed on the console.
  • Executed testing strategies to improve systems, databases and processing techniques.
  • Monitored console for alarms and system performance issues.

Salesperson

SalesMate
Liverpool, NSW
07.2022 - Current
  • Developed key customer relationships to increase sales.
  • Resolved customer complaints promptly and efficiently.
  • Educated customers about products and services offered by the company.
  • Advised customers on the latest product features and benefits.
  • Provided personalized service to build relationships with customers.

Education

Bachelor of Business Administration - Business Administration

Macquarie University
North Ryde
12-2024

Skills

  • Data Analysis and Visualization: Proficient in SQL, Tableau, Excel, and Power BI
  • ETL Processes: Experienced in employing data cleaning, extraction, transformation, and loading techniques
  • Analytical Thinking: Ability to translate complex data into actionable business insights
  • Communication: Effective at presenting complex information in an accessible manner

Projects

PROJECTS

COVID Data Analysis and Visualization – SQL and Tableau

  • Conducted real-time analysis of COVID-19 data sourced from Our World in Data, employing data cleaning techniques and ETL processes.
  • Created interactive dashboards in Tableau, transforming raw data into intuitive visual insights.

Market Analysis of BVC Company

  • Conducted comprehensive market analysis to assess trends and performance.
  • Utilized advanced Excel functions for data sorting, filtering, and analysis.
  • Employed SQL for complex data queries, manipulation, and deeper insights generation.
  • Analyzed competitive landscape, customer preferences, and market opportunities.

Excel Pivot Table Project

  • Analyzed large datasets related to sales performance and customer trends using pivot tables.
  • Identified key performance indicators to monitor sales achievements and areas for improvement.
  • Provided actionable insights on customer buying patterns and product popularity.

Dynamic Sales Dashboard in Power BI for Salesmate

  • Developed an interactive sales dashboard in Power BI to monitor real-time performance.
  • Utilized DAX formulas for complex data modeling and calculations.
  • Designed visualizations to clearly present sales trends, performance metrics, and growth opportunities.
  • Enabled sales team to quickly identify trends, making data-driven decisions to enhance sales strategies.

Timeline

Console Operator

7-Eleven
04.2023 - Current

Salesperson

SalesMate
07.2022 - Current

Bachelor of Business Administration - Business Administration

Macquarie University
Fardeen Alam Khan