$20

Hourly Consulting Rate

Vrushali Patil

Independent Consultant

Industry Experience

Financial Services

Logistics/Procurement

Transportation

Location Supported

Worldwide

Languages Supported

English

Skills

  • Robotic process automation

Product Specialization

  • UiPath Robotic Process Automation
  • Automation Anywhere Enterprise

About

• Overall 3+ years of IT experience with 2.5 years of experience in both Automation Anywhere RPA and UiPath RPA development.
• Basic Knowledge of Robotic Process Automation Development with tools Blue Prism and Scripting in Python.
• Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.
• Used String Operation to Compare and eliminate duplicates from the data.
• Worked on using Excel and CSV commands with Automation Anywhere.
• Experience in using Send Email command to Email reports and errors.
• Experience in using Delay and Wait for commands with Automation Anywhere.
• Worked on Activities using Object Cloning and Manage Web Controls.
• Strong and precise understanding of Automation Anywhere Platform and UiPath Studios technological limitations and Clear understanding of Windows/Web/Text app integration with Interaction framework.
• Good knowledge of Database concept's in SQL Server & MySQL.
• Worked on various quality assurance methodologies such as Waterfall and Agile Methodologies and a solid understanding of the SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle).

Top Project Highlights

Payment Application

The project is about different payments (Clear,  OnAccount, Short, and Overpayment) of the business process and post it to SAP.

Responsibilities :

  • Modified existing software to CORRECT ERROR, UPGRADE interface, and improve performance.
  • Solving service tickets and incidents on a priority basis.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Design Meta bot to perform Business Logic.

ATR Cash and Bank

The user puts a file into folder and bots picked one by one file for processing after that all data is pushed into SAP.

Responsibilities:

  • Modified existing software to CORRECT ERROR, UPGRADE interface, and improve performance.
  • Solving service tickets and incidents on a priority basis.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Design Meta bot to perform Business Logic.

Late Voucher Creation

The Project is related to get some containers as input from customers, If the container state is Gate-Out/ Gate-in then only we process the containers and compare the dates and inform to the user that this is a late voucher (Have time to process this).

Responsibilities:

  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.

SOB Updation

The project is related to get some containers and dates as input from customers, then open containers in GCSS and update the given dates in GCSS. After updating export updated data from the database into excel and send updated sheets to customer.

Responsibilities :

  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.

Insurance Booking : Telebinding

The process is related to book insurance for home appliances like T.V, Fridge, Washing Machine. We get some insurance booking cases from the salesperson. Then dump all data in DB, and take one by one record for processing. This project is related to matching tenure and adding amount against the deal id. After completing the process, extract records from the database to excel and send an updated sheet to the customer.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

Mandate Dispatch

We downloading input reports from MPAS application for 38 banks, consolidating all input and segregating the data file wise. Then dump all data in DB, and take one by one record for processing. This project is related to matching LAN no with images that are getting from the WinSCP tool and renaming the images with LAN no, and making the zip file and uploading this data into the MPS web application. After completing the process, extract records from the database to excel and send an updated sheet to the customer.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project. 
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Making User Manual for the Support team.

Master 1A IFA

We get some cases from customers over mail. Then dump all data in DB, and apply input validations as mentioned in BRD. Then prepare files for uploading in finnone web application for code creation. This project is related to create codes against IFA, DME, Galaxie applications. Then after code creation in finnone web application downloading a file and update status against the records in DB using downloaded report file from finnone web application. After completing the process, extract records from the database to excel and send an updated sheet to the customer.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

Distributed Personal Loan(DPL)

This project is related to Personal Loan. We get some cases from customers over mail. Then dump all data in DB, and apply input validations as mentioned in BRD. Then put inputs in Finnone web application and book the personal loans and update status against the records in DB. After completing the process, extract records from the database to excel and send an updated sheet to the customer.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

CV Liberary

This process is related to update inputs on the CV portal. We read the input file and login to the CV-Library portal and navigate to the search CV page. Then enter inputs like domain name, experience, etc. Then extract data from the table and store it into UiPath first data table. Then navigate to each and every profile and extract contact details and email and store that into the second data table. Then merge these 2 data tables and consolidate in 1 data table and then enter the values in excel. Send this consolidated excel to customers.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  •  Making User Manual for the Support team.

