Back
Client Work / 2024
Tatitatu.Id
Bussines Process Optimization
Transformed Tatitatu Operational Process from scattered spreadsheets to an integrated system saving hours of manual effort, minimizing errors, and giving the team realtime control over their operations.
Role
UI/UX Designer / System Analyst / Project Manager
Duration
a Month
Context and Problem
Tatitatu is a wholesale and retail accessories company under Dansa Bonifade Indonesia, producing and distributing handmade bracelets and jewelry to various outlets and business partners. Despite its growth, all operations from production to payroll were still managed manually through multiple spreadsheets.
This caused several recurring issues in daily operations:
Updating stock, material costs, or prices required editing several sheets one by one — a slow and error-prone process.
Payroll was recalculated daily. Attendance was submitted via chat and manually converted into per-minute wages by supervisors.
Cost of good sold (COGS) and bonus calculations were scattered. Data for cost, KPI, and payroll were stored in different files and had to be merged manually each month.
Production wasn’t connected to distribution. Tracking materials, finished goods, and sales performance in real-time was nearly impossible.
To solve this, we aimed to unify all operational processes into one connected system improving efficiency, and visibility across the entire workflow.
Process and Challange
In this project, I took on a dual role as System Analyst and UI/UX Designer. The Tatitatu team needed the system ready within a short time frame, as it would be used to support their new outlet launch. This meant I had to analyze and design an end-to-end system for 9 user roles and over 15 interconnected features all within one month.
The challenge wasn’t just technical or time-related it was human and structural. Each department had its own spreadsheet logic, formulas, and recording habits. Unifying these differences required changing behavior without disrupting familiarity the new system had to feel natural yet faster and more reliable.
We also had to:
Analyze a long and fragmented business flow with incomplete documentation.
Design an interface intuitive enough for non-technical users.
Maintain alignment between designer, developer, and client under tight deadlines.
Manage ongoing feedback and new bugs even after modules were declared “final.”
I collaborated closely with the project manager and Tatitatu’s internal supervisors. We started with in depth interviews and live sketching sessions to map out their existing workflows. To keep the transition smooth, I studied every spreadsheet and formula from COGS calculations to bonus logic and mapped how each data point connected. This helped me transform their manual workflow into a structured, digital system that still felt familiar.
We analyzed each feature by user type while I simultaneously built a design system to ensure efficiency and consistency during the high-fidelity design stage. After every user interview, I discussed implementation details directly with the developer to ensure the logic could be realistically applied. Once a feature was finalized, I conducted regular usability testing with real users.
Some key feedbacks that shaped the iterations included:
Color differentiation for user roles. Users working in different outlets needed clear visual indicators for their respective roles.
Instead of clicking “+” or “–” repeatedly, users can now add items instantly with a single tap, streamlining adding item.
After all features and user flows were finalized, I created a user feature matrix table summarizing which users could access which modules.This documentation helped both the development team and the client track progress and avoid misunderstandings.
Taking Over as Project Manager
When the project manager couldn’t continue until completion, I stepped up to ensure the project stayed on track. Although I don’t have a technical background in coding, I managed the team by conducting regular check in every three days and setting clear feature delivery goals. During development, user error reports came in daily. To handle them systematically, I created a dedicated error log spreadsheet containing the issue location and description, helping developers trace and fix problems faster. After each fix, I conducted post checks across modules to ensure no new bugs appeared in other parts of the system.
Impact
Processes that were once manual and scattered are now centralized, faster, and easier to control.
Everything from payroll and KPI bonuses to COGS calculations, stock monitoring, and inter outlet distribution is now integrated in one connected system.
Overall, the system successfully:
Simplified workflows from production to sales.
Increased business process efficiency.
Saved significant time in daily operations and reduced human error.
Reflection
This project taught me how system complexity and time constraints can shape communication and expectations.
Because Tatitatu’s business process was long and layered, we decided to discuss the system feature by feature in each session making it easier for everyone to understand and agree.
However, as the project progressed, some misunderstandings arose certain features were thought to be missing even though they had already been discussed and approved. This experience reminded me that clear documentation and a complete system visualization from the start are essential for shared understanding.
From this project, I learned that designing complex systems requires:
Transparent and structured documentation.
Written agreements on finalized features.
A full system overview early on to maintain consistency in later development stages.
