Guru Venkata Vamsi Morampudi

Dynamic RPA Lead with extensive experience at Walgreens, excelling in UiPath and Automation Anywhere. Proven track record of enhancing automation processes, driving efficiency, and delivering impactful solutions. Skilled in C#.NET and adept at collaborating with cross-functional teams to achieve project goals. Committed to continuous improvement and innovation in automation technologies.

• Automation anywhere Master certified in version 11 and A2019.
• Completed a few certifications from UiPath like RPA Developer Beginner Diploma, RPA Developer - UiPath Orchestrator 2016.2, RPA Developer - SAP Automation Training.
• Azure 204 developer certification.

On boarding PR & SOW process, Apple, RPA Lead, Automation Anywhere, Apple E-Approval & Mail, It is developed to Automate current hiring process in the Apple ecosystem. Bot receives Statement of Work (Different vendors submit the SOW for different cost centers) via Apple Email box and which internally routes to Apple desktop application called E-Approval. Once Sow is received it validates the vendor details with Apple vendor list along with the biggest allocated to each resource. This is again checked back with each Cost center and if budget is available then bot is going to create new PR and send back PR confirmation to respective vendors for each quarter. Later the Same PR number is again saved back to DB for extending the PR for other quarters as well. Download Invoices, T-Mobile, RPA Lead, Automation Anywhere, SAP GUI, Chrome, There are two types of T- codes (MIR4 and ME23N) that bot use, and the process begins with an Input excel file that has been dropped to Network share drive path. Outlook monitoring bot, reads the emails and if there is an email from specific process owners with subject line then such email is marked as read and attachment is downloaded to bot shared drive path. After performing mandate validations and cleaning of data, it is then added to Queue. Based on the device pool configurations the queue item is then dispersed to each individual bot runner. Bot Log’s & activates the SAP Screen and navigates with the given transaction codes and if the material code starts with 50 it uses ME24N otherwise it uses MIR4. For each t-code it has to navigate to different screen reach to the place where bot find the list of tables and apply filter on tr/v column, Amount and currency columns. It is then click on the attachment list for the sorted table and click on download Invoice link. This link directly opens the pdf invoice in Chrome browser. Bot finally download the file and place it in the end user shared drive location. At the end all the sap screens are closed and logged out of sap sessions. Email notifications are triggered to respective stakeholders. WFA Address Change, HCA, RPA Lead, UiPath, SAP GUI, Chrome, The main purpose of this bot is to close the tickets assigned to WFA teams whose request contains the subject line either “Change Address” and “Licensure Request”. Dispatcher Process: Bot log in to CMS web portal and set the filter on active cases tab as recent and Subject line as Change address & Licensure request. Once the table is updated the entire dump is then exported to Excel file. Each record in the excel file is read and added to Queue. Performer Process: The process gets deviated based on subject lines. Step 1: If Change Address, it will check 4-digit HRCO code in the subject line. If it is 5903, the bot will close the case. Else, fetch the 8- digit EID from the subject line and search in GHR. Step 2: If Licensure Request, it will fetch the 8-digit EID from the subject line and search in GHR. Step 3: Check if relationship status = Terminated. If yes, close the case. If not, go to step 4. Step 4: Check if the credential section has value ‘Registered Nurse’ or ‘Licensed Practical / Vocational Nurse (LPN/LVN)’. If not, close the case. If yes, go to step 5. Step 5: Go to the Assignment tab. If it has more than 1 Active work assignment, for each active work assignment, go to Active row and fetch HRCO. Check if it matches 5903. If all active row has 5903 HRCO, then close the case. Else, go to step 6. Step 6: Check if any of the assignments has 5903 HRCO. For those who has HRCO as 5903, close the case. For those who don’t have HRCO as 5903, go to Qualification credential, and do the step 4 check again, if all of the cases fail the step 4 check, then close the case. If they pass the step 4 check, then assign the case to the WFA Manual team for review. Step 7: if there is only 1 Active work assignment, then go to step 6. End of Performer. Mass Maintenance PO’s, Walgreens, Sr RPA Developer, Automation Anywhere (v-10/11), SAP GUI, Chrome, It has three different processes like Change quantity, Change Delivery Date and close PO. Process is triggered by placing input files in the Business shared drive. These files will undergo a data validation phase to clean the data with the help of a macro file. On Successful validation, the data will be pushed to a new input excel file and the original file placed in the shared drive will be archived for backup. We are using SAP GUI Desktop Application and T-code ME21N for logging to sap and process each PO’s as per the process. For the process in Change Quantity, we are going to alter the Quantity field in SAP and for Change Delivery date, we just change delivery date which was given in the input excel file. For the Close PO process we will consider all the PO numbers which were given in input excel and close then one by one. To identify the records on which our bot is worked on for a day, it uses two files. Summary sheet which contains the data of successfully processed records for all the 3 processes and Exception sheet which contains the records which have validation /SAP errors. Towards the end emails are triggered to respective stakeholders with the attached Summary and Exceptions sheets for their review. CS OE MX for Government Orders, Becton Dickinson, RPA Developer, Automation Anywhere(v10), SAP GUI, Chrome, Bot process starts with logging to Mexico Government web portal. It navigates to different pages and finally lands on the page where there is a table data. The table contains multiple rows with a hyperlink attached to each row. Bot has to click on each row and save the data to an input excel file which acts an input to SAP GUI. Once bots close or save the hyperlink data, the row will vanish from the table. Using these excel files data, bot creates the PO orders in SAP and will generate a Pdf. These are saved to the user's shared drive folder location and send an email with the Material number in the description. Note: This bot doesn’t have QA / UAT portals, hence it was developed with a production web portal only. Month End Closing Activities, Becton Dickinson, RPA Developer, Automation Anywhere(v10), Hyperion Files, SAP GUI, Chrome, This automation has two parts. Part 1: -Bot enters given T-Code and login To SAP Application. It Loops Each Country code files and downloads the data for each one of them. From each data file, copy and paste the quantity and cost according to the WWB code and company code to the summary file. Once the Summary sheet is updated for all the country files it sends out an email with a summary sheet as an attachment. Part 2: - User will put the 7 types of Hyperion input working files into the robot input folder. Concept-wise, the robot will open each of the files, refresh the sheet with HFM formula, copy and paste the data to the ‘Value’ sheet. BPC Allocation, Becton Dickinson, RPA Developer, Automation Anywhere(v10), MS-Excel Add-in, SAP GUI, Chrome, Bot Login to SAP System and click on FTM BPC End User Role to select Excel EPM Add-In connection. Once Connection is successfully established, the bot opens the control file which is dropped by the user into a shared drive location. Bot Loops each row and opens those excel files that we mentioned in the control file. In each excel file the Menu sheet is default selected and chooses the year and projection values and sets them with the values that were given in the Control File. To Refresh and save the sheets, Bot moves as per the file names like if the filename has “PCT”, Activate “PCT” sheet else if the filename has “FA”, it goes to “Direct LC” sheet. Finally, data will be submitted to the EPM Server and then sap connection can be closed. Tax Automation, Accenture, RPA Developer, Automation Anywhere (v 8&9), Chrome, Excel, Tax Automation is about automating the current manual process of entering the Tax codes for AN Invoices in the Buy Now tool. It deals with the RPA process where a robot will be updating the tax code against the Ariba Network invoice. Currently all AN (Ariba Network) Invoices in Buy Now tool do not have Tax Code populated. Invoice Agent needs to manually populate the tax code, based on items/locations purchased and some tax code table (stored as offline spreadsheet). Robot will help to automate the current manual tax code updating process, which in turn, helps to reduce manual intervention and avoid human errors. Voucher Distribution Services (VDS), Maxcom (Tanzania), Rwanda, Afgun, Zambia, .Net Developer, C#.Net, Soap Web services, SQL Server 20012, VDS is a service-oriented application. It is a simplified solution to purchase prepaid mobile top-ups, post-paid bill payments and recharge vouchers through POS (Point of sale) terminals, deployed at retailers' desks. This application is designed and developed to overcome the problems associated with distribution of physical vouchers like printing, dispatching, stocking, availability and tracking of recharge cards. It consists of services like Airtime vouchers, DSTV recharge, Star times payment, User details, User Current balance, Individual Service Configurations etc. In VDS, it hosts multiple individual services by speaking with various end points and interfaces and managing all these individual services on a multiple scale has turned out to be a tedious task. Also, we had taken up the task of re-uniting all services into a single API plugging in all the interfaces/services on a common code of platform. Also, this had enhanced the re-usability of the code and opened up a pathway for ‘N’ no scalability for all the outgoing and incoming services.

xxxxxxx0426

Passport Number: P0437182