Tarek Ali
Dubai
Summary
At the Federal Tax Authority, our team's data management efforts have been pivotal in streamlining VAT and Corporate Tax registrations. Through Power BI, we deliver daily and periodic reports that foster regulatory compliance and offer strategic insights for informed decision-making. The blend of technical proficiency in data cleansing and quality assurance has significantly uplifted the integrity of our tax-related insights. Previously, with BFL Group, our collaborative efforts in data analysis led to the creation of dynamic visualizations and strategic reports that propelled business growth. The application of SQL and Python for data transformations and visualizations underpins the depth of my analytical skills, which contribute to the Federal Tax Authority's commitment to optimizing tax processes and maintaining robust financial data systems. Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Analyst
Federal Tax Authority
Dubai
02.2024 - Current
- Oversaw VAT and Corporate Tax (CT) registration processes and updates, to ensure compliance and accuracy in tax registrations and approvals
- Conducted comprehensive data cleansing to remove duplicates, handle cancellations, and categorize records by tax types, enabling high data integrity and enhancing the precision of tax-related insights
- Developed and analyzed daily and periodic reports using Power BI to monitor compliance and VAT obligations
- Provided actionable insights to support strategic decision-making and optimize tax operations
- Supported the implementation of RPA solutions and data warehouse initiatives for CT applications, ensuring data flow consistency and process efficiency through data analysis
- Collaborated on internal audit requirements for data cleansing and quality checks
- Managed departmental reports and meeting documentation to facilitate transparent communication across teams
Business Data Analyst
BFL Group
Dubai
10.2023 - 02.2024
- Analyzing diverse datasets to uncover actionable insights, enhancing data-driven decision-making, and aligning analytical findings with business objectives to drive growth
- Designing dynamic, interactive dashboards and reports using Power BI and advanced Excel functions, translating complex data into clear, visual insights for stakeholders
- Executing complex data transformations and crafting SQL queries to extract key patterns and trends, enabling deep, precise analysis across extensive datasets
- Utilizing Python for data automation and visualization, streamlining workflows and generating impactful reports with tools like Pandas, Matplotlib, and Seaborn
- Working cross-functionally to implement ETL/ELT solutions and maintain data quality, fostering reliable, data-driven solutions that enhance team collaboration and operational efficiency
Data Analyst
Grand Bazaar General Trading
Dubai
09.2021 - 10.2023
- Conducted financial data analysis, calculated key financial ratios such as gross margin, inventory turnover, and profitability, and provided actionable insights to support strategic decision-making in retail sectors across Dubai Mall and Souk Madinat Jumeirah
- Analyzed inventory levels and turnover rates, identified high-demand and low-performing products, and generated recommendations to optimize stock levels, enhance product availability, and reduce carrying costs
- Monitored market trends and competitor pricing to provide insights on price positioning and sales strategies, ensuring competitive advantage and alignment with industry standards in the antiques, apparel, and fragrance sectors
- Analyzed consumer purchasing patterns, identified seasonal trends, and presented findings on customer preferences to tailor marketing efforts and improve the customer experience
- Designed dynamic dashboards and reports using Power BI and Excel to facilitate data-driven decisions across departments, ensuring easy access to key metrics and performance insights
Senior Accountant
Grand Bazaar General Trading LLC
Dubai
02.2021 - 11.2021
- Prepare monthly profit and loss statement
- Prepare monthly financial statements
- Analyze general and marketing expenses
- Calculate commissions for sales representatives and store employees
- Prepare budget every 3 months
- Prepare cash flow statement
- Supervise warehouse accountant and purchasing accountant
- Record daily sales from point of sale to main cash box
- Post daily expenses for the company and record other income
- Increased company's profits by 15% in the past year
- Reduced general expenses by 10%
- Improved the accuracy of financial reporting
- Provided valuable financial insights to management
Cost Accountant
Hassan Allam Holding
Cairo
08.2019 - 01.2021
- Gets all accounting documents regularly (such as invoices, advices, instructions, statements, reports, etc.)
- Ensures that all accounting documents are signed and supported as required before proceeding further
- Analyzes transactions based on accounting documents and writes accounting entries using given codes
- Prepares computation or analyses in support of the monthly services-to-other-sites entries
- Prepares computation or analyses in support of entries for expenses passed on or distributed to other sites
- Prepares costing sheets or similar reports for imported or specific items in which costs are first accumulated on a suspense account; reclassifies such items to the correct account after obtaining approval for final value
- Posts all cash and general accounting entries (including Stores auto-entries) to the books of accounts, updates these entries upon getting approval, and, if applicable, sends the debit or credit advices to concern parties
- Does monthly intercompany account reconciliation, and coordinates with sites and offices to match balances
- Prepares financial statements like operations report, cash flows, package reports, etc
- As periodically required
- Prepares analyses or statements or special reports for certain accounts as and when required by Management
- Prepares monthly the payroll deductions statement and submits the same for review and approval
Accounts Payable & Receivable Specialist
Archirodon Group N.V.
Cairo
08.2016 - 08.2019
- Conduct monthly and quarterly account reconciliation to ensure accurate reporting and ledger maintenance
- Handle all bank operations, Reconciliation and treasury works
- Coordinate monthly closing process
- Conduct day to day cash transactions
- Prepare assets, liability, and capital account entries by compiling and analyzing account information
- Guide accounting clerical staff by coordinating activities and answering questions
General Ledger Accountant
Gardenia
Cairo
12.2014 - 07.2016
- Posts all cash and general accounting entries (including Stores auto-entries) to the books of accounts, updates these entries upon getting approval, and, if applicable, sends the debit or credit advices to concern parties
- Gives copies or originals of posted documents to payables accountant/cashier, if payments would be made
- Does monthly intercompany account reconciliation, and coordinates with sites and offices to match balances
- Prepares financial statements like operations report, cash flows, package reports, etc
- As periodically required
- Prepares analyses or statements or special reports for certain accounts as and when required by Management
- Prepares monthly the payroll deductions statement and submits the same for review and approval
- Files documents, Financial Reporting and does relevant clerical work as applicable
- Does other accounting work given from time to time by the chief accountant
- Performs any other related duties as assigned
Education
Bachelor's degree - Business/Commerce, General
Al-Azhar University
06.2013
Skills
- Visual data representation
- Data filtering
- Defect tracking
- Gap analysis
- Data formatting
- ETL processes
- Problem-solving
- Data analysis
- Business process improvement
- Business solutions development
- Reporting tools
- Data integrity validation
- Database maintenance
- Excel functions
- Tableau
- Data validation
- Microsoft power BI
- Machine learning
- Data science
- Statistical analysis
- Project management
- Web scraping
- Trend analysis
- Business intelligence tools
Certification
- Data Science Professional Certificate (IBM)
- IBM Data Science Professional Certificate (IBM)
- Applied Data Science Capstone (IBM)
- Data Analyst Professional Certificate (IBM)
- Data Analyst Capstone Project (IBM)
- IBM Data Analyst Professional Certificate (IBM)
- Machine Learning with Python (IBM)
- Data Visualization with Python (IBM)
- Data Science Fundamentals Specialization (V2) (IBM)
- Statistics for Data Science with Python (IBM)
- Data Science Foundations (IBM)
- Databases and SQL for Data Science (IBM)
- Data Engineering Essentials (IBM)
- Data Analysis with Python (IBM)
- Data Visualization & Dashboard Essentials (IBM)
- Data Analysis & Visualization Foundations Specialization (IBM)
- Excel Essentials for Data Analytics (IBM)
- Python Project for Data Science (IBM)
- Python for Data Science and AI (IBM)
- Data Analytics Essentials (IBM)
- Tools for Data Science (IBM)
- Data Science Methodology (IBM)
- Data Science Orientation (IBM)
- Data Manipulation with pandas (DataCamp)
- Intro to Machine Learning (Kaggle)
- Financial Analysis: Introduction to Business Performance Analysis
- SQL: Data Reporting and Analysis
- Introduction to Python
- Data Analytics: Graph Analytics
- Complete Guide to Power BI for Data Analysts by Microsoft Press
Organization
Federal Tax Authority
Languages
Arabic
First Language
English
Advanced (C1)
C1
References
References available upon request.
Timeline
Data Analyst
Federal Tax Authority
02.2024 - Current
Business Data Analyst
BFL Group
10.2023 - 02.2024
Data Analyst
Grand Bazaar General Trading
09.2021 - 10.2023
Senior Accountant
Grand Bazaar General Trading LLC
02.2021 - 11.2021
Cost Accountant
Hassan Allam Holding
08.2019 - 01.2021
Accounts Payable & Receivable Specialist
Archirodon Group N.V.
08.2016 - 08.2019
General Ledger Accountant
Gardenia
12.2014 - 07.2016
Bachelor's degree - Business/Commerce, General
Al-Azhar University