About Me
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…
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.
Experience
Data Analyst
- 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
<p>Develop a previously nonexistent command center that is the basis of all reporting and decision making for Bridge Legal in its entirety<br>
Write and optimize large SQL queries using Amazon Redshift for faster run times and minimize the risk of database overloads<br>
Analyze and maintain data reporting, locate gaps that contribute to poor metric performance, collaborate with leadership to improve KPI's<br>
Intercommunicate with a tech team located in China to build connection pathways for data flow and logic where needed<br>
Create, maintain, and automate internal campaign specific dashboards using Looker Studio that provide insights for split-second decision making<br>
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<br>
Conduct in-depth KPI analysis and create presentations for board of directors meetings, conferences, and stakeholders</p>
Marketing Data Analyst I
<p>Managed and trained 3 marketing analysts on basic, intermediate, and advanced tasks to ensure overall understanding and productivity<br>
Ran production adjacent to a team of 3 marketing analysts for two Rivers Casino properties: Des Plaines and Schenectady<br>
Used SQL, Excel, Access, and Snowflake to manipulate patron data based on researched based criteria<br>
Used SAS software to analyze trends within our database structure and provide insights and reports to the VP of Marketing Analytics<br>
Used Foundry and Snowflake to manage casino slot machine data and analytics<br>
Evaluated data that helped in assessing slot machine operational availability failures and malfunctions<br>
Used Tableau to create, maintain, and monitor dashboards that provided key insights to influence informed decision making<br>
Streamlined communication between different departments to ensure efficiency and completion of interdepartmental tasks</p>
Junior Data Analyst
<p>Constructed complex SQL, Python, and JSON scripts to extract insights from two large database structures: AWS and Google Cloud<br>
Used Microsoft Power BI and IBM Cognos Analytics to create personalized dashboards that kept track of important business KPIs and automated complex tasks<br>
Analyzed internal data components in conjunction with social media platform data to create campaign specific performance reports<br>
Maintained and supervised the integrity, architecture, and validity of our internal database structures making sure all touchpoints were working efficiently<br>
Collaborated with software developers on designing efficient database structures that met application requirements</p>
Mathematics Tutor
<p>Assisted students in acquiring a better understanding of weak comprehension within a subject or a subject as a whole<br>
Planned and administered instruction to middle school, high school, and college students of various multi-cultural backgrounds</p>
Marketing Representative
<p>Sponsored academic and social activities for graduate students<br>
Subsidized graduate students who traveled to present original work at professional meetings and conferences<br>
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<br>
Presented at Marketing Conferences and meetings with researchers and alumni to discuss new investigations and findings</p>
Mathematics Educator
<p>Provided private instruction to individuals and small groups of students to improve current academic performance and prepare for academic assessment<br>
Provided individual personalized lessons online, through Chegg, to students in a vast array of subject categories<br>
Main focus: Mathematics (applied, theoretical, and proof-based) and Microsoft Excel<br>
Taught in English and Spanish</p>