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.
Freelance
-
Business Intelligence AnalystFreelanceIrvine, Ca, Us
-
Ai Prompt EngineerOutlier Oct 2023 - Jul 2024San 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. -
Sr Data AnalystAllied Universal Jul 2022 - Oct 2023Irvine, 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. -
Sr Data AnalystHealthequity Oct 2018 - Jul 2022Draper, 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. -
Sr Data AnalystCompass Group Mar 2016 - Oct 2018Chertsey, 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. -
Data AnalystEcolab Aug 2015 - Mar 2016St. 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. -
Business AnalystFirst 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 UniversityBusiness Intelligence -
Metro State UniversityPsychology
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial