safrizalrahman46/Data-Warehouse_Jobsheet_SIB_2G
Mar 2025 – Apr 2025
2 Months active
Languages Used
CSVSQLXML
Technical Skills
Data ProcessingData TransformationData WarehousingDatabase AnalysisETLSQL Querying
Rizxqi
PROFILE
Rizxqi
Rizqi Dewanto developed and delivered four core features for the safrizalrahman46/Data-Warehouse_Jobsheet_SIB_2G repository over two months, focusing on automated data processing and analytics workflows. He built ETL pipelines using Pentaho to transform and export car sales and population data from CSV sources, enabling analytics-ready outputs in both CSV and Excel formats. Leveraging SQL and database analysis, he implemented queries for sales KPIs, employee hierarchies, and branch dashboards, supporting business reporting needs. Rizqi also designed and documented an end-to-end data warehouse ETL pipeline, creating dimensional models to improve data availability, accuracy, and self-service reporting for stakeholders.
Overall Statistics
Feature vs Bugs
100%Features
Repository Contributions
4Total
Bugs
0
Commits
4
Features
4
Lines of code
14,014
Activity Months2
Your Network
10 peopleWork History
April 2025
2 Commits • 2 Features
Apr 1, 2025Month: 2025-04 — Delivered the foundational Data Warehouse ETL pipeline and supporting documentation, enabling analytics and reporting workflows for the Data-Warehouse_Jobsheet_SIB_2G project. Key outcomes include end-to-end ETL to populate the data warehouse with transformed data from OLTP sources, creation of dimensional tables (date, employee, courier, payment status, shipping status, region) and shipment facts to enable business reporting and insights, and documentation updates with two reference PDFs for reporting workflows and educational materials (LaporanJobshet3.pdf and LaporanKuis1.pdf). These efforts improve data availability, accuracy, and self-service reporting for business stakeholders.
2 Commits • 2 Features
Apr 1, 2025Month: 2025-04 — Delivered the foundational Data Warehouse ETL pipeline and supporting documentation, enabling analytics and reporting workflows for the Data-Warehouse_Jobsheet_SIB_2G project. Key outcomes include end-to-end ETL to populate the data warehouse with transformed data from OLTP sources, creation of dimensional tables (date, employee, courier, payment status, shipping status, region) and shipment facts to enable business reporting and insights, and documentation updates with two reference PDFs for reporting workflows and educational materials (LaporanJobshet3.pdf and LaporanKuis1.pdf). These efforts improve data availability, accuracy, and self-service reporting for business stakeholders.
April 2025
March 2025
2 Commits • 2 Features
Mar 1, 20252025-03 Monthly Summary for safrizalrahman46/Data-Warehouse_Jobsheet_SIB_2G. Key feature deliveries include two ETL pipelines and SQL analytics queries that enhance data preparation, analytics, and reporting capabilities. No major bugs fixed in this period. Impact: automated data preparation and exports enable analytics-ready data, improved visibility into sales performance and organizational structure, and scalable analytics across branches. Technologies/skills demonstrated: ETL transformations (KTR), SQL analytics, data export automation to CSV/Excel, and version-controlled data pipelines.
March 2025
2 Commits • 2 Features
Mar 1, 20252025-03 Monthly Summary for safrizalrahman46/Data-Warehouse_Jobsheet_SIB_2G. Key feature deliveries include two ETL pipelines and SQL analytics queries that enhance data preparation, analytics, and reporting capabilities. No major bugs fixed in this period. Impact: automated data preparation and exports enable analytics-ready data, improved visibility into sales performance and organizational structure, and scalable analytics across branches. Technologies/skills demonstrated: ETL transformations (KTR), SQL analytics, data export automation to CSV/Excel, and version-controlled data pipelines.
Activity
Loading activity data...
Quality Metrics
Correctness85.0%
Maintainability85.0%
Architecture85.0%
Performance85.0%
AI Usage20.0%
Skills & Technologies
Programming Languages
CSVSQLXML
Technical Skills
Data ProcessingData TransformationData WarehousingDatabase AnalysisETLPentahoSQLSQL Querying
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline