Galih Rakasiwi

Projects :

1. BNPL new business reporting

2. OJK reporting

3. Akulaku RBT Dashboard (C level consumption)

4. IFRS9 / PSAK71 ECL modeling

Key Responsibilities :

- Data exploration

- Build and maintain local internal datamart (unix, SQL server, postgres)

- Build reporting pipeline

- Data to OJK rules and system compliance

- ECL modeling (SAS software)

- Internal reporting

- External reporting

- Dashboard creation (google data studio and pentaho report designer)

Projects :

1. Sales reporting website (Agent to country level Singapore, Brunei, Malaysia)

2. New general insurance product dashboard

3. AIA Vitality dashboard

Key Responsibilities :

- Daily data staging (prod to data warehouse)

- Data exploration

- ETL automation development - Informatica tools

- Datamart DBA (SQL server, Postgres, Unix server)

- Maintain agency sales website (ASP .net)

- Dashboard creation (Tableau)

Projects :

1. Retail Banking bank wide dashboard

2. Branchless Banking bank wide dashboard

3. Regular reporting (Daily, Weekly, Monthly, Annual)

Key Responsibilities :

- Data exploration

- Datamart and table creation (SQL Server, Oracle DB, Hadoop)

- Data testing and validation

- ETL automation development and monitoring (Talend ETL)

- Report template creation (VBA)

- Report distribution to all region and users (FTP server)

- Dashboard creation (Tableau)