Bakhrom Abdurakhmonov

Business Data Analyst | CPG Retail & Sales Data

Summary

Financial Business Analyst with 5 years in CPG, turning retailer, syndicated, and ERP data into decisions for sales, category, and finance teams. Built 1st Phorm's first centralized retail data hub in Google BigQuery, own product master data across SPINS, Circana, and NetSuite, and automate recurring reporting with Python, Tableau, and Looker Studio.

Experience

Financial Business Analyst

Nov 2021 – Present

1st Phorm International LLC

St. Louis, MO

  • Built a centralized retail data hub in Google BigQuery, pulling in-store sales and inventory data via API from Target, Walmart, and other retailers, covering ~3,000 stores and 12 SKUs.
  • Connected the hub to a Google Firebase dashboard used by 8+ KAMs and category managers to track velocity, inventory, and low-stock stores; replaced 3-5 manual reports and flagged 20+ stores missing product.
  • Built the financial model behind the annual budget and forecast, combining new product launches, planned marketing campaigns, new customer pipeline, existing account trends, and margin impact from upcoming cost changes.
  • Own product performance master data across SPINS, Circana, and NetSuite/Oracle, and analyze it to surface cross-channel trends that shape product placement, marketing strategy, and retail expansion.
  • Built Tableau dashboards, including a sales heat map and distribution map spanning 30+ states, that closed coverage gaps, prevented duplicate distributor signings, and supported retailer pitches.
  • Developed NetSuite, Looker Studio, and Excel dashboards to forecast product demand and track SKU and customer performance, informing rebate and inventory decisions.
  • Use Enterprise AI to troubleshoot data issues, dig into datasets, and catch patterns and insights manual analysis would miss; used it to improve existing dashboards and internal tools.
  • Automated weekly, monthly, and quarterly reporting with Python (pandas, NumPy) and Excel macros, saving 5-10 hours per week.
  • Ran gap analysis to find tools the team was missing, then sourced or built them, including a CRM tool and a product/customer health dashboard.
  • Ran data quality audits and root cause analysis on syndicated data to improve reporting accuracy; trained 3 colleagues on 1WorldSync, retailer portals, and automation.

Esports Data Manager (Part-time, student role)

Aug 2021 – May 2024

Maryville University

St. Louis, MO

  • Consolidated legacy spreadsheets into a centralized, schema-driven database in Google Sheets.
  • Developed an ETL-style pipeline that standardized raw entries into a master data table powering real-time dashboards for player performance and team strategy.
  • Built a Sheets and Python data-aggregation tool pulling performance metrics from Discord, tournament APIs, and Twitch so leadership could monitor trends and adjust strategy.

Skills

Data & Pipelines
Google BigQuery, REST API integrations, ETL, SQL, Python (pandas, NumPy), R, Java, Google Sheets
Visualization & Reporting
Tableau, Looker Studio, Power BI, Google Firebase dashboards, Advanced Excel (macros, modeling)
CPG & Retail Data
SPINS, Circana, Nielsen, VIP, 1WorldSync, Syndigo, Retailer portals (Walmart, Target, Hy-Vee, Albertsons, KeHE)
Systems & Finance
NetSuite ERP (advanced), Oracle Cloud (NSPB), Airtable, Financial modeling, Budgeting & forecasting, Demand forecasting, Enterprise AI automation, Custom tools & dashboards

Education

Bachelor of Science, Business Administration (Finance minor)

2020 – 2024

Maryville University of St. Louis

St. Louis, MO

Summa Cum Laude, GPA 3.9