.jpg)
I translate complex multi-stream operational data into clear, high-impact business insights.
Specializing in operations management, custom SQL analytics architecture, and data engineering dashboards designed for decision-makers.
Transitioning into data analytics allows me to merge this operational instinct with technical precision. Rather than looking at numbers in a vacuum, I approach data parsing through the lens of a seasoned manager who knows how performance directly impacts the bottom line. This integration ensures that every repository built or metric tracked addresses a real-world enterprise challenge.
On the technical layer, I specialize in architecting structured SQL queries to isolate and normalize disparate backend operational data streams. I then transform those data layers into clear, clean Tableau dashboards tailored specifically for senior leadership. This translates granular technical logs into intuitive visual landscapes that support fast executive actions.
Skills
- SQL
- Tableau
- Excel
- Data Storytelling
- Data Visualization
- Data Analysis
- Leadership & Team Development
- Operations Management
- Business Intelligence
- Business Development
- Product Data Management
- Cross-Functional Collaboration
Telecom Customer Churn Insights
retention optimization Tools Used:Built a business dashboard that uncovers exactly why and when customers are canceling their subscriptions. By tracking customer risk patterns and account lifecycles, this tool gave leadership a much deeper insight into where subscribership was failing. Allowing leadership to make clear and concise decisions on exactly where to focus their retention efforts to keep subscribers happy.
View Live Dashboard
Sweet Toothache March Cupcake Sales
sales & revenue optimization Tools Used:Created a sales dashboard designed specifically to help a small business owner run things more efficiently, by exposing their strongest and weakest selling products. This single-view dashboard instantly tracks daily sales trends, highlights bestseller flavors by location, and breaks down the exact profit made per flavor. Giving the owner clear data to know exactly which new flavors are driving revenue and where to focus to grow the brand.
View Live Dashboard.png)
SQL Case Study : Data Extraction
Scenario: The objective is to extract and analyze all data that defines and determines the top-selling products, comprehend how well each product category is performing in terms of sales, calculate revenue generation, and customer order volumes.
SELECT
p.product_id,
p.product_name,
COUNT(o.order_id) AS total_orders
FROM products p
LEFT JOIN orders o ON p.product_id = o.product_id
GROUP BY p.product_id, p.product_name;
SELECT
p.product_category,
SUM(o.quantity) AS total_quantity_sold
FROM products p
LEFT JOIN orders o ON p.product_id = o.product_id
GROUP BY p.product_category;
SELECT
p.product_id,
p.product_name,
SUM(o.quantity * p.product_price) AS total_revenue
FROM products p
JOIN orders o ON p.product_id = o.product_id
GROUP BY p.product_id, p.product_name
ORDER BY total_revenue DESC
LIMIT 1;
SELECT DISTINCT
o.customer_id
FROM orders o
JOIN products p ON o.product_id = p.product_id
WHERE p.product_name = 'Product A';
Advanced SQL Analytics
Scenario: The objective is to extract and analyze all data that defines and determines product performance, comprehend how well each category is performing in terms of inventory and sales, and calculate revenue streams and total volume, for granular business intelligence insights.
SELECT
p.category,
SUM(o.quantity) AS total_quantity,
SUM(o.quantity * p.price) AS total_revenue
FROM
orders o
INNER JOIN
products p ON o.product_id = p.product_id
GROUP BY
p.category
ORDER BY
total_revenue DESC;
WITH RankedProducts AS (
SELECT
p.category,
p.product_name,
SUM(o.quantity) AS total_quantity_sold,
DENSE_RANK() OVER (
PARTITION BY p.category
ORDER BY SUM(o.quantity) DESC
) AS ranking
FROM
products p
INNER JOIN
orders o ON p.product_id = p.product_id
GROUP BY
p.category,
p.product_name
)
SELECT
category,
product_name,
total_quantity_sold
FROM
RankedProducts
WHERE
ranking = 1;
WITH RankedSales AS (
SELECT
product_id,
revenue,
ROW_NUMBER() OVER (
PARTITION BY product_id
ORDER BY sale_date DESC, sale_id DESC
) AS rn
FROM
sales
)
SELECT
p.product_id,
p.product_name,
ROUND(AVG(rs.revenue), 2) AS avg_recent_revenue
FROM
RankedSales rs
JOIN
products p ON rs.product_id = p.product_id
WHERE
rs.rn <= 3
GROUP BY
p.product_id,
p.product_name;
SELECT
e.department_id,
d.department_name,
e.employee_name,
e.salary,
SUM(e.salary) OVER (
PARTITION BY e.department_id
ORDER BY e.employee_name
) AS running_salary_total
FROM
employees e
JOIN
departments d ON e.department_id = d.department_id
ORDER BY
e.department_id,
e.employee_name;
Project Overview: Omni Geo-Link Engine
Built a QR code system that routes users based on location before the page loads — gave marketing parallel testing instead of sequential. By automatically adjusting where a customer lands based on their physical location, this utility allows businesses to run multiple marketing strategies simultaneously. It takes the guesswork out of localized campaigns, turning a simple smartphone scan into a seamless, fast, and completely customized experience.
Core Features & Architecture
- Geo-Fencing & Routing: Built a smart location engine that automatically senses a user's physical area the millisecond they scan, instantly sending them to customized local promotions.
- Dynamic QR Generation: Overhauled the visual interface to generate sharp, branded QR codes on the fly, complete with a center brand logo and built-in error protection.
- SQL Database Extraction: Engineered a clean backend data layer using structured SQL queries to instantly track daily traffic volumes, user scan counts, and high-performing regions.
- Instant Cloud Deployment: Automated a live launch pipeline syncing my code updates directly from GitHub straight to a live cloud server on Railway, keeping data seamlessly connected.
The Impact
"Shifted from static link routing to a dynamic, geo-intelligent perimeter, allowing for location-exclusive data access and advanced campaign tracking."
Bachelor of Applied Sciences in Electronic Engineering
Bachelor of Arts in Audio Engineering
With close to two decades of professional experience, my career is built on a foundation of operational leadership and management within complex technical spaces. I possess a deep understanding of organizational frameworks, cross-functional team direction, and the metrics that drive successful execution. This administrative background enables me to evaluate corporate structures with an innate understanding of workflow inefficiencies.
Ultimately, my mission is to deliver comprehensive business intelligence by bridging the gap between data engineering and operational strategy. I ensure that complex workflows are not only audited correctly but also visualized meaningfully for stakeholder review. Let's connect to discuss how optimized data models can drive your operational goals forward.