Rpa Developer Sql Database

Lakshmi Kavuri

Email: ad7imt@r.postjobfree.com

Tel: 248-***-****

PROFESSIONAL SUMMARY:

6+ years of constructive experience in IT which includes around 4 years of experience with full project development, implementation, and deployment using UIPATH STUDIO and UIPATH ORCHESTRATOR as a CERTIFIED ROBOTIC PROCESS AUTOMATION (RPA) developer.

Completed training and certification on RPA Developer Associate and RPA Developer Advanced.

Designed, Developed, and tested BOT tasks using RPA UiPath and scheduled using Power Automate.

Involved in the creation of different business documents including flowchart diagrams, PDD, SDD/TDD, As-Is, To-Be, Test cases, Test Scripts, change logs, Defect logs, Creating Libraries, and review checklists.

Involved in Static Code Analysis to debug the source code, detecting the issue, reporting it to Developer

Designed applications with excellent exception-handling mechanisms.

Experience in installing, upgrading, migrating, optimizing, performance tuning, and configuring UiPath Applications.

Experience in working with Orchestrator Test Manager.

Worked on the usage of different Screen Scraping methods (Full text, Native, and OCR) in UiPath.

Created and Scheduled the Bots in Control Tower (UiPath Orchestrator).

Expertise in scheduling and triggering tasks with advanced features of task-queuing technology and deploying tasks in Remote PCs.

Worked on Automating Web portal, Excel, PDF, API, and Email automation.

Experience in task recording, editing, scheduling, and distribution using UiPath.

Experience in managing BOT workloads using UiPath Orchestrator Work Queue.

Experienced in integrating automation features like web recording and OCR for better capturing of text from images and making it readable.

Maintaining several RPA BOTs as batch processes daily and ensuring quality and high performance.

Involved in POC (Proof of Concept) and Business Requirement Document (BRD).

TECHNICAL SKILLS:

Skills

Proficiency

Robotic Process Automation

UiPath– (Studio, Orchestrator, Robots), UiPath Document understanding, Test Suite

Office Tools

MS Office (Word, Excel, PowerPoint, Outlook)

Operating Systems

Windows7, 10

Programming Languages

C, C#, VB.net, MYSQL, PowerShell

Design and Process

Agile Scrum, RPA Methodology

Version Control

Git, Azure DevOps, TFS

PROFESSIONAL EXPERIENCE:

Client: SBA Communications May 2022– June 2024

Role: RPA Developer (UiPath)

Description: This project was undertaken for SBA Communication, a successful company in the wireless infrastructure sector. The primary goal of the project was to automate multiple areas, including the internal audit software that handles the auditing process, Company server restarts, and Excel data updates. Additionally, the project aimed to automate the management of employee PTO balances, ensuring that the deployed bots would handle data updates and reporting tasks.

Responsibilities:

Implemented End to End Robotic Process Automation (RPA) using UiPath.

utilized Excel automation for repetitive Excel data entry, appending, and column comparing.

Participated in comprehensive project documentation, including business logic, automation process flow, testing, and deployment in production.

Developed workflows as per client requirements and evaluation of processes and feasibility to help in suitable RPA implementation.

Experience in designing the Process Definition Documentation (PDD) using Task Capture.

Created and conducted a walk-through of the Solution Design Document (SDD) with Vizio Diagrams of the Framework.

Involved in phases of the Software Development Life Cycle, including design development and deployment.

Implemented various logics in the Bot using IF, While Do while, and For Each loop, Switch, parallel activities.

Worked on Automating Web portals, CITRIX, APIS, Excel, PDF, TXT, and Email automation.

Utilized Email automation with activities like SMTP and Outlook to send and receive email notifications, as well as handle business or application exceptions.

Developed the RE Framework in UiPath for better exception handling and used it to define project states.

Managed Exceptions using Try-catch activity.

Acquired a Comprehensive understanding of invoice processing workflows including receipt, verification, approval, and payment scheduling.

Involved in code review and fine-tuning the code for performance optimization.

