Service_Category: Functional Testing

Demand Forecasting for Manufacturing with Real-Time Demand Visibility

Case Study

Demand Forecasting for Manufacturing with Real-Time Demand Visibility

Overview

For manufacturers, the ability to fulfill demand into the future is one of the top priorities for the operations managers. However, it still remains a challenge to see the future demand in a manner that aids the manufacturing process. Using Salesforce, manufacturers can only document or identify details of any specific order in the pipeline.

Ideally, manufacturers also need to see the material that goes into an order and the status of their procumbent to execute the order. A typical Salesforce-based system would not help look into the concerns of production demand. It would only consider the items included on a completed Sales Order, which does not give an accurate picture of the cycle time. An accurate view of the cycle time is, therefore, essential to predict the amount of time required for a process to produce one unit.

 

Our Solution

  • A cloud-driven self-service feature makes it very easy for employees to upload data remotely
  • Managers can see the gaps in the supply chain in advance to make timely adjustments
  • A unified view of the supply chain brings the ability to anticipate shifts in demand and adjust production and inventory levels accordingly
  • Material forecasting based on the demand helps identify potential supply disruptions or quality issues early
  • It helps managers to make alternative sourcing or contingency plans for sourcing of raw materials
  • A forecasting dashboard makes it easy to analyze lead times of raw materials and components ordered to fulfill the production demand
  • Forecasts on lead time variability and potential delays helps managers plan production schedules and buffer inventory levels
  • Forecasts on labor requirements can be made using historical data and project-based estimations fed into the system by managers
  • Based on past supplier experience and logistical experience managers can rate vendors
  • Easily create models to analyze this historical data and detect patterns that indicate future supply chain gaps
  • Feed real-time logistical tracking data into the system to monitor shipments and address any transportation-related gaps

Challenges

  • It was a challenge to determine how many labor hours would be required to fulfill each SKU in the demand pipeline
  • to The Standalone Salesforce dashboards are unable to provide forecasts at the account, product, or territory level
  • The decision-makers in the organization were unable to see data relevant to their objectives
  • Forecasts of parameters such as quotes, orders, account opportunities, contracts, etc., were not available
  • Legacy systems are unable to fetch external data into Salesforce to create comprehensive forecasts
  • Some SKUs have short lead times, making it crucial to have real-time or near-real-time demand forecasting
  • Existing systems were unable to flag unreliable suppliers or any other disruptions in the supply chain
  • Capturing data related to regulations, customs, and market conditions in different regions was not possible

How we Can Help

  • We can build and implement a Machine Learning Prediction Model based on historical data, supply chain data, and other 3rd party data
  • Build models to predict demand based on calculations on the lead times of the suppliers and logistics partners
  • Create different tables and tranches to store data for each SKU separately and capturing the entire production cycle
  • Integrate Machine Learning Models to use each SKU production-cycle data for building multiple forecasts
  • Capture data by monthly and weekly inventory demand by individual products, raw materials, suppliers, etc.

The Impact

  • Operations Managers can save 30 hours of production data entry tasks
  • Automated data processing saves 200 man-hours of effort in reporting
  • Data-grounded predictive analytics on inventory requirement into the future
  • Automated Inventory optimization helps prevent unnecessary overstocking
  • SKU-wise and location-wise pricing optimization can be done in a few clicks

BFSI Case Studies: Discover the Top Applications of Contract AI in Banking and Insurance Companies

Discover the Key Benefits Unlocked by Global BFSI Leaders.

Download BFSI Case Studies

Contact Your Solutions Consultant!

Automate Manual Trade Finance and Commercial Banking Processes

Case Study

Automate Manual Trade Finance and Commercial Banking Processes

Overview

When you think of international trade, it is mostly underpinned by transactions that takes place between importers and exporters of goods. The banking system plays a key role here as an arbitration channel that helps manage both the parties to conduct business within acceptable terms. It therefore involves international trade regulations, foreign exchange rates, and more.

This requires procedures such as opening an account and securing Letters of Credit (LOC) whereby the buyer’s bank provides the seller a guarantee to make the agreed payment on behalf of the buyer. The Bank therefore needs to assess Contract Documents, KYC Documents, Mortgage Documents, etc., to evaluate the creditworthiness liquidity/guarantee seekers. Timely evaluation of the risks can help the bank’s treasury management team to perform their tasks faster.

