← All projects
May 2024 – Sep 2024 · Banking Sector

Document Management Digitalization

Replaced paper-based document workflows with an electronic DMS, automating onboarding and cutting manual processing time.

SharePointPower AutomatePower BIExcelMS Office

The problem

The bank's transaction and compliance departments relied on paper-based document workflows for client onboarding and record-keeping — a slow, error-prone process with poor traceability for audits.

Workflow transformation

Paper-based processes replaced with a structured digital pipeline — SharePoint for storage, Power Automate for routing, Power BI for tracking.

Workflow transformation
Before — Paper-based
📄Paper forms
Manual hand-off
🗄️Physical archive
After — Digital DMS
1
SharePoint DMSCentralized storage
2
Power AutomateRule-based routing
3
Power BILive tracking
Processing time
~45 min
~8 min
−82%
Audit traceability
Manual logs
Full digital trail
Document retrieval
Physical search
Instant search
−95%

The approach

I gathered requirements and mapped the existing paper-based workflows end to end, then designed and implemented an electronic document management system (DMS) on SharePoint. I automated the customer-onboarding process using Power Automate, replacing manual hand-offs with rule-based flows, and built tracking and reporting dashboards in Excel and Power BI so department heads could monitor throughput in real time. I also trained the relevant departments on the new digital tools to ensure smooth adoption.

Tools & technologies

SharePointPower AutomatePower BIMicrosoft ExcelMS Office

Key outcomes

  • Converted a fully paper-based workflow into a structured electronic DMS, improving traceability for audits.
  • Automated key steps of the customer-onboarding process, reducing manual handling and turnaround time.
  • Delivered live tracking and reporting dashboards adopted by the transaction and compliance departments.
  • Trained staff across departments, securing adoption of the new digital solution.
CV