Accounts & MIS Executive
Bhatia Brothers FZE
Total years of experience :20 years, 0 Months
Responsibilities:-
•NetSuite implementation of the database.
•After implementation preparing reconciliation report base on old database and new database.
•Handel Procure to pay and order to cash in Netsuite.
•Preparing A/R ageing and A/P Ageing reports and Inventory Ageing reports according to NetSuite.
•Preparing the Expense report and Sales report for all the location.
•Coordinating with Sales supervisor for the correct data.
•LI Digital Payment System
Responsibilities:-
•Works on Power BI to develop the reports and Dashboards
•Assisted with automation of Reconciliation department by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
•Analyzing products revenue in & out flows.
•Coordinating with vendors to avoid risk mitigation
•Involved in product testing with development team to test from operational perspective
•Given product training to stakeholders
•Extensive usage of MS Excel (Aggregate functions, Lookup & Pivot table)
Projects:-
•Developed the dashboard with the help of VBA coding, that automatically lookup with other files and published result into source file.
•Developed the automated tool with the help of VBA coding that helps in sending emails with the attachments to the clients.
•Vodafone Australia- Tech Mahindra Business Service
Responsibilities:-
•MIS reporting by using MS Excel, SQL for Mumbai Operational and for Vodafone Australia.
•Gather raw data from MY BI and Hyperion portals, upload the data into SQL. Manipulate the queries into SQL and get the required data to prepare the reports.
•Coordinating with Australia team and Mumbai team and generating dashboard reports as per requirement
•Daily preparing KPI reports to measure the performance between Mumbai Team and Australia Team.
•Extensive usage of MS Excel (Aggregate function, Lookup, Pivot table)
3) BT Customer Experience Dashboard - Tech Mahindra
As a SPOC monitoring data which was submitted by cross functional teams
•Analyzed same data and prepared dashboards for management
•Handling tickets of user and providing feasible solutions
•Prepared monthly dashboards on AMS
•BTGS CEP - Tech Mahindra
Responsibilities: - BTGS-CEP
•BT conducts the surveys for their products which are being used across the globe by the leading business customers. Involved in Loyalty Tracker, F2F and EDCSM surveys.
•On completion of the survey, the reports are generated. We work on the data to prepare reports which we received from different SPOC of different regions.
•We validate the data and uploaded it on various portals
Responsibilities:-
•Ryder is a Logistics and Transport company, who provides services to all over the world.
•Handled Account Payable activity, in Accounts Payable, we make payments to the Vendors across the globe.
•To make right payments to right vendor is equally important
Munot & Co is Chartered Accounting firm.
•My job was to maintaining Books of Accounts up to Finalization.
•Prepared Vat Returns forms, prepared Sales Tax Returns forms.
•Auditing of Financial Statements.
•Surfa Coats
Surfa Coats is a paint company.
• My job was to take orders from Builders and Shops & place to the company
from
from
from