Afnan Anderil

I'm

About

Muhammad Afnan Bin Mohd Anderil

  • City: Kuala Selangor, Selangor
  • Email: afnananderil@gmail.com

Certified Data Analyst and Business Analyst with hands on experience and official certifications in Power BI (Microsoft Certified) and Alteryx (Designer Core Certified). Proven track record in leveraging tools like Tableau, UiPath, SQL, and Power Automate to deliver actionable insights, automate workflows, and enhance decision-making. Skilled in building dynamic dashboards, streamlining processes, and translating complex data into clear business strategies. Seeking a forward-thinking organization where I can apply my analytical expertise to drive operational efficiency and business growth.

Resume

Aacademic background and Professional Experience.

Education

Bachelor of Electrical & Electronic Engineering with Honours

2019 - 2023

Universiti Putra Malaysia, Selangor

Foundation in Agriculture Science

2018 - 2019

Universiti Putra Malaysia, Selangor

Professional Experience

Business Analyst

Jan 2024 - Present

Cisco Systems (Malaysia) Sdn Bhd

  • Built around 7 interactive Tableau dashboards weekly, used directly by Business Operations Managers in APJC for strategic planning.
  • Delivered accurate funnel and forecast reports to support executive decision-making.
  • Responded to dynamic business needs with tailored ad hoc reports and pipeline analyses.
  • Supported APJC Theater GVS BOM and leadership in day-to-day operations.
  • Technologies used: Tableau, Power BI, Alteryx, Power Automate, SQL, UiPath and Excel.

Data Analyst

Oct 2023 - Dec 2023

Kiwitech Sdn Bhd, Negeri Sembilan

  • Collaborated with city council on smart city initiatives, including smart traffic light systeBuilt Power BI dashboards to present key insights to stakeholders.
  • Built Power BI dashboards to present key insights to stakeholders.
  • Employed API integration to collect real-time data from smart city infrastructure.
  • Cleaned and transformed data using Python and SQL to ensure reliability.
  • Technologies used: Azure Data Factory, Power BI, SQL, Python and Postman.

Portfolio

This is the portfolio projects that I have created:

  • All
  • Dashboard
  • SQL
  • Alteryx
  • RPA
  • Python

PIZZA SALES REPORT DASHBOARD

Dashboard

FACEBOOK CLOSED REASON DASHBOARD

Dashboard

CASE STUDY Customer Behaviour Analysis on Dummy Data

SQL

PROJECT MANAGEMENT DASHBOARD

Dashboard

HR ANALYTICS DASHBOARD

Dashboard

Web Scrapping Using UiPath

RPA

Automatic Download Data CRM (Saleforce) Using UiPath

RPA

PIZZA SALES REPORT ANALYSIS USING SQL

SQL

CRM Cleaning Data Using Alteryx

Alteryx

Sales Cleaning Data Using Alteryx

Alteryx

ROAD ACCIDENT ANALYSIS USING SQL

SQL

PYTHON WEB SCRAPING

Python

Skills

The skills in which I am proficient and can make meaningful contributions are:

HTML 85%
SQL 87%
Microsoft POWER BI 90%
UIPATH 80%
MICROSOFT EXCEL 90%
ALTERYX 80%
Other Skills: Tableau, Microsoft Azure, Microsoft Powerpoint, Python, Power Automate, Figma Languages: Bahasa Melayu (Native), English (Fluent), Arabic (Basic)

Certification

All the certification is described in this section.

Microsoft Certified: Power BI Data Analyst Associate

Alteryx Designer Core Certification

Data Analytics Essentials-Cisco

Google Analytics for Beginners