PDF Integration

This project is related to fetch data from different PDF’s. Read PDF files from the shared drive and convert it into a string. Then we are applying regex formula to extract email id, contact number, address, and put this in one data table and then, at last, read this data table and put values in excel and format the excel. And send this excel file to customers.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

CI Automation Team

This project is related to filter out data from the web and fetch data from the web. Open the Automation Browser and Enter City Name and State on the web page and click Submit. Filtered data is shown. Create a new excel with a header as  “Name”, “Surname”, “Address”, “City”, ”State”, ”Zip Code”, ”Country”, ”Occupation”, ”Company”. Fill the Input data extracted from the web into newly created Excel with respective fields. Repeat this for all the values in filtered data. 

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

Comparing prices from different online stores

The objective of this case study is to prepare an RPA to compare multipurpose printer prices of Flipkart and amazon online shop. All related category products from Flipkart and Amazon shall be listed in an xls/xlsx file. If the model name is matching then the price difference shall be shown in the report. Use the model name of the printer for comparison.

Responsibilities:

  • Making TDD as per requirements.
  • End to end development.
  • Involved in the Smoke testing of the project.
  • Requirements gathering from clients.
  • Done Unit Testing and UAT.
  • Design Meta bot to perform Business Logic.
  • Making User Manual for the Support team.

 

First XLS shall contain:Model Name, Price, Rating, offers (All from Flipkart)

Second XLS shall contain: Model Name, Price, Rating, offers (All from Amazon)

Third XLS shall contain: Model Name, Price Flipkart, Price Amazon, Price difference

Employment

Automation Developer

2020 - Present
    • Actively involved in requirement analysis, project design, and project planning.
    • Developed apps using Automation Anywhere.
    • Gathered business rules and requirements and converted it to code and automation in Automation Anywhere and in UiPath Studio.
    • Effectively identified, debugged, and resolved bug issues in Automation Anywhere using the debugger.
    • Documented Automation Anywhere training materials and user manual for the current solution app.
    • Communication with Management and BA to keep them updated on progress.
    • Responsible for regular production support activities as well as maintenance-related tasks.
    • Analysis of Business and Technical Requirements.
    • Involved in the UAT testing with End-User

Associate Programmer

2019 - 2020
    • Actively involved in requirement analysis, project design, and project planning.
    • Developed apps using Automation Anywhere.
    • Gathered business rules and requirements and converted it to code and automation in Automation Anywhere and in UiPath Studio.
    • Effectively identified, debugged, and resolved bug issues in Automation Anywhere using the debugger.
    • Documented Automation Anywhere training materials and user manual for the current solution app.
    • Communication with Management and BA to keep them updated on progress.
    • Responsible for regular production support activities as well as maintenance-related tasks.
    • Analysis of Business and Technical Requirements.
    • Involved in the UAT testing with End-User

Associate Programmer

2017 - 2019
    • Worked on BOT Design, Testing, Production, and identified the design flaws based on service requests and issues.
    • Handled the BOT inventory and new automation requests while analyzing design feasibility and calculating benefits.
    • Performed Quality and Analysis based on Quality Management System Manual and prepared quality check reports.
    • Prepared project reports, performance specifications for BOTs, and delivered presentations for the team.
    • Gathering detailed requirements from the Client for business requirements.
    • Preparing Impact Analysis by analyzing the existing system for automation development.
    • Preparing the design document about the automation process.

Education

Computer Diploma
2010-2013

After the 10th Join Diploma course in Computer Science Full-time course From Pune University.

B.E
2013-2016

B.E in Computer Science Full time course from Pune University.

M.Tech
2018-2020

M.Tech in a software system, Work Integrated Course from BITS Pilani.

Certification

ITIL
2017-2017
Ui Path Orchestrator
2018-2018
Ui Path RPA Developer Foundation
2018-2018
Automation Anywhere Advanced Professional
2019-2019
Automation Anywhere Master Professional
2019-2019
Big Data 101 IBM Badges
2019-2019
Hadoop 101 IBM Badges
2020-2020
Spark 101 IBM Badges
2020-2020

Ooops!

Maximum of Three products are allowed for comparision