Ghani Murtafa Amal Alaudin

Developed dashboards for daily management by integrating Azure Databricks data lake, SAP, and other multiple sources to PowerBI to better manage team workload and KPI monitoring. 

Automated data combining for daily management and from various data sources using Excel and Power Automate to increase work efficiency. 

Created a novel supplier performance measurement calculation by integrating the impact of faulty deliveries.  

Collaborated with diverse and cross-functional teams to support projects to increase data-related efficiency.  

Increased up to 30% accuracy of campaign forecast using developed algorithms from big data for 2000+ items.

Created reports and presentation for improvement project to leaders and other stakeholders such as sales and marketing.

Developed PowerBI dashboard for end-to-end demand planning team analysis from scratch integrated with BigQuery.

Utilized BigQuery, Python, PowerBI, and Google Sheets AppScripts, to automate and simplify business processes.

Created a supply chain network design model using Python and Google Spreadsheets with clustering and mixed-integer linear programming to provide an optimized network in upcoming years for a major e-groceries company in Indonesia.

Built a working prototype calculator for warehouse area requirement, asset calculation, and financial analysis for 10 years of company expansion.

Created a comprehensive dashboard to track business performance and improve data availability using Google Sheets for CMO and marketing-related divisions.

Developed customer journey, operations flow, financial projections, and evaluated UI/UX for a new business unit.

Managed 17 laboratory assistants and organized workshops, practices, tutorials, recruitment, and research.

Trainer for "Multivariate Statistics Training" using RStudio for cluster, regression, discriminant, and factor analysis.

Tutored operation research & quality control course and guided student group project.

Developed customer segmentation method based on behaviour for promotion plan using cluster analysis with Python.

Formulated weekly promotion planning, analysis, and evaluation. Increased user promotion participation more than 2x.

Conducted competitor analysis research for "Series A" Staffinc funding to understand the company's competitive advantage in the business process outsourcing market.

Formulated a new employee journey system (recruitment, payroll, performance management, career management) for an inefficient cost usage department.

Assisted 5 courses in the 3rd-6th semester: Basic Physics, Introduction to Computation (Python), Engineering Drawing (SolidWorks), Database Systems (SQL, RStudio), and Integrated System Design Practice I.

Created learning modules, homework, and weekly practice for students. Instructed weekly practical sessions for Python, SQL, RStudio, SolidWorks and Basic Physics.