Expertise in ORCHESTRATOR to deploy and manage processes and packages executed by one or multiple Configured BOTs.

Extensively worked on debugging applications for fixing bugs and production support.

Collaborated with test teams during the product testing and UAT phases to resolve assigned bugs.

Configured the Bots and deploying processes and scheduled the jobs in UiPath Orchestrator.

Used Queues to collect information from the orchestrator to perform additional tasks.

Proficient in implementing programming languages such as C# and VB.NET, with extensive hands-on experience in both.

Support business development activities, responding to the proposals as an RPA subject matter expert, by coordinating with key stakeholders in the company.

Environment: UI PATH, EXCEL, OCR, API, PDF, RE Framework, EMAIL Automation, AI, ORCHESTRATOR

Client: Comerica, Michigan JAN 2021– April 2022

Role: RPA Developer (UiPath)

Description: This project was carried out for Comerica, one of the largest financial institutions and I helped automate processes from two different LOBs namely Retail, and Fraud. The primary goal of the project was to help propagate automation by identifying existing huge time time-consuming, repetitive, manual tasks and providing innovative automated solutions. A centralized management platform managed critical automation activities by optimizing and continuously improving processes. This resulted in enhancing quality through error reduction and cost savings.

Responsibilities:

Implemented End to End Robotic Process Automation (RPA) using UiPath.

Experience in designing Process Definition Documentation (PDD).

Create and conduct a walk-through of the Solution Design Document (SDD).

Use agile/rapid-iteration methodologies to deliver work and be involved in agile and scrum meetings.

Involved in phases of Software Development Life Cycle of design and development.

Implemented various logics in the Bot using IF, While Do while, and For Each loop.

Worked on Automating Web portal, Excel, PDF, TXT, and Email automation.

Use EMAIL AUTOMATION with different activities like SMTP, and OUTLOOK to send and receive email notifications, business, or application exceptions.

Developed RE Framework in UiPath for exception handling & used it to define states in the project.

Expertise in ORCHESTRATOR to deploy and manage processes and packages executed by one or multiple Configured BOTs.

Interacting with Windows and web browsers for continuous navigation of applications.

Image-based texts in applications are also automated with mouse clicks.

Used image activities with wait conditions to ensure proper website or application loading, to perform certain actions in a loop.

Extract text from the PDF Documents by using Get Text, Read PDF with OCR activities along with Anchor Base activity for fluctuating values from one or more PDF files.

Design workflows in EXCEL APPLICATION SCOPE to automate all the manual tasks in the business which used MS Excel

Scheduling the BOTs through Orchestrator and managing the robot's workloads.

Supported business and technical teams during robotic projects and mitigated/Resolve risks and issues that may impact project schedule, cost, scope, quality, etc.

Support business development activities, responding to the proposals as an RPA subject matter expert, by coordinating with key stakeholders in the company.

Analyzed the test results and reported defects in Jira.

Environment: UI PATH, EXCEL, OCR, MS Office, PDF, RE Framework, EMAIL Automation, ORCHESTRATOR

Client: Scan Health Plan, CA FEB 2020 – DEC2020

Role: RPA Developer (UiPath)

Description: The primary goal of the project was to Automate the entire accounting software that deals with Enrollment Processing. This software supports Customized Claims Reporting Single Screen Simplicity for Accounting, and Integrated Software for Simplified Claims Processes. Automated this software so that the deployed BOTs will take care of Updating data and reporting works. And automated Claim’s data to be saved.

Responsibilities:

Working knowledge of the credential manager of UiPath, which involves the user credentials securely.

Used Corn Expression in the orchestrator for triggering complex schedules.

Experience in designing the Process Definition Documentation (PDD)

Built some solutions by utilizing the UiPath tool and further maintained technical responsibility for project delivery as the sole technical resource on a project.

Performed the practical usage of various UiPath Orchestrator functionalities like Bots, Processes, Assets, Jobs, Schedulers, Logs, Recovery Methods, and Application Credentials.

Worked on logging onto websites, searching websites, submitting web forms, or updating records on a website.

Expert in implementing features like Web recording, Image recognition, and Task Editor in UiPath.