New-age Banks therefore need Contract AI assistants and digital worker bots to help their time-deficient Treasury Management teams. It will help them capture data accurately from multiple documents and input them accurately in tranches where they need to be. 

Our Solution

  • Build a ranking engine using Machine Learning to rank and analyze large volumes of trade transactions
  • Get a unified view of risks involving – Outstanding Advances, CLP Commitments, Collateral Availability, Unsecured Credits, etc.
  • Automate document processing, text analytics, and third-party data
  • Automate ingesting ID & income verification documents
  • Automate data extraction from unstructured texts like mortgage papers, bonds, security guarantees
  • Built a centralized interface can save 20 working days worth of man hours per month
  • Automate amortization of borrowing costs, amortization schedules
  • Automate the posting of treasury accounting data entry
  • Automate review of +100000 transactions every month via ML models
  • Cover regional and country-specific compliance requirements

Challenges

  • Missing or incorrectly prepared documents pose risk for both buyers and sellers
  • Manual data extraction and validation can cause shipment delays and ultimately delayed payments
  • Manual Treasury Management may require 20+ accountants a day, per month to extract data manually.
  • More team members are required to process Bank Guarantees and Letters of Credits for multiple fund categories (can go up to 25 for large banks)
  • Treasury calculations such as accruals on debt, derivatives, and fees, and amortization can be erroneous
  • The manual process can require producing of over 5,000 lines of GL journals per month

How we Can Helped

  • Integrates a document parser solution within the Bank’s workflows
  • Creates a pulling trigger to fetch parsed data from new documents
  • Triggers automation to start a workflow anytime a new document is parsed e.g., a collateral bond
  • Triggers automation of all processes which are expecting data from e.g., a PDF document
  • Fetches parsed data from and adds new rows in Google Sheets or in any System used by employees
  • Enables automation to fetch documents from a shared DropBox or a Google Drive
  • Automates selecting parsing rules to process the document and search for the required information

The Impact

  • Gain a 500% Increase in Contract Scanning Speed
  • Enable accurate data capture with 95%+ Straight-Through Processing (STP)
  • Ensure the Treasury Team does not have to look at risk assessment documents 95 out of 100 times

BFSI Case Studies: Discover the Top Applications of Contract AI in Banking and Insurance Companies

Discover the Key Benefits Unlocked by Global BFSI Leaders.

Download BFSI Case Studies

Contact Your Solutions Consultant!

New Application Interface to Automate Letter of Credit (LOC) Issuing Processes

Case Study

New Application Interface to Automate Letter of Credit (LOC) Issuing Processes

Overview

A large financial institution from the US wanted to streamline the process of issuing Letter of Credits (LOCs) to its member banks. These banks were its partners who were depending on its support for liquidity, asset/liability management, and housing, community, and economic development activities. An L/C acts as a promise made by the Bank on behalf of the member to make payments to a third-party beneficiary in the event of a default of performance.  

The daily tasks for the Bank’s employees involved generating several reports: Daily Reports, General Ledger Reconcilement Reports, Daily Transaction Journal Repot, Amortization of Fees, Commitment listing Report, Commitment Summary Report, etc. The older legacy platform made it difficult for the Bank’s employees to perform reconciliations at the end of the day by matching the member bank’s commitment request details, tracing the changes, and finally tallying it with the commitment. The commitment amount mentioned in the LOC is issued after multiple credit check processes. 

The legacy application interface was build using PowerBuilder and migration to Java brought the flexibility required to add new automation capabilities. The migration makes it easy for the bank to make rapid changes in its framework while supporting an open, flexible platform development environment. Using Sun Technologies’ automated migration tools, our Solution Architects completed the project in rapid sprints to successfully launch the new application. It has helped convert all PowerBuilder app functionalities to a Java-supported modern web architecture and interface. 

