Tio Lovian

Data Analyst
MaleSales representativeLive in IndonesiaNationality
Share

Work experience

  • Data Analyst

    Unilever
    2025.01-Current(a year)
    Responsible for developing, maintaining, and validating dashboards and data pipelines to support Commercial Division (CD) across all channels (LMT, GT,MT). Key tasks include: • Design and maintain interactive dashboards and automated reports. • Validate and ensure data accuracy, consistency, and completeness. • Manage data integration and ETL processes across multiple sources. • Provide business insights and recommendations based on data analysis. • Collaborate with CD teams to align reporting with business needs.
  • Business Intelligence Developer

    PT Astra International Tbk
    2024.04-2025.01(10 months)
    - Set up a Power BI data gateway connection, configure connections to OneDrive, SQL Server, and Cloudera. - Develop Power BI reports. - Build Power BI reports using DAX. Create custom charts in Power BI. - Develop Power BI using data flows. - Create Power BI solutions using data marts. - Embed Power BI into an HTML webpage with Single Sign-On (SSO) using Azure Active Directory. - Troubleshoot reports experiencing slow performance. - Configure user access authorization for both report data and the reports themselves. - Set up scheduled or event-triggered data refreshes from external systems for datasets.
  • Trainer Power BI

    Purwadhika Digital Technology School
    2024.06-2024.06
    1. Introduction to Data Analysis & Power BI 2. Power Query Editor for Data Transformation 3. Data Manipulation, Data Cleaning 4. Data Modeling 5. DAX (Data Analysis Expressions) 6. Basic Data Visualization: Categorical Chart 7. Basic Data Visualization: Numerical Chart 8. Building Dashboard 9. End to End Data Analysis Project with Power BI 10. End to End Data Analysis Project with Power BI
  • Business Intelligence Developer (Project)

    The Body Shop Indonesia
    2023.07-2024.04(10 months)
    - Designing Data Warehouse and Business Intelligence solution using Microsoft Technology: a. Microsoft SQL Server Databases b. Microsoft SQL Server Reporting Services (SSRS) c. Microsoft SQL Server Analysis Services (SSAS) d. Scripting: Oracle SQL queries - Make improvements or additions to the Data solution existing warehouse - Create a Dashboard in PowerBI - Setup power BI data gateway connection, setup connection to One Drive, SQL server, cloudera and/or sap. - Develop power bi report, Develop power bi using DAX, Develop power bi using custom charts, Develop power bi using data flow, Develop power bi using data mart and Develop power bi embedded in html webpage with mechanism single sign on using azure active directory. - Carrying out troubleshooting reports with slow performance
  • Operational Specialist

    Cerdas Cermat
    2022.01-2023.12(2 years)
    - Testing websites manually - Testing the website whether it is in accordance with the flowchart - Ensure the website runs smoothly - Drive project management and monitoring: ensure projects run smoothly and on schedule from planning to delivery. - Be the main point of contact between internal and external teams such as Content Providers, and Marketplace Partners. - Course development: assisting content partners in curriculum development as well as content development such as conceptualization, video editing and scripting.
  • Power BI Developer (Project Base)

    Unilever
    2022.10-2023.07(10 months)
    - Developed Factory Dashboard in PowerBI and PowerApps related to factory operation - Integration Factory Dashboard to DFOS - Extract primary and secondary data to various tools. - Develop and maintain databases. - Design and implement a solution that automated the data flow from data entry to the SharePoint database. Involved in analyzing the data flow process, creating data models, and developing automated dashboards using PowerBI. Worked closely with stakeholders to gather requirements and provided training and support to end-users. - Utilized Excel to identify the root cause of false QDTL measurements at the Home Care facility. Responsibilities included analyzing data, developing dashboards, and collaborating with the operations and technical teams to reduce false measurements caused by external and internal flow time of machine lines, and false run/stop/idle/block machine conditions. - Responsible for maintaining a detailed record of issues and their descriptions, validating problem descriptions, and collaborating with developers to estimate issue resolution time. Facilitated post-go-live support for all stakeholders by providing assistance with issue resolution and ensuring that the solution met the needs of the end users. - Facilitated the implementation of advanced quality inspection through camera machine learning by facilitating the preparation of necessary documentation and machine modification. This involved defining key parameters for identifying good and defective products based on machine learning models.
  • Student Independent Kampus Merdeka

    Microsoft
    2021.08-2021.12(5 months)
    - Microsoft Office Specialist: Word and Excel. - Microsoft 365 Fundamentals. - Microsoft Office Specialist: Outlook and PowerPoint. - Microsoft Power Platform Fundamentals. - Create a dashboard with Power BI
  • Social Media Admin

    saladbuah99
    2018.01-2021.03(3 years)
    (3 years 3 months) - Handle social media accounts - Create visuals for social media - Create content on social media - Respond to questions & answers - Make analytical reports from daily and monthly social media - Introducing the Company's Product Brands Through Social Media - Digital Marketing - Make Planning, Content Instagram, Facebook, Twitter, etc. - Upload Daily Content on Social Media - Manage All Digital Marketing Activities, Social Media - Communicate with users who ask questions in DM, Comment, Inbox, etc. - Learn New Things About New Social Media Features

Educational experience

  • Universitas Nasional

    Security System Installation, Repair, and Inspection Technology
    2018.01-2022.01(4 years)

Certificates

Data analytics Junior Web Developer MTA: Software Development Fundamentals - Certified 2022 Blockchain for Business Leaders Belajar Membuat Augmented Reality dengan Lens Studio
Resume Search
Nationality
Job category
City or country
Jobs
Candidates
Blog
Me