Krystofer Hernandez

Krystofer Hernandez

Data Analyst
United States of America
English, Spanish

نبذة عني

Experienced Data Analyst with demonstrated knowledge of Internal and External Database Architecture, Multi-Point Data Connections, Complex Data Manipulations and Scrubbing, Advanced SQL Querying with coded language imple…

الخبرة

Data Analyst

Bridge Legal
Apr 2023 - حتى الآن · 3 سنوات 2 أشهر

- Develop a previously nonexistent command center that is the basis of all
reporting and decision-making for Bridge Legal in its entirety
- Write and optimize large SQL queries using Amazon Redshift for faster run
times and minimize the risk of database overloads
- Analyze and maintain data reporting, locate gaps that contribute to poor metric
performance, collaborate with leadership to improve KPI's
- Intercommunicate with a tech team located in China to build connection
pathways for data flow and logic where needed
- Create, maintain, and automate internal campaign-specific dashboards using
Looker Studio that provide insights for split-second decision making
- Dashboard creation for the following departments: Social and Digital Media,
TV/Radio, Call Center (Internal and External KPI's), Client-Facing Analytics
and Affiliate Marketing
- Conduct in-depth KPI analysis and create presentations for board of directors
meetings, conferences, and stakeholders

Data Analyst

Bridge Legal, Chicago, IL
Apr 2023 - حتى الآن · 3 سنوات 3 أشهر

Develop a previously nonexistent command center that is the basis of all reporting and decision making for Bridge Legal in its entirety
Write and optimize large SQL queries using Amazon Redshift for faster run times and minimize the risk of database overloads
Analyze and maintain data reporting, locate gaps that contribute to poor metric performance, collaborate with leadership to improve KPI's
Intercommunicate with a tech team located in China to build connection pathways for data flow and logic where needed
Create, maintain, and automate internal campaign specific dashboards using Looker Studio that provide insights for split-second decision making
Dashboard creation for the following departments: Social and Digital Media, TV/Radio, Call Center (Internal and External KPI's), Client-Facing Analytics and Affiliate Marketing
Conduct in-depth KPI analysis and create presentations for board of directors meetings, conferences, and stakeholders

Marketing Data Analyst I

Rivers Casino, Des Plaines, IL
May 2021 - Apr 2023 · 1 سنة 11 أشهر

Managed and trained 3 marketing analysts on basic, intermediate, and advanced tasks to ensure overall understanding and productivity
Ran production adjacent to a team of 3 marketing analysts for two Rivers Casino properties: Des Plaines and Schenectady
Used SQL, Excel, Access, and Snowflake to manipulate patron data based on researched based criteria
Used SAS software to analyze trends within our database structure and provide insights and reports to the VP of Marketing Analytics
Used Foundry and Snowflake to manage casino slot machine data and analytics
Evaluated data that helped in assessing slot machine operational availability failures and malfunctions
Used Tableau to create, maintain, and monitor dashboards that provided key insights to influence informed decision making
Streamlined communication between different departments to ensure efficiency and completion of interdepartmental tasks

Junior Data Analyst

Encompass Foundations, Chicago, IL
Feb 2017 - May 2021 · 4 سنوات 3 أشهر

Constructed complex SQL, Python, and JSON scripts to extract insights from two large database structures: AWS and Google Cloud
Used Microsoft Power BI and IBM Cognos Analytics to create personalized dashboards that kept track of important business KPIs and automated complex tasks
Analyzed internal data components in conjunction with social media platform data to create campaign specific performance reports
Maintained and supervised the integrity, architecture, and validity of our internal database structures making sure all touchpoints were working efficiently
Collaborated with software developers on designing efficient database structures that met application requirements

Mathematics Tutor

University of Illinois at Chicago, Chicago, IL
Aug 2016 - May 2021 · 4 سنوات 9 أشهر

Assisted students in acquiring a better understanding of weak comprehension within a subject or a subject as a whole
Planned and administered instruction to middle school, high school, and college students of various multi-cultural backgrounds

Marketing Representative

UIC Liautaud Graduate School of Business, Chicago, IL
May 2020 - Apr 2021 · 11 أشهر

Sponsored academic and social activities for graduate students
Subsidized graduate students who traveled to present original work at professional meetings and conferences
Considered issues of concern that affected graduate students and promoted the interests of the graduating class through contact with the University of Illinois at Chicago (UIC) administration
Presented at Marketing Conferences and meetings with researchers and alumni to discuss new investigations and findings

Mathematics Educator

Chegg Inc, Chicago, IL
Aug 2017 - Jan 2021 · 3 سنوات 5 أشهر

Provided private instruction to individuals and small groups of students to improve current academic performance and prepare for academic assessment
Provided individual personalized lessons online, through Chegg, to students in a vast array of subject categories
Main focus: Mathematics (applied, theoretical, and proof-based) and Microsoft Excel
Taught in English and Spanish

المهارات

التحليلات إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) SQL MySQL SQLite PostgreSQL Oracle SQL SQL Server MS Excel MS Access Python JSON Amazon Redshift Snowflake Google BigQuery Google Cloud AWS Microsoft Power BI IBM Cognos Analytics Tableau Looker Studio Google Analytics Foundry SAS SPSS Minitab JMP Analytics Canvas Supermetrics Apache Spark Zapier Qualtrics Microsoft Office Data Modeling Database Architecture Data Manipulation Data Scrubbing Business Intelligence Dashboard Creation Process Automation Segmentation Data Forecasting Marketing Analytics Social Media Analytics Leadership Training Communication Detail-oriented Deadline-driven
الإبلاغ عن هذا الملف الشخصي؟