Systems Analyst Portfolio

Loan Approval Process

End-to-end BPMN redesign for Maple Trust Bank — from manual paper-based intake to automated digital disbursement.

9–12 days
As-Is cycle time
 
≤ 2 days
To-Be target
12
Gaps identified
16
Requirements mapped
18%
Manual rework rate

Process Narrative — As-Is

Maple Trust Bank's current personal loan approval (CAD $5K–$50K) spans 7 steps and 6 roles, averaging 9–12 business days end-to-end. The process is manually intensive and paper-dependent.

👤

Customer

Submits application and supporting documents

🧑‍💼

Loan Officer

Branch intake, document review, data entry

📊

Underwriter

Credit assessment, risk scoring, recommendation

🏛️

Credit Bureau

External — credit report & score provider

⚖️

Compliance Officer

AML/KYC, sanctions screening, regulatory sign-off

🏢

Branch Manager

Final approval authority for loans > $25,000

Step 1 — Application Intake (Day 0)

Customer visits branch. Loan Officer completes a 12-page paper form and photocopies ID and pay stubs. Data is manually re-keyed into the core banking system (CBS).

Pain: Dual entry — 35 min/application, 8% transcription errors

Step 2 — Document Verification (Day 0–1)

LO physically checks for completeness. Missing items require a customer phone call and return visit.

Pain: 22% return-visit rate

Step 3 — Credit Bureau Pull (Day 1–2)

LO manually logs into bureau portal, keys applicant SIN and DOB, downloads PDF, emails to UW shared inbox. No API integration.

Pain: Manual lookup, mis-routed emails

Step 4 — Underwriting Review (Day 2–5)

Underwriter pulls next file from FIFO queue. DSR calculated in ad-hoc Excel sheet. Recommendation memo written manually. Queue depth averages 40 files.

Pain: 3-day median queue wait, inconsistent Excel models

Step 5 — Compliance Review (Day 5–7)

AML/KYC and sanctions screening — only triggered after Underwriting completes. Serial flow means Compliance rejections cause full rework.

Pain: 12% rework rate from late Compliance rejections

Step 6 — Branch Manager Sign-off (Day 7–8)

For loans > $25K, file is couriered to originating branch for wet-ink BM signature, then couriered back.

Pain: 1–2 day courier delay, pages occasionally lost

Step 7 — Disbursement (Day 8–12)

Customer returns to branch in person to sign loan agreement. Funds released upon completion.

Pain: 9% post-approval drop-off (customers never return)

Step 8 — Rejection

Rejected applicants receive a paper letter by mail within 10 business days. No adverse-action explanation provided in real time.

Pain: No real-time notice; potential regulatory exposure

As-Is BPMN — Current State

End-to-end process flow showing all pain points (red). Steps are serial; Compliance runs only after Underwriting completes.

flowchart TD Start([fa:fa-user Customer submits application]) --> LO1[LO: Paper form intake + photocopy IDs] LO1 --> LO2[/LO: Dual-entry into CBS/] LO2 --> LO3{Documents complete?} LO3 -- No --> LO4[Call customer, schedule return visit] LO4 --> LO1 LO3 -- Yes --> LO5[/LO: Manual login to Credit Bureau portal/] LO5 --> LO6[/Download PDF report, email to UW inbox/] LO6 --> UW1[UW: Pull next file from FIFO shared inbox] UW1 --> UW2[UW: Calculate DSR in Excel, write memo] UW2 --> UW3{Recommend approve?} UW3 -- No --> REJ1[Paper rejection letter mailed to customer] REJ1 --> EndR([End: Rejected]) UW3 -- Yes --> CO1[CO: AML / KYC / sanctions review] CO1 --> CO2{Compliance pass?} CO2 -- No --> REJ1 CO2 -- Yes --> AMT{Loan greater than $25K?} AMT -- No --> DISB1[Disbursement Clerk prepares agreement] AMT -- Yes --> BM1[Courier file to originating branch] BM1 --> BM2[BM: Wet-ink signature on paper] BM2 --> BM3[Courier file back to hub] BM3 --> DISB1 DISB1 --> DISB2[Customer returns to branch in person to sign] DISB2 --> DISB3{Customer signs?} DISB3 -- No --> EndD([End: Abandoned]) DISB3 -- Yes --> DISB4[Funds released to deposit account] DISB4 --> EndA([End: Disbursed]) style LO2 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style LO4 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style LO6 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style UW1 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style CO1 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style BM1 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style BM3 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style DISB2 fill:#3d1a1a,stroke:#c0392b,color:#f85149 style REJ1 fill:#3d1a1a,stroke:#c0392b,color:#f85149

