Skip to main content
karam atfyKA
Looking for a job

karam atfy

@karamatfy

Business Intelligence Consultant at Freelance, building Power BI dashboards that uncover profit leaks and pricing risks.

Egypt
Message

As a Business Intelligence Consultant & Data Analyst at Freelance, I design automated Power BI reports and Star Schema models that turn transactional records into executive KPI dashboards. I develop DAX measures and Power Query workflows to monitor performance, revenue growth, and customer retention.

In my commercial sales and profitability project, I analyzed $11.95M in sales data and identified a West territory margin drop linked to deep discounting. I also found that promotions above 20% were associated with a 66% drop in sales volume and a 65% loss in net profit.

For my multi-channel marketing model, I audited a $37.36M digital marketing budget across six acquisition channels. The analysis identified Social Media as the ROAS leader and Email as the top conversion driver, informing budget allocation recommendations.

As an Inventory Data Specialist & Operations Storekeeper, I audited records for 5,000+ spare-parts SKUs using ERP software and Advanced Excel, reducing reconciliation variance by 25%. I also deliver data workshops and mentor junior professionals in dashboard interpretation, data modeling, and data storytelling.

Experience

Work history, roles, and key accomplishments

FR
Current

Business Intelligence Consultant & Data Analyst

Freelance

Jan 2024 - Present (2 years 9 months)

Design automated Power BI reports and Star Schema data models, transforming complex transactional records into centralized executive KPI dashboards. Develop optimized DAX measures and Power Query ETL workflows to monitor business performance indicators, revenue growth, and customer retention.

FE
Current

Corporate Trainer & Data Workshop Facilitator

Freelance / Educational

Jan 2023 - Present (3 years 9 months)

Deliver structured workshops on data literacy, KPI dashboard interpretation, and business reporting tools for corporate teams and analysts. Mentor junior professionals on dashboard ergonomics, data modeling best practices, and data storytelling techniques.

AP

Inventory Data Specialist & Operations Storekeeper

Automotive & Parts

Jan 2018 - Dec 2023 (5 years 11 months)

Audited operational databases containing 5,000+ spare parts SKUs via ERP software and Advanced Excel, reducing reconciliation variance by 25%. Conducted monthly inventory analyses, optimizing stock turnover ratios and reorder thresholds to prevent working capital lockup.

Education

Degrees, certifications, and relevant coursework

Alexandria University logoAU

Alexandria University

Bachelor of Commerce, Commerce

Bachelor of Commerce degree from Alexandria University, Egypt.

Tech stack

Software and tools used professionally

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan