SYSTEM STATUS: INITIALIZING
Willy
DATA PIPELINES & AUTOMATION 0%
Home Projects About Experience Contact Let's Connect

WILLY

Data Analyst

I'm Willy, a data analyst focused on turning complex data and repetitive processes into simple, efficient solutions.

View Projects Let's Connect
EXPLORE PROJECTS
Data Analyst

Featured Projects

Every project is presented following the structured analytical framework:

Problem
→
Solution
→
Automation
→
Business Impact

Reporting Automation Sales Perishable

Problem
Manual VLOOKUP reporting took 15–20 min per sheet across 11+ daily reports (165–220 min/day).
Solution
Built a modular Python reporting pipeline with automated validation, formatting, period detection, and Outlook integration.
Impact
Reduced runtime to ~30 seconds for 11 reports — 150× faster / 99.3% time saved.
Looker Studio Python pandas openpyxl Outlook API Excel Claude.ai gemini.ai ChatGPT

O!Save vs Indomaret Competitive Analysis

Problem
Needed to measure O!Save’s impact on Indomaret sales in nearby competitive areas.
Solution
Analyzed 75 nearby Indomaret stores across 40 departments to assess sales performance around O!Save outlets, using SPD, APC, and STD metrics.
Impact
Identified store- and department-level sales changes, enabling more targeted strategic adjustments.
Excel Business Analysis SPD / APC / STD Indomaret BI Claude.ai gemini.ai ChatGPT

CSV Splitter Tool

Problem
5M+ row CSV files exceeded Excel’s row limits, making the data difficult to open and analyze.
Solution
Built a Python tool to automatically split large CSV files into multiple Excel-compatible files.
Impact
Enabled faster and easier data handling, eliminating manual file splitting.
Python xlsxwriter CSV Excel Looker Studio Claude.ai gemini.ai ChatGPT
About Me

I build systems that make data work faster.

Willy Lengkong — Retail Data Analyst
✨ 3+ Years in Data & Retail
MD Strategic Analyst · PT Indomarco Prismatama (Indomaret Group)

I’m a Strategic Data Analyst with a background in business operations, data analytics, and technology, while currently pursuing my studies in Information Systems at Universitas Pelita Harapan.

My work focuses on turning complex and repetitive processes into more efficient, structured, and reliable workflows. I enjoy analyzing business problems, working with data, and building practical solutions that help teams work faster and make better decisions.

With a combination of business understanding and technical skills, I’m continuously exploring how data, automation, and technology can be used to create simpler and more effective ways of working.

Guiding Principle
Execution Framework
01
Understand Problem

Analyze retail business context and root bottlenecks.

02
Structure Data

Normalize, clean, and model datasets for pipeline readiness.

03
Automate Workflow

Engineer modular, zero-touch automated Python pipelines.

04
Measure Impact

Quantify speed gains, accuracy, and clear business ROI.

Data & Automation

Python pandas openpyxl xlsxwriter Automated Data Pipelines ETL

Analytics & Retail Metrics

SPD / APC / STD Analysis Competitive Analysis Business Analysis Target Allocation Modeling

Excel & Data Processing

Power Query PivotTable Advanced Formulas Data Modeling Dashboard

Tools & AI Environment

Outlook API Google Sheets Looker Studio Tableau VS Code Git Antigravity Claude AI Gemini AI ChatGPT AI
Career & Education

Experience & Qualifications

Menara Indomaret, Jakarta, Indonesia

PT Indomarco Prismatama (Indomaret Group)

Retail Merchandising & Automated Analytics
💼 Work & Automation Full-time Active
Jun 2024 – Present (On-site)
Responsible for retail merchandising intelligence, nationwide performance reporting optimization, and engineering automated data pipelines for business decision support.
MD Strategic Analyst
Full-time · Jun 2024 - Present
Menara Indomaret, Jakarta, Indonesia
Skills: Python, pandas, Tableau, openpyxl, ETL, Looker Studio, Automated Data Pipelines, and 6+ other skills
Key Achievements
  • Developed the Python reporting automation pipeline for Sales Perishable reports, reducing daily manual processing time across 11 reports from 165–220 minutes to ~30 seconds (99.3% efficiency gain).
  • Conducted comprehensive competitive analysis (O!Save vs. Indomaret) spanning 75 stores and 40 product departments using SPD, APC, and STD evaluation models.
  • Designed and implemented a multi-tier target allocation pipeline integrating historical sales trends and carton packaging rounding rules.
Merchandising Support Staff
Full-time · Oct 2022 - Jun 2024 · 1 yr 9 mos
Menara Indomaret, Jakarta, Indonesia
Skills: Oracle, Excel, Outlook
Key Responsibilities & Operations
  • Product Data Management: Managed the registration process for an average of 70 new products per month into the system, ensuring complete data accuracy before nationwide distribution across retail stores.
  • Pricing Administration: Handled regular input and updating of product selling prices, maintaining strict alignment with prevailing retail merchandising strategy.
  • Promotion Execution: Managed technical setup and system parameters for promotional campaigns, ensuring effective and timely execution at the store level.
  • Product Classification & Tagging: Responsible for applying product labels (tags) to categorize sales performance, identifying best-sellers (fast-moving), regular-selling items, and items slated for delisting.
Visit Website
Education
Lippo Karawaci, Tangerang, Indonesia

Universitas Pelita Harapan (UPH)

Bachelor of Information Systems — Data Science and Data Analytics
🎓 Education Undergraduate Active
2025 – 2029 (Expected) · Lippo Karawaci, Tangerang
Universitas Pelita Harapan (UPH) | Faculty of Artificial Intelligence and Data Science. Cumulative GPA: 3.78 / 4.00. Focus: Enterprise Information Systems & Data Innovation. Direct alignment between academic data engineering concepts and enterprise retail automation pipelines.
Visit Website
Technical Certification
Online Credential Verification

Dicoding Indonesia

Verified Technical Path · Web Development Fundamentals
🎖️ Certification Verified Credential ID: N9ZONW8KYXG5
Issued 26 Juli 2026 · Verified Online Credential
Verified credentials in web development fundamentals, including HTML, CSS, responsive design, and semantic web structure.
Dicoding Certificate — Willy Lengkong
Verify Certificate on Dicoding.com
Visit Website
0
Faster Reporting Workflow
0
Processing Time Saved
0
Daily Reports Automated
0
Retail Stores Analyzed
Get In Touch

Let's Collaborate

Have a data challenge, reporting need, or workflow that could work better? I'm open to strategic projects where data, technology, and problem-solving come together let's talk.

Direct Email
willylengkongg@gmail.com
WhatsApp Direct
+62 822-8115-7451
Location
Jakarta, Indonesia
Available for Strategic Projects

I am open to opportunities in data analytics, business process improvement, and technology-driven solutions. Feel free to connect!

Action completed