Edwin Gunawan Email & Phone Number

Jakarta, Indonesia

Jakarta, Indonesia

- Managing Backend and Frontend Engineers to deliver blockchain financial security technology- Spearheaded research initiatives to develop innovative approaches for ensuring blockchain security, enhancing detection capabilities for illicit funds.- Defined product features, including robust API functionalities, and crafted intuitive dashboards tailored to user needs and industry standards, elevating user experience.- Providing detailed progress reports to the founder on a weekly… Show more - Managing Backend and Frontend Engineers to deliver blockchain financial security technology- Spearheaded research initiatives to develop innovative approaches for ensuring blockchain security, enhancing detection capabilities for illicit funds.- Defined product features, including robust API functionalities, and crafted intuitive dashboards tailored to user needs and industry standards, elevating user experience.- Providing detailed progress reports to the founder on a weekly basis, facilitating informed decision-making and strategic planning. Show less

Jakarta, Indonesia

Managing Data team on TokenomyETL Process Management:Manage & develop the ETL process, ensuring efficient data extraction, transformation, and loading into our Data Warehouse. Key highlights include:- Extracting data from internal organizations ERP data source from mysql and postgres- Populating fact and dimension table using incremental and snapshot methods.- Analyzing and optimizing Data Warehouse performance.- Managing ad hoc data integration for team business… Show more Managing Data team on TokenomyETL Process Management:Manage & develop the ETL process, ensuring efficient data extraction, transformation, and loading into our Data Warehouse. Key highlights include:- Extracting data from internal organizations ERP data source from mysql and postgres- Populating fact and dimension table using incremental and snapshot methods.- Analyzing and optimizing Data Warehouse performance.- Managing ad hoc data integration for team business enhanced analytical capabilities.API Data Pull Integration, Monitoring, and Scheduling:built a parameterized data API integration system(using Python and Postgresql) from scratch that efficiently extracts data from partner API(Indodax, Whalefin, Fireblock, Matrixport) and Mailgun.- Extracting data from partner organizations API endpoints using incremental and snapshot methods, powered by Python and PostgreSQL.- Creating a robust landing data structure integrating data from partners.- Enhancing email tracking and analytics.-Automating updates distribution and optimizing data retrieval processes through monitoring and scheduling.AS Data Analyst Lead- Manage data analyst periodical and required reports in timely manners- Nurture data analyst capabilities to create a robust fact modeling- Weekly communicate and give brief explanation on updates and end results of given task Show less

Jakarta, Indonesia

Jakarta, Indonesia

Managing 3 Data team on Tanihub:1. Data Analyst- Manage DA team deliverables (accommodate meeting, finding solution, backup team)- Support day to day business needs on reporting- Lead Data team on accommodating report due to ERP migration- Provide insight on what need to do for next step, selection on tools to help increase productivity & performance- Trace root cause on slow performance and apply fix2. Data Scientist - Manage the DS team on Forecasting, and… Show more Managing 3 Data team on Tanihub:1. Data Analyst- Manage DA team deliverables (accommodate meeting, finding solution, backup team)- Support day to day business needs on reporting- Lead Data team on accommodating report due to ERP migration- Provide insight on what need to do for next step, selection on tools to help increase productivity & performance- Trace root cause on slow performance and apply fix2. Data Scientist - Manage the DS team on Forecasting, and already go live and currently is used by Procurement team .(Forecasting model help team TP to make decision on stocks flow)- Accommodate team DS on meeting, model review, testing model with Procurement team 3. Data Engineer- Mentoring on creating Datawarehouse from scratch- Arrange meeting with vendors and suggesting tools demo for management- Independently suggesting POC test scenario for vendors- Successfully create and manage communication regarding creation of DB dev snapshot data, NDA with legal, as well as connection credentials with vendors - Able to deliver POC demand within tight schedule without any delay Show less

Jakarta, Indonesia

Indonesia

