📊 Data Analytics Portfolio

🧠 About

Hello! I’m Cyrus Baruc, a continuous learner with over a decade of experience in technology and a proven track record of delivering high-quality solutions to real-world business problems. I bring strong communication skills, sharp problem-solving abilities, and a deep passion for working with complex systems. Whether it’s data analytics, process automation, or system optimization, I thrive in turning challenges into impactful results.

🧘 Philosphy

“When nothing seems to help, I go and look at a stonecutter hammering away at his rock, perhaps a hundred times without as much as a crack showing in it. Yet at the hundred and first blow it will split in two, and I know it was not that blow that did it—but all that had gone before.” — Jacob Riis

🎓 Education

Bachelor of Science in Industrial Technology, Major in Electronics Cebu Technological University – Main Campus
📅 Graduated: [2012]

Developed a strong foundation in electronics, instrumentation, and technical systems, with emphasis on:

• 🔧 Troubleshooting and diagnostics of electronic circuits and control systems
• 🧠 Problem-solving using logical and analytical thinking in lab and field environments
• 💡 Practical knowledge of microcontrollers, sensors, and industrial automation
• 🛠️ Hands-on experience in PCB design, board repair, soldering, and equipment calibration
• 📐 Basic skills in CAD and electrical schematics interpretation

This background sharpened my attention to detail and ability to work with complex systems—skills I now bring into data analytics and business intelligence.

📜Relevant Certifications

• 🎯 PL300: Power BI Data Analyst Associate Issued by Microsoft - 2024
• 🎓 Data Science Certification Program University of the Philippines Cebu (Discontinued due to financial constraints)
• 📊 Power BI Data Analyst Microsoft on Coursera
• 📈 Google Business Intelligence Certificate Google on Coursera
• 📉 Google Data Analytics Certificate Google on Coursera-
• 🛡️ Data Governance Specialization Project SPARTA PH
• 💻 Computing Specialization Project SPARTA PH
• 📊 Data Visualization Specialization Project SPARTA PH
• 🧩 Data Associate Pathway Project SPARTA PH

🧠 Domain Knowledge

• 💰 Finance & Accounting – Familiar with financial reporting, revenue analysis, and budgeting workflows
• 🏗️ Construction – Experience with project tracking, cost management, and operational reporting
• 👛 Personal Finance – Budgeting, expense tracking, and financial planning dashboards
• 📈 Investment & Stocks – Knowledge in portfolio performance, equity tracking, and returns analysis
• 📣 Digital Marketing (Meta Ads) – Campaign performance, ad spend analysis, and audience insights
• 🏭 Manufacturing (OEE) – Deep understanding of Overall Equipment Effectiveness, downtime tracking, and performance KPIs
• 🖥️ Managed Service Provider (MSP) – Ticketing metrics, SLA monitoring, asset reporting, and support performance

🛠️ Key Skills & Expertise

After over a decade in the electronics industry, I successfully transitioned into the world of data—bringing with me a strong foundation in systems thinking and problem-solving. Since then, I’ve been driving meaningful impact through data analytics by delivering innovative, user-centric solutions. My journey has been defined by the development of dynamic and insightful projects, including:

• 📊 Excel Dashboards
  Crafting interactive and visually appealing dashboards to simplify complex data for decision-makers.
• 🐍 Python Applications
  Developing robust applications for data analysis, automation, and visualization.
• 📈 Power BI Dashboards
  Designing comprehensive, interactive dashboards—such as the highly praised Revenue Analytics Dashboard—to support business intelligence needs.
• 🧾 Paginated Reports (SSRS)
  Creating print-ready, detail-rich reports tailored for operational tracking and compliance requirements.
• 🔄 Process Automation
  Streamlining workflows using Power Apps and Power Automate, improving team efficiency and reducing manual tasks.

🧰 Tech Stack

• Programming Languages
  Python, SQL, Power Query M Language, DAX, R, VBA
• Cloud & Data Platforms
  Power Platform, Dataverse, Microsoft Fabric, Microsoft SQL Server, SAP, Microsoft Entra ID, Azure Blob Storage
• Data Engineering & ETL
  Data Modeling, Data Staging, Query Folding, Schema Implementation, Data Warehousing
• Data Analysis & Visualization
  Excel, Power BI, Tableau, Pandas, Seaborn, Plotly, SSRS, Power BI Report Builder
• Optimization & Performance Tools
  DAX Studio, Bravo for Power BI, Performance Analyzer, Tabular Editor
• Process Automation
  Power Automate, Power Apps (Canvas & Model-Driven), Python, Office Scripts, Excel VBA
• Other Platforms & Tools
  Microsoft 365 Suite, SharePoint, ServiceNow, Microsoft Planner, Visual Studio, VS Code, Jupyter Notebooks

🔄 Project Lifecycle & Delivery Approach

I follow a structured and collaborative approach to ensure successful project execution from start to finish:

• 🔍 Requirements Gathering
  Engage with stakeholders to understand objectives, pain points, and desired outcomes. Translate business needs into clear, actionable data requirements.
• 🛠️ Development
  Leverage tools like Power BI, Excel, and Python to design and build scalable, intuitive solutions—prioritizing clarity, performance, and user engagement.
