An Information System graduate from Universitas Komputer Indonesia (UNIKOM) with a structured track in Data Engineering, Business Intelligence, and Data Analytics across major enterprises. I specialize in breaking down data silos, transforming raw transactional data into clean relational structures, and architecting interactive dashboards that drive executive decision-making.
- 🎓 Education: Bachelor of Computer Science in Information Systems, UNIKOM (Cum Laude / Rector's Award for Academic Excellence).
- 🔄 Exchange Program: Fully funded alumnus of the National Student Exchange Program (PMM 2) in Computer Engineering at IIB Darmajaya.
- 💼 Core Expertise: Business Intelligence Architecture, End-to-End Data Pipelines (ETL), Star Schema Data Modeling, Database Normalization, and Process Mapping.
| Kategori | Teknologi & Metodologi |
|---|---|
| Business Intelligence | Power BI (Multi-page, DAX Optimization), Advanced Excel (Power Query, PivotTables, Macros), Data Visualization, Data Storytelling, Gestalt Principles, Design Thinking. |
| Data Engineering | SQL (Complex Joins, Subqueries, CTEs, Aggregations), MySQL, Python (Pandas), Pentaho, ETL Pipelines, Data Warehousing, Data Mart Design |
| Business Process & SCM | SAP ERP (Logistics/Procurement Tracking), Business Process Modeling Notation (BPMN), Order-to-Cash (O2C) Stream, Stakeholder Engagement, Requirements Gathering. |
- Description: Developed an 8-page executive dashboard in Power BI consolidating supply chain data from 3 operating subsidiaries. Built a VBA Excel Macro pipeline to automate the processing of 20 raw SAP files, replacing an entire weekly manual reporting cycle under strict SKK Migas regulations (PTK 007, A7001).
- Description: Architected a centralized Data Mart unifying data from 4 distinct operational departments. Built 4 interactive Power BI dashboards using Design Thinking and Gestalt Principles, reducing cross-departmental data inconsistencies by 90% and passing full User Acceptance Testing (UAT).
- Description: Built an ETL pipeline in Advanced Excel to transform 1,100+ raw retail transactions from 5 cities into a standardized, normalized dataset. Applied PivotTables and Data Table analysis to deliver dynamic dashboards tracking Total Sales, Cost, and Net Income. Scored 90/100 on the national BNSP Data Analyst Competency Assessment.
- Description: Engineered an ETL pipeline in Power Query to cleanse and structure 55,000+ CRM and sales quotation records. Deployed a 4-page Sales Dashboard that eliminated a 2-week monthly manual reporting lag and mapped the company's first formal 10-step, 16-actor BPMN diagram.
- Description: Developed a bull selection system in Python implementing Genetic Algorithms calibrated to SNI KPIs, improving fitness scores by 27.5% across 5 generations. Normalized a MySQL database to 3NF to eliminate redundancies, and deployed a Machine Learning model to automate feed ration formulas against Dry Matter (Bahan Kering) requirements.
- 💼 LinkedIn: linkedin.com/in/muhammadzidanesyifawijaya
- 📧 Email: zidanwijaya94@gmail.com
- 📱 Location: North Jakarta, Indonesia