Part 1 - Loan Application Processing | Practice UiPath Projects | PDD | SDD | Banking Use Case

[Music] hi everyone welcome back to the channel first  of all thank you so much for providing such   a wonderful response to the end-to-end use case  series which we have been covering on the channel   in case you are looking to the channel  for the first time and you haven't already   subscribed please consider subscribing  to the channel to get the latest updates   in the same Series today I am  going to add one more use case   this use case would be related to the banking  domain and the name of the use case is loan   processing automation let us see what exactly  would be the complete agenda for this use case   we are going to start with the problem statement  this time what I have thought different from the   other use cases is that I am going to show you  guys two important documents of a project which   is process design document and solution  design document also known as PDD and sdd   so that you guys understand whenever we work  on a real-time project how does the automation   start from PDD to sdd and then to development we  do not directly jump to development we start with   PDD sdd and then we jump to the development the  same thing I am going to follow in this use case   post that I am going to show you one quick  snippet that how does the automation look like   and then we are going to create this Automation  in a step-by-step manner using uipath Studio   I would be sharing all the resources that include  the input files the source code and the templates   so that you guys can also follow along with  me in a step-by-step Manner and lastly we   will simply execute the solution considering  the length of the use case I have thought to   divide this video into two parts in the first  part we would be defining the problem statement   we would be covering the PDD  the STD and a sample execution   in the part 2 of the video we would be doing  the development part where we would start from   a template of re framework and we developed this  end-to-end automation there so I hope the agenda   is clear so let's get started by looking  at the problem statement for this use case let's say I have a bank where many people are  there who are applying for a loan now on let's   say daily or a weekly basis the bank receive email  which is having data of the customers who wanted   to apply for the loan now there is a person in the  loan department who is actually going through the   email and validating whether that attachment which  the application or the email has are valid or not   valid is the data inside the application is proper  not proper is it following the bank standards is   it following the loan requirement what is the  yearly income what is the loan amount they are   expecting and all the details he is validating  one by one for all the valid records from that   Excel or the CSV whichever he finds that yes these  are all the valid he passed treat to a different   department where they actually feed all these  data into the system and they Grant the loan or   in other term they generate something which is  called a loan ID right so this is the overall   problem statement which we are going to address  today in this use case talking about the bank I   would be using this bank which is called UI Bank  the URL for the bank is UI Bank Dot uipath.com   and this is the email which we are receiving  on the daily basis like 26th of 11 27 28th we   are receiving email which is having the data  for loan processing data and each of the email   has something which is called an attachments if I  download this attachment you would notice that I   am getting the customer name email address credit  card type occupation amount loan amount for how   much tenure they are using and all the details  of the customer we are getting as an input now   for some of the record you would notice that the  email address is blank that means the details   are missing and we cannot process the loan  for here we are saying that the age is blank   somewhere the loan amount is blank right  so it's not possible for it to process   so that is where they have to manually validate  if all the details are available then we would   need to consider what are the banking rules to  give the loan so that is where the robot run and   it will actually process the loan application now  to process the loan application the banking guys   are going to this website UI bank and in here  they have a section which is called apply for   a loan click on this and it will take you to  a new page of the loan of the bank you simply   have to click here which says apply for a loan you  have to provide all the details what what is the   loan term if you notice here as of now the bank is  providing only for one three five and ten and I am   getting request for 9 13 as well right so all of  these should be rejected right once you fill all   these details and you click submit the loan will  get processed and you will get something which is   called a loan ID now as the output the expected is  that for all these records if the record is valid   and it satisfy all the criteria we need to have  the loan ID available for each of the record so   that is the manual process and that is the problem  statement what we are going to address today   now before directly jumping to the PDD and the sdd  of the solution let's have a quick look up on the   robot that how does the robot work and what is the  final outcome so that you guys get interested in   building the use case so I'll quickly go back to  my email and I can see that I have received the   emails for 26 27 and I have email for 28th as well  right so business folder is blank I have the email   available run the file initializing the settings  that mean config has read Killing was done   as you can see Edge is gone now I have got the  credentials for the email so now the robot would   be going and reading the emails and validating  so total emails were four we have got the   folder for 2811 the folder exists which means  that it was able to download and we have got   100 records here right the next thing it opened  the application UI Bank application in the bottom   now the robot has started the processing it has  started doing the validations in the bottom the   Excel is flashing right that means that the  status is getting updated back to the Excel   for the valued records the robot is filling up the  loan application wherever the record is not valid   the status would be updated back and wherever  the application is valid it's simply filling   this thing okay generated the loan ID let's  quickly go back to the output and validate I   hit a quick refresh so this is our loan data.csv  so as you can see here the robot has updated this   Excel with this column which is column n which  we have instructed and it is showing me status   so let's quickly validate so I'll go here and I'll  just check for uh email address let's say and as   you can see for all of them the email address  was missing so that's why it says email address   is blank the same applies to let's say I go and  validate for the yearly income so yearly income   was blank so it has got this now the banker has  do not have to worry that what has went wrong   right it can directly come here and validate and  they can see this report for the valid one how do   I know the valid ones I can do a select all and  you can just remove the business validations hit   OK right so for all these records where you are  seeing this ID right these are the records where   all data was available I'll just put some and  it was satisfying the business criteria as well okay so let's start by looking at the process  definition document also known as the PDD so   whenever we start any development process the  first thing is we would have a PDD which is   typically created by the business analyst now a  business analyst will draft all the details in   the PDD and then it will land into the automation  we'll create solution design document and then   actually we shift towards the development okay so  let's quickly have a quick walk through that how   does a PDD look like and what are the different  details which are available okay so if I further   scroll down to the document I could see that the  automation name is loan application processing   there is a small bit detail about that what  is the being application used so UI bank is   an application which is being used to do this  loan operation it talks about that what are the   functionalities I can see that they are  dealing with the debt products they are   dealing with the financial harms they are  doing something with the expense right so   as of now I can relate that yes this is  something in the financial area and the   bank or the application which we are using is  the UI Bank okay let us further scroll down   and see what we have got so this is the table of  content that what exactly is included in the PDD   now depending on the type of the company you are  working or type of automation you have this format   would might look a little bit different but more  or less the content of the PDD would be the same   thing okay so quickly I will go through scroll  this that what exactly is the PDD and what all   details are included and what exactly we can make  out of it okay the first section in the document   is called the purpose of the document simply  meaning that why we are reading this document so   it clearly says that we have a business process  which has been chosen to be automated by uipath   robotic process automation technology and this is  something which is the detail which is available   about the business use case right that why  exactly the business want to automate that   So reading that I can sense that yes this is and  something where the bank is trying to give loan to   people depending on some of the criterias right so  this section particularly will have details about   the process okay what exactly is the objective the  second section talks about when you are doing this   automation what you are trying to achieve every  Automation in uipath has some objective right   it can be cost benefit it can be FTE saving it  can be reducing of the processing time it can   be to have a better monitoring better let's say  execution capability anything so if I talk about   this automation the PDD says that we wanted to do  this automation because we simply want to reduce   the processing time by 80 percent we want to have  a better monitoring capability and that would be   provided by the robot logs right make sense  right so this is the objective as a developer   now I understand that I have a UI Bank application  that is dealing with some loan kind of thing and   they wanted to reduce the processing time and have  some monitoring capability as well okay the next   section is the process key contact which means  that in order to understand more about the process   the automation process the manual process if I  have some doubt in this document or if I want to   get some more additional information get some file  whom should I contact to so basically these are   the people who are expert in this area also known  as the subject matter expert or the process owner   now the process owner is expected to review this  document and provide the sign off which means   that this document says that the process owner is  Mukesh kala which means that whichever detail is   available in this document first of all Mukesh  kala should provide you the sign of saying that   yes the document is accurate this is what we are  doing and this is what we are expecting from the   automation right so you would have something who  is called a process owner and then you would have   something who is called a subject matter expert  who understand in and out of this process right   so SME for me is John and the process owner is  Mukesh we would have the contact detail phone   number everything in the PDD now if I further  scroll down there is a section which talk about   minimum prerequisites for an automation if I have  to develop this automation what are the things we   require it says that you require a field process  design document a complete process design document   test data to support the development because you  cannot give the live data to the development right   so you need to have test data or some replica  of the data to start the development you need   to have the user accesses creation of the user  account for the license permission restriction   accounts robots all the accesses which are  required to run the robot should be available   we should have the input Excel available meaning  the process is running on some input action that   should be available and some email right  so these are the prerequisites which are   required to run this automation that again might  change depending on the kind of automation you   are working with the next section is about the  as is process description and it has something   which is called process overview right and  this is a pretty important section for me   to get all the information such as I can see  that the process full name is loan application   processing it is related to the banking domain  and in the banking I am dealing with the loan   department it has a short description about  the process now what is the role required for   performing the process is the loan officer right  which means that if you go to a bank a bank may   have different different roles different different  UH responsibilities right different different   people having different different privileges so  if I have to or if the robot has to perform this   automation which role or which access would be  required so that is an access of the loan officer   process schedule and frequency how do you want  to run the process once it is deployed right so   as I can see that it is an unattended process so  the process schedule and the frequency would be   weekly and weekly we are expecting around 100 to  300 items to process right so that means if the   person is doing this manually they are dealing  with close to 100 to 300 transaction on a weekly   basis right process execution time that how much  time does it take for the human to do this right   this is the address thing so it says that 15  minute per transaction so if I have to evaluate   the overall time if it is 300 records so that  would be 300 into 15 minute for one transaction   Peak period Peak period simply means that at  what point of the time your volume is more   right or the volume is less so you say that 100  to 300 so I can say that when I am at the last   working day of the month as per the banking  rules I get more transactions right so the   peak period for me is last working day of the  month transaction volume increases to 250 Plus   then it also talks about number of Ft supporting  this activity which means that how many full-time   employees are currently doing this automation  so as of now the UI Bank tells me that they have   three employees who are working on weekly basis  doing approximately close to 300 transaction   spending this much per transaction to do this  process right and then level of the exception   rate what would be the input data that would  be an email and a csb file the output data   would be an Excel and a summary email right so  this is gives me a good overview of the process   that what we are going to do so that was about  the as is process depending on your automation   we always can add more details or remove  the details which are not necessary fine   let us move forward again the moving forward I  can see now the next thing it talks about what   are the applications which are going to be used  in this automation so it tells me that you have   to use Microsoft Edge and it has given me the  build number you have to use Microsoft Excel and   it has given me the build number as well right  the version number or the build number is very   important whenever we take the requirement  now the reason for that is that let's say I   am using Microsoft Edge and that calls for a UI  automation selector based automation right if I   am using 107 version and let's say my development  machine has some old or some latest version   chances are there that my selector might be  different and the bank selector might be different   so in case the versions are not matching you will  land up a situation where the automation work with   the developer and it does not work in the client  machine right and then we always say that it   is working on my machine and it's not working on  your machine right that does not work that happens   because the application versions might mismatch  so at the starting of the automation make sure   you have the same version of the application and  that you can take a sign of as well right then it   is a thick line Thin Client what kind of access  you want to have you I want to have a read write   access so all these details would be available in  this block the next important bit in the PDD is   the Asus map which means that how is the business  doing this process manually without automation how   does this thing happen right so they have given me  this diagram they say that we start we read a loan   email which is received we download the attachment  we save the excel at some location right this we   can understand that our email is received they  download the attachment save the Excel then they   open the UI bank which is a browser based because  browser is involved they enter the loan details   the UI bank I guess is expected to give you a loan  ID that loan ID has to be put back to the Excel   and this Excel I guess is the same Excel here  and then once everything is done you send an   confirmation email and you stop so this is at a  high level what this automation is supposed to do   now we are not designing the solution we are just  trying to understand that what exactly we have the   requirement right so this at a very high level  it called the high level or the Asus process map   next in the PDD it has given me some of the  process statistics that total three processes   are involved five window action 48 Mouse clicks  28 and this diagram whatever you are looking on   the screen this is all the statistics everything  is created by a tool which is called task capture   okay so task capture is an application which is  used to actually draft the process design document   right so detail statistics is available that loan  application how many clicks you did in the loan   csb how many clicks all this detail information is  available here and the next thing in the PDF would   be that how you have to perform the operation you  would have a screenshot wise step by step defined   right so it says that open the email download and  save the attachment right so you have to go to an   email download and save the attachment right click  and save okay then you have to open that Excel   and what else if I just scroll down it  says that your Excel will have this kind   of data you have to click on First  Data you have to do a control plus c   and let me just quickly scroll it down so we  have to copy the data and then we have to open   this UI Bank application which is this guy we  have to fill up all these details Ctrl C Ctrl   V so this PDD has all the details if you guys  go and follow this manually I would be able to   perform the same operation right and it  has given me all those details with the   PDD usually you get all the set of the input  files as well okay so let me just scroll down   yeah so till this point they have given me all  the details that what needed to be do in the   automation right I have read through this complete  document and I understand what needs to be done   so this is the CSV which we get as an input in the  email that is what it is mentioned in the PDD that   you will have all these details title name address  credit card type credit card number age occupation   all these details you would get in a email has  an attachment and you have to apply for the loan   for all of these candidate right now I don't know  whether this data is correct not correct whether   they are eligible not eligible the PDD also told  me that about the UI Bank application so I got the   URL and this is how the UI Bank application look  like this has the feedlike email address the loan   amount requested loan term what is your current  yearly income before the taxes what is the age and   when you click on submit it actually gives you the  loan ID which needs to be appended here right so   all these details I got from this document and now  I pretty much understand what exactly we need to   do in the automation right we would get an email  we download this we fill up all these details and   once we generate the loan ID we have to put the  mail ID back here the loan ID back here okay if I   further go to the process design document it gives  me something else that what is in scope of RPA and   what is not in scope of RPA that what are the  things that the robot should do the robot should   receive the email sent from the business team okay  the robot should download the email attachment   which would have the email details read the  CSV file open the UI Bank key in the data right   generate the loan ID revert the loan ID email  sent back to the business right to the same mail   ID where you receive these details you have to  revert back with the loan ID correct so these are   the things which I can understand from the ah PDD  what are the other things out scope of RPA there   are the things which we would mention that which  typically RPA would not be able to perform okay   you have to always think from the business  point of view whenever we are doing with   automation right so as your business analyst  would have done his job so he would also   the business analyst would also tell you that what  are the business exception that you need to handle   while coding this automation right so I can  see that there are some of the condition   which we need to take care the first one is  no email simply means if I do not get an email   you need to send a business exception if you get  an email but it do not have an attachment then   also you need to generate a business exception you  get a CSV in the email but the CSV is blank can   happen right so then also you need to generate  a business exception it has also given me some   condition that loan term should be one three five  and ten only right so if I go to my input Excel   yes so there is something which is called loan  term and I can see that there are something 14 11   3 7 12. but my process document says that you need  to generate the loan only if the loan term is one   three five and ten that means the board should  not generate and not apply for all the loans   where it is some different value apart from this  right so all things we need to consider when we   are designing the solution the next condition it  says that the H should not be less than 18 months   right we have an age column here so it says that  you need to give to loan to the people whose age   is greater than 18 right the last condition says  the loan amount should be less than three times   of the yearly income right so these are the  three condition which we need to take care   when we are actually handling or creating this  automation that the loan amount should be less   than three times of the yearly income right so  if I am looking for a loan of let's say 1 lakh   I should have a yearly income of let's say ah 40  000 then only I will be eligible for a one lakh   loan because three of my yearly salary that is  three into forty thousand will give me one lakh   twenty thousand that would be more than the loan  amount right so these are the conditions which we   need to take care when we are designing the  solution right so this detail would be also   given to you when you get the business requirement  right so these are all the things which you need   to take care when you designed it right the next  section talks about known exceptions what are the   known exceptions in this process right some of the  known exception could be browser not responding   you have the UI bank which is working on the  browser and suddenly it start responding restart   the browser email not sent or received this  complete automation is working on an email but   let's say you receive uh this complete automation  work on the concept of email but let's say I do   not have the email available with me right so what  should I do I can contact to the info at the rate   of mail server team office is not installed I need  Excel I need email I need Outlook but let's say   my office is not installed on the computer I need  to contact to the admin team and this is my admin   email ID browser extension missing what it simply  means that UI bank is opening in browser right to   interact with the uipath you would always require  the UI plugin one finder you go to the machine and   you find that the browser extension is missing  what you need to do you need to contact to the   uipart.admin dot manage right so these are all  the details which the process design document   would have with the proper contact details and  everything right depending again depending on   the kind of Automation and the thing you are using  you would have more details available here right   what happens when the application crashes what  kind of error messages unknown error unknown   exception all those details would be available  in this document right where should you write   transaction logs error logs each and every detail  would be available in the process design document   right so we have walked through the process  design document and I hope now you understand   that what exactly does the automation require  what are the things we need to take care of right   so once you are finalized with the PDD you  have the sign of PDD from the business the   next document which you would like to prepare  is called the solution design document right   that brings us to the end of the process design  document so I hope with me you are also able to   understand that what exactly is the process what  we have to develop for whom we are developing the   process what are the business accession scenarios  what are the things we need to take care right so   see you in the next section where we will be  discussing about the solution design document okay so now that we have understood the process  design document and what needs to be done in the   automation the next step is to create the  solution design document which typically   is created by the solution architect  the senior developer and the developer   the solution design document would be having  the things related to the development it would   be having the overall architecture that  how we are going to design the solution   what are the things we need to take care of  how would the exception be handled typically   the flowchart of the development and the  other details right so let's quickly walk   through the sdd for this process which  is called the loan application processing so this is the table of content which is available  let me quickly scroll to the down and see what we   have got in the document the first thing is  that what exactly is the purpose so the focus   of the solution architect was on increasing the  robustness scalability efficiency replaceability   code visibility right and this talks about  a little bit about the UI Bank application   if I further move down to the sdd I can  see that the robot type is unattended the   orchestrator used is yes scalable is yes  the uipath version used is 2022.10 right   so now if you notice here the difference from  the PDD and the sdd is that the sdd is having   more technical details which are close to the  development or I would say to the developer okay   architectural structure of the master project  right so this is the high level diagram that   what exactly the automation is going to do if you  notice here it's say that start by reading the   email if the email is received you validate the  attachment if the email is not received you raise   a business exception and stop the process right  once you validate the attachment if the attachment   is valid you say download and save the attachment  otherwise you raise a business exception   same thing you download save the attachment  open the first sheet read all the records one   by one you validate if the data is available  you do the business validation so remember   we total have three condition which we need  to validate if any of those condition fail   we simply raise a business exception if all  the data is available it satisfies all the   criteria we go to the open UI Bank application  which is in the browser key in all the data   get the loan ID populate the Excel and  we stop the process all right so this is   a high level diagram of what exactly we  need to do in this automation okay and   this indicates that these are the operation  which we are going to perform in the browser   furthermore in the sdd we have these details which  are available that what exactly is the production   environment it is running on the Windows Virtual  Machine prerequisite to run would be an input   email within CSV file attached that is having all  the loan details right input data is a one valid   CSV and a UI Bank application the expected output  for the process is one email with the loan numbers   how do you start the automation process it will be  scheduled from the orchestrator for the reporting   purpose we are going to use the orchestrator logs  do I use queues keyboard or any other platform   it's not applicable now the question arises  how is the orchestrator used so we are using   it to schedule from the orchestrator we can use  assets right so you can specify the details here   any password policy you need to maintain can be  specified orchestrator locks would be mentioning   the compliances credentials where exactly you  want to store the credential we are going to use   orchestrator naming convention everything what is  the schedule details we are going to schedule it   at weekly 6 AM CET right so this now you notice in  difference to the PDD which was more close to the   business requirement this document is more close  to the developer how do you schedule how do you   manage the exception at what time you want to  schedule it what would be the input what would   be the output how is the orchestrator used where  is the orchestrator all these details would be   typically part of your solution design document  right if I further move the document you would   notice that it tells me about the description  the environment prerequisite that I require a   Windows 10 I require UI path assistant I require  license Microsoft Excel Microsoft Edge to store   the code I am using GitHub I am using configs and  the asset to store the configurable things right   how many reusable components I have made are  there any new reasonable components so all   these information would be part of your STD the  same document also you can mention that are there   any future improvements which you want to have  in the process any other remarks which you need   to have and all the details which are technically  important would be a part of the solution design   document right so that was the PDD and the sdd  for this use case which we are going to build   okay so I hope you guys are following along with  me and we have all understood what exactly is   the STD for this use case if that is the case I  want you to type sdd in the comment box so that   I understand that we all are on the same page in  the next part of this video I would be coding the   entire solution for this by a step-by-step Manner  and don't worry about the files the PDD the sdd   and all the relevant documents I would share it to  you once we complete the end-to-end implementation   so for that you would have to stick to the  channel please like this video subscribe to   the channel and hit the Bell notification so  that as soon as I upload the next video you   get a immediate notification so I would like to  wrap this video here thank you for watching if   you like this video please do subscribe to the  channel and happy automation [Music] thank you

Channel: Tutorials by Mukesh Kala

Views: 18,490

Keywords: UiPath, UiPathCommunity, RPA, LearnRPA, Tutorials By Mukesh Kala, automation, tutorials, how to, uipath tutorials, uipath beginner, robotic process automation, UiPathRPA, uipath rpa, UiPath Videos, Rpa tutorial, Robotic Process Automation, UiPath basic, UiPath Advance tutorial, uipath training, UiPath examples, uipath video, RPA Training, UiPath Mukesh Kala

Id: ypKMeph_UW4

Length: 36min 16sec (2176 seconds)

Published: Mon Dec 26 2022