Solutions

Enrollment individual policy

  • Downloading the policy information.
  • Create policies in the TPA portal along with beneficiaries.
  • Process for all the policies within a strict deadline.
  • Deploy an unattended bot.
  • Download data from insurer portal automatically in scheduled time.
  • Validate and format the data to create/renew it in the TPA portal.
  • Bot starts to create or update the policy where various steps are involved.
  • Much time is saved and it helps the team to achieve the SLA.
  • Reduction of work stress.
  • Can concentrate in core work.
  • 90% of effort automated.
  • AHT reduced by 95%.
  • Significantly improved SLAs.
  • ROI in two months.
  • Increased operational quality.

Departmental Stores

Downloading the Sales and Stock Data monthly from the different portals and consolidate those files and save them in a date wise manner in a shared path.

  • Deploy an unattended bot
  • Bot starts to login to the portals one by one.
  • Checks for the date (if the date is < 6 bot chooses for the 1st date of the month to till date) If the date is >6 bot chooses 15days back date.
  • Downloads all the stocks and sales data one by one
  • Consolidate the files data using macros
  • Saving the files into the shared path
  • Automated Daily
  • Much time is saved for downloading
  • Reduces the work load
  • Consolidation is done easily

Billing of Materials

  • Reduce the Bill of Material (BOM) Validation Time.
    • Using Email automation Base file will be downloaded.
    • The bot will login to SAP and download YPDMB and MB52.
    • Bot shall compare the base file and downloaded files.
    • The bot will consolidate the data and it will be sent to the clients via mail.
    • Team will fill the required fields.
    • Bot has to compare the filled data of team and downloaded file data.
    • Bot has to automatically post the result of BOM in the final output file.
    • Team will place the PLM file manually.
    • Bot has to check the BOM sizes vs SAP size.
    • Bot has to compare the PLM size vs sap size.
    • Much time is saved for downloading.
    • Reduces the work load.
    • Consolidation is done easily.

    CLO Rendering and CLO style creation

    Based on the input sheet they will be creating the some styles , based on the goad seal column applying those to the style codes and storing them in the output folder. These will be stored in the report sheet and sent to the concern team from the email list.

    • The purpose of the process is to design the Product based on the given input file.
    • Using A360 automation is performed in CLO Tool.
    • Bot shall acquire some of the information such as Top Stitch Color, Embroidery Color, Main Label, Size Label, labels details from the input sheet and create a style level CLO3D project file based on the standard input sheet & Gold Seal CLO 3D project file
    • Creating different style codes and storing those files in a output folder.
    • Much time is saved for style creation
    • Reduces the work load.
    • Automated ~3300 style creation per month
    • Automated 4200 style rendering per month

    Quality Management

  • Supplier Reimbursement & Claim list.
    • Mapping of Part ID and Claim ID is a time killing job for n number of goods.
    • Chance of missing the data/error.
    • Automated with processing time reduced to 90%.
    • Zero error % and data loss.
    • Report generation for every product for reimbursement.
    • Transparent in good movement.

    Supply Chain Management

    Parts planning for production, Logistics, Daily report generation, Quality check report, PR/PO creation, Pickup calendar, BOM Comparison, Delivery Tracking Report, Inventory report, Critical part report, Vendor Payment

    • Difficult in planning of parts required for production.
    • Report generation of the production details on daily basis
    • Purchase Request and Order creation, Handling
    • Huge time involved in comparison of BOM
    • Criticality of updating the delivery status in portals
    • Data loss at inventory management
    • Automated the pre planning of the parts required for production
    • Parts shortfall/Excess quantity can be avoided
    • BOM Comparison with multiple products made easy
    • Automated the execution of PR/PO
    • Up-to-date delivery data tracking automation
    • Automated daily report generation

    Account Payable Process (SAP with IQ BOT)

    • 85% of effort automated.
    • AHT reduced by 60%.
    • ROI in 4 months.
    • Significantly improved SLAs and operational quality.
    • Huge time to identify the Business rules from master files Ex. Tax code, GL Code, Plant code.
    • The process had low to medium error rates, delayed SLA's and the volume is very high in the months.
    • BOT will check for the PDF files, then convert and upload to the respective IQ BOT Instance.
    • IQ BOT converts the required data into a structured format.
    • Data BOT generates Excel file.
    • Then AA Bot automatically logs in and post the data in SAP.

    Central Data Maintenance - Customer, Supplier (SCM)

    • 90% of effort automated.
    • AHT reduced by 90%.
    • Purchase Request and Order creation, Handling.
    • ROI in 2 months, 5FTEs redeployed.
    • Significantly improved SLAs and operational quality.
    • Complex calculations involving multiple components to audit like.
    • The process had high error rates, delayed SLA's, especially in high volume months.
    • Major challenge was the team had to do truck calculations based on the load weightage, truck capacity, Number of vehicles for the load. This was very complex and took a few weeks to complete the process manually.
    • Deployed a unattended bot, which will download the relevant data (Excel) from SAP.
    • BOT will check the orders with all the conditions and Bot will process order by order.
    • BOT will send all the relevant data through mails like credit block, No stock orders, Partial stock etc.
    • BOT will generate the pick slips according to the order wise.
    • Bot will automatically calculate the load weightage, truck capacity, based on that bot will select the truck.

    Admin (Airline Project)

    • 90% of effort automated.
    • AHT reduced by 90%.
    • Error rates reduced to 0.
    • Significantly improved SLAs and operational quality.
    • PNR and user data was sent using email and the invoices were manually downloaded from Airline portals using that data.
    • Then convert to unloadable format and split the excel into category wise, accordingly need to merge the PDF files.
    • The existing process had high error rates, delayed SLA's, Daily volume is high.
    • Deployed an unattended bot that reads data from excel and downloads all invoices automatically.
    • BOT extracts the required fields from PDF and updates to input file.
    • It then converts data to unloadable format and splits the excel based on the category.
    • BOT then merges the PDF document and sends the email to users for the further process.