Hi, I'm Dwi Budi Setyonugroho. My journey began with an Engineering degree, where my thesis on risk assessment taught me early on how to approach data analysis. As my interest in the data science field grew, I pursued the IBM Data Analyst Professional Certificate to master the fundamentals of analytics, followed by the Microsoft Power BI Data Analyst Professional Certificate to deepen my expertise in data visualization. Finally, I completed the Google Advanced Data Analytics Professional Certificate, where I dove deeper into statistics and machine learning to build predictive models.
Subsequently, I joined virtual internships with three companies, applying those skills to solve complex challenges in credit risk modeling and revenue optimization. Currently, I work as a private driver, which has further honed my communication, crisis management, time management, and adaptability soft skills. I would be honored to bring my blend of knowledge to your team.

Validated proficiency in essential SQL skills for data analysis, including data manipulation, joining tables, and summarizing datasets. This certification involves a rigorous timed exam and practical application of SQL queries to real-world business scenarios.

In this learning journey, I explored intermediate and advanced SQL concepts, primarily using PostgreSQL. I learned how to logically design databases using normalization and dimensional modeling. I mastered complex querying techniques, including advanced joins, set operations, and various subqueries like CTEs. I also gained skills in data manipulation using CASE statements, date/string functions, and arrays. Finally, I learned to write powerful window functions for analytics and manage database views and roles.

This program included over 200 hours of instruction and hundreds of practice-based assessments, which helped me simulate real-world advanced data analytics scenarios that are critical for success in the workplace. The content was highly interactive and exclusively developed by Google employees with decades of experience in advanced data analytics and data science. Through a mix of videos, assessments, and hands-on labs, I was introduced to advanced data analytics tools and platforms and key technical skills required for an advanced role.

This program was uniquely mapped to key job skills required in a Power BI data analyst role. In each course, I consolidated what I learned by completing a project that simulated a real-world data analysis scenario using Power BI. I also completed a final capstone project where I showcased all my new Power BI data analytical skills by connecting to data sources to transform data into an optimized data model and demonstrating data storytelling through dashboards, reports and charts to solve business challenges and identify new opportunities.

I gained hands-on expertise in the full data analysis lifecycle, from wrangling datasets with SQL and Python to visualizing insights in Excel and Cognos. My projects included analyzing vehicle inventory with pivot tables, creating interactive KPI dashboards, and extracting financial data with Pandas. I also built regression models to predict housing prices and developed a dynamic Python dashboard for flight reliability, effectively bridging technical rigor with data storytelling.

Completed a Full Learning Path with Professional Skill during 59 hours in Microsoft Excel. This comprehensive program covers Excel from basic to advanced levels, including data manipulation, forecasting, regression, and statistical analysis. Gained hands-on experience with data cleansing, visualization, pivot tables, Power Pivot, VBA macros, and advanced analytical techniques.
GPA: 3.34 / 4.00
My engineering training provided a rigorous quantitative foundation, emphasizing spatial logic, complex system modeling, and statistical risk assessment. This background honed my ability to decompose ambiguous real-world problems into structured data models, directly translating geological field methodologies into modern data-driven decision-making frameworks.
Organizational Leadership
Human Resource Development Dept: Designed seminar, workshop, and research to develop soft skills and hard skills for the members.
Media & Publication Dept: Managed and created graphic design and visual communication strategies for organizational social media.

Addressing a critical class imbalance in a 466k-row lending dataset, I engineered a leakage-free pipeline and deployed a Balanced Logistic Regression model to proactively identify high-risk borrowers. This end-to-end solution transformed raw data into actionable business intelligence, directly enabling stakeholders to mitigate potential financial losses through data-driven approval strategies.
Risk Detection: Increased Recall from 8% to 66%, successfully catching 2 out of 3 potential defaults that baseline models missed.
Model Performance: Achieved a 220% improvement in F1-Score (0.14 → 0.45) by optimizing for the minority class rather than overall accuracy.
Data Integrity: Reduced the dataset from 466k to 239k high-confidence records by rigorously removing data leakage and ambiguous "Current" loan statuses.

