Lyric Melendez
Columbus
Summary
Results-oriented Senior Tech Risks & Controls Associate with expertise in data analysis, Python automation, and Tableau reporting. Possess hands-on experience in troubleshooting complex issues and delivering efficient solutions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Tech Risks & Controls Associate
JPMorgan Chase
Columbus
08.2022 - Current
- Developed LLM-based prompt solution that automated identification and redaction of Level 3 sensitive information, reducing manual review time by 80%.
- Streamlined analysis and reporting of regulatory citations, enabling efficient tracking for compliance submissions across 10+ business units.
- Designed Python and Alteryx automation solutions for reporting processes, cutting manual effort by 60% and accelerating delivery timelines.
- Built and maintained over 10 Tableau and Alteryx dashboards to enhance data-driven decision-making for senior leadership.
- Led multiple deliverables, including onboarding and mentoring new team members while participating in firm-wide DEI projects.
- Completed formal AI training through Oxford Education and pursued upskilling in emerging technologies and prompt engineering.
- Contributed to innovation working groups focused on risk and controls automation to drive process improvements.
- Enhanced compliance for over 50 stakeholders through effective reporting solutions that prioritized accuracy.
Senior Business Intelligence Analyst
PDI Software
Chicago
08.2021 - 08.2022
- Managed relationship with largest client, PepsiCo, as dedicated BI analyst.
- Conducted seven ad-hoc analyses for PepsiCo beverage category managers to identify market trends.
- Delivered competitive pricing analysis for Frito-Lay to Strategy & Insights Revenue Growth Management team.
- Collaborated with executive leaders on Offers & Insights Extended Leadership Team to drive strategic initiatives.
Business Intelligence Analyst
PDI Software
Chicago
08.2020 - 08.2021
- Provided analytical insights from convenience retailer and CPG client data using SQL, GCP BigQuery, and BI tools.
- Led integration of first Tableau dashboards into Insights Cloud services by developing custom reporting dashboards from AWS Redshift.
- Onboarded and trained five new clients on Insights Cloud software platform, enhancing user engagement.
- Collaborated with operational, engineering, and product teams to ensure positive client feedback through data integrity and user experience optimization.
Education
Bachelor of Arts - Strategic Communications & Business Analytics
Miami University
Oxford, Ohio, OH05-2020
Skills
- Data Analysis
- Python
- Tableau
- Alteryx
- Regulatory Compliance
- Business Intelligence
- GCP BigQuery
- SQL
- Jupyter Notebook
- Python
- R
- Power BI
- Data Visualization
- Machine Learning
- Prompt Engineering
Certification
AWS Cloud Practitioner
Timeline
Senior Tech Risks & Controls Associate
JPMorgan Chase
08.2022 - Current
Senior Business Intelligence Analyst
PDI Software
08.2021 - 08.2022
Business Intelligence Analyst
PDI Software
08.2020 - 08.2021
Bachelor of Arts - Strategic Communications & Business Analytics
Miami University