{"id":3925,"date":"2025-11-15T22:10:38","date_gmt":"2025-11-15T22:10:38","guid":{"rendered":"https:\/\/dev.iwis.io\/?post_type=portfolio&#038;p=3925"},"modified":"2025-11-28T17:41:22","modified_gmt":"2025-11-28T17:41:22","slug":"yuria-farm","status":"publish","type":"portfolio","link":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/","title":{"rendered":"Audit of data sources and design of a new data architecture for YURiA-PHARM"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"footnotes":""},"portfolio_category":[112,104],"portfolio_tag":[113],"class_list":["post-3925","portfolio","type-portfolio","status-publish","hentry","portfolio_category-business-intelligence-bi","portfolio_category-custom-software-development","portfolio_tag-data-engineering"],"acf":{"portfolio_project_image":3927,"portfolio_project_description":"YURiA-PHARM is one of Ukraine's top five pharmaceutical companies, which has been developing innovative medical products for over 20 years. ","portfolio_project_tags":[113],"portfolio_project_url":"","portfolio_categories":[112,104],"portfolio_featured_project":false,"portfolio_about_label":"About the project","portfolio_about_title":"They made this diagnosis and issued instructions for applying the new architecture.","portfolio_about_description":"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.   \n","portfolio_about_problem_title":"The client's problem","problem_item_text_default":"<span style=\"font-weight: 400;\">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.  <\/span>\n\n<b>Key challenges:<\/b>","portfolio_about_problem_items":[{"portfolio_about_problem_item_text":"low consistency between data sources;"},{"portfolio_about_problem_item_text":"lack of a single repository for reporting and analytics;"},{"portfolio_about_problem_item_text":"manual report generation and dependence on individual systems;"},{"portfolio_about_problem_item_text":"limited transparency of customer patterns and loyalty processes;"},{"portfolio_about_problem_item_text":"Inhibition of initiatives from data departments due to architectural fragmentation."}],"problem_item_text_default_second":"<span style=\"font-weight: 400;\">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.<\/span>","portfolio_about_problem_image":3927,"portfolio_details_label":"Project details:","portfolio_details_title":"Key facts about the project","portfolio_details_cards":[{"portfolio_details_card_type":"text","portfolio_details_card_title":"9 months","portfolio_details_card_image":null,"portfolio_details_card_text":"Project duration"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Large","portfolio_details_card_image":null,"portfolio_details_card_text":"Project size:"},{"portfolio_details_card_type":"image","portfolio_details_card_title":"","portfolio_details_card_image":279,"portfolio_details_card_text":"Project complexity"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Completed","portfolio_details_card_image":null,"portfolio_details_card_text":"Project status:"}],"portfolio_team_label":"Our Team:","portfolio_team_members":[{"portfolio_team_member_text":"Project Manager"},{"portfolio_team_member_text":"Business Analyst"},{"portfolio_team_member_text":"Data Engineer"},{"portfolio_team_member_text":" Data Analyst"},{"portfolio_team_member_text":"Data Scientist"}],"portfolio_solution_items":[{"media_type":"image","gif_image":null,"static_image":3928,"solution_label":" Case information","solution_title":"We planned a data architecture that matches the scale of YURiA-PHARM.","solution_points":[{"point_text":"<span style=\"font-weight: 400;\">The goal of the project was to develop a unified architectural vision for the new data warehouse.<\/span>","point_has_bullet":false},{"point_text":"<b>Our approach:<\/b>","point_has_bullet":false},{"point_text":"<span style=\"font-weight: 400;\">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. <\/span>\n\n<span style=\"font-weight: 400;\">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. <\/span>\n\n<span style=\"font-weight: 400;\">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.<\/span>","point_has_bullet":false}],"button_text":"","button_url":""},{"media_type":"image","gif_image":null,"static_image":3926,"solution_label":"","solution_title":"Work results:","solution_points":[{"point_text":"<span style=\"font-weight: 400;\">We have laid the foundation on which to build a systematic, scalable, and business-oriented data architecture.<\/span>","point_has_bullet":false},{"point_text":"<b>Our client received:<\/b>","point_has_bullet":false},{"point_text":"<span style=\"font-weight: 400;\">architectural vision of the new GSH;<\/span>","point_has_bullet":true},{"point_text":"a step-by-step roadmap for implementation;","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">expert assessment of the implementation budget;<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">recommendations for the development of data infrastructure;<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">documentation agreed upon with the team.<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">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. <\/span>","point_has_bullet":false}],"button_text":"","button_url":""}],"portfolio_results_slider_type":"desktop","portfolio_results_mobile_images":null,"portfolio_results_desktop_images":[{"portfolio_results_desktop_image":4163}],"portfolio_show_feedback_button":true,"portfolio_feedback_preview_image":"","portfolio_feedback_video_url":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/\" \/>\n<meta property=\"og:site_name\" content=\"iwis\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/IWIS.UKRAINE\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-28T17:41:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/\",\"url\":\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/\",\"name\":\"Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis\",\"isPartOf\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#website\"},\"datePublished\":\"2025-11-15T22:10:38+00:00\",\"dateModified\":\"2025-11-28T17:41:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.iwis.io\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Audit of data sources and design of a new data architecture for YURiA-PHARM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#website\",\"url\":\"https:\/\/dev.iwis.io\/en\/\",\"name\":\"IWIS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.iwis.io\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#organization\",\"name\":\"IWIS\",\"url\":\"https:\/\/dev.iwis.io\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\",\"contentUrl\":\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\",\"width\":512,\"height\":512,\"caption\":\"IWIS\"},\"image\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/IWIS.UKRAINE\/\",\"https:\/\/www.linkedin.com\/company\/iwis-ukraine\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/","og_locale":"en_US","og_type":"article","og_title":"Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis","og_url":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/","og_site_name":"iwis","article_publisher":"https:\/\/www.facebook.com\/IWIS.UKRAINE\/","article_modified_time":"2025-11-28T17:41:22+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/","url":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/","name":"Audit of data sources and design of a new data architecture for YURiA-PHARM - iwis","isPartOf":{"@id":"https:\/\/dev.iwis.io\/en\/#website"},"datePublished":"2025-11-15T22:10:38+00:00","dateModified":"2025-11-28T17:41:22+00:00","breadcrumb":{"@id":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.iwis.io\/en\/results\/yuria-farm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.iwis.io\/en\/"},{"@type":"ListItem","position":2,"name":"Audit of data sources and design of a new data architecture for YURiA-PHARM"}]},{"@type":"WebSite","@id":"https:\/\/dev.iwis.io\/en\/#website","url":"https:\/\/dev.iwis.io\/en\/","name":"IWIS","description":"","publisher":{"@id":"https:\/\/dev.iwis.io\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.iwis.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dev.iwis.io\/en\/#organization","name":"IWIS","url":"https:\/\/dev.iwis.io\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/","url":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","contentUrl":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","width":512,"height":512,"caption":"IWIS"},"image":{"@id":"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/IWIS.UKRAINE\/","https:\/\/www.linkedin.com\/company\/iwis-ukraine\/"]}]}},"_links":{"self":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/3925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"version-history":[{"count":4,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/3925\/revisions"}],"predecessor-version":[{"id":4174,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/3925\/revisions\/4174"}],"acf:term":[{"embeddable":true,"taxonomy":"portfolio_category","href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category\/104"},{"embeddable":true,"taxonomy":"portfolio_category","href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category\/112"},{"embeddable":true,"taxonomy":"portfolio_tag","href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag\/113"}],"wp:attachment":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/media?parent=3925"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category?post=3925"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag?post=3925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}