Mohamad Ghanem Email & Phone Number

Ottawa, On, Ca

Ottawa, Ontario, Canada

- Power Automate Flows: Developed workflows, resolved errors, created expressions and formulas, utilized HTTP requests for data management.- Power Apps Leave Application System (Award Winning): Designed and implemented a leave application system, providing debugging and support.- Power BI Leave Application System: Created report visuals for monitoring employee leave, incorporating statistics and metrics.- Power BI Heat Map Reports: Developed report visuals with heat and bubble maps, conducted data cleaning, utilized Python and Google Maps API for geo-data.- Power BI Revenue Reports: Produced detailed reports and visualizations (pyramids, funnels, bar charts), leveraging DAX and Power Query formulas.- Microsoft Excel Projects: Cleaned and harmonized data across spreadsheets, analyzed multi-year data, created tailored formats.- Data Entry Projects: Recorded, cleaned, and entered data into the department database.- Tracing Program Project: Led the initiative to trace lost alumni, creating flowcharts and assigning tasks to ensure completion.- Data Integrity & Security: Ensured protection, careful handling, and safeguarding of highly confidential data.- Research Projects: Conducted research to support departmental objectives.- HTML & CSS PDF/Email Formatting: Utilized HTML and CSS for PDF form submissions, designed emails for the leave system, reducing paper usage by 40%.- Documentation of Automation Flows & Apps: Authored documentation for automation flows and applications, including code explanations and usage rationale.- App Speed Optimization: Optimized code to enhance data loading speed for users and managers.- Management View in App: Developed a feature for managers to oversee employee leave, providing a gallery-like list with leave metrics.

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

Continued part-time from the Projects Assistant full-time position• Designed a leave management system using the Microsoft Power Platform. Utilized Power Apps to develop a low-code application with advanced functionalities.• Employed Power Automate to streamline office processes, including approval requests, document approvals, and daily email notifications highlighting employees currently away.• Utilized HTML and CSS for creating PDF form documents integrated into the automation process.• Employed CSS for designing email tables.• Utilized Power BI to craft calendar visualizations, including an employee away calendar with monthly views, filters, and slicers.• Created reports with Power BI, featuring cleaned data, filters, slicers, and intricate calculations for leave submission data entry.• Conducted research using Excel spreadsheets.• Engaged in data entry and record management within the Banner9 database system.• Assisted in photo management, including editing and tagging.• Managed reception duties, handling mail, calls, and other responsibilities.

Ottawa, Ontario, Canada

Duties as Co-Op student at the Department of University Advancement:• Designed a leave management system using the Microsoft Power Platform. Utilized Power Apps to develop a low-code application with advanced functionalities.• Employed Power Automate to streamline office processes, including approval requests, document approvals, and daily email notifications highlighting employees currently away.• Utilized HTML and CSS for creating PDF form documents integrated into the automation process.• Employed CSS for designing email tables.• Utilized Power BI to craft calendar visualizations, including an employee away calendar with monthly views, filters, and slicers.• Created reports with Power BI, featuring cleaned data, filters, slicers, and intricate calculations for leave submission data entry.• Conducted research using Excel spreadsheets.• Engaged in data entry and record management within the Banner9 database system.• Assisted in photo management, including editing and tagging.• Managed reception duties, handling mail, calls, and other responsibilities.

Ottawa, Ontario, Canada

Connect with the Carleton University network and sustain a positive relationship with business partners and parents and provide them with multiple campus activities and programs that enrich the student's life at the University to support and help multiple variations of funds at Carleton University.

Ottawa, Ontario, Canada

Impact on sales and customer satisfaction by:• In-store shopping - selecting quality products• Ensuring customer orders are accurate and ready for pick-up• Answering any customer inquiries• Handling POS transactions (debit/credit/cash/gift card)• Providing exceptional customer service• Other duties as required