Omkar Kajrolkar

Experienced Senior RPA Developer with 3.5 years of expertise, specializing in designing and implementing RPA solutions using UiPath and Process Studio. Skilled in optimizing business processes, increasing efficiency, and decreasing operational costs through automation. Successfully delivered RPA projects for prominent clients including Honda Cars India Ltd, Euronet Worldwide pvt Ltd., and AADHAR Housing Finance Ltd. Adept at client-side project management with 2.5 years of experience. Proven ability to drive successful outcomes through RPA implementations.

1. Honda Cars India Ltd.:-

1.1 Exit ID Deletion:-

Description:- 

• The Employee Exit ID Deletion Process involves automating the deletion of employee IDs from various systems upon their exit using UiPath Robotic Process Automation (RPA). This project aims to streamline the offboarding process, ensuring that former employees no longer have access to company systems, thereby enhancing security and compliance.

Technologies Used: 

• UiPath Studio for workflow development and automation.
• Orchestrator for process scheduling, monitoring, and management.
• Integration with HR management systems and other relevant platforms.

Applications Used: 

• Excel Application, Outlook, Web.

Benefits:

• Efficiency: Significantly reduces the time and effort required for the employee offboarding process.
• Accuracy: Minimizes the risk of human error, ensuring that all IDs are deleted as required.
• Security: Enhances data security by promptly revoking access for exited employees.
• Compliance: Ensures compliance with internal policies and regulatory requirements through detailed audit trails.

Roles & Responsibilities:

• Implemented and developed the process as per requirement

• Implemented different manipulations in excel as per the project requirement.

• Used Re-framework for implementation of the process.

Outcome: 

• Successful implementation of the Employee Exit ID Deletion Process using UiPath RPA will result in a more efficient, accurate, and secure offboarding process, benefiting the organization by safeguarding sensitive information and maintaining compliance standards

2. Euronet Worldwide pvt ltd.:-

2.1  UPI Recon:-

Description:-

• The UPI Reconciliation Web Portal Process involves automating the reconciliation of Unified Payments Interface (UPI) transactions using UiPath Robotic Process Automation (RPA). This project aims to enhance the efficiency and accuracy of transaction reconciliation, ensuring discrepancies are identified and resolved promptly.

Technologies Used: 

• UiPath Studio for workflow development and automation.
• Orchestrator for process scheduling, monitoring, and management.
• Integration with HR management systems and other relevant platforms.

Applications Used: 

• Excel Application, Outlook, Web, SQL.

Benefits:

• Efficiency: Streamlines the reconciliation process, significantly reducing the time and effort required.
• Accuracy: Enhances the accuracy of transaction matching, minimizing the risk of discrepancies going unnoticed.
• Transparency: Provides clear and detailed reconciliation reports, aiding in financial review and audits.
• Compliance: Ensures compliance with financial regulations through accurate and timely reconciliation.

Roles & Responsibilities:
• Implemented and developed the process as per requirement
• Implemented different manipulations in excel as per the project requirement.
• Used Re-framework for implementation of the process.

Outcome: 

• The successful implementation of the UPI Reconciliation Web Portal Automation using UiPath RPA will result in a more efficient, accurate, and transparent reconciliation process. This will benefit the organization by reducing manual workload, improving financial accuracy, and ensuring compliance with regulatory requirements.

2.2 Visa Report (Desktop Application):-

Description:-

• The VISA Report Desktop Process involves automating the generation, compilation, and distribution of VISA reports using UiPath Robotic Process Automation (RPA). This project aims to streamline the reporting process, ensuring timely and accurate production of VISA reports while reducing manual intervention.

Technologies Used: 

• UiPath Studio for workflow development and automation.
• Orchestrator for process scheduling, monitoring, and management.
• Integration with various data sources such as database, Excel, and internal systems..

Applications Used: 

• Excel Application, Outlook, Desktop tool(Edit Package), SQL.

Benefits:

• Efficiency: Significantly reduces the time and effort required for generating and distributing VISA reports.
• Accuracy: Minimizes the risk of human error, ensuring the accuracy and consistency of reports.
• Timeliness: Ensures timely production and distribution of reports, meeting deadlines and regulatory requirements.

Roles & Responsibilities:
• Implemented and developed the process as per requirement
• Implemented different manipulations in excel as per the project requirement.
• Used Re-framework for implementation of the process.

Outcome: 

• Successful implementation of the VISA Report Desktop Automation using UiPath RPA will result in a more efficient, accurate, and timely reporting process. This will benefit the organization by improving operational efficiency, ensuring compliance, and reducing the manual workload on employees.

2.3 Email Report Download:-

Description:-

• The Email Report Download and Data Massaging Process involves automating the retrieval of reports from Outlook emails, performing necessary data massaging, and sending the processed output reports using UiPath Robotic Process Automation (RPA). This project aims to streamline the report handling process, ensuring timely and accurate processing and distribution of reports while reducing manual effort.

Technologies Used: 

• UiPath Studio for workflow development and automation.
• Orchestrator for process scheduling, monitoring, and management.
• Integration with Microsoft Outlook for email operations.
• Data processing tools within UiPath for data massaging and report generation.

Applications Used: 

• Excel Application, Outlook.

Benefits:

• Efficiency: Streamlines the report handling process, significantly reducing the time and effort required
• Accuracy: Enhances the accuracy of data massaging, ensuring the quality and consistency of reports.
• Timeliness: Ensures timely retrieval, processing, and distribution of reports, meeting deadlines and stakeholder expectations.
• Scalability: Allows for easy scaling of the process to handle varying volumes of reports.

Roles & Responsibilities:
• Implemented and developed the process as per requirement
• Implemented different manipulations in excel as per the project requirement.
• Used Re-framework for implementation of the process.

Outcome: 

• The successful implementation of the Email Report Download and Data Massaging Process using UiPath RPA will result in a more efficient, accurate, and timely handling of reports. This will benefit the organization by improving operational efficiency, ensuring high-quality output, and reducing the manual workload on employees.

3. AADHAR Housing Finance Ltd.:-

3.1 Loan Management Partial Reversal:-

Description:-

• The Loan Management Partial Reversal Process involves automating the partial reversal of loan transactions using UiPath Robotic Process Automation (RPA). This project aims to streamline the reversal process, ensuring accuracy and efficiency while reducing manual effort and the risk of errors.

Technologies Used: 

• UiPath Studio for developing automation workflows.
• Orchestrator for process scheduling, monitoring, and management.
• Integration with the loan management system for data extraction and processing.

Applications Used: 

• Excel Application, Outlook, Web, SQL.

Benefits:

• Efficiency: Streamlines the loan partial reversal process, significantly reducing the time and effort required.
• Accuracy: Ensures accurate calculations and updates, minimizing the risk of errors.
• Compliance: Enhances compliance with financial regulations and internal policies through accurate processing and detailed reporting.
• Scalability: Allows for easy scaling of the process to handle varying volumes of loan reversals.

Roles & Responsibilities:
• Requirements Gathering: Collaborate with finance and IT teams to understand the current loan management process and identify automation opportunities.
• Development: Design and develop RPA workflows in UiPath to automate the partial reversal process.
• Used Re-framework for implementation of the process.

Outcome: 

• The successful implementation of the Loan Management Partial Reversal Process using UiPath RPA will result in a more efficient, accurate, and compliant loan management process. This will benefit the organization by improving operational efficiency, ensuring high-quality output, and reducing the manual workload on employees.