Rifky Mardiansyah — Digital Administration & Data Analytics

Jakarta, 2026

About Me

More Than
Just Admin.

Final-year student of D4 Digital Office Administration at Universitas Negeri Jakarta, GPA 3.82. I sit at the intersection of administration and technology — I don't just manage documents, I build the systems that manage them.

Currently completing my internship at TVRI, Indonesia's national broadcaster, where I catalogue decades of broadcast archives and maintain real-time documentation systems.

3.82GPA / 4.00

10+Tools Mastered

9+Projects Built

Winner — Best HR Services Innovation, Intl. Exhibition FEB UNJ 2024

Multimedia II Competency License

Toolkit

Core
Skills.

Tools I use to turn messy data and manual workflows into clean, reliable systems.

Data Analysis & Excel

SUMIF, VLOOKUP, PivotTables, dashboard design with real datasets

Office Suite

Word, PowerPoint, advanced document formatting and automation

Web Development

HTML, CSS, Bootstrap, Supabase — functional web apps from scratch

No-Code / AppSheet

GPS attendance, role-based apps, automated PDF reports — zero code

Creative Media

Adobe Suite, visual communication, event documentation

Digital Archiving

Metadata systems, document retention policy, broadcast archives

Portfolio

Selected Work.

9 Projects

Internship Experience

Broadcast & Archive

TVRI: Broadcast Archive

Managing historical physical assets and daily digital broadcast records at Indonesia's national broadcaster.

MetadataArchivingSPS System

IT & Admin

Telkom: Network Data Audit

Verified 100+ ONT device records at PT Telkom Indonesia, cleaning regional asset data to eliminate inconsistencies.

ExcelAuditIT Support

Systems & Development

Web App

SeDaP: Digital Archiving

Web-based document management with automated archive expiry, real-time activity logs, and role-based access.

HTML/CSSSupabaseSystem Design

No-Code App

Mobile HRIS (AppSheet)

A full HR mobile app — GPS attendance, photo check-in, role-based views, auto PDF reports. Built without code.

AppSheetNo-CodeAutomation

Data Analytics

Excel Dashboard

E-Commerce Sales Dashboard

99,441 real orders from Olist (Kaggle), turned into a multi-sheet Excel dashboard with 1,263 formulas.

ExcelSUMIFReal Data

Excel Dashboard

Customer Database & CRM

25 clients, 60 interactions, and a sales pipeline — all connected via VLOOKUP with weighted pipeline value tracking.

ExcelVLOOKUPCRM

Excel Dashboard

HR & Payroll Tracker

Employee master data, attendance recap, and automated payroll using VLOOKUP across sheets — simulating a real HR workflow.

ExcelVLOOKUPPayroll

Excel Dashboard

Inventory & Stock Management

Stock tracking with automatic reorder alerts, stock movement log, and category breakdown — all formula-driven.

ExcelIF / SUMIFInventory

Excel Dashboard

Budget & Expense Report

Budget plan vs actual spending per division, with variance analysis and automatic On Track / Over Budget status.

ExcelSUMIFBudget Analysis

Operations

Event Operations

LinkedToTalk: Stage Manager

Full venue setup and stage flow for a 100+ person talk show — zero broadcast delays.

Stage ManagementOperationsLive Events

Broadcast & Archive

TVRI — Student Intern

Pengelola Materi Audio Visual (PMAV) · Feb – Mei 2026

What I Did Here

As a Student Intern at the PMAV division, my role covered both inactive physical tape archives and active daily digital broadcast documentation — keeping everything catalogued and findable.

Entered active metadata — daily news rundowns and broadcast scripts — into the SPS system in real time
Catalogued inactive physical tape archives, labelling cassettes and entering structured metadata into a centralised spreadsheet
Performed content transcription from broadcast materials for TVRI's digital platforms (YouTube)
Maintained consistency between physical tape records and their digital documentation counterparts
Supported the division's data entry workflow across both inactive archive and active broadcast materials

MetadataArchivingSPS SystemTranscriptionSpreadsheet DB

IT & Admin

PT Telkom Indonesia — Data Audit

Internship · Feb – Apr 2020

What I Did Here

Tasked with auditing Optical Network Terminal (ONT) device records for Telkom's regional division — the data was inconsistent with mismatched IDs and outdated statuses.

Cross-checked 100+ ONT device records against field technician reports
Consolidated everything into a clean, verified Excel report for regional management
Coordinated directly with field technicians to resolve on-site data discrepancies
Streamlined the reporting process with timely status updates to supervisors

ExcelDatabase AuditIT SupportRegional Reporting

Web App

SeDaP — Smart Archiving System

HTML / CSS / Bootstrap / Supabase · Mar – Jun 2025

The Problem I Solved

SeDaP replaces messy physical filing with a centralised web system featuring automated archive expiry and full activity logs.

Built a responsive web app for centralised document tracking and retrieval
Implemented automated archive destruction logic based on document retention rules
Engineered real-time activity logs for every user action — security and audit ready
Integrated Supabase for database operations and user authentication
Designed clean dashboard UI using Bootstrap — no prototyping tools

