Learn Data Skills
Beta
Ernesto Gonzales

Ernesto Gonzales

IT Analyst

Non-Profit Organization | San Diego, CA

Technologies

My Portfolio Highlights

My New Github

Predictive Models Building - GitHub

My New Github

Predictive Models Building - GitHub

Mixing variables and algorithms to create insights.

My Work

Take a look at my latest work.

DataLab

Salaries and Workforce Distribution Analysis - Level 1

article

Building a RESTful API for Sentiment Analysis

Python
github

Predictive Models Building - GitHub

DataLab

Salaries and Workforce Distribution Analysis - Level 1

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

CompTIA Data+

UC San Diego Extension Business Intelligence Analysis

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Casa Familiar, Inc. | Sep 2024 - Present

IT Analyst

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.
Show More

Sempra | Aug 2023 - Mar 2024

Ethics Analyst

Supported the Ethics & Compliance Helpline, managing case reviews, assignments, and progress tracking. Analyzed and transformed data for reports and presentations using Power BI, Excel, and Microsoft SQL Server Management Studio. Developed Power BI dashboards on trends and statistics for stakeholders. Supported a web-based case management system, collaborating with third- party vendors. Conducted first-level review of investigation reports, ensuring accuracy and thoroughness in English and Spanish. Provided training and best practice guidance to investigators in Spanish. Acted as a SharePoint Webmaster, providing site maintenance, management, and ad-hoc customizations. Translated several training materials and documentation into Spanish leveraging my bi-cultural background. Acted as an effective live translator for meetings in English and Spanish.

San Diego Gas & Electric | Jan 2023 - Aug 2023

Information Technology Associate | Audit Services | Data Analytics

Provided a detailed access controls project for Power BI using MS Office Suite by researching, documenting, and gathering evidence of all types of access within Power BI by role. Created a table matrix to summarize and illustrate all the available types of access to Power BI from Report Administrator, Member, Contributor and Viewer roles. Explored, tested, and validated current access levels by user roles in Power BI and documenting findings.

San Diego Gas & Electric | Apr 2022 - Jan 2023

Information Technology Associate | Cybersecurity Technology Risk Management

Updated dashboards for upper management using Power BI, SQL, and ERM platform. Provided third party risk management by doing cybersecurity risk assessments and contract reviews. Performed risk analysis using ERM and creating metrics and reports for risk owners.

San Diego Gas & Electric | Jul 2021 - Apr 2022

Information Technology Associate | IT Associate Program

Created documentation for the program to condense knowledge transfers, program tasks, and program planning. Created a SharePoint website for the program, and as a webmaster role created a set-up for navigation and file repository. Collaborated with Program Manager on innovative ideas for the program through data cleansing, wrangling to show historical data of the program.

San Diego Gas & Electric | Jan 2021 - Jul 2021

Information Technology Associate | Technology Investment Optimization

Enhanced, maintained, and refreshed Power BI Financials Report monthly and ad-hoc updates and fixes for stakeholders. Facilitated stakeholder meetings and made the preparation of presentation materials by clients to show to company directors. Collaborated with Accounting, Program Managers and Stakeholders on gathering Accruals for Capital and O&M projects. Facilitated and collected financial data for presentations for company directors and key stakeholders weekly for the purchase review committee using data wrangling and parsing.

San Diego Youth Services | Nov 2019 - Jan 2021

Youth Support Partner

Provided case management using web-based applications for client reporting, history and record updates, and case follow-up for an average of fifteen rotating cases for at-risk youth clients. Supplied educational resources to an average of twelve homeless and at-risk youth on a regular basis both in person and via the phone. Helped find housing, education, legal resources, and health insurance to five recurrent clients in past caseload. Promote positive influence and independent living skills to clients reducing incidence of negative behaviors.

Southwestern Community College District | Dec 2014 - Nov 2019

Psychology Statistics Tutor

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. Helped ten to fifteen students daily with general abilities in learning, studying, and keeping information as well as subject matter material, such as data analysis and statistics.

Southwestern Community College District | Feb 2016 - May 2019

Clerical Assistant II

N/A

South Bay Latino Research Center | Jun 2017 - Oct 2017

Research Assistant II

Screened an average of thirty potential subjects every month to decide suitability for active studies. Managed critical paperwork such as informed consent forms and personal waivers for new participants. Screened up to seven participants per day administering relevant tests and surveys.

California Department of Rehabilitation | Feb 2017 - May 2017

ISP Tutor

Tutored students with psychology statistics and improving writing skills. Supported students in homework assignments, helping find and address specific concerns. Coached students with failing grades and helped raise their grades by two letter grades.

My Education

Take a look at my formal education

Master of Science in Data AnalyticsWestern Governors University | 2024
Business Intelligence Analyst Certificate, Business IntelligenceUC San Diego Extension | 2021
Bachelor of Arts - BA, Applied PsychologySan Diego State University | 2019
Associate of Arts - AA, PsychologySouthwestern Community College District | 2017
Associate of Arts - AA, Liberal Arts and Sciences/Liberal StudiesSouthwestern Community College District | 2015

About Me

Ernesto Gonzales

I’m passionate about working with Power BI and continuously enhancing my Python skills. I’m currently looking to transition into a Data Scientist role.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free