Data Analyst Sales Service

John de Joya

Lakewood, CA ************@*****.*** 562-***-**** linkedin.com/in/johndejoya github.com/migueldj66

Aspiring Data Professional. Experience with Tableau, Excel, Google Colab, Jupyter notebooks, MySQL Workbench Lakewood, California, United States

DATA ANALYST

Bi-lingual data analyst with experience at improving information accessibility through visual storytelling and adapted communication. Familiar with developing analytical tools to optimize workflow and enhance data analysis capabilities. Completed a data science and analytics program led by industry leaders. Former insurance agent with experience in the financial industry and distribution.

The Cal State Long Beach Data Science and Analytics program has a focus on applications like Excel, Python, SQL and Tableau in the context of the data analytics process and business intelligence.

EDUCATION

California State University, Long Beach, CA January 2022-October 2022

Data Science & Analytics Certificate

Coursework: SQL and Databases, Data Storytelling, Business Intelligence, Python Programming, Machine Learning

Asian Institute of Management, Philippines April 1998-March 1999

Master in Management

University of the Philippines June 1984-April 1988

AB, Psychology

SKILLS PROFILE

Programming Languages: Python, SQL

Tools: Tableau, Excel, Google Colab, Jupyter notebooks, MySQL Workbench

Language: Tagalog (Fluent)

Analytics: Summary Statistics, Linear and Logistical Regression, Data Modeling, Data Visualization, Time-Series Analysis

Relevant Skills and Knowledge: Excel Data Analysis, Data Storytelling, Visualizations and Storyboarding, Presentation and Collaborations, Wrangling, Analysis of Variance, Sampling Techniques, Stored Procedures, SQL Query Optimization, ETL and Data Pipelines, Dashboarding, Supervised and Unsupervised Machine Learning, Classification and Clustering

PROJECT HIGHLIGHT

Project: Visual Communication Dashboard The Bird Refuge Tourism Project https://miro.com/app/board/o9J_knXqgoc=/?share_link_id=963*********

The project was carried out in three parts:

Created a final data set using MySQL Work Bench;

Proceeded with Data Wrangling using Python; and,

delivered three dashboards catering to distinct tourism segments using Tableau.

The three dashboards were uploaded to Miro.com for presentation.

Project: Business Intelligence Difficult Sports Tableau Public

The project would yield an interactive dashboard that communicates the most difficult sports according to dimensions agreed upon by experts in the field.

Utilizing publicly available dataset from ESPN. The task was to do data exploration using Excel;

Plan out the dashboard by asking the right questions (i.e. Who, What, etc.).

The dashboard was built using Tableau and was presented to a peer for improvements before the final presentation. The link is found above.

PROFESSIONAL EXPERIENCE

Insurance Agent, Bankers Life – September 2016 to August 2021

Long Beach, CA

Consultative selling and after sales service;

Life insurance, health insurance and annuity

Focus on retirement solutions: Retirement Care, Final Expenses, Retirement Income, Health Expenses

Account Manager, Professional Platinum International Inc. – March 2004 to July 2014

Developed collection policies and procedures which reduced ageing by 60%;

Interacted with the customer to continue using our products;

Collaborated with the president to determine training topics and marketing materials for salespeople; Complemented sales training by improving marketing materials and presentations;

Created and curated the monthly company newsletter which contained sales tips, product knowledge and awardees;

Processed orders;

Recruited and interviewed new sales representatives.

Contact this candidate