What is Droid?
Droid is automation of repeat tasks. Handled by AI – ML driven automation for routine organizational processes to meet current and ongoing business needs.
Why not introduce latest technology in current practices?
Can bring Droid into work culture and reap rewards of superior experience in day-to-day practices.
Accurate, Consistent & Fast
Active round the clock
Quick & Easy to Deploy
Control Center can configure BOT for enhanced/varied output
Our Digital Transformation Tools to
solve your problems
Covid-19 data submission to ICMR
Submission of Covid–19 data daily to ICMR portal (Indian govt. agency) was mandated for the organization and the same data was filled in the local in-house business system as well. This was duplication of efforts to take the same data and then submit to the ICMR portal.
Automation with Droid tool
Implementing and Configuring the Droid tool helped to automate submission of Covid–19 data to ICMR portal by directly fetching from client business application.
- Avoid manual intervention for data submission to the ICMR government portal
- Avoid duplicate efforts in this data submission
- Save manpower by allocating different productive activity/work
Auto fetch Financial data
To get sales and invoice information from 3PL system, it was time consuming and costly to integrate with the SAP system.
Automation with Droid tool
Implementing the Droid tool helped to pull data of invoices and cash collection from 3PL system automatically.
- Integration and data availability in real time
- Reduced time for interface implementation with 3PL system
- Cost effective
When there are 2 different systems for sales with different vendor, chargeback and rebate would be separate for direct and indirect customers. Country managers and users wanted a single dashboard for sales and pricing analytics from both the systems. To pull information from different vendors, with the kind of enormity of business operations, manual process was cumbersome, error prone.
Implementing the Droid tool helped to pull data automatically from 3PL system for analysis and then used for strategy, planning, amongst others.
- Reduce time for interface implementation with 3PL
- Cost effective
- Country Head and decision-making team got a single dashboard to view all round details from various source which helped them for combination of data analysis and research and strategy execution
Data Integration with EDW (electronic data warehouse)
The enormous amount of data, the data of 40 countries and all stored in the IMS (Information management system).
Business users found it very difficult to pull data from this IMS and use for analysis. It was time-consuming task when pulling data for each country would take hours to generate file from the IMS.
After allotting a data warehouse, and once configured, the implemented Droid tool helped to automatically connect with the IMS and pull data and load into EDW. And it was very simple and quick to generate data for analysis.
- Time saving of business users
- Different country data despite spread across, available on a single platform
- Thus, easy availability of data
- Business can slice and dice the data to generate analytical dashboard by comparison with competitor data
Pricing submission to Government Portal
As per government norms, business must submit the product prices on biweekly, monthly, and yearly basis. Government portal only allows single product price submission at a time which made the entire process for business users spend enormous time.
Droid tool was so designed that helped business to automatically submit all prices by providing data in one excel file.
- Reduce manual efforts
- Avoid manual, repetitive tasks and reduce errors
- Save business time and use for productive work
Each day, organization would navigate to Tender portal/s and set filters to fish out any new tender launch for products they sell. Or else, they must depend on vendors to send them notification about new tenders of their choice.
Droid tool so designed helped business to automatically send alerts for any new tenders of their choice.
- Business got automatic tender alerts on daily basis based on the criteria set for their choice of products or other configuration
- Vendor dependency to send emails for new tenders reduced
EMA & MHRA XML download
In Pharmacovigilance (PV) operations, there is manual process for downloading the E2B R3 & R2 XMLs from regulatory agencies which is time and resource consuming.
To avoid use of large amount of time and resources, configuring the Droid tool fully automated this manual operations.
- Business got fully automated feature of E2B R2, R3 XML download
- 100% fully automated setup with no manual intervention
- Auto logins, auto download & auto unzipping of E2B R2, R3 XMLs successfully executed using this Droid tool
Business use a CRM system which has no interface to pull information from it, which made it difficult to use collectively with other data available in the EDW (electronic data warehouse) for analysis. Also, the said CRM only provided data in CSV file through FTP.
Instead of using a FTP tool and download the CSV files and use for analysis, the Droid tool was configured such that it helped to transfer the CRM data from their FTP directly into EDW server.
- Avoided any interface constraints
- Easily migration of data in EDW for analysis
Extraction of Account details
Just with the account number on hand, to get other details, such as the address normally would involve traversing onto the portal and extract each detail manually. For such repeated, non-productive tasks, it was more and more tedious, frustrating and error prone for the organization.
Introducing this Droid tool helped to automatically pull data from said portal with no manual intervention.
- Avoided manual tasks and errors
- Saved enormous business time
CSV (OQ-PQ Execution)
Implementing GxP compliant solutions is not just the release of the software code, but it also involves CSV (computer system validation) documentation and its successful execution, compiling the documents with evidence and then the release is complete. To generate OQ/PQ documents, it would consume considerable amount of time of QA/Project/Other users/teams. Also, it is repetitive task for every client setup.
The BOT helped automate routine, repeated CSV tasks and operations; OQ & PQ execution with documented evidence & achieve operational efficiency across CSV cell.
- Save time; for bigger project, the amount of time saved can be up to months
- Avoided working on repetitive tasks
- Increased Operational efficiency across CSV/Project departments
Reconciliation of 2 system
Sales and Finance systems are tightly bound together and if any sales information is not pushed to either system, it would have mismatch of data. And users would not have information (ones that is not pushed for use or even real time).
The configured Droid tool helped to provide one consolidated file to analyze mismatch between the two systems.
- Avoid manual activity of checking mismatch data between the two systems
- Users can concentrate to solve the problem rather finding mismatched data between the two systems
HQ Growth Bot
To automatically send and receive data from SAP, this Droid tool was developed and deployed.
This Droid tool extracted data from Sarjen’s HQGrowth portal and send it directly to SAP. And vice versa. That is, it also extracts information from SAP and load it into HQGrowth portal automatically or configured frequency.
- Automation of data push and pull – retrieve and load into either system without any other SAP tools such as SAP PI/PO, BODS, etc.
- Saves on costs with respect to SAP tools
Client business in US was growing rapidly and there was a need to deploy a scalable solution for Sales reporting. This meant integration of data points across 3 key systems SAP & Legacy CRM and legacy contracts management systems. In the legacy process it took almost a full week to gather data from different sources, clean, analyze and finally present an integrated view for management consumption.
We deployed a Robotic Process Automation (RPA) powered interface to build interface to pull data from different systems into data warehouse with xero human intervention. This data feed further connected to our analytics solution over Power BI platform to present real time sales information to management, hereby elimination both the lead time to information and eliminating errors in preparation of reports.
The RPA solution potentially help save enormous costs to build a native API on legacy contracts management system and also annually saving vast expenses by eliminating the effort spent on producing the analytics report.
The Droid Automation tool which was built for us by Sarjen has proven to be a significant support for my team. In the past, we had to collect account information from a secure portal manually, it would take people hour and hours to collect the data they needed.
Sarjen offered up a solution which has enabled us to seamlessly upload a list of account number, and then in very quick time, the droid system returns all the account details via automated method.
I think this is a strong case for where Sarjen has done over and above to support the Accord teams. We use the tool often and it has been really useful.
I would like to express my sincere congratulations for this initiative as well as for its results.
I’m very happy with the amount of time saved just because I receive the alerts instead of manually searching for tender announcements. It is a real help in my daily activity as is it targeted to the relevant tenders for our industry.
I hope this tool can be extend for other markets as well as it is a real benefit in terms of time efficiency, especially for the countries with limited human resources such as we are.
Thank you once again for your support and wishing you all the best!
We are really glad to work with you on developing data extraction tool with droid system. Sarjen has created the tool which has helped us lot in delivering our monthly important reports on time. Extraction of these reports were taking lots of time in our system and many times we were not able to extract data from vendor tool even after multiple attempts. You have solved our this issue and saved our time by 4 working days.
In addition, I would like to appreciate your dedicated and prompt support!!