Now you can Instantly Chat with Venu Gopal!
About Me
Hands on practical knowledge of other automation tools like Automation Anywhere and Winautomation. For the last 2.5 years working on various automation components and features available in RPA like Desktop automation, Citrix automation, Web automatio...
Show MoreSkills
Portfolio Projects
Description
Bot should read emails from specific folder in shared mailbox, filter the emails by broker email ids, download the attachments (either pdf or html), extract required fields from the attachment, save them to excel report created in a specific format. CIBOS system will export a report in excel file, which needs to be reconciled with above excel extract created from email attachments. Before reconciliation, bot needs to clean up the data in both the extracts like Date Time formats, Amount values contains commas. In Phase I few brokers emails are considered for reconciliation; other brokers will be considered in next phase.
Show More Show LessDescription
Bot needs to connect to Clients Ariba system, download the list of Orders raised yesterday till current time and pending to be processed. Download the Order files (called cXML – text files) and attachments (if present) for each order, save it to a network drive. Another Bot picks up these downloaded files and uploads into another system called Yantra Hub. Once orders are uploaded into Yantra Hub, within few minutes they will be automatically pushed into DXC Order Management system. In the end it generates the excel report in the end with the list of orders processed, date and time they are processed, Number of Attachments (if it has). This needs to be scheduled as a task so that it runs every two hours with specific user account.
Show More Show LessDescription
When customer Vattenfall raises P1 issues, they send emails to DXC Shared mailbox (in a standard agreed template), from where Bot must read the email contents, login to ServiceNow, create a ticket with all the provided details in the email. In the end, bot logs off from Service Now and closes the browser. This needs to be scheduled so that it runs all the time.
Show More Show LessDescription
As part of our support activities for our client, we carry out Server shutdown / start up activity when DBA team performs monthly shutdown task. Need to stop all the services on all the servers and bring them back online once DBA task is completed. Used Citrix Automation feature available with UI Path to create a front-end robot to accomplish it and reduced time taken to complete the task.
Show More Show LessDescription
CPA global team needs to monitor for any failed Policing cases and take corrective action. They run few SQL scripts on 6 different SQL environments to identify them and resubmit them, if required. They do it every 15 minutes for which they work in 24/7 shift. We used UI Path Citrix Automation feature to automate this monitoring process.
Show More Show LessDescription
Suncorp Bank is Australias leading regional bank and part of the Suncorp Group. Decillion has already implemented the Suncorp Automated Foreign Exchange (SAFE) system for Suncorp. This solution was based on MAPS Version 2 with BizTalk 2006 as the base processing platform. A core component of BizTalk 2006 is the Accelerator for SWIFT, which allows SWIFT message processing functionality. BizTalk 2006 will no longer be supported by Microsoft in 2013, and subsequent updates to the Accelerator for SWIFT will not be provided. This means that the SAFE system will not have up-to-date SWIFT message standards post-2013 and will risk the ability of SAFE to process SWIFT messages. To mitigate this risk, Decillion is upgrading the current SAFE implementation to MAPS Version 3, which runs on BizTalk 2010 and will continue to receive yearly SWIFT message standards upgrades.
Show More Show LessDescription
Singapore government mandates all the banks to improve the existing Payment System. As part of this mandate all major banks in Singapore need to implement new systems to complete the GIRO transactions. Our product integrates G3 system with our clients Core banking and Internet Banking system using Biz Talk Server 2010 as a middleware application.
Show More Show LessDescription
Our client wants to change their procurement system (ABSNS5) from the existing system. This integration should be done with Biz Talk between ABSNS5 and Oracle EBS. Vendor Interface, Exchange Rate Interface, Purchase Orders Interface, Invoice interfaces are part of this integration.
Show More Show LessDescription
As part of early morning checks done by support team to verify the Payment Process system. Bot login to Claims Connect application, searches for a standard claim, navigates through the pages and generates a Payment file (.pdf). If the payment file is generated, then system is working as expected. In the end screenshot will be taken, sent as email attachment (SMTP) to notify about the validation process status to support team.
This needs to be scheduled as a task so that it runs every morning at a specific time with specific user account.
Show More Show Less