Looking for a job

William Andreas

@williamandreas

Data Analyst at PT. Nirwana Lestari who cut monthly reporting turnaround by ~77% through commercial and margin analysis.

Indonesia

Message

At PT. Nirwana Lestari, I streamlined monthly commercial and margin reporting, reducing turnaround time by ~77%. I analyze sales, volume, pricing, COGS, gross profit, and GPM to identify performance drivers and trends.

I also streamlined purchase reconciliation across SAP data, reducing turnaround time by ~33%, and used risk-based sampling to check disposal records against physical warehouse inventory.

At PT. Dachin Etech Global, I researched consumer behavior and benchmarked e-commerce and retail products to inform market opportunities and product positioning. Earlier, I mentored four data science cohorts at PT. Purwadhika Kirana Nusantara; three cohorts graduated and moved into data-related roles.

Experience

Work history, roles, and key accomplishments

Current

Compliance Analyst

Current

PT. Nirwana Lestari

Nov 2024 - Present (1 year 11 months)

Streamlined monthly commercial and margin reporting, reducing turnaround time by ~77% while analyzing sales, volume, pricing, COGS, gross profit, and GPM. Streamlined purchase reconciliation workflows across SAP data, reducing turnaround time by ~33%.

SQL SAP Data Analysis Reporting Reconciliations Risk Based Sampling Excel

Market and Consumer Research Analyst

PT. Dachin Etech Global

Jul 2024 - Nov 2024 (4 months)

Conducted quantitative and qualitative consumer research to identify purchase behavior, channel preferences, and product needs. Analyzed e-commerce and competitor data to benchmark prices and sales performance, and coordinated field research operations.

Quantitative Research Qualitative Research Competitive Benchmarking Data Analysis Survey Design Field Research Coordination

Data Science Lecturer

PT. Purwadhika Kirana Nusantara

May 2021 - May 2023 (2 years)

Mentored 4 data science cohorts through hands-on projects and career preparation, with 3 cohorts successfully graduating and transitioning into data-related roles.

Data Science Mentorship Training Python Machine Learning