Sergey Garmash Email & Phone Number

Russia

Hybrid

Procurement Department | Business Analysis Team• Develop and implement data analytics instruments within the procurement department, including tools for cost calculation and budget comparison to improve financial oversight.• Automate routine tasks and optimize processes, such as creating tools for currency exchange rate retrieval and contract expiration tracking, reducing risks and improving efficiency.• Localize and adapt tools like VBA macros to maintain seamless business operations without workflow disruptions.• Collaborate on cross-functional projects with production, R&D, and supply chain teams to drive process improvements.• Foster a data-driven culture within the department, enhancing analytical capabilities through targeted initiatives and tool development.

Remote

Commercial Excellence Department | Sales Planning Team• Provide strategic analytical support to commerce and marketing teams.• Develop and maintain distributor sales forecasts.• Drive automation of reporting processes, saving significant time for teams.• Proficient in Power Query, SQL, and legacy code for data optimization.

Remote

Marketing department | Analytics Team• Leveraged advanced data analysis to extract trends and insights, fueling strategic decision-making and enhancing marketing campaign effectiveness.• Developed dynamic Power BI dashboards for real-time KPI tracking, facilitating data-driven decision-making across the organization.• Applied robust data analytics methods to large datasets, uncovering actionable insights that optimized marketing strategies and boosted overall business performance.• Delivered compelling presentations to the leadership team, simplifying complex analytical findings and effectively communicating strategic recommendations and performance metrics.• Championed the enhancement of the company's analytical infrastructure by incorporating cutting-edge technologies, tools, and methodologies, significantly boosting data accuracy, operational efficiency, and productivity.

Moscow

Professional Products Division | Business-Analysis Department (E-commerce channel)• Delivered full-fledged analytical support for the E-com channel, including preparation of data-driven insights for client negotiations (SO evolution, TOP SKUs, turnover, and stock level calculations).• Automated KAMs' reports, enhancing work speed by fivefold compared to previous systems.• Pioneered the analytical environment for the E-com channel, creating Power BI dashboards and automating reports with Power Query. Notably, first in the company to create a comprehensive prices & discounts report and initiated the development of the primary E-com report.• Developed a Sell-In Forecast model, successfully increasing its forecast accuracy from 0% to 40%.• Assessed new data sources and actively participated in API-based data delivery. Swiftly identified discrepancies between API data and top client's site data, ensuring rapid resolution by alerting all stakeholders.• Conducted in-depth analysis of major competitors' performance indicators.• Efficiently managed daily ad-hoc requests for the E-com team, demonstrating flexibility and quick response capability.

Moscow

Commercial Excellence Division | Systems Support & Business Intelligent Department• Managed, improved, and maintained the data quality of sales and CRM databases, resulting in a 15% reduction in duplicates and inactive pharmacies within the sales database. Also, swiftly resolved user incidents to minimize downtime.• Enhanced business reporting by developing and supporting Power BI reports, including the creation of a comprehensive new products report.• Streamlined the calculation of bonuses and sales plans for the field force, and expedited ACB's reconciliation process by over twofold.• Provided analytical support for promotional activations as part of the non-ACB pharmacies project, enabling effective decision-making.• Conducted training sessions for colleagues, enhancing their proficiency in working with the sales database and fostering a data-driven work environment.

Moscow

Traditional Trade Department• Generated regular reports encompassing Sell In, Sell Out, and Inventory metrics, providing vital business insights.• Streamlined the collection and analysis of trade investment data from field force, forwarding key insights to the finance department. Notably, optimized the trade investment file, reducing its size from 21 Mb to 1 Mb, thus significantly speeding up its opening and calculation time.• Spearheaded the Data Warehouse (DWH) implementation project in collaboration with the Malaysian team, leading to the successful development and constant upload of distributor data. Pioneered the creation of the Standard Operating Procedure (SOP) for data collection from distributors in the Moscow office.• Contributed to the project of field reports development for the field force. Ensured the development of reports, calculation of the implementation budget, and facilitated submission for GM's approval.• Conducted induction training for newcomers to effectively navigate the company's analytical data, fostering a data-informed culture. Additionally, led several MS Excel training sessions for the entire company workforce.

Moscow

Human Pharma Division | Sales and marketing efficiency Department• Prepared essential daily reports, including Sell In, Sell Out, and Inventory metrics, to monitor business performance and inform strategic decisions.• Compiled comprehensive monthly reports detailing competitors' sales performance and tender participation to ensure competitive awareness.• Managed the execution of 15 data contracts, ensuring compliance and effective data management.• Streamlined the processing of Inventory reports, reducing the processing time from 2 days to 1.5 hours, enhancing efficiency.• Transitioned the handling of Sell In data from a bi-weekly to a daily process, resulting in more timely and actionable insights.

Moscow

Operational Department | Analytical Group• Processed Sell Out reports, providing crucial data for business decision-making.• Utilized QlikView for data visualization and analytics to support business objectives.• Managed the execution of 6 contracts, ensuring timely fulfillment and compliance.• Initiated and led a project to procure reports from companies aggregating distributor prices, enhancing market understanding and strategic planning.

Mytishchi, Moscow, Russia

Nestle's Wholesale Department• Provided comprehensive analytical and administrative support to the wholesale team, enhancing their operational efficiency and data-driven decision-making capabilities.• Assisted in managing the bonus process and discounts for partners, ensuring accurate and timely reward distribution.

Moscow

Marketing & Sales Support Services• Processed data from distributor reports, ensuring accurate and timely insights for decision-making.• Maintained the relevance and accuracy of MasterData dictionaries and workbooks, ensuring reliable and up-to-date resources for the organization.

Professional Certificate In Commercial Analysis

Postgraduate Student, Sociology Of Management, 4,4 (Of 5)

Master Of Public Administration - Mpa, Social & Economic Processes Governance, 5 (Of 5)

Activities and Societies: Best Graduate