Jerick Sebree

Jerick Sebree

Business Intelligence & Data Analyst

Welcome

Learn more about Jerick Sebree

down

At a glance

FULL NAME

Jerick Sebree

LOCATION

United States

PHONE

(770)733-8653

Introduction

Thank your for taking the time to get to know a little about me. I am Jerick, and I build data solutions. I am also a husband, a former athlete, a sci-fi enthusiast, and a paw parent to a beautiful Frenchton pup. I’ve always been described as inquisitive and that curiosity is what ultimately led me to a fulfilling career in analytics. I’ve spent the last 10 years refining analytical skills from both the backend and service side of data management, with my two most recent roles being in Data Analysis and Business Intelligence. It is this technical experience in addition to my experience as a Financial Analyst that makes me uniquely equipped to deliver end to end data solutions directly to business stakeholders without the need for a Business Analyst to interpret business requirements.

Expertise

My strengths consist of delivering automated data solutions that promote operational efficiency and extract meaningful information from large datasets. This includes performing ETL operations such as mining and scrubbing public or organizational databases, transforming and modeling data, creating pipelines, and building impactful data visualizations.

Contact Me
SQL
Tableau
BigQuery
Power BI
Excel
Salesforce

Resume

Professional Experience

Download Resume

Senior Business Analyst

Zillow
January 2021 - Current

  • Manage Rentals organizational OKRs including facilitation of 2022 Objectives, overseeing MBR and WBR Reviews of OKR metrics, and presenting progress to senior leadership in All Hands forums 
  • Streamline business processes and efficiencies by leveraging intermediate to advanced skills in SQL, Salesforce, and Tableau to create standardized dashboards, datasets, automations, and self-service tools
  • Lead analysis of $11M project to expand multi-family housing footprint across underserved markets 
  • Pioneer views into market segmentations including geography and population size 
  • Collaborate with product managers, senior leaders, data science, marketing and other cross functional partners to create ad hoc analyses and dashboards to monitor success of the business 
  • Create Analytics Leaders Team (ALT) to leverage best practices across the various analytical disciplines that support Rentals including data science, data visualization engineering, and sale operations analytics

Senior Data Analyst

The Home Depot
August 2019 - January 2021

  • Decreased warehouse inventory replenishment processing time by 20% by creating workflow automation 
  • Conducted interviews with key business partners and end users to capture business process workflow and user requirements 
  • Created custom data pipelines while executing efficient ETL solutions with tools such as Excel, GCP, BigQuery, and Tableau 
  • Created self-service solutions with tools such as Tableau to better manage and track key metrics 
  • Developed customized scheduled reporting and dashboard views to provide business leaders with real-time insights on KPIs 
  • Performed ad hoc analyses and presented results and recommendations to leadership team 
  • Fostered cross-functional business relationships as well as developed Junior Analysts

Business Intelligence Analyst

Southern Company
June 2018 - July 2019

  • Coordinated and managed Southern Company Gas’s multi-organizational database integration project with the upgrade of claims management platform 
  • Directed the migration of data in three key Southern Company Gas divestitures, overseeing the transfer of over 250,000 records 
  • Developed custom dashboard solutions for real time KPI tracking of claim management utilizing SQL, SAP BusinessObjects, VBA, and MS Office Suite 
  • Created, maintained and scheduled over two hundred custom reports each crafted to deliver key insights to company performance 
  • Served as System Administrator for the primary user applications of three company divisions 
  • Oversaw master data management, encouraging users to follow best practices and ensuring data integrity 
  • Advised directors and upper management on initiatives related to business strategy, budget, and procurement of vendor services 
  • Championed automation and process improvement, building synergies across organizations and efficiencies in information delivery

Analyst

Metropolitan Life, Inc.
June 2012 - May 2018

  • Developed billing and reporting automation tools, decreasing production time by 33% by utilizing various technologies including MS Excel, MS Access, SQL, Visual Basic and Macros
  • Produced and analyze financial charts, tables, ratios and reviews for 15 National Account Customers totaling over $100M in annual revenue using Cognos, Excel, and PowerPoint
  • Led Customer Unit’s Efficiency Team to identify and manage potential projects aimed to improve workflow and productivity across multiple divisions
  • Created and maintain customer specific databases to facilitate day-to-day financial management
  • Presented results from financial report analysis and advise management, internal partners, and clients on appropriate recommendations
  • Modeled revenue projections to estimate annual earnings and losses on key customers
  • Reconciled billed accounts and enter adjusting journal entries into GL adhering to GAAP principals

Grants Manager/Budget Analyst

The University of Washington, College of Education
September 2014 - June 2015

  • Constructed innovative budgeting tool that certifies and projects salary, tuition, and other payroll related benefits for over 30 employees – implemented across all financial departments at the College of Education
  • Extracted and analyzed detailed expense reports utilizing the university’s data mart and Excel pivot tables
  • Managed 35 state, federal, and private grant funded budgets totaling $15 million in funding
  • Supervised procurement specialist, overseeing day-to-day transactions, travel, and ad hoc purchases
  • Partnered with local faculty, faculty from partnering institutions, and subcontractors to ensure budget compliance on private, federal, and state grants
  • Extended, closed, maintained, and requested grant budget advancements depending on the need of the faculty

Operations Risk Management Advisory Associate

KPMG
July 2011 - June 2012

  • Tracked stakeholder pain points and communicated results to technology partners for a multibillion-dollar integration acquisition project
  • Directed client cost analysis on perspective IT project releases for one of the nation’s leading commercial bank firms
  • Prepared detailed reports, PowerPoint slides, and data analysis for key initiatives for senior level management
  • Managed firm’s implementation guides that set the standard for client’s customer implementation accounts
  • Managed day to day status tracker, PowerPoint presentations and data analysis

Education

Download Resume

The University of Massachusetts

Bachelor of Science in Information Technology
September 2017 - May 2019

  • Magna Cum Laude; Alpha Sigma Lambda Honor Society
  • 3.8 GPA

The University of Georgia

Bachelor of Business Administration in Banking & Finance
August 2008 - May 2011

  • Bachelor of Science Education in Sports Management (Dual Degree)
  • INROADS Scholar
  • 3.2 GPA

Portfolio

Zillow Analysis
Zillow Analysis
NFL – QB Analysis
NFL – QB Analysis
Civil Injustice Infographic
Civil Injustice Infographic
US Economy Q3 2020
US Economy Q3 2020

Contact Me












Your message was sent successfully!

Something went wrong, try refreshing and submitting the form again.