Writing
Ernesto Gonzales
Data Analyst
San Diego,CA
Summary
Bilingual data analyst with 6+ years of analytics experience. Proficient in Power BI, Tableau, Python, SQL, and SharePoint administration. Recognized for attention to detail and expertise in data modeling, dashboards, and business needs analysis. Proven ability to understand customer requirements and transform them into actionable project plans. Committed and inquisitive professional with a strong interest in Artificial Intelligence and Machine Learning Engineering.
Overview
10
10
years of professional experience
3
3
years of post-secondary education
2
2
Certifications
1
1
Language
Work History
IT Analyst
Casa Familiar, Inc.
San Diego, CA
09.2024 - Current
- Administering and regulating OneDrive and SharePoint to ensure secure and efficient document collaboration and storage.
- Developing and implementing standard operating procedures for IT systems and tools.
- Generating reports to analyze system performance.
- Leading the implementation of new IT systems, ensuring smooth integration and staff training.
- Collaborating with internal teams to identify and improve IT processes.
- Proposing and implementing solutions to optimize system efficiency using as a Salesforce Administrator.
- Improved user experience, monitoring feedback and making necessary adjustments to software applications.
Ethics Analyst
Sempra Headquarters
San Diego, California
08.2023 - 03.2024
- Developed SharePoint custom solutions for the department's internal and company-facing SharePoint sites, leading to an 80% increase in user satisfaction, and site visibility.
- Led dashboard projects using Power BI, SQL, and Excel to increase data analysis speed by 30% within 3 months, leading to informed business and improved data decision-making.
- Improved data visualizations by creating custom DAX calculations for ad-hoc reports, resulting in a 20% increase in KPI accuracy.
- Translated 50+ documents into Spanish, enabling effective communication with Mexico Headquarters and contributing to successful cross-cultural daily collaboration.
- Optimized investment reporting precision by 60% through data validation in Excel and Power BI, leading to efficient budget allocation for legal matters in 6 months.
Information Technology Associate
San Diego Gas & Electric
San Diego, CA
01.2022 - 08.2023
- Optimized investment reporting precision by 60% through data validation in Excel and Power BI, leading to efficient budget allocation for legal matters in 6 months.
- Developed SharePoint site, improving document repositories, and custom solutions, leading to a 50% increase in overall system and documentation efficiency.
- Administered and regulated the use of OneDrive and SharePoint, ensuring efficient document collaboration and storage for the organization.
- Improved the audit department's analytical capabilities by 50% by creating a data literacy course, resulting in insightful data analysis in 3 months using Power BI.
Youth Support Partner
San Diego Youth Services
San Diego, California
11.2019 - 01.2021
- Utilized web-based applications to provide case management for client reporting, history and record updates, and case follow-up for an average of 15 rotating cases.
- Facilitated access to housing, education, legal resources, and health insurance for five recurrent clients, contributing to their overall well-being and stability.
Tutor II
Southwestern Community College District
Chula Vista , CA
12.2014 - 11.2019
- Aided thirty-two weekly students on average of all skill levels with excelling statistics for psychology.
- Instructed two to three small groups of struggling students in key subject concepts daily.
- Motivated students towards learning and studying to build self-confidence and reduce fear of failure.
Research Assistant II
South Bay Latino Research Center
Chula Vista, California
06.2017 - 10.2017
- Evaluated and determined the suitability of an average of 30 potential subjects monthly for active studies, improving the accuracy of subject selection for research projects.
- Screened up to 7 participants daily, administering relevant tests and surveys, resulting in accurate data collection and analysis to support IT database system enhancements.
Education
Master of Science - Data Analytics
Western Governors University
Millcreek, UT 09.2023 - 09.2024
Bachelor of Arts - Applied Psychology
San Diego State University
San Diego, CA 09.2017 - 05.2019
Skills
Analytical Thinking
Attention to Detail
Customer Service
Dashboard Development
Database Management
Data Cleaning
Data Literacy
Data Mining
Data Modeling
DAX
Exploratory Data Analysis
Governance Risk and Compliance
Machine Learning
Microsoft Office 365
PostgreSQL
Power BI
Python
SharePoint Administration
SQL Server Management Studio
Tableau Desktop
Salesforce
Azure Administrator
Microsoft Entra Administrator
Microsoft Exchange Administrator
IT Helpdesk Support
VoIP Administrator
Cybersecurity
Business Intelligence
Data extraction
IT Project Management
Projects
Machine Learning Algorithm Using Random Forest Regression
Created a machine learning algorithm using mobile food order delivery data to identify features impacting delivery times. Utilized data preparation, feature engineering, modeling, and analysis in Python, achieving a model accuracy score of over 95%. The algorithm found four features that impacted delivery time.
Data Mining With K-Means Clustering
Implemented an unsupervised machine learning algorithm (K-Means) in Python to identify patterns in hospital stay lengths based on patient income. Conducted thorough data preparation, exploratory data analysis, and visualized results. The findings laid the groundwork for predictive modeling, aiding data-driven decision-making in a healthcare resource allocation context.
Certification
Data+, CompTIA, 06/01/23
Interests
Reading
Audio Mixing and Mastering
Timeline
IT Analyst
Casa Familiar, Inc.
09.2024 - Current
Master of Science - Data Analytics
Western Governors University
09.2023 - 09.2024
Ethics Analyst
Sempra Headquarters
08.2023 - 03.2024
Information Technology Associate
San Diego Gas & Electric
01.2022 - 08.2023
Youth Support Partner
San Diego Youth Services
11.2019 - 01.2021
Bachelor of Arts - Applied Psychology
San Diego State University
09.2017 - 05.2019
Research Assistant II
South Bay Latino Research Center
06.2017 - 10.2017
Tutor II
Southwestern Community College District
12.2014 - 11.2019
Similar Profiles
ANAID GALINDOANAID GALINDO
Staff Accountant/Grants Accountant at Casa FamiliarStaff Accountant/Grants Accountant at Casa Familiar
JESSIE AGUILARJESSIE AGUILAR
MAINTENANCE at CASA FAMILIARMAINTENANCE at CASA FAMILIAR
Jose Martinez CovarrubiasJose Martinez Covarrubias
Pet Sitter at FamiliarPet Sitter at Familiar