Pleshakov Andrey Alexandrovich

Citizenship: Россия
Native language: Русский
Language proficiency: English - fluent
Autobiography
Я работаю в области Информационные технологии/ERP системы
Моя профессия - SAP BW consultant
Current job
- Knauf Service CIS - Senior consultant SAP BW (from july 2007-07-01 00:00:00.0, Красногорск)
• Executing SAP BW roll-out projects in parallel with SAP ERP2005 go-live over KNAUF enterprises within CIS.
• Activating standard BI content, developing ETL process, data storages for special local reporting, developing data sources in SAP Query.
• Enhancing standard data extractors.
• Creating BEx queries and final Excel reports with VBA coding,
according to technical tasks from End users/ERP consultants.
• Providing post-implementation users support and development.
• Successfully have finished projects in 5 enterprises.
Previous jobs
- Coca-Cola HBC Eurasia - SAP Reporting and CoE (Center of excellence) Manager (2006-03-01 00:00:00.0 - 2007-07-01 00:00:00.0, Москва)
• Provided reporting requirements for SAP BW for Supply Chain planning and procurement and KBIs measurement purposes.
• Created reporting pack for Supply chaing planning within country, improved existent reports in SAP BW.
• Developed reporting system for planning and procurement, combining data from several information sources (SAP R/3, APO, BW, data archives) and executed necessary analysis and reports' preparation.
• Executed reproting in basic directions for analysis and KBIs' measurement:
- Forecast, production and deployment planning - accuracy, compliance;
- Out of stock and service level;
- Operating reports with sales, production, deployment plans and actuals;
- Inventory levels of finished goods and raw materials;
- Procurement reports - purchasing price accuracy, vendors evaluation.
• Prepared periodic KBIs and business recommendations, based on the reporting and analysis results. - Coca-Cola HBC Eurasia - Subject matter expert – key user; power user. SAP project (2006-03-01 00:00:00.0 - 2007-04-01 00:00:00.0, Москва)
• Implemented Material Planning Management (raw materials and semi-finished goods) in boundaries of SAP installation project over Russia (12 plants, 88 locations).
• Gathered and maintained material master data for 7 hundreds raw and packaging materials for 12 plants, and more than 1,3 thousands bills of materials by product/plant.
• Developed raw materials planning process for SAP environment, used change management, amendments and SAP template development for business requirements.
• Trained and supported sixteen local and three central raw materials planners.
• Successfully started up (Go live!) with 100% system performance and supported adaptation afterwards.
• Created two company's procedures for master data update and support for material master and bill of materials master information. - Coca-Cola HBC Eurasia, CSO - Raw materials analyst. Central Planning dept. (2004-11-01 00:00:00.0 - 2006-03-01 00:00:00.0)
• Developed new raw materials planning process, created database and integrated other tools for automated planning, using constraints and MRP parameters.
• Planned all seven groups of centrally purchased raw and packaging materials for eleven production plants with total quantity of 7,5 hundreds items and with average cost of $55mln.
• Supervised 11 local planners, central raw materials coordinator and reporting specialist.
• Decreased inventory level on hand from 59 to 48 days of production by most valuable material types without reducing production compliance.
University education
- All-Russian Financial and Economic Institute (higher education)Accountig and statistics, Economist in accounting and audit, 1995-2002
Training courses
- BW310, BW330, SAP CIS, Москва, Sertificate, 2008
- SAP BW Power user training (analog BW305)Deloitte, Sertificate, 2006
- Enabling fast change training, Coca-Cola HBC, Diploma, 2006
- SAP trainings, SAP & Coca-Cola HBC, Passport, 2006
- Stock and supply management I (training)Ernst &Young, Diploma, 2005
- Stock and supply management II (training)Ernst &Young, Diploma, 2005
- Sales and operations planning training, Coca-Cola HBC, Diploma, 2004