Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Daniel Castilla

San Diego,CA

Summary

Data analyst with both professional and educational experience in
energy, billing, real estate, healthcare, economics, and project management.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Calpine Energy Solutions
01.2022 - Current
  • Monitored and billed electrical usage for California CCAs daily, ensuring thousands of customers were billed on accurate rates and totals
  • Utilized Excel functions and generated macros in order to maximize efficiency when analyzing reports and producing audits
  • Worked with Power BI visualization tools in order to accurately measure data for compliance
  • Wrote scripts in SQL to capture data that was not represented in existing reports
  • Worked in a dynamic team which involved collaboration, trainings, and problem solving

Project Manager

Epic Systems
11.2020 - 09.2021
  • Implemented Claims and Remittance application of Epic’s electronic health record software for multiple organizations
  • Developed detailed project plans to monitor and track progress for multiple project phases including build, testing, and going live with our customers.
  • Organized and facilitated meetings both internally and customer-facing with operational leaders, executives, and directors
  • Researched and implemented best practices to translate in-person program design into a virtual format during the pandemic.
  • Assisted analysts with software build by fielding their questions and follow-ups daily
  • Held multiple internal roles such as writing monthly newsletters about the healthcare industry, curating agendas for monthly meetings for new hires, and assisting colleagues in their customer projects.

Real Estate Intern

California Coast Credit Union
06.2019 - 08.2019
  • Worked alongside the Senior Vice President of Real Estate in processing home loan applications. These duties included customer outreach to ensure timely delivery of all required financial information for loan processing.
  • Assigned member files to coworkers for verification of submitted documents and authorization forms
  • At the direction of the executive board, worked with fellow interns to envision and present a future business model for credit unions based on an in depth analysis of industry surveys, interviews, and academic research.

Research Assistant

UC Santa Barbara
03.2019 - 06.2019
  • Worked alongside the Senior Vice President of Real Estate in processing home loan applications. These duties included customer outreach to ensure timely delivery of all required financial information for loan processing.
  • Assigned member files to coworkers for verification of submitted documents and authorization forms
  • At the direction of the executive board, worked with fellow interns to envision and present a future business model for credit unions based on an in depth analysis of industry surveys, interviews, and academic research.

Education

Bachelor of Arts - Economics

UC Santa Barbara
Santa Barbara
03.2020

Skills

  • Data Visualization and Presentations
  • Data Analysis
  • Excel Functions
  • Data Cleaning
  • SQL
  • Analytical Problem Solving
  • Project Management
  • Clear and Concise Communication

Certification

  • Learn SQL Basics for Data Science, University of California, Davis - February 2023
  • Data Analytics, Google - January 2023

Timeline

Data Analyst

Calpine Energy Solutions
01.2022 - Current

Project Manager

Epic Systems
11.2020 - 09.2021

Real Estate Intern

California Coast Credit Union
06.2019 - 08.2019

Research Assistant

UC Santa Barbara
03.2019 - 06.2019

Bachelor of Arts - Economics

UC Santa Barbara
Daniel Castilla