Sales Customer

HARISHANKAR GUPTA

** ****** ******-*** ***, Brampton, ON

Cell 639-***-**** • E Mail: *****************@*****.*** Summary

Results-focused and customer-centric Accounts Receivable Specialist with 7 years of international experience in entire Order to Cash Process with proven capability in monthly cash forecast and maintaining cash applications, processing credit memos, revenue analysis, B2B collections, credit management, reconciliation and financial reporting. Managing customer deductions and analyze complex aged receivables and payment discrepancies. Enjoy working closely with cross- functional teams to find solution and resolve disputes. Excellent in Excel and word. Excellent organizational, multi-tasking and time management skills with stay calm under pressure abilities in fast paced and high-volume environment Key Skills and Competencies

Accounting Skills

Accounts receivable Cash Application Credit Management B2B Collection Financial Reporting Billing Management

Variance Analysis Data and Journal Entry Accounts/GL/Bank Reconciliation Monthly cash forecast Projection Process Improvements SAP ERP/Microsoft Dynamics AX Strong Mathematical Skills Full cycle of Accounts Payable Organizational & Team-Oriented Skills

High degree of dedication, ownership, and initiative Strong negotiation and conflict resolution skills Strong reconciliation and analytical skills Ability to work independently and perform in a team environment Strong oral and written communication skills Excellent Microsoft Office Skills- Excel (VLOOKUP, Pivot, Complex formulas, Macro), Word and Outlook Highly motivated and professionally aggressive individual Achievements

Provided process improvement by SAP ERP based credit note automation which saved 120 hours annually

Implemented process improvement of auto posting and clearing in SAP ERP which saved 420 hours annually

Made Excel based ageing to show the actual position of customers in absence of inputs into SAP ERP reports Professional Experience

Accounts Receivable Clerk-B2B Collection 01/2020 – Present Maple Lodge Farms Ltd, Brampton – Canada

Manage assigned portfolio of accounts including reconciliations, cash application with validation, deductions management, issuing credit memos, execute collection strategies to improve period-end/monthly cash flow, admin tasks

Contacts customers to secure payment information and provide appropriate proofs of delivery and documentation as required until full debt is closed and prepare and monitor monthly cash forecast.

Manages payments of outstanding and late accounts based on aging, formulates collection strategies to mitigate customer objections to making timely A/R payments; collections up to 3.5 million CAD per week.

Investigates and resolves billing discrepancies or improper billing through research, documents and processes applicable corrections for review by management; discrepancies reduced by 50%.

Process customer payments (EDI, Wire, Cash, Cheques, credit card) with 99% accuracy and 100% within deadline.

Experiencing online vendor portals for raising query and dispute to resolve customer claims and other discrepancies

Ensures strict confidentiality and privacy of financial transactions as they relate to the organization and its customers.

Senior Accounts Receivable Analyst- B2B Collection 01/2019 – 07/2019 Gujarat Borosil Ltd (Manufacturing Co.) - (This Company is very similar to Canadian Solar) – India Responsible for cash and credit management, contracts and intercompany billing, collection, process improvements, AR audit, resolve invoice and sales order discrepancies, inventory management, and preparing bank deposits & credit memos

Issue monitored and managed “shipment hold/notification” screen within authorized credit limits.

Prepared Sarbanes-Oxley (SOX) reports and various financial reports on monthly basis to ensure credit & collection policies and procedures outlined are being strictly followed.

Maintained A/R records with 98.5% accuracy in cash application (cash, credit card, cheque, EFT) with bank deposit validation, customers’ accounts/GL reconciliation, created and issued credit/debit notes as per discrepancy.

Overdue Collection (aged receivables) reduced from $272K to $27K CAD by communicating timely in professional manner by phone, letter and email on detailed aging and past due accounts and resulted 30% increased cash flow.

Revamped A/R procedures by designing SAP reports and spreadsheets to identified and rectified issues related to short payment, over payment, unapplied credit, misapplication to maintained timely customers’ accounts. Accounts Receivable Analyst- B2B Collection 07/2017 – 01/2019 Chiripal Poly Films Ltd (Manufacturing Co.) (This Company is very similar to Uflex films Ltd., US) – India Responsible for credit management, cash application, collection, reconciliation, payments issues/disputes, cashflow, Key Account Management (KAMs) to gain support and build strong partnerships with customers, bank deposit, credit memos

Handled portfolio of 600+ accounts from billing through to payment with 97% accuracy in cash application.

Reduced DSO (average days’ sales outstanding) from 96 to <30, significantly improved almost 25% cash flow with strong credit collection follow ups on past due invoices(aging) “hit list” and coordination with sales department.

Maintained and established credit limits in SAP for new and existing accounts and performed financial statement analysis for all accounts over $100k.

Reduced 30% client payments disputes by timely accounts reconciliation and regular communication. Business Process Lead (Accounts Receivable) 12/2013 – 06/2017 Tata Consultancy Services – India

Responsible for cash application and credit management, MIS, audit, accounts payable, customer relationship, recon.

Performed cash application on correct customer accounts of Hitachi project with 99% accuracy for different Europe countries through SAP and Alloc8 software also completed and reviewed standard operating procedures (SOPs).

Established and monitored new/existing credit limit for customers by performing financial statement analysis and by analyzing Dunn & Bradstreet(D&B) reports recommendation.

Extra Tasks-Performed accounts payable function, managed vendors accounts, reviewed all invoices and approval prior vendor bill payment, booked expenses, made payments, compliance resolved of SOX audit. Education Qualification

Educational Credential Assessment approved by WES, Canada

Certified Financial Modeling & Valuation Analyst (FMVA) from Corporate Finance Institute (CPI), Canada

MBA (master’s in business administration) in Finance, Indore, India

Bachelor’s in commerce (Accounting)- Bachelor’s degree, Gwalior, India Training & Certificate with Volunteer Work

Completed customer service training and got certificate in RODS, REGINA, SK, Canada

Attended Training: Kaizen workshop, Green belt (lean process-six sigma)

Arranged fund, food, clothes to Old Age Homes by calling and meeting with persons and companies Reference

Available upon request

Contact this candidate