Mohamad Faisal Gunawan Email and Phone Number
📩 mohfaisalg@gmail.com🎓 Graduated from a Full Stack Data Analytics Boot Camp with overall score 98/100🔎 Data Analysis/Wrangling skills using Excel, SQL, and Python📊 Data Visualization/Data Communication/Storytelling using Tableau, Looker Studio, and Power BI💼 Experienced with various data analytic projects such as customer churn analysis, cost-benefit analysis, customer segmentation analysis, turnover rate reduction, data quality enhancement, demand forecasting analysis, customer behavior analysis, cost optimization analysis, dashboard monitoring analysis.................................................................................................................................................................................................................As a data enthusiast with less than 2 years of experience utilizing data to generate business insight. I had experience as an Operations Analyst managing data-driven projects and optimizing logistical supplies for over 150 hospitals and healthcare facilities nationwide with a success rate of 95%. Currently, I am seeking to join a data analyst role with hands-on experience with various data-driven projects through Data Analytics Bootcamp. Possessing a deep understanding of Microsoft Excel, SQL, Python, and Data Visualization Tools (Tableau, Power BI, Looker Studio)
-
Data And Logistics Project AnalystUndpWest Java, Indonesia -
Data AnalystUndp Jun 2024 - PresentJakarta, Indonesia• Analyzed more than 3000+ Influenza and COVID-19 cases from 90+ government hospitals to identify trends and improve the surveillance system, resulting in a 15% increase in early detection and response efficiency towards the disease.• Streamlined the process of health data reporting by automating data extraction and analysis workflows, reducing report generation time by 20% and increasing the accuracy of weekly and monthly health outcomes reports.• Developed and maintained Tableau dashboards to monitor health data reports from 38 provinces in alignment with health indicator standards, resulting in enhanced data transparency and improvement in decision-making efficiency for higher-level management -
Data Analyst AssociateRevou Sep 2023 - Jan 2024Jakarta, IndonesiaThe dataset comes from the collaboration between RevoU and Zurich Insurance which is about the performance of Ziaga Life Flexy Ads.• Analyzed the performance of Ziaga Life Flexy Ads by developing a dynamic dashboard using Tableau, resulting in 5 visualizations of performance Ads and the identification of effective Ads that can boost customer conversion rate.• Managed to conduct comparison analysis of Ziaga Life Flexy Ads using Excel, resulting in an improvement in performance Ads in terms of cost and benefit.• Analyzed the payment performance of over 300 customers by examining their profile characteristics, leading to a 10% improvement in payment behavior -
Data Analyst TraineeRevou May 2023 - Sep 2023Jakarta, Indonesia• Led and managed the IBM Employee Attrition Analysis project in time, focused on building a predictive model (logistics regression model) to determine the factors that drive employee attrition, reduced the attrition rate, and produced impactful business recommendation - with a project score of around 96/100. • Managed and conducted funnel analysis of the GoFood customer journey by determining the business metrics to improve customer experience and business performance.• Managed and conducted linear regression analysis using E-commerce Sales dataset to predict customer purchase behavior by utilizing spreadsheets tools and statistics knowledge.• Conducted cohort analysis and the optimization cost analysis using E-commerce dataset by deprioritizing some product category that have a low market share and profit using SQL tools and BCG matrix. • Managed bank transaction dataset and conducted RFM analysis and K-Means Analysis to reduce the cost of promotion by analyzing the customer segmentation. • Managed bank transaction dataset and developed machine learning model (logistics regression analysis) to determine the probability of customer taking the Pay Later feature from 30.000 customers and conduct the revenue cost ratio analysis.• Built and developed interactive dashboard using E-commerce dataset to monitor the business performance in the past year by utilizing Tableau and Looker as a data visualization tools. -
Event OfficerIndonesian Youth Diplomacy Jan 2023 - Sep 2023Jakarta, IndonesiaThe ASEAN Youth Summit is a forum for young people from Southeast Asian nations to discuss regional issues and promote cooperation in areas like politics, economics, and culture.• Created and organized meals arrangement for up to 200+ participant including 80+ international delegates using spreadsheet from 5 – 8 September 2023 (the main event).• Collected the attendance of organizer committee to make an efficient number of meals that should be served by creating a google form.• Collaborated and coordinated with the Event Organizer, Catering, Medical Team, and across Division to ensure the success of the event, increasing the participant satisfaction by 98% -
Operation AnalystMinistry Of Health Of The Republic Of Indonesia Aug 2022 - Jan 2023Jakarta, Jakarta, IndonesiaA government ministry that organizes public health affairs within the Indonesian government.• Led data-driven projects focused on optimizing operational processes, improving resource allocation, and enhancing service for the Ministry of Health to supply Covid-19 reagents across nations.• Coordinated with 150+ hospitals and health facilities to collect data and determine the number of reagent supplies.• Collected and analyzed large datasets using Excel to identify patterns and forecast logistic supplies.• Mitigated the risk of overstocking and shortages by utilizing data analysis tools to calculate optimal supply levels.• Conducted meetings with users to identify product quality issues and compiled findings into weekly or monthly reports.• Performed thorough research and analysis of over 50 logistics Covid-19 reagents products available in the market.• Collaborated with the procurement team to establish an optimized procurement process, considering factors such as price, machine compatibility, and user requirements for the reagent products.• Established SOP for a transparent reimbursement scheme and evaluated the progress of claims.• Coordinated with the finance team to resolve various issues, resulting in an enhancement of user satisfaction.• Effectively managed national projects to distribute COVID-19 reagents to 34 provinces in 6 months. -
Logistics OfficerIndonesian Youth Diplomacy Jun 2022 - Jul 2022Jakarta, IndonesiaThe Y20 Summit is an annual international gathering of young leaders from G20 member countries and youth organizations. It focuses on discussing global issues, creating policy recommendations, and advocating for youth perspectives to be considered by G20 leaders.• Strategized, evaluated, and scheduled meal arrangements for up to 30 individuals during the event.• Managed the consumption logistics on the Jakarta - Bandung events in 2022, achieving 98% success rate.• Collaborated closely with the public health officer to facilitate Covid-19 testing, delegate healthcare, and food safety measures, ensuring the safety of VVIP attendees.• Handled 22 special meal requests, specifically vegan food, in coordination to address delegate meal preferences.• Employed data-driven planning and forecasting techniques, while coordinating with cross-functional teams. -
Supply Chain AnalystNational Institute Of Health Research And Development (Nihrd), Indonesia Apr 2021 - Jun 2022Central Jakarta, Jakarta, IndonesiaA government ministry that organizes public health affairs within the Indonesian government.• Collected data inventory and organized all related files by coordinating with 50+ government hospitals.• Analyzed large datasets using Excel to identify patterns and forecast logistic supplies.• Assisted 50+ hospitals in data logistics entry into the internal system through online meetings and phone calls.• Facilitated seamless data integration to streamline distribution processes and optimised efficiency• Identified and resolved logistical supply challenges by collaborating with relevant stakeholders.• Monitored and precise calculation methodologies to track and forecast logistical supplies.• Effectively preventing inventory shortages across 23 government hospitals.• Developed and maintained a relationship with 50+ hospitals in 3 provinces (North Maluku, Riau Islands, and Lampung) including the public health officer and third parties.• Successfully promoted to be Operations Analyst Consultant within 6 months of working. -
Business Development InternShopee Jan 2021 - Mar 2021Jakarta Selatan, Jakarta, IndonesiaA leading e-commerce platform in Southeast Asia owned by Sea Limited.• Verified and compared Shopee products against competitor offerings using internal price matching tools.• Supported team members to achieve 2000 products per day by comparing price and product description.• Coordinated and worked closely with the QC team to produce a good result of matching products.
Mohamad Faisal Gunawan Education Details
Frequently Asked Questions about Mohamad Faisal Gunawan
What company does Mohamad Faisal Gunawan work for?
Mohamad Faisal Gunawan works for Undp
What is Mohamad Faisal Gunawan's role at the current company?
Mohamad Faisal Gunawan's current role is Data and Logistics Project Analyst.
What schools did Mohamad Faisal Gunawan attend?
Mohamad Faisal Gunawan attended Revou, University Of Indonesia.
Who are Mohamad Faisal Gunawan's colleagues?
Mohamad Faisal Gunawan's colleagues are Leo Spangler, Anou Borrey, Jonica Lopez, David Avendaño, Mahsa Jafari, Suleiman Gutale, Zuzana Tollrianová.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial