Parthiban Kumar

Project - 01

Client : USAA

Location : United States of America

Environment : Automation Anywhere A360, Advanced Excel, MySQL, Amazon Redshift, Basic Python,Service Now

Domain: Enterprise Data Management.

Description :

I am working as an RPA Developer on this project, and I have developed over 10 task bots to automate the manual activities performed across multiple processes. I gained a deep understanding of each process, identified automation opportunities, and built end-to-end automated workflows. One of the key achievements in this project was transforming a 4–5 hour manual task into a 20-minute, fully automated process, resulting in over 90% time savings.

Responsibilities :

• Developed automation bots in Automation Anywhere using advanced macros, VB scripting, and SQL queries.
• Automated the process by integrating data from database tables and input files received from ServiceNow.
• Developed automation solutions using UiPath for various business processes.
• Analysed workflows to identify automation opportunities and improve efficiency.
• Conducted testing and debugging of automated processes to ensure functionality in DEV, Test, and Prod environments.
• Developed both attended and unattended bots based on client requirements and the specific needs of each process flow.
• Conducted thorough analysis and performance tuning of Complex A360 automations, including SQL query optimization, data transformation process to improve efficiency and reduce latency
• Provided training and support to end-users on RPA tools and best practices.
• Maintained documentation for automated processes and system configurations.
• Optimized bot execution time to ensure all processes completed within the specified time limits.
• Implemented best practices related to security, scalability, reliability when working on robotics projects.
• Identified opportunities for further automation by analysing current processes or workflows.
• Designed, tested, and deployed robotic process automation applications.

Project - 01

Client : ASN Impact Investors

Location : Netherland

Environment : Automation Anywhere A360, Ui Path, Advanced Excel, Amazon Redshift, Tableau Desktop

Domain : Sustainable Finance Disclosure Regulation (SFDR)

Description :

Worked extensively and developed 15+ bots and 10+ reports with sustainable financial data automation, ensuring the highest levels of data accuracy, security, and integrity.

Responsibilities :

• Designed, developed, tested, and implemented automation workflows across financial systems using RPA tools and custom scripts.
• Automated end-to-end data collection, data quality checks, and data validation using RPA bots, reducing manual intervention.
• Implemented strong data accuracy controls, exception management, and automated reconciliation to ensure integrity across systems.
• Automated database processes (SCD Type 2, multi-layer GAL/SPAL workflows), and supported Data Engineering teams in pipeline optimization.
• External Team will collect data from multiple service providers, like BNPP, MSCI, and Triple Jump, and load those data in the Redshift S3 bucket.
• Automated sustainable financial data pipelines ensuring high accuracy, security, and integrity.

Project – 01

Client : HUMANA Inc

Environment : Tableau, SQL

Domain : INSURANCE

Responsibilities:

• Created dashboard designing with effective data visualization of large data volume from data sources.
• Developed Tableau data visualization worksheets with different styles like bar, pie, tree map, dual axis, donut chart and Geographic Map.
• Combined multiple dashboards into single story to enhance visual appeal of the report.
• Created action filters, parameters and sets for preparing dashboards and worksheets.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Creating views for YTD, QTD, MTD, YOY, QOQ, MOM views for corporate actions.