Yaroslav Bukhanovskyi

- Built reporting infrastructure from scratch as first analyst on greenfield energy trading project. - Designed a near-real-time Power BI dashboard consolidating solar generation, curtailment, demand forecasts, and revenue. - Developed ML-based 3-hour-ahead solar generation forecasting pipeline, cutting energy imbalances by 5%. - Automated financial reporting workflows, cutting multi-day manual processes to minutes and eliminating error-prone data handoffs.

- Restored an analytics function absent for 3+ years, architecting a unified Power BI reporting layer across sales, marketing, finance, and support. - Standardized CRM pipelines from the ground up - deduplication, schema cleanup, lead lifecycle structuring. - Delivered a 4× increase in inbound leads while halving the marketing budget, by identifying high-ROI channels through attribution and campaign performance modeling.

- Engineered monthly audit pipelines processing 10M+ rows of turnover data across 4,500+ Ukrainian pharmacies, with automated anomaly checks. - Developed time-series forecasting models for pharmacy demand planning, improving inventory and procurement accuracy for key clients. - Led methodology adaptation for market entry into Kazakhstan, reconfiguring pipelines for new data formats and regional reporting.

- Consolidated monthly data from 250+ pharmacy chains and distributors into a centralized Excel/Power Pivot reporting system, replacing fragmented manual aggregation. - Produced recurring sales performance, inventory, and KPI reports across product lines, brands, and regions — directly informing commercial strategy and territory planning.