Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

Trevor Guleserian

Senior Data Analyst
Lees Summit,MO

Summary

Highly skilled Senior Business Analyst with training in Business Administration from Oklahoma Baptist University. Possesses proficiency in Python, R, JavaScript, Tableau, Big Data, Machine Learning, SQL, noSQL, HTML, and CSS acquired from Kansas University Data Analytics Boot Camp. Demonstrates expertise in analytics, team collaboration, and effective communication. A driven and proactive individual who excels in supportive and demanding environments. A valuable asset for organizations seeking a highly skilled professional. Systematic Data Analyst with 4 years of experience and extensive training in Healthcare and Marketing. Expert in businus administration and data collection for research and metric analysis. Proven skill in effective collaboration, maintaining lasting rapport with coworkers and clients.

Overview

7
7
years of professional experience
5
5
years of post-secondary education

Work History

Healthcare Analyst

JG Consulting Associates
Olathe, Kansas
9 2022 - Current
  • Tasked with analysis of healthcare reimbursement data from a variety of provider groups and hospitals, renegotiation of contractual rates based on firsthand data, and generating government mandated pricing transparency tools for several clients
  • Successfully negotiated millions of dollars' worth of reimbursement increases for clients leveraging Healthcare claims data
  • Acquired skills include negotiation techniques, contract modeling, transforming data insights to comprehensive visual stories for executives, managing client relations, and revenue cycle management.
  • Improved patient care quality by analyzing healthcare data and identifying trends.

Marketing Analyst

Rain the Growth Agency
Portland, Oregon
04.2022 - 03.2023

Charged with accurate collection and analysis of digital and traditional marketing data for seven clients with multimillion dollar monthly budgets

  • Tasked with analytical reporting and maintenance of dashboard for Paid Search, Paid Social, OTT, Programmatic Display, TV, Print, Direct Mail, and Radio marketing channels
  • Integrated marketing and analytics tools to drive data-driven decisions and improve campaign performance
  • Acquired skills include how marketing campaigns drive client goals, monitoring and managing integrity of data, discovering actionable insights from data, dashboarding with Datorama and Tableau, parsing operational and usage data, ETL, manipulating and harmonizing data from primary and secondary sources, understanding of marketing principles and tactics, and managing client relations.
  • Participated in ongoing professional development opportunities to stay current on best practices within the field of marketing analytics.
  • Assessed KPIs to achieve in-depth understanding of campaign performance.

Associate Digital Marketing Analyst

SelectQuote
Overland Park, Kansas
02.2021 - 04.2022
  • Charged with accurate collection and analysis of digital marketing data from external sources and internal databases leveraging SQL
  • In charge of analytical reporting and maintenance of dashboard for Paid Search, Paid Social, and SEO channels
  • Acquired skills include Data validation, ETL, Statistical Analytics, SQL modeling, delivering actionable insights derived from data, and critical thinking.

Charge Entry Specialist and Medical Office Specialist (Oncology Float)

Hospital Corporation of America
Kansas City, Missouri
01.2018 - 01.2021
  • Charged with accurate and timely billing of Oncology Patients while also aiding in day to day operations of clinics
  • Acquired skills include time management, teamwork, communication, and critical thinking.
  • Boosted customer satisfaction levels by addressing patient inquiries regarding their charges in a professional and respectful manner.
  • Enhanced revenue cycle management through timely and accurate charge entry for medical procedures and services.

Education

Data Analytics Bootcamp Certificate - Data Processing Technology

Kansas University
Kansas City, KS
04.2020 - 09.2020

Bachelor of Business Administration -

Oklahoma Baptist University
Shawnee, OK
08.2014 - 05.2019

Skills

Python

R

JavaScript

Tableau

CSS

HTML

VBA

Power BI

Amazon Quicksight

Google Analytics

Datorama

SQL

NoSQL

Projects

Citi-Bike-Analysis, https://github.com/trevorguleserian/Citi-Bike-Analysis, The purpose of this project was to analyze the New York Citi bike transit system. This data was utilized to analyze trends in use based on gender, age, subscribership, geography, station, and bike ID. This project stretched personal ability to visually present a wide variety of complex data. Tableau was leveraged to analyze and present data in story format. SQL-Employee-Analysis, https://github.com/trevorguleserian/SQL-Employee-Analysis, The purpose of this project was to create and query a staff directory relational database. This project enhanced personal ability to operate a relational database. PostgreSQL was utilized to create a server where I built a schema based on a custom ERD after which I queried the data. ETL-Project, https://github.com/trevorguleserian/ETL, This group project charged members to Extract, Transform, and Load data. Personal responsibility on this project was to import data, transform NFL-stats data, and create an SQLite database file. The team utilized Python's Sqlalchemy, Pandas, and SQLite modules to Extract, Transform, and Load the data.

Timeline

Marketing Analyst

Rain the Growth Agency
04.2022 - 03.2023

Associate Digital Marketing Analyst

SelectQuote
02.2021 - 04.2022

Data Analytics Bootcamp Certificate - Data Processing Technology

Kansas University
04.2020 - 09.2020

Charge Entry Specialist and Medical Office Specialist (Oncology Float)

Hospital Corporation of America
01.2018 - 01.2021

Bachelor of Business Administration -

Oklahoma Baptist University
08.2014 - 05.2019

Healthcare Analyst

JG Consulting Associates
9 2022 - Current
Trevor GuleserianSenior Data Analyst