Marcos Mota

Portfolio

Building Data-Driven Solutions

With over a decade of experience in business intelligence and software development, I’m dedicated to creating solutions that make data clear, accessible, and actionable. Every project in this portfolio reflects my commitment to helping organizations unlock insights, improve processes, and drive meaningful results through technology.

1
Successful Projects
1
Published Works
carlos-muza-hpjSkU2UYSU-unsplash

My Projects

Explore a selection of projects that reflect my passion for transforming data into actionable insights and creating custom software solutions. From dynamic BI dashboards to automation tools and applications, each project is designed to help teams make smarter decisions and focus on what matters most.

Revenue & ARPS Report

A complex Power BI report built for a finance department of a educational institution. It has many KPIs for current and historical intakes, providing also future predictions to allow the board of directors to take data-driven decisions. This award winning report was the most important piece of information for the entire organization at the time. Company information hidden for privacy reasons.

Visit

Warehouse Report

A report built for a warehouse department of a company. It provides information about the received, shipped and handled units, allowing managers to understand exactly how one of the most important departments is performing. Company information hidden for privacy reasons.

Visit

SGT (TMS, Total Management System)

A complete desktop application built in C#, WPF and MySQL that provides users the ability to create, edit, delete, send and manage sales proposals and service orders. It also has integration with emails and external applications, user management, encryption for passwords and many other solutions. The provided repository is a public version and doesn't reflect the current situation of the application as it's still being used by a company. A test version will be released soon. The tool is in Portuguese

Visit

Battery Report

A Power BI report to track how the batteries used in electrical equipments like forklifts are performing, mainly focused on autonomy. It makes the maintenance department able to see in detail which equipments and batteries require more focus. Company information hidden for privacy reasons.

Visit

Simon Says - Arduino Game

This is an Arduino project that features a Simons Says game in which the user needs to press the colored buttons in the correct order. The game features different difficult levels, different speed settings and an option to change the color pattern created focusing on accessibility.

Visit

8 Bit Bazaar

A simple website built for a group assignment to sell items from old times. This website works like a store for old games, in which the user can add items to the cart, purchase them and see the receipt.

Visit

Free Games Explorer

A website that enables users to explore many free games available in multiple platforms. The user has the option to see a list of games, filter with some criteria like category, platform or name, and see details and screenshots.

Visit

Forms Game

A simple website containing a game in which the user needs to select three cards that has the form amount, shape, color and fill equal or different. This was built for a assignment to show JavaScript skills.

Visit

Other Projects

Additional projects developed for internal use, showcasing solutions that improved business performance and data-driven decision-making.

  • Title: Forestry Operational Excellence
    Period: March 2022 - April 2023
    Description: Designed and developed a forestry data consolidation solution enabling real-time KPI tracking for enhanced decision-making. Orchestrated project scope, employing Scrum methodology, collaborated with stakeholders, and led daily development meetings to ensure optimal product delivery.
    Technologies Used: Scrum, Jira, MS Project, MS Excel, Power BI, DAX, HTML, CSS, JavaScript, SQL Server.
  • Title: Payroll Systems Migration 
    Period: December 2020 - July 2022 
    Description: Managed the ETL part of a migration process from ADP to SAP HCM; designed and developed Excel-based automation for ETL, ensured meeting deadlines in daily meetings, and replicated tool success in another branch, enhancing project outcomes. 
    Technologies Used: VBA, MS Excel, Power Query, Power Pivot, DAX, SQL Server, Talend Open Studio, C#.