Summary
Overview
Work History
Education
Skills
Certification
Automation of processes
Timeline
Generic
Ashu Sharma

Ashu Sharma

Gurugram

Summary

An ardent Revenue Assurance Manager with 5 years of experience, seeking data analysis opportunities to leverage financial expertise and analytical skills in driving impactful business decisions

Overview

6
6
years of professional experience
1
1
Certification

Work History

Manager -Revenue Assurance

Sunstone Eduversity
Gurugram
02.2023 - Current
  • Conducting reconciliations with clients to ensure accurate collections and payables, resolving any discrepancies.
  • Issue invoices to clients, track timely collections, and ensure there are no doubtful debts.
  • Conducted daily reconciliations of payment gateway transactions using Python scripts, streamlining manual processes into summarized reports.
  • Fetched and extracted data from MySQL databases based on specific requirements.
  • Initiate and manage the opening of escrow accounts or current accounts with standing instructions, fostering seamless financial transactions
  • Performed bi-monthly updates in Tally for revenue received, payouts, and collections, ensuring accurate and up-to-date financial records.
  • Create monthly revenue analysis dashboards in Power BI to evaluate revenue streams and campus-wise collections, delivering actionable insights for better decision-making.
  • Utilize advanced Excel, Power BI, and SQL to generate detailed reports that inform strategic decision-making
  • Track client agreements and prepare reconciliations, ensuring compliance with contract terms and conditions
  • Perform ad-hoc tasks as required.
  • Coordinate cross-functional teams to discuss discrepancies using SQL queries, and streamline processes.

Credit Control Executive

LocoNav India Pvt ltd
04.2021 - 02.2023
  • Applied proper codes to invoices, files, and receipts to keep records organized and easily searchable
  • Prepared vendor invoices and processed incoming payments on ZOHO
  • Prepare suspense clearance reports on a daily basis
  • Implemented a new budgeting process
  • Prepared various reports such as Outstanding, Debtor, suspense for crucial decision making
  • Disbursed petty cash by recording entries and verifying documentation in ZOHO
  • Keeping track of all payments and invoices etc
  • Taking care of TDS data received QTR Wise and provide invoices against them to adjust the same
  • Coordinate with internal team on daily basis regarding suspense & payments clearance
  • Tracked business revenue and expenditures and reconciled accounts to maintain high accuracy

Finance Executive

TRPC Services Pvt. Ltd
12.2018 - 01.2021
  • Exclusively handling 401K plans & assessing financial analysis of client's contributions toward the plan
  • Processing the Investments Entries in Software -( Trust Me)
  • Preparation and generating reports of Financial Statements
  • Updation of market values of the securities at the end of every year
  • Handling issues/grievances of clients through Portal Regarding any Issue in statements or any transaction
  • Knowledge of working on Platform plans importing for retirement Plan engaged participant in Relius software
  • Settle off Prior year Contribution Receivables for the participant in the next year
  • Settle off Prior Adjustment A/R and activities of Loan issuance for participants
  • Update client's dashboard, handling queries from participants through mail based on payment issues
  • Coordinate regularly with superiors & peers for work status, issues, projections, assumptions and suggestion for process improvement
  • Responsible for Reconciliation of accounts for client's investment activity, detect the error through duplicity of entries

Education

MBA/PGDM -

Narsee Monjee Institute Of Management Studies
Mumbai
12.2021

B.Com -

Delhi University
12.2019

12th - English

Haryana
12.2016

10th - English

Haryana
12.2014

Skills

  • Financial Analysis
  • Trust Accounting
  • Busy
  • Tally ERP
  • Advanced Excel
  • Power BI
  • Zoho CRM
  • HTML
  • CSS
  • Python
  • MySQL
  • Chatgpt
  • Reconciliation
  • Data Analytics
  • Pandas
  • Numpy
  • Matplotlib
  • Jupyter Notebook
  • Visual Studio

Certification

  • Tally ERP 9
  • Advanced Excel
  • Data Analysis with Python, LinkedIn
  • MySQL
  • Advanced web designing

Automation of processes

  • Automated daily reconciliation of payment gateway transactions using Python scripts reduces manual effort and improves data accuracy
  • Developed a Google Sheets integration using Python to automate transactional mapping with statements, incorporating partial lookup functionality for streamlined reconciliation

Timeline

Manager -Revenue Assurance

Sunstone Eduversity
02.2023 - Current

Credit Control Executive

LocoNav India Pvt ltd
04.2021 - 02.2023

Finance Executive

TRPC Services Pvt. Ltd
12.2018 - 01.2021

MBA/PGDM -

Narsee Monjee Institute Of Management Studies

B.Com -

Delhi University

12th - English

10th - English

Similar Profiles

CREATE PROFILE
Ashu Sharma