Product & System Design
Uncovering underlying pain points while ensuring a holistic human-centered design, ranging from digital systems, products, to features
Product Design
Personal product design projects that impacts people, community, and society
MyNeighbor / TetanggaKu App
MyNeighbor believes that everyone—especially those in need—is our neighbor whom we should love. Hence, with the limited resources that this world has, and yet the abundant needs others have, MyNeighbor serves to create a culture of genuine giving where we are all able to be good stewards by redistributing the resources from the people who are more fortunate than others to those that are truly in need by informing the needs of this world and enabling people to share their resources (both monetary and in-kind) efficiently, generously, and genuinely to our neighbors in need for the flourishing of the society.
Role: Founder & Product Manager
Design Output:
Research on NGO industry & landscape comparison between Indonesia & USA
User persona & pain points from primary market research via surveys & interviews
Low & high-fidelity wireframes via figma
Digital brand guideline
Working prototype
Technical MVP Features:
Full-stack web app prototype using Flutter framework & Firebase for backend for giving & receiving in-kind donations
Language localization to switch web app between Bahasa Indonesia & English
Honorable Mention:
MyNeighbor was selected as one of the top 12 projects out of 56 submissions at the COVID-19 Global Church Hackathon
(On-hold due to co-founder hiatus)
Goodkind.id
Goodkind.id is a digital application aimed at making it easier for public servants to connect with their communities, raise funds, and build a digital footprint. We also provide a platform for the general public to file complaints and support public servants who are clean, fair, and dedicated to serving the people.
Role: Product Manager (Reported to Founder/CEO) & Founding Secretary
Technical Features:
Prospective Legislative Candidates Profile
Prospective Legislative Candidate Onboarding
Complain Ticket System
Recognitions:
Endorsed by the former governor of Jakarta
Live Platform: goodkind.id
Systems Design
Out-of-the-box system feature limitation requires creative, technical, robust, and scalable solutions that are compliant with regulatory authorities and organizational policies
Payment Acknowledgement (PAIN002) Sorting Program
Designed an SAP program that sorts incoming payment acknowledgement (PAIN002) incoming from multiple global banking partners. This program sorts which PAIN002 belongs to payments originating from SAP vs. Quantum Treasury Management System (TMS).
In-House Cash (IHC) Payment Factory Document Chain Report
Designed a report with drill-down capabilities in SAP that will track and report on the end-to-end Payments-on-Behalf-of (POBO) factory lifecycle from invoice, payment request, IDOC, payment document, to bank statement document.
Designed an end-to-end payments interface and process between Quantum TMS and SAP that adheres to multiple system specifications, from SAP S/4HANA, SAP Multi-Bank Connectivity (MBC), Swift Network, to Banking System.
Treasury Boundary Systems Payment Factory
Payments Exception Report
Designed a program that catches payment exceptions before actual payment runs are executed. This program will generate a report that allows Payment Processors to review and triage issues before problems arise.
Automatic Payment Reversal
Payment Error Alert Notification
Designed an enhancement that triggers when a payment item generated from the system is rejected by the bank. This enhancement will reverse the payment accounting document and block the corresponding invoice accounting document.
Designed a program that sends an email notification whenever there are any message errors in SAP MBC. The email will contain a spreadsheet attachment of the error messages for IT Services to check the error messages and triage the issue(s) accordingly.
Payment Acknowledgement Pre-Processor Transformation
Designed a program that ingests a payment acknowledgement file (PAIN002) on a directory level and transforms the XML file into a target folder while archiving the original file. The transformed file will have all required tags within each PAIN002 adhere to ISO standards for SAP to be able to process the payment status.
Electronic Bank Statement File Rename Program
Designed a program that will ingest files within an application server directory with a certain naming pattern, then move the file to a target folder with a certain naming convention pattern while archiving the original file and ensuring proper success/error logs.
Cash Forecasting for Ending Bank Balance & Sales Contract Program
Designed programs that will help SAP's standard Cash Flow Analyzer (CFA) to forecast Sales Contracts and Bank Account Closing Available Balance from the Electronic Bank Statement instead of accounting document amounts. This helps Treasurers perform accurate cash forecasting without being dependent on cash reconciliation.
Designed a market data interface via Bloomberg Data<GO> API into SAP S/4HANA for Foreign Exchange (FX) currency spot rate and forward rates on a daily and monthly basis, respectively.
Designed an interface and process to ingest 3rd Party Banking Data from LexisNexis Accuity, along with an interface mapping to migrate legacy SAP ECC banking data to SAP S/4HANA system.
Bloomberg FX Currency Rates Interface
Bank Key Master Conversion Program
Cash Position Analytics Dashboard
Designed analytics dashboards for Cash Positioning, Cash Flow Reporting & Forecasting, and Financial Planning & Analysis (FP&A) for Fixed Fee & Resource Bill Rate contracts.
Software Development
Building specific software solutions and components to solve specific use cases that help understand technological capabilities and frameworks for future design
PlantBit IoT: The FitBit for Plants
Developed an Internet of Things (IoT) system for plant photoperiod regulation and growth metric tracking using Swift, Google Assistant, DialogFlow, FireBase, and Arduino over a 24h timeframe during a group hackathon.
Awards:
1st Place Major League Hacking (MLH) at Calvin University Winner
3rd Place Calvin Startup Winner
GitHub: PlantBit IoT
Material Resource Planning (MRP) System
End-to-end development of an MRP system from its front-end (C#) to back-end (SQL DBMS). This includes:
Understanding all use cases and requirements
Designing relational database structure, stored procedures, indexes, and views
Designing and creating the graphical user interface (GUI) using .NET framework in Visual Studio
GitHub: MRP Design
Developed a Visual Studio 2017 WinForm Solution using C# to derive information from the Four Gospels flat text file (.txt). The solution will parse .txt and create a dataset in a text file with a list of all unique words along how many times that word appears in the parsed text file. Output dataset will go through ETL and be visualized using Excel and Tableau, respectively, for data exploration and hypothesis validation.
GitHub: Text Parser
Text Parser Software Solution
Additional notable projects as the IT & Data Management Department Founder at the Fellowship of Indonesian Christians in America (FICA) include, but are not limited to, Google Analytics Dashboard, OpenAI LLM Chatbot, FlightAPI Cost Analyzer, FICA Alumni Database, FICA Constituent Data Visualization, and many more.