Nuchem Katz

I am a confident, capable, and passionate power apps developer. I design, code and test elegant, reliable and maintainable power apps. In addition, I use technologies like Azure services, C# and Dynamics 365 to enhance, streamline and add capabilities to my products.

1. Developed a People Skills app and database (both in Dataverse and in SharePoint) that provided functionality for filtering, adding and editing scores for employees for a range of tools or soft skills.
2. Developed an app that provided functionality for daily clock-in, leave-request booking, employee database, and project management and reporting. It also allowed for the underlying database schema to be changed dynamically by new fields being created and pushed from the application level. This was made possible by leveraging SharePoint’s Rest API toolkit. The app also included role based permissions on the application level as well as at the database level (SharePoint groups) by utilizing Azure Active Directory capabilities and Office365 connectors available in power apps.
3. Developed an app that integrated, dynamics’ dataverse tables, cognitive search and blob storage, using flows. Users were able to search, inside powerapps, for dataverse column values or search for document content in documents related to these dataverse rows; in turn, only the rows that were associated to documents that contained the search term, were returned to the user. Additionally, I helped develop the same solution using Azure Functions, with a custom connector, instead of flows.
4. Developed a Power automate flow that automatically and on schedule, ingested multiple excel spreadsheets stored in SharePoint or OneDrive into SharePoint Lists and made the data available for a power app to consume. The flow included converting excels’s flat structure into a relational model, checking for duplicates with already existing data and getting additional data (such as emails and profile info) via available office365 connectors.
5. Developed an application that queried external databases via enterprise and premium APIs, consuming the results and presenting it to the user for manipulation in power apps. The app was also able to capture audio and videos by leveraging Azure Blob Storage, Transloadit (an images to video converter) and Power Automate. The work included converting json to power apps types and embedding or connecting Power Automate within Power Apps.
6.  Developed a number of Power Automate desktop flows that ran unattended and daily, on a Virtual Machine, to test several data governance controls around data or site access, the sharing of data with unauthorized persons and the storing of data on unauthorized machines.
7. Had experience with share point development, including column formulas, group and custom permissions, and exporting and importing lists and sites as templates across environments/tenants using the Share Point Power Shell Management Console.
8.  Have solved data ingestion, schema development and audit retrieval into or from dataverse,using C# programming.
9.  Have edited power apps source code using visual studio and the new power apps .msapp files unpacker tool (PASopa).
10.  Tested Power Apps Canvas by using Test Studio in conjunction with Application Insights in Azure.

2017 - 2021          BSc hons in Computer Science, Birkbeck College, University of London