Experience

• XLOOKUPS, VLOOKUPS, HLOOKUPS

• REGXMATCH, REGXEXTRACT, REGEXREPLACE

• ARRAYFORMULA

• IMPORTRANGE, IMPORTXML

• FILTER, UNIQUE

• LAMBDA, LET

• COUNTIFS, SUMIFS, MAXIFS, MINIFS

• SEARCH, FIND, LEFT, MID, RIGHT

• GOOGLEFINANCE (Currencies & Stock Exchanges)

• Pivot Tables

• Many nested IF statements

• Custom formulas generated in Google App Script

• 1 Click Month-End Reports

• Mail Merge

• Google Sheet Information to Google Forms

• Custom Sorting and Formatting

• Data Pipelines

• Mailbox Management 

• API Management & Webhooks

• Tailored sheets that continue & improve current spreadsheets

• Database Management & Policies

• Advanced Analytics & Forecasting

• Building for robustness & Longevity

• I started this Google Sheets business because I craved a new challenge that would push me into unfamiliar territory. I wanted to create something truly my own, using my expertise to make a real impact. Offering Google Sheets solutions is a skill I’m deeply proficient in, and it felt fitting to use it to uplift businesses that value authenticity and professionalism.

• The name "Sidekick" reflects my vision of empowering clients while keeping them in control. They are the heroes of their own companies, and I’m here as their sidekick, supporting them to achieve their goals. This idea has been a quiet passion for many years, and now I’ve finally given myself the chance to bring it to life. I love the fast pace and freedom of this work, knowing that every project is an opportunity to make a difference.

• I believe every company deserves access to a spreadsheet solution that is secure, powerful, and tailored to streamline workflows, save time, reduce errors, and enable data-driven decisions, all without the high price tag and hidden costs of other spreadsheet solutions. Seeing the hefty fees of other software providers only solidified my belief that Google Sheets, being free and highly adaptable, is a smarter choice. Instead of a blank, unsupported canvas, businesses can have a custom solution that meets their specific needs.

• Working alongside clients who want to grow and achieve more is genuinely fulfilling. My goal is to support them in a way that prioritizes their growth while also positively impacting their personal lives. Life is too short to be caught in endless cycles of mundane business tasks when it could be spent having breakfast with family, cheering at your child’s game, staying up to help with homework, or cooking dinner together. Helping clients reclaim that balance between work and life is what drives me to go all out in everything I do.

• Stock Status

  • Built and manage

  • Automated through a pipeline with logic applied for external and internal use

  • Supersessions

  • Price Lists

  • Policies applied to logic

  • Back in Stocks with timestamps and email notification

• Internal Fleet

  • Expenses & Cost Analysis

  • Fuel Analysis and Forecasting

  • Vehicle service plans vs predicted mileage 

  • Triggered emails and logic for vehicle services, vehicle and driver license renewals via Google App scripts

  • Root Cause Investigations

  • Anomaly Spotter

• Couriers

  • Expenses & Cost Analysis

  • Shipping Cost Adjustments

  • Customer Satisfaction

  • Root Cause Investigation

• Warehouse

  • Triggered emails and logic for fire safety equipment as well as serviceability within each warehouse via Google App scripts

  • Inventory Reporting and Analysis

• Price Lists

  • Supersessions

  • Dead Stock

  • New Stock & Naming conventions

  • Barcode Management

• Supplier Inventory

  • Automated Reports to suppliers

  • Google App scriptted sheet that generates certain reports based on multiple criteria per supplier

• Buying Strategies

  • Different internal and external factors considered 

  • Monitoring sell-through and cover

• Drawdowns & Upliftments

  • Stock moving

  • Picking Lists

  • Stock recons

• Store Shuffles

  • Custodian

  • Stocking Levels

  • Data dumps to lists per store on collection and warehouse picking lists

  • Stock Take Management

• Efficient Supplier Selections

  • Strategic recourse analysis and management

  • Automated reports to generate passive income

• Product Database Management

  • Product master for Vend/Lightspeed

  • Pricing Analysis & Implementation

  • Price List Clean Ups

• • Stocking Levels

    • Combination of forecasting the optimal stocking level that considers tray/packet sizes

    • Opened a new blank canvas store based on prediction

• • Ad hoc Reports

    • Distribution containers

    • Delivery Charge adjustments

    • Order Insights

