Sivaramakrishnan Rajendran

Highly organized and detail-oriented Accounts Payable Analyst with over six years of experience in managing end-to-end accounts payable processes, including invoice processing, GR/IR reconciliation, and employee expense management. Skilled in ensuring timely and accurate payment processing, while maintaining compliance with company policies and industry regulations. Proficient in ERP systems, with a strong ability to identify discrepancies, resolve vendor issues, and contribute to process improvements. Adept at working in fast-paced environments, ensuring the smooth functioning of accounts payable operations. Seasoned Accounts Payable Team Lead with comprehensive background in financial management and team leadership. Have managed invoice processing, vendor relations, and payment transactions to ensure smooth operational flow. Strengths include problem-solving capabilities, strong communication skills, and deep understanding of accounting principles. Previous roles highlight successful implementation of effective strategies for cost reduction and process efficiency.

• Reviewed 100+ vendors that were under debit balance and successfully resolved over 30+ debit balance open items with the vendors worth $817,435.95.
• Identified duplicate vendors and resolved debit balance - 4 vendors.
• Proactively identified incorrect postings and got them corrected that could have resulted in a potential Debit balance - 8 vendors worth $288,669.05.
• Recovered an amount of $103,000 from a single vendor which reduced the debit balance open items, recognized with an Amazon Voucher worth 10k.
• Secured a refund of $145,144.13 from the vendor Wheels INC and transferred the remaining balance to the alternate account.

🚀Leveraging Power Automate AI Builder

Introduction:

In the modern business environment, handling invoices efficiently is critical for maintaining healthy cash flow and ensuring timely payments. Traditionally, processing invoices involves manual data entry, which is not only time-consuming but also prone to errors. To address these challenges, leveraged AI-driven automation tool Microsoft Power Automate's AI Builder. This project outlines the steps required to create an automated solution for extracting invoice information using AI Builder, focusing on enhancing accuracy, efficiency, and scalability.

Objectives:

1. Automate Invoice Data Extraction: Developed a solution that automatically extracts key information from invoices such as invoice number, date, vendor name, and total amount.
2. Reduce Manual Processing: Minimized the need for manual data entry and validation, freeing up employee time for higher-value tasks.
3. Improve Data Accuracy: Utilized AI to enhance the accuracy of extracted data, reducing errors associated with manual processing.

Project Scope

This project will focus on automating the extraction of information from invoices in PDF format that we receive through Generic MailBox. The extracted data will be validated in validation station created using Power Apps and then integrated into a Share Point list for further processing. The solution had leveraged Microsoft Power Automate and AI Builder capabilities, making it scalable and adaptable to various business needs.

• Diploma of Completion UiPath Action Center
• Explore automation development with UiPath Studio
• ABBYY Vantage Fundamentals
• ABBYY Vantage Intermediate
• Power BI: Dashboards for Beginners
• Business intelligence Using Power BI

• In the fast-paced world of data analytics, time is of the essence. I recently undertook a project to optimize the weekly consolidation of Tableau reports, which was previously a manual process taking 30 minutes to complete.
  
  By leveraging Python scripting, I developed an automated solution that:
  ✅ Consolidates the entire report in less than 10 seconds.
  ✅ Ensures accuracy and consistency in the data.
  ✅ Frees up valuable time for deeper analysis and strategic tasks.
  
  The transformation involved designing a script that efficiently:
  1️⃣ Data will be extracted by the user on weekly basis from Tableau Dashboard.
  2️⃣ Processes and integrates the information into a consolidated report.
  3️⃣ Automates repetitive steps to minimize manual effort.
  4️⃣ Email will be sent to respective users once the data is consolidated.
  
  The impact has been incredible, not just in terms of time saved, but also in enhancing the team’s productivity and decision-making capabilities.
  
  This experience reinforced the power of automation and the importance of leveraging technology to solve real-world challenges.

• Managing the AP Helpdesk Escalation Hub daily report was once a time-consuming process, involving manual downloads from ServiceNow, aging calculations, and report distribution. Recognizing the inefficiency, I implemented a fully automated solution using Python.
  
  Key Highlights:
  • Automation of Report Generation: The ServiceNow report is now auto-scheduled daily, eliminating the need for manual downloads.
  • Data Consolidation and Analysis: A Python script consolidates data, calculates aging and aging buckets, and prepares a pivot table for insightful analysis.
  • Seamless Distribution: The script automatically emails the finalized report to the business for review.
  • Task Scheduler Integration: Using Task Scheduler, the automation runs as a .bat file daily, requiring no manual intervention.
  
  Impact:
  This automation has saved approximately 20 minutes daily, enhancing productivity and enabling focus on higher-value tasks.
  
  This project demonstrates the power of automation in optimizing routine processes and delivering consistent, accurate outputs.

• Overview
  
  The project focused on evaluating and enhancing the ABBYY Vantage Intelligent Character Recognition (ICR) tool, with the goal of improving its data extraction accuracy from handwritten or printed documents. Role encompassed User Acceptance Testing (UAT) and functional validation to ensure the tool met business needs for precision and usability.
  
  Objectives and Deliverables
  
  • Objectives: Verify ICR accuracy, assess usability, and identify improvements.
  • Deliverables: Comprehensive UAT reports, functional analysis documentation, and enhancement recommendations.
  
  Responsibilities
  
  • UAT Testing: Executed test cases with diverse document samples, tracked defects, and collaborated with developers for resolution.
  • Functional Analysis: Validated requirements, documented tool capabilities, and highlighted user experience insights for iterative improvements.
  
  Approach
  
  • Testing: Collected varied document samples, measured accuracy, and maintained a feedback loop with stakeholders.
  • Functional Analysis: Reviewed performance across business scenarios and identified usability enhancements.
  
  Success Criteria
  
  • Achieving test case success, meeting functional requirements, and delivering actionable recommendations for the ICR tool.