Jose Franco | Data Analyst

Jose Franco

Data Analyst

Based in El Salvador

About

I am a Data Analyst with over 3 years of experience specializing in Real Estate and Sales data. Recently, I earned my Google Data Analytics Professional Certificate and am currently pursuing certification as a Microsoft Power BI Data Analyst.

Skills

Projects

Power BI Sales Dashboard

The main idea behind the project is to showcase a sales dashboard for a company. This dashboard helps answering questions like: top product (revenue), top client, sales vrs marketing budget, top location, among others.

COVID-19 Tableau Dashboard

The purpose of this project is to analyze historical data for COVID-19 infections since 2020. This project's dataset comes from ourworldindata.org. You can get insights on total deaths vrs total infections, infected population by country and infected population percentage forecast.

Cleaning and Manipulating Data in SQL

The purpose of this project is to showcase some data cleaning skills for large data sets: finding null values, creating alter tables, splitting addresses, changing date formats, removing duplicates. The data set was obtained from another data analyst, and it contains housing data from Tennessee.

Experience

2016-2019

Data Analyst at First American Corporation

Led the formulation and execution of data analytics strategies aligned with business objectives. Delivered insights and recommendations to senior leadership by examining customer behavior in real estate acquisitions across the USA. Conducted analysis of sales trends and offered recommendations for enhancing the performance of two SaaS products marketed by First American.

Education

2010-2015

Bachelor of Science in Industrial Engineering at Central American University, El Salvador

Acquired advanced knowledge in Algebra, Probability and Statistics, Calculus, Differential Equations, Numerical Methods, among others. Critical thinking and problem solving. Business Acumen and Communication Skills.

2017-2019

Master's in Logistics and Operations at Franklin University, Ohio

Acquired skills in Data Collection and Management, Descriptive and Predictive Analytics. Supply Chain and Operations Analytics, Simulation Modeling and Business Intelligence Tools.

2022

Azure Administrator Associate at Microsoft

Acquired knowledge in Cloud Services, Storage Accounts, Networking, Virtual Machines, Network Security Groups, Data Lake, among others. Credential ID CD2FEBA0FEA1BECA

2024

Data Analytics Professional Certificate at Google

Acquired proficiency using analytical & viz tools like: Google Sheets, SQL, R, Tableau, Google BigQuery. Verification link: https://coursera.org/share/5870acaa091f6fbdbb220ec6519800c1