About Me

Photograph of Samuel Garen Name: Samuel Garen
Pronouns: He / Him
Location: Portland, Oregon, USA

I am an award-winning data analyst, project manager, and technical team leader based out of Portland, Oregon. I make complex information understandable, actionable, and beautiful. Currently I help Grafana Labs execute analytics and engineering projects to glean insights from large data sets and make better decisions through reporting, visualization, modeling, and predictive analysis in support of their sales / GTM / revenue operations efforts.

I believe in stripping problems to their foundations and building from there, focusing first upon simplicity, ease of use, usefulness, quality, and understandability. The best designs are essential, intuitive, and effortless to use, and it is only through close communication, careful research, dismantling of preconceptions, and meticulous attention to detail that this may be achieved.


Experience

Grafana Labs

Stockholm, Sweden


  • Senior Manager, RevOps Analytics

    October 2022–Present (1Y 7M)

At Grafana Labs, I lead the company's analytical capabilities within the Revenue Operations / GTM / Sales organization, partnering closely with Finance and other cross-functional organizations to drive insights, ensure reliable access to critical operational data and metrics, and forecast and predict business performance and trends.

Adidas AG

Herzogenaurach, Germany


  • Senior Manager of Data Solutions

    May 2021–September 2022 (1Y 4M)

  • Manager of Data Solutions

    December 2020–May 2021 (5M)

  • Manager, Business Performance Analytics

    December 2019–December 2020 (1Y)

  • Assistant Manager, Business Performance Analytics

    January 2019–December 2019 (11M)

At Adidas, after successful roles taking over the eCommerce division's Business Performance Analytics team, I founded a back-of-house data science and development studio called Data Solutions, delivering end-to-end support for our business partners in the eCommerce and Retail divisions, Omnichannel Analytics, various business units, and our executive suite. Our work spanned from construction of data sets and development of our data foundation, through automated reporting, dashboarding, and construction of tools, to advanced analytics, modeling, forecasting, and other data science projects. My team ensured our internal clients and external business partners have immediate and reliable access to key infomation, worked to elevate, contextualize, and prioritize key data from massive datasets for our partners, and provided critical insight into operational data to assist our partners in making data-driven decisions to steer the business.

Key Achievements

  • Management of a team of four analysts and developers focusing on in-market development of new tools and data capabilities, with special focus upon delivery of queryable data in domains previously inaccessable to end users. Successful data foundation deliveries include:
    • Sales order data for eCommerce
    • Invoice (net sales) data for eCommerce
    • Supply chain and inventory data for all commercial channels
    • Geolocated sales data for eCommerce
    • Aggregated clickstream and app experience data from Adobe and Amplitude raw data
    • Product metadata
    • Data from credit card and other payments processors
    • Customer contact and call center data
  • Ground-up design, development, and support for the eCommerce division's core financial and operational forecasting engine, providing detailed daily and real-time projections of daily sales and other metrics used to set targets and monitor business performance, plan and execute commercial events like promotions, staff distribution and call centers, and identify financial risks. Actions taken based on recommendations from this engine generated an additional $10 million USD in sales in 48 hours over Cyber Monday 2020 and an additional $12 million USD in sales over Black Friday and Cyber Monday 2021.
  • Development of an automated predictive financial waterfall engine, producing daily projections of consumer demand, shipment backlogs, consumer and supply chain cancellations, returns, net sales, margin, and profitability at fine grain. Previously exceptionally labor-intensive, this approach both fully automates this task allowing for daily, rather than occasional on-demand projections, but produces these projections with average error 70% lower than manual methods and at individual product level, rather than just a total business view.
  • Development of the eCommerce division's product sales and inventory reporting systems, blending financial, inventory, web clickstream, marketing, and social media data with product metadata in various capacities into Tableau and Excel, providing business partners daily visibility into key performance metrics, geolocated financial and web data, forecasts, and automated predictive analyses.
  • Training of other analysts and operational teams on successful use of SQL, Python, advanced techniques in Excel, and visualization techniques in Tableau with particular concentration on visualization and reporting techniques accommodating of disabilities such as dyslexia and color blindness.

