Consume Finance | U.S.A.
About the Client:
One of the largest privately held retail consumer finance companies in the United States. With a customer-centric focus, they offer an innovative mix of FinTech and brick-and-mortar financial products and services through an online customer portal as well as through 230+ retail locations in 3 states under the same brand.
Some key facts about the company:
• Healthy Balance sheet
• Positioned to grow
• Locations are 100% company owned – no franchises
• Named multiple times to the Inc. 5000 list of America’s fastest-growing private companies
• Named multiple times to the Dallas 100 list of the fastest-growing private companies in North Texas
Challenge:
Financial reports were delayed due to long running jobs and failed reports.
What We Did:
The Motivity Labs team worked closely with the client to understand the impact of the long running jobs and the following steps were undertaken
Step 1: Our Database Administrator team reviewed multiple backups and restores of the databases to ensure that they were successfully executed before jobs depending upon the database started
Step 2: In case of a delay, the DBA team analysed the RCAs for the delay and fixed the issues from the server and database end for smooth execution of the jobs.
Step 3: The Production support team monitored and troubleshooted the crucial jobs which were generating the reports to the business and made sure they completed within the SLA’s.
Step 4: Our team took constant feedback from the client about the requirements and did the changes accordingly.
Step 5: Our team focused more on the customer point of view and tried to match their requirements by fine tuning the jobs by rescheduling, changing connection strings to reduce the load on the servers and fine tuning the SQL code of the long running jobs and reports and debugging the SSIS packages to identify the delay.
Step 6: Our team also automated the 10 AM daily run log reports and hourly job status reports as per client’s requirement apart from the support work, they also handled additional tasks such as processing of Kohn/Thomason Legal fees into ADS toolbox and Monitoring Power BI reports and jobs in Azure cloud.
Success achieved:
Motivity Labs was able to accomplish 100 % successful execution of the job without any failures and the client was pleased with the end results. The jobs are completed within the SLA and the reports are being delivered on time. And by doing so we made sure every minute counts!
