Skip to content
View stu99a's full-sized avatar
1 follower · 1 following
  • 18:34 (UTC -12:00)

Block or report stu99a

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
stu99a/README.md

Josiah Mathew

Data Analyst | Data Engineer | Python | SQL | Power BI | CBRNe Professional

About

Data Analyst and Data Engineer with experience in:

  • Python
  • SQL
  • Power BI
  • Data Cleaning & Transformation
  • Data Visualization
  • Business Intelligence

I also have professional experience in the security and intelligence sector, specializing in CBRNe.

Featured Projects

Security Intelligence Analytics

  • Global Terrorism Intelligence Analytics End-to-end intelligence analytics project analyzing over 200,000 terrorism incidents using Python, SQL, SQLite, and Power BI. Identified attack patterns, regional hotspots, organizational activity, and historical trends through geospatial analysis and interactive dashboards.

Business Analytics

  • Superstore Business Analytics Case Study End-to-end business analytics project using Python, Power BI, and exploratory data analysis to identify sales, profit, and customer trends.
  • JPMorgan Chase Quantitative Research Quantitative research project using Python, machine learning, and statistical modeling to forecast commodity prices, value storage contracts, estimate credit default risk, and develop FICO-based risk rating systems.
  • E-Commerce Database Management System Designed and developed a relational e-commerce database using SQL and SQLite. Built interconnected tables for customers, products, orders, deliveries, employees, and feedback while enforcing data integrity through primary and foreign key relationships

Data Engineering

Web Scraping Pipeline

  • Books to Scrape ETL Pipeline End-to-end ETL and analytics pipeline that scrapes book data, performs data cleaning and exploratory analysis, stores data in SQLite, and answers business questions using SQL.

Technical Skills

Languages

  • Python
  • SQL

Analytics

  • Pandas
  • NumPy
  • Excel

Visualization

  • Power BI
  • Google Looker
  • Tableau
  • Plotly

Databases

  • PostgreSQL
  • SQLite
  • Mongo DB

Tools

  • Git
  • GitHub
  • Jupyter Notebook
  • Visual Studio Code (VS Code)
  • IBM SPSS Statistics
  • IBM Cognos Analytics

Current Focus

  • Data Analytics
  • Data Engineering
  • Nuclear Security Applications of Data Science

Contact

Pinned Loading

  1. stu99a stu99a Public

  2. global-terrorism-intelligence-analytics global-terrorism-intelligence-analytics Public

    End-to-end intelligence analytics project analyzing 200K+ terrorism incidents using Python, SQL, SQLite, and Power BI.

    Jupyter Notebook

  3. clinicaltrials-data-engineering clinicaltrials-data-engineering Public

    Python data engineering pipeline for extracting, transforming, and storing Neurofibromatosis clinical trial data from the ClinicalTrials.gov API.

    Python

  4. books-to-scrape-etl-analytics books-to-scrape-etl-analytics Public

    End-to-end ETL and analytics pipeline that scrapes book data, performs data cleaning and exploratory analysis, stores data in SQLite, and answers business questions using SQL.

    Jupyter Notebook

  5. superstore-business-analytics-case-study superstore-business-analytics-case-study Public

    End-to-end business analytics project using Python, SQL, and Power BI.

    Jupyter Notebook

  6. jpmorgan-quantitative-research-forage- jpmorgan-quantitative-research-forage- Public

    Quantitative finance projects including natural gas price forecasting, storage contract valuation, probability of default modeling, and credit risk rating systems.

    Jupyter Notebook