Lidya Aprillia

Media Planning · Cost & Budget Analysis

Lidya Aprillia

Media planning professional with an accounting background, turning campaign, cost, and audience data into clear insights on media investment efficiency at SCTV & Indosiar.

“Work hard and enjoy the journey.”

Get in touch Download CV View experience
Portrait of Lidya Aprillia

01About

Media planning professional with an accounting background and 1.5+ years of full-time experience at PT Surya Citra Media Tbk (SCTV & Indosiar). Experienced in media planning and monitoring, planned versus actual cost reconciliation, post-buy analysis, KPI tracking, and budget and cost performance reporting for management and key clients. Turns campaign, cost, and audience data into clear insights and recommendations on media investment efficiency, and applies Microsoft Excel (Advanced), Tableau, Arianna Software, and data automation using Claude Code.

02Experience

  1. Jan 2025 – Oct 2026 Full-Time

    Cost Per Rating Program Planner (Media Planning)

    PT Surya Citra Media Tbk · SCTV & Indosiar

    • Reconciled planned versus actual broadcast performance and program costs to track KPI achievement, audience performance, and media cost efficiency, supporting budget evaluation and planning decisions.
    • Conducted post-buy analysis and presented insights and optimization recommendations on planned versus actual campaign performance.
    • Planned and monitored cost per rating (CPRP) programs for SCTV and Indosiar, ensuring accurate and consistent media performance reporting across both channels.
    • Translated audience, cost, and performance data into actionable insights and recommendations through periodic reports for management and key clients.
    • Validated 100+ daily transactional and planning records to maintain data accuracy for internal and client-facing reporting.
    • Automated routine data processing and reporting workflows using Claude Code, reducing repetitive manual work.
  2. Jun 2024 – Sep 2024 Internship

    Accounting and Administration Intern

    PT Indo Global Gemilang

    • Reconciled customer and transaction data in Microsoft Excel to support accurate reporting and data validation.
    • Reviewed and validated advertising transactions against internal criteria and maintained supporting documentation.
  3. Feb 2024 – Jun 2024 Internship

    Cost Per Rating Program Planner Intern (Media Planning)

    PT Surya Citra Media Tbk · SCTV & Indosiar

    • Developed monthly media plans with the marketing team, aligned with campaign and client objectives.
    • Verified advertising spot and scheduling data to support accurate media placement and broadcast execution.
    • Managed advertising data retrieval and upload through Arianna Software for SCTV and Indosiar broadcast portals.
  4. 2023 Organization

    Project Officer, Accounting Building Career & Development Festival

    HIMA S1 Accounting, UPN Veteran Jakarta

    • Chief executive organizing a workshop and career talk held by HIMA S1 Accounting UPN Veteran Jakarta.
    • Career Talk theme: "The Importance of Understanding Data Analysis in The Auditing Career Path."
    • Workshop theme: "Build Personal Branding to Compete in the Career World."
    • Coordinated all divisions as project officer to help Bachelor of Accounting students grow through ABCD Fest 2023.
    Lihat Project

03Moments at Work

Lidya Aprillia with the team at Emtek Media office
With the team · Emtek Media office

04Projects & Research

2026 · Self-initiated

Corporate Budget & Management Report — Excel Simulation

Microsoft Excel · Budget Verification · Variance Analysis

  • Built a 9-sheet Excel model that simulates one annual budget cycle of a free-to-air TV network: verifying 25 departmental submissions, consolidating them into a corporate and programme budget, and reporting monthly Budget vs Actual with a full-year forecast.
  • Automated verification rules (document completeness, year-on-year cap, benchmark tests) flagged 7 of 25 submissions and reduced requests by 5.9% in the simulation; variance statuses use both a percentage tolerance and a materiality threshold.
  • Added TV-specific metrics — cost per episode vs genre benchmark, TVR and cost per TVR point — plus 9 automated integrity checks so every total reconciles across sheets.
Excel dashboard of the Corporate Budget and Management Report simulation showing revenue, opex and operating profit year-to-date, key takeaways, budget versus actual charts and department status
Dashboard output · simulation with fictitious data, built for practice
Budget submission verification sheet showing requested amounts, year-on-year change, document check, status and recommended approval for each item
Automated submission verification · status, recommended approval and reviewer notes
Unduh File Excel
LinkedIn · 2026

Beyond Cost Saving: A Multi-KPI Framework for AI Efficiency

Strategic & Data Analytics Commentary

  • Analyzed Klarna's AI chatbot case (2.3M conversations/month, 75% of customer chats across 23 countries) to evaluate the trade-off between cost efficiency and service quality.
  • Argued that measuring efficiency through a single cost-saving metric can mask real business impact on customer experience, loyalty, and brand trust.
  • Proposed a multi-KPI monitoring dashboard — CSAT, AI Escalation Rate, and Complaint Rate — with weekly operational review to rebalance AI-human composition based on performance data, not assumptions.
Lihat Post di LinkedIn
2026

Real-Time KPI Tracking Automation — Mayora Campaigns

Prefect · Tableau · Claude Skill Automation

Automated the Tableau-to-Prefect pipeline with a Claude skill that refreshes real-time KPI achievement data for Mayora campaigns three times a day (9 AM, 3 PM, 5 PM), saving roughly 33 hours of manual reporting a month while sharply improving data accuracy.

Mayora Daily Check dashboard showing automated %ACT campaign achievement tracking, with raw actual/estimate figures blurred
Live %ACT tracking output · raw figures blurred for client confidentiality
2026

PIB NPT Data Cleaning — Claude Skill

Tableau · Claude Skill

Built a Claude skill that cleans raw PIB NPT data pulled from Tableau on demand and outputs ready-to-use percentage estimates, cutting prep time by about 20 minutes per run so analysis can start faster.

Raw PIB NPT data pulled from Tableau, with product name, MO, and program name columns blurred
Raw input · product, MO & program columns blurred for confidentiality
Cleaned PIB NPT percentage result from the Claude skill, with product name and underlying figures blurred except the final percentage
Cleaned output · only the final % PIB estimate is left visible
Sep 2023 – Jun 2024

Journal Publication: Auditor Ethics

Published in SINTA 3 Indexed Journal

  • Wrote and examined the auditor's Machiavellian dimensions in ethical decision-making, reviewing 25+ academic references.
  • Interviewed an external auditor from a Big 4 public accounting firm as primary informant; published in a SINTA 3-indexed academic journal.
Lihat Project

05Skills & Tools

Core Skill

  • Media & Program Planning
  • Budget & Cost Analysis
  • Variance Analysis
  • Data Reconciliation & Validation

Soft Skill

  • Adaptability
  • Team Communication
  • Planning & Analysis
  • Team Work

Tools & Software

  • Microsoft Excel (Advanced)
  • Power BI
  • Tableau
  • Accurate Online
  • Zahir Accounting
  • PowerPoint
  • Word
  • Arianna Software

Zahir

Comfortable entering data for financial statements, making invoices, and recording company stock quickly, accurately, and efficiently.

Lihat Sertifikat & Project

Accurate

Quick at capturing sales, efficiently managing warehouse inventory, and accurate in producing comprehensive company reports.

Lihat Sertifikat & Project

Excel

Expert at processing data, active in using Excel formulas, and skilled at building worksheets that stay smooth, fast, and accurate.

Lihat Project

PowerPoint

Great at making PowerPoint presentations interactive, understandable, and targeted for report presentations.

Lihat Project

Word

Extensive experience writing scientific papers to competition-winning standard at the national level, and fast in writing.

Lihat Project

Tableau

Strong at processing and filtering data, building worksheets, and creating dashboards from the data presented.

Lihat Project

06Education

2021 – 2024

Bachelor of Accounting

Universitas Pembangunan Nasional “Veteran” Jakarta

Coursework: Auditing, Financial Management, Cost Accounting, Business Analysis

  • Organization: Himpunan Mahasiswa S1 Akuntansi (2023)
  • 1st Winner, National Investigative Audit Competition (2022), Universitas Kristen Duta Wacana Lihat Sertifikat
  • 2nd Winner, National Investigative & Forensic Audit Competition (2023), Universitas Trilogi Lihat Sertifikat
2019 – 2021

SMA Negeri 20 Jakarta

Social Sciences

07Certifications & Languages

  • Zahir User Certified (2023–2028)
  • Accurate Online (2023–2025)
  • Microsoft Office Specialist (2024)
  • TOEFL ELPT, UPN Veteran Jakarta (2024)
IndonesianNative
EnglishConversational

Let's talk planning & data

Open to media planning and cost & budget analysis roles focused on campaign investment and budget control.

Chat on WhatsApp Download CV