Muhammad Farhan Email & Phone Number

Palembang, Id

• Responsible for the company's performance rating program in environmental management based on the regulation of the minister of environment and forestry republic of indonesian number 1 of 2021.• Has increased the company's PROPER assessment (PPA, PPU, PLB3) 2022-2023 from red to blue

Palembang, Sumatera Selatan, Indonesia

A perfumery brand started in 2020 with an ambitious dream to unlock all potentials of Indonesian fragrance industry at affordable prices and GOD quality.

Palembang, Sumatera Selatan, Indonesia

• Creation of creative fragrances for the local market• Creating local brand appearances at lower costs across all product categories• Responsible for fragrance formulation with special focus on self care

• Understanding Data Warehouse process flow• Make the importance of Data Warehouse for an industry and examples of its implementation• Implemented add, rename, save, delete, and reorder data processes in Worksheets.• Made the different types of charts and their differences and uses the urgency of the process of visualizing data and its principles• Create a concept of Big Data, statistics, and data visualization on Kimia Farma's sales data.• Created datamart designs, filter, extract, and analyze Kimia Farma sales data on the Salicyl brand on 8 cities in Indonesia• Create a dashboard from the sales data of Brand Salicyl in one year from the raw data that has been provided.

• Learning and improving skills in data analysis, SQL Querying, and soft skills around business intelligence analyst• Doing tasks around data analysis, SQL Querying, and others in the field of business intelligence analysis as a form of understanding and as a form of implementation of business intelligence analyst• Creating and processing data from Microsoft Excel using the drop-down list, dual-axis chart, data filtering, and advanced formula features (Data Validation, Pivot table, slicer, Sumif & Sumifs)• Creating several types of data visualization from Microsoft Excel through pivot charts and chart displays adapted to the data obtained.• Performing forecasting data from one year's data with a pivot table to predict future sales.

• Learn about the practices and processes used by a junior or associate data analyst on a daily basis . • Learn key analytical skills ( data cleaning , analysis , & visualization ) and tools ( spreadsheets , SQL , R programming , Tableau ) • Understand how to clean and organize data for analysis , and complete analysis and calculations using spreadsheets , SQL and R programming • Learn how to visualize and present data findings in dashboards , presentations and commonly used visualization platforms

• Coordinate for village service work program planners.• Monitoring, evaluation, and reporting of village service work programs.• Carry out administrative service tasks.• Analyzing and monitoring the required budget funds between villages.• Inputting and validating identity card data (KTP).• Coordinate the guests of the partnership socialization meeting.