Riyadh Region
Results-driven Sales Data Analyst with over 3 years of experience turning raw sales data into actionable insights. Skilled in leveraging Microsoft Excel (advanced formulas, PivotTables, charts), Power BI (data modeling, DAX), and Microsoft Dynamics 365 Business Central to deliver accurate, timely, and visually impactful reports. Currently supporting SITAF in Riyadh with sales performance tracking, KPI reporting, and trend analysis to help sales teams and management make data-backed decisions. Experienced in VBA automation, data cleansing, and custom dashboard creation to streamline workflows and improve decision-making speed.
Extract, clean, and analyze sales data from Microsoft Dynamics 365 Business Central to produce actionable reports. Build and maintain Excel dashboards for monthly, weekly, and daily sales performance tracking. Design Power BI sales dashboards to visualize sales trends, customer behavior, and product performance. Automate recurring sales reports using VBA to reduce manual workload by over 30%. Collaborate with sales managers to track KPIs and identify growth opportunities.
• Assisted in analyzing sales and stock data on Microsoft Dynamics 365 Business Central for Sitaf Food in Riyadh, Saudi Arabia. • Prepared weekly and monthly reports on food and beverage sales, contributing to data-driven decision-making processes. • Collaborated with team members to present findings and analysis to stakeholders, enhancing communication and understanding within the organization.
Developed Power BI dashboards to visualize HR, procurement, and sales data. Utilized SQL for advanced data querying, cleansing, and reporting. Applied Excel data modeling and visualization to support business reviews. Improved operational efficiency by 40% through automation of repetitive tasks.
SQL: Wrote and optimized SQL queries for extracting, filtering, and aggregating sales and operational data. Joined datasets from multiple tables to create consolidated reports for decision-making. Integrated SQL outputs into Excel and Power BI for advanced visualization. Microsoft Excel & Power BI: Data Cleaning: Standardized and validated sales data for accuracy and consistency using Excel functions and Power Query. Formulas & Functions: Leveraged advanced formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS) to perform in-depth sales analysis. Pivot Tables: Built interactive pivot tables to summarize sales by month, region, product, and salesperson. Charts & Visualizations: Created bar, line, and pie charts in Excel and Power BI to highlight trends, KPIs, and performance metrics. Conditional Formatting: Applied visual cues to quickly identify growth areas and anomalies. Power BI Dashboards: Designed dynamic sales dashboards with DAX measures, filters, and slicers for self-service analytics. Postman (API Testing & Integration): Sent GET, POST, PUT, and DELETE requests to retrieve and update data for analysis. Managed and organized API endpoints using collections for efficient testing. Used variables to enhance flexibility in request automation. Created mock servers to simulate API responses for integration testing. Freshservice (ITSM Tool): Managed incident, service request, change, and problem processes to ensure business continuity. Automated routine tasks and notifications to reduce manual workload. Created performance reports and analytics to track SLAs and identify process improvements.
Extracted, cleaned, and uploaded product and customer data from various sources into the company CRM. Maintained and updated Excel-based sales trackers for management review. Created monthly sales and customer reports to support business planning. Used Excel pivot tables and conditional formatting to highlight performance trends. Assisted in migrating customer records into a new CRM platform, ensuring data accuracy and completeness.