JOHN SIMON

EXPERIENCE

Aug **** INTERIM DATA ANALYTICS MANAGER

BellXcel

Jul 2021

Jun 2023

BUSINESS INTELLIGENCE LEAD

AMN Healthcare

Oct 2020

Mar 2021

BUSINESS INTELLIGENCE ANALYST II

In-Situ

May 2019

Mar 2020

IT ANALYST

InvenTrust Properties

Jan 2018

Jun 2018

OPERATIONS ANALYST

Comcast

Sep 2016

May 2017

BUSINESS ANALYST

University Of Northern Colorado

EDUCATION

2016

2020

BACHELOR OF SCIENCE COMPUTER

SCIENCE

Colorado State University

ad4l5p@r.postjobfree.com

720-***-****

OBJECTIVE

SKILLS

Developed and implemented analytics strategies to improve customer experience.

·

Analyzed large data sets to identify trends, patterns, and opportunities for improvement.

·

Monitored website performance metrics such as page views, time-on-site and bounce rates to optimize user engagement.

·

Collaborated with stakeholders to define business objectives and KPIs for analytics initiatives.

·

Designed dashboards using Tableau to define business objectives and KPIs for analytics initiatives

·

Developed automated reporting processes using SQL queries to streamline data extraction tasks.

·

Developed complex SQL queries to extract and analyze data from multiple sources.

·

Utilized Power Bi and Snowflake to partner with the Information Technology department to test and validate automated dashboards to deploy into a production

environment.

·

Worked within the Sales Operations Reporting team to build out a 360-degree view of our MSP customers and identified opportunities to use analytics and reporting tools to influence decision-making within the organization to achieve business objectives.

·

Ran all scorecard and daily reports for the MSP Organization, and assist in running VMS/AV reporting out of ShiftWise and Fieldglass.

·

Gathered user feedback to improve existing reports or create new ones and identified opportunities for data optimization and automation of processes.

·

Automated client QBR's and measurements of internal turn- around times and compare to SLA's and benchmark and processes.

·

Created technical documents outlining processes, procedures and standards used in Business Intelligence development efforts.

·

Implemented process improvement metrics and trends utilizing KPI's in Power Bi.

·

Identified opportunities for data optimization and automation of processes for Client QBR's.

·

Generated daily, monthly and quarterly reports utilizing tableau to address short or long-term business intelligence needs.

·

Leveraged organizational business intelligence data to derive critical insights relating to customer product consumption using Google BigQuery and Tableau.

·

Designed, developed and established KPI's to provide analysis and strategic insights that drove performance.

·

Worked closely with developers to resolve app functionality issues by creating and executing test plans while documenting performance results.

·

Optimized legacy SQL to improve dashboard efficiency and functionality.

·

Performed data cleansing and manipulation using MS Excel to verify customer account information.

·

· Designed and implemented ETL processes in SSIS packages. Created technical documents outlining processes, procedures and standards used in Business Intelligence development efforts.

·

Integrated new technologies to meet area and project requirements.

·

Collaborated with engineers and departmental managers to identify, develop and implement software for a SharePoint data migration project.

·

Collaborated with engineers and senior directors of IT to draft customized IT deployment communication and roadmaps.

·

Designed and created database systems after reviewing end user's requirements within Microsoft SQL Server

·

Utilized unit testing and other methods to enhance quality within Google BigQuery

·

Developed and implemented IT solutions to streamline business processes.

·

Conducted computational analysis to produce interactive dashboards in Tableau by visualizing sales forecasts and profits for monthly business presentations and enterprise client reviews

·

Utilized Jira to track organizational efficiency and establish a new workflow system that improved departmental productivity by approximately 15%

·

Tested databases and performed bug fixes within Microsoft SQL Server to optimize queries

·

Created sales analysis using Power BI to analyze product performance and revenue by year

·

Developed and launched new offerings tool to optimize customer satisfaction utilizing Google BigQuery

·

Conducted root cause analyses to formulate countermeasures to business missteps and improve operations.

·

Generated weekly financial reports within Excel to recommend cost optimization strategies to senior

management.

·

Proactive, customer-orientated retail

professional with over 4 years of

experience in reputable shops.

Received 3 ‘Passion Awards’ for

delivering outstanding service and

have consistently surpassed my target

KPIs for mystery shoppers.

· Google Analytics Certified

· Certified Scrum Master

· Microsoft SQL Server Certified

· Python

· Tableau CRM

· Power Bi and DAX

· Snowflake

· Shiftwise

· Fieldglass

· Salesforce

· Forecasting and Planning

· Data Mining

· Process Development

· Agile Project Management

· KPI Dashboard and Metrics

· Technical Writing

· SDLC and PDLC

Contact this candidate