East Call Center (US Client)

RPA Tool: UiPath
Applications Automated: Excel, Outlook, SQL Server, Oracle, SharePoint
Project Overview: There were 15 different modules of the retail department. Business users must fetch the data from SQL Server, Oracle, SharePoint, Excel, and update the data into Master Template which are in a shared folder with lacs of records. And the user has to create Pivot Table, Apply Pivot Filter to multiple output reports (Current Date, Weekly Filter, Monthly, Second Last Date Filter, Previous Business Day Filter), and the user has to send Final updated reports to multiple Business User.

Sales Order Creation (Singapore Client)

RPA Tool: UiPath
Applications Automated: Notepad, Excel, Outlook, SAP
Project Overview: This Process included multiple EDI (Text Files) files from Billing Department for different vendors from which the data was extracted and accordingly SAP Details were updated. BOT will check that SO is created or not and will process further accordingly. If the SO does not exist, then bot creates the Sales order and sends an email notification to business with the result.

India Private Report

RPA Tool: UiPath
Applications Automated: SAP, Excel, Outlook, Chrome, Google Sheet
Project Overview: In this process Manufacturing department user downloads the data from SAP from 5 different T-codes, Download the HTML Report and converts it into the Excel format, after processing all the files user updates the Final Master Template and sends an output the Business user every day.

Export Report

RPA Tool: UiPath
Applications Automated: SAP, Excel, Outlook, Chrome, Google Sheet
Project Overview: In this process Manufacturing department user downloads the data from SAP from 5 different T-codes, Download the HTML Report and converts it into the Excel format, after processing all the files user updates the Final Master Template and sends an output the Business user every da

Invoice Processing (PDF)

RPA Tool: UiPath
Applications Automated: SAP, Excel, Outlook, Chrome (HTML Report)
Project Overview: In this Billing Department process the User reads the Digital invoices from different vendors with different templates. It copies the data from pdf like Vendor Name, Invoice No, Invoice Name, GST No from, GST No To, SGST, CGST, IGST, Type of Supply, Total tax etc. and updates the data into final output template and sends the same result with Business through an email.

Birthday Wish Bot

RPA Tool: UiPath
Applications Automated: HRMS Portal, Excel, Outlook, Chrome, PPT

In this process BOT downloads the Employee Details file from HRMS portal and it will fetch only current date Employee details and will
- Create a Birthday Card for the Employees every day (PPT Template)
- Sends Birthday Card to Employee and its Manager through SMTP Mail(VB).
- Posting the Birthday Card on (Facebook Page) Workplace Page.

SignaVio File Upload Process

RPA Tool: UiPath
Applications Automated: Excel, Outlook, WebPortal, GoogleSheets
Project Overview: Bot Downloads the Google Sheet as input and reads the records and bot navigates to the Web Portal, downloads the Report from web portal i.e. CSV file and copies the data from CSV to Google Sheet for Each record and sends a status mail to business with the result.

Invoice Creation (US)

RPA Tool: Automation Anywhere (A2019 Version)
Applications Automated: Excel, Outlook, WebPortal, GoogleSheets
Project Overview: Bot logins to workday Web Portal Extract the Invoice Table and save to Excel then navigates to SharePoint and downloads the Purchase order receipt and upload to Workday Web portal for each Invoice Number.

Updates the status of each record in the Status report and Sends to Business user.