Projects
/
WIL-753
Consumer Finance Reporting
In progress
Overview
Tasks
177
Dependencies
Thread
Activity
152 parent tasks · expand a row to add subtasks
+ New task
WIL-341
DTA-409 Outstanding per customer as End of July
—
In progress
MA
WIL-304
DTA-403 Waive request → settlement turnaround — monitor after Instapay reconciliation
—
In progress
MA
WIL-466
DTA-402 Dynamic Los Modeling
16
—
In progress
MA
WIL-311
DTA-401 partial settlement impact on collection
—
Done
MA
WIL-169
DTA-398 Installment Amount ( BKT2 & Above )
—
Done
MA
WIL-642
DTA-396 Report
—
In progress
MA
WIL-722
DTA-394 Analytic ids of users in Bucket 2,3,4,5
—
Done
MA
WIL-560
DTA-388 Acquisition Dashboard
—
In progress
MA
WIL-364
DTA-386 Filters issue in explore
—
Done
MA
WIL-480
DTA-380 DBR
—
Done
MA
WIL-321
DTA-377 Offloading - Batch 2
—
Done
MA
WIL-297
DTA-374 offloading- Bank Next
—
Done
MA
WIL-133
DTA-372 ECL
—
In progress
MA
WIL-428
DTA-371 • Offloading FRA Sheet
—
In progress
MA
WIL-496
DTA-370 Customers Insatllments per Month
—
Done
MA
WIL-551
DTA-367 Partial Settled July-26
—
Done
MA
WIL-303
DTA-365 DBR Sample report Q2-2026
—
Done
MA
WIL-478
DTA-359 Users with loans less than 60,000 EGP
—
Done
MA
WIL-300
DTA-352 How to improve our collection rate
—
In progress
MA
WIL-290
DTA-345 Portfolio Vs City VS Age
—
Done
MA
WIL-508
DTA-339 Buckets 1, 2, 3, and 4 full picture
—
Done
MA
WIL-714
DTA-331 Lending users behaviour on payments volumes
—
Done
MA
WIL-330
DTA-329 Add BKT 6 similar to BKTs 4 and 5
—
Done
MA
WIL-659
DTA-327 Payments Users lending
—
Done
MA
WIL-879
DA-117 bkt4&bkt5 users legal
—
Done
MA
WIL-126
DTA-319 Report Access Request
—
Done
MA
WIL-264
DTA-317 COMP& AML_Trx Value > 5 X AVG ticket size
—
Done
MA
WIL-586
DTA-316 AML_Occupations VS Declared
—
Done
MA
WIL-193
DTA-315 COMP_Utilization over 80 % of full limit
—
Done
MA
WIL-189
DTA-314 COMP& AML_NID Lifecycle & Expiry Tracking
—
Done
MA
WIL-388
DTA-313 AML_Trx Report_Same-Day Transaction and Payment
—
Done
MA
WIL-808
DTA-312 AML_Trx Report_Multiple Daily Transactions
—
Done
MA
WIL-213
DTA-311 AML_Trx Report_Early_Settlement_<3M
—
Done
MA
WIL-650
DTA-306 Delinquent users investigation
—
Done
MA
WIL-374
DTA-304 analytics plan
—
Done
MA
WIL-404
DTA-300 Los report issue
—
Done
MA
WIL-748
DTA-293 Refferal investigation
—
Done
MA
WIL-208
DTA-290 Request for Customer Limits Report
—
Done
MA
WIL-745
DTA-287 Download Records
—
Done
MA
WIL-157
DTA-286 Active merchants - Branches list
—
Done
MA
WIL-322
DTA-284 Install media souce
—
Done
MA
WIL-160
DTA-281 Schedule 2 reports for 1. approved and 2. activated users with "Capped" geofencing category, and send them to Risk Controls
—
Done
MA
WIL-551
DTA-277 Check if a user booked more than one discount offer loan, after capping the offer to one transaction per user on 15-5-2026
—
To do
MA
WIL-131
DTA-273 Send April-26 outstanding figures to Risk team for validating
—
Done
MA
WIL-480
DTA-272 Implement monthly provisions logic on Looker
—
Done
MA
WIL-731
DTA-269 Marketing Performance
—
Done
MA
WIL-600
DA-114 Klivvr limit vs. market gap — iScore consumer-finance facilities per user
—
Done
MA
WIL-745
DA-113 Discount-offer collection drop in M3 (95/94 → 40%) — new vs. old booking
—
Done
MA
WIL-612
DTA-275 Existing base vs. new acquisition utilization — cohort dashboard (same-month activation & utilization)
—
Done
MA
WIL-521
DA-111 Validate 65% install → credit request conversion
—
Done
MA
WIL-106
DA-110 Klivvr ticket size doc: approved vs. activated vs. utilized
—
Done
MA
WIL-823
DA-108 Validate actual ticket size vs. communicated (+1k)
—
Done
MA
WIL-701
DTA-262 Offloading Finance Requirements
—
Done
MA
WIL-538
DTA-256 Add filter to lending deals report to filter for limit status
—
Done
MA
WIL-169
DTA-255 Export users list
—
Done
MA
WIL-460
DTA-253 Marketing performance dashboard- attribution data refresh rate
—
Done
MA
WIL-712
DTA-247 Telesales pre-expiry reports- Test +1 vs. +4 approved not signed
—
Done
MA
WIL-510
DTA-245 Loan amount
—
Done
MA
WIL-144
DTA-243 lookalike from high limit users
—
Done
MA
WIL-381
DTA-232 Merchant x Offer combo analysis
—
Done
MA
WIL-123
DTA-227 Special Interest Rate 2nd Wave
—
Done
MA
WIL-768
DA-106 Lending Merchant category doesn't represent actual categories
—
To do
MA
WIL-637
DTA-250 Closed Loop Dashboard enhancements
—
Done
MA
WIL-405
DTA-222 User Creation to Lending Approval Cohort Analysis
—
Done
MA
WIL-183
DTA-220 Add 2 Colum to Cards Acqusition Report The ranch Name & agent Email
—
Done
MA
WIL-325
DTA-194 need to add total outstanding interest per each user id in lending protifolio per installment
—
Done
MA
WIL-416
DTA-193 outstanding of overdue users per bucket
—
Done
MA
WIL-811
DTA-187 Commission sales report
—
Done
MA
WIL-553
DTA-184 Family, "other" relationship options
—
Done
MA
WIL-539
DA-104 change credit limit details
—
Done
MA
WIL-691
DTA-183 Adding bucket history to lending explore and fra reports
—
Done
MA
WIL-885
DTA-182 Need access to Los dashboard & Quality of sales
—
Done
MA
WIL-724
DTA-173 Report to see the customers how signed the contract and did not receive the card
—
Done
MA
WIL-848
DTA-176 Create report
—
Done
MA
WIL-896
DTA-174 Locker Access
—
Done
MA
WIL-741
DTA-163 Export Collection Domain from looker
—
Done
MA
WIL-402
DTA-175 Add filter in Lending Deals Report report
—
Done
MA
WIL-596
DTA-157 Lending Explore Revamp
—
To do
MA
WIL-198
DTA-156 Filters in FRA monthly/quarter reports
—
Done
MA
WIL-217
DTA-160 Appreciate your support to provide us with a list of the customers who utilized with offer 75% Discount & 50% Discount with their total Outstanding Principle & Interest.
—
Done
MA
WIL-547
DA-98 On-ground lending users logic update
—
Done
MA
WIL-193
DTA-153 Kindly fill in the required information in the attached Excel(Fill in the type of client and the nature of work (governmental, private sector, or self-employed).
—
Done
MA
WIL-150
DTA-151 kindly add rebate revenue and admin fees for every loan on lending protfolio per installment and kindly send it at 1/1/2026 12:01 AM
—
Done
MA
WIL-450
DTA-149 Lending recommendation engine
—
To do
MA
WIL-849
DTA-177 Lending Deals Report (The filter "signing^_date" is not allowed. looker_production_project/views/lend_credit_limits_details.view.lkml:446)
—
Done
MA
WIL-209
DTA-147 risk dashboard ana
—
In progress
MA
WIL-861
DTA-146 pending limit approval 9AM for the last day to be send to credit team
—
Done
MA
WIL-211
DTA-178 Analysis on Top Family Plan Spenders
—
Done
MA
WIL-257
DTA-143 i need the self declared occupation for sent list of customers
—
Done
MA
WIL-794
DTA-139 Dubai Phone
—
Done
MA
WIL-851
DTA-136 we need to add the below fields ( Customer Segment - Employer - Residence address - Business address ) bank nxt offloading
—
Done
MA
WIL-592
DTA-135 Day-to-day lending sales per agent in the Quality of sales
—
Done
MA
WIL-187
DTA-179 Day to Day Sales Dashboard
—
Done
MA
WIL-299
DTA-131 Lending QoS (Partnerships) dashboard edit
—
Done
MA
WIL-737
DTA-130 Need to add the approval date to the activated credit limit breakdown.
—
Done
MA
WIL-660
DTA-128 Pending approval to Action needed & from action needed to pending limit approval report
—
Done
MA
WIL-702
DA-92 Portfolio outstanding amount as of October'25
—
Done
MA
WIL-732
DTA-119 Display the Offer column
—
Done
MA
WIL-710
DTA-115 Provision by tires
—
Done
MA
WIL-826
DTA-106 Add list of all lending merchants to looker
—
Done
MA
WIL-658
DA-84 User on ground searched
—
Done
MA
WIL-406
DTA-102 Add klivvr uninstall date to users explore in looker
1
—
Done
MA
WIL-825
DTA-101 provide break down for quarter 3 in 2025 lending
—
Done
MA
WIL-253
DA-81 analytics ID
—
Done
MA
WIL-815
DA-78 Portfolio Analysis
—
Done
MA
WIL-255
DA-75 instalments breakdown per user
—
Done
MA
WIL-176
DA-77 Download file with more 5000 Rows https://klivvr.cloud.looker.com/explore/looker_production_model...
—
Done
MA
WIL-410
DA-80 Hourly view for data - Performance request
—
Done
MA
WIL-387
DA-82 Closed loop dashboard
—
Done
MA
WIL-112
DTA-87 Fico Score / Users
—
Done
MA
WIL-329
DTA-84 Acquisitions Drop Last Week
—
Done
MA
WIL-773
DTA-82 I need the Records in this Look to corelate the rejections from credit flow with the uninstalls o...
—
Done
MA
WIL-715
DTA-78 Add new data element about declared user income to lending explore
—
Done
MA
WIL-793
DA-83 Outsanding Overview
—
Done
MA
WIL-136
DA-76 Supervisors Activations dashborad
—
Done
MA
WIL-267
DA-71 closed loop dashboard Total Merchant Admin Fees Per Portfolio ( result limit reached )
—
Done
MA
WIL-213
DA-66 Lending Users Anomalies Alert
—
Done
MA
WIL-202
DA-65 Merchant Anomalies Alert (Closed Loop)
—
Done
MA
WIL-287
DA-64 compare self declared info Vs extracted form NID
1
—
Done
MA
WIL-663
DA-63 MTD Finance Report
1
—
Done
MA
WIL-143
DA-56 Create new dashboard for early settlement
—
Done
MA
WIL-630
DA-49 Tenor distribution on closed loop
—
Done
MA
WIL-405
DA-48 Check eligibility & id upload date
—
Done
MA
WIL-792
DA-47 Check I-score info in BQ and request
—
Done
MA
WIL-490
DTA-64 Early Settlements Dashboard
—
Done
MA
WIL-419
DA-68 Blended Effective interest rate calculation (Update)
1
—
Done
MA
WIL-157
DTA-60 Validate KYC 4 flags in LOS
1
—
Done
MA
WIL-513
DTA-59 Add blocked limits by departments as a breakdown in LOS
—
Done
MA
WIL-213
DTA-58 Create derived table in looker with all lending user funnel details
—
Done
MA
WIL-540
DTA-57 Renaming offer type for iPhone 17 preorder
1
—
Done
MA
WIL-811
DA-33 BNPL Merchant network
—
Done
MA
WIL-151
DTA-55 Lending Impact on Payments
—
Done
MA
WIL-898
DA-31 Uncollected Dues until Sep 21 2025
—
In progress
MA
WIL-706
DA-30 missing users from payment intent with manual method
—
In progress
MA
WIL-864
DA-32 installment payments by payment mmethod
—
Done
MA
WIL-623
DA-28 Check eligibility dates not found
—
Done
MA
WIL-761
DTA-48 Check handling of lend_credit_limits_logs in Looker
—
Done
MA
WIL-425
DTA-46 Cohort Analysis for Lending
—
Done
MA
WIL-517
DA-27 Add filter to dashboard
—
Done
MA
WIL-128
DA-24 Pre-expiry report
—
Done
MA
WIL-441
DA-25 Lending quality of sales (Agents & partnership)
—
Done
MA
WIL-161
DTA-38 Looker Changes
—
Done
MA
WIL-747
DA-26 Access to dashboard
—
Done
MA
WIL-875
DTA-33 approved & expired credit limits dump for tele sales
—
Done
MA
WIL-386
DA-22 send sep expected collection to omar ( collection )
—
Done
MA
WIL-663
DE-28 Users with No occupation
—
To do
MA
WIL-690
DTA-30 Data points looker data export ( rejected credit limits )
—
Done
MA
WIL-830
DTA-13 Remove company name from KYC masking pipeline
2
—
To do
MA
WIL-627
DTA-204 Dashboards Documentation
—
Done
MA
WIL-357
DA-6 Blended Rate New Calculation
—
Done
MA
WIL-589
DA-5 Adding Activation Date as filter option in Lending QoS
—
Done
MA
WIL-108
DTA-8 FRA Quarterly Report
1
—
Done
MA