SELECT * FROM insights
COUNT(opportunities)
AVG(performance) ↗
SUM(value) = 💡

Mahmoud Khalil

Bridging accounting and data analysis — delivering accurate financial insights and actionable business decisions.

Financial Services Excel & Power BI SQL & Reporting

About Me

I've always been fascinated by how numbers can tell the story of a business. When I joined Mansoura University, I explored the basics of finance, and soon realized that numbers alone aren't enough — turning them into insights is what really matters. That curiosity pushed me to learn tools like SQL, Python, and Excel (Power Query) to dive deeper into data and connect it with financial analysis. During my CIB Summer Internship, I applied analytical and reporting skills to real banking operations and witnessed how data can guide decisions and create real impact. Now, I'm combining my accounting foundation with data-driven tools to transform raw data into actionable financial insights. Every dataset has a story — and I'm passionate about bringing it to life.

Projects

📊 Titanic Data Analysis Dashboard

Comprehensive analysis dashboard examining survival patterns of 891 passengers. Deep dive into demographics, social class impact, and port embarkation effects on survival rates using advanced Excel functions and Power BI visualizations.

Excel Power BI Data Viz Statistical Analysis

🛒 Super Store Analysis For DEPI

Interactive business intelligence dashboard analyzing multi-regional store performance. Features comprehensive KPI tracking, sales trend analysis by region & sub-category, order fulfillment delays, and predictive insights for business growth.

Excel Power BI SQL Data Analysis KPI Tracking

Technical Skills

Financial Analysis

Advanced accounting principles, variance analysis, financial reconciliation, budgeting, and comprehensive financial modeling for business insights.

Excel (Advanced)

Expert-level Excel with Pivot Tables, complex formulas, Power Query, VBA automation, and dynamic dashboard creation. MOS Excel Certified.

Power BI & SQL

Data extraction, transformation, advanced DAX measures, interactive visualizations, and database querying for comprehensive reporting.

Data Visualization

Creating compelling, interactive dashboards with clear KPI representation, trend analysis, and actionable business intelligence.

Business Tools

Microsoft Office Suite mastery, project management, cross-functional collaboration, and effective business communication.

Languages

Arabic (Native), English (B2 Proficient) - enabling effective communication in international business environments.

Professional Experience

CIB Egypt – Summer Internship

Financial Services • Banking Operations
  • Completed comprehensive rotation across onboarding, compliance, and financial services operations departments
  • Processed daily banking transactions with 100% accuracy, ensuring regulatory compliance and customer satisfaction
  • Supported KYC/AML verification processes and handled complex client inquiries with professional expertise
  • Collaborated with cross-functional teams to streamline operational workflows and improve efficiency

Work Egypt – Recruitment Assistant

Human Resources • Talent Acquisition
  • Reviewed and evaluated 100+ candidate applications, coordinating interviews across multiple departments
  • Organized and digitized applicant records, improving database efficiency by 40% and enhancing data accessibility
  • Assisted in developing recruitment strategies and candidate assessment criteria for various positions

Education

Faculty of Commerce (English Section)

Mansoura University
Bachelor of Commerce in Accounting

Comprehensive study of accounting principles with specialized focus on financial reporting, cost accounting, and business analytics. Developed strong analytical thinking and problem-solving skills through rigorous coursework in financial analysis, auditing, and data-driven decision making.

Accounting Principles Financial Analysis Business Analytics Cost Management

Certifications & Training

Aspire Leaders Program

Aspire Institute

Comprehensive leadership development program focusing on strategic thinking, team management, and organizational leadership skills.

Emerging Talents for Future Workplace

Commercial International Bank (CIB)

Intensive training in banking operations, customer service excellence, advanced Excel applications, and professional soft skills development.

Human-Centric Interpersonal Skills

Frankfurt School of Finance & Management

Advanced training in workplace communication, emotional intelligence, empathy-driven leadership, and collaborative management practices.

Project Management Training

PMI × INJAZ Al-Arab

Professional project management methodologies including resource planning, timeline management, risk assessment, and stakeholder communication.

Professional Soft Skills Development

Egyptian Banking Institute

Comprehensive soft skills training covering business communication, teamwork dynamics, professional etiquette, and client relationship management.

Microsoft Office Specialist (MOS) - Excel

Microsoft Certification

Official Microsoft certification demonstrating advanced proficiency in Excel functions, data analysis tools, pivot tables, and spreadsheet formatting.

Offered Services – Data Analysis

Data Cleaning & Preprocessing

Transform raw data into clean, organized datasets ready for analysis.

Excel SQL Data Prep

Data Visualization & Dashboards

Create interactive charts and dashboards using Excel, Power BI, and Tableau to help businesses understand their data at a glance.

Power BI Excel Tableau Dashboards

Statistical Analysis & Insights

Analyze data trends, patterns, and correlations to support informed decision-making.

Stats Insights Trends

SQL & Database Management

Extract, query, and manage data efficiently using SQL databases.

SQL Database Query

Reporting & Financial Analysis

Generate clear and actionable reports for financial or operational decision-making.

Excel Power BI Financial Reporting

Predictive Analytics & Forecasting

Use historical data to forecast trends and help businesses plan strategically.

Forecasting Excel Trends Planning

Get In Touch

Ready to transform your data into actionable insights? Let's collaborate on your next project.