🔴 Red nodes = pain points identified in the gap analysis

Gap Analysis

12 gaps identified across 4 themes: integration absence, sequential bottlenecks, paper inertia, and customer experience.

IDGapTypeStepSeverityRoot Cause
GAP-01Dual paper + CBS data entryManual / data qualityStep 1MediumNo digital intake channel
GAP-02Missing docs only caught at branchReworkStep 2MediumNo upfront validation logic
GAP-03Manual credit bureau lookupIntegration gapStep 3HighNo API integration
GAP-04FIFO queue, no prioritizationBottleneckStep 4HighNo case management system
GAP-05DSR calculated in ad-hoc ExcelInconsistency / riskStep 4MediumNo standardized rules engine
GAP-06Compliance is serial — after UWSerialization bottleneckStep 5HighSequential process design
GAP-07Wet-ink BM signature, courierManual handoff / delayStep 6MediumNo e-signature workflow
GAP-08Redundant approvals on small loansOver-controlSteps 4–6LowRisk policy not tiered
GAP-09In-person customer signingCX / drop-offStep 7HighNo remote ID verification
GAP-10Rejection by paper mail onlyCX / complianceStep 8MediumNo customer-facing portal
GAP-11No real-time status for applicantTransparencyAllLowNo applicant portal
GAP-12No audit trail across paper handoffsCompliance riskAllHighHybrid paper/digital trail
IDGapImpact
GAP-03Manual credit bureau lookup15–20 min/file; mis-routed emails; PII via email
GAP-04FIFO queue, no prioritization3-day median queue wait; no SLA visibility
GAP-06Compliance serial after UW12% rework rate; adds 2–3 days when triggered
GAP-09In-person customer signing9% post-approval drop-off
GAP-12No end-to-end audit trailRegulatory exposure; difficulty proving timelines
IDGapImpact
GAP-01Dual data entry8% transcription errors, 35 min/application
GAP-02Missing docs caught late22% return-visit rate, customer friction
GAP-05Ad-hoc Excel DSRInconsistent risk decisions, audit weakness
GAP-07Wet-ink BM signature1–2 day courier delay, lost pages
GAP-10Rejection by paper mailSlow adverse-action notice, NPS impact
IDGapImpact
GAP-08Redundant approvals on small loansOver-control adds days unnecessarily for <$15K
GAP-11No real-time status visibilityInbound call volume; NPS cost

To-Be BPMN — Redesigned Process

Redesigned flow with digital intake, automated credit scoring API, parallel UW + Compliance, tiered auto-approval, and digital e-signature.

❌ Before

  • Paper forms + dual CBS entry
  • Manual bureau PDF lookup
  • Serial UW → Compliance
  • Wet-ink courier for BM
  • In-person customer signing
  • Paper rejection letters
  • No audit trail

✅ After

  • Digital app + OCR extraction
  • Credit Bureau REST API
  • Parallel UW + Compliance
  • E-signature for BM approval
  • Remote ID verification + e-sign
  • Real-time adverse-action notice
  • Immutable append-only audit log
