• Gender: Male
• Age: 34
• Designation: Executive (Analytics & Reconciliation)
• Highest Education Level: Post Graduate Diploma
• Notice Period: 30  Days
• Preferred Location: PUNE
• Work Experience: 11 Year(s)

Education

PGDM (Finance) From Mitcon Institute of Management with 69% in 2014
BBA (Finance) From Jiwaji University with 68% in 2012
HSC from Rani Laxmibai Public School (ISCE) with 77% in 2009
SSC from Rani Laxmibai Public School (ICSE) with 63% in 2007

Skill Sets

IT Skills
• Microsoft Certified Excel Expert.
• MS Outlook, MS Office (Excel, Power point, Word).
• SAP
• Quick Books.
• Power BI.
• Power Query.
• Power Pivot.

Work Experience

Executive (Analytics & Reconciliation)
From May 2017 - Present
Company profile- business software and ERP Software solution provider for professional services,

Job profile-
Review time-sheets received from consultants.
• Customer Invoicing using Quick-Books.
• Prepare AR aging report.
• Follow-up through emails and calls.
• Cash clearing
• Prepare and analyses trade show, travel, SGA reports.
• Prepare and analyses variance analysis reports budget vs actual for department heads.
• Prepare tools utilization reports, bench report, etc.
• Participate in the preparation of company’s back-office budget.
• Prepare commission pay-outs for salespersons of US & India.
• Prepare commission pay-outs for recruiters of US & India.
• Prepare various dashboards for AP, AR and other teams in Power BI.
• Co-ordinate with AP and AR team for reconciliation of accounting data and revenue to prepare reports.
• Perform KPI reporting.
• Prepare process documentation.
• Participate in any special projects and perform ad-hoc tasks and analysis.
• Preparing business presentations and templates for different teams.

Auditor (Accounts Payable)
3.2 years experience
Company profile- leading businesses in the Information Technology Audit Services

Job profile-
• Processing of vendor invoices in SAP.
• Getting approval from the BU head of the project.
• Preparing AP aging report.
• Applying payment to the vendors in SAP.
• Co-ordinate with vendors for receipt, verification and payment of invoices.
• Vendor reconciliation.
• Bank reconciliation.
• Perform payment audit and reconciliation.
• Processing and payment of expense claims.
• Reporting activities related to accounts payable.
• Giving MS-Excel training to the new joiners.
• Helping the team in excel related tasks.
• Preparing process documentation/Workflow preparation.