Data Pipeline
A data pipeline is a series of automated processes that move and transform data from one system to another, typically for analysis or reporting. It begins with data ingestion, where raw data is collected from sources like websites, APIs, databases, or files. Next, the data undergoes transformation, which includes cleaning, filtering, reformatting, or enriching it to ensure consistency and usability. Finally, the processed data is loaded into a destination system, such as a data warehouse, database, or visualization tool like Tableau or Power BI.
Scheduled Web Scraping
Each week, an automated Python bot scrapes the list of all active locations from WestsidePizza.com. It then retrieves the corresponding online ordering websites for each store, enabling consistent and up to date data collection.
Deal and Menu Data Extraction
From the ordering websites, the bot collects all available deal names, descriptions, and prices. It also scrapes base menu prices for standard pizzeria products to support deeper pricing analysis.
AI-Powered Deal Breakdown
Using AI logic, the system analyzes deal descriptions to identify and classify which products are included in each deal. This step adds structure to otherwise unstandardized data, making it easier to compare and quantify value.
Scalable Architecture
The scraping process is designed with scalability in mind. Its flexible structure allows new pizza brands to be added to the pipeline with minimal changes, enabling fast expansion across competitors in the industry.
Data Cleaning and Filtering in SQL
Once raw data is collected, it is processed through SQL queries to clean, filter, and organize it into structured tables. This ensures accuracy and prepares the data for meaningful analysis.
Visualization in Tableau
The final cleaned dataset is loaded into Tableau, where it powers dynamic dashboards and reports. These visualizations provide insights into pricing strategies, promotional trends, and value comparisons across locations and deals.
View the Report
To be added later.
Detailed Labor Forecasting
Income / Expense Comparisons
Income / Expense Comparisons
This labor forecasting tool analyzes hourly data and seasonal sales trends to calculate staffing needs in 15-minute increments for each department. It accounts for minimum staffing levels, historical seasonal trends and outputs ready-to-use schedules, streamlining the labor planning process with precision and efficiency.
Income / Expense Comparisons
Income / Expense Comparisons
Income / Expense Comparisons
Cost comparison reports track KPIs across locations or departments, helping businesses identify trends, control costs, and improve overall profitability.
Food Cost Management
Income / Expense Comparisons
My food waste tracker monitors vendor orders and actual usage to highlight waste from overuse, theft, or negligence by comparing usage to ideal amounts based on product recipes.
Employee Performance Metrics
Tracks and compares KPIs across all store orders, whether an employee is present or not. It calculates each employee’s profitability by analyzing how much revenue they help generate versus how much they cost in labor. This enables clear, data-backed comparisons of individual performance and contribution to the company’s bottom line.
Discounting and Marketing Reports
Discounting and Marketing Reports
This report analyzes all discount and marketing efforts by calculating how much sales each code generates versus its cost. It also reviews discount activity by employees and customers to detect possible theft, overuse, or operational errors, helping maintain margin integrity.
Restaurant Location Analysis
Discounting and Marketing Reports
My location analysis report helps forecast sales for new business locations by evaluating demographic and market factors such as population, area type, and competitor density. It’s designed to minimize risk by identifying high-potential sites while continuously improving its prediction accuracy and precision through performance tracking and data expansion.
Task Automation with Python
What is Python?
Python is a powerful, high-level programming language designed for efficiency, scalability, and versatility. Widely adopted in data science, automation, and AI, Python enables rapid development of complex solutions with clean, maintainable code. Its extensive library ecosystem and strong integration capabilities make it an ideal choice for building advanced, data-driven applications and streamlining business workflows.
Boosts Operational Efficiency
Python automation streamlines repetitive tasks like data entry, report generation, and file management, reducing manual workload and saving valuable time. This allows teams to focus on strategic initiatives while ensuring faster turnaround on daily operations.
Web Scraping for Real-Time Market Insights
Python’s powerful libraries such as BeautifulSoup, AutoHotKey, and Selenium enable businesses to gather real-time data from competitors, industry sources, and online marketplaces. This gives companies a competitive edge by tracking pricing, customer sentiment, and trends automatically.
Builds Robust Data Pipelines
With tools like pandas, SQLAlchemy, and Airflow, Python can automate the entire data pipeline, from ingestion and transformation to storage and visualization. This ensures that decision makers always have access to clean, timely, and relevant data to guide business strategies.
Improves Decision-Making with Actionable Data
Automated data processing in Python turns raw inputs into structured insights through dashboards, alerts, and reports. This empowers leaders to make informed decisions quickly, based on up-to-date and accurate business intelligence.
Reduces Costs and Human Error
By minimizing the need for manual labor and reducing the risk of errors, Python automation helps lower operational costs. Automated processes follow consistent logic, which improves accuracy and eliminates costly mistakes caused by human oversight.
SortMate
A Smarter Way to Sort Your Scanned Documents
SortMate is a desktop application designed to automatically organize scanned documents using Optical Character Recognition (OCR) and custom keyword-based filters. It reads the text content of PDFs and image files, identifies key terms, and intelligently sorts each file into pre-configured folders. Whether it's utility bills, bank statements, business receipts, or personal records, SortMate streamlines document management by removing the need for manual sorting. It’s a time-saving solution for students, professionals, and anyone looking to maintain a clean digital archive.
Designed to Solve a Real Problem
I created SortMate to solve a recurring time management problem. I digitally archive all of my incoming mail, but I was spending 45 to 60 minutes each week manually organizing PDFs into folders. That time quickly added up. So I built a tool that could learn to recognize common document types and file them for me, based on simple user-defined rules. The result is a practical, user-friendly application that transforms a repetitive task into a one-click process.
How It Works: From OCR to Folder
The app uses Tesseract OCR to extract text from scanned PDFs or images. Users begin by installing Tesseract and selecting a source folder containing their documents. From there, they set up custom folder categories and assign keywords to each—words or phrases commonly found in certain types of documents (like "Invoice," "IRS," or "Business Name"). When a document contains a matching keyword, SortMate automatically moves it into the corresponding folder. Filters can be nested as well, allowing for subfolders based on more specific item-level keywords.
Built with Simplicity and Flexibility
SortMate features a clean, intuitive GUI built with Tkinter and custom assets. The procedural design makes it easy to navigate—new users can get started in minutes. Each setup step is clearly labeled: install OCR, select a source folder, configure sorting destinations, and fine-tune item filters. The app supports PDF scans and common image file types, and it can detect text regardless of document orientation. Keywords are not case-sensitive, making the filtering process more forgiving and flexible.
Versatile Use Cases
This tool isn’t just for personal use—it can benefit small business owners, freelancers, students managing coursework, and even creatives organizing contracts or invoices. SortMate’s adaptable rule system makes it easy to tailor for any workflow. Once configured, it quietly takes care of your document organization in the background, freeing up time and mental energy for more meaningful work
GitHub Link
Download
To be added later.
Interactive SMS
Interactive SMS is a two-way texting system where users can reply with predefined commands to receive instant responses, trigger scripts, or enable dynamic marketing interactions.
Try it yourself! Send a message to (253) 215-8111
send ADVENTURE1 to try the interactive space adventure
send MARKETING1 to see an example of SMS marketing