• 👥 User Training
  Conduct hands-on training sessions and create user-friendly documentation to support seamless adoption and promote self-service analytics.
• 🚀 Deployment
  Manage smooth rollouts by integrating solutions into existing business environments with minimal disruption.
• 🔧 Maintenance & Support
  Provide ongoing support, performance optimization, and iterative improvements based on user feedback and evolving business requirements.

🎯 Career Goals

I am committed to staying at the forefront of technology by continuously learning and expanding my skillset. My current focus is on deepening my expertise in Artificial Intelligence, Machine Learning, and Predictive Analytics—with the goal of delivering more intelligent, forward-looking solutions that drive business value in an ever-evolving data landscape.

📌 Key Projects

While I have completed numerous projects, I selectively showcase only my best work.

🧩Power BI

📊Revenue Analytics

Project Overview:

Designed and developed a multi-layered Power BI dashboard to provide in-depth Revenue Analytics for business stakeholders. The solution offers both high-level and granular views of revenue performance, helping drive strategic decisions through clear, data-driven insights.

🔍Key Features:

Executive Summary

A top-level snapshot of total revenue, trends, KPIs, and performance versus targets.

Revenue Buckets Page

Categorized revenue insights by products, services, or business units for focused analysis.

Drilldown Sub-Page

• Revenue Actuals: Month-over-month actuals with variance indicators.
• Revenue Volume: Breakdown by quantity sold or delivered, correlated with revenue trends.
• Calculations: Transparent logic and formulae behind revenue components, ensuring clarity and trust.
• Analytics: Advanced visualizations highlighting growth patterns, seasonality, and anomalies.

🛠️Tools & Technologies:

• Power BI Desktop & Power BI Service
• Power Query for ETL
• DAX for custom measures and time intelligence
• SQL for data extraction and transformation
• SAP

📈Impact:

This dashboard enabled Finance and Sales teams to monitor revenue performance in real time, detect variances early, and improve forecasting accuracy. It became a key reporting asset used in monthly business reviews and revenue strategy sessions.

📸 Dashboard Screenshots:

📋 Summary Page

📂 Revenue Bucket Specific Pages

Sub-Pages: Revenue Actuals, Revenue Volume, Revenue Calculations, Analytics

🏭 Manufacturing Overall Equipment Effectiveness (OEE) Dashboard

📝 Project Overview

Developed a comprehensive Power BI dashboard to visualize and monitor Overall Equipment Effectiveness (OEE) for a manufacturing operation. This solution empowers production managers and engineers with actionable insights to optimize equipment performance, reduce downtime, and improve manufacturing efficiency.

---

🔍 Key Features

• OEE Breakdown
  Real-time visualization of OEE components – Availability, Performance, and Quality – with historical trend analysis.
• Shift & Line Analysis
  Filters for production lines, shifts, and date ranges to track performance across different operational segments.
• Downtime Analysis
  Interactive drill-down on downtime reasons categorized by type, frequency, and duration.
• Target vs. Actual
  Visual comparison of OEE KPIs against predefined benchmarks with conditional formatting.
• Interactive Controls
  Dynamic slicers, tooltips, and bookmarks for an intuitive and user-friendly experience.

---

📸 Dashboard Screenshot

🖥️ Managed Service Provider (MSP) – Users & Devices Cross Program Validation

📝 Project Overview

Built a data validation and monitoring dashboard for a Managed Service Provider (MSP) to ensure data integrity across multiple systems managing users and devices. This solution helps identify mismatches, improve asset tracking, and support proactive remediation.

---

🔍 Key Features

• Cross-Platform Data Matching
  Validates consistency of user and device records across systems (e.g., Active Directory, Intune, endpoint management).

• Anomaly Detection
  Highlights discrepancies in user/device status, assignment, and activity logs.

• License & Assignment Tracking
  Monitors usage and compliance of software licenses and device assignments.

• Audit-Ready Outputs
  Provides clean, exportable summaries to support IT audits and compliance checks.

---

📸 Dashboard Screenshots

⚙️ Power Apps

📄 Revenue Analytics – Driver Commentaries

Developed a Power Apps interface to allow business users to input commentary directly linked to revenue data points. These commentaries are then captured and reflected in Power BI reports, enriching insights with qualitative context.

Please click the link to see more details:
Revenue Analytics – Driver Commentaries

🔁 Power Automate

📊 RAR Data Validation Metrics

Designed and implemented a Power Automate workflow to support RAR (Revenue Accounting & Recognition) data validation metrics. The solution integrates key components of the Microsoft ecosystem and Power Platform to automate validation and delivery processes for the Revenue Accounting team.

Technologies Used:
SharePoint · Power Automate · Power BI · SAP

---

📸 Workflow Screenshot

🐍 Python Knowledge Base

• 📄 Programs
• 🔢 Sequences
• 🔁 Loops
• 🧮 Functions
• 🏗️ Object-Oriented Programming
• 📊 Exploratory Data Analysis

---

🧠 SQL Code Library

• 📈 Aggregation Functions
• 🧩 Nested Queries