Karim's Assistant

Online

Karim El Otmani

Data Specialist & Excel Master

I transform complex data into interactive dashboards and automated solutions that drive decision-making and optimize business processes.

Discover My Projects Get In Touch Preview Resume

Hello, I'm Karim.

Passionate about problem-solving, I specialize in creating tools in Excel and Power BI to make data clear, accessible, and actionable. My goal is to build effective solutions that eliminate manual tasks, ensure reliable reporting, and provide valuable insights for business growth. Having worked at Amazon and as a freelancer, I know how to adapt to various needs and deliver concrete results.

Advanced Excel Power Query & Power Pivot VBA & Macros Power BI Data Analysis Automation

Technical Skills

Here are the key technologies and tools I work with to deliver exceptional results.

Excel & VBA 95%

Power BI 90%

Data Analysis 88%

Power Query 92%

Automation 85%

Dashboard Design 87%

My Main Projects

Here is a selection of projects that illustrate my expertise in dashboard creation, analysis, and automation.

Operational Analysis

Daily Performance Dashboard | Amazon

Created an automated dashboard to analyze team performance and detect outliers (missed calls, extended breaks). This tool allowed managers to get a comprehensive overview and drill down into details to make informed decisions.

Key Skills:

Dashboard Building Automation KPI Analysis

Business Intelligence

Sales & Conversion Tracking | Fitness Coach

Developed a comprehensive dashboard for a coach selling programs on Instagram. The solution tracks conversion rates by closer, identifies top-performing programs, and analyzes trends to optimize sales strategy.

Key Skills:

Interactive Dashboard Sales Analysis Visualization

Market Research

Competitive Analysis | TikTok Shop Launch

A scraping and analysis mission of a competitor's products (Lancôme) for a client launching their TikTok shop. I provided a detailed report with top-rated products and strategic proposals for their market entry.

Key Skills:

Web Scraping Data Analysis Reporting

Open Source

GitHub Portfolio | Data Projects

A collection of data analysis projects, Jupyter notebooks, and research prototypes showcasing my expertise in Python, data visualization, and machine learning applications.

Key Repositories:

Jupyter Notebooks Python Research

Process Automation

Document Signature & Notification Workflow

Automated the entire document signature process by integrating Notion, DocuSign, and WhatsApp. When a contract status changes to "Ready for Signature" in Notion, the system automatically generates and sends DocuSign envelopes, then notifies stakeholders via WhatsApp.

Key Skills:

n8n Workflows API Integration Process Automation

AI & Machine Learning

RAG AI Chatbot with Automated Knowledge Base

Built a sophisticated two-part RAG (Retrieval-Augmented Generation) system that automatically syncs documents from Google Drive, processes them into vector embeddings, and creates an intelligent chatbot that answers questions based on the specific knowledge base.

Key Skills:

RAG Architecture Vector Databases AI Integration

Sales Automation

AI-Powered Lead Processing & Routing

Created an intelligent lead processing system that captures leads from Tally forms, uses AI to analyze and categorize them, then automatically routes high-priority leads to the sales team via Slack while logging all leads in Notion CRM.

Key Skills:

Lead Scoring CRM Integration Conditional Logic

AI Education Platform

Tiny-LLM Learning - Personalized AI Tutor

A web-based personalized learning platform that helps students study, track progress, and interact with an AI-powered tutor. Features a central dashboard as the student's "home base" for all learning activities, powered by a custom fine-tuned tiny-Language Model.

Key Skills:

AI/ML Integration Web Development Educational Technology