Design and develop analytics solutions for e-commerce businesses, transforming fragmented sales, inventory, and operational data through SQL, Python, BigQuery, and Dataform into reliable dimensional models and BI-ready datasets.

Designed data models integrating 23+ sales, inventory, purchasing, supplier, and product tables into a centralized analytics environment. Migrated e-commerce data to BigQuery and developed SQL transformations to standardize frequently updated operational data into reliable, analysis-ready datasets. Developed SQL and Python workflows to consolidate multi-source data, reducing manual data preparation and reporting activities by more than 50%. Built Power BI dashboards used by a 7-person purchasing team to monitor inventory and support purchasing decisions across 3,000+ SKUs per order. Automated product and supplier data collection using Python, Requests, and BeautifulSoup, reducing product analysis time by 57%, from approximately 7 to 3 minutes.

Integrated 30+ commercial and legal data sources using SQL, flat files, and Power BI to centralize analytics for an operation managing 10,000+ customer accounts monthly. Designed a Balanced Scorecard with 30+ KPIs across three business areas, enabling weekly performance monitoring and earlier identification of operational gaps. Developed analytical data models and Power BI dashboards used by 25+ stakeholders to monitor portfolio recovery, customer contact strategies, and process performance. Shifted performance management from monthly reporting to weekly data-driven reviews, enabling earlier strategy adjustments and corrective actions.

Automated the cleaning and transformation of performance data for 4,300+ employees using Python, Pandas, and NumPy, reducing manual data preparation effort by approximately 80%. Integrated internal employee data with external labor market datasets using SQL and Python to analyze talent supply, job demand, skills, salaries, and employee mobility. Developed analytical models and Power BI dashboards to identify critical professional profiles and support workforce planning, hiring decisions, and retention analysis.

Designed and implemented a supplier performance monitoring system with standardized KPIs to track service levels, delivery compliance, and supply quality. Developed inventory and warehouse analytics dashboards to monitor stock levels, identify occupancy bottlenecks, and support material planning decisions. Analyzed purchase order and supplier data to identify fulfillment issues, improve procurement visibility, and support supply chain planning.