Our Solution

  • The newly deployed interface allows batch processing for issuing multiple LOCs in one click 
  • The process of notifying the customer closer to the data of renewal has been automated 
  • Digital Bots are helping the Bank’s auditors fetch the required information easily 
  • Auditors can now generate daily and monthly commitment summaries with a simple click 
  • Users can view Renewed Commitments, Commitments to be Renewed and Changes to Renewal Amount, Amortization Fees, etc. 
  • Approval dashboards give administrators the ability to get Pending/Approved/Rejected/Failed commitments in one-click 
  • Approvers get a single dashboard view of all the information needed: Commitment Type, Original Balance, and Status 
  • Auditors can easily view Outstanding Advances, Collateral Availability, Financial Guarantees, Interest Rate Swaps, and Unsecured Credits 
  • The new application streamlines complex processes involving generation of reports such as Transaction Enquiry Report, Transaction Journey Report, Transaction Journal Reports, Financial Guarantee Reports
  • Automation helps to automatically re-calculate fees based on modifications made to the contract
  • The system automatically calculates the credit rate and maturity date
  • Easy Credit Assessment and Analysis feature gives a single pane view of – Collateral, Outstanding Advances, Unsecured Credit, Guarantees, and more.

Challenges

  • Errors in data inputs of credit rates, maturity dates, renewal fees, and related changes.
  • Errors caused by frequent screen changes and switching to new folders in a clunky User Interface
  • Audit reports required double-checks before a Letter of Credit is issued.
  • Auditors had to look through multiple folders to get the required information.
  • Processing large volumes of Letter of Credit (LOC) request documents and collateral pledges caused delays
  • Processing large volumes of Commitment Linkage Changes required more resources
  • Amending large amounts of Commitment Linkage Details required more manual time and effort
  • Error-prone processes to in linking multiple LOCs with Member bank deposits 
  • Monitoring/Adjusting multiple Letter of Credit requests from a Member Bank was a tedious task

How we Helped

  • Our solution architects helped retire the legacy interface used by the Bank’s employee 
  • Smooth transition was made to a new application portal for all PowerBuilder functionalities 
  • Enhanced the security and auditing functionality aligned with user roles and permissions 
  • Manual processes involving queries and generating reports were automated using a RPA Bot 

The Impact

  • 80% faster turnarounds in issuing LOCs
  • 95% tasks related to data retrieval and calculations are automated
  • 75% savings in Auditor’s time spent on manual data collation from multiple systems

BFSI Case Studies: Discover the Top Applications of Contract AI in Banking and Insurance Companies

Discover the Key Benefits Unlocked by Global BFSI Leaders.

Download BFSI Case Studies

Contact Your Solutions Consultant!

Automate Pricing Computation and Optimization for SKUs with AI for Inventory Scenario Planning

Use Case

Automate Pricing Computation and Optimization for SKUs with AI for Inventory Scenario Planning

Overview

A typical challenge faced by most retail manufacturers is often due to information being captured differently by their field service management software, ERP, and CRM. Due to an absence of cohesion between different systems, most Retail and FMCG manufacturing companies can’t identify clients, respond to changes in the demand, or address customer trends on time.

Sun Technologies’ solution architects are partners to some of the largest retailers in the US for solving this problem. Our experts are able to show retailers how a mixed bag of technology can be made more cohesive using workflow automation to distinguish between – active customer interest, customer demand, online buyers, and payers.

Our award-winning RPA solution is helping top Fortune 500 companies to accelerate the following:

Financial Planning

Resource Allocation

Expense Control

Performance Evaluation

Decision Making

Goal Alignment

Cash Flow Management

Contingency Planning

Demand Planning

Inventory Management

Production Scheduling

Resource Allocation

Sales and Marketing Strategies

Budgeting and Financial Planning

New Product Launch

Campaign plans

Replace or automate human touch with robotic bots and software at significantly lower costs. Join us for a quick-sprint workshop that will leave you inspired with real RPA use cases that will – Reduce turnaround times by 80%, improve productivity using the same resources by 200%, reduce spending on IT resource and licensing by 50%.

Our Solution

  • The new system is much more efficient and easier to develop and maintain. The on-boarding process for new clients is also now much easier and faster.
  • Our initial diagnosis can reveal opportunities in automating spreadsheet inputs that can result in incorrect invoicing, inaccurate inventory reporting, discrepancies in deal pricing, and wrong shipping details.
  • A rigorous order management system can be easily set-up for non-technical users using automated, multi-level interventions and workflow routing
  • Cascading workflows were created to ensure that data entered once need not require manual input in another system, once again
  • Implemented one source of the truth to view all historical data related to sales, supply-chain, customer segments, and more
  • Placed predictive algorithms for analysing the impact of price change, discounts, and stocks in transit or in production
  • Implement algorithms to enable effective assortment planning and tailoring inventories to meet the demand of specific customer segments
  • Enable end-to-end visibility by combining all ERP, CRM, and data spread over different tools you can significantly reduce lead-times

