Greta gerdaa

Spreadsheet UX/UI & Retention Architect

Shaga3App

Aug 2023 - Present • 2 yrs 9 mos

I focused on the "User Experience" of complex digital tools built within Excel and Google Sheets. I specialized in "Cognitive-Load Reduction," designing interfaces that make massive amounts of data easy to navigate and interpret through clean layout design and intuitive navigation menus. My role involved the creation of custom "Dashboard Layouts" and "Progress Trackers" that motivate teams to complete data entry and follow operational protocols. I utilized custom VBA to overhaul the standard look of Excel, creating a "Software-Like" feel with custom ribbons and buttons that justify premium consultancy pricing. I handled the technical side of "Access Control," ensuring that different team members only see the tabs and data relevant to their specific role. My daily tasks included the optimization of conditional formatting and sparklines to provide an instant visual view of performance without needing to read thousands of rows. I conducted "User Testing" sessions to identify navigation friction and implement fixes that improved data entry accuracy. My work helped many business owners increase their team's productivity and generate higher-quality reports from their spreadsheets. I provided "UX Blueprints" for new sites, ensuring that the design was built on a foundation of data visualization science.

Lead Data Cleaning & Normalization Specialist

Global Excel Summit

May 2023 - Present • 3 yrs

I serve as the lead technical consultant for large-scale data cleaning and structural normalization projects, specializing in "Lossless Data Processing." My primary responsibility is ensuring that businesses moving messy, legacy data into modern CRM or ERP systems do not lose critical information or maintain duplicate records. I architect complex Regex (Regular Expression) patterns and utilize VBA to automate the removal of duplicates, the standardization of addresses, and the correction of formatting errors across datasets of hundreds of thousands of rows. My daily operations involve optimizing the "Data Foundation," which includes configuring power-cleaning workflows that handle inconsistent date formats, currency conversions, and text string parsing. I handle the implementation of custom "Data Scrapers" and parsers that allow for the automated extraction of information from messy PDF or CSV exports into structured, usable formats. I conduct monthly technical audits to ensure that the data pipeline is healthy and that there are no "silent" errors affecting the integrity of the business's master records. My work helps established brands maintain high data quality scores, significantly increasing their operational efficiency and the accuracy of their predictive analytics.

Advanced CSV & PDF Data Migration Lead

Pivo

Apr 2023 - Present • 3 yrs 1 mo

I managed the end-to-end technical migration of legacy datasets into modern spreadsheet ecosystems for B2B and SaaS clients. My role involved using advanced VBA to monitor the entire data journey during the transition, ensuring no record was lost or corrupted. I specialized in recreating custom legacy functionalities—such as complex conditional formatting or historical trend analysis—within the new spreadsheet environment. My work included the creation of "Data Cleaning Pipelines" integrated into the new sheet to help teams maintain data hygiene moving forward. I am an expert in using visual data mapping tools to plan out every contingency, including the merger of multiple inconsistent CSV files into a single master database. My design process was heavily focused on "Friction Reduction"—stripping away unnecessary columns and steps from the old system to maximize the new sheet's usability. I provided ongoing post-migration optimization services, using split-testing to identify the best-performing elements of the new architecture. By treating the data migration as a technical systems overhaul rather than just a copy-paste job, I helped my clients achieve consistent, scalable growth and a clear understanding of their historical performance.