Jeddika Ciangga

Experience

• 

  PT. Quadraluminari

  Nov 2017 - May 2019

  Technical Specialist
• 

  Carote

  Oct 2020 - Jan 2022

  Data Analyst

  - Data extraction from 3-5 different e-commerce platforms and generalize into 1 general template using Microsoft Excel- Fixing code flaws and other issues, as well as removing corrupted data using Microsoft Excel - Creating and managing databases and data systems using Microsoft Excel and SQL, the result can reduce the error from 2% to below 1%- Analyzing data to determine its quality and meaning using Microsoft Excel and Tableau - To improve the conversion growth by 30%. - Giving critical business functions a numerical value so that business performance may be measured and compared across time.- Successfully make Indonesian market become #1 in SEA market by analyzing local, national, and worldwide trends that have an impact on the company and its industry- Preparing management reports using Tableau that include trends, patterns, and predictions based on important data and the sales growth increased by 30-50% Show less

• 

  MyEduSolve

  Aug 2021 - Dec 2021

  Microsoft Office Master Instructor

  - Delivering knowledge about Microsoft Office (Microsoft Word, Microsoft Excel, and Microsoft Powerpoint)- Helping students to solve study cases regarding the Microsoft Office program- Brainstorming with students, to create a good portfolio for their career

• 

  MyEduSolve

  Feb 2022 - Jul 2022

  Data Science Track Instructor
• 

  Ula

  Mar 2022 - May 2023

  Tech Business Intelligence Analyst

  - Received, cleaned, and prepped data from different departments using SQL and Google Sheets to help other teams easily monitor their performance- Creation of a centralized Product and Tech dashboard using Domo and provide analysis to support decision-making and drive better results- Socialize the centralized dashboards and collect feedback from Product Managers (PMs) to optimize a set of metrics in the dashboard- Create weekly report summarizing the performance of product and tech metrics - Ensure PMs utilize the central dashboard and achieve 100% adoption- Collaborate with PM to analyze the Order Density and Share of Wallet of the customer to create visibility about the performance- Collaborate with the Data team and PMs to reduce manual tracking of Product key metrics by 50%- Collaborate with the Finance and Data team to create a single point of truth for datamart finance related and achieve 100% of data validity in different departments- Identify the misleading information related to the customer phone numbers to save costs by around 15% - 20% - Create automation for Engineering and Finance to have visibility of Whatsapp and SMS performance.- Create an automation analysis for HR, Ops team, and Commercial team to reduce the manual effort by around 75% Show less

• 

  Kuncie

  May 2022 - Apr 2023

  Microsoft Office Principal Mentor
• 

  MyEduSolve

  Sept 2022 - Dec 2022

  Data Analyst Track Instructor

  - Led a mentoring Data Analyst class for more than 50 students. Teaching Syllabus: Microsoft Excel (Associate and Expert), Database, Introduction to Python, Introduction to Data Analytics + Power BI- Support Students in completing a real-case project with the collaborated company- Help students that will lead to an increase in the probability of being accepted by several large companies in Indonesia