- work as RPA Consultant to automate & deliver Automation Projects with High Quality implementations.
- Subject Matters Expert on Automation/RPA/RDA (Assist and give Tips, Advises & Best Practices on Automation, Assist on Trouble-shooting for development/implementation of RPA)
- As Technical Support: Liaise with US Head Office to request any need for the Singapore office (
- Automation / Robot Process Automation Projects:
- Deployed @One of Japan [email protected]
- [Telco Billing Automation] Robot Automation to generate the Telco Bills Summary Report.
- [Excel - Robot #1] The input are Different Telco Bills (Singtel Mobile + Fixed Lines, Starhub Mobile). One Robot will handle all these templates. Users will maintain Contacts Master Files (Mobile and Fixed Lines contacts), Email Distribution master file.
- [RPA, RDA, VBA] Automation Flow will do GST adjustment (caused by rounding decimal from 4 to 2 decimals), Excel Formula to get Different Amount caused by Decimal Rounding and put it on one of the Department. These are templates consumed by the Robot: Email template, VBA Macro Generator.
- [Excel] The Output #1 are Pivot Summary and Details Report, Users are able to overwrite the Different Amount
- [Excel] The Output #1 will review and verified by Users and the Finalized version will become outputs for other Robots
- [RPA, RDA, VBA - Robot #2] The Finalized Output #1 will be used for Email Sending based on the Departments Cost Center. RDA will call VBA Macro and generate the Report Template per Department and split it into multiple files. RPA finally will distribute and send email with Status Report.
- [RPA, RDA, VBA - Robot #3]The Finalized Output #1 will be used for Integration with Expense Ledger System. RPA+RDA will call VBA Macro to generate CSV Format. RDA finally will upload the CSV to Expense Ledger System. RPA+RDA will capture the result of upload and save its prompt message (either success, duplicate or missing CSV file)
- Exceptions handling are Skip the process for Opened Files, Input Files that not follow the Format.
- [HR Expense- in progress]Robot Automation to generate HR Expenses report.
- Extract multiple source input reports and transform it into Data that required by Planning Department.
- Generate Report per Department and distribute by email
Key Technologies: Excel Formula, Form & VBA; Robot Process Automation (RPA) + Robot Device Automation (RDA) with Kofax Kapow; MS SQL Server.