How it was used
Used AI tools in almost every day to day activities to increase the productivity. Generating images, reports, proposals, excel VBA codes and python codes.
Where applied
Recently, applied python code to read BOM of 419 pdf drawings for new projects. The code generated in 4 hours and executed 419 files in 3 minutes.
Outcome
Completed in 5 hours instead of 5 days work with more than 85% accuracy.
Allowed team to produce more accurate, faster estimation without any manual data entry constrains.
How it was used
Used Excel + VBA functions to manage the timesheet, Google sheets with app scripts to manage RFQ and work order details.
Where applied
Recently, applied this combination techniques to create timesheet template and Master datasheet management.
Outcome
The time for monthly time sheet preparation and printing reduced to 99%.
Prepared one timesheet template with enabled VBA print all employee individual time sheet in a single click.
How it was used
Developed one flow based chatbot to support clients/ internal sales teams to do the follow up with technical team.
Concept
Upon receiving one RFQ from client, The technical team issued one reference number with authorization code. The status shall be updated in the integrated google sheet. The customer can be fetch the data in the google sheet through the wahst app chat.
Outcome
The clients and sales teams aware about the current status 24*7
The same bot can be integrate to website as well.