Skip to content
View ampojohnfranz's full-sized avatar
0 followers · 2 following

Highlights

  • Pro

Block or report ampojohnfranz

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ampojohnfranz/README.md

Hi, I'm John Franz Aranas Ampo

Technical Data Analyst & Electronics Engineering Student specializing in bridging hardware logic, data pipelines, and interactive business intelligence.

Featured Project

Live E-Commerce Analytics Dashboard

  • What it does: Analyzed 96,478 e-commerce orders using SQL and Python (Pandas/Plotly) to uncover revenue drivers and delivery performance gaps, then deployed a live interactive Streamlit application for business user discovery.
  • Tech Stack: Python, SQL, Streamlit, Plotly, Pandas.

Technical Toolkit

  • Languages & Frameworks: Python (Pandas, Streamlit, FastAPI), SQL (Google BigQuery, PostgreSQL)
  • Tools & Analytics: Power BI, Microsoft Excel, Git/GitHub, Docker
  • Core Domains: Data Analysis, IoT Telemetry, Data Annotation & Quality Control (2D/3D LiDAR)

Core Portfolio Repositories

  1. ecommerce-sql-python-analysis: The data cleaning and foundational analysis behind the live Streamlit dashboard.
  2. qsr-operations-and-fraud-detection: Power BI dashboard and Python script analyzing franchise operations and POS fraud detection.
  3. asos-inventory-optimization: Business-focused retail inventory analysis.

Contact & Availability

  • Location: Cagayan de Oro City, Philippines
  • Role Focus: Part-time / Freelance / Data Gigs (Available 40 hours/week)
  • Education: BS Electronics Engineering, USTP (Expected Graduation: June 2027)

Popular repositories Loading

  1. ecommerce-data-pipeline ecommerce-data-pipeline Public

    FastAPI REST server and ETL pipeline transforming raw e-commerce order payloads into a relational database for live Power BI analytics.

    Python 1

  2. ecommerce-inventory-pipeline ecommerce-inventory-pipeline Public

    Automated ETL data pipeline integrating live supplier REST APIs with SQLite and Power BI for real-time inventory monitoring.

    Python 1

  3. ecommerce-omnichannel-integrator ecommerce-omnichannel-integrator Public

    Automated enterprise ELT pipeline integrating dual REST APIs into a containerized PostgreSQL data warehouse for live omnichannel profit analytics.

    Python 1

  4. asos-inventory-optimization asos-inventory-optimization Public

    Python-based supply chain analysis calculating $600k+ in 'phantom revenue' from ASOS inventory stockouts.

    Jupyter Notebook 1

  5. qsr-operations-and-fraud-detection qsr-operations-and-fraud-detection Public

    End-to-end Power BI dashboard and Python anomaly detection pipeline tracking QSR operations and POS fraud.

    Python 1

  6. ecommerce-sql-python-analysis ecommerce-sql-python-analysis Public

    Portfolio project analyzing e-commerce revenue and delivery performance using SQL and Python on the Olist dataset.

    Python 1