JAYAVARDHAN GANDIKOTA

Lead RPA Developer (UiPath)

+1-469-***-**** ad4fpn@r.postjobfree.com

EXPERIENCE SUMMARY

9+ years of total IT experience which includes 7 years of experience in Robotic process automation using RPA UiPath tool and 2 years of hands-on experience using Power Automate. I have worked closely with customer’s/business stake holders in transforming the business with the help of RPA. Played roles of Lead developer, Consultant / Senior Developer.

Worked with Banking, Finance, Insurance, HR, Telecommunication and Health Care industries.

With 8 years into RPA, I have been working on UiPath with strong fundamental knowledge on Studio, Orchestrator, Infrastructure and Platform Migration.

Involved in process automation collaborations with business users globally to analyse business process, recommend RPA based solutions for the processes and develop robots using Automation anywhere software.

I have facilitated Training sessions for college students utilizing the UiPath tool as part of a government-sponsored scheme, providing comprehensive instruction in RPA.

Implement and optimize automation scripts in UiPath Studio and Power Automate. Proficient in UiPath Studio, Robot, and Orchestrator, with hands-on experience in deploying bots from development to production environments.

Strong knowledge with Agile, Waterfall methodologies. Involved in end-to-end implementations, maintenance and support projects.

Expertise in preparing Process Design Documents (PDD), Solution Design Documents (SDD), Runbooks and Technical Documents for effective project documentation.

Experience in setting up UiPath platform such as installing all components of UiPath and enabling multi tenancy in UiPath Orchestrator.

Strong knowledge in Document extraction methodologies. Used UiPath Intelligent OCR extract data from structed and unstructured document models.

Work experience in Intelligent Document Processing (IDP) utilizing UiPath Advanced AI Center Machine Learning Models and UiPath Document Understanding, leveraging Out-of-box ML models within the realm of AI-related automation.

Developed Custom Activities using C# and reusable components.

Knowledge in Integration of ServiceNow with UiPath.

Strong knowledge in designing UiPath automations using Web, Excel, PDF, REST API, Main Frames, SAP Automation (EPR), CITRIX and Salesforce (CRM) and Modern Design UiPath.

Hands on experience on UiPath Test Suite implementations.

Implemented Enhanced RE-Framework in UiPath projects, enhancing system integration capabilities.

Familiar with Microsoft Power Automate, Power Apps, Forms, Power BI, SharePoint.

Supported user training, documentation, and roll-out activities, ensuring a smooth transition to automated processes.

Highly motivated, Pro-active and possess excellent technical, interpersonal & problem-solving skills and motivating others to produce results on time.

Strong hands-on experience in designing complex automation using RE Framework.

Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology and develop business solutions that increase efficiency, productivity, and profitability.

Excellent documentation and presentation skills.

SKILLS

Robotic Process Automation

UiPath (v 2016.2, 2018.4, 2019.10,2020.10, 2022.10, 2023.6), Orchestrator and Power Automate

Language and Scripts

C#, VB.Net, Java

Cloud Services

Azure

Project and Test Management

Jira, MS Team Foundation Server

Service Management

ServiceNow

Diagramming Vector Graphics

MS Visio

Methodology

Waterfall Model, Agile – Scrum

CI/CD

Bitbucket

Version Controlling

GIT, SVN and Bitbucket

Data Base

My SQL Server

Web Technologies

HTML, JavaScript

Data Visualization

Kibana and Power BI

Collaboration and Documentation tool

Confluence

Type of Automations

Web, Desktop, MS Excel, Native/scanned PDF, REST API, MS Word, Main Frames, SAP Automation (EPR), text files, CITRIX, Computer vision, Salesforce (CRM), Modern Design Uipath, Communication Mining

UiPath Components and Features

UiPath Studio, UiPath Orchestrator, UiPath Robots, Action Center, AI Center using Out-of-box ML models (IDP), and Document Understanding, OCR, Generative AI and UiPath Test Suite (Uipath Test Manager)

Power Platform

Power Apps, Power BI, and SharePoint

WORK EXPERIENCE

JPMorgan chase & co.

Lead Engineer - 06/2023 to Till Date

PepsiCo

Lead Engineer - 11/2021 to 03/2023

Alight Solutions

Senior Software Engineer - 12/2019 to 10/2021

ThermoFisher Scientific Inc.

Software Engineer - 03/2015 to 11/2019

EDUCATION

Singhania University

Bachelor of Science (B.Sc), 2014

CERTIFICATIONS

Certified Solution Architect

UiPath Certified Professional Advanced RPA Developer (UiARD) Certification (2023)

Certified UiPath Foundation

Certified UiPath Infrastructure

Certified UiPath Implementation Methodology

