Alexei Plitman Email & Phone Number

Petah Tikva, Il

Full data processing from source to end user dashboards (ETL, data management, reports optimization)Development and management of reports for many business processes for inside and outside clientsPower BI + PostgreSQL + PythonFabrics, Databricks

Tel Aviv, Israel

● Data Models / Dashboards/ Reports for Sales, Expenses, COGs, Budget and Forecast, Operations, P&L based on various data sources (full ETL process) for various stakeholders by request and by initiative. ● Inventory (all warehouses worldwide) and Delivery (all shipping providers + delivery points) monitoring with live connectors to partners’ sites and data sources.● Analytical and management models for Pricing, Profit and others.Regular reports and insights.Full Power BI integration from the scratch with Python connectors to data sources, Excel, SAP, Python, Shopify, SQL

• Sales and Profit analysis by client/brand/product group. Results and gaps, charts and visualization.‎• Promotion planning (by clients and products) and analysis, brand new system of promotions ROI evaluation.‎• Market share development reports as interactive model with various abilities and dashboards.‎• Full rebuilding of data flows, automation of all above, tools, dashboards and methodology development. ‎Connection of all the different data sources – supply chain, distributors, accounting and finance.‎• Forecasting of sales and production, forecast accuracy analysis, demand planning – all with SAP.‎• New products and projects P&L models. • Sales and Operations planning. Special projects and reports to European HQ.‎• Power BI integration from the scratch.‎• Tableau reports

Israel

• Data processing and analysis- mainly sales and marketing.• Optimization of data flows and process methods, development of new Excel based systems. • Periodical monthly, quarterly and reports to the Board (Sales, production, market shares, costs, stocks etc by country/product group)• Saving a lot of working hours with automation of data processing. Maximizing the accuracy of data.• Special projects (Various requests – i.g. marketing research, currency rate influence, coffee pricing trends)• Delphi implementation – queries and reports.• Sales Mapping project for the Performance Excellence department covering all the international sales offices.

Israel

• Deep analysis of the business particularity• Developing of Profit management schemes for each specific business with main indicators, key points and methods of influence• Budgeting and purchase planning• Vertically integrated reporting system, sales and stock real-time monitoring and analysis• In-class and field trainings and coaching for all hierarchy levels from salesmen to branch managers on sales, analytics, management, decision making• Stock analysis and management system, prevention of losses and overstock• New business projects evaluation and assessment

Master'S Degree, Applied Mathematics

Mathematics, algorithms, programming languages

Strategic Management