Automate the Universe Challenge #2

After Hours Notification

Challenge:  After hours notification - Like many corporate operations supporting both east and west coast activities can put a strain on employee scheduling and work life balance.  In our case we were required to keep one east coast employee in the office until 9pm to handle the occasional need to provide order credit approval.  Staffing 6pm-9pm (or 15 hrs / week) for less than 2 hours of actual work.  

Solution:  Create a BOT to monitor the order queue for anything needing credit approval between 6-9 pm.   The first bot run at 6pm would inventory all open orders so that pending credit approvals where not duplicated.  Upon arrival of credit approval - determine order credit owner, lookup contact information for responsible employee and send text message alert and email.  Allow employee to login from home and handle credit situation.  TEAM loves this solution.  Business says it saves close to 300 hrs / month.  Plus we also gained savings by closing the office at 6pm instead of 9pm which reduced security costs and risks as well.  

Automated Report - excel as answer to everything

Challenge statement: A few years ago I was working in a company and we started a transformation journey, that had an impact on our service (it was a nice challenge, because at that time I didn’t think on the big picture and that situation helped me to realize the importance of provide accurate information).

We were requested to provide some metrics about the bots’ execution, even thought we were collecting some numbers (# errors,# rows processed ok, etc.) taking into consideration the business requirements.

The board needed to see the impact of RPA in our company, as we just had 4 bots running in production at that time, we created an excel file and we completed manually the data, and we add some charts to communicate the numbers.

The problem was when we weren’t able to update the information and they needed to access.

So we needed an automated report

Solution statement: the solution provided was to create a bot that complete an excel file with data related to each execution. That excel file was going to be taken as input for a power bi report that the board shown every month. 

The bot was called as subtask on each bot execution(we already had the information to complete that file, so to include the subtask on each bot wasn’t to much work), and as it wasn’t more than 50 lines the development time was too small.

The impact of this small development was huge because it helped us to provide to the board the information they needed to show, and it helped us releasing our RPA team from update the information on that file.

 

Happy to continue improving my skills doing everyone’ jobs less complicated.

Excel as answer to everything 🤣

Challenge Statement:

Managing virtual machines (VMs) and servers efficiently is a significant challenge in IT operations. Identifying idle or underutilized resources manually is time-consuming and prone to errors, leading to unnecessary costs and inefficient resource utilization. This process often requires detailed analysis of usage patterns and performance metrics, which can be complex and labor-intensive.

Solution Statement:

Automation Anywhere, combined with the Gen AI, can automate the process of identifying idle VMs and servers and generating detailed reports. This solution leverages RPA capabilities to continuously monitor resource utilization and generate actionable insights, ensuring optimal use of IT infrastructure.

Idle Resource Identification Automation:

1. Data Collection: Automation Anywhere bots can be programmed to collect performance metrics and usage data from various monitoring tools and systems, such as cloud management platforms, hypervisors, and server monitoring software.

2. Data Analysis: Using the Gen AI, the collected data can be analyzed to identify patterns and anomalies. AI models can be trained to detect idle or underutilized resources based on predefined thresholds and usage patterns.

3. Report Generation: Once idle resources are identified, the bots can compile the findings into comprehensive reports. These reports can include details such as resource ID, utilization metrics, duration of idleness, and recommendations for resource optimization.

4. Notification and Action: Automation Anywhere bots can also be configured to send notifications to IT administrators or trigger automated actions, such as shutting down idle VMs or reallocating resources to optimize usage.

Benefits:

1. Cost Savings: By identifying and managing idle resources, organizations can significantly reduce unnecessary costs associated with running underutilized VMs and servers.
2. Improved Resource Utilization: Automation ensures that IT resources are used optimally, leading to better performance and efficiency.
3. Time Savings: Automating the identification and reporting process saves valuable time for IT teams, allowing them to focus on more strategic tasks.
4. Accurate Reporting: Automation minimizes human errors, ensuring that reports are accurate and reliable.
5. Proactive Management: Continuous monitoring and automated actions enable proactive management of IT resources, preventing resource wastage and improving overall infrastructure efficiency.

Hi All, 
Currently i was working on this where our finance department was fasing some issue
Problem statement:

In the Finance department (AP), processing invoices is a repetitive and time-consuming task that consumes a significant amount of time. The current manual process involves receiving invoices via email, extracting relevant data, entering the data into the accounting system, and verifying the information for accuracy. This manual handling leads to several challenges:

High risk of human error in data entry

Difficulty in maintaining compliance with regulatory requirements

Solution Statement:

I propose implementing using Automation Anywhere to streamline the entire invoice processing workflow. The proposed solution includes the following steps: Automated Email Handling: Use bots to monitor the Accounts Payable email inbox and automatically download incoming invoices. Data Extraction: Employ optical character recognition (OCR) technology to extract key data (such as invoice number, date, vendor details, and amounts) from the invoices. Data Validation: Create a bot to validate the extracted data against purchase orders and other relevant documents to ensure accuracy and compliance. Data Entry: Automatically input the validated data into the accounting system. Error Handling and Notifications: Develop a bot to handle errors by flagging discrepancies and notifying relevant personnel for review. Reporting and Compliance: Generate automated reports to ensure compliance with regulatory requirements and provide insights into the invoice processing workflow.

Challenge Statement:

While maintaining and supporting up and running bots there are chances that any enhancements came , code changes take place thus as a result each and every time respected supporting employee needs to deploy the changes into the production and its a repetitive and time consuming task.

Solution Statement:

As a solution of this challenge, with the help of automation we can create a deployment bot and with the help of this bot only by giving some details as a input data into the excel and thus by keeping that file at the particular location this deployment bot can be triggered and thus with the help of this amazing automation bot this repetitive task can be automated.

Thanks 
Nidhi

Challenge Statement:

In our corporate environment, the on boarding process for new employees is time-consuming and prone to errors. It involves multiple manual tasks such as data entry, document processing, and system updates, leading to delays and inefficiencies in getting new hires up and running smoothly.

Solution Statement:

Automation Anywhere offers a comprehensive solution to streamline and improve the on boarding process for new employees. By leveraging RPA (Robotic Process Automation) technology, we can automate repetitive tasks such as data entry, document verification, account setup, and system updates. Bots can be programmed to extract information from various sources, populate forms accurately, and trigger notifications for necessary approvals. This reduces the time spent on manual tasks and minimizes the risk of errors, ensuring a faster and more reliable on boarding experience.

Additionally, Automation Anywhere's intelligent automation capabilities enable us to create workflows that adapt to changing requirements and comply with regulatory standards seamlessly. By automating compliance checks and documentation processes, we can ensure that new hires are on boarded in accordance with company policies and industry regulations.

Overall, implementing Automation Anywhere in our on boarding process not only increases efficiency and accuracy but also enhances the employee experience by providing a smoother transition into the organization.

Challenge Statement:

I faced a complex scenario where 25 distinct processes needed to run in parallel. The use of a workload manager (WLM) was not feasible because each process required a unique input. The challenge was to efficiently utilize client VMs and ensure that the outputs of all processes were delivered simultaneously. To tackle this, I designed a comprehensive orchestration system for these 25 processes. Discover the solution and see how I addressed this problem.

Solution Statement:

Thanks to Automation Anywhere APIs, I designed an orchestration bot that leverages Automation anywhere APIs to address this challenge. I created a mapping file defining the allocation of VMs for each process. For example, Process A is assigned max 2 VMs, and Process B is assigned max 3 VMs etc and also defined the priority. If there are idle machines available, the orchestration bot dynamically deploys processes to these VMs. Even when all dedicated VMs are occupied, the bot batches input data and queues processes based on priority. It was exciting to work with the APIs and develop an innovative solution that optimizes resource utilization. This is how I successfully tackled the problem.

Challenge Statement:

In RPA, when an automation bot encounters an error, it triggers an email to the support team according to the error handling condition. However, to address the bot issue, a support team member must first review these emails, then navigate to the project management tool to create a support ticket, and finally begin addressing the issue. This process can be time-consuming for support personnel.

To streamline this process, the solution is as follows:

Solution Statement:

To address the challenge mentioned, I developed a Support Ticket creation bot. This bot is designed to be called in the catch block to handle any errors that occur. When triggered, the bot uses the tool's API to create a ticket in the project management tool. The ticket includes all necessary details such as the error message, error line, bot name, and machine name on which the bot was running. This streamlined approach allows the support person to quickly access the ticket and begin addressing the bot issue.

Challenge Statement:
Any IT department faces the challenge of managing guest user accounts effectively. When guest users do not accept invitations or remain inactive, these accounts can pose security risks and lead to unnecessary administrative overhead. Manually tracking and managing these accounts is time-consuming and prone to errors. There is a need for an automated solution to clean up guest user accounts, ensuring timely reminders and disabling inactive accounts.

Solution Statement:
To automate the cleanup of guest user accounts. This solution will monitor guest user activities, send reminders, and disable accounts based on predefined criteria, ensuring efficient and secure management of guest user accounts.

Benefits:
Improved Security, Enhanced Efficiency, Consistency, Time-saving, Proactive Management.

By implementing this solution, the IT department can ensure efficient and secure management of guest user accounts, reducing administrative overhead and mitigating security risks associated with inactive accounts.

Problem Statement: In the context of human resources and talent acquisition, sourcing candidates for job openings is a critical but time-consuming task. 

Solution statement: Automates the candidate sourcing process to identify and engage potential candidates efficiently. The system should be capable of:

Job Requirement Analysis: Develop algorithms to analyze job requirements and extract key criteria such as skills, experience, qualifications, and location. The RPA solution should understand the specific needs of each job opening to target relevant candidates effectively.

Data Extraction and Aggregation: Implement bots to crawl various sources of candidate data, including job boards, social media platforms, professional networks, and resume databases. The RPA solution should extract candidate profiles, resumes, and contact information from these sources and aggregate them into a centralized database.

Candidate Screening: Develop screening criteria based on job requirements and use them to filter and prioritize candidate profiles. The RPA solution should assess candidate qualifications, skills, and experience against predefined criteria to identify potential matches.

Outreach and Engagement: Implement automated communication channels, such as email, messaging, or chatbots, to reach out to potential candidates and initiate engagement. The RPA solution should send personalized messages or notifications to candidates to inform them about job opportunities and encourage them to apply.

Application Tracking: Develop mechanisms to track candidate responses and applications throughout the recruitment process. The RPA solution should log interactions, record application status updates, and schedule follow-up actions to ensure timely and effective communication with candidates.

Candidate Relationship Management: Design a system for managing relationships with candidates and nurturing talent pipelines for future opportunities. The RPA solution should maintain candidate profiles, track communication history, and categorize candidates based on their qualifications and interests.

Compliance and Data Privacy: Ensure compliance with data protection regulations and privacy policies when collecting and processing candidate information. The RPA solution should adhere to legal requirements regarding consent, data security, and confidentiality to protect candidate privacy.

Performance Monitoring and Optimization: Implement monitoring tools to track the performance of the RPA solution in terms of candidate sourcing efficiency, response rates, and quality of hires. Analyze data insights to identify areas for optimization and continuously improve the sourcing process.

By addressing these objectives, the RPA solution will streamline the candidate sourcing process, reduce manual effort, and accelerate the recruitment cycle, leading to improved talent acquisition outcomes and organizational efficiency.