Projects 📊📈

Here are some of the dashboards, reporting tools, and analysis projects I’ve built. My work focuses on turning complex business data into clear insights that help leaders understand performance, identify risks, and take action.

Executive Sales & Inventory Dashboard

Dashboard link will be added here.

Power BI Embed Placeholder

Leadership-facing dashboard built to monitor sales performance, inventory risk, product trends, and store-level execution. Designed to help teams quickly identify growth opportunities, declining trends, and areas requiring follow-up.

Image Preview Placeholder

Store Visit & Resource Allocation Analysis

Dashboard link will be added here.

Power BI Embed Placeholder

Analysis designed to evaluate store visit activity, sales performance, and route effectiveness. The goal was to help leadership understand whether field activity was driving measurable business value and where resources should be prioritized.

Image Preview Placeholder

Pricing & Business Performance Analysis

Dashboard link will be added here.

Power BI Embed Placeholder

Business analysis used to evaluate pricing strategy, product velocity, sales trends, and break-even performance. Built to help leadership compare margin impact against sales volume before making pricing decisions.

Image Preview Placeholder

More projects: github.com/Pedraza57

Experience

Data Analyst | Max Distributing

01/2025 – Present

Improve leadership visibility into sales performance, inventory risk, product trends, and store execution by developing dashboards and recurring reporting used to monitor business performance and prioritize action.

Support sales, operations, finance, and executive stakeholders by analyzing customer, region, product, and business-unit performance to identify growth opportunities, declining trends, and accounts requiring follow-up.

Turn complex sales, inventory, pricing, and operational findings into clear executive summaries that explain what changed, why it matters, and where action is needed.

Senior Analyst | QVC

12/2022 – 12/2024

Analyzed supply chain, inventory, merchandising, and operational data to identify trends, process gaps, and opportunities to improve planning, fulfillment, and business performance.

Developed a predictive model using historical shipping and order patterns to help the auditing team prepare for recurring customer orders and reduce fulfillment delays.

Built reporting outputs that helped leadership and cross-functional teams understand operational performance, demand trends, inventory movement, and fulfillment issues.

Inventory Analyst | DSV Solutions

03/2020 – 12/2022

Analyzed warehouse, inventory, shipment, and order data to identify operational issues affecting fulfillment timing, shipment readiness, and customer satisfaction.

Built operational reporting that improved visibility into inventory availability, warehouse execution, and process bottlenecks impacting service performance.

Partnered with logistics and warehouse leaders to translate data findings into process improvements that supported better planning, execution, and delivery performance.

Skills

Analytics & Reporting: Sales Analysis, Inventory Analysis, KPI Reporting, Trend Analysis, Variance Analysis, Data Validation, Executive Reporting

Business Intelligence: Power BI, Dashboard Development, Scorecards, Data Storytelling, Leadership Dashboards, Visual Analytics

Technical Tools: SQL, Excel, Python, Power Automate, MySQL, ODBC, Data Modeling

Business Focus: Retail Analytics, Distribution, Logistics, Supply Chain, Operations, Process Improvement

Education

Master of Science in Data Analytics
Capella University | Expected 02/2027

Bachelor of Science in Business Administration
Capella University

AWS Academy
Cloud Computing AWS | Cloud Architecting AWS | Cloud Developing AWS