Fran Sumawijaya
Based inWest Java, IndonesiaCurrentlyInformation Systems, Satu University (Binus Curriculum)AlsoAssistant Lab, Database Systems
Download CV

About

The unusual
background.

I spent three years inside a real business, managing industrial product lines, navigating client relationships in oil and gas, and reconciling financial systems. That is where I learned what operational complexity feels like from the inside.

Now I am building the systems thinking and analysis layer on top of that. Not because I transitioned out of the business world, but because I realized the best consultants are the ones who have lived the problems they solve.

I am currently pursuing Information Systems at Satu University, working as a Database Systems Lab Assistant, and taking on systems analysis projects where I can apply both sides of what I know.

Experience

1. Commercial & Operational ExperienceBuilt inside real businesses, understanding how operations and finance actually flow.

PT Aloindo Mega Andalan — Sales Executive & Financial Operations (2023–2025)

Market AnalysisMonitored and forecasted quarterly price fluctuations for steel commodities to support procurement and sales strategies.
Supply Chain ManagementManaged end-to-end communication and logistics for industrial product imports from suppliers in China and Thailand.
Financial AdministrationHandled project-based financial tasks, including tax reporting (PPN), invoicing, and reconciliation of accounts.
Client ConsultationRecommended technical specifications for industrial products (pipes, fittings) based on specific project needs in the energy and construction sectors.

Satu University — Marketing & Enrollment Consultant (2024–Present)

Represented the university as a consultant for prospective students, providing guidance on academic programs and career pathways through school visits and engagement events.
2. Systems & Technical ProjectsArchitecting logical frameworks, databases, and structural solutions.

Woofbar ERP System — Project Lead & System Analyst

System ArchitectureConducted "As-Is" and "To-Be" analysis to design a vertical ERP system for pet services (Hotel, Grooming, Taxi).
Database DesignArchitected a relational database included pricing engine, logical availability and business rule engine, ensuring data integrity across 7 integrated business modules.
Knowledge ManagementIntegrated an embedded KM module within the system to centralize operational documentation and workflows.
Project ManagementFormulated the roadmap, defining project scope, constraints, and initial development milestones.

Satu University — Database Systems Teaching Assistant (2024–Present)

Mentored students in Database Management Systems (DBMS) fundamentals, including SQL optimization, complex queries, and relational concepts.

Startup Competition — Hipster Strategist (1st Winner DIGCOFEST UNESA)

Managed business development, financial projections, and conducted trade-off analysis for the project's initial ideation phase.
3. Strategic Branding & DesignTranslating business value into clear, compelling technical and visual communications.

Frans Keith Design & Branding — Principal & Creative Lead (2023–Present)

Fuumi Coffee BrewerySocial Media, Branding, & Digital Marketing (2023)
Fanzztrip (Concert Trip)Branding & Digital Marketing Strategy (2023)
Own Lab (TikTok Agency)Branding & Product Strategies (2025)
Avrora Story (Wedding Organizer)Branding & Product Strategies (2024)
Endolita UMKMVisual Identity & Branding Design (2024)
20+ Graphic Design ProjectsExecuted various visual communication and digital assets for diverse niche clients.

Eisen Bower Production House — Visual Communication & Creative Director Assistant (2022)

Bank IndonesiaDesigned data visualization reports to improve the readability and presentation of financial data.
Creative AssetsHandled video editing and assisted in production workflows for brands like Blackbealt and Ariston Indonesia.
4. Leadership & Academic BackgroundTheoretical foundations and soft-skill validations.

OneTalk Public Speaking Club — Founder & Lead Mentor (2024–Present)

Established the organization and developed a structured curriculum for public speaking and communication training.

HIMASIF Satu University — Business Development (2024–Present)

Managed funding initiatives and provided strategic recommendations for student organization programs.

Education

Satu University (2024–Present)Bachelor of Information Systems.
SMKN 14 Bandung (2020–2023)Multimedia / Visual Communication.

Skills and tools

Systems and Analysis

UMLBPMNSystems thinkingDesign thinkingVisual Paradigm

Business

Business developmentNegotiationAgileJiraTrello

Design and Communication

FigmaIllustratorPhotoshopCopywritingPublic speaking

Languages

IndonesiaEnglishJapan