Sergey Garmash

- Data analysis and insights sharing - Dashboards development - Statistics data processing - Presentations preparation for management - Improving analytical environment of the Company

- SI forecasting development project - Wildberries's API data project - E-com Team's Reporting automatization (and creating reports on Power BI) - Ad-hoc requests for E-com and Digital teams

- MatchFlow Loyalty project - Field force bonus calculation. Preparation of the bonus base and consolidation of the data of KPIs executing by the field force. Discussing with management about bonuses and sending the data to the payroll group. - Preparation of quarterly sales plans. - Support existing reports and creating new reports based on Power BI. - New Product Innovations report preparation. - Database compliance control for sales database (Pradata) with CRM database (Proxima)

- Sales Force Automation project - CRM implementation project; - Monthly distributors' trade investment register forming and reconciliation. - Daily sell-in and sell-out reports preparation. - Control of work, coaching, and simple data processing requests delegation for junior analyst.

- Report processing (Sell-In, Sell-Out, Inventory) - Work with IQVIA and Cursor data - Contract management (15 contracts) - Ad-hoc requests and participation in company's projects Achievements: - I've accelerated the processing of Stock reports up to 1.5 hours (previously - 2 days) - I've transferred work with Sale IN data on a daily basis (previously - 2 times a week) - I've optimized interaction with distributors for reporting contracts

- Report Processing (Sale OUT) - Testing new data modules based on QlikView - Contract management and lead new data consolidation (6 vendors)

- Full analytical and administrative support for sales team - Leading the bonus process and discounts reconciliation for partners

- Work with data from distributors' reports - Monitoring the relevance of MasterData dictionaries - Regular update of Pharmacies and Hospitals' workbooks