BRYAN PEDRAZA
Laytonville,CA
Summary
Data Analyst / Business Intelligence Analyst with expertise in SQL, Python, Power BI/DAX, and Excel, specializing in turning complex data into insights that drive business performance.
Overview
6
6
years of professional experience
Work History
Business Intelligence Analyst
Max Distributing
01.2025 - Current
- Optimized merchandiser route ROI by linking store-visit activity to subsequent sales (Python, SQL, Excel); surfaced month-over-month KPIs, and partnered with the VP of Sales and Engineering to re-route time and reduce low-impact visits.
- Built a regulatory intelligence pipeline (Python, SQL, LegiScan API) delivering monthly early-warning alerts; mapped regulatory changes to state and product-level sales, briefed the CEO and CFO, and enabled Sales and Compliance to mitigate risk, protect revenue, and plan market responses.
- Standardized weekly sales periods and built executive dashboards (Power BI, DAX) highlighting current vs. previous and dollar and percent change with dynamic, plain-language titles; advised the CEO, CFO, and VP of Sales to make faster, action-focused decisions on promotions, inventory, and regional strategy.
Senior Analyst
QVC
12.2022 - 01.2025
- Built a SQL/Python analytics framework that cut data-processing time 30% and enabled predictive analytics for strategic planning.
- Delivered Power BI/DAX dashboards with real-time KPIs, improving operational efficiency 20% across teams.
- Contributed to a 15% revenue lift by translating market-trend analysis into actionable, data-driven recommendations for senior leadership.
Inventory Analyst
DSV
03.2020 - 12.2022
- Developed and optimized SQL queries/views (joins, CTEs, window functions) to clean and integrate data; automated preprocessing to reduce manual work ~30%.
- Built scheduled and ad-hoc reports and executive dashboards (Excel) delivering weekly KPIs and actionable trend analyses to managers.
- Analyzed inventory levels to maintain optimal stock across multiple locations.
Education
B.S. - Business Administration - Data Analytics concentration
Capella University
Minneapolis, MN09-2025
MBA - Data Analytics
Capella University
Minneapolis, MN04-2027
Skills
- SQL, Python, Power BI
- Microsoft Excel, data visualization
- Stakeholder analysis, predictive modeling
- A/B testing, data governance
Timeline
Business Intelligence Analyst
Max Distributing
01.2025 - Current
Senior Analyst
QVC
12.2022 - 01.2025
Inventory Analyst
DSV
03.2020 - 12.2022
B.S. - Business Administration - Data Analytics concentration
Capella University
MBA - Data Analytics
Capella University
Similar Profiles
Thomas MooreThomas Moore
Sales Representative at Intermountain Distributing - Watkins DistributingSales Representative at Intermountain Distributing - Watkins Distributing
Javier ZelayaJavier Zelaya
District Manager /Team Leader at Browns Distributing & Southern Eagle DistributingDistrict Manager /Team Leader at Browns Distributing & Southern Eagle Distributing
PRASHANT MISRAPRASHANT MISRA
Vice President – Account Growth & NBD at Max Mudra - JV Between The Tribes Group and DDB Mudra From Omnicom (now The Max, a Tribes Group Company)Vice President – Account Growth & NBD at Max Mudra - JV Between The Tribes Group and DDB Mudra From Omnicom (now The Max, a Tribes Group Company)
Sage BaslerSage Basler
Equipment Owner and Operator at Strong Arm ConstructionEquipment Owner and Operator at Strong Arm Construction
Shantil FergusonShantil Ferguson
Director of Finance at Long Valley Health CenterDirector of Finance at Long Valley Health Center