The new E-visa portal combines convenience for customers and efficiency for the team
E-visa is a travel brand from western Ukraine. The team helps clients quickly, correctly, and stress-free apply for visas to...
View more
Audit of data sources and design of a new data architecture for YURiA-PHARM
About the project
They made this diagnosis and issued instructions for applying the new architecture.
YURiA-PHARM is one of Ukraine's top five pharmaceutical companies, which has been developing innovative medical products for over 20 years. The company launches more than 20 new products every year, has its own research base, modern production facilities, and exports to over 40 countries. YURiA-PHARM reinvests 90% of its profits into development, in particular, into scaling R&D, new technologies, and digital business transformation. The constant launch of new products, entry into international markets, and increasing complexity of operations require consistency in all processes: from production to data management.
The client's problem
YURiA-PHARM had dozens of disparate data sources that were not integrated into a single system. This complicated analytics, delayed reporting, and hindered the launch of data initiatives. The company lacked a holistic architectural vision that matched the scale of its operations.
Key challenges:
- low consistency between data sources;
- lack of a single repository for reporting and analytics;
- manual report generation and dependence on individual systems;
- limited transparency of customer patterns and loyalty processes;
- Inhibition of initiatives from data departments due to architectural fragmentation.
The company needed a systematic approach to data management that would allow it to align sources, establish architectural integrity, and create a foundation for scaling.
Case information
We planned a data architecture that matches the scale of YURiA-PHARM.
-
The goal of the project was to develop a unified architectural vision for the new data warehouse.
-
Our approach:
-
We started by understanding the context: we conducted a series of interviews with key stakeholders at YURiA-PHARM to gather information and see how data actually works in different departments. This was followed by a detailed audit of more than 15 sources: ERP, CRM, and BI systems.
Based on the collected data, we formed an architectural vision of the new GSC, adapted to the scale and internal structure of the company. We developed a phased transition plan, taking into account technical, business, and process dependencies.
The result was a roadmap that the client’s team was able to immediately put into action: with a description of the architecture, a budget estimate, and clear development priorities.
Work results:
-
We have laid the foundation on which to build a systematic, scalable, and business-oriented data architecture.
-
Our client received:
-
architectural vision of the new GSH;
-
a step-by-step roadmap for implementation;
-
expert assessment of the implementation budget;
-
recommendations for the development of data infrastructure;
-
documentation agreed upon with the team.
-
The company’s data underwent a complete diagnosis, and instead of general ideas, a clear, coordinated action plan emerged. The solution takes into account the specifics of the business, data structure, and internal constraints.
Project details:
Key facts about the project
9 months
Project duration
Large
Project size:
Project complexity
Completed
Project status:
Our Team:
Project Manager
Business Analyst
Data Engineer
Data Analyst
Data Scientist
More cases
Similar cases
British American Tobacco: The tobacco giant is now also a technology leader
British American Tobacco is a company that operates in over 180 countries worldwide. The team comprises more than 45,000 employees.
View more
Planeta Kino has built its own ecosystem: a portal for screening schedules and ticket sales.
Planeta Kino is the largest and most innovative cinema chain. It was the first company in Ukraine to introduce online...
View more
Contact Us
Looking for a reliable technical partner? We are ready to join your project at any stage – from idea to launch.
Information
Fill out the form, and we will contact you to discuss the project.
Address
Senator Business Center, 32/2 Knyaziv Ostrozkykh St. Kyiv, Ukraine, 01010
Phone
+38 (044) 334 42 30
