Data Analyst

Collected, cleaned, and analyzed B2B customer transaction data to perform segmentation using K-Means Clustering. Utilized SQL, Python (Pandas), and Excel (advanced functions like VLOOKUP, pivot tables) for data extraction, transformation and analysis. Designed and deployed Power BI dashboards to visualize sales performance, inventory trends, and financial KPIs. Conducted time-series analysis to identify seasonal trends, predict future sales, and guide inventory management. Built Machine learning models (ARIMA) for monthly sales forecasting, reducing stock wastage by 10–15%. Automated daily and monthly reporting using Python (Pandas, Matplotlib) and Excel macros, reducing manual work by 30%. Supported the finance team with real-time dashboards for cash flow visibility, expense tracking, and overdue payments.

Monitored accounting audits and ensured compliance with internal controls. Led cost accounting and financial forecasting activities. Supervised inventory transactions including access to receiving, storage, and shipping areas. Prepared key financial statements, including Balance Sheet, Profit & Loss Statement, and Cash Flow Reports. Managed petty cash and controlled its disbursement, reporting all the related incurred expenses on time. Conducted root cause analysis of delayed payments and implemented targeted credit control strategies. Led end-to-end analytics projects from data collection to executive dashboard reporting.

Carried out the ledgers and bank statements reconciliation of the company. Managed the submission of invoices and organized the filing of the financial documents. Made routine accounting journal adjustments for recurring corrections. Carried out the company’s bank deposits and managed the incoming payments and outgoing cheques. Preparation of reports of Purchase, Purchase return, Sales, Sales return. Tracked and recorded vehicle-related expenses, ensuring proper documentation and compliance with company accounting procedures.

GPA: 2.39/4.0