Challenges

  • Product portfolio restructuring is done by combining multiple spreadsheets manually
  • Poor master data management was causing mistakes in demand planning
  • Retail operations either faced excessive inventory or had to deal with stockouts
  • Inability to take timely decisions for pricing change or to ensure sufficient stocks
  • Orders valued in millions are placed on hold monthly due to manual order management
  • Losses due to manual process for refactoring stock availability after order cancellations

How we can help

  • By deploying AI-driven models, you can identify optimal product offers for category or SKU bundle
  • Automate the analysis of data such as past sales, customer demographics, and competitor offerings
  • We can help you to established a governance framework that will help devise forecasting strategies based on your profit objectives and thresholds
  • Upgrade to microservices and leverage the cloud. This will bring all critical data and visibility in one place
  • Create forecasting and data views that are easy to maintain while handling large data volumes
  • Because the demand calculation flow consists of particular ‘steps’, our experts can separate existing logic and created a microservice for each one
  • Connect and integrate data that’s spread in systems such as – AWS, SAP, Oracle, Tally, Outlook, G-Suite, Sharepoint, and more
  • Data from files will be divided into chunks that are sent and processed using user validations as required by the business
  • We will also develop an internal balancer that ensures messages are processed using logic and database as required

Download Complete Forecasting, Budgeting, and Demand Planning Checklist for FMCG
and Retail Leaders

The top choice of Fortune 500 Finance and Operations leaders.

Download Forecasting Automation Guide

Contact Your Solutions Consultant!

Automate Demand Forecasting and Planning in FMCG and Retail

Use Case

Automate Demand Forecasting and Planning in FMCG and Retail

Enable savings in millions with predictive order fulfillment forecasting and real-time sales visibility

By using demand forecasting automation, you can become 400% faster speeds in predicting demand for particular products or services. This generally entails looking at specific data sets that characterize inventory status and sales to estimate all future needs. 

Forecasting automation can also help maximize profits by speeding-up the cycle-time for predicting inventory of high-demand products and preventing the depletion of high-demand product stocks. 

Using Sun Technologies’ award-winning workflow automation solutions, you can implement an end-to-end automated, demand forecasting process. The solution can be easily integrated into any aspect of your operations – email, ERP, CRM, Databases, etc. to provide prediction for all SKUs with impeccable accuracy. 

Our award-winning RPA solution is helping top Fortune 500 companies to accelerate the following:

Order Management

Warehouse Management

Distribution Management

Retail Planning

Microsoft Dynamics Integration

Sage Integration

NetSuite Integration

Quickbooks Integration

Multi-entity Accounting

Project Accounting

Production Scheduling

Resource Allocation

Sales and Marketing Forecasting

Budgeting and Financial Planning

New Product Launch

Campaign plans

Replace or automate human touch with robotic bots and software at significantly lower costs. Join us for a quick-sprint workshop that will leave you inspired with real RPA use cases that will – Reduce turnaround times by 80%, improve productivity using the same resources by 200%, reduce spending on IT resource and licensing by 50%.

Our Solution

  • Automate Data Collation: Engineer an automated data pipeline to collect and cleanse the data 
  • Machine Learning: Use machine learning techniques to predict the demand for specific product SKUs 
  • Data Integration: Gather data from various sources, including customer usage patterns, historical sales, market trends, and competitor information 
  • Advanced Analytics: Implement advanced analytics techniques like time series forecasting and predictive modelling to capture demand patterns accurately 
  • Segmentation: Categorize customers based on usage, demographics, and preferences to create more accurate forecasts
  • Collaboration: Collaborate with marketing and sales teams to gather insights on upcoming promotions, offers, and campaigns that may impact demand
  • External Factors: Consider external factors like economic indicators, competitor moves, and technological advancements that influence demand

Challenges

  • High volume of historical data from sales and inventories for each SKU and distribution channel 
  • Disparate systems with different aggregation logic that add to the complexity of predicting demand 
  • Predicting demand for new products/models that do not have any history in the market 
  • Allocating better inventory of models to optimize overall cost structure 
  • Forecasting demand for products at the SKU level 
  • Predicting future trends for every model at the SKU level 
  • Find a way to cull appropriate data from relevant data sets 
  • Not having a consistent method of identifying devices across systems

