Summary
Overview
Work History
Education
Skills
Timeline
Generic

Lyric Melendez

CHICAGO,IL

Summary

Data-driven professional with a strong background in Governance, Risk & Compliance, now seeking to apply expertise in Data Analytics within the field of Psychology. With experience in automation, data mining, and advanced analytics, I aim to contribute to research and decision-making in psychological studies. Skilled in extracting meaningful insights from data to inform behavioral and psychological research, and motivated to leverage technology to improve mental health and well-being.

Overview

4
4
years of professional experience

Work History

Tech Risk & Controls Senior Associate

JPMorgan Chase & Co
08.2022 - Current
  • Automated comprehensive risk assessments to identify, evaluate, and mitigate technology risks across the organization by leveraging advanced analytics tools and scripting languages.
  • Collaborated with 14 business units to integrate automated controls into new and existing systems, improving the security posture and operational efficiency.
  • Utilized metrics and KPIs from automated analysis to measure the effectiveness of controls, driving continuous improvement and eliminating 75% of manual processes.
  • Developed 4 Tableau dashboards to track control and risk metrics, enabling the control management team to close 7 audit issues.
  • Created 3 Python automation scripts for issue management and reporting, saving 10 hours per month in stakeholder efforts.
  • Implemented email automation solutions reaching 500+ users, reducing task durations by 11 months.

Senior Business Intelligence Analyst

PDI Software
09.2021 - 08.2022
  • Managed the relationship with PepsiCo, the largest client in the product’s history, by delivering 7 advanced ad-hoc analyses that helped identify market trends and promotional opportunities.
  • Provided competitive pricing analysis for PepsiCo’s Strategy & Insights team, analyzing dayparts, affinities, trip velocities, and basket sizes.
  • Led the integration of Tableau dashboards into the Insights Cloud platform, creating custom client reporting tools from AWS Redshift to analyze category-level convenience store data.
  • Worked closely with cross-functional teams to ensure data integrity and optimized user experiences, resulting in high client satisfaction.

Business Intelligence Analyst

PDI Software
08.2020 - 09.2021
  • Provided promotional sales and customer insights through SQL, GCP BigQuery, and BI tools for 12 CPG clients.

Education

Bachelor of Arts - Strategic Communications & Business Analytics

Miami University
Oxford, OH
05-2020

Skills

  • Technical Skills: SQL, R, Python, Tableau, SPSS, Alteryx, Data Mining, Machine Learning, Data Visualization, Google Analytics, Power BI, Jupyter Notebooks, Statistical Analysis, Behavioral Data Analysis
  • Certifications: AWS Certified Cloud Practitioner
  • Soft Skills: Analytical Thinking, Research Methodologies, Problem Solving, Cross-Functional Collaboration, Data Interpretation for Behavioral Insights, Client Platform Training

Timeline

Tech Risk & Controls Senior Associate

JPMorgan Chase & Co
08.2022 - Current

Senior Business Intelligence Analyst

PDI Software
09.2021 - 08.2022

Business Intelligence Analyst

PDI Software
08.2020 - 09.2021

Bachelor of Arts - Strategic Communications & Business Analytics

Miami University

Similar Profiles

CREATE PROFILE
Lyric Melendez