Afnan Anderil

I'm

About

Muhammad Afnan Bin Mohd Anderil

  • Website: https://afnananderil.github.io/
  • Phone: +601139358042
  • City: Kuala Selangor, Selangor
  • Email: afnananderil@gmail.com
    • Degree: Bachelor of Electrical and Electronic Engineering (Honours)

A results-oriented Data Analyst and Business Analyst with a proven track record of successfully leveraging automation tools such as Alteryx, UiPath, Power BI, Tableau and to drive data-driven insights and streamline business processes. With hands-on experience in both roles, I excel in creating impactful dashboards that facilitate informed decision-making and optimize operational efficiency. Seeking a challenging opportunity in a forward-thinking organization where I can utilize my analytical skills and contribute to driving business growth through innovative data solutions.

Skills

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

HTML 85%
SQL 87%
Microsoft POWER BI 85%
UIPATH 80%
MICROSOFT EXCEL 93%
ALTERYX 80%
Other Skills: Tableau, Microsoft Azure, Microsoft Powerpoint, Python, Power Automate, C++, MATLAB, AutoCAD, Visual Studio Code, Adobe Illustrator, Adobe XD, Adobe Photoshop, Arduino, Figma Languages: Bahasa Melayu (Native), English (Fluent), Arabic (Basic)

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

Certification

All the certification is described in this section.

Alteryx Designer Core Certification

Data Analytics Essentials-Cisco

Data Analytics Consulting Virtual Internship-KPMG

Data Analytics and Visualization Virtual Experience-Accenture

Power BI Job Simulation

Google Analytics for Beginners

Resume

All the academic background, work experience, award, achievement, curriculum and volunteer services desribed in this section.

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

  • Developed approximately 15 interactive dashboards per week using Tableau, with reports directly utilized by the Business Operations Manager (BOM) for strategic planning and operational decisions in the GVSE APJC region.
  • Generated and maintained critical business reports, including funnel and forecast reports, ensuring accurate and timely data-driven insights for strategic decision-making within the APJC region.
  • Delivered customized, ad hoc reports and pipeline analyses to meet dynamic business needs, showcasing the ability to adapt and respond quickly to various analytical requests in the APJC theater.
  • Provided daily operational support to the APJC Theater GVS BOM and Leader, facilitating seamless business functionality and success.
  • Proficient in Power BI, Power Automate, SQL, Power Query, and UiPath, leveraging these tools to streamline processes, automate workflows, and perform comprehensive data analysis for the APJC theater.

Data Analyst

Oct 2023 - Dec 2023

Kiwitech Sdn Bhd, Negeri Sembilan

  • Collaborated with the city council on smart city projects, including the implementation of smart traffic lights.
  • Utilized Azure Data Factory for data extraction, transformation, and loading (ETL) processes.
  • Employed API integration to collect real-time data from smart city infrastructure.
  • Employed Python and SQL for data cleaning and preprocessing, ensuring data accuracy and reliability.
  • Designed and developed interactive dashboards in Power BI to present key insights and performance metrics to the city council.
  • Played a pivotal role in enhancing data-driven decision-making and improving urban infrastructure efficiency.

Engineer Intern

July 2022 - Oct 2022

Sony EMCS (Malaysia) Sdn Bhd, Selangor

  • Actively participated in the overall process of producing new LCD TVs, collaborating with cross-functional teams.
  • Contributed to the successful completion of nearly 100 LCD TV units per day, ensuring strict adherence to quality standards and production timelines.
  • Played a key role in the development of LCD TV circuit boards by contributing of nearly 80 number of circuit board adjustment (CBA) activities.
  • Utilized technical skills and knowledge to optimize circuit board performance, resulting in an average 90% improvement in efficiency and functionality.

Awards and Achievement

BEST TEAM AWARD - Ministry of Higher Education (MoHE)

2023

Received the prestigious best team award in ROBOCON Malaysia 2023 competition organized by the Ministry of Higher Education (MoHE). Served as a leader of the team and representative for Universiti Putra Malaysia in the competition.

CHESS COMPETITION - Majlis Sukan Universiti Malaysia (MASUM)

2021 - 2022

Represent UPM in the competition for 2 consecutive years, competing against other universities. Served as a leader of the team in 2021 and 2022. Achieved remarkable success by securing a place in the top 10.

ANUGERAH PUTERA PERKASA - Tenth College Universiti Putra Malaysia (UPM)

2022

Received the award regarding the highest achievement as a coordinator and participant in co-curricular activities whether at the college, university, national or international level.

GOLD MEDALIST - Universiti Putra Malaysia (UPM)

2021 - 2022

Received the Gold Medal for the chess competition in UPM. Represent the college for 2 consecutive years, competing against other college in UPM

Extra Curriculum and Volunteer Services

1. ROBOCON MALAYSIA 2023 COMPETITION

The robotics competition organized by the (MoHE). Served as the leader of the UPM team.

2. VICE PRESIDENT ACTIVITY COLLEGE REPRESENTATIVE COUNCIL SESSION 2021-2022

Assisted in the management of student placements for a total of 1,400 individuals within the college, coordinated and executed nearly 40 activities, extending up to the international level.

3. COLLEGE REPRESENTATIVE COUNCIL SESSION 2020-2021

Represent the college students in all respects.

4. PRESIDENT SPIRITUAL AND UNITY TENTH COLLEGE 2020-2021

Responsible to foster a harmonious and inclusive campus environment by organizing various events and spiritual activities.

5. SECRETARY OF KELAB BIMBINGAN MAHASISWA UPM 2020 AND 2021

Actively contributed to various aspects, including strategic planning, organizing events, recruiting new members, and implementing initiatives that enhanced the club's reputation for 2 years.

6. MEMBER OF IEEE STUDENT BRANCH UPM

Assisting top board members in organizing events related to electrical and electronic engineering.

7. ELECTION OF STUDENT REPRESENTATIVE COUNCILS 2019 AND 2020

Served as the committee member for 2 years.

8. MEMBER OF GOOGLE DEVELOPER SCIENCE CLUB UPM 2021-2022

Assisting top board members in organizing events in or outside UPM. Joined talks and programs related to technology such as Cyber Security, Data Science and Artificial Intelligence.

9. MEMBER OF SELANGOR STUDENT ASSOCIATION UPM

Assisting top board members in organizing events.

10. “SEKOLAHKU SYURGAKU 2019” ROBOTIC PROGRAM

Served as a facilitator to explain about robotics in the primary school.