Our experts will create a roadmap for demand forecasting automation based on:

  • Current state of affairs and future plans
  • Analyzing system limitations vs. Order Management process automation needs
  • Identifying the best UI/UX for Data input, data visualization, and demand forecasting dashboards that also connects with users’ spreadsheet-driven processes

How we will automate demand forecasting processes

  • We use our expertise of legacy systems to recommend the most cost-optimized way for realizing automation
  • We use our expert diagnosis to quickly gain an understanding of your multiple SKU, Styles, Stores, and more
  • We analyze the manual dependencies in your process to get the required information for inventory forecasting

Download Complete Forecasting, Budgeting, and Demand Planning Checklist for FMCG
and Retail Leaders

The top choice of Fortune 500 Finance and Operations leaders.

Download Forecasting Automation Guide

Contact Your Solutions Consultant!

Automate Budgeting and Forecasting in FMCG and Retail

Use Case

Automate Budgeting and Forecasting in FMCG and Retail

Overview

We specialize in automating Demand Forecasting and CAPEX/ OPEX Planning for diverse industries. Our solution architects are building automation layers that pull data from e-mails, POS, CRM, CDP, ERP, warehouses, documents, files, folders, and any device – to create automated forecasting & planning workflows.

Without proper financial models and technology in place, it is hard for business leaders to keep a track of overhead and business costs. Sun Technologies’ workflow automation layering and data connectors represent the fastest way to gain valuable insight into how its business activities impact the bottom line.

Our award-winning RPA solution is helping top Fortune 500 companies to accelerate the following:

Financial Planning

Resource Allocation

Expense Control

Performance Evaluation

Decision Making

Goal Alignment

Cash Flow Management

Contingency Planning

Demand Planning

Inventory Management

Production Scheduling

Resource Allocation

Sales and Marketing Strategies

Budgeting and Financial Planning

New Product Launch

Campaign plans

Replace or automate human touch with robotic bots and software at significantly lower costs. Join us for a quick-sprint workshop that will leave you inspired with real RPA use cases that will – Reduce turnaround times by 80%, improve productivity using the same resources by 200%, reduce spending on IT resource and licensing by 50%.

Our Solution

  • Automate enterprise-wide data consolidation made possible by ETL (extract, transform, load) process integration
  • Enable collaboration between the finance team and the operations team
  • Complete training and hand-holding assistance for all budget owners using the forecasting template
  • Implement a monthly rolling forecasting system to replace a static budgeting process
  • Enable scenario modelling by ensuring timely sales, costs, and revenue inputs from different business lines
  • Get dedicate experts to ensure all non-technical users learn to do their part I the automation workflow action triggers and next steps
  • Consolidate the entire transaction database covering millions of transactions, pricing values, locations, SKUs, and business lines
  • Get an innovative layer that consolidates transaction-level details from multiple models into a whole new analytical representation

Challenges

  • Considerable overhead costs and no visibility to allocate the cost out to each business line
  • Manual dependency to input data from different teams – Finance, Operations, Supply Chain, Procurement, Sales, Marketing, Customer Service, etc.
  • Manual tracking of the entire budgeting lifecycle from scratch
  • Manual pulling of data from disparate systems and databases
  • Manual routing of spreadsheet to other team members for validation
  • Multiple spreadsheet versions and inability to collaborate
  • Inability to do accurate forecast scenario modelling
  • Manual mapping of data sets to run comprehensive reports
  • Manual currency conversions and lack of ownership
  • Cost of employing resources to import, export, and input such data

Our experts will help uncover key forecasting and budgeting processing opportunities based on:

  • Current state of affairs and the IT landscape
  • Understanding of how many different tools and apps different users navigate to get any required information
  • How many exchange of hands takes place and how many manual dependencies are there for any type of forecast
  • System limitations/ Accounting process improvements required
  • Current Budgeting/Forecasting Process
  • Understanding current reporting tools and how it is used for manual spreadsheet and email, and/or chat driven reporting and report sharing
  • Financial Operations Pain Points and Difficulties with the use of spreadsheets

Our forecasting automation implementation approach

  • We use our expertise of legacy systems to recommend the most cost-optimized way for realizing automation
  • We use our expert diagnosis to quickly gain an understanding of your multiple business lines, budget owners, and the different tools used to collect data
  • We analyze the manual dependencies in your process to get the required information for cash-flow forecasting

