Accounting Spv. at Eksekutif Computer (2022-01 – Present)
Financial Reporting, Accounting Software Proficiency, Financial Reconciliation, Inventory Management, Inventory Analysis, ERP System Development, Business Process Automation, Data Integration, and Data Visualization
- Prepare and manage comprehensive financial statements on a daily, monthly, and annual basis to ensure fiscal transparency
- Execute and manage transaction journals using Zahir Accounting and Accurate software with high precision
- Perform regular data reconciliation to ensure the accuracy and consistency of financial reports across all platforms
- Manage and organize detailed inventory reports, ensuring structured tracking of all assets
- Conduct in-depth analysis of inventory turnover, including movement trends, dead stock identification, and supply chain efficiency
- Design and develop custom ERP systems using Google Sheets integrated with Looker Studio for advanced reporting and interactive dashboards
- Build and deploy web applications via Google Apps Script to automate workflows and significantly enhance operational efficiency
- Streamline and centralize data across Finance, Operations, and Inventory departments into a single, unified system
- Create real-time visual dashboards to monitor business performance and support strategic decision-making
Data Engineer / Fullstack Developer (Freelance) at ORE Consultant (2024-01 – Present)
Custom ERP Development, Web Application Development, Data Pipeline Construction, Database Management & Optimization, Workflow Automation, and Dashboard & Analytics
- Architected and deployed a customized ERP system using Google Sheets as a database and Google Apps Script for back-end logic
- Developed and maintained full-stack web applications using Google Apps Script to streamline internal business processes and user interfaces
- Engineered automated data pipelines to extract, transform, and load (ETL) financial and inventory data from various sources into a centralized system
- Optimized spreadsheet-based databases for high performance, ensuring data integrity, security, and real-time synchronization
- Designed and implemented advanced automation scripts to eliminate manual data entry, reducing human error and increasing operational speed
- Built interactive business intelligence dashboards using Looker Studio, providing stakeholders with real-time visibility into key performance indicators (KPIs)
Business Consultant at Kandada Consultant (2014-01 – 2015-12)
Business Concept Planning, Data Analysis & Field Survey, Cost Estimation & Budgeting, Project Proposal Development, Project Funding Consultancy, and Strategic Advisory
- Developed and structured comprehensive business concepts, including strategic frameworks and operational models
- Conducted in-depth data analysis and on-site field surveys to gather actionable insights and market intelligence
- Formulated detailed Budget Plans (RAB) to ensure financial feasibility and project cost control
- Authored professional project proposals and pitch decks for internal and external stakeholders
- Provided strategic consultancy regarding project funding, including capital structure and investment readiness
- Advised on project viability and resource allocation to optimize business outcomes
Accounting Spv. at Rai Fitness Indonesia (2015-01 – 2021-12)
Financial Reporting, Accurate System Management, Tax Compliance, Budgeting & Investment, Audit & System Optimization, Application Development, and IT & System Coordination
- Prepared comprehensive financial statements including Profit & Loss, Cash Flow, and Balance Sheets (initially managed via manual Excel prior to Accurate implementation)
- Handled data entry and financial reporting using Accurate accounting software
- Prepared and managed local tax reporting (Pajak Daerah) in accordance with regulations
- Developed Budget Plans (RAB) for investment purposes and capital expenditure
- Conducted financial statement audits and restructured administrative systems to improve accuracy and workflow
- Developed custom application systems using Excel VBA (Visual Basic for Applications) and MS Access; successfully implemented these as Token Systems at Rai Fitness and Rai Licious Cafe
- Managed and coordinated IT infrastructure and customer/member information systems to ensure data integrity and service continuity
Accounting Spv. (Freelance) at Rai Fitness Indonesia (2015-01 – Present)
Tax Compliance
- Prepared and managed local tax reporting (Pajak Daerah) in accordance with regulations
Accounting Staff (Inventory) at PT Cakrawala Mega Indah (2013-01 – 2014-12)
Accounting, Tax, & Inventory Operations and Financial & Analytical Reporting
- Analyzed and verified every transaction document and shipping record to ensure data integrity
- Managed data entry and tax documentation within the SAP ERP system
- Conducted regular Stock Take (Stock Opname) to maintain inventory accuracy and reconcile physical stock with system records
- Verified VAT (PPN) documents and handled comprehensive tax reporting to ensure regulatory compliance
- Performed detailed reconciliation for Income Tax Article 22 (PPh 22)
- Prepared monthly Cash Flow reports to monitor liquidity and financial health
- Developed monthly Sales Reports to track revenue trends and performance
- Compiled Inventory Mutation reports to track the flow of goods and stock adjustments
- Generated Aging Inventory reports to identify slow-moving stock and optimize warehouse efficiency
- Performed monthly reconciliation between Sales and COGS (Cost of Goods Sold) to ensure gross profit accuracy
Junior Auditor at Kantor Akuntan Publik Purwantono, Sarwoko & Sandja (2010-01 – 2021-12)
External/Internal Auditing, Audit Working Papers, Audit Reporting, and Financial Verification
- Conducted comprehensive audits of clients' financial statements to ensure compliance with accounting standards and regulatory requirements
- Developed and maintained detailed Audit Working Papers (AWP) to document testing procedures, evidence gathered, and findings
- Prepared formal Audit Reports and Management Letters communicating audit results, internal control weaknesses, and strategic recommendations to clients
- Performed substantive testing and analytical procedures to verify the accuracy of balance sheet accounts and income statements
