Customer Name
Partner Name
We modernized TekCor4's Data Infrastructure with Scalable AWS Services, Streamlining File Processing and Seamless Migration from 20-Year-Old System
Challenge
INDUSTRY OVERVIEW
TekCor4, a technology and analytics company based in the UK. They have a CFA application which is utilized by car dealerships worldwide to gain valuable business insights pertaining to their customers, with the ultimate goal of enhancing the overall customer experience.
TekCor4 aims to empower car dealers with actionable data-driven information, enabling them to provide timely and personalized services to their customers.
CHALLENGE
- High-cost architecture with a substantial investment required in infrastructure, technology, or development resources
- Difficulty in onboarding new customers/modify the file profile of customers
- No user control at key stages of file processing & reports are more prone to error
They wanted to build a system that can effectively handle a massive influx of data from over 5,000 customers. This involves processing 200,000 files of various sizes every month, storing over 20 million documents in the database, and retaining data for 3 years.
Why were we brought in?
Ganit has made a significant dent in various industries using data science and analysis. Ganit partners with clients to translate their data into a tangible, insightful plan of action that delivers on a measurable impact to the clients’ topline & bottom-line growth.
Our approach
Solution
Ganit modernized their entire infrastructure to micro-services driven application with a data platform on AWS that can process large influx of data at scale and facilitate consumption for analytics and visualization.
An event driven architecture with the following components was built:
- AWS Transfer Family was used to pick up files uploaded by users and transfer it to Raw S3 zone on Amazon S3
- ECS cluster was spun up upon receiving a file in the Raw S3 Zone that reads the file type and data present in it to perform necessary transformation using Amazon EMR with automated scaling configured. The transformed data is stored in Curated Zone in Amazon S3
- Data from the curated zone was then loaded in Oracle hosted on AWS
- Application UI facilitates seamless onboarding of new customers and file profiles, providing access to features and processed files, while also enabling users to view processed data effortlessly
Features of the tool
- Reliable system to monitor and report any system issues or failures to maintain accurate inventory records through timely analysis and reporting of problems
- Autoscaling application to meet the spike in demand ensuring smooth operation
- Entirely templatized IaaC architecture
A valuable difference
Impact
- Process of whitelisting IP for new users has been streamlined from taking 3 days to 3 seconds
- Capability to bulk process 10000+ files within 40-60 mins as opposed to 10+ hours previously. 48 pipelines streamlined into 6 pipelines
- The cut over from the 20-year-old system to a new system ran without any errors or un-foreseen challenges
Insurance
Reducing Manual Call Audits Using GenAI for Insurance Quality Assurance
Insurance
Cutting Underwriting Decision Time Through Document Intelligence
BFSI
Improving Loan Processing Turnaround Through Automated Document Verification
RETAIL
Our data science solutions helped a major retailer reduce its wastage by 20% in Fruits and Vegetables category
RETAIL
We developed a sales forecasting engine for a CPG company in Africa leading to a 12% increase in forecast accuracy
CPG
We helped an Indonesian CPG leader realizer a 10% increase in ROI in their Promotional Strategy using Dynamic Pricing Optimized (DPO)
CPG
Our recommendation engine helped one of the largest CPG companies achieve additional 12% revenue lines for the company
HEALTHCARE & PHARMACEUTICALS
We helped a pharma leader reduce their time for drug development by cutting their initial research time by 65%
HEALTHCARE & PHARMACEUTICALS
We partnered with a leading pharmaceutical company to develop HCP Persona Analytics Engine leading to an incremental 35% lift in their engagement
BFSI
We helped an NBFC realize dynamic pricing recommendations leading to an incremental revenue lift of 3%
BFSI
We transformed portfolio management through intelligent automation with 90% reduction in man-hours
RESTAURANTS & HOSPITALITY
We partnered with one of the biggest food chains to deploy a data-driven system leading to a 22% increase in revenue
LOGISTICS
We helped a major logistic company achieve 100% if its SLA using our route optimizer & resource management solution
MANUFACTURING
We partnered with a global manufacturer to restore high quality production line
MANUFACTURING
We helped a leading manufacturer manage its production lines and reduce downtime due to unplanned stoppage
SUPPLY CHAIN
We helped an enterprise improve supply chain visibility and enable real-time decision-making across operations
ENERGY & UTILITIES
We helped a leading utility automate customer service workflows, reducing response time and operational effort
BFSI
Reducing Knowledge Search Time Using Enterprise RAG for BFSI Operations
Insurance
Automating Medical Claims Adjudication to Reduce Processing Time and Manual Effort
Insurance
Reducing Manual Call Audits Using GenAI for Insurance Quality Assurance
Insurance
Cutting Underwriting Decision Time Through Document Intelligence
BFSI
Improving Loan Processing Turnaround Through Automated Document Verification
RETAIL
Our data science solutions helped a major retailer reduce its wastage by 20% in Fruits and Vegetables category
RETAIL
We developed a sales forecasting engine for a CPG company in Africa leading to a 12% increase in forecast accuracy
CPG
We helped an Indonesian CPG leader realizer a 10% increase in ROI in their Promotional Strategy using Dynamic Pricing Optimized (DPO)
CPG
Our recommendation engine helped one of the largest CPG companies achieve additional 12% revenue lines for the company
HEALTHCARE & PHARMACEUTICALS
We helped a pharma leader reduce their time for drug development by cutting their initial research time by 65%
HEALTHCARE & PHARMACEUTICALS
We partnered with a leading pharmaceutical company to develop HCP Persona Analytics Engine leading to an incremental 35% lift in their engagement
BFSI
We helped an NBFC realize dynamic pricing recommendations leading to an incremental revenue lift of 3%
BFSI
We transformed portfolio management through intelligent automation with 90% reduction in man-hours
RESTAURANTS & HOSPITALITY
We partnered with one of the biggest food chains to deploy a data-driven system leading to a 22% increase in revenue
LOGISTICS
We helped a major logistic company achieve 100% if its SLA using our route optimizer & resource management solution
MANUFACTURING
We partnered with a global manufacturer to restore high quality production line
MANUFACTURING
We helped a leading manufacturer manage its production lines and reduce downtime due to unplanned stoppage
SUPPLY CHAIN
We helped an enterprise improve supply chain visibility and enable real-time decision-making across operations
ENERGY & UTILITIES
We helped a leading utility automate customer service workflows, reducing response time and operational effort
BFSI
Reducing Knowledge Search Time Using Enterprise RAG for BFSI Operations
Insurance
Automating Medical Claims Adjudication to Reduce Processing Time and Manual Effort
Insurance
Reducing Manual Call Audits Using GenAI for Insurance Quality Assurance
Insurance
Cutting Underwriting Decision Time Through Document Intelligence
BFSI
Improving Loan Processing Turnaround Through Automated Document Verification