Business Systems Architect | Roadmap & GSheets & Automation
5.0
Rating
4
Followers
Business Systems Architect | Roadmap & GSheets & Automation
Profit and loss tracker for daily financial indicators +KPI dashboards.
I developed a spreadsheet with an advanced system for tracking daily P&L metrics.
The sheet allows analysis across different time frames (week, month, 6 months, year) and includes dynamic projections based on the last 3, 5, or 7 days of performance.
It features:
– Automatically calculates planned targets and actual results using built-in formulas.
– Assigns responsible owners and priorities to each metric.
– Manager evaluation system that links daily performance ratings to employee compensation.
– KPI dashboards for clear visualization.
1
66
Apps Script to create Google events and tasks when a cell is updated.
The requirement was to automatically create Google Tasks and Calendar events when a task is entered in Google Sheets.
• Implemented automatic updates to Google Tasks when the task name, status, or date is modified in the sheet.
• When a task is completed in Google Tasks, its status updates automatically in the spreadsheet for all assigned users.
• Meetings are scheduled via the sheet, generating Google Calendar events for all Gmail participants listed in the cell.
• Added automatic updates to calendar events when changes are made in the sheet.
• Entire solution built using Google Apps Script.
1
65
The client’s goal was to enter a new international market with a defined value proposition — but lacked clarity on the required steps.
I conducted a focused strategy session with the business owner, structured the full market entry strategy into clear blocks, and mapped every step into my proprietary task management system. I defined timelines, estimated budgets, assigned responsibilities, and outlined the necessary org structure to execute the plan.
The client received a complete roadmap, including a mind map in xmind and pdf formats, along with a fully structured Google Sheets action plan.
1
61
My proprietary system for managing and achieving any goal you set
Ranking Platform for padel players 🔥, they can register their matches, and be ranked with an ELO ranking system. It is a secondary product from SportChain
0
59
This is a Business Simulator platform in Finances , that allows students from universities and profesionals to learn and test their knowledge in finances using real cases scenarios, and getting feedback in all the journey.
0
64
Sportchain is a StartUp, a Web3 platform that allows people to invest and co-own sports facilities. This project has won 1st place in a hackathon and received mentorships from FounderSchool and Lisk.
0
74
Personal Website, for a Director and Producer, video potfolio, films, awards using NEXT JS, Vercel