Ekaterina Chernysheva

• Executed SQL queries to extract detailed data on transactions, tariffs. • Conducted regular reconciliation of extracted and cleansed data with adjacent systems to ensure financial reporting accuracy and operational compliance. • Identified and analyzed discrepancies in financial metrics. • Collaborated with employees and partners on contract and transaction verification issues. • Designed and implemented ETL pipelines with Power Query and Python to cleanse, transform, and prepare data for analysis.

• Built demand forecasting models based on historical data and market trends. • Calculated key performance metrics: sales plan execution, forecast accuracy, and service level. • Visualized sales data for the Sales team.

• Calculated unit economics to determine target purchase and sales prices, accounting for all operational costs (logistics, customs duties, COGS). • Conducted ABC analysis of the entire product assortment and delivered visualized reports to optimize product categories and matrix. • Successfully negotiated contracts with 20+ suppliers across 7 categories, including cookware and home decor. • Productively negotiated pricing and payment terms, achieving an average cost reduction of 3%.

• Planned and formed procurement budgets based on sales forecasts. • Achieved 90% sales forecast accuracy, enabling more effective inventory management. • Built predictive demand models for company P&L planning using historical data and market trends. • Managed data integrity, cleansed data for analysis, and prepared reports.

- Planned shipments of 120-150 containers per month. - Monitored transportation, storage, and customs clearance of goods; handled claim management with suppliers. - Ensured optimal inventory levels at company warehouses. - Optimized transportation and warehouse costs.

- Owned the supplier reconciliation process, ensuring accuracy of the balance sheet and resolving discrepancies proactively. - Led and developed a team of 2 specialists responsible for the end-to-end accounts payable process. - Maintained daily accounts and registering transactions in ERP software - Preparation reports for tax audit; monetary control of import purchases; claim settlement with suppliers - Participation in the month end closing procedure