{"id":4431,"date":"2025-12-05T12:45:48","date_gmt":"2025-12-05T12:45:48","guid":{"rendered":"https:\/\/dev.iwis.io\/?post_type=portfolio&#038;p=4431"},"modified":"2025-12-08T09:30:15","modified_gmt":"2025-12-08T09:30:15","slug":"skarbnytsia-2","status":"publish","type":"portfolio","link":"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/","title":{"rendered":"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem."},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"footnotes":""},"portfolio_category":[112],"portfolio_tag":[114],"class_list":["post-4431","portfolio","type-portfolio","status-publish","hentry","portfolio_category-business-intelligence-bi","portfolio_tag-business-intelligence-bi"],"acf":{"portfolio_project_image":4434,"portfolio_project_description":"Skarbnytsia is the largest network of pawnshops in Ukraine, which has been engaged in private lending since 1992. The brand has over 400 branches in 97 cities.  ","portfolio_project_tags":[114],"portfolio_project_url":"","portfolio_categories":[112],"portfolio_featured_project":false,"portfolio_about_label":"About the project","portfolio_about_title":"Transformed a large volume of historical transactional data into a transparent and manageable decision-making system","portfolio_about_description":"Skarbnytsia is the largest pawnshop chain in Ukraine, which has been engaged in private lending since 1992. The brand has over 400 branches in 97 cities. The company operates on the basis of its own CRM system. It offers high standards of service to its customers. In addition, it has a modern mobile application and loyalty programs. Skarbnytsia is constantly modernizing the industry and introducing innovations. The team proves that financial support can be fast, affordable, and secure at the same time.      ","portfolio_about_problem_title":"The client's problem","problem_item_text_default":"<span style=\"font-weight: 400;\">The customer approached us with a request to develop a data warehouse. The brand was operating on an outdated ERP system. It did not meet modern requirements for analytics and scaling. Large arrays of historical transactions were stored in it without the possibility of export and integration. In addition, they were not synchronized with modern data tools. <\/span>\r\n\r\nOur client was unable to work with key data areas, in particular:","portfolio_about_problem_items":[{"portfolio_about_problem_item_text":"launching user segmentation;"},{"portfolio_about_problem_item_text":"building personalized communication."}],"problem_item_text_default_second":"<span style=\"font-weight: 400;\">Our main task was to develop a mechanism that would allow us to fully utilize data for business development.<\/span>","portfolio_about_problem_image":4434,"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":"12 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":"Backend Developer"},{"portfolio_team_member_text":"DevOps Developer"}],"portfolio_solution_items":[{"media_type":"image","gif_image":null,"static_image":4433,"solution_label":" Case information","solution_title":"Data transformation at Skarbnytsia has become a strategic asset for business development ","solution_points":[{"point_text":"<span style=\"font-weight: 400;\">Our team created a centralized data warehouse for analytics for Ukraine's largest pawnshop network.<\/span>","point_has_bullet":false},{"point_text":"<b>Our approach:<\/b>","point_has_bullet":false},{"point_text":"<span style=\"font-weight: 400;\">We began our work with a detailed analysis of the client's strategic goals and wishes. After that, we set about describing all existing IT systems, their limitations, interrelationships, and real possibilities for working with data. Next, we formed an architectural vision for the case. <\/span>\r\n\r\n<span style=\"font-weight: 400;\">The next step was to create a set of technological tools that effectively support business goals. After agreeing on the budget and architecture, we moved on to building a centralized data warehouse based on Microsoft solutions. Then we transferred the project to a Time &amp; Material model, which allowed us to easily respond to technical risks and adjust our work in real time. <\/span>","point_has_bullet":false}],"button_text":"","button_url":""},{"media_type":"image","gif_image":null,"static_image":4432,"solution_label":"","solution_title":"Work results:","solution_points":[{"point_text":"<span style=\"font-weight: 400;\">Working together with the customer's IT team yielded excellent results. We developed a scalable data warehouse, laying the foundation for all future analytical initiatives. Key achievements: <\/span>","point_has_bullet":false},{"point_text":"<span style=\"font-weight: 400;\">implemented bronze and silver levels of data storage; <\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">set up automatic rules for updating indicators; <\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">introduced quality and consistency checks;<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">reduced the dependence of ETL processes on changes in Legacy ERP;<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">increased the flexibility and stability of the entire architecture.<\/span>","point_has_bullet":true},{"point_text":"<span style=\"font-weight: 400;\">As a result, the customer received a reliable and effective platform that allows them to confidently move towards data-driven solutions.<\/span>","point_has_bullet":false}],"button_text":"","button_url":""}],"portfolio_results_slider_type":"desktop","portfolio_results_mobile_images":null,"portfolio_results_desktop_images":null,"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>Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - 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\/skarbnytsia-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - iwis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/\" \/>\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-12-08T09:30:15+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\/skarbnytsia-2\/\",\"url\":\"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/\",\"name\":\"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - iwis\",\"isPartOf\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#website\"},\"datePublished\":\"2025-12-05T12:45:48+00:00\",\"dateModified\":\"2025-12-08T09:30:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.iwis.io\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem.\"}]},{\"@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":"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - 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\/skarbnytsia-2\/","og_locale":"en_US","og_type":"article","og_title":"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - iwis","og_url":"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/","og_site_name":"iwis","article_publisher":"https:\/\/www.facebook.com\/IWIS.UKRAINE\/","article_modified_time":"2025-12-08T09:30:15+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\/skarbnytsia-2\/","url":"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/","name":"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem. - iwis","isPartOf":{"@id":"https:\/\/dev.iwis.io\/en\/#website"},"datePublished":"2025-12-05T12:45:48+00:00","dateModified":"2025-12-08T09:30:15+00:00","breadcrumb":{"@id":"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.iwis.io\/en\/results\/skarbnytsia-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.iwis.io\/en\/"},{"@type":"ListItem","position":2,"name":"Case study: Skarbnytsia, a company with over 400 branches, transitioned from a legacy system to a scalable data ecosystem."}]},{"@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\/4431","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":1,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/4431\/revisions"}],"predecessor-version":[{"id":4439,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/4431\/revisions\/4439"}],"acf:term":[{"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\/114"}],"wp:attachment":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/media?parent=4431"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category?post=4431"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag?post=4431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}