Saravanakumar Gurusamy

Senior automation and data analytics professional with 18+ years of experience, including 11+ years in IT automation, 6+ years in UiPath RPA, and 5+ years in Power BI development. Expertise spans Power BI Desktop and Service, DAX, Power Query (M), SQL, data modeling, ETL, UiPath Orchestrator, Excel VBA, VSTO, SAP GUI scripting, and end-to-end process automation. Delivered 200+ automation solutions and 12+ unattended bots across logistics, finance, payroll, supply chain, and reconciliation operations, generating 90 FTE savings, 45% cost savings, 50% faster processing, and 90% error reduction.

Skilled in requirements gathering, solution design, development, testing, UAT, deployment, production support, stakeholder management, and team mentoring.

Senior Data Analyst - VBA & Power BI - Finwiserr (Contract) - Sharjah, UAE / Remote

(2025-12)

• Develop and maintain Excel automation solutions using VBA and VSTO, including add-ins, Ribbon UI components, reusable modules, UserForms, custom functions, and data-validation tools.
• Design and maintain Power BI dashboards and reports using business-focused data models, DAX, Power Query, and interactive visualizations.
• Automate financial and operational reporting, data consolidation, validation, reconciliation, formatting, and report-generation workflows.
• Integrate Excel solutions with databases, REST APIs, and external applications; improve performance, error handling, maintainability, and version compatibility.
• Own requirements gathering, testing, documentation, deployment, troubleshooting, and end-user support.

Expert Automation - VBA, UiPath RPA & Power BI - DHL Global Forwarding Freight - Chennai

(2018-04 - 2025-09)

• Delivered 200+ Excel VBA automation solutions across global logistics, payroll, supply-chain, finance, and reconciliation operations.
• Generated measurable business impact: 90 FTE savings, 45% cost savings, 50% faster processing, 90% error reduction, and 85% accuracy improvement.
• Designed and deployed 12+ unattended UiPath bots using UiPath Studio and Orchestrator, including queue management, exception handling, monitoring, and production support.
• Built Power BI and SQL Server dashboards for FTE savings, vendor reconciliation, and employee joining and relieving analytics.
• Automated SAP GUI, IBM AS/400, ServiceNow, PDF, Excel, Outlook, FTP, and web workflows; connected Excel and Access to SQL Server using ADODB.
• Managed the full SDLC from discovery and specifications through design, development, testing, UAT, deployment, documentation, maintenance, and user support.
• Partnered with stakeholders across APAC, EMEA, the United States, and Australia; led code reviews and mentored junior developers in VBA and Power BI.

Senior Software Engineer (Consultant) - Hewlett Packard Enterprise - Chennai, India

(2015-03 - 2018-03)

• Developed VBA solutions across Excel, PowerPoint, Word, Access, Outlook, and web-scraping workflows for global users and leadership teams.
• Automated IBM logistics applications for Air, Ocean, and S21 processes, producing financial, reconciliation, dashboard, and invoice reports.
• Managed specifications, coding, testing, documentation, deployment, maintenance, technical support, and user training.
• Created customized toolbars, add-ins, Ribbon interfaces, complex charts, maps, league tables, tombstones, and investment-banking deliverables.

Senior Business Analyst - MIS / VBA Automation - Evalueserve.com Pvt. Ltd. - New Delhi, India

(2011-08 - 2015-02)

• Delivered Excel VBA automation across the full project lifecycle, including specifications, coding, testing, documentation, deployment, and maintenance.
• Automated Internet Explorer workflows for newsletters, RSS feeds, web crawlers, and website data extraction.
• Completed an onsite assignment at SABIC in Saudi Arabia (Apr 2013 - Jan 2014), automating petrochemical and Oil & Gas reporting with Excel VBA.

Senior Process Executive - Syven Global Services Pvt. Ltd. - New Delhi, India

(2007-03 - 2011-08)

• Automated complex Excel and PowerPoint deliverables using VBA, including scatter, bubble, bar, line, column, area, and pie charts; financial tables; maps; tombstones; and league tables.
• Migrated, tested, and rebuilt Microsoft Excel, PowerPoint, and Word 2003 macro code for Microsoft Office 2007.

MBA - Systems - Madurai Kamaraj University (2003)