Download Complete Forecasting, Budgeting, and Demand Planning Checklist for FMCG
and Retail Leaders

The top choice of Fortune 500 Finance and Operations leaders.

Download Forecasting Automation Guide

Contact Your Solutions Consultant!

Intelligent documentation software for a hands-free and automated Contract Lifecycle Management

Use Case

Intelligent documentation software for a hands-free and automated Contract Lifecycle Management

Key objectives you can fulfill

Eliminate financial loss:

Prevent revenue leakage – overpayments, dispute resolution, and support costs.

Eliminate off-contract spend:

Get more visibility to effectively manage spend and avoid spend leakage

Improve Compliance:

Reduce risk exposure, improve governance, comply with agreed terms

Faster contract cycles:

Close contracts faster, remove bottlenecks and inefficiencies

Improve customer experience:

Meet all contract SLAs to meet customer expectations

 

Example of Intelligent Document Automation in action

Our Solution

  • Effective supplier governance
  • Streamlined supplier performance monitoring
  • Set-up timely supplier reporting
  • Centralized contracts in a structured format to enable quick computation, validation, comparison, and analytics.
  • Automated obligations management, SL management, invoice auditing, and value tracking against contracted business case.
  • Enabled effective management of supplier risks and issues on a single platform
  • Enhanced compliance through automated compliance tracking

Challenges

  • Compliance Management
  • Obligation Management
  • Risk Management
  • Performance Management
  • Relationship management
  • Essential reviews/approvals skipped for speed
  • Long approval cycles lead to delays
  • Tedious manual tasks result in errors and higher risks
  • Resubmissions for contract amendments often missed
  • Missing or incorrect customer, invoice data
  • Missing invoices or incorrect recipients
  • Poorly constructed invoices, invalid schema/format
  • Lack of visibility and tracking for internal teams

Impact you can on-board

  • 44% reduction in manual supplier governance efforts
  • 42% reduction in person days spent on manual contract management
  • 42% reduction in person days spent on manual Performance Management
  • 49% reduction in person days spent on manual Financial Management
  • 44% reduction in person days spent on manual Relationship Management

How we can help

  • Integrate the entire IT environment with the intelligent documentation program
  • Enable auto extraction, auto-intake, and auto-population of all the required information.
  • Integrate document automation workflow designer with different data sources including emails, ERP, CRM, CDP tools, files, folders, and shared storages
  • Enable the automation workflow to auto-generate parts of required content and data
  • Enable auto-generation to create POs, invoices, contract renewals, quotations, and more
  • Set up event-triggers, routing, and cascading workflows that mirror the documentation process
  • Create buttons in and collaboration tool, e.g. slack for a timely review and approvals
  • Create data map for data extraction from a tool e.g. Salesforce leading into an event trigger
  • Create audit tables to keep track of when and to whom any information is sent
  • Also track the progress or lifecycle of a contract and set up reminders for renewals, quality checks, etc.

Take a look at these high-priority workflows that are fit for document automation.

The top choice of Fortune 500 Finance and Operations leaders.

Download Document Automation Workflow Guide

Contact Your Solutions Consultant!

Reimagining UI/UX for a large bank to modernize advance transfer processing and transactions

Case Study

Reimagining UI/UX for a large bank to modernize advance transfer processing and transactions

Overview

A large US-based community bank wanted to reimagine user experience offered to their network member banks and community lenders. Sun Technologies helped build an online platform that enables authorized users from member banks to remotely and securely obtain account balances and perform business transactions (Advances, Wire Transfers and Book Wires).

While the bank wanted to modernize online banking experience for the end-users using the latest technologies such as Representational State Transfer (REST) Application Programming Interface, their legacy backend was built on Service Oriented Architecture Protocol (SOAP).  and the other with traditional frameworks. After examining the time taken by the techniques to render the web page to the user, and the availability and scalability of the software, we will understand the need for the new technologies in the banking and financial sectors.

The time taken by the legacy framework to render the web page to the user was a challenge that made the migration necessary. Modernizing, upgrading, and supporting the legacy applications is an extremely time-consuming, expensive, and risk-prone process. Sun Technologies helped the bank to connect the banks legacy data and framework with a modern UI/UX.