Read Manual

No-Code App

Mobile HRIS — AppSheet

Google AppSheet · Award Winner 2024

No Code. Full Functionality.

Replaced paper-based HR processes with a functional mobile app using Google AppSheet — no custom backend needed.

GPS geofencing to verify attendance location in real time
Mandatory photo verification for every clock-in and clock-out
Role-based access control — separate admin and employee views
Automated monthly PDF attendance reports — zero manual compiling
Result: 100% elimination of paper-based HR forms

AppSheetGoogle SheetsGPS GeofencingAuto PDF

Excel Dashboard

E-Commerce Sales Dashboard

99,441 Real Orders · Kaggle / Olist Dataset

📊project-olist.jpg

What This Is

Olist's public e-commerce dataset turned into a proper multi-sheet Excel dashboard. Every number is formula-driven — no hardcoded values.

5-sheet workbook: Dashboard, Data helpers, Monthly Summary, Category Summary
1,263 real Excel formulas — SUMIF, COUNTIF, IF, cross-sheet references
73 product categories analyzed across 3 years (2016–2018)
Year-on-year growth, monthly trends, and delivery performance included

Download .xlsx Data Source

Excel Dashboard

Customer Database & CRM

25 Clients · 60 Interactions · Sales Pipeline

🤝

What This Is

A full CRM simulation covering customer master data, interaction logs, and an active sales pipeline — all connected via VLOOKUP with weighted pipeline value per stage.

4 sheets: CRM Dashboard, Database Pelanggan, Log Interaksi, Sales Pipeline
VLOOKUP auto-fills company name and industry in every interaction log row
Pipeline weighted value = estimated value × closing probability per stage
COUNTIF & SUMIF breakdown by status, industry, pipeline stage, and lead source
183 real Excel formulas across all sheets

Download .xlsx

Excel Dashboard

HR & Payroll Tracker

20 Employees · April 2026 Simulation

👥

What This Is

End-to-end HR simulation covering employee master data, attendance, and automated payroll — all connected via VLOOKUP across sheets.

4 sheets: HR Dashboard, Data Karyawan, Rekap Absensi, Slip Gaji
Payroll auto-calculates gaji bersih using VLOOKUP from employee master data
Attendance IF formula labels each employee: Baik / Cukup / Perlu Perhatian
SUMIF breakdown of salary totals and headcount per division
265 real Excel formulas — VLOOKUP, SUMIF, COUNTIF, AVERAGE, IF

Download .xlsx

Excel Dashboard

Inventory & Stock Management

20 Items · 50 Mutations · April 2026

📦

What This Is

A stock management dashboard tracking 20 office supply items with automatic reorder alerts, movement logs, and category breakdown.

3 sheets: Inventory Dashboard, Stok Barang, Mutasi Barang
IF formula auto-flags status: Aman / REORDER / HABIS based on minimum stock
VLOOKUP pulls item price into every mutation transaction automatically
50 stock movement records (in/out) with total value calculation
SUMIF breakdown of total stock value per category

Download .xlsx

Excel Dashboard

Budget & Expense Report

Q2 2026 · 6 Divisions · 45 Transactions

💰

What This Is

A Q2 budget planning and expense tracking workbook with automatic variance analysis — showing exactly where each division is over or under budget.

4 sheets: Budget Dashboard, Anggaran, Realisasi, Budget vs Aktual
IF formula auto-assigns status: On Track / Over Budget / Under Utilized
VLOOKUP pulls division and category from budget plan into expense records
SUMIF aggregates actual spending per division for real-time comparison
236 real Excel formulas — SUMIF, VLOOKUP, IF, cross-sheet references

Download .xlsx

Event Operations

LinkedToTalk — Stage Manager

100+ Attendees · Sep – Nov 2025

What I Did Here

Made sure every segment ran on cue and every technical element was in place before the lights went up.

Managed full venue setup and stage flow across all event segments
Coordinated vendors, performers, and technical crew pre-show
Resolved on-site technical issues in real time — zero delays
Supervised crowd movement and safety around the stage area

Event ManagementStage CoordinationLive Operations

Turning Office Chaos Into Clean Systems.

More ThanJust Admin.

CoreSkills.

Selected Work.

TVRI: Broadcast Archive

Telkom: Network Data Audit

SeDaP: Digital Archiving

Mobile HRIS (AppSheet)

E-Commerce Sales Dashboard

Customer Database & CRM

HR & Payroll Tracker

Inventory & Stock Management

Budget & Expense Report

LinkedToTalk: Stage Manager

TVRI — Student Intern

What I Did Here

PT Telkom Indonesia — Data Audit

What I Did Here

SeDaP — Smart Archiving System

The Problem I Solved

Mobile HRIS — AppSheet

No Code. Full Functionality.

E-Commerce Sales Dashboard

What This Is

Customer Database & CRM

What This Is

HR & Payroll Tracker

What This Is

Inventory & Stock Management

What This Is

Budget & Expense Report

What This Is

LinkedToTalk — Stage Manager

What I Did Here

Turning Office
Chaos Into Clean
Systems.

More Than
Just Admin.

Core
Skills.