Certified UiPath Test Suite developer

PROJECTS HANDELED ACROSS THE CAREER

Project#1

Project-name : Intelligent Collection Agent Triggering

Organization : JPMorgan Chase & Co.

Technologies used : UiPath, AI Center/ML, Action Center and IDP using Document Understanding

Target Applications : Workflow manager, SAP Application

Role : Lead RPA Developer

Duration : 06/2023 to till date

Roles & Responsibilities:

The Scope of the project is developing end-to-end RPA Automation process to handle Windows Manager Data for the client JPMorgan Chase & Co. using AI/ML Automation and SAP integration.

Involved in Business Meeting for Requirement gathering.

Created SDD and Run Book Documents.

Implemented out-of-the-box ML models for Invoices which are in SAP application for incident categorization.

Applied Semantic similarity for mapping email questions to the knowledge base.

Conducted Sentiment Analysis to determine urgency and assigned the correct category and team in the ServiceNow portal.

Automated incident categorization processes using ML models to enhance efficiency.

Optimized workflows for faster and more accurate incident handling.

Collaborated with cross-functional teams for seamless integration of NLP models into ServiceNow.

Ensured effective communication channels between different modules of the project.

Documented ML models and configurations for future reference.

Generated reports on incident categorization performance and improvements.

Identified and implemented enhancements based on performance feedback and system monitoring.

Conducted regular evaluations to improve the accuracy and efficiency of NLP models.

Project#2

Project-name : GDPC (Global Development Programming Communications) Organization : PepsiCo

Technologies used : UiPath

Target Applications : Excel, MS Word and SharePoint

Role : Lead RPA Developer

Duration : 12/2022 to 03/2023

Roles & Responsibilities:

The Scope of the project is developing end-to-end RPA Automation process to handle HR Data for the client Pepsico using Exce, MSWord Automation and Sharepoint integration.

Involved in Business Meetings for Requirement gathering.

Created PDD, SDD and Run Book Documents.

Involved and experienced with full systems life cycle to include planning, coding, testing, and documentation for RPA activities.

Analysed the feasibility of existing process suitable for automation.

Worked with UI Automation, ServiceNow Integration to create end-to-end process automation using UiPath.

Participated in Agile Scrum Sprint design, daily Standup calls and Retrospective

Involved in code review and fine tuning the code for performance related issues.

Design UiPath Automation Framework to test and handle the defects/bugs found in testing and work on debugging application for fixing bugs and Production support.

Designed and Developed scalable Unattended bots using various Design approaches like Queues, Dispatcher-Performer, Scheduled and Real Time.

Monitored Dev Readiness, Solution Designs, Code Development and facilitate Process deployments to production and worked with test teams during the Product test and UAT phases to fix assigned bugs.

Maintaining several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization.

Project#3

Project-name : AP invoice processing Automation

Organization : PepsiCo

Technologies used : UiPath, IDP using UiPath Document Understanding

Target Applications : Outlook, MS-SQL Database

Role : Lead RPA Developer

Duration : 08/2022 to 11/2022

Roles & Responsibilities:

Involved in Business Meeting for Requirement gathering.

Created SDD and Run Book Documents.

Utilized UiPath and Document Understanding (IDP) for automation of invoice processing.

Configured the robot to download and extract information from digital and scanned invoices received via AP mailbox.

Integrated UiPath with Oracle EBS to post and submit invoice information.

Utilized AI Centre for training invoices using ML pipelines.

Ran ML pipelines for retraining ML Skills to enhance the accuracy of data extraction from invoices.

Collaborated with RPA Developers to integrate ML models into the automation workflow.

Documented the automation workflow, ML training processes, and configurations.

Generated reports on the performance of the automated system and ML models.

Implemented continuous improvements based on feedback and monitoring of the automation process.

Collaborated on optimizing ML models for better accuracy and efficiency.

Project#4

Project-name : SFDC Testing

Organization : PepsiCo

Technologies used : Lead RPA Developer

Target Applications : SFDC, Oracle OIC, Oracle Fusion Cloud

Role : Lead RPA Developer

Duration : 05/2022 to 07/2022

Roles & Responsibilities:

The Scope of the project is developing end-to-end RPA Automation process to handle Termination requests of the user for the client Pepsico using UI Automation, Testing and ServiceNow integration.

Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Documents).

Participated in demo meetings to demonstrate the capabilities of RPA for on-going projects and potential clients.

Involved and experienced with full systems life cycle to include planning, coding, testing, and documentation for RPA activities.

Analyzed the feasibility of existing process suitable for automation.

Worked with UI Automation, DataBase integration and ServiceNow Integration to create end-to-end process automation using UiPath.

Participated in Agile Scrum Sprint design, daily Standup calls and Retrospective

