Rogers M.

My goal is to partner with clients to deliver both immediate and lasting value through reporting and workflow automation — helping teams reclaim 80%+ of their weekly manual work time and focus on high-impact, critical thinking tasks. 📊 Reporting Expertise – Looker Studio + More: I specialize in building real-time dashboards and business reports using Looker Studio, powered by seamless integrations with: - Data Sources: Google Sheets, Google Analytics 4 - Cloud Platforms: AWS, GCP - Databases: BigQuery, PostgreSQL, MySQL, Google Cloud SQL - ETL Pipelines & Integrations: GA4 → Google Sheets, BigQuery → Looker Studio - Streaming: AWS (PostgreSQL) → GCP (BigQuery) 🔄 Workflow Automations I Build: I streamline operations with custom automations across Google Workspace: - Web app to Google Sheets pipelines - Google Forms → Sheets, Calendar, Gmail - Metabase → Google Sheets → BigQuery - Auto-generate bulk Google Docs from data - Mail merges from Google Sheets to Gmail - Custom Gmail responders powered by ChatGPT + Google Apps Script - Connect all apps to/fro Google Sheets using Zapier 🏆 Top Rated (Top 10% on Upwork) With over 14 years of experience in reporting and automation, I've delivered results for clients across industries including: Health, Marketing, Hospitality, E-commerce, Training Data, Education, and Fintech. 🛠️ Recent Projects: ✅ Built a 3-statement financial report in Looker Studio, connected to Google Sheets, and embedded on a Google Site — enabling the client to access real-time, consolidated financial insights easily and securely in one place. ✅ Developed a career recommendation web app powered by a data dictionary in Sheets — helping users get personalized career guidance quickly based on their skills and preferences, improving decision-making. ✅ Created a Slack bot that sends private birthday messages via Gmail and notifies teams in Slack — boosting team morale and engagement by automating timely, personalized birthday greetings without manual effort. ✅ Connected GA4 to Google Sheets and integrated sales data to calculate ROAS, visualized in Looker Studio — giving the client clear, actionable marketing performance insights to optimize ad spend and maximize ROI. ✅ Built a Gmail drafting tool using Google Apps Script + ChatGPT via the OpenAI API — enabling the client to generate smart, context-aware email responses faster, saving time and improving communication quality. ✅ Streamed data from AWS (PostgreSQL) to GCP (BigQuery), wrote custom SQL, and visualized payment card data in Looker Studio — empowering the fintech client with seamless data integration and detailed analytics for better payment behavior understanding. Your project could be my next success story 🚀. Message me 📩 and let’s explore how we can make it happen! 💪 Keywords: Looker Studio, Google Sheets, SQL, Google Apps Script, Data Automation, Reporting Automation, Dashboard Development, Sales Reporting, Sales Analytics, Financial Dashboards, Forecasting, Data Visualization, BigQuery, PostgreSQL, Google Analytics 4, Inventory Dashboards, HR Dashboards, Performance Dashboards, Web App Integrations, ETL, Data Pipelines, Google Workspace Automation, Gmail Automation, Slack Bot Automation, Inventory Management Template, Planners, Trackers, Google Form, Form Ranger, Google Calendar, Leave Tracker