04 · Selected Project Portfolio
Recent engineering-led automation work
Selected recent automation projects and engineering initiatives.
India Customs Clearance Automation · RPA / IDP / API Integration
Production-grade automation for customs declaration entry for inbound air shipments across India gateways. Built on Automation Anywhere A360 with Python-driven workload loading and distribution across four parallel bot runners.
A360PythonWLMKofax OCRSQL ServerREST APIFuzzy Matching
- Implemented batch workload distribution and parallel processing across four bot runners.
- Integrated Kofax OCR for invoice extraction and custom SQL logic for fuzzy customer-profile validation.
- Automated government ACCS portal submission through REST APIs and tracked processing in a centralized SQL manifest.
- Added daily reporting and cloud-based log archival for auditability.
Outcome: Improved customs clearance turnaround time and materially reduced manual effort across India operations.
China Dispute P23 · RPA / Salesforce / Revenue Data
End-to-end automation of China customer billing dispute triage and case management, integrating Automation Anywhere with Salesforce FCM, an internal revenue-analysis application and a revenue data API.
Automation AnywhereSalesforce FCMPythonXML ParsingSQLPAM
- Processed Mandarin-language dispute emails and extracted shipment tracking information.
- Retrieved billing data using authenticated web UI automation and Python-driven XML parsing.
- Updated Salesforce cases with enriched data, attachments and queue routing.
- Used a concurrency-safe SQL claiming pattern to support multiple bot instances in parallel.
- Externalized XPath selectors, queue mappings and URLs so operational changes did not require code redeployment.
Outcome: Faster, more consistent dispute processing with reduced agent handling time and a complete SQL audit trail.
Server Utilization Dashboard (SUD) · RPA Observability / Analytics
End-to-end observability platform that ingests Automation Anywhere A360 Control Room activity and converts high-volume execution history into utilization, capacity and team-attribution metrics.
A360 REST APIPythonSQL ServerPower BIStar Schema
- Processes roughly 90,000 activity records per day using paginated ingestion.
- Designed a Kimball-style star schema for utilization and attribution reporting across 200+ servers and 300+ runner accounts.
- Implemented token auto-refresh, multi-day activity splitting and SQL-based incremental loading.
- Created idempotent dimension procedures and a high-water-mark mechanism to recover from partial failures.
- Delivered both an immediate CSV pipeline and a production database-backed incremental loader using the same Power BI semantic model.
Outcome: Established a scalable data foundation for bot utilization, capacity and operational decision-making.
Auto Disk Cleanup Utility · Infrastructure Automation
Automated disk-space management platform designed to prevent RPA bot failures caused by disk exhaustion across 250+ production Windows servers.
PowerShell 5.1PowerShell RemotingXML ConfigHTML ReportingPython
- Automated cleanup of temporary files, browser caches, logs and configured folders through centralized parallel orchestration.
- Implemented per-server XML configuration and safety controls to avoid interference with live automation workloads.
- Produced HTML audit reports and centralized logs, supported by a disk-analysis dashboard and stakeholder reporting utility.
Outcome: Reduced disk-related production incidents by 95% and eliminated more than 80 hours of monthly manual IT effort.
QWIM — Queue Workload Item Manager · RPA Support Engineering
Enterprise support utility connecting directly to Automation Anywhere Control Room APIs to retrieve, filter and safely bulk-delete stalled or failed queue work items.
PythonFlaskRequestsHTML5BootstrapPyWebViewPyInstaller
- Built secure authentication, queue schema discovery and high-volume work-item filtering.
- Added multi-condition filtering and controlled bulk deletion for faster incident resolution.
- Packaged the solution as both an enterprise web deployment and standalone Windows executable.
Outcome: Replaced repetitive manual queue cleanup with faster, auditable support operations.
Monitor Bot · Failure Detection / Incident Automation
Production monitoring solution that continuously scans Control Room executions, normalizes failures, detects duplicates and automatically creates ServiceNow incidents for unique failures.
A360C# CLRSQL ServerRegexSHA-256ServiceNow REST API
- Built a 16-step regex normalization pipeline to reduce variable error messages to canonical forms.
- Used deterministic SHA-256 hashing to suppress duplicate incidents.
- Created incidents through ServiceNow REST APIs, stored full metadata in SQL and sent formatted HTML notifications.
- Replaced fragile single-file checkpointing with a SQL-backed timestamp model for distributed, fault-tolerant execution.
Outcome: Automated incident creation across 30+ configured automations and transformed manual triage into a coordinated incident lifecycle.
Back to cover ↑