KAMEL ABDALLAH

KAMEL ABDALLAH

Senior Sales Analyst
Malaysia
English, Arabic

نبذة عني

Resourceful Senior Sales Analyst with over 10 years of experience in data analysis, financial reporting, and business intelligence. Proven ability to extract, clean, and transform multi-domain data, developing interactiv…

الخبرة

Senior Sales Analyst

NSK, Selangor, Malaysia
حتى الآن

Analyzed regional, product, and customer segment sales performance data to identify trends, risks, and revenue growth opportunities., Developed and maintained interactive Power BI dashboards (DAX, Data Modeling) for tracking KPIs, sales pipeline, quotas, and win/loss analysis., Collaborated with Sales, Marketing, and Finance teams to support revenue forecasting, annual planning, and commercial strategy development., Evaluated sales effectiveness and optimized pricing, discount structures, and margin performance to enhance profitability., Performed ad-hoc data analysis to support strategic initiatives and executive decision-making in a dynamic environment., Ensured data accuracy and integrity across CRM systems and reporting platforms through rigorous validation and data cleaning., Worked cross-functionally to design and implement sales performance frameworks and standardized reporting., Presented data-driven insights and strategic recommendations to senior leadership utilizing effective storytelling and visualization., Automated reporting processes and improved overall efficiency using advanced Excel and BI tools., Mentored junior analysts, fostering best practices in data analysis, reporting, and dashboard creation.

Commercial Manager

Family Foods, Cairo, Egypt

Spearheaded data-driven commercial and operational reporting across sales, finance, production, and supply chain functions., Engineered and maintained integrated performance dashboards consolidating operational, financial, and commercial data., Conducted trend analysis, revenue forecasting, and variance analysis to support executive decision-making., Enhanced marketing ROI by 20% through structured KPI measurement and customer data analytics., Standardized reporting templates across departments to improve data accuracy and traceability., Implemented cost-control analytics, contributing to improved profitability and 300% margin growth during business model transformation., Prepared validated datasets for financial reviews and strategic planning., Automated recurring Excel reports using advanced formulas and VBA, reducing manual reporting time., Utilized Python (Pandas) for exploratory data analysis and preparation of large commercial and operational datasets used in Power BI dashboards., Developed Python-assisted data cleaning and transformation workflows to enhance reporting accuracy across sales, finance, and production datasets., Applied Python-based analytics techniques to support sales performance monitoring, KPI tracking, and revenue trend analysis.

Sales Business Development Manager

K. Hagag Group, 6th of October, Egypt

Automated Power BI and Excel reports, resulting in a 30% reduction in reporting time., Designed SQL-based tools for sales performance tracking and inventory management., Constructed ESG KPI dashboards and models to enhance transparency and ensure compliance., Leveraged Python scripts for data preparation and automation of sales performance datasets utilized in Power BI reporting., Executed Python-assisted exploratory analysis to uncover sales trends, product performance patterns, and demand fluctuations.

Finance Reporting Supervisor

Beyti (Almarai & PepsiCo JV), Cairo, Egypt

Oversaw enterprise-level financial and operational reporting to support Sales, Finance, and Commercial leadership., Generated structured financial reports including DSO, aging analysis, revenue trends, and variance analysis., Served as a liaison between Finance, Sales, Marketing, and Operations to ensure data alignment and reporting accuracy., Developed a comprehensive standardized reporting system, enhancing decision-making speed by 30%., Facilitated audit processes through validated and reconciled datasets compliant with IFRS standards., Executed forecasting and scenario analysis to support budgeting and financial planning initiatives., Established a centralized Accounts Receivable Shared Service Department, improving transparency, traceability, and governance controls., Created Excel-based reporting automation tools integrating multi-source datasets., Utilized Python data processing techniques alongside SQL and Excel to analyze financial and commercial datasets, enhancing forecasting and variance analysis., Applied Python-based analytics to improve the efficiency of large dataset processing and reporting workflows.

AR & DC Accountant

Beyti (Almarai & PepsiCo JV), Cairo, Egypt

Validated daily sales and treasury data, ensuring adherence to internal controls., Conducted reconciliations and supported monthly financial closing activities., Performed inventory audits, ensuring the accuracy of transactional datasets., Maintained version-controlled financial records to support governance requirements.

Sales & Key Account Analysis Supervisor

Beyti (Almarai & PepsiCo JV), Cairo, Egypt

Analyzed extensive sales datasets to reveal revenue trends and performance gaps., Developed structured sales performance dashboards for senior management., Executed forecasting and analyzed promotional effectiveness to refine sales strategies., Enhanced the asset tracking system, achieving a 30% sales uplift through improved accountability and monitoring., Conducted Python-based exploratory analysis on sales and customer datasets to identify revenue drivers and performance gaps., Utilized Python and Excel analytics tools to enhance the preparation of data for management performance dashboards.

المهارات

الأتمتة التقارير المالية مايكروسوفت إكسل المهارات التحليلية أزور استخراج البيانات حوكمة البيانات نمذجة البيانات جمع المعلومات تعاون تعلم الآلة باور بي آي مهارات العرض التحليل الإحصائي Data Cleaning & Validation Data Transformation & Standardisation Multi-Domain Data Analysis Dashboard Development & Data Visualisation KPI Tracking & Performance Measurement Forecasting & Trend Analysis Variance Analysis & Financial Modelling Data Governance & Reporting Standards Excel Dashboards VBA Automation SQL Statistical Analysis & Confidence Measurement Cross-Functional Enterprise Reporting Process Automation & Continuous Improvement KPI Scorecards & Executive Reporting Data Validation & Reconciliation Forecasting Models Python for Data Analysis Python Data Cleaning & Transformation Python Automation for Data Processing Python-based Sales Data Analysis Python for KPI Performance Monitoring Python Visualization Libraries Reporting Automation Multi-source Data Integration Sales Performance Analytics KPI Tracking Communication Skills Learning Opportunities Revenue Analytics BI Tools Business Insight Generation KPI Monitoring Database Querying ETL Processes Problem-Solving Skills Critical-Thinking Skills BI Best Practices Predictive Modeling Industry Knowledge Data extraction Data cleaning Data validation Data transformation Data standardisation Data analysis Dashboard development Data visualisation KPI tracking Performance measurement Forecasting Trend analysis Variance analysis Financial modelling Data governance Reporting standards Excel dashboards Pivot tables Power Query VBA DAX Data modeling Statistical analysis Confidence measurement Cross-functional reporting Process automation Continuous improvement Financial reporting (IFRS) Executive reporting Data reconciliation Forecasting models Python Pandas NumPy Matplotlib Seaborn Reporting automation Multi-source data integration ETL processes Database querying BI best practices Predictive modeling Machine learning Communication skills Presentation skills
الإبلاغ عن هذا الملف الشخصي؟