Portland General Electric

Portland, Oregon, USA


  • Independent Consultant, Operations and Analytics

    April 2014–February 2022 (7Y 11M)

Portland General Electric retained me as a consultant to assist with software solutions and data analysis for needs that could not be satisfied immediately by internal teams. Key projects included development of software tools to collect and parse arcane network performance data and aggregate this into readable reports, reducing labor for this reporting by 95%. Other projects included SQL training for internal business analysts, advisement on methodologies for producing actionable reporting based on available data, recommendations on best practices for research of non-communicative system nodes based on analysis of successful repair rates, and rapid-turnaround repair and support for preexisting scripts and other software tools.

Key Achievements

  • Development of software packages and scripts in VBa, Python, and SQL for statistical analysis of systems performance and reliability data to meet immediate needs that could not be accommodated by internal development and data teams.
  • Designed and implemented process improvements in support of major database and software system transition, decreasing labor on reporting tasks by 95% and reducing errors by 75%.
  • Facilitated development of a library of technical documentation of above analytics tools and methodologies.
  • Trained network data analysts on SQL language / Oracle SQL dialect, core concepts, and best practices as well as efficient use of Oracle SQL Developer.

Epiq Global

Beaverton, Oregon, USA


  • Senior Project Coordinator / Senior Project Lead

    March 2018–December 2018 (9M)

  • Project Coordinator / Project Lead

    September 2016–March 2018 (1Y 6M)

  • Project Coordinator

    October 2015–September 2016 (11M)

At Epiq, I led multiple simultaneous projects to assist with recovery of damages related to large-scale, systematic banking fraud and other regulatory matters. Operating under intense regulatory and media scrutiny, these programs have successfully helped more than two million individuals and businesses recover over $2 billion USD, while assisting auditors with identifying patterns of fraud and potential additional areas of investigation. To support these projects, I also acted as client liasion and project advisor to technical teams on a SaaS legal claim database management tool for client and regulator use, heavily customized for each settlement project. These projects were among the most sophisticated the company handled, each with revenues between $1 million and $10 million annually.

Key Achievements

  • Served as key liaison and project lead to Fortune 500 clients and Big Four banks on four of the company’s largest projects, each exceeding $1 million in monthly revenue and together earning over one quarter of division revenue.
  • Collaborated with Agile development team on bi-weekly sprints, attended daily scrums, provided business, functional, and technical requirements, approved wireframes and demos, and performed UAT for software updates to SaaS database management web application.
  • Created series of process improvements and supporting software for a series of high-labor, error-prone mailings processes, reducing labor on these tasks by 88% to 97%.
  • Developed software tools used by project team to administrate settlement projects, providing unique visibility, flexibility, and reportability, as well as forecasting four times more accurate than possible with previous tools.

Portland State University

Portland, Oregon, USA


  • Graduate Teaching Assistant

    September 2012–March 2014 (1Y 6M)

At Portland State University, I acted as an assistant instructor in a series of undergraduate history courses, mostly concentrating on World History and the history of the Middle East. I received the honor from the professors I worked with to offer frequent presentations on the history of the Middle East to students, where I developed a presentation style characterized by bold, graphic typography, meaningful use of animation, and rich, rapid-fire imagery. I also polished skills in providing positive, constructive feedback and critique of ideas, which continues to serve me well.

Key Achievements

  • Presented weekly lectures for undergraduate classes of 60 to 80 students in world history, classical history, and the history of the Middle East. Polished skills in public speaking, instruction, and clear presentation of complex information.
  • Held regular discussion and mentoring sessions among students, including constructive critique of writing and analysis skills and techniques.
  • Graded assignments, papers, and essays and provided constructive feedback to students.
  • Twice-recipient of Portland State University's "Rockstar Graduate Teaching Assistant" award, for spring term 2013 and winter term 2013.

Education

Portland State University

Portland, Oregon, USA


  • Master's of Arts, History, Architectural History Focus (Unfinished)