Acting as a BI Analyst for PT Sejahtera Bersama, I engineered an end-to-end data pipeline in Google BigQuery to resolve fragmented sales data, enabling the identification of a critical "Volume vs. Value" paradox between high-frequency eBooks and high-revenue Robots. By visualizing these insights in Looker Studio, I formulated three strategic initiatives—including product bundling and regional replication—projected to unlock over IDR 175M in optimized revenue.
Revenue Visibility: Uncovered IDR 175,475,057 in total sales and 11,654 units across 7 categories, revealing that Robots drive 44.3% of revenue while eBooks drive 32.7% of volume.
Strategic Opportunity: Identified a specific cross-sell gap leading to a proposed "Robot Starter Kit" bundle designed to convert high-volume entry customers into high-value hardware buyers.
Regional Optimization: Pinpointed Washington DC as a top performer (IDR 5.5M), providing a data-backed blueprint for replicating success in underperforming markets like Houston and Sacramento.
Architected an end-to-end analytics solution for Indonesia's largest pharmaceutical retailer by engineering a BigQuery ELT pipeline to unify 672K+ transactions and implementing complex tiered margin logic to resolve data silos. This initiative enabled real-time performance monitoring that identified a critical 30% geographic revenue dependency and pinpointed specific operational bottlenecks causing a 0.4-point customer satisfaction gap in key branches.
Uncovered Geographic Risk: Identified that Jawa Barat drives 29.5% of total revenue (102B IDR), highlighting a massive concentration risk versus emerging markets.
Diagnosed Operational Gaps: Detected branches like Tarakan and Bekasi where high facility ratings (>4.4) masked poor transaction experiences (<3.99), enabling targeted audits.
Quantified Profitability: Calculated 98.54B IDR in Nett Profit across 31 provinces using dynamic pricing tiers, revealing a 0.7% revenue stagnation trend in 2023.

This project-based internship focuses on the core concept of the end-to-end data science lifecycle, ranging from initial business understanding and data collection to automated model deployment. Participants leverage a technology stack including Python, R, and SQL to master specific skills in exploratory data analysis, feature engineering, machine learning modeling, and version control with Git.

This project-based internship provides Business Intelligence training focusing on technology stacks like SQL (PostgreSQL and BigQuery), Microsoft Excel, and Looker Studio. It cultivates specific skills in database management, advanced data manipulation (such as CTEs and joins), and data storytelling through interactive dashboards for banking portfolio analysis.
This project-based internship provides hands-on experience in SQL querying, Google BigQuery data warehousing, and Looker Studio visualization to support analytical business needs. Participants acquire specific skills in ETL pipeline design, exploratory statistical analysis, and data storytelling to transform complex big data into actionable insights.
Managed end-to-end operational logistics for private clients, ensuring seamless execution of daily schedules across diverse geographic regions. Operated as the primary point of contact for time-sensitive travel requirements, leveraging real-time data analysis to optimize routes and mitigate delays.
Key Achievements & Responsibilities
Operational Efficiency: Designed and executed dynamic route optimization strategies using real-time traffic data and predictive scheduling, ensuring 100% punctuality for critical business appointments.
Crisis Management & Adaptability: Successfully navigated complex logistical challenges (e.g., vehicle maintenance emergencies, sudden schedule pivots, and adverse weather conditions), maintaining operational continuity without disrupting client workflows.
Asset Management: Maintained strict adherence to safety protocols and vehicle performance metrics, conducting proactive preventative maintenance to ensure zero downtime and optimal vehicle reliability.
setyonugrohodwibudi@gmail.com
Dwi Budi Setyonugroho
dwibudisetyonugroho
+62 851 8611 1556
Chat with me