Omar Shady

General Accountant ( Inventory - Export - Sales ) at LORD For Import and Export - Sotraco - S.A.E (2024-09 – Present)

Prepare and manage official documents for foreign clients
Design professional company letters and templates, including official requests and salary certificates.
Organize and archive client documents by creating dedicated folders to prevent data loss or mismanagement.
Create and maintain special records for clients involved in fraud and trademark infringement cases.
Record sales invoices and inventory issue vouchers using Al-Yaseer Accounting System.
Develop product codes, descriptions, and structured content using Microsoft Excel to facilitate documentation processes.
Analyze sales data using Power BI, including monthly, quarterly, semi-annual, and annual reports with comparative analysis.
Participate in annual inventory counts alongside external auditors at the end of each fiscal year.
Communicate and coordinate with shipping agencies through Microsoft Outlook.
Adapt to high-pressure environments, analyze operational problems, and implement practical solutions.
Prepare and execute bank transfer requests, including accurate calculation of transfer amounts and completion of official bank forms.
Analyze customer receivables and payments to ensure accurate financial records and timely settlements.
Prepare Certificates of Origin and follow up on their official approval and authentication by the Chamber of Commerce.

Data Analyst at Freelancer For Companies (2024-06 – Present)

Analyzed sales and inventory data using advanced Excel tools (PivotTables, Power Query, VLOOKUP).
Extracted and cleaned customer and invoice data from the accounting system for reporting purposes.
Built dynamic dashboards in Power BI to visualize key performance indicators (KPIs) and monitor sales trends.
Integrated and transformed data from multiple sources (CSV, Excel, accounting software) to enhance accuracy and usability.
Delivered periodic reports to management to support strategic decisions related to pricing and product lines.
Collaborated with sales and accounting teams to identify data needs and develop tailored analytical models.

Retail & Accounting Supervisor – Office Supplies Store at El-Maghraby Centre For Import ( Family Business ) (2021-09 – 2024-05)

Managed daily sales operations and handled accounting records for a retail store selling office supplies, children’s toys, and document printing services.
Supervised inventory and stock management to monitor total product quantities and prevent shortages or overstocking.
Set product pricing by combining cost, expenses, and profit margins to calculate net profit accurately.
Prepared basic financial tracking for sales, expenses, and profitability analysis.
Designed professional product visuals and promotional content for social media platforms, including Facebook, Instagram, and TikTok.
Published and managed marketing content to increase product visibility and customer engagement.
Worked efficiently under pressure while serving customers from different segments and backgrounds.
Supported overall store organization and operations to ensure smooth daily workflow.

نبذة