Mohamed Heram

Data Analyst and Business Intelligence specialist who has delivered end-to-end analytics across $27M+ in combined revenue data using Power BI, Excel, and SQL — uncovering high-impact findings such as an 8.1x store performance gap and a critical -101.5% margin leak. Skilled at building interactive dashboards, DAX measure libraries, and KPI reporting systems that cut reporting time by up to 40% and turn raw data into clear, decision-ready insights. Experienced across telecom, real estate, and education sectors.

Data Analysis Intern (2026-01 – Present)

• Analyzed datasets of 500+ records using Excel (Pivot Tables, VLOOKUP) and Power BI to extract actionable business insights
• Designed and deployed interactive dashboards to track KPIs and operational performance metrics in real time
• Cleaned, transformed, and validated raw data to ensure high data quality and accuracy for reporting
• Developed structured reports to communicate findings and support management decision-making

Data Analyst (2025-01 – Present)

• Partnered with clients to understand business requirements and translate them into analytical solutions using Excel and Power BI
• Built interactive dashboards enabling clients to self-serve data insights and reduce manual reporting effort
• Performed end-to-end data workflow: collection, cleaning, transformation, analysis, and visualization
• Delivered business-focused reports with clear KPIs, trends, and actionable recommendations

Technical Support Intern (2025-02 – 2025-07)

• Provided first-level technical support to 30+ users per shift, resolving ~70% of issues without escalation
• Reduced average issue resolution time by 25% through structured troubleshooting frameworks
• Documented 100+ support tickets, building a data record that improved team knowledge base and reporting
• Applied data tracking skills to monitor issue trends and identify recurring technical problems

Real Estate Business Analyst Intern (2025-07 – 2025-12)

• Supported residential market analysis and property listing data management to inform sales strategy

Sales Representative (2026-03 – Present)

• Maintain sales and customer records while analyzing client needs to recommend data-driven financing plans

B.Sc. in Management Information Systems (MIS) (2020-10 – 2024-06)