Our developers helped the client introduce new-age digital experiences that allowed the bank’s network of lender financial institutions to make advances to their local community of loan seekers. Faster transaction time required changing the operating model and migrating from an older tech stack to a new one. To fulfill this objective, Sun Technologies implemented – Angular (Frontend), Springboot (Backend/server side), Hibernate (ORM layer), Security (LDAP authentication).

Our Solution

  • Architected an intelligent frontend design strategy and migration roadmap
  • The new Frontend is more “human readable”, better performing, easier to debug, and easier to consume
  • The roadmap was used to connect the legacy data/framework with a modern UI/UX
  • Used REST APIs to enable silent login capabilities and assign user roles
  • The newly deployed connector layer offers different representations of the legacy resources including JSON, HTML, or similar
  • Implemented a modern navigation for the end-users, taking them on a pre-determined routing journey
  • This pre-determined user-action based journey is modernized with quick re-direction to the respective webpages and login pages
  • The new navigation which is mapped to the users needs, takes them to the respective reporting dashboards
  • The new mapped navigation is designed to help end-users access certain widgets on the re-directed pages
  • These widgets are integrated to hep the end-users perform financial calculations and analysis
  • The new modern front end has helped the bank to enhance their web-based internet banking portal
  • It has improved user experience and brought various functionalities such as transactions, wires, and advances, under a single dashboard
  • The customized portal is easy to use and provides intuitive navigation for user queries
  • Newly enabled functionalities help in automated report delivery to end customers

Challenges

  • Slow and clunky dashboards, navigation, and log-in process for advance tranters
  • Inability of the legacy system to provide modern, intuitive features
  • Slow response time and clunky dashboards that look archaic
  • Frustration among end users as they are expecting better services
  • Legacy UI/UX impacted navigation and effected speed of information retrieval
  • Converting the legacy framework into a new modernized front-end
  • Integration with multiple third-party apps was essential for many widget-driven self-service features
  • The implementation team had to ensure business continuity while migration to the new tech stack is on-going

Impact

  • Seamless migration with zero-disruption and 100% business continuity
  • Launched alternate channel for accessing information and reports
  • Reduced steps and processing time of online transaction requests
  • Real-time postings for all reporting functions
  • 6X increase in transaction processing volumes since launch
  • 2X increase in new customers on-boarded by the bank
  • 400% surge in online customer traffic
  • Increase in revenues with new cross-selling opportunities

How we helped

  • We started the journey by spotlighting the need for operating model changes.
  • Next, we communicated with the organization’s core teams and prioritized the strategic actions.
  • Further, our experts built a digital roadmap that is secure and scalable in line with the digital strategy with reduced risk of non-compliance.
  • The team managed access control and permissions as per a new set of protocols as required by the bank
  • Our team re designed the entire portal and connect the legacy framework and data to the revamped new portfolio.
  • Finally, we helped them enhance their digital services, leading to exponential growth in core services revenue.
  • We also helped them address their digital priorities to enable growth in disconnected markets.

Contact Your Solutions Consultant!

Ensuring timely App launch to support a critical Housing Loan Program

Case Study

Ensuring timely App launch to support
a critical Housing Loan Program

Overview

A large US-based government-sponsored bank providing housing subsidies to the local community, member banks, and construction companies required a business-critical app.
The app was in production since a year and the project had suffered multiple delays caused by mistakes and coding miscalculations of their IT vendor. The client sought to replace the incumbent vendor who eventually backed out without a proper handover.

Our Solution

  • We helped the client in launching the app on time and enable online access to business-critical workflows
  • The team implemented a maker-checker process flow by structuring complex data that was scattered in multiple tables and folders
  • Successfully created and tested the maker-checker workflow by unifying data and making it visible on the app for the users to view
  • Users with the maker role access are now able to raise requests, examine requests, and seek timely approvals
  • Users with the checker role access can approve or reject requests while validating data based on set rules
  • The app brings accuracy in performing subsidy grant eligibility calculations based on these rules
  • The project needed constant repairing of broken codes and testing to monitor the app’s functional performance
  • We worked with client-appointed vendors who raised frequent change requests regarding code functionality
  • More than 300 tickets were resolved by making corrective changes in the code after the analysis

