Azeezur R.

Developed comprehensive Google Sheets dashboards to track over 15 KPIs across various e-commerce channels, enhancing data visibility significantly. Established advanced data validation rules in Google Sheets, which decreased data entry errors and ensured high accuracy across a large number of product listings. Automated P&L reporting utilizing Google Sheets QUERY functions and Apps Script, resulting in a significant reduction in reporting time while increasing consistency. Conducted data analysis of product performance metrics with pivot tables and custom formulas, targeting revenue-generating SKUs for inventory optimization. Validated and reconciled e-commerce data from platforms such as Shopify and Amazon using advanced functions in Google Sheets to maintain data integrity. Created forecasting models based on historical sales data in Google Sheets, aiding strategic planning with high accuracy. Worked alongside marketing teams to assess campaign ROI through visualization techniques, supporting financial allocations for marketing spends. Standardized product catalog management protocols across a substantial number of SKUs to enhance searchability and improve the customer experience. Analyzed operational expenses through conditional formatting and charts in Google Sheets to identify cost-saving opportunities.

Developed automated financial reconciliation spreadsheets in Google Sheets to accurately process and validate numerous transactions on a monthly basis. Maintained financial data integrity across various ledgers by employing cross-referencing techniques in Google Sheets ensuring compliance. Created dashboards for expense tracking that featured real-time data validation and automated alerts, thus enhancing financial visibility and reducing processing time. Collaborated with cross-functional teams to establish standardized data entry and validation procedures that significantly minimized discrepancies.