Abhishek Jain Email & Phone Number

Gurgaon, India

Job Profile: – Accounts Receivable & CollectionsDesignation: - Manager (Consultant)Software Used: - PeopleSoft, Great Plains, Hyperion, PCS, Remedy, MS Excel, various other weblinks.• Managing 4 team of 15 people situated in India, Manila and U.S.• Verifying all the payments from various Lockbox are posted correctly and timely.• Verifying all the required Debit & Credit memos entered correctly by the team.• Daily, Monthly reconciliation & Control Check, Executing periodical ad-hoc Cash Reconciliation reports.• Updating MIS Report to decide on outstanding items in reconciliation report.• Booking revenue numbers at month end for different business divisions. • Perform analysis on bad debt allowance for each business unit and ensure bad debt is accurately provisioned and sent to third party agency for further collection attempts.• Reviewing & approving month end accounting entries and Balance Sheets before submitting to the Corporate in order to verify all the reconciling items are justified and there are no carry forward items from the previous months.• Providing support for the SOX Audit.• Providing data as and when required by auditors for External Audit.• Monitoring the work allocation among the collectors based at Infosys(Manila),Tampa and Iowa .• Weekly review and quality assurance of work done by collectors.• Monthly reconciliation of payments collected by collectors.• Reviewing and approving various waivers that are to be provided by the customer service and collections to customers.

New Delhi Area, India

Job Profile: – Cash ApplicationsDesignation: - Finance Business AnalystSoftware Used: -LeasePak, Business Object, E-Lease, MS Excel• Clearing of customer invoices with payments with respect to bank statement.• Posting of unidentified items to suspense account• Clearing of suspense accounts and allocation to respective account• Clearing of various GL accounts with respect to bank statements.• Sharing status with clients on weekly & monthly Conference Call.• Cash Tie Reporting on end of day between Bank transactions & Customer Ledger.• Variance identification and variance analysis.• Reporting out the variances and cash analysis to business heads and other stakeholders.• Weekly suspense data analysis and clearing of accounts and reporting out.• Continuous support to standardize the activities throughout different processes.PROJECTS UNDERTAKEN• Automation of daily cash reconciliation in MS Excel through VBA Macros.• Awarded as "Star of the Month” for Automation of daily cash reporting in MS Excel through VBA Macros.• Connected recognition by onshore team for consistent and quality delivery• Designed the outlay of the SOP followed throughout the processes.• Implemented few lean ideas resulted in time saving for the team and cost for Cisco.

Job Profile: - AR & CollectionsDesignation: - Team LeadSoftware Used: - PeopleSoft, Great Plains, Hyperion, PCS, B2K, Remedy, MS ExcelVerifying all the payments from various Lockbox are posted correctly and timely.Verifying all the required Debit & Credit memos entered correctly by the team.Daily, Monthly reconciliation & Control Check, Executing periodical ad-hoc Cash Reconciliation reports, Daily matching of complex/multiple/other outstanding transactions.Investigating transaction owners and issuing enquiries on all un-reconciled transactions within various SLA standards.Updating MIS Report to decide on outstanding items in reconciliation report.Cash Flow Statement Preparation. Booking revenue numbers at month end for different business divisions. Posting GL Entries for Trade AR, Cash, bank, NSF, Revenue clearing, other receivables/income, Taxes, finance charges, setoffs & credits posting, Sales allowance & bad debts expense for different business units. Passing accrual /adjustment entries at year end.Reviewing & approving the Balance Sheets before submitting to the Corporate in order to verify all the reconciling items are justified and there are no carry forward items from the previous months.Providing support for the SOX Audit.Providing data as and when required by DELLOITE for External Audit.Monitoring the work allocation among the collectors based at Infosys(Manila),Tampa and Iowa .Weekly review and quality assurance of work done by collectors.Analysis of Aging reports for different Business Units in order to determine potential the Write Off accounts .Monthly reconciliation of payments collected by collectors.PROJECTS UNDERTAKENSuccessfully transitioned & trained the team for AR process from US in 2009 & Collections process in 2010.Clean up of the reconciling items for year 2007 & 2008 at the time of Transition of AR Process.Support provided for successful migration of IXPlus system to PCS.

Software Used: - Oracle, Frontline Financial, CODA, MS ExcelReconciliation of the monthly Vendor statement & Company Records.Weekly payments for all the agencies & vendors across Asia & Europe.Handling a team of 12 people, the team work involves checking of invoices as per the contract, send by vendors to agent and then agency sends us those invoices in the form of liquidations or directly, enter those invoices into the systems like ORACLE/ERP or Frontline Financial and then in CODA & then propose the payment for agency and vendor on weekly basis.The Company awarded me with the Star Performer Award for the year 2005.PROFESSIONAL SKILLSCOMPUTER SKILLSProficient in using personal computer skills through NIIT in such programs as Microsoft Windows, Microsoft Word, Excel, Access, PowerPoint, Internet, Visual Basic 6.0, SQL Server, Macros.; Create Macros in Excel in order to get more easy and more reliable data.Create and distribute a variety of reports using Word and Excel. INTERPERSONAL SKILLSInteracted with a wide variety of personalities while functioning as a service counter executive. QUANTITATIVE SKILLSCompleted and submitted invoices and process for payments. Handled expense reports with account summaries. Consistently entrusted with large sums of money.

Education record

Diploma, Computer Application And Programming (Gniit)

Diploma, Computer Application And Programming (Gniit)