Know your supplier system

Utilizing Microsoft Power Apps environment, I created an internal know-your-supplier (KYS) management system that streamlines data and file collection process, increases data accountability via introduction of approvals and handles automated signature requests via DocuSign. The KYS system is reinforced by comprehensive Power BI analysis of gathered data to mitigate risks, and strategically identify cost-saving opportunities for the organization.

Key Deliverables

  1. Internal application developed, including design, front-end development, as well as backend and data infrastructure. 
  2. Automated file population and signature request via DocuSign platform.
  3. Extensive Power BI analyses to deliver actionable intelligence and support various teams with day to day processes.

32%

Increase in data insights on cost spending

47%

Advancement in efficiency of the entire KYS process, from the initial request to the final supplier contracting

+50

Suppliers successfully contracted through the system

Key Phases

  1. Data infrastructure design and creation of central data repository using Microsoft Dataverse.
  2. Front-end & back-end development of a low-code application using Microsoft Power app environment
  3. Creation of approval workflows and signature requests via DocuSign via Power Automate.
  4. Establish an ETL (Extract, Transform, Load) service for migrating data to a central data repository.
  5. Design of Power BI dashboards displaying analysis on data related to travel

Front-end app design illustrations