Selected work · Alexander Koltsov

ERP, Operations and Automation Case Studies

These ERP consulting case studies and operations projects show the business context, my responsibilities and the result. The collection includes implementations, process design, workflow automation and AI architecture.

24 project records

ERP

Enterprise ERP Transformation for an International Manufacturing Business ↗

Challenge: Critical processes and data were distributed across functions and external systems. Manufacturing, stock, sales,…
Scope: Odoo Enterprise · ERP ownership · multi-company operations · manufacturing
Solution: Alexander acted as ERP owner and transformation lead. He designed and continuously developed the Odoo environment across…
Result: The business had an integrated operational backbone connecting demand, orders, procurement, production, stock movements,…

Read full case ↗ERP Consultant ↗

Automation

Odoo as the Operational Core of a Multichannel Commerce Business ↗

Challenge: Each channel used its own product, order, and customer structures. Maintaining consistent SKUs, stock positions, payment…
Scope: Odoo · WooCommerce · Allegro · TikTok
Solution: Alexander designed the Odoo-centered integration architecture and end-to-end data flows for products, variants, orders,…
Result: The target operating model provided a central ERP record for multichannel transactions while preserving the connections…

Read full case ↗Workflow Automation Services ↗

Automation

High-Volume Shopify Plus and ERP Integration ↗

Challenge: Product variants, orders, customers, inventory, and fulfillment had to remain synchronized between the storefront and the…
Scope: Shopify Plus · Odoo · API integration · catalogue management
Solution: Alexander worked on the Shopify Plus–Odoo architecture and synchronization scope, covering product templates, variants,…
Result: The commerce front end and ERP backend were connected through defined operational data flows, enabling Odoo to support the…

Read full case ↗Workflow Automation Services ↗

Operations

Manufacturing Process Design from Procurement to Financial Result ↗

Challenge: Procurement, raw-material storage, recipes, unit-of-measure transformations, production stages, finished goods,…
Scope: Odoo Manufacturing · bills of materials · work centres · MTO
Solution: Alexander analysed and designed end-to-end Odoo flows covering bills of materials, manufacturing orders, work centres and…
Result: The designed processes connected purchase and demand signals to material availability, production execution, finished stock,…

Read full case ↗Business Process Optimization Consultant ↗

Operations

ERP and Billing Design for a 3PL Fulfillment Operation ↗

Challenge: Warehouse activity and 3PL services had to be translated into controlled operational events and billable services. Without a…
Scope: Odoo · 3PL · fulfillment · warehouse management
Solution: Alexander analysed the fulfillment model and designed the ERP processes linking warehouse operations, logistics events,…
Result: The solution design connected physical fulfillment activity with ERP records and the commercial billing flow, giving the…

Read full case ↗Business Process Optimization Consultant ↗

AI and MCP Architecture for Management and Financial Reporting ↗

Challenge: Data access and interpretation were separated: users had to locate figures, reconcile sources, prepare reports, and then…
Scope: AI agents · Model Context Protocol · tool-based AI · Odoo
Solution: Alexander developed a controlled reporting architecture in which AI uses authorised tools and Model Context Protocol…
Result: The resulting architecture enables conversational analysis to be grounded in authorised business data rather than values…

Read full case ↗AI Automation Consultant ↗

AI-Assisted CRM Follow-Up for a Dormant Lead Base ↗

Challenge: Lead histories had to be reviewed individually to understand status, context, previous communication, and the appropriate…
Scope: AI workflow design · Odoo CRM · Odoo API · lead qualification
Solution: Alexander designed an AI-assisted follow-up model with selection rules, structured fields, action logic, and technical…
Result: The lead base could be processed through a consistent workflow that surfaced context and proposed actions instead of relying…

Read full case ↗AI Automation Consultant ↗

AI-Enabled Vertical Product Development ↗

Challenge: Domain-specific work depended on fragmented tools, specialist knowledge, and repeated human analysis. Turning a sector…
Scope: Product discovery · startups · product management · unit economics
Solution: Alexander led the initiatives as an entrepreneur and product owner, applying industry discovery, requirements analysis,…
Result: The initiatives converted industry-specific knowledge into structured product concepts and working development tracks with…

Read full case ↗AI Automation Consultant ↗

Operations

Project Portfolio Management Offices and Executive Governance ↗

