☁️ Projects

National Legislative Intelligence Tracker

Designed a Python and SQL-based system that integrates with the LegiScan API to monitor U.S. state-level legislation impacting controlled products (e.g., Kratom, Delta). Delivered automated compliance summaries and alerts, enabling leadership to make rapid, law-informed business decisions—an approach applicable to mission-critical legal and regulatory monitoring.

Strategic Risk Alert Dashboard

Developed an automated Power BI reporting system to detect and visualize sales and inventory anomalies across nationwide retail accounts. Combined transactional data with business unit hierarchies to generate early warnings for market decline, supporting executive situational awareness and operational decision-making.

Max Delivers ☁️

● Engineered a legislation monitoring system using Python, SQL, and the LegiScan API to identify U.S. laws affecting restricted product sales (e.g., Kratom, Delta), aiding legal compliance and strategic planning.

● Developed automated Power BI and Python reporting tools to track sales risk, zero inventory, and underperforming products, enabling proactive sales interventions.

● Built executive dashboards to evaluate regional sales performance, business unit trends, and regulatory impacts, combining multiple datasets via complex SQL joins and Subqueries to deliver insights directly to C-level stakeholders.

QVC ☁️

● Spearheaded the development of an advanced analytics framework using SQL and Python, optimizing data processing by 30% and enhancing predictive analytics capabilities for strategic decision-making.

● Designed and implemented dynamic dashboards and reports in Tableau and Power BI, providing real-time business insights that led to a 20% increase in operational efficiency across multiple departments.

● Developed a predictive model to forecast sales trends, which improved inventory management and reduced overstock by 25%

● Conducted comprehensive trend analysis and market research to identify emerging opportunities, contributing to a 15% revenue increase by influencing product development and marketing strategies.

DSV ☁️

● Analyze large datasets using SQL, Python to identify trends, patterns and insights.

● Automate data cleaning and preprocessing tasks, reducing manual workload by 30%

● Conduct A/B testing to optimize website performance and user experience resulting in a 15% increase in conversion rates.

● Collaborate with cross-functional teams to define project requirements and deliver actionable recommendations.

● Create interactive dashboards and reports using Tableau for stakeholders to visualize key metrics.

github.com/Pedraza57.

Experience

Business Intelligence Analyst| Max Delivers | Remote CA

01/2025 - Present

● Conduct advanced data analysis to support operational strategy, regulatory compliance, and product risk intelligence. Designed and deployed automated systems to track legislative changes affecting controlled products across U.S. states using Python, SQL, and API integrations. Deliver executive-level dashboards and reports that enhance decision-making, monitor national sales trends, and identify potential legal and market exposure.

Senior Analyst | QVC | Hybrid CA

12/2022 - 01/2025

● Led data-driven initiatives to inform executive strategy and optimize business operations across multiple departments. Developed performance dashboards, conducted deep market trend analyses, and managed high-impact analytical projects to identify growth opportunities and operational risks. Ensured data integrity and translated complex datasets into clear, actionable intelligence for stakeholders. Collaborated across teams to improve reporting methodologies, streamline data workflows, and integrate evolving analytical tools for enhanced insight generation.

Data Analyst | DSV | Fontana CA

03/2020 - 12/2022

● Extracted and analyzed large-scale operational data to support strategic planning and performance optimization. Produced detailed reports and visualizations to communicate key findings to leadership, facilitating data-driven decisions. Partnered with cross-functional teams to identify root causes of business challenges and implement solutions that enhanced process efficiency and organizational effectiveness.

Skills

● Python ● SQL ● Advance Excel ● Power BI ● AWS web services ● Data Visualizations ● Communication Skills

Education

● Capella University Masters in Data Analytics (Expected 2027)

● B.S. in Business Administration - Data Analytics concentration

● Data Analytics Professional Certificate - Break into tech

AWS Academy

● Cloud Computing aws

● Cloud Architectingaws

● Cloud Developing aws

● Cloud Operations aws

Elements

Text

This is bold and this is strong. This is italic and this is emphasized. This is superscript text and this is subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.

Heading Level 2

Heading Level 3

Heading Level 4

Heading Level 5
Heading Level 6

Blockquote

Preformatted

i = 0;
while (!deck.isInOrder()) {
	print 'Iteration ' + i;
	deck.shuffle();
	i++;
}

print 'It took ' + i + ' iterations to sort the deck.';