Sukamto - Email and Phone Number

Project :1. Develop and maintain end-to-end ETL process from various sources to DWH or Data Mart destination 2. Develop and maintain end-to-end ETL process from Data Mart to Regulatory Reporting (Antasena, Obox, Siskehat, Dashboard and LPS SCV)3. Generate technical ETL documentation 4. Perform any change request (CR) due to change in business process or other technical related matter

Project :1. Develop and maintain end-to-end ETL process from various sources to DWH or Data Mart destination 2. Develop and maintain end-to-end ETL process from Data Mart to Regulatory Reporting (Antasena, Obox, Siskehat, Dashboard and LPS SCV)3. Generate technical ETL documentation 4. Perform any change request (CR) due to change in business process or other technical related matter

Maintain end-to-end ETL process from various sources to DWH or Data Mart destination included but not limited to:• GL Reporting• GL Outbound• Forex calculations• Impairment • Nominative filesMonitor end of day and end of month process and resolve issues (if any)Generate maintenance scriptPerform system integration testing and other testing procedure.Carry out User Acceptance Test (UAT).Support all stakeholders (IT, Risk, Accounting Team) to fulfill their needs in IFRS. Client issue checking and problem solving.Do the PSAK 50/55 Maintenance or Database Health Check.Analyze bug and communicate with system developers.

Maintain end-to-end ETL process from various sources to DWH or Data Mart destination included but not limited to:• GL Reporting• GL Outbound• Forex calculations• Impairment • Nominative filesMonitor end of day and end of month process and resolve issues (if any)Generate maintenance scriptPerform system integration testing and other testing procedure.Carry out User Acceptance Test (UAT).Support all stakeholders (IT, Risk, Accounting Team) to fulfill their needs in IFRS. Client issue checking and problem solving.Do the PSAK 50/55 Maintenance or Database Health Check.Analyze bug and communicate with system developers.Client : PT. Bank Resona PerdaniaProject : PSAK 50/55Tools : SSIS (ETL Tools), SQL Server (Engine/ App Database) Period : Oktober 2018 – NowClient : PT. Sarana Multi InfrastrukturProject : PSAK 50/55Tools : SSIS (ETL Tools), SQL Server (Engine/ App Database) Period : Oktober 2018 – NowClient : PT. Bank Muamalat IndonesiaProject : PSAK 50/55Tools : Pentaho (ETL Tools), Oracle (Engine/ App Database) Period : Oktober 2018 – Now

1. Support ERP Oracle as 1st Layer (Point of Sales, Supply Chain Management, Finance & Accounting)for Head Office, Warehouse Erajaya Group Distribution : TAM, NGA, SES, ERAFONE, DCM.2. Support project with IT Business Analyst3. Monthly reconciliation for inventory accounts.4. Coordination with 5 person the application support retail staff.5. Daily monitoring of ticketing system6. Create monthly ticketing reports for KPI application support staff.

1. Support ERP Oracle as 1st Layer (Point of Sales, Supply Chain Management, Finance & Accounting) for Head Office, Warehouse Erajaya Group (TAM, ERA, NGA, SES, ERAFONE, DCM)2. Support .NET Application as 1st Layer (AMS, Finance & Accounting)for Head Office, Warehouse & more than 40 Outlet's TAM Service3. Training to end user