Vamsi Punati

RPA developer and controller with 2.8 years of experience delivering automation solutions via Blue Prism and Power Automate Desktop. Expertise in designing and implementing workflows that optimize efficiency and minimize manual tasks. Skilled in API integration and cloud-based solutions, applying agile methodologies to align with business processes.

• https://www.credly.com/badges/11ff6e84-c011-452a-af2b-8f2846440f66

• English
• Hindi
• Telugu

Project 1 : Riyad Bank (KSA)

Platform   : Robotic Process Automation

Software  : Blue Prism

Client   : Riyad Bank

Role   : RPA Developer and controller

Duration  : October 2023 to October 2025.

Description:

Riyad Bank (Arabic: بن ك الرياض) is one of the largest financial institutions in Saudi Arabia, ranked fourth in assets. It has involved in the Automation journey across multiple areas of departments in the Riyad Bank.

Roles & responsibilities

• Designed and developed automated workflows utilizing Blue Prism Process Studio and Object Studio to streamline banking operations.
• Created and maintained reusable Business Objects to interface with core banking applications, web portals, and Excel spreadsheets.
• Implemented robust exception-handling frameworks and Work Queue management to ensure accurate transactional processing and reporting.
• Participated in process analysis, assisting in the translation of Process Definition Documents (PDD) into Solution Design Documents (SDD).
• Conducted unit testing, system integration testing, and actively supported User Acceptance Testing (UAT) prior to deployment.
• Actively monitored the Blue Prism Control Room, tracking bot health and resource utilization to ensure uninterrupted execution.
• Investigated system logs and queue exceptions to diagnose execution errors, creating incidents and performing root-cause analysis.
• Managed environmental security by updating application passwords and Windows credentials within the Blue Prism Credential Manager before expiry.
• Configured, scheduled, and modified process triggers and Environment Variables in alignment with dynamic business requests.
• Assisted in platform infrastructure upgrades, specifically migrating Blue Prism environments from version 7.1 to 7.3.
• Led support activities during business hours, ensuring SLA compliance and resolving pending queue items efficiently.
• Collaborated with the client in daily stand-up calls, sharing technical updates, incident reports, and process improvement initiatives.

Project 2 : Apex Accounting Services (USA) 

Platform  : Intelligent Automation / Robotic Process Automation 

Software  : Power Automate (Cloud & Desktop), AI Builder, Excel 

Client  : Apex Accounting Services 

Role  : Power Automate Developer and Controller 

Duration  : October 2025 to Present

Description:Apex Accounting Services is a premier global financial solutions provider managing high-volume transactional data for enterprise clients. The organization embarked on an intelligent automation journey to streamline their Procure-to-Pay (P2P), Order-to-Cash (O2C), and month-end reconciliation cycles, aiming to eliminate manual data entry errors, accelerate processing speed, and enforce strict financial audit compliance across all business units.

Roles & responsibilities

• Designed and developed end-to-end automated workflows utilizing Power Automate Cloud and Desktop flows to streamline accounts payable and receivable processes.
• Integrated cloud-based ERPs, legacy accounting systems, SharePoint, and Outlook using standard, premium, and custom API connectors.
• Executed automated financial data extraction pipelines utilizing AI Builder (Form Processing) to ingest, classify, and validate vendor invoices and purchase orders.
• Built scheduled cloud flows to handle recurring bank reconciliations, cross-referencing multi-source Excel statements with internal ledger records.
• Created robust exception-handling frameworks within desktop flows to gracefully manage application timeouts, UI changes, and data discrepancies during critical month-end closing activities.
• Actively monitored run histories, flow activity logs, and desktop flow queues via the Power Automate Admin Center to ensure uninterrupted execution.
• Managed machine group allocations, on-premises data gateway configurations, and flow execution scheduling to maintain seamless operational continuity.
• Investigated flow failures, system logs, and data exceptions to diagnose execution errors, creating incidents and performing root-cause analysis.
• Handled environmental security by managing service account credentials, connections, and Azure Key Vault secrets, updating them prior to expiry.
• Configured automated Outlook and Microsoft Teams alert systems to immediately notify accounting stakeholders of data validation anomalies or system exceptions.
• Handled the controller’s team and support activities during business hours, ensuring SLA compliance for critical financial workflows.
• Engaged in daily stand-up calls with the client and business teams, sharing technical updates, incident reports, and process improvement initiatives.