AMOL BHASKAR VAIRAGADE
Pune
Summary
Strategic Financial Operations Specialist with 9+ years of expertise in Accounts Receivable and end-to-end payment processing. A tech-forward professional with a proven track record of bridging the gap between finance and technology to drive organizational efficiency. Expert in managing complex payment lifecycles, customer/dealer refunds, and MIS aging analysis. Highly proficient in developing custom automation solutions and data-driven workflows using Python, SQL (MySQL), Power Automate, and VBA macros. Skilled in transforming raw financial data into actionable insights through Power BI dashboards. Dedicated to maintaining high data integrity and streamlining manual processes within dynamic finance teams.
Overview
10
10
years of professional experience
5
5
Certifications
Work History
Accounting Service Associate
JOHN DEERE FINANCIAL INDIA PVT. LTD.
08.2019 - Current
- Payment Operations: Oversee all incoming payments, ensuring 100% accuracy in daily cash application and posting of lease/installment payments to customer accounts.
- Refunds & Compliance: Manage the end-to-end lifecycle of customer and dealer refunds for excess payments, ensuring timely resolution in strict compliance with company policies.
- Adjustment Management: Process chargebacks, contract terminations, and journal voucher charges, including NSF fees, late fees, and attorney/repossession fees.
- Reporting & Analytics: Develop and maintain MIS reports for AR aging, providing management with critical visibility into overdue balances and collection trends.
- Process Excellence: Spearheaded automation initiatives using Power Automate to reduce manual effort and improve departmental KPI tracking.
- Projects in John Deere
- Project 1: Attorney & Repossession Fee RPA: Built a Power Automate solution to automate fee applications. Streamlined data downloads and template uploads, significantly reducing manual intervention.
- Project 2: Journal Voucher Pre-Work Tool: Developed a VBA Macro tool for JV templates, saving 0.5 hours of manual work per day.
- Project 3: Financial Statement Formatter: Created a VBA tool for Credit Analysts to automate Balance Sheet and Income Statement formatting, reducing processing time by 15 minutes per file.
- Project 4: Statement of Account (SOA) Process: Saved 1,300+ annual labor hours by developing a Power Automate Desktop tool that integrated SecureCRT and web portals to automate Statement of Account processing, validation, and delivery.
Assistant Accountant
Infosys BPM ltd.
08.2016 - 07.2019
- Cash Application: Administered all incoming payments via Direct Debit/ACH, ensuring accurate daily recording and follow-up.
- Month-End Management: Led month-end close activities and reconciled bank statements and suspense accounts on daily and monthly bases.
- Client Relations: Resolved complex inquiries within agreed SLAs and supported internal audits.
- Performance Tracking: Prepared weekly dashboards and audit reports for internal quality teams and leadership.
- Career Progression: Promoted from Junior Accountant (2B) to Assistant Accountant (2A) based on high performance.
- Projects In Infosys
- Project 1: Cash Application Automation: Delivered a tool at Infosys that saved 0.20 FTE in manual processing time.
- Project 2: UAC Reporting Tool: Programmed a VBA-based AR reporting tool that improved efficiency by 0.25 FTE.
Education
MBA - Finance
Sinhgad Institute of Management & Computer Application
Pune, India 04.2001 -
BBA - Finance
S.B. City Binzani College, Nagpur University
Nagpur, India 04.2001 -
Skills
Programming & Database: Python, MySQL
Data Visualization & Reporting: Tableau, Power BI
Automation Tools: Power Automate Desktop, Excel VBA
Certification
Awards: Performance Excellence Reward; Citizen Development Award (Power Automate Process Improvement).
Timeline
Accounting Service Associate
JOHN DEERE FINANCIAL INDIA PVT. LTD.
08.2019 - Current
Assistant Accountant
Infosys BPM ltd.
08.2016 - 07.2019
MBA - Finance
Sinhgad Institute of Management & Computer Application
04.2001 -
BBA - Finance
S.B. City Binzani College, Nagpur University
04.2001 -