Support data & analysis for Corporate & Finance

1. Maintain ERP integration with several different apps2. Build auto-reconcile feature for finance ops3. Build ERP flow automation4. Maintain Data & Analytics, heavily from ERP5. Maintain ETL from various apps to data warehouse6. Maintain & build business dashboard & data viz

1. Build data integration over apps and build the integration schedule. Heavily utilized the APIs. The data was pushed to Zoho Platform and Company SQL Database. The integration was built in NodeJS and applied in VPS.2. Formulate business metrics in data visualization tools (Zoho Analytics, Google Data Studio).3. Build a dashboard and data visualization based on business needs in Zoho Analytics or Google Data Studio.4. Perform detailed analysis (by request and also initiatively give analysis when available), heavily use python pandas and sklearn.5. Automate the ETL process to perform recurring analysis. The data come from Company SQL Database and the Zoho platform. The task was performed using python, pandas, and sklearn which was triggered by the NodeJS schedule.6. Automate various clerical processes in another division.

1. Maintain accounting systems2. Build & maintain feature accounting automation3. Build & maintain ETL, data warehouse, and data viz4. As consultant to give perspective of business initiative in areas of tax, accounting, ops, technology

1. Design and implement database and logic related to accounting for Baitul Mal Wat Tamli (BMT). 20202. Build report automation for psychology assessment & support for statistical analysis of the results. 2020 - present3. Build simple apps to record sales & generate sales report using google sheet and google script in an online store. 20224. Design "mini" ERP to be followed by Fullstack Engineer for development in an online store. 2023

Review & Improve curriculum and materials for Data Analyst Bootcamp

Try to make a good Accounting & Finance operation

Create and reporting the financial position of company and related income statement, cash flow.Analyze financial condition from financial statements and financial transactions for management's decision.Analyze and design business flow and workflow to improve effectiveness and efficiency of information systems in finance & accounting areas