John Jarvis

John Jarvis Email and Phone Number

Business Intelligence Analyst @ Irvine, CA, US
Irvine, CA, US
John Jarvis's Location
Irvine, California, United States, United States
About John Jarvis

Over 8 years experience focused on Data Processing, Analysis, Visualization. I am comfortable in DOMO, Power BI, Tableau, Sigma. Also SQL & Python. I have several years of experience in Snowflake and AWS systems.

John Jarvis's Current Company Details
Freelance

Freelance

Business Intelligence Analyst
Irvine, CA, US
John Jarvis Work Experience Details
  • Freelance
    Business Intelligence Analyst
    Freelance
    Irvine, Ca, Us
  • Outlier
    Ai Prompt Engineer
    Outlier Oct 2023 - Jul 2024
    San Francisco, Us
    ▪ Engineer targeted prompts for an LLM to generate functional code blocks.▪ Critically review Python and SQL code produced by LLM.▪ Write Python & SQL code to correct bad responses produced by the LLM.▪ Evaluate and rate performance of other trainers, using a detailed rubric.
  • Allied Universal
    Sr Data Analyst
    Allied Universal Jul 2022 - Oct 2023
    Irvine, Ca, Us
    • Designed and built ETL/ELT processes that integrate data from several sources for use in reporting using AWS S3 buckets, DOMO Workbench (ETL), and Azure (business data), PostGRE (project data).• Built dashboards used by developers to monitor performance of proprietary ML tools, ensuring that a 90% fill rate is achieved by the system.• Created data sets based on text message conversations, to feed a dashboard that enables prompt correction of over 95% of conversational errors.• Integrated data from several services to build a phone and update tracking tool, which located and elicited updates of over 80% of the non-compliant phones in the first month after implementation.• Aggregated time series data to show hourly patterns over a day, daily patterns over a month, etc. of Workday tracking more than 40,000 shifts per week.
  • Healthequity
    Sr Data Analyst
    Healthequity Oct 2018 - Jul 2022
    Draper, Ut, Us
    • Created and maintained hundreds of denormalized BI & reporting views in Snowflake that provide data for use in dashboards, built on claims tables adding > 500,000 new records per week, call center data handling 100’s of calls per day.• Designed, built and maintained a call center dashboard that integrated data from Salesforce, Avaya and other sources to track individual and team performance, call reasons, and frequency of calls based on demographic criteria.• Built and maintained Marketing, Claims and Operations dashboards using DOMO and Power BI.• Rebuilt dozens of Tableau dashboards in DOMO as part of a migration from DB2 to Snowflake.• Wrote documentation for reporting, dashboards and Snowflake views, aligned with organizational best practices.
  • Compass Group
    Sr Data Analyst
    Compass Group Mar 2016 - Oct 2018
    Chertsey, Surrey, Gb
    • Built sales performance dashboards for cafeteria and vending outlets using Power BI.• Used SSRS to generate weekly Excel reports for smaller and franchised businesses.• Developed automated quarterly customer satisfaction reports to University cafeteria vendors, sourcing data from Azure database using VBA scripts and Excel spreadsheets.• Wrote Python scripts to quantify aspects of written responses to customer satisfaction surveys.
  • Ecolab
    Data Analyst
    Ecolab Aug 2015 - Mar 2016
    St. Paul, Mn, Us
    ▪ Received and validated data from restaurants, used in the development of an at risk locations tool.▪ Wrote and ran VBA macros to ensure that input data matches expected logic and formats.▪ Collaborated with developers to test and QA the locations tool.
  • First Choice Global Marketing
    Business Analyst
    First Choice Global Marketing May 2013 - Jul 2015
    ▪ Provided wholesale sales reporting & analysis.▪ Designed report documents to accurately match customer requirements.▪ Reported weekly sales and promo activity to all vendor clients and internal executives.▪ Gathered requirements to facilitate product specific progress reports.

John Jarvis Education Details

  • Capella University
    Capella University
    Business Intelligence
  • Metro State University
    Metro State University
    Psychology

Frequently Asked Questions about John Jarvis

What company does John Jarvis work for?

John Jarvis works for Freelance

What is John Jarvis's role at the current company?

John Jarvis's current role is Business Intelligence Analyst.

What schools did John Jarvis attend?

John Jarvis attended Capella University, Metro State University.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.