FINANCE

E-commerceGenerating both periodic and ad hoc reports as needed.• Made a combination of power query editor (ETL), Excel functions, and VBA codes to automate periodic reports.• Providing support and maintenance to existing management information systems.• Analysing historical sales data using Excel, to distinguish slow-moving and fast-moving articles.• Generating comprehensive sales through reports utilized to analyse sales data, track performance metrics, and identify areas for improvement.• Conducting RCA (Root Cause Analysis) to figure out the main reasons for returns.• Conducting stock reconciliation processes to compare the In-Hand_Stock, Sold on Portals, and received from Vendor, identifying and resolving discrepancies.• Generating and distributing management reports in an accurate and timely manner.• Developing and implementing an inventory aging report by analysing historical sales data and categorizing inventory items based on their sales velocity.• Providing recommendations to update current MIS to improve reporting efficiency and consistency.• Performing data analysis for generating reports periodically.• Analysing business information to identify process improvements for increasing business efficiency and effectiveness.• Handling the reconciliation of payments received in the bank with the corresponding entries reflected across various channels involves ensuring accuracy and consistency in financial recordsPreparing Power BI Dashboard for Visualizing the daily and monthly sales data to get insights.• Participating in cross-functional meetings to resolve recurring issues.

*Awarded Employee of the Month for outstanding performance (03/2022).*Awarded Trainee of the Month for outstanding performance within a month, of joining the organization (08/2021).Maintained accurate records of all vendors and their contracts.• Handled all queries and escalations from clients on reports and ensured resolution within TAT.• Tracked, monitored, and reported on all Service Deliveries.• Quality improvement plans.• Prepared scorecards for the team every week.• Prepared Dashboards & and PowerPoint for SLA reports, query resolution, and MOMs.• Processed Orders using SAP.