For graduate school, I elected to continue my work in architectural history, focusing upon the use of visual symbol and motif to communicate across linguistic and religio-cultural lines in the medieval Middle East, with additional focus upon the network of logistics and trade established that provided inspiration and materials which have profoundly influenced the architecture and material culture of the Middle East. Unfortunately, the intensification of the Syrian civil war and resultant destruction of the structure that was to be a focus of my thesis has forced me to place further work on hold.

Portland State University

Portland, Oregon, USA


  • Bachelor's of Science, History, Architectural History Focus

  • Minor, Architecture

  • Additional Study, Civil Engineering

For my bachelor's degree, I knew I was excited about design, but did not immediately have a clear direction. I decided to build my own course of study by approaching design from three angles: civil engineering, architecture, and architectural history. I was honored to have work I produced in all three disciplines preserved in Portland State's archive as future teaching materials, as well as a number of designs presented by the School of Architecture to the National Architectural Accrediting Board in their successful arguments for accreditation.

Seattle Pacific University

Seattle, Washington, USA


  • Foundational Study, Classics and History

Key Skills

Interpersonal

  • Project management
  • Development and management of diverse teams
  • Communication and public speaking
  • Confident decision-making
  • Building partnerships with clients and vendors
  • Collaborative leadership
  • Mentoring and employee development
  • Strategic analysis and planning
  • Problem resolution
  • Product development
  • Procedure design and implementation
  • Risk assessment and mitigation
  • Milestone tracking and reporting
  • Quality assurance
  • Operational efficiencies and process improvements
  • Development and use of corporate brand identities

Technical

  • Adobe Analytics
  • Adobe Creative Suite
  • Agile, Kanban, Scrum, and Waterfall methodologies
  • Alteryx Designer, Server, and Analytic Apps
  • Amazon S3
  • Azure DevOps Server
  • Clari
  • Excel / VBa
  • Financial modeling & analysis
  • Google Analytics
  • Google BigQuery
  • Google Docs / Sheets / Slides
  • Grafana
  • Hadoop / HUE / Hive / Impala
  • HTML / CSS
  • Jira
  • Microstrategy
  • Predictive modeling & classification
  • Python
  • SAP HANA
  • Salesforce
  • Selenium
  • SketchUp
  • SQL (ANSI, Exasol, Oracle, and Microsoft SQL Server dialects)
  • Tableau
  • Technical documentation

Sample Work

Product Sales Dashboard

Tableau logoTableau

This report provides detailed product sales metrics, enabling easy comparison to forecast, along with other derived metrics such as margin, discount rate, and average sales price. Metrics are displayed at top level for easy consumption, visualized by a number of key product and sales channel attributes, and broken further into the top products contributing to overall sales. Selectors at left allow visualizations to be easily changed among modes to help the user understand where over­performance and under­performance to forecast are coming from and filters allow the user to quickly drill down into key products. Histograms at lower right inform how sales are distributed by price and margin to ensure sales are generated profitably. Product color data is incorporated to assist in identifying trends.

Source Code for This Website

HTML iconHTML / PHP

This Github repository contains the source code for this website, allowing review of the embedded PHP. The PHP within this page performs some silly trickery, such as dynamically generating the date range and duration for each job title shown above and sets the globe icon next to each employer or university's city and state above to a map centered on the actual location. I used construction of this portfolio site as an excuse to learn a bit more PHP, such as working with geodata and dynamic manipulation of SVGs.

Awards

Adidas AG

  • eCommerce Division Peer Recognition Award

    Q2 2022

  • eCommerce Division Peer Recognition Award

    Q4 2021

  • Special Recognition for Exceptional Performance

    Q4 2020

  • 3-Cs "Confidence" Award for Outstanding Leadership

    Q3 2019

Portland State University

  • Rockstar Graduate Teaching Assistant

    Winter Term 2013

  • Rockstar Graduate Teaching Assistant

    Spring Term 2013

Contact Info

E-mail sdgaren@gmail.com LinkedIn - linkedin.com/in/sdgaren