Ayazullah Shaikh

Architected and implemented robust RPA solutions using UiPath Studio and Automation Anywhere. Built custom activities (Python) that streamlined data processing and automated customer onboarding, reducing turnaround time by 25%. Skilled problem-solver with strong collaboration skills to ensure seamless process integration and knowledge transfer.

Custom Activities in UiPath Studio (3 years)

• Efficient Email Body Generation: Developed a custom activity that extracts unique customer IDs from Excel data, applies filters to consolidate entries, and then generates HTML-formatted email bodies with organized information for improved communication clarity. This activity has saved X hours of manual email preparation per week. (UiPath Studio, C#)
• Comprehensive Robot Activity Logging: Created a custom activity that meticulously logs robot activities throughout the entire process, providing a detailed audit trail for monitoring and analysis. This enhanced logging capability supports accurate tracking and troubleshooting of automation tasks. (UiPath Studio, Error Handling)

Enhanced Data Processing:

• Excel to PDF Conversion: Built a custom activity that seamlessly transforms Excel data into well-formatted PDFs, simplifying data presentation and sharing. (UiPath Studio)
• Excel Data to Dictionary Conversion: Developed a custom activity that converts DataTables from Excel into efficient Dictionaries for optimized data manipulation within UiPath workflows. (UiPath Studio, Data Manipulation)

RPA Developer Foundation

1. Auto Renewal Receipting Process

• Client: SUD
• Technologies Used: UiPath, LINQ, API Integration
• Team Size: 2

Responsibilities:

• Configured Outlook to read emails and download attachments.
• Automated downloading and processing of reports from BI Portal.
• Manipulated and verified data from Status and Unreconciled Reports.
• Populated API parameters and executed API runs to update transaction statuses.
• Executed transactions in Life Asia and implemented error handling and notifications.
• Recorded receipt numbers and set realization dates.

Key Achievements:

• Enhanced process accuracy and efficiency, reducing manual effort.
• Improved process reliability with robust error handling.
• Reduced operational costs through automation.

2. Automated File Download

• Client: Internal Process
• Technologies Used: Microsoft Power Automate

Responsibilities:

• Analyzed requirements and assessed the feasibility of automation.
• Designed and implemented a Power Automate flow to manage file downloads from three different URLs.
• Configured triggers and actions for efficient and accurate file downloads.
• Conducted thorough testing and made necessary adjustments.
• Maintained and monitored the flow to ensure continuous functionality.

Key Achievements:

• Streamlined the file download process, significantly saving time.
• Reduced manual effort for the team through automation.

3. Combi Phase 1 - Automated Health Insurance Policy PDF Generation

• Client: ICICI Lombard
• Technologies Used: UiPath, SOAP, XML, i-partner Database, Excel

Responsibilities:

• Automated the retrieval of data from the i-partner Database and an Excel spool file.
• Designed a UiPath workflow to integrate retrieved data into the Path Finder (API) Iterative Flow.
• Created an XML file for use in a SOAP request (Sampark) with specified XML parameters.
• Processed the SOAP request to generate PDF bytecode.
• Stored the resulting bytecode back into the i-partner Database.

Key Achievements:

• Streamlined the generation and storage of Health Insurance Policy PDF bytecode.
• Ensured accurate and efficient data handling and integration.

4. Ehire Process

• Client: Internal
• Technologies Used: Automation Anywhere

Responsibilities:

• Logged into the job board system and navigated to the "Applicants" page.
• Applied filters to select applicants based on date and extracted relevant data.
• Initiated a loop to check and extract data for each applicant, navigating through multiple pages.
• Extracted URLs from each applicant record and gathered detailed data.
• Formatted extracted data and organized it in an Excel file.
• Created folders for extracted records and input files, and saved formatted Excel files and applicant resumes accordingly.
• Ensured proper closure of the browser after data extraction was complete.

Key Achievements:

• Enhanced the efficiency and accuracy of the hiring process by automating data extraction and formatting.
• Significantly reduced manual effort and time spent on applicant data processing.
• Streamlined the recruitment workflow and improved data management reliability.

5. GST ITC Reconciliation

• Client: Internal
• Technologies Used: Power Automate

Responsibilities:

• Automated the processing of an Excel input file containing multiple sheets, received via Outlook.
• Designed a Power Automate flow to map details from the 'Purchase Register' sheet to other sheets such as 'GSTR-2B' and 'GSTR-2B_CDNR.'
• Added a new column 'ID' in the 'Purchase Register' sheet by concatenating 'GSTIN Number' and 'Invoice Number.'
• Mapped common columns (IGST, CGST, and SGST) across all sheets, introducing columns to calculate differences and maintain reconciliation status.
• Ensured the bot accurately checked for matching or mismatched amounts and updated the status accordingly.

Key Achievements:

• Streamlined the GST ITC reconciliation process, reducing manual effort.
• Improved accuracy in data mapping and discrepancy identification.

6. Reminder Mail

• Technologies Used: Power Automate, VB.NET, Custom Code, Outlook, Excel

Responsibilities:

• Automated the process of receiving and downloading an Excel input file from Outlook.
• Extracted relevant information, such as order delivery date and customer email, from the Excel file.
• Populated a mail body template with the extracted details using VB.NET and custom code.
• Configured the process to send reminder emails to customers 7 days before the delivery date.

Key Achievements:

• Improved customer communication by ensuring timely delivery reminders.
• Enhanced customer satisfaction and reduced missed deliveries.

7. DVP

• Client: ICICI Bank
• Technologies Used: UiPath, VB.NET

Responsibilities:

• Utilized VB.NET and UiPath to create a bot that processes a master PDF file from a network path.
• Implemented logic to identify and extract customer data within the master PDF.
• Automated the splitting of the master PDF into individual PDFs, each named after the corresponding Customer ID.
• Ensured the extracted PDFs were saved accurately to the specified drive paths.

Key Achievements:

• Enhanced the efficiency of handling customer data by automating the PDF splitting process.
• Reduced manual effort and minimized errors.
  

8. Vendor Payment

• Client: Internal
• Technologies Used: Automation Anywhere

Responsibilities:

• Designed and implemented a bot to retrieve payment data from an Excel sheet.
• Automated the input of payment details into the Oracle Web Application, handling iterative payment transactions.
• Configured the bot to submit each transaction and maintain payment status.
• Extracted Reference IDs from the Oracle Application after each transaction and updated the Excel sheet accordingly.

Key Achievements:

• Enhanced the efficiency and accuracy of the vendor payment process.
• Reduced manual input errors and ensured timely payment transactions.