Challenge: Projects were managed through differing practices, roles, priorities, and reporting formats. Senior management lacked a…
Scope: PMO design · project portfolio management · project governance · methodology development
Solution: Alexander created and developed Project Management Offices, designed corporate project-management methodologies, defined…
Result: The organisations gained a shared management framework for projects and portfolios, including defined responsibilities,…

Read full case ↗Business Process Optimization Consultant ↗

Operations

Scaling a Global Digital Product Portfolio Through Operating-Model Redesign ↗

Challenge: The breadth of the portfolio and pace of delivery required clearer management responsibility and tighter coordination across…
Scope: COO and CFO leadership · operating-model design · digital products · product portfolio management
Solution: As an operational and financial leader, Alexander formed a new management structure and connected operating decisions with…
Result: The business operated with a more explicit management structure capable of supporting a large digital portfolio, fast…

Read full case ↗Business Process Optimization Consultant ↗

Automation

SEO-Safe Migration from WordPress to Astro at Content Scale ↗

Challenge: The sites depended on legacy WordPress infrastructure and accumulated content, media, redirects, and obsolete URLs.…
Scope: Astro · WordPress migration · technical SEO · redirect strategy
Solution: Alexander personally managed content and media migration, URL inventories, redirect mapping, 301/404/410 analysis,…
Result: The sites ran on an Astro, Node.js, Nginx, and Linux stack with repeatable deployments and verified link integrity. On one…

Read full case ↗Workflow Automation Services ↗

ERP

Building an International ERP Consulting Delivery Model ↗

Challenge: ERP work was inherently variable across industries, countries, business maturity levels, and implementation scopes.…
Scope: Odoo Enterprise 12–19 · ERP consulting · entrepreneurship · international delivery
Solution: Alexander created a service model covering Odoo implementation, customisation, migration, hosting, integrations, BI,…
Result: Clients could engage through a defined delivery lifecycle with explicit scope, responsibilities, analysis, solution design,…

Read full case ↗ERP Consultant ↗

ERP

Multi-Company, Multi-Warehouse ERP for a Growing Distribution Group ↗

Challenge: Each additional entity and warehouse multiplied the number of stock movements, internal transactions, access rules,…
Scope: Odoo · multi-company ERP · eight-warehouse architecture · inventory management
Solution: Alexander led the design and implementation of a multi-company, multi-warehouse Odoo architecture. He structured legal…
Result: Five companies and eight warehouses operated within a shared management architecture with traceable stock flows, common…

Read full case ↗ERP Consultant ↗

Operations

Group Management Accounting, Budgeting, and AI-Connected Finance ↗

Challenge: Financial data originated in multiple legal entities and billing platforms. Budget control, liquidity management, management…
Scope: Odoo Accounting · multi-company finance · management accounting · budgeting
Solution: Alexander designed and implemented the group finance architecture: management charts and analytical dimensions, entity-level…
Result: The group gained an integrated management-accounting model across eight entities, connected to source billing data and…

Read full case ↗Business Process Optimization Consultant ↗

ERP

Warehouse and Financial Control for an Industrial Business ↗

Challenge: Stock receipts, internal movements, issues, sales, purchasing documents, and financial records were not sufficiently…
Scope: Odoo Inventory · Odoo Accounting · procurement · sales
Solution: Alexander implemented the warehouse and financial management scope end to end. He structured products, units of measure,…
Result: Warehouse events and their financial consequences were recorded in a connected system with traceable documents, controlled…

Read full case ↗ERP Consultant ↗

Automation

Amazon Commerce with 3PL Integration and Embedded AI ↗

Challenge: Marketplace orders, inventory held by the fulfillment provider, shipments, returns, product data, charges, and financial…
Scope: Odoo · Amazon · Mintsoft · 3PL
Solution: Alexander delivered the solution as a complete implementation. He designed Amazon order and product flows, integrated the…
Result: Amazon sales, external fulfillment, stock visibility, operational exceptions, and financial records formed a connected…

Read full case ↗Workflow Automation Services ↗

ERP

End-to-End Omnichannel Automation for an Import and Retail Business ↗

Challenge: Purchasing, incoming goods, landed costs, wholesale orders, online orders, retail transactions, stock, customer balances,…
Scope: Odoo · procurement · imports · landed costs
Solution: Alexander designed and delivered the complete ERP transformation. He connected supplier and procurement workflows, imports,…
Result: The business operated through a unified process from purchasing and import through warehouse receipt, multichannel sale,…