flowchart TD Start([fa:fa-mobile Customer: digital application via web or mobile]) --> SYS1[/System: real-time field validation + doc checklist/] SYS1 --> SYS2[/System: OCR extract ID and pay stub data/] SYS2 --> SYS3{Documents complete?} SYS3 -- No --> SYS4[/Auto-notify customer via SMS and email/] SYS4 --> SYS3 SYS3 -- Yes --> API1[/API: Credit Bureau REST call returns JSON score/] API1 --> RULES[/Rules engine: standardized DSR and risk score/] RULES --> TIER{Risk tier?} TIER -- Low risk up to 15K --> AUTO1[/System: auto-approve per policy/] AUTO1 --> ESIGN TIER -- Medium or High risk --> UW1 & CO1 UW1[UW: review case in workflow tool] --> JOIN((AND-join)) CO1[CO: AML and KYC and sanctions in workflow tool] --> JOIN JOIN --> DECIDE{Both approved?} DECIDE -- No --> REJ1[/System: real-time adverse-action notice via portal and email/] REJ1 --> EndR([End: Rejected with reason codes]) DECIDE -- Yes --> AMT{Loan greater than $25K?} AMT -- No --> ESIGN[/System: send e-sign package to customer/] AMT -- Yes --> BM1[BM: e-sign approval in workflow tool] BM1 --> ESIGN ESIGN --> CUST1[Customer: remote ID verification and e-sign] CUST1 --> SIGNED{Signed within SLA?} SIGNED -- No --> REMIND[/Auto-remind at 24h and 72h/] REMIND --> SIGNED SIGNED -- Yes --> DISB[/System: auto-disburse to deposit account/] DISB --> AUDIT[/System: write immutable audit trail entry/] AUDIT --> EndA([End: Disbursed]) style SYS1 fill:#122113,stroke:#238636,color:#3fb950 style SYS2 fill:#122113,stroke:#238636,color:#3fb950 style SYS4 fill:#122113,stroke:#238636,color:#3fb950 style API1 fill:#122113,stroke:#238636,color:#3fb950 style RULES fill:#122113,stroke:#238636,color:#3fb950 style AUTO1 fill:#122113,stroke:#238636,color:#3fb950 style REJ1 fill:#122113,stroke:#238636,color:#3fb950 style ESIGN fill:#122113,stroke:#238636,color:#3fb950 style DISB fill:#122113,stroke:#238636,color:#3fb950 style AUDIT fill:#122113,stroke:#238636,color:#3fb950 style REMIND fill:#122113,stroke:#238636,color:#3fb950

🟢 Green nodes = automated / system tasks. UW and CO run in parallel (AND-split → AND-join).

⚡ Credit Bureau API

Replaces manual portal login — score returned in <5 sec via REST call, no PII over email.

⚡ Parallel Review

AND-split sends file to UW and Compliance simultaneously — eliminates 2–3 day serial delay.

⚡ Tiered Auto-Approval

Loans ≤ $15K passing rules engine skip human review — zero queue wait for low-risk files.

⚡ Digital E-Signature

BM approves in workflow tool, customer signs remotely — courier delays and drop-off eliminated.

⚡ Immutable Audit Trail

Every state transition logged with actor, timestamp, and payload hash — regulator-ready.

⚡ Real-Time Notices

Adverse-action reasons delivered via portal and email within 60 seconds of decision.

Expected Outcomes

MetricAs-IsTo-Be Target
Median time-to-decision7 business days< 4 hours
Median time-to-disbursement9–12 business days< 2 business days
Manual rework rate18%< 5%
Post-approval drop-off9%< 2%
Late Compliance rejection rate12%< 3%

Requirements Traceability Matrix

Each gap maps to one or more system requirements (FR / NFR) and the To-Be BPMN element that realises it.

GapReq IDTypeRequirementBPMN Element
GAP-01FR-01FRDigital application form writes directly to CBS — no rekeyingSYS1
GAP-01FR-02FROCR extracts data from ID and pay stubs and pre-populates applicationSYS2
GAP-02FR-03FRDocument checklist enforced at submission — blocks until all mandatory artifacts uploadedSYS1 → SYS3
GAP-03FR-04FRCredit bureau integrated via REST API; score returned in <5 secondsAPI1
GAP-03NFR-01NFRBureau payloads over TLS 1.3 mutual auth; no PII via emailAPI1
GAP-04FR-05FRCase management tool with risk-weighted UW queue prioritizationUW1 (parallel)
GAP-05FR-06FRDSR and risk score calculated via versioned centralized rules engineRULES
GAP-05NFR-02NFRAll risk decision inputs/outputs persisted immutably for 7 yearsAUDIT
GAP-06FR-07FRParallel UW + Compliance via AND-split; joined only when both decisions recordedAND-split / AND-join
GAP-07FR-08FRQualified e-signature for Branch Manager approvalBM1
GAP-08FR-09FRAuto-approve loans ≤ $15K passing rules engine without human reviewTIER → AUTO1
GAP-09FR-10FRRemote ID verification and customer e-signature compliant with PIPEDACUST1
GAP-09FR-11FRAutomated e-sign reminders at 24h and 72h post-issuanceREMIND
GAP-10FR-12FRAdverse-action notice via portal + email within 60 sec of rejection, with reason codesREJ1
GAP-11FR-13FRCustomer portal shows real-time application status and required actionsPortal (cross-cutting)
GAP-12NFR-04NFRImmutable append-only audit log — every state transition with actor, timestamp, payload hashAUDIT
AllNFR-05NFR95% of low-risk applications disbursed within 2 business daysCross-cutting SLA
AllNFR-06NFRCustomer-facing portal and APIs at 99.9% monthly availabilityCross-cutting