• • Orders

    • Forecast and predict optimal levels to order with numerous factors considered (South African Suppliers) factoring locational suppliers

• Customer Database Clean-ups

• Reverse Geocoding

• Business Plans

• Rebate Report

• Sale Representative Sales Tracking Report

  • Built a data pipeline to update the data with insight and use of other databases for each rep

  • Email notification triggered

• Sale Representative Month-End Report

  • Google Cloud Hosting

  • Data Studio dashboard to allow tailor-made reports

  • Heatmaps and scattered sales maps

• Reallocation of Sale Reps

  • Based on many factors to get the most effective territory

• Fertilizers, Farm Feeds, Seeds and Remedies (ACT 36)

  • Built data pipeline to manage resources

  • Auditing and clawback reporting

  • Supplier reports

• Excess Stock Management

  • Built a user-friendly dashboard using existing databases

• Stock Distribution

• Auditing Promotions and Clawbacks

• Generating and Presenting Reports

• Growth Strategies

• Developed generic app to automate a data pipeline within the company’s environment, saving time in building and testing

• Bridged gap between stores and the Sale Representatives via data driven reports that can be customized to facilitate any conversation

• Generated a system that allows the user to data dump and pull insight such as buy-ins, stocking levels, store shuffles and redistributions of stock

• Integrating Google Forms, Sheets, Data Studio and Gmail within the Google environment

• A personal win is effectively communicating my needs while supporting the needs of everyone in the team, this also includes guiding the leadership and instilling values that support the whole team that motivates and respects the culture and ethics of everyone to allow the support within a functional team  

My personal values and needs were not being met, and I had outgrown my role. I needed a change to rejuvenate my energy and pursue new opportunities.

• Champion Internal Comms Strategy via WhatsApp Business by weekly sharing media-rich, sharable content to all the Retailers to increase pride and loyalty for the company. I created the model and aligned with everyone in the company

• Social Studio sentiment adjustments, reports created based on competitors’ insight as well as recent campaigns and strategies

• Monthly Management Deck assistance

• Maintained the sales funnel Dashboard that I created in Google Data Studio (data is pulled from Google Data Sheets)

  • • I created a proposal to automate all weekly sale funnel reports for the South Africa and Sub-Saharan Africa markets

• Monthly Customer Forum Deck created using all the Customer Complaints, Breakdown reports and response rate on social media complaints

• I assisted the Data Warehouse Team which includes dotModus and created a proposal for a dashboard that pulls the data required for the Customer Forum into a highly detailed automated report. This assisted the business by checking regularly what is working and where improvements can be made

• Ad-hoc strategy creation

• Strategy to increase foot traffic for the experience centre and organic traffic to the restaurant on site

• I joined the team to create the first virtual event for JL South Africa and Sub-Saharan Africa, the Retailer 2021 Strategy with COVID

• Product Investigation via social media opinions

• Product specialist in the Defender 90 for the homologation vehicle

• Defender 110 Customer and Headquarter reveal activations

• Team Member for our first ever virtual ROTY and IOTY Awards Ceremony

• Revolutionizing reception with technology and better practices

• Represent the brand in a respectful way and try my best to help all customers as well as the Headquarter employees and Training Academy

• Manage customer expectations when transferring calls to the case managers

• Relay highly detailed facts to my colleague or case manager before transferring calls

• Send and receive parcels and deliveries

• Package parcels

• Complete waybill and custom documents

At the time, the whole organisation was in a headlock and could not take me as a full-time employee after my contract elapsed.

• Fairly and accurately mark all scripts across the grade

• Respectively ensure the marking is neat and comments are within reason

• Arrive on time and clock in hours correctly

• Adjust marking level for First, Second and Third Year

This position is for Honour students at the University of Pretoria, so this position lapsed once I had finishing studying.

• Attend regular meetings about the content, ways to facilitator and catch-up sessions

• Facilitate content sessions throughout the year to students in Zinnia’s residency

• Mentor the students and provide them support

• Be diplomatic to everyone’s point of view

Having been in the programme for three years as well as uncertain application status for Honors in 2019, I did not apply for any further leadership positions.

• Collect and drop off stock and equipment

• Dress appropriate with the table laid out as prescribed

• Provide insight to the brand based off my research

• Sell as many units as possible

I wanted to pursue other career developments.