o
i
l
o
f
t
r
o
P
t
n
a
t
s
i
s
s
a
e
executiv
i
r
t
i
f
a
s
a
l
i
b
a
n
Hello, I‘m
Nabila Safitri
Industrial Engineering student and Data Management specialist focused
on operational efficiency. Expert in building automated tracking systems
and interactive dashboards to ensure high-level Data Integrity and Quality
Assurance.
With experience overseeing team operations and multi-million dollar
datasets, I bring a 'zero-error' approach to Data Cleaning and Record
Keeping. I am highly tech-savvy in digital workspaces and committed to
providing proactive Executive Support to streamline business workflows
in a remote environment.
linkedin.com/in/nabilasafitri29
-
-
My Education
Institute Technology Sepuluh Nopember
Bachelor of Chemistry | GPA 3.27/4.00
Participation:
1. BEM ITS
Head Sub-division of Student
Advance Development
-
2. Chemistry Association Student ITS-
Committee of Student Development
Personal Skill
Data Management
Workflow Automation
Strategic Executive Support
Experienced in maintaining high-integrity databases
and automated trackers, demonstrated by managing
million-dollar
sales
datasets
and
complex
operational files with 100% accuracy.
Proficient in leveraging advanced Excel and digital
workspaces to streamline administrative processes,
rooted in an Industrial Engineering background
focused on systemic efficiency.
Experienced in managing high-level calendars,
confidential record-keeping, and cross-departmental
communication to optimize leadership workflows and
ensure flawless internal operations.
Experience
BEM (Student Executive Board), ITS
As Head of Sub-Division
As part of my student-organization duties, I managed the operational side of Instagram content publishing by building and
maintaining a structured content tracking system. The goal was to ensure on-time posting, organized collaboration with
assistants/designers, and visibility across content status, deadlines, and distribution platforms.
I developed a centralized Social Media Content Tracker using Google Sheets to streamline the publishing workflow from
content planning to live posting.
Objective
Ensure consistent and on-time Instagram posting
Prevent scheduling conflicts and upload errors
Create transparent workflow tracking for team collaboration
Monitor content readiness across multiple platforms
Reduce missed deadlines and last-minute revisions
Experience
BEM (Student Executive Board), ITS
The tracker includes structured columns for:
Content title & short description
Content output format (Feed, Story, Post IG)
Upload date & exact upload time
Status tracker (On Track / Late / Revision / Done)
Deadline for assistant submission
Countdown to upload deadline
Google Docs link (caption draft)
Google Drive link (creative assets)
Multi-platform checklist (Instagram Feed, Story,
TikTok, Twitter, LinkedIn, YouTube, Website)
Project #1
Operational Systems &
Team Performance
Tracking
In this project, I was responsible for architecting and
managing the operational backbone for Britzone
Surabaya. My primary goal was to ensure that all
departmental activities remained on track through a
centralized, data-driven system, minimizing the need
for constant oversight by leadership.
Project #1
Objectives & Selling Points:
Automation: Remove repetitive manual updates and
notifications.
Data integrity: Ensure consistent, validated HR data for accurate
planning.
Administrative support: Streamline routine HR tasks so admins
can focus on higher-value work.
Deliverables
Automated HR Planning workbook (Excel + Google Sheets-ready)
Leave & attendance tracker with validation rules
Onboarding checklist & task tracker
Dashboard templates for weekly/monthly reports
SOP + short user guide for admins
Project #1
Unified template: Built a modular Excel / Google Sheets
workbook separating input sheets (protected) from
reporting/dashboard sheets (read-only).
Data validation & controlled input: Dropdowns, date pickers,
and protected ranges to prevent inconsistent entries and
accidental overwrites.
Automation layer: Implemented formula-driven workflows and
lightweight automation (Google Apps Script or Excel macros)
for tasks such as status updates, deadline reminders, and
automatic aggregation of monthly headcount changes.
Auditability: Added change logs and version snapshots to track
edits and restore prior states when needed.
Dashboards & reports: Created pivot summaries and visual
dashboards for headcount, upcoming onboarding, leave
balances, and open roles, exportable to PDF for stakeholder
meetings.
SOP & handover: Supplied a concise SOP and user guide for
admins, including how to run automations and troubleshoot
common issues.
Project #2
Sales Analytics
Dashboard
This project features a Comprehensive
Sales & Profitability Dashboard designed
to empower executive decision-making. It
consolidates high-level KPIs with detailed
analysis of temporal trends, customer
demographics, and product performance.
Project #2
Key Value Propositions:
Correlation Analysis (Sales vs. Profit Margin): Implemented a dual-axis visualization
to track monthly sales volumes against profitability percentages.
Market Composition Analysis: Integrated a donut chart to visualize sales distribution
across segments, revealing that the Consumer segment accounts for 50% of total
revenue ($1.16M).
Product Portfolio Ranking: Developed a "Top 10 Product" ranking system to identify
key revenue drivers.
Interactive Filtering: Built a robust filtering system allowing users to slice data by Year,
Region, Segment, and State for localized and period-specific insights.
Project #2
Raw Data
Technical Skills Demonstrated:
Helper sheets (pivoting)
Holistic Dashboard Architecture: Balancing high-level
metrics (Total Sales of $2.3M) with granular product and
regional data.
Data Visualization Best Practices: Utilizing professional
color schemes, clear data labeling, and intuitive chart
selection to maximize "Data-to-Ink" ratio.
Tools Used: Microsoft Excel (Slicers, Pivot Tables, Dual-Axis Charts, Donut
Charts, Top-N Filtering)
Project #3
Advanced Sales
Benchmarking & Variance
Analysis Dashboard
This project showcases an Advanced Sales
Benchmarking & Variance Analysis
Dashboard. It is designed to provide statistical
context to sales figures by comparing annual
performance and monthly trends against a 4year historical baseline -).
Project #3
Raw Data
Technical Skills Demonstrated:
High-Level Visualization: Mastery of complex
Excel chart structures, data labeling, and
professional layout design.
Analytical Thinking: Implementing statistical
baselines and variance calculations to drive datainformed decision-making.
Project #3
Key Value Propositions:
Sophisticated Variance Mapping: Leveraged advanced charting techniques, including
the use of "invisible helper bars," to dynamically position YoY variance indicators and
percentage labels.
Developed a comparative model that measures current monthly sales against a longterm historical average. This helps businesses distinguish between standard seasonal
patterns and genuine performance shifts.
Fully integrated with Slicers to allow users to filter performance by region, providing a
granular view of sales trends across the entire organization.
Tools
Managed professional
communication channels by
setting up response-time
protocols and automated
reminders to optimize team
Workflow and maintain
seamless leadership-to-staff
coordination.
UI layout drafting, content
mockups, and collaborative visual
planning.
Architected a synchronized timeline
and project schedule to manage
complex organizational events,
ensuring Executive Support by
streamlining task deadlines and
coordinating cross-departmental
calendars.
Used as the primary engine for
high-level data management and
executive reporting.
Thank
You!
!
E
T
A
R
O
B
A
L
L
O
C
S
’
LET