o Create and design ETL and DWH for multi company under AXA Indonesia (AMFS, AFI, ALI)o Mainly responsible for develop and maintain Finance stream & OPS stream o Successfully create and implement NRT (Near Real Time) dashboard report that would automatically send email every 2 hours to finance business user that consist of their APE (Annual Premium Equivalent) achievement in amount and percentage, also consist of comparison to their budget and previous year achievemento SSIS SSAS… Show more o Create and design ETL and DWH for multi company under AXA Indonesia (AMFS, AFI, ALI)o Mainly responsible for develop and maintain Finance stream & OPS stream o Successfully create and implement NRT (Near Real Time) dashboard report that would automatically send email every 2 hours to finance business user that consist of their APE (Annual Premium Equivalent) achievement in amount and percentage, also consist of comparison to their budget and previous year achievemento SSIS SSAS and SSRS developer Show less

Greater Jakarta Area, Indonesia

Business Intelligence Project at PT Sinarmas Agribusiness and food (under Deloitte Singapore)o Successfully learn and get 3 BI DOMO Certification by DOMO + Deloitte less than one week (Domo Accreditation, Professional Service Certification, Technical Certification)o Create Dataset using BI DOMO (Magic ETL and DOMO dashboard) for Down Stream Indonesia (Branded Sprint and Refinery Sprint) it is a finance P&L related report card consist of GS, COGS, COGM, OI ,OPEX and ACAo Create… Show more Business Intelligence Project at PT Sinarmas Agribusiness and food (under Deloitte Singapore)o Successfully learn and get 3 BI DOMO Certification by DOMO + Deloitte less than one week (Domo Accreditation, Professional Service Certification, Technical Certification)o Create Dataset using BI DOMO (Magic ETL and DOMO dashboard) for Down Stream Indonesia (Branded Sprint and Refinery Sprint) it is a finance P&L related report card consist of GS, COGS, COGM, OI ,OPEX and ACAo Create DomoStas Datasets and DataFlow(BU) for monitoring Data health (data that need attention), Data Availability(How to ensure data is ready for consumption), Data Ownership and Expertise (Who Owns data across Organization)o Join and helping user training for Transport Dashboard HO Launch and Aerial Manuring Launch Show less

Greater Jakarta Area, Indonesia

o Prepare and analyze reporting required by management accurately and within deadlines (Daily Huddle Report, Underwriting report, Weekly & Monthly Sales reporting, Ad-hoc request by management)o Develop and maintain current jobs to migrate or transform data from source systems (Oracle DB & Tableau)o Evaluate current ERP system and collaborate with vendor to do Change Request include (SIT,UAT and documentation)o Research and evaluate software, system upgrades and enhancements and… Show more o Prepare and analyze reporting required by management accurately and within deadlines (Daily Huddle Report, Underwriting report, Weekly & Monthly Sales reporting, Ad-hoc request by management)o Develop and maintain current jobs to migrate or transform data from source systems (Oracle DB & Tableau)o Evaluate current ERP system and collaborate with vendor to do Change Request include (SIT,UAT and documentation)o Research and evaluate software, system upgrades and enhancements and provide technical recommendationo Provide analysis and giving advice to management for any reporting submitted Show less

Greater Jakarta Area, Indonesia

MIS Team for Cube and Reportingo Conduct effective communication with OTO team during UAT activities to have better relationship and clear understanding of user perspectiveo Understanding Report deliverables in order to understand better each report requiremento Create and Modify FS base on CR user requiremento Successfully Improve BI design and structure resulting better performance and reduce processing timeo Creating QC Script for CRo Manage GDC team (Global… Show more MIS Team for Cube and Reportingo Conduct effective communication with OTO team during UAT activities to have better relationship and clear understanding of user perspectiveo Understanding Report deliverables in order to understand better each report requiremento Create and Modify FS base on CR user requiremento Successfully Improve BI design and structure resulting better performance and reduce processing timeo Creating QC Script for CRo Manage GDC team (Global Development Centre) to deliver CR base on FS, also checking UT result. Show less

Greater Jakarta Area, Indonesia

My Responsibilities as BI consultant:- Gather User Requirements, Design & implementing Business Intelligence- Data modelling, Analyzing source system data, Data Mining and architecture design - Designing and creating the data warehouse and all related extraction (multi-source)- Developing the data warehouse and all related ETL (data quality,data integration, data conversion)

Greater Jakarta Area, Indonesia

Developer, QA,Trainer, server Administrator, support for Business Intelligence