RPA Projects ListContact / Links Skills UiPath Automation Projects List Stock & Crypto Consolidation UiPath Generic Framework
|UiPath Forum Profile||Among most active users. Ranked top 10-15 in terms of solutions provided||Profile Link|
|UiPath Marketplace Profile||Created and uploaded multiple templates/frameworks/snippets/reusable components. 10k+ total downloads||Profile Link|
|Resume + Job references||Download|
Some of my personal RPA projects and experience
|Chatbot that combine OpenAI and text-to-video tech||By combining OpenAI's language processing capabilities with D-ID's text-to-video technology, this tool lets you upload a photo and turn it into a "Speaking portrait", allowing you to interact with it!||NodeJS, OpenAI, D-ID||Watch Video Here
|Upload documents and ask questions about these documents||Web application where you can upload any document (of ANY size/page count), and ask questions about these documents. The questions and answers will be stored on the web app||NodeJS, OpenAI, Langchain, SQL||Watch Video Here
|Generative AI Tool for Insurance||1. Automatically extract key information from uploaded theft forms, and generate verdict (approve/decline) as well as give a reason for the verdict. 2. Allow claims officers to ask questions about the claim and about the policy via chatbot. 3. Automatically generate an email reply to the claimant with the results of the claims analysis||NodeJS, OpenAI, Langchain||Watch Video Here
|Job Scraping from 5 job portals into Google Sheets||This process involves an agent setting specific parameters such as candidate name, job position, maximum number of records to gather, and chosen job portals. Once configured, a robot autonomously collects data from these job portals and organizes it into respective candidate dashboards for convenient access and review.||UiPath, OpenAI, VBA, Python, Google Sheets||Watch Video Here
|Extract fields from candidate CV and generate fixed-format company CV||For each CV in input folder, extract key fields into Google Sheets, after the sheet is verified and marked "Confirmed", the robot will generated a fixed-format word CV based on the details in the Google Sheet||UiPath, OpenAI, VBA, Google Sheets||Watch Video Here
|VIdeo Demo Pending...||UiPath, OpenAI, Google Sheets|
|Cost Center Allocation||(SAP Process) Allocation of costs from one cost center to another and verify result||UiPath, VBA, VbScript, SAP||Watch Video Here
|Processing Fee settlement||(SAP Process) Download data from sap, consolidate excel and generate voucher, upload voucher and perform batch approval in SAP||UiPath, VBA, VbScript, SAP||Watch Video Here
This is another one of my personal projects, but I have included a detailed walkthrough of the process here!
Generate an excel summary for a list of crpytocurrency and stock tickers. The tickers are specified by the user.
|Subprocess 1||Add Tickers To List||Attended robot|
|Subprocess 2||Generate summary of tickers||Unattended robot|
|Systems involved||Web browser (Chrome)|
|Type of RPA||Data scraping from multiple websites, Data consolidation|
This process lets the user specify a list of Tickers (Stock/Crypto) for the robot. When the user runs this process, an excel table will popup, the user can fill in this table and click "OK".
The robot will then store this table in a JSON file. (If the JSON file already contains tickers, it will append to it)
When subprocess 2 runs, the robot will look at this list to know which stocks / cryptocurrency tickers to look at.
The robot will go through the list of tickers in the JSON file. For each ticker - if the type = Stock, the robot will extract details from Nasdaq website, if type = Crypto, the robot will extract details from CoinMarketCap website. All the details and charts will be consolidated in an excel file.
Then it will generate an email (on the right) containing a summary of the details; the excel file that the robot also generated is attached in the email. The below video shows the details of the excel file
This is the framework (built on top of UiPath's own REFramework) I use throughout almost all my projects. The one shown here is the base framework but for each project I will extend it to fit the client requirements
Generic framework applicable to any process, and can be built on top of your own processes. Easy to configure.
|Type of RPA||Generic framework|
Before the main process starts, the robot will run a "healthcheck" in the "Initialization" stage to ensure that all the required files, folders and credentials exist. The list of files/folders/credentials can be configured inside the program
After the healthcheck is completed, the robot will send a summary email stating whether the healthcheck is successful or not. If its successful, it can continue to the main process, otherwise, it will end
After the process is finished running, the robot will send a summary email. This email contains a table summary of all the main steps that has been executed by the robot