Muhammad Hilman Alfajri

Muhammad Hilman Alfajri

Head

Followers of Muhammad Hilman Alfajri977 followers
location of Muhammad Hilman AlfajriJakarta, Indonesia

Connect with Muhammad Hilman Alfajri to Send Message

Connect

Connect with Muhammad Hilman Alfajri to Send Message

Connect
  • Timeline

  • About me

    SIMPATI Telco Product Growth and Innovation at Telkomsel

  • Education

    • Institut Teknologi Bandung (ITB)

      2017 - 2021
      Bachelor's degree Mechanical Engineering 3.58

      Completed an undergraduate study in four years with cum laude predicate.Learned critical thinking and problem solving through assignments, and some projects throughout the study.Conducted data exploration in the final thesis to find the problem and draw a hypothesis.Activities & Societies : Student Association, Student Choir Organization.

    • RevoU

      2022 - 2023
      Full Stack Data Analytics

      Completed the program with final grades of 89.33 out of 100Accepted to join the program through test and interview with an acceptance rate of <10%Dedicated more than 200 hours on online classes and assignmentsMentored by instructors from Tech Industries such as XL Axiata, Ex-Tokopedia, Ex-Kitabisa, OY! Indonesia, Bank Jago, etc. Learned end-to-end data analytics process from understanding business problems to data visualization using various methods and various software… Show more Completed the program with final grades of 89.33 out of 100Accepted to join the program through test and interview with an acceptance rate of <10%Dedicated more than 200 hours on online classes and assignmentsMentored by instructors from Tech Industries such as XL Axiata, Ex-Tokopedia, Ex-Kitabisa, OY! Indonesia, Bank Jago, etc. Learned end-to-end data analytics process from understanding business problems to data visualization using various methods and various software (Spreadsheet, SQL, Python, Looker, Tableau).Learned practical knowledge and skills through the project cases given in each topic’s assignment.Selected as one of students from 50+ students to present the analytics assignment during python module based on the quality of the assignment. Show less

    • SMAN 71 Jakarta

      2014 - 2017
      High School Diploma Science 363/400
    • Pacmann

      2024 - 2025
      Data Engineering
  • Experience

    • Gita Patria Sapta Eka Choir SMAN 71 Jakarta

      Oct 2015 - Oct 2016
      Head
    • Himpunan Mahasiswa Mesin ITB

      Feb 2019 - Apr 2019
      Head of Logistic Wisnight Sub-division at Wisuda April HMM ITB 2019
    • ITB Student Choir

      Apr 2019 - Jun 2020
      Head of Festival Paduan Suara XXVI ITB 2020
    • Himpunan Mahasiswa Mesin ITB

      Jun 2019 - Jul 2019
      Head of Wisnight Division at Wisuda Juli HMM ITB 2019
    • Himpunan Mahasiswa Mesin ITB

      Jul 2020 - Aug 2021
      Head of Engineer Division

      Badan Pengurus HMM ITB 2020/2021 "Teladan Berkarya"

    • PT Geo Dipa Energi (Persero)

      Jul 2020 - Aug 2020
      Mechanical Engineering Intern

      Founded and concluded the root cause of power output fluctuation in Patuha Geothermal Power Plant in 1-month-internship

    • Institut Teknologi Bandung

      Jan 2021 - Apr 2021
      Basic Fluid Mechanics Tutorial Assistant

      - Provided support for basic fluid mechanic's students to solve several problems every week- Evaluated students' works

    • Institut Teknologi Bandung

      Aug 2021 - Nov 2021
      Mechanical Engineering Laboratory Asisstant

      - Provided support for students to understand the refrigeration cycle testing module- Evaluated students works

    • Mega Persada Group

      Nov 2021 - May 2022
      Business Development

      Data Analytics: Create and Deliver dashboards, visualizations, automated reports, calculators, and data feeds to monitor Business Development ProjectsData Analytics: Monitored and calculated Business Development KPI and managed to achieve the targeted score.

    • Doosan Heavy Industries & Construction

      May 2022 - Jul 2023
      Subcontract Engineer

      Communicate with vendors, negotiate the prices, and maintain relationships with more than twenty suppliers and vendors.Manage more than twenty suppliers and vendors to deliver the requested materials on time.Created automated graphs and dashboards for comparing subcontractors actual costs with the planned costs.

    • RevoU

      Aug 2022 - Apr 2023
      Data Analyst Associate

      Developing Support Dashboard for Business Performance Management in a SaaS Company-Define key metrics that need to be monitored through the dashboard.-Developed C-Level, Sales Manager, and Operational Team business performance dashboards to help stakeholders optimize the business processUtilizing Customer Data to Supporting Development of Better Marketing Strategy in a SaaS Company-Evaluated current marketing performance by calculating marketing efficiency ratio and finding the GMV gained from each marketing strategy-Provide insights and recommendation about which marketing strategy should be focused on in the futureAnalyzing & Evaluating Sales Funnel Evaluation in a SaaS Company-Analyzed the biggest drop off of the funnel and the most common reason of the dropoff to provide insightful analysis-Providing insights and recommendation to the stakeholders to reduce the leads dropoffAnalyzing & Evaluating Pricing Strategy of a SaaS Company-Conducted data transformation, EDA, and PED Analysis to evaluate the current pricing strategy-Providing recommendation regarding new pricing based on customer behavior of each subscription typeClustering Analysis of Popular Songs in Spotify Indonesia-Perform data extracting, cleaning, processing, mining with Google BigQuery and Python-Conducted EDA, correlation analysis, clustering analysis using machine learning, and data visualization from various data sources using Python to identify the characteristics, trend, pattern, and relationship between each parameter of the Popular Songs in Indonesia-Provide insights, recommendations, and solutions to music producers about the characteristics of popular songsClustering analysis of Mutual Funds Application Customer using Python-Clustering analysis and interpretation using machine learning on Python based on customer demographic, and behavior-Provide insights and recommendations for thematic campaign based on the customer segmentation analysis Show less

    • Gaja - GPay Digital Asia

      Aug 2023 - May 2025
      Data Analyst

      - Improved daily report efficiency by reducing reporting time by 79% through automating the data mining process using Python, SQL, and Microsoft Excel.- Develop interactive dashboards to help Sales and Operational Team to monitor business performances swiftly using Tableau.- Manage and fulfill ad-hoc analysis requests from all departments across the company.- Develop and maintain data mart and its ETL using apache NiFi and SQL.- Monitor and maintain data quality of the data mart.

    • Telkomsel

      Jun 2025 - now
      • TEC Associate - SIMPATI Telco Product Growth and Innovation

        Sept 2025 - now
      • TEC Associate - Prepaid Customer HVC and Retention Pamasuka

        Jun 2025 - Aug 2025
  • Licenses & Certifications