Microsoft Excel
Accomplished Data Analyst Senior Specialist from current company, adept in data analysis and visualization, significantly enhancing decision-making and efficiency. Leveraged Excel and Power BI for impactful reports, fostering teamwork and collaboration. Achieved streamlined reporting processes and developed advanced analytical tools, improving data storage and retrieval performance. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Performing operational operations to keep the stock quantities in the stores and central warehouse at the targeted level.
Calculating store shelf capacities and determining the minimum/maximum stock values of the products for the stores according to the targeted inventory turnover days.
Ensuring that the products are sent to the stores at the right time and in the right amount by regularly checking the automatic shipment system.
Revising stock quantities/order parameters by examining the sales movements of the products and feedback from the stores
Presenting reports containing performance indicators such as stock adequacy target and out-of-stock rate to senior management
According to sales analysis, creating recommendation purchasing reports for the next period
Reviewing the list of products to be returned and making the necessary changes.
Determining the amount of fabric needed for production and making the material requirement plan accordingly.
Follow-up of all processes until the raw fabric is ready for production from its semi-finished state.
Cost analysis by calculating the wastes that occur during the production processes.
Preparation of weekly and monthly production reports and submission to senior management.
Calculating production costs and presenting them as a report to senior management.
- Daily, weekly and monthly turnover reporting and controlling target realization rates.
- Analyzing the performance of regional customer representatives.
Identifying lost and gained customers at the end of the month and providing support to the field for their re-acquisition.
- At the end of the year, analyzing the budget and target setting of the sales department for the new year and creating a new budget.
-Preparing dashboards to be presented to managers by visualizing monthly and annual sales data in Excel environment.
- Premium calculations and reporting of regional sales representatives.
Data Analysis
Microsoft Excel
Microsoft Power Bi
Microsoft Excel VBA
Data Visualization
[Area of Expertise] License - [Timeframe]
[Area of Expertise] License - [Timeframe]
[Area of certification] Training - [Timeframe]
Udemy Education Certifictions