Krystofer Hernandez
Des Plaines,IL
Summary
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 implementations (JSON, Python, etc.), Business Intelligence Dashboard Creation (Microsoft Power BI, IBM Cognos Analytics, Tableau, and Looker Studio), Process Automation, Segmentation, Data Forecasting, and Social/Digital Media Analytics. Deadline-driven, detail-oriented, and successful at thriving in high-pressure environments. Bilingual and fluent in Spanish, offering solid comprehension of cultural diversity and integration of multicultural values.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Marketing Analyst |
Bridge Legal
Chicago, IL
04.2023 - Current
- 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 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
Database Marketing Analyst |
Rivers Casino
Des Plaines, IL
05.2021 - 04.2023
- 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 Marketing Analyst |
Encompass Foundations
Chicago, IL
02.2017 - 05.2021
- 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
Marketing Representative |
UIC Liautaud Graduate School of Business
Chicago, IL
05.2020 - 04.2021
- 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 Tutor |
University of Illinois at Chicago
Chicago, IL
08.2016 - 05.2021
- 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.
Mathematics Educator |
Chegg Inc
Chicago, IL
08.2017 - 01.2021
- 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
Education
Master of Science - Marketing
University of Illinois At Chicago
Chicago, IL05.2021
Bachelor of Science - Mathematics
University of Illinois At Chicago
Chicago, IL05.2020
Skills
- High proficiency and extensive experience in using SQL, MySQL, SQLite, PostgreSQL, Oracle SQL, SQL Server and MS Access
- Experience using Python and JSON
- Expert command of Enterprise Data Warehouse platforms Snowflake and Google Big Query
- Advanced proficiency in using Google Analytics and Foundry
- Extensive experience using SAS Statistical Software
- Thorough comprehension of SPSS, Minitab, and JMP
- Proven experience in creating, modifying, and automating dashboards in Business Intelligence Platform Tableau, Microsoft Power BI, IBM Cognos Analytics, AWS QuickSight, and Looker Studio
- In-depth knowledge of data connections and automation tools like Analytics Canvas, Supermetrics, Apache Spark and Zapier
- Expertise in Insight Creation from Data
- Complex understanding of Microsoft Office products in conjunction to the analytical software stated above
Certification
- Structured Query Language (SQL)
- Google Analytics
- Content Marketing
- Marketing Analytics
- Machine Learning
- Personal Branding
- Cloud Identity
- Mathematical Data Science
Accomplishments
- UIC President's Award Program (PAP) Scholar
- Dean’s List (Fall 2016, Spring 2017, Fall 2018, Fall 2019, Spring 2019, Spring 2020)
- SACNAS Scholarship Recipient
- UIC's Salute to Academic Achievement Recipient
- Township District 214 Award
Professional Affiliations
- UNICEF Chapter Member (UIC)
- Phi Kappa Phi Honorary Member
- SACNAS (Society for Advancement of Chicanos/Hispanics and Native Americans in Science) Member
- L@S GANAS (Latinos Gaining Access to Networks for Advancement in Science) Research Fellow/Mentor
Projects
Grand Opening: University Village Starbucks Jan 2021 – May 2021
- Created IMC Strategy report/presentation (with AIDA model) alongside the Starbucks marketing team
- Launched real surveys using Qualtrics and analyzed data using Tableau and IBM Cognos Analytics
O’Shea Doors and Trim Aug 2020 - Dec 2020
- Analyzed data to determine problems in company’s marketing strategy
- Marketing recommendations/report was given which resulted in an improved marketing campaign for the company
Project Mask Up Mar 2020 – May 2021
- Led an Encompass Foundations project providing medical masks to hospitals
Timeline
Marketing Analyst |
Bridge Legal
04.2023 - Current
Database Marketing Analyst |
Rivers Casino
05.2021 - 04.2023
Marketing Representative |
UIC Liautaud Graduate School of Business
05.2020 - 04.2021
Mathematics Educator |
Chegg Inc
08.2017 - 01.2021
Junior Marketing Analyst |
Encompass Foundations
02.2017 - 05.2021
Mathematics Tutor |
University of Illinois at Chicago
08.2016 - 05.2021
Master of Science - Marketing
University of Illinois At Chicago
Bachelor of Science - Mathematics
University of Illinois At Chicago
Similar Profiles
Cameron ApplewhiteCameron Applewhite
Intake Specialist at Bridge LegalIntake Specialist at Bridge Legal
Ashleigh ShortAshleigh Short
Intake Specialist at Bridge LegalIntake Specialist at Bridge Legal
KAIT HANSONKAIT HANSON
Director of Sales Development at Bridge LegalDirector of Sales Development at Bridge Legal
Dina NAIKPAIDina NAIKPAI
Head of Estimation Department at Administrative Office of PresidentHead of Estimation Department at Administrative Office of President
Marie LapotrieMarie Lapotrie
Front Office Agent at WFSFront Office Agent at WFS