Extensively worked on automating SAP interfaces.

Scanned Invoices in Image format are converted to text using open OCR.

Inspected PDF Processing, Excel Automation, and various web-based Applications Automation.

Evaluated task migration process from development to production systems through UiPath Orchestrator.

Interacted with different mail services such as SMTP, and Outlook to get the mail messages into the folder.

Handled exceptions using the Try-Catch activity and was good at using loops, for each activity etc.

Created and Scheduled the Bots in Control Tower (UiPath Orchestrator). Expertise in scheduling, triggering tasks with advanced features of task-queuing technology, and deploying tasks in Remote PCs.

Active handle several Issues when occurred in the designed workflows by using DEBUGGING AND EXCEPTION HANDLING Techniques.

Created and documented test procedures and scenarios for pre-UAT phases supporting the operational teams during UAT (User Acceptance Testing) and rollout phases.

Deployed the process in UiPath ORCHESTRATOR and scheduled their execution.

Provide inputs to the business team for the valuation of an idea along with its business case.

Part of the COE Team, where building the POCs for client approval.

Environment: UIPATH, EXCEL, SQL Server, MS Office, EMAIL, UiPath Orchestrator, OCR, RE Framework

Client: Mercedes Benz Financial Services NOV 2018– NOV2019

Role: QA Tester (Automation)

Description

My MBFS App is a Native App, developed for the user to make online payments, Enroll in Auto Pay, View Transaction History, and various other features for the User. There were 3 Apps one is for Canadian users; the other one is for US users and a brand partner with M me (Mercedes Me) which allows the user to start the car and other connect features for the Benz Users along with finance pillar integration.

MMF Global app is the app for different Countries (Thailand, USA, Singapore, Australia, India). It is intended to serve multiple countries with the same features as My MBFS but has the option to choose the Country based on which the payments and date format will change.

Responsibilities:

Story Analysis and building test scenarios based on them.

Prepared Test Plans for Functional Testing.

Creating Test scenarios for Mobile Apps, Database validation, and Rest API’s.

Preparation of test data for execution.

Test Automation using Selenium, Cucumber, and Appium.

Used Android Studio for Android App automation and Simulator for iPhone.

Creating a Folder structure in the X-Ray Test Repository (JIRA) for storing both manual and automated test scripts.

Tested Rest web services Using Postman and SoapUI.

Participated in Integration testing, Swarm testing, and Regression Testing.

Participated in Performance Testing Activities using the Neo Load tool.

Environment: Selenium, Cucumber, TestNG, SoapUI, Postman, Neo Load.

Client: Mercedes Benz Financial Services Sep 2017- OCT 2018

Role: QA Tester

Responsibilities:

Involved in analyzing requirements documents.

Developed test strategy, test plan, test cases, and test scenarios based on requirements Document.

Performed Functional testing manually.

Developed Test Strategy and Test Plan to ensure that test cases reflect user needs for functional Performance, Usability, and Security requirements.

Identified program variance from functional requirements, and recommended modifications for standardization and increased usability.

Prepared manual test cases for service appointment creation, modification, and deletion. Generated test scripts and performed functionality testing.

Involved in performing extensive back-end testing to make sure data is properly reflected on the web Application.

Generated the Test Status Reports from the Test Director and regularly presented them to the QA Team lead and Project team lead.

Performed Web Services Testing and XML validation by creating a test case suite using Soap UI.

Used Quality Center as a defect management tool.

Performed Manual Testing and regression testing activities for new releases as end-to-end testing on Different platforms like Windows with different web browsers.

Responsible for documenting errors, and their resolution, as well as performing extensive Regression Testing.

Maintained defect tracking in an Excel spreadsheet and prepared weekly reporting for the management.

Involved in weekly walk-through and inspection meetings to verify the status of testing and to discuss defect and like scenarios.

Environment:

ALM, Quality Center 9, IBM Rational Functional Checker, Bugzilla, JIRA, Windows, SQL Developer.

Education:

Bachelor’s Degree with First Division from JNTU University, India.

Contact this candidate