{"id":73117,"date":"2025-12-17T05:41:58","date_gmt":"2025-12-17T05:41:58","guid":{"rendered":"https:\/\/www.cloudthat.com\/resources\/?post_type=resources&#038;p=73117"},"modified":"2025-12-17T05:41:58","modified_gmt":"2025-12-17T05:41:58","slug":"scheme-letter-automation-delivers-5x-speed-boost-and-90-accuracy-for-paint-manufacturer","status":"publish","type":"resources","link":"https:\/\/www.cloudthat.com\/resources\/case-study\/scheme-letter-automation-delivers-5x-speed-boost-and-90-accuracy-for-paint-manufacturer","title":{"rendered":"Scheme Letter Automation Delivers 5x Speed Boost and 90% Accuracy for Paint Manufacturer"},"content":{"rendered":"<p>Established as part of a major industrial group&#8217;s diversification into the paints industry, the company has rapidly emerged as a modern, technology-driven brand committed to transforming the decorative and industrial coatings market in India. Headquartered in Mumbai, the company emphasizes transparency, innovation, and customer-first principles in its product and service offerings.<\/p>\n","protected":false},"author":325,"featured_media":73118,"parent":0,"template":"","cat_resources":[6],"technology":[32],"published_by":"325","primary-authors":["225","633","488"],"secondary-authors":["325"],"acf":{"banner_image":73120,"resources_label":"","download_url":"https:\/\/content.cloudthat.com\/resources\/wp-content\/uploads\/2025\/12\/JSW_Two_Pager_CaseStudy.pdf","client_logo":"","highlights":{"first_part":{"icon":336,"title":"5x","subtitle":"Improvement in Data Processing Speed"},"second_part":{"icon":335,"title":"90%","subtitle":"Improved Accuracy"},"third_part":{"icon":334,"title":"70%","subtitle":"Reduction in Manual Effort"}},"the_challenge":"The paint manufacturing company faced operational inefficiencies in processing scheme letters and calculating dealer bonuses due to documents in various formats requiring manual data extraction. Without intelligent OCR, frequent errors occurred in identifying product names, bonus slabs, and regions, while product naming variations complicated validation against master datasets. These mapping errors affected bonus computations, causing delays, disputes, and payout inconsistencies. Heavy manual effort was required for generating transactional files, necessitating an automated solution to extract accurate data from unstructured documents while reducing turnaround time and operational dependencies.","client_testimonial":{"image":"","description":"","author":""},"solutions":"\u2022 Implemented automated ingestion workflow for scheme letters (PDF\/JPG\/PNG\/JPEG) and datasets in Amazon S3, triggering OCR processing pipeline\r\n\u2022 Developed AWS Lambda functions for file preprocessing and Amazon Bedrock Claude Sonnet model invocation to extract structured OCR data\r\n\u2022 Built a two-step validation engine using AWS Lambda to match extracted product names and regions with master datasets using fuzzy similarity checks\r\n\u2022 Designed AWS Glue Crawlers and ETL Jobs to detect processed OCR files, update Data Catalog, and transform results into transactional and bonus calculation files\r\n\u2022 Implemented JSON-based mapping framework to resolve product naming variations and apply correct bonus logic for OCR-extracted names\r\n\u2022 Stored and transformed outputs, including transactional files, similarity results, and bonus datasets, in Amazon S3 for downstream reporting\r\n\u2022 Enabled business users to query validated data using Amazon Athena for serverless SQL-based analytics and insight generation\r\n\u2022 Integrated Amazon SNS for alerting on AWS Glue job failures and real-time pipeline monitoring","the_results":"Transformed scheme letter processing through end-to-end automation, achieving 90% mapping accuracy, 70% manual effort reduction, 5\u00d7 processing speed improvement, and 60% operational support reduction with proactive monitoring.","about_client_left_side":[{"field_63315a4dc06e1":"15085","field_63315a5bc06e2":"Industry\u00a0","field_63315a61c06e3":"Manufacturing"},{"field_63315a4dc06e1":"15083","field_63315a5bc06e2":"Expertise\u00a0","field_63315a61c06e3":"Amazon S3, Amazon SQS, Amazon Bedrock, AWS Lambda, Amazon Athena, Amazon SNS"},{"field_63315a4dc06e1":"15084","field_63315a5bc06e2":"Offerings\/solutions\u00a0","field_63315a61c06e3":"Automated scheme letter processing with enhanced validation, reduced effort, and faster processing"}]},"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/73117"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources"}],"about":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/types\/resources"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/users\/325"}],"version-history":[{"count":1,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/73117\/revisions"}],"predecessor-version":[{"id":73124,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/resources\/73117\/revisions\/73124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media\/73118"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media?parent=73117"}],"wp:term":[{"taxonomy":"cat_resources","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/cat_resources?post=73117"},{"taxonomy":"technology","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/technology?post=73117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}