👋 Hi, I'm Ashley Jovel-Lagos

Data Analyst | Business Analyst | Marketing Analyst | Financial Analyst

🚔Law Enforcement Turned Data Analyst
💻 Excel, Tableau, SQL, Python R
📸 Weightlifting, Traveling, Photography
📍 Pontiac, Michigan USA


Technical Skills

  • SQL

  • Excel

  • Tableau

  • Power BI

  • Python

  • R

  • Project Management


Projects

🍔 DoorDash Marketing Project

Excel | Exploratory Data Analysis
◾ Real world-marketing campaign data
◾ Using only Excel for analysis and data visualization
◾ Utilized VLOOKUPS, Pivot Tables, Scatter Plots, & Bar Charts
◾ Provided a comprehensive write up to help the marketing team on their next campaign

.

🏫 Evaluating School Success with Tableau Project

Tableau | Data Visualization
◾ Created dashboard evaluating 1,800 different schools' performance across 100's of features
◾ Used Scatter Plots, KPI's, Bar Plots, & Area charts to show performance differences
◾ Presented dashboard to stakeholders via recorded video

.

💵 Financial Analysis of World Bank Loans

SQL | Exploratory Data Analysis
◾ Data-mined 1.2M real bank transactions to find financial outliers, patterns, & trends
◾ Used SQL clauses such as SELECT, WHERE, FROM, GROUP BY, AVG, MIN/MAX, SUM, AND, etc
◾ Created written report highlighting findings

.

🏥 Analyzing Hospital Data with SQL

SQL| Exploratory Data Analysis
◾ Analyzed what affections hospital stay length in MySQL
◾ Created a histogram using SQL (weird, I know)
◾ Real data from over 101,000 hospital patients

.

🏀 Analyzing NBA Data with Tableau

Tableau | Dashboarding
◾ Analyzed the 2022 NBA season statistics
◾ Created Stacked Bar Charts, Heatmaps, Treemaps & Bubble Charts
◾ Built a Tableau story & shared via written report

.


About Me

👋 Hi, I'm Ashley & welcome to my portfolio! Over the past few years, I've become obsessed with data. I've fallen in love with the ability to take a table of numbers and transform it into meaningful insight. With a background in law enforcement and banking, I bring a unique lens to data analysis—one that’s grounded in real-world problem-solving, a sharp attention to detail, and a passion for uncovering meaningful trends.I'm proficient in analyzing data with:
- Excel
- Tableau
- SQL
- Python
- R
-Power BI
And I'm looking to help a company extract insights from their data. If you'd like to contact me, feel free to email, call or send me a message on LinkedIn. Contact information below👇👇👇☎️Contact Information:
Email : [email protected]
Phone : 248-574-1018

Previous Experience

📊Speech and Client Experience (CX) Analyst
United Wholesale Mortgage (UWM) · September 2025 - Current
◾Analyze large sets of client interaction data to identify trends, improve customer experience, and support data-driven decision-making across departments.
◾Develop and maintain dashboards and automated reports in Excel and SQL to track KPIs and provide insights to leadership on team performance.
◾Collaborate with cross-functional teams to design new metrics, validate reporting accuracy, and implement process improvements based on analytical findings.
💻 Data Analyst
Data Career Jumpstart · Internship · April 2025 - Current
◾ Developed reports and infographics to clearly communicate and break down complex ideas in clear explanations about SQL queries, Python code, and using visual tools like Tableau and Power BI for over 100 students.
◾ Designed a Tableau dashboard after collecting and cleaning data in Excel to help better understand what the Massachusetts public school system is struggling with and how to better improve.
🚔 Crime Analyst | Road Patrol Deputy
Oakland County Sheriff’s Office · January 2023 – September
◾ Conducted risk assessments of 50+ high-risk areas per month, resulting in a 15% reduction in response times and improved resource allocation.
◾ Collected and analyzed data from 100+ incident reports weekly, identifying trends that informed targeted patrol strategies.
◾Interpreted operational data to identify potential threats and emerging crime trends, enabling data-driven decision-making for patrol activities.
💸 Financial Transactions Specialist
Huntington Bank · March 2022 – January 2023
◾ Identified and resolved transaction discrepancies with a 98% accuracy rate, reducing financial errors and improving data quality.
◾ Identified and resolved 10+ transaction discrepancies per week, maintaining data integrity and reducing financial errors by 15%
◾Prepared daily financial summaries and reports for branch management.
🎧 Customer Service Representative
Comerica Bank · July 2021 – March 2022
◾Handled 50–70+ customer inquiries daily, resolving financial service issues with a 95% satisfaction rating, contributing to monthly customer experience KPIs.
◾Identified and flagged potential fraud patterns, reducing risks and protecting client assets through careful account monitor.
◾Assisted with detecting suspicious account activity, contributing to a 20% decrease in fraud-related escalations over a 3-month period.
🚔 Road Patrol Deputy
Oakland County Sheriff’s Office · January 2021 – May 2021
◾Responded to emergency and non-emergency calls, completing detailed reports for 100+ cases per month.
◾Assisted in collecting field data for investigations, contributing to several successful case resolutions.
◾Demonstrated strong observational and reporting skills critical to both officer safety and criminal prosecution.
🚨 Police Officer | Investigator
Detroit Police Department · May 2018 – January 2021
◾Investigated over 200+ criminal cases, gathering and analyzing evidence, witness statements, and reports to identify suspects and support prosecution.
◾Collaborated with multi-agency teams and shared intelligence insights to support data-driven strategies in high-crime areas.
◾Utilized internal databases and digital tools to track suspects, analyze crime locations, and monitor repeat offender activity.
👜 Sales Associate
Coach· July 2017 – May 2018
◾Assisted an average of 50+ customers per shift, identifying needs and recommending products based on trends and preferences, contributing to daily sales goals.
◾Analyzed customer feedback and buying behavior to support merchandising decisions and store layout improvements.
◾Collaborated with team members to streamline store operations, contributing to a 10% increase in overall customer satisfaction scores during peak seasons.