In response, a sequence of focused group discussions was initiated to thoroughly understand stakeholder needs. The devised solution included two primary enhancements:
- Integration of New Entity Grid: A novel entity grid was integrated into the client's front-end systems, such as Microsoft Dynamics CRM and Salesforce. This grid was engineered to autonomously log analyst activities, including case assignments, closures, and team transfers. It adeptly recorded the duration of each activity, with most logs being autonomously generated upon status alterations, including reactivations or closures of cases.
- Power BI Reporting System Development:A comprehensive Power BI report was formulated, aggregating data from assorted applications. Utilizing a bespoke configuration template, the report adeptly assigned the time spent on each task to the relevant team category, ensuring meticulous tracking of time expenditure across various departments like sales, KYC, credit, and customer service. This reporting tool also provided in-depth insights into time distribution by region, request type, and analyst, significantly enhancing the refinement process of the KYC operations.