Owner

• Feb 2009 - Present

• Jan 2019 - Present

Used programs - Excel (VBA and SQL), Access, SAP, SQL server (T-Sql)• SQL server database administration, data quality control.• Supplier performance KPI reporting system administrator.• As centralized forecasting process administrator lead and guide countries in forecast accuracy improvements.• Manage forecast and allocation EDI system implementation.• Develop centralized S&OP system.

• Oct 2011 - Dec 2018

• KPI definition and follow up for selected suppliers: delivery accuracy, agreed lead-times, forecast, and allocation realization targets, increase EDI efficiency and decrease manual efforts.• Develop and administrate internal and external BI reports.• Develop and administrate centralized forecast and allocation system with data interpretation according to internal and external requirements.• SAP ECC (HAN) purchasing related reports improvement suggestions.• Goods delivery terms unification for all group countries.• Internal and external assortment unification. • Facilitate weekly and monthly purchasing performance related meetings: dashboards, presentation.• SQL server reporting system administration and programming: data download and connection from three different resources with a different data structure. Show less

• Mar 2007 - Aug 2013

• Balanced goods purchasing with sales prediction to achieve optimal stock level taking into account seasonality and marketing plans. Stock turn improved from 4 to 11 times per year.• Assortment internal harmonization with branches in Sweden, Finland, and Germany. Increased products list for customers from 400 stock item to 6000 fast delivered items.• Forecast process implementation with main suppliers with the purpose to decrease lead-time.• Goods delivery in the EU based on contract agreements.• Warehouse work optimization and address system implementation. Show less

Senior Purchasing Analyst (freelancer)

• Feb 2019 - Present

Used programs - Excel (VBA and SQL), Access, 1C, MySql, SQL server (T-Sql) • Develop and implement an analytical system than combines information from three countries and systems into one analytical system. The central management team can see all countries sales and stock development in a unified form. • Facilitate weekly company results summary. • Analyze and confirm purchasing requests according to company sales plans and defines the optimal stock level. • Statistical forecast system development. Show less

Baltic Sales Director

• May 2020 - May 2022

Vietnam producers interests representation in Latvia: - Agricultural products- https://www.facebook.com/VietnamAgriculture88888/ - Textile, apparel, sugar, coffee, nuts, frozen see products - tps://www.facebook.com/aldiasia77777 Vietnam producers interests representation in Latvia: - Agricultural products- https://www.facebook.com/VietnamAgriculture88888/ - Textile, apparel, sugar, coffee, nuts, frozen see products - tps://www.facebook.com/aldiasia77777

MS Excel programmer (freelancer)

• Aug 2017 - Aug 2017

Used programs - Excel (VBA and SQL), Access Project management tool development based on MS Excel. Used programs - Excel (VBA and SQL), Access Project management tool development based on MS Excel.

Chairman Of The Board

• Dec 2010 - Jul 2017

Used programs - Excel (VBA and SQL), Access Real estate management. Bookkeeping, budgeting, and finance controlling. Unity foundation process. 160 apartments. Total area - 10700 m2. Used programs - Excel (VBA and SQL), Access Real estate management. Bookkeeping, budgeting, and finance controlling. Unity foundation process. 160 apartments. Total area - 10700 m2.

General Manager / Finance manager

• Aug 2004 - Feb 2007

Used programs - Excel (VBA and SQL), Access • Performed full 2000-2004 years audit with Tax Authorities reports correction. • Office management. • Full cycle bookkeeping (3 revised annual reports). • Finance management with 7 m.EUR annual turnover. • Big building projects management: technical specification, contracts, goods production, and delivery schedule. • Three sales agents work management. • Goods delivery from EU and China based on contract agreements. • Internal expedition and warehousing. • New product implementation. Show less

Transport department manager

• Mar 2003 - Jul 2004

Used programs - Excel (VBA and SQL), Access • Created and incalculated a system of petrol comsumption, repairing costs, spare parts consumption, and transport haul regulations for 40 trucks and 100 cars. Total costs reduces by ~10%. • Implemented new results based motivation system for truck drivers. • HR management 40 truck drivers and 4 repairing service workers. Used programs - Excel (VBA and SQL), Access • Created and incalculated a system of petrol comsumption, repairing costs, spare parts consumption, and transport haul regulations for 40 trucks and 100 cars. Total costs reduces by ~10%. • Implemented new results based motivation system for truck drivers. • HR management 40 truck drivers and 4 repairing service workers.