Involved in code review and fine tuning the code for performance related issues.

Design UiPath Test Suite Automation Framework to test and handle the defects/bugs found in testing and work on debugging application for fixing bugs and Production support.

Designed and Developed scalable Unattended bots using various Design approaches like Queues, Dispatcher-Performer, Scheduled and Real Time.

Monitored Dev Readiness, Solution Designs, Code Development and facilitate Process deployments to production and worked with test teams during the Product test and UAT phases to fix assigned bugs.

Maintaining several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization.

Project#5

Project-name : User / Contractor On-boarding

Organization : PepsiCo

Technologies used : Power Automate

Target Applications : Jira, One Login, and Jobvite

Role : Lead RPA Developer

Duration : 03/2022 to 06/2022

Project Description:

Involved in Business Meetings for Requirement gathering.

Created PDD, SDD and Run Book Documents.

Jira tickets are raised for new user requests and assigned to a designated robot user for processing.

The bot intelligently categorizes users as either contractors or employees based on predefined criteria.

For employee On-boarding, the bot retrieves user details from the Jobvite system, ensuring accurate and up-to-date information.

For contractors, relevant details are extracted from the Jira ticket itself.

The bot integrates with OneLogin to create user profiles, ensuring a unified identity management system.

Upon successful user creation, OnePass is utilized to securely share login credentials with the respective users.

The Power Automate workflow is visually designed to represent the sequential steps, including triggers for Jira ticket assignment, conditional logic for user categorization, and connectors for communication with AD, OneLogin, and OnePass.

The system incorporates error-handling mechanisms to identify and address any issues that may arise during the onboarding process, ensuring the reliability of the automated workflow.

The project adheres to security best practices, employing secure channels for data transfer and storage. Multi-factor authentication and encryption are implemented where applicable.

The design of the automated system allows for scalability, accommodating an increasing number of user onboarding requests without compromising efficiency.

Comprehensive logging mechanisms are implemented to record each step of the onboarding process. This facilitates auditing, troubleshooting, and performance analysis.

The project aligns with relevant compliance standards and data protection regulations to ensure the secure handling of user information.

Created documentation and conducted training sessions for relevant stakeholders, ensuring a smooth transition to the automated onboarding system.

Project#6

Project-name : User Provisioning / re-activation

Organization : PepsiCo

Technologies used : UiPath

Target Applications : Jira Corp, Salesforce, OneLogin, and Pullo (Active Directories)

Role : Lead RPA Developer

Duration : 11/2021 to 02/2022

Roles & Responsibilities:

Interacts with Jira via Rest API (Background automation) and extract user details like username and email etc. Bot will check the user status in Salesforce (UI based automation) to identify if user is active, inactive, or not available in Salesforce to take required action Bot will add/verify user in Pullo group Active Directory (UI based automation). Bot will verify user status again in Salesforce after some interval and update canned response in Jira and close the ticket.

Project#7

Project-name : Base pay - WFA (Work Force Administration)

Organization : Alight Solutions

Technologies used : Ui-Path, APIs Integration.

Target Applications : Salesforce Tool (Web Application), Oracle Database, Excel,

Role : Senior RPA Developer

Duration : 11/2020 to 10/2021

Roles & Responsibilities:

Collaborated closely with Business Team and Architecture.

Implemented REST API automation to fetch data from Excel and perform required operations.

Checked data matching in Salesforce using API requests for Requestor validation.

Developed logic for inserting, modifying, or deleting records in the Salesforce tool.

Integrated Oracle database for data storage after applying necessary operations.

Collaborated with team members to ensure seamless integration and data flow.

Utilized Salesforce APIs for data validation based on Emp ID, Name, HR, and Manager roles.

Collaborated with API Automation Developer for efficient API usage.

Configured and maintained Oracle database tables for efficient data storage.

Collaborated on designing a database schema aligned with client requirements.

Developed automation scripts to capture screenshots of operations.

Integrated screenshot capture seamlessly into the overall workflow.

Conducted regular team meetings for effective communication.

Addressed integration challenges and updates promptly.

Documented integration workflows and configurations.

Generated reports on data operations and database status.

Conducted regular reviews for process optimization.

Collaborated on implementing efficiency improvements.

Project#8

Project-name : Purchase Order Creation (PO)

Organization : Alight Solutions

Technologies used : Ui-Path

Target Applications : SAP Application, MS-SQL, Excel

Role : Senior RPA Developer

Duration : 03/2020 to 10/2020

Roles & Responsibilities:

Collaborated closely with Business Team and Architecture.

Created end-to-end automation for SAP Purchase Order processing using UiPath.

Collaborated on streamlining procurement tasks and reducing manual efforts.

