Emir's Portfolio

Table of Contents

• Python
• Tableau
• SQL

Python

Project	Description	Link
SQL Data-Staging Tool	Multi-threaded tool for concurrent SQL pulls from different DB types.	link
Log File to PostgreSQL ETL	Python watchdog ETL to pivot log files to PostgreSQL DB.	link
Lens Report Generator	PyQt6 GUI to generate PDF reports with Matplotlib heatmap vizzes.	link

Tableau

Please visit my Tableau profile for a sample of my Tableau vizzes.

Vizzes	Description	Link
Implemented Dashboards	Map View of my implemented dashboards.	link
Process Overview	Daily Adherence to Process Control standards and log view for individual records.	link
Process Discovery	Box Plots and Pass-Fail Bar Charts to identify worst performers.	link
Inspection Discovery	Scatter Plots and Pareto Bar Charts to identify worst performing products and lens types.	link
Inspection Overview	Provides OEE and Quality Performance for plant optical and inspection device performance.	link

SQL

Project	Description	Link
WIP Job Tracker	Multiple joins across 4 tables from Informix database prepped for a left join with a MS SQL server	link
Nested Substing_Index	Create MySQL view parsing semi-structured column using CTE's and Nested SUBSTRING_INDEX Calls.	link