Kareem

Power BI Report with Embedded Power Apps & SharePoint Integration

Hamilton Beach Brands Inc • Freelance

May 2026 - Jun 2026 • 1 mo

I designed and built a complete end-to-end solution integrating Power BI, Power Apps, and SharePoint to streamline monthly comment tracking and data collection. What I Built: I created a Power BI report with an interactive month slicer that allows users to filter data dynamically Developed and embedded a custom Power Apps canvas application directly into the Power BI report as a visual Implemented automatic month capture from the Power BI slicer using PowerBIIntegration.Data without requiring manual user input Built a comment submission form with validation and success notifications Connected Power Apps to a SharePoint list to automatically save comments with their corresponding month values Technical Skills Applied: Power BI: Report design, slicer configuration, embedding Power Apps visuals, data visualization Power Apps: Canvas app development, form design, formula writing using Power Apps formula language (Power Fx) SharePoint: List creation, column configuration, permissions management PowerBIIntegration.Data: Reading filter context from Power BI into Power Apps Data Integration: Patch function for creating new records, error handling, and user notifications Key Features: ✓ Automatic month detection from Power BI slicer ✓ Real-time data submission to SharePoint ✓ User-friendly form with validation ✓ Success notifications upon submission ✓ Tested and verified end-to-end functionality Outcome: A fully functional, production-ready solution that eliminates manual data entry steps and streamlines the comment collection process. Users can now submit monthly feedback directly from the Power BI report without duplicating month selection.

Umzug Hitzke GmbH (German Logistics Company)

Umzug Hitzke GmbH (German Logistics Company)

Jan 2026 - Mar 2026 • 2 mos

Projects Delivered: 1. AI Audio Transcription System Automated transcription of 50-100 daily voice recordings using AssemblyAI and OpenAI GPT-4. Built intelligent routing to deliver formatted transcriptions to correct employees based on folder structure. Results: 85% time savings (3 hours → 30 min daily), 100% automated delivery 2. WhatsApp Document Distribution Created smart PDF routing system with business hours detection (8 AM-6 PM), automatic scheduling for off-hours uploads, and group-specific messaging. Results: 90% workflow automated, zero manual tracking, scalable to 500+ docs/month 3. Dynamic Calendar Management Automated .ics file parsing and event creation across 12 employee calendars. Implemented subfolder-based categorization (HI-UZB, PO-UZB, BE-UZB) with intelligent title reformatting. Results: 80% time reduction (2-3 hours → 30 min daily), 20-30 appointments processed automatically Technical Achievements: ✅ Integrated Microsoft Graph API, AssemblyAI, OpenAI ✅ Complex expression logic (path parsing, JSON lookups, conditional routing) ✅ Concurrency management for simultaneous uploads ✅ Comprehensive error handling & duplicate prevention Total Impact: 200+ hours saved monthly, production-ready solutions with zero manual errors Tech Stack: Power Automate Premium, Microsoft 365, AssemblyAI, OpenAI API, Microsoft Graph, QNAP Integration

Industrial Procurement Company (RFQ Automation System)

Procurement Tactics • Freelance

Dec 2025 - Feb 2026 • 2 mos

I was approached by a procurement team struggling with managing RFQs manually. Their workflow depended on emails, spreadsheets, and constant follow-ups, leading to scattered documents, delays, and missed opportunities. They didn’t lack tools — they lacked an efficient system. After analyzing their process, I designed and built a complete RFQ automation system using Microsoft 365. I developed an automated intake flow that captures RFQ emails, generates reference numbers, creates structured OneDrive folders, and logs data into Excel. I also implemented an approval monitoring system, supplier enquiry automation, quotation tracking, and a client offer follow-up workflow. Each flow was connected with smart logic for status tracking, routing, and error prevention. Today, the system runs seamlessly in the background, transforming their operations. RFQs are instantly organized, supplier communication is faster, and no documents are lost. Automated follow-ups have improved response rates, while manual workload has been drastically reduced. The company now saves over 150 hours monthly, operates with near-zero errors, and focuses more on strategic decisions rather than repetitive tasks.