Anastasiia Sokol

Led 3 simultaneous projects in fast-paced environments, prioritizing tasks to meet tight deadlines. Acted as a bridge between business and technical teams, translating complex needs into precise specifications. Delivered actionable insights and ad-hoc reports using SQL, Excel and BI tools. Led grooming and planning sessions to align feature development with strategic goals. Performed UAT to ensure functionality met customer needs and delivered business value. Created clear requirements and specifications.

Designed, built, and maintained over 30 reports and dashboards (MicroStrategy, Excel, Google Sheets) to track operational OKRs and other KPIs, providing clear, reliable data for decision-making. Collaborated with cross-functional teams of analysts, developers, and SMEs to ensure reporting solutions aligned with strategic goals. Used SQL and SSIS to create complex queries and ETL processes, ensuring high data integrity and enabling detailed analysis.

Analyzed and processed large data to ensure effective database management and integrity. Improved and optimized database workflows to increase efficiency and performance. Contributed as a subject matter expert in the development of a new data management application.

Collaborated with brewery departments to coordinate efforts in achieving common goals. Analyzed logistics KPIs, identifying root causes for deviations and implementing corrective actions to maintain efficiency. Redesigned 4 planning tools and developed 2 new ones in Excel, improving scheduling accuracy and reducing planning time by 30%. Acted as a SME during the transfer of production planning activities from 3 breweries to a central Business Service Center. Mentored new employees.

Analyzed logistics Key Performance Indicators (KPIs), identifying root causes for deviations and implementing corrective actions to maintain efficiency. Developed 2 logistics planning tools to manage stock levels, meet customer needs, and align with warehouse capacity. Acted as a subject matter expert during the transfer of distribution planning activities from 7 breweries to a central Business Service Center. Mentored new employees, fostering a collaborative and high-performing team environment.

Managed the end-to-end purchasing cycle, from initial customer inquiry and supplier negotiation to final warehouse posting. Built and maintained strong relationships with suppliers, negotiating favorable terms and pricing to ensure cost-effectiveness and reliability. Collaborated effectively with internal sales, product, and demand teams to align procurement strategy with business needs. Trained employees to work in specialized software applications (Endorsia, wOrders, SKF Croesus).