Riah Qomariah

Experience

• 

  IDS Medical Systems (idsMED)

  Jan 2022 - Jan 2023

  Data Analyst Intern

  ● Analyzed and collect required data in database using SQL● Built and design tables in database● Integrated and combined data sources from tabular data and data from other servers into one storage with the ETL process.● Developed report dashboards with business intelligence processes for the finance department, inventory management, sales and improvement KPI e-ticket country (Indonesia) dashboards.● Created technical specification/Business requirements document before built a dashboard● Tools : SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), Power BI Exibir menos

• 

  IYKRA

  Jan 2023 - Jan 2023

  Data Engineer - Data Fellowship Program

  ● Receive tech skills to be a professional data engineer such as apache airflow, apache spark, apache kafka, etc.● Load data from data lake in google cloud storage to google BigQuery using dataflow ● Ingest data to google cloud storage as a data lake using apache airflow with docker● Transform data to google BigQuery as a data warehouse with dbt transformation● Analyze public dataset using Pyspark.● Ingest data to data lake in a streaming way and created producer and consumer using apache kafka with python script● Create avro producer and consumer, and load the data to bigquery● Create report dashboard from public dataset using Looker studio, Power BI, and Tableau Exibir menos

• 

  PT Bank Rakyat Indonesia (Persero) Tbk

  Jun 2023 - now

  Data Analyst
• 

  IYKRA

  Jun 2023 - now

  Data Analyst

  Placement at PT Bank Rakyat Indonesia (Persero) Tbk● Create queries to access, modify and retrieve data from the database.● Build ETL processes to extract data from various sources, transform and load it into a data mart using SQL andPySpark.● Create AtScale cubes to receive data from various sources and map the data used on the dashboard.● Responsible for developing interactive dashboards to visualize data analysis outcomes using Tableau and facilitatestrategic decision-making● Conducted unit testing to validate the data visualized on the dashboard and ensure its accuracy and consistency● Documented the development process, including project design, unit testing results, deployment SOP (StandardOperating Procedure), and monitoring SOP (Standard Operating Procedure), to facilitate team collaboration● Collaborated with the quality control team to ensure that data and features on the dashboard function properly, andalign with expectations Exibir menos