Read full case ↗ERP Consultant ↗

Automation

Integrated E-Commerce, Marketplace, Logistics, and Polish Finance Automation ↗

Challenge: Orders and operational data moved across several sales channels and a carrier network, while finance had to maintain correct…
Scope: Odoo · WooCommerce · Amazon · Allegro
Solution: Alexander implemented the project end to end: purchasing, product and supplier data, inventory, WooCommerce integration,…
Result: Procurement, online demand, marketplace orders, delivery operations, customer documents, and finance were handled through a…

Read full case ↗Workflow Automation Services ↗

Automation

International E-Commerce Operations Across Shopify, Amazon, 3PL, and CRM ↗

Challenge: Direct-to-consumer orders, marketplace fulfillment models, warehouse stock, shipping execution, CRM activity, purchasing,…
Scope: Odoo · Shopify · Amazon FBA · Amazon FBM
Solution: Alexander delivered the entire solution from discovery through production. He designed procurement and replenishment,…
Result: The implemented system connected purchasing, stock, Shopify, Amazon fulfillment, shipping, CRM, and accounting in a…

Read full case ↗Workflow Automation Services ↗

ERP

Four-Company, Twenty-Warehouse ERP Transformation in Africa ↗

Challenge: The scale of the warehouse network and legal structure produced a large number of inventory, manufacturing, intercompany,…
Scope: Odoo · four-company architecture · twenty warehouses · manufacturing
Solution: Alexander designed and led a large-scale multi-company implementation covering twenty warehouses, product and location…
Result: Four legal entities, twenty warehouses, production, purchasing, cash management, and finance were brought into a shared…

Read full case ↗ERP Consultant ↗

ERP

Intercompany Trade and Group Finance for a Three-Entity African Business ↗

Challenge: Goods and financial obligations moved between group entities as well as external suppliers and customers. Intercompany…
Scope: Odoo · three-company ERP · intercompany procurement and sales · billing integration
Solution: Alexander designed and implemented the multi-company model for procurement, intercompany purchasing and selling, inventory…
Result: The three entities operated through a connected transaction chain in which external purchases, intercompany sales, billing…

Read full case ↗ERP Consultant ↗

Automation

Collaborative Document Management and Approval Inside ERP ↗

Challenge: Documents moved between employees and counterparties through separate files and communication channels. Editing, comments,…
Scope: Odoo Documents · ONLYOFFICE · collaborative editing · approval workflows
Solution: Alexander designed a commercial document-management solution combining Odoo Documents with ONLYOFFICE. The architecture…
Result: Operational records and their supporting documents could be managed in one controlled workspace with visible ownership,…

Read full case ↗Workflow Automation Services ↗

ERP

Localised POS and Fiscal Workflow for a New Country Operation ↗

Challenge: Standard retail functionality did not by itself cover the country-specific fiscal workflow, device behaviour, document…
Scope: Odoo POS · Serbian fiscalisation · KEP · SUNMI V2 PRO
Solution: Alexander analysed the local requirements and designed the Odoo POS solution around KEP and SUNMI V2 PRO devices. He mapped…
Result: The target POS workflow connected store transactions, fiscal processing, supporting hardware, and ERP records through a…

Read full case ↗ERP Consultant ↗

AI-Assisted Business Analysis from Conversation to Delivery Scope ↗

Challenge: Business analysts had to manually reconstruct requirements, decisions, contradictions, dependencies, and action items before…
Scope: Generative AI · transcript analysis · context engineering · business analysis
Solution: Alexander developed AI-assisted analysis workflows for processing transcripts and documents, extracting and grouping…
Result: Unstructured discussions and source materials could be converted into consistent project artefacts more quickly, while…

Read full case ↗AI Automation Consultant ↗

Put the next step into practice

Need Help with Your Project?

Discuss your ERP, operations, workflow automation, or AI automation project with Alexander Koltsov.

Contact Alexander ↗

ERP, Operations and Automation Case Studies

Consulting services behind the projects

ERP Consultant ↗

ERP Implementation Consultant ↗

Business Process Optimization Consultant ↗

Workflow Automation Services ↗

AI Automation Consultant ↗

Need Help with Your Project?

ERP Consultant

ERP Implementation Consultant

Business Process Optimization Consultant

Workflow Automation Services

AI Automation Consultant