Ensured seamless integration of UiPath with SAP for efficient data processing.

Provided insights for optimizing the procurement process for automation.

Ensured alignment of automated workflows with efficiency goals.

Conducted thorough testing of UiPath automation for accurate Purchase Order processing.

Documented UiPath workflows for future reference.

Generated reports on automation performance and efficiency gains.

Facilitated regular reviews for process optimization.

Collaborated on implementing enhancements for SAP automation.

Project#9

Project-name : DBD Ach Recon (Day-By-Day Automated Clearing House

Reconciliation) – TFSS (Tax Filing Shared Services)

Organization : Alight Solutions

Technologies used : Ui-Path, SQL Database, Pdf, Main Frames

Target Applications : SQL Database, Pdf

Role : Senior RPA Developer

Duration : 12/2019 to 02/2020

Roles & Responsibilities:

Developed automation scripts to process PDFs placed in a designated folder.

Extracted information from PDFs and entered the data into Excel.

Implemented required validations to standardize data as per client requirements.

Integrated SQL database for storing processed data.

Conducted validation checks to ensure data integrity and consistency.

Developed logic for comparing new data with existing data in the database.

Implemented automation for sending emails to respective teams.

Extracted and formatted the difference amounts from the database comparison results.

Ensured accurate and timely email notifications.

Conducted regular team meetings for effective communication.

Addressed automation challenges and updates promptly.

Documented automation workflows and configurations.

Generated reports on data operations, validations, and email notifications.

Conducted regular reviews for process optimization.

Collaborated on implementing efficiency improvements.

Project#10

Project-name : GL Report Automation

Organization : ThermoFisher Scientific

Technologies used : Ui-Path, SQL Database, Html

Target Applications : Master Web Application, Outlook, MS-SQL Database, Citrix

Role : RPA Developer

Duration : 03/2018 to 11/2019

Roles & Responsibilities:

Developed UiPath automation to navigate through the web application.

Downloaded reports for different clients using various navigation sequences.

Extracted data from downloaded Excel files.

Integrated SQL database for storing and managing the extracted data.

Developed automation to dump data from Excel files into the database.

Implemented automation to send reports to respective teams for corrections.

Extracted and included calculation differences in the email body.

Conducted data comparisons between newly extracted data and existing data in the database.

Identified any differences and triggered the sending of reports for corrections.

Conducted regular team meetings for effective communication.

Addressed automation challenges and updates promptly.

Documented automation workflows and configurations.

Generated reports on data operations, comparisons, and email notifications.

Conducted regular reviews for process optimization.

Collaborated on implementing efficiency improvements.

Project#11

Project-name : Amendment Returns and Negative wages processing.

Organization : ThermoFisher Scientific

Technologies used : Ui-Path, SQL Database, Macros, Excel

Target Applications : Master Web Application and SQL Database

Role : RPA Developer Duration Duration : 03/2017 to 02/2018

Roles & Responsibilities:

Developed UiPath automation to fetch Excel files from a specific folder.

Applied macros to standardize the Excel files as per client requirements.

Navigated through the web application to upload the standardized Excel files to specific client pages.

Created and optimized macros for standardizing Excel files.

Collaborated with UiPath Automation Developer for seamless integration of macros in the automation workflow.

Integrated SQL database for tracking and updating the status of each client.

Developed automation to update the database with the number of client reports received and uploaded in a day.

Conducted regular team meetings for effective communication.

Addressed automation challenges and updates promptly.

Documented automation workflows, macro configurations, and database updates.

Generated reports on the daily status of client reports received and uploaded.

Conducted regular reviews for process optimization.

Collaborated on implementing efficiency improvements.

Project#12

Project-name : Utility bills processing Automation

Organization : ThermoFisher Scientific

Technologies used : UiPath, OCR

Target Applications : P2P Application (Web Application)

Role : RPA Developer

Duration : 02/2016 to 02/2017

Roles & Responsibilities:

Invoices will be placed in one folder Bot will process through OCR engine invoices based on confidence score invoices will be processed STP and some invoices will be sent for Validation station. After exporting invoice information using intelligent OCR activities Bot will process the exported data and prepare based on the predefined template and will prepare for bulk upload and will uploaded to P2P application and will upload invoice file for each invoice and will be make ready for approval and payment.

Project#13

Project-name : Fund Accounting - Client Reporting

Organization : ThermoFisher Scientific

Technologies used : UiPath

Target Applications : Wealth Spectrum (Web Application), Outlook

Role : RPA Developer

Duration : 08/2015 to 01/2016

Roles & Responsibilities:

Downloading daily reports from Wealth spectrum, performing reconciliation, archiving reports with encryption, and sending archived file to customers.

Contact this candidate