Data Analytics Portfolio

About

Hello! I’m Cyrus Baruc, a continuous learner with over a decade of experience in technology with proven track record of providing high-quality solutions to business problems. Strong communication, problem-solving, and passionate to working with complex systems.

Education

Bachelor of Science in Industrial Technology major in Electronics at Cebu Technological University-Main Campus

Relevant Certifications

Microsoft Certified Professional: PL300 Power BI Data Analyst Associate
Data Science Certification Program at UP Cebu (discontinued due to financial constraints)
Power BI Data Analyst @ Microsoft on Coursera
Business Intelligence Certificate @ Google on Coursera
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 and Accounting
Construction
Personal Finance
Investment/Stocks
Digital Marketing (Meta Ads)
Manufacturing (OEE)
Managed Service Provider (MSP)

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.
Python Applications: Developing robust applications for data visualization and analysis.
Power BI Dashboards: Designing comprehensive dashboards, such as the highly praised Revenue Analytics dashboard.
Paginated Reports: Creating print-ready, detail-rich reports to support operational and regulatory needs
Process Automation: Utilizing Power Apps and Power Automate to streamline workflows and enhance efficiency.

Tech Stack

Programming Languages: Python, SQL, Power Query M Language, DAX, R, VBA
Cloud and Data Platform: 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: DAX Studio, Bravo, Performance Analyzer, Tabular Editor
Process Automation: Power Automate, Power Apps (Canvas and Model-Driven), Python, Office Scripts, Excel VBA
Other Platform: Microsoft 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: I engage with stakeholders to understand their objectives, pain points, and desired outcomes. This includes translating business needs into clear, actionable data requirements.
Development: Leveraging tools like Power BI, Excel, and Python, I design and build scalable solutions—focusing on clarity, performance, and user engagement.
User Training: I conduct hands-on training sessions and create user-friendly documentation to ensure seamless adoption and self-service analytics for end-users.
Deployment: I manage smooth rollout of solutions, integrating them into the business environment with minimal disruption.
Maintenance & Support: I provide ongoing support, performance tuning, and iterative improvements based on user feedback and evolving business needs.

Career Goals

I am committed to staying at the forefront of technology by continuously learning and expanding my skillset. My current focus is on mastering AI, Machine Learning, and Predictive Analytics to enhance my ability to provide cutting-edge solutions in the ever-evolving data landscape.

Key Projects

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

Python Knowledge Base

SQL Code Library

Thank you for visiting my portfolio. I look forward to connecting with you and exploring how we can leverage data to drive success.