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:
Portfolio
This is the portfolio projects that I have created:
- All
- Dashboard
- SQL
- Alteryx
- RPA
- Python
Certification
All the certification is described in this section.
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.