homepage

Empowering Ideas Through
Data-Driven Innovation

Eksplore

Let's Connect

Linked In

Yefta Widianto S, Stat

Data Analyst | Business Intelligence | CRM Analyst | Data Intelligence

Passionate in business intelligence and data analysis as a source of business decision making, providing insights, and perspectives to all parties aiming for the company & business mutual benefit. Has experience in leading comprehensive customer master data projects, including project planning, execution, management, and stakeholder engagement.

Skills

Python

SQL

R-Studio

Big Query

SPSS

Minitab

Knime

SAP - CDP

Power BI

Tableau

Looker Studio

Microstrategy

Microsoft 365

Photoshop

Video Editors

Website Dev'l

Work Experience

PT. Astra International Tbk
CRM & Data Intelligence (2022 - Now ) : Responsible for leading data analysis projects, developing reports and dashboards, managing data governance and security, and creating data monetization models to support business growth
See Detail
PT. Cipta Kridatama
Mining Engineering (2021 - 2022 ) : Responsible for managing business processes across departments and sites, developing predictive machine learning models and interactive dashboards to optimize mining operations, planning mine design and drainage systems, collecting production data, and preparing regular coal production reports.
See Detail
PT. Telkom Witel
Marketing & Customer Care (2021) : Responsible for implementing telemarketing strategies for product customers area and providing solutions to customer inquiries and complaints.
See Detail
Bank Indonesia
Data Analyst (2020) : Responsible for UAEK (Economic and Financial Advisor) in analyzing and visualizing economic data. Collaborating with the team to create and submit survey results to Bank Indonesia Tegal employees
See Detail

Highlight Project

Single ID Verification

Verify and consolidate customer data to ensure that all information stored in Auto2000’s system is accurate, centralized, and valuable for future utilization and business optimization.

Power BI DS Area Visualization
More Detail

Power BI Training

Led Power BI training focused on designing strategic dashboards and publishing reports to Power BI Service, empowering participants to elevate data storytelling and business decisions

Power BI DS Area Visualization
More Detail

Change Management

Change Management drives strategic transformation by strengthening stakeholder engagement, fostering user awareness, and accelerating adoption through training and gamification.

Power BI DS Area Visualization
More Detail

Predictive Model

Leveraged customer database with machine learning model to identify customer behavior and generate personalized car recommendations to get high-potential customer to repurchase.

Machine Learning Retargeting
More Detail

Privacy Policy

A key of the task force responsible forΒ  implementing the Personal Data Protection Law across Astra Group, ensuring with national regulations and corporate data governance standards.

PDP Privacy Data Consent
More Detail
Scroll to Top

CRM & Data Intelligence

PT Astra Intenational Tbk – Totoya Sales Operatio

(2022 – Present)

  • Ad-Hoc Data Analysis to solve business cases
  • Develop report and deep analytics dashboard using SQL, Python, Power BI,and Tableau
  • Actively leverage SQL to explore and extract data from Cloudera databases, driving advanced analytics and seamlessly integrating with Python, Tableau, Power BI, and other tools to deliver actionable insights and dynamic reporting
  • Built and refined an analytical machine learning model (Apriory, XGBosst, RFM, etc) to enhance data utilization and drive strategic business decisions
  • Leveraging advanced Power BI features, including DAX, database connections, Row-Level Security (RLS), and access & security management to optimize data-driven decision-making. Proficient in using custom visuals, Power Query, and integrating diverse data sources to enhance reporting processes and drive strategic business outcomes.
  • Lead projects related to data (end to end process), digital transformation, new product development, new revenue stream, and operational process with collaborate with all stakeholders (internal & external), business, and operational team.
  • Instrumental in designin, conceptualizing, and supervising the customer data protection and regulation (PDP) at PT Astra Internasional Tbk Ecosystem.

Achievement :

  1. Provided in-depth market condition analysis for multiple regions through comprehensive research and interactive dashboards.
  2. Successfully leading the Single ID project. Managed the customer data issue in Auto2000 by overseeing data collection, storage, and utilization
  3. Creating and delivering enhance application to the customer data system and providing a seamless online-to-offline customer channel
  4. Orchestrating change management activity in digital transformation product for all stakeholder or end user
Detail Project

Mining Engineering

PT. Cipta Kridatama – ABM Group

(2021 – 2022)

  • Responsible for analyzing all business processes every departments and divisions in the head office and site
  • Built a machine learning model for predictive analysis (Decision Tree & SVM), focused on calculating hauling cycle time to optimize operational efficiency and improve decision-making processes
  • Led the improvement of site monitoring systems by developing an interactive Tableau dashboard, enabling real-time data visualization and enhancing decision-making capabilities
  • Planning mine design, drainage, and others to support the mining process
  • Conduct data collection, coal production, overburden, and others
  • Prepare daily, weekly, and monthly coal production recording report.

Achievement :

  1. Initiated a process improvement project proposal using the Lean Six Sigma methodology to map equipment requirement processes in production through statistical analysis, aiming to minimize waste and improve process efficiency.

  2. Developed a real-time monitoring dashboard that reduced manual data analysis time and improved operational visibility across departments.

  3. Simplified and digitized reporting systems into a flexible and management-friendly format, enabling faster decision-making and easier performance tracking.

Detail Project

Marketing & Customer Care Team

PT. Telkom Witel Yogyakarta – Internship

(2021)

  • Implementation of a telemarketing strategy for indihome customers at Yogyakarta area
  • Serving and answering the solutions to customer complaints and ensuring customer satisfaction.
  • Conducted daily follow-ups with existing customers based on data to promote and upsell additional services.
  • Performed data analysis on follow-up results to identify sales opportunities and customer engagement patterns.
  • Analyzed customer complaint data to identify recurring issues and propose service improvement insights.
  • Created summary reports and dashboards to visualize customer interactions and performance metrics for management review

Achievement :

  1. Successfully implemented strategy to handle 200 customers per day and achieving a 24% conversion rate in upselling IndiHome services.
  2. Developed an interactive dashboard to visualize daily and weekly follow-up results, enabling management to monitor customer response trends in real time.
  3. Enhanced customer insight reporting by transforming raw complaint and follow-up data into actionable analysis, supporting decision-making for marketing and customer service improvements.
Detail Project

Data Analyst

Bank Indonesia – Internship

(2021)

  • Supported the UAEK (Economic and Financial Advisory Unit) in analyzing regional payment systems using regression and statistical methods.
  • Conducted a QRIS adoption survey local business owners to assess digital payment readiness and awareness.
  • Designed & implemented sampling-based survey methodologies to ensure representative & reliable data collection.
  • Created data visualizations and reports to communicate economic insights effectively to management and stakeholders.

Achievement :

  1. Developed an inflation forecasting analysis for the Tegal region, providing strategic insights for management and local government in planning economic stabilization measures.
  2. Designed and implemented a QRIS adoption survey that collected actionable data from local businesses to support regional digital payment initiatives.
  3. Transformed survey and regression results into comprehensive analytical reports and visual dashboards, improving data-driven decision-making within the UAEK department.
Detail Project