Challenges

  • The project was at first given to a large IT vendor who was unable to provide quality code and missed multiple deadlines
  • They delivered a dysfunctional app that was unable to deliver even the basic functionality offered by the legacy system it meant to replace
  • The condition in which the project was delivered was not stable and it suffered from wrong calculations and data retrieval failures
  • It was largely caused by broken code structures and faulty microservices architecture implemented by the previous vendor team
  • When a particular task or a command is executed, it would lead to breakage at some other place and result in a breakdown

Impact

  • Up to 4-5 hours per day of savings on employee time spent on manual validation
  • Construction partner retention enabled by a vastly improved online service desk
  • Complete automation of data collection, approvals, validation, and report generation
  • 90% reduction in manual paperwork by transitioning to a frictionless online process
  • Customized dashboards to monitor data in real-time by the partnered banks
  • 5X times faster app development cycle time
  • 10X faster bottle necks identification
  • 200+ test cases
  • Up to 70% reduction in hard parses
  • +60% reduced regression time
  • Improved business continuity
  • 100% accuracy in calculations and data retrieval
  • 10X improved response time
  • Vastly improved ROI

How we helped

  • Solving functionality issues caused by breaking codes and errors
  • Providing maintenance and support for multiple legacy business application
  • Enabling error-free implementation of new rules to perform complex calculations
  • Using unstructured data housed in undocumented tables and folders
  • Handling CI/CD while managing multiple change requests
  • Mitigating the impact of change on the codes with testing automation
  • Repairing faulty codes that do not integrate properly with the app’s microservices architecture
  • More than 300 tickets were resolved by making corrective changes in the code after the analysis

Contact Your Solutions Consultant!

Enabling smooth legacy software migration and upgrade to modernize a Mortgage Asset Management Program

Case Study

Enabling smooth legacy software migration and upgrade to modernize a Mortgage Asset Management Program

Overview

A large US government-sponsored bank was dealing with a complex migration from an older version of Java and Angular to the new update.

The coding architecture, names, styling, front-end UI, etc., are subject to change after any migration or upgrade. Hence, our team had to ensure that the business logic of the existing solution and its functionality wasn’t impacted due to this upgrade. It required knowledge of legacy coding language models to prevent any disruptions causing malfunctions in the system.

Our Solution

Migration and upgrade of Angular and Java often require rewriting an entire app from scratch. A lack of understanding of Java and Angular coding structures can lead to overall system breakdowns.

We had four key stages in which the solution was implemented:

  • Each major version introduces its share of breaking changes including dropping some components.
  • So, as a first step, we reviewed the breaking changes introduced by each major release
  • Then we started importing custom code into new app and started performing all required tests
  • We used the right Java and Angular libraries and frameworks to fix name changes and broken codes in the system
  • We carefully chose libraries and frameworks to facilitate further maintenance.

Challenges

  • Functionality failure can occur as the code needs a manual upgrade
  • It does not automatically update in many places and leaves the system broken
  • When a new upgrade package is installed, changes in the code lead to a visually broken application
  • Wrong colors, margins, and paddings can appear in the frontend UI if the codes are not refactored
  • It can mess up all the styling completely and fail to deliver the way the app and software backend/dashboards must appear (impacted by changes in: text color, font, themes, and sizes)

Impact

  • Successful database update resulting in zero-failure of critical retrieval of mortgage loan evaluation status updates
  • 8X faster processing of all mortgage asset risk management and analysis calculations based on accurate data
  • Complete code monitoring and functionality tests ensuring zero instances of data break or complete loss of data

How we helped

  • Using our knowledge of the component library, we defined components that are used in multiple places in the applications.
  • For example, buttons, input elements, progress-bar, etc. Those components have no business logic besides visualization, user interactions, and validation.
  • Our experts possessed knowledge of coding components that are directly related to the business logic of the application.
  • We knew how the changes impact the business logic of the application.
  • We laid out a time-bound plan and roadmap for the applications accessibility testing 
  • We created a unified automated application process without affecting everyday business operations
  • Our dedicated offshore team was supporting the testing of mobile and web applications
  • Our team evaluated the existing accessibility practices and cross-compared results using the best-in-class testing tools
  • Our web accessibility testing helped the client to take advantage of agile processes to handle mortgage asset management, risk analysis, documentation, and processing. 
  • Our continuous testing methodology and knowledge of legacy coding frameworks have enhanced data security and quicker liquidity provisioning on mortgage asset loans

Contact Your Solutions Consultant!