🎓 Final-year Mathematics undergraduate at Universiti Teknologi Malaysia (UTM)
📊 Aspiring Data Analyst with interests in data analytics, business intelligence and quantitative analysis
💡 Skilled in Power BI, Excel, SQL, Python, DAX and data modelling
🔬 Experienced in quantitative research, statistical analysis and polynomial regression
🎯 Building practical analytics solutions through dashboards, SQL analysis and data-driven research
🗣️ Languages: Malay, English
Tools: Microsoft Power BI • DAX • Data Modelling • Data Visualization
Built a three-page interactive Power BI dashboard to analyse retail sales performance across 2024–2025, covering revenue, profitability, product performance, regional trends, returns and customer loyalty.
Key areas explored:
- Executive KPIs for total sales, gross profit, profit margin and orders
- Monthly sales trends and regional performance
- Product and category profitability
- Product-level sales and margin analysis
- Return value, return rate and return reasons
- Customer loyalty-tier sales performance
- Fact and dimension-based semantic data model
Tools: SQL • SQLite • DB Browser for SQLite
Analysed a Brazilian e-commerce dataset to explore customer behaviour, sales performance, product trends, revenue and freight costs.
Key areas explored:
- Customer and order analysis
- Revenue and monthly sales trends
- Product category performance
- Freight cost analysis
- Business insights from transactional data
Tools: Microsoft Excel • Data Model • DAX • PivotTables • PivotCharts
Built an interactive Excel dashboard to analyse sales performance, profitability, product trends, store performance and inventory health.
Key areas explored:
- Monthly revenue and profit trends
- Product category and product performance
- Store and location performance
- Inventory value and stock status
- Interactive filtering using slicers and timeline
Tools: Microsoft Excel • Advanced Formulas • Named Ranges • PivotTables • Charts
Completed an advanced coursework-based Excel dashboard analysing 46,380 call centre records to monitor operational KPIs, service targets and agent performance.
Key areas explored:
- Monthly call volume and service performance
- Complaint rates and customer satisfaction
- Call resolution and abandonment rates
- Agent performance against operational targets
- Interactive month selection and scrollable agent analysis
Tools: Microsoft Excel • VBA • Excel Macros • Named Ranges • Formulas
Completed a coursework-based Excel VBA project that automates weekly timesheet creation, daily pay calculations and weekend rates.
Key features:
- Creates a new weekly timesheet automatically
- Collects the week-commencing date using an input box
- Calculates weekday pay using a named hourly rate
- Applies a 1.5× rate for Saturday and Sunday
- Generates daily formulas and the weekly total
- Runs through a worksheet button or keyboard shortcut
Awarded for research on rainfall trend analysis using polynomial regression.
Published research on rainfall trends in Pahang, Malaysia using quantitative modelling and polynomial regression.
Role: First Author
Research focused on rainfall trend analysis for Bentong and Kuantan, Pahang, using polynomial regression and quantitative model evaluation.
Research work included:
- Analysed daily rainfall data and long-term rainfall patterns
- Developed polynomial regression models of degrees 1–5
- Compared model performance using RMSE
- Evaluated numerical stability across polynomial degrees
- Applied quantitative model evaluation to select an appropriate model
- Used GNU Octave and Excel for analysis and data preparation
- 📊 Microsoft Power BI Data Analyst Professional Certificate
- Power BI
- Data Transformation
- Power Query
- Data Modelling
- DAX
- Data Visualization
- Dashboard Design
- Power BI Service
- Business Intelligence
- 🏢 SAP S/4HANA Course Completion
- Foundational exposure to SAP S/4HANA
- Enterprise Resource Planning concepts
- SAP business processes and enterprise systems
- 📗 Excel Skills for Business Specialization
- Intermediate and advanced Microsoft Excel
- Advanced formulas and functions
- Data analysis and dashboard development
- VBA and automation
- 🗄️ Learn SQL Basics for Data Science Specialization
- SQL querying
- Aggregations
- Joins and subqueries
- Data analysis using relational databases
- 📈 Data Analytics for Organisation
- Data analytics fundamentals
- Data-driven decision making
- Organisational analytics applications
Skills: Power BI • Dashboard Design • KPI Reporting • Data Visualization • Interactive Reports • Data Storytelling
Skills: DAX • Power Query • ETL • Data Transformation • Data Modelling • Star Schema • Fact & Dimension Tables • Data Relationships
Skills: SQL • SQLite • Joins • Subqueries • Aggregations • GROUP BY • Data Filtering • Relational Data Analysis
Skills: Python • Pandas • NumPy • Matplotlib • Data Analysis • Data Preparation
Skills: Advanced Excel • PivotTables • PivotCharts • INDEX-MATCH • Advanced Formulas • Data Model • DAX • VBA • Excel Macros • Slicers • Dashboard Development
Skills: Statistical Analysis • Polynomial Regression • RMSE • Quantitative Research • Model Evaluation • Trend Analysis
Foundational Learning: SAP S/4HANA • Enterprise Resource Planning (ERP) • Enterprise Business Processes
Tools: Power BI Desktop • Microsoft Excel • DB Browser for SQLite • GNU Octave • Jupyter Notebook • GitHub
Interested in internship opportunities where I can apply analytical and quantitative skills to real-world business problems, particularly in:
Data Analytics • Business Intelligence • Business Analysis • Risk Analytics
