Christian Hernandez

Experience

1. Senior Data Science Analyst

   Silicon Valley Bank

   Feb 2022 — Present · New York, NY, US

   Advanced proficiency in SQL, Tableau, and Excel, utilizing them to perform data cleaning, forecasting, audience segmentation, visualization, process automation, and data analysis - Collaborated with stakeholders to create deep dive analysis that led company to successfully reach at-risk EOY target for a +$750M in client revenue initiative - Developed a modeling and forecasting exercise utilizing Excel forecasting formulas, resulting in company goals of $1.5B in revenue and 900 new clients - Simplified complex SQL Queries involving multiple tables through the use of Joins, Sub-Queries, Common Table Expressions, Partitions, and Aggregations as a way of streamlining data processing and analysis – removing 8hrs of manual effort weekly across multiple teams - Created, maintained, and troubleshooted Tableau dashboard containing company-wide targets and data from 10+ sources – amassing +1K views monthly - Employed Tableau best practices in formulating reports, developing SQL queries and managing 10+ advanced dashboards – improving KPI by 50% YoY by year end - Designed and created advanced analysis and dashboards in Tableau utilizing: actions, calculations, parameters, trendlines, forecasting, LOD expressions, groups, CASE statements and other functions - Wrote and distributed Monthly Performance updates containing insights for facilitating 1,500 Client Referrals spanning from Cross Business Collaboration to an audience of 100+ stakeholders

Education

• The City College of New York

  Bachelor of Arts in English, Minor in Journalism, Pre-medical track, 3.5

  2013 — 2017

• COOP Apprentice

  Data Analytics

  2019 — 2019