Skip to content

stu99a/stu99a

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

35 Commits
 
 

Repository files navigation

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

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors