Hi there! I'm

Mohit Shyam Amode

Data Analyst

SQL · Power BI · Tableau · Python · Dashboards

I turn messy, high-volume data into clear, decision-ready dashboards. From Power BI and Tableau to Grafana and PromQL, I build reporting workflows that replace guesswork with analytics — across nonprofits, government, AR/VR, and higher education.

View My Work Get in Touch
Mohit Shyam Amode
250K+ Records Engineered into ML-Ready Datasets
30% Enrollment Growth Driven by SQL Analysis
30+ Stakeholders Served by Live Dashboards

About Me

I'm a Data Analyst with a Master of Science in Data Science from Seattle University. I specialize in dashboard development, SQL and NoSQL data modeling, query optimization, and translating operational requirements into actionable insights.

My work spans the full analytics lifecycle — cleaning and validating raw records, writing SQL, and shipping dashboards in Power BI, Tableau, and Looker Studio. At Seattle University I cut program-report lookup from 15 minutes to instant KPI visibility and used SQL analysis to grow study-abroad enrollment 30% (200 → 280). I've also built Power BI dashboards used by 30+ stakeholders and supported a $120K annual Google Ad Grant.

Dashboard Development

Power BI, Tableau, Looker Studio, Grafana, R Shiny & Streamlit dashboards for KPI and BI reporting.

Statistical Analysis

EDA, hypothesis testing, time-series and trend analysis — turning raw data into clear, defensible decisions.

KPI & Reporting

Operational KPI dashboards and reporting workflows — cut report lookup from 15 minutes to instant for staff.

SQL & Data Modeling

SQL & NoSQL modeling, aggregation pipelines, query optimization, and JSON/CSV reporting workflows.

Data Cleaning & Validation

Standardizing, validating and transforming large record sets for consistent, reliable, audit-ready reporting.

ML & Modeling

Random Forest, GAM & Balanced RF, plus RAG, vector search and OpenAI embeddings with LangChain.

Work Experience

Data Analysis & Research Intern

EcoServants Project · Remote, USA

September 2025 – Current

  • Analyzed website engagement and outreach datasets using Google Analytics, SQL, JSON, and CSV reporting workflows, supporting data-driven decisions tied to a $120,000 annual Google Ad Grant.
  • Organized outreach and field-submission datasets with Python, SQL, and NoSQL-style workflows, improving data accessibility and reporting efficiency for donor, volunteer, and nonprofit initiatives.
  • Standardized and validated 300+ plant taxonomy records and mapped 100+ geotagged submissions, improving structured-data consistency and regional reporting.
Google AnalyticsSQLPythonJSONData Validation

Data Analyst (Contract)

Qualitest — Client: Meta · Seattle, WA

April 2026 – May 2026

  • Evaluated and validated 2,000+ AR/VR recordings against structured CSV quality parameters, ensuring near-100% compliance accuracy for AI and ML workflows.
  • Performed QA and failure analysis on multi-modal data-collection workflows, identifying annotation inconsistencies that reduced rework for engineering teams by 25%.
  • Conducted structured data validation for autonomous bot-training pipelines, improving workflow precision and supporting scalable ML model development.
AR/VR DataQACSVML WorkflowsFailure Analysis

Data Analyst (Capstone)

Washington Department of Fish & Wildlife · Seattle, WA

January 2025 – June 2025

  • Built a Power BI analytics dashboard used by 30+ stakeholders to visualize biological trends and environmental metrics, enabling data-driven fishing permissions.
  • Automated and merged 250K+ biological and sensor records into ML-ready JSON and CSV datasets, reducing data-entry errors and supporting legal-size crab catch decisions.
  • Built Random Forest, GAM, and Balanced RF models achieving 92% accuracy and a 0.78 F1 score, improving regional fisheries visibility.
Power BIRandom ForestGAMPythonFeature Engineering

Data Analyst Intern

Education Abroad Office, Seattle University · Seattle, WA

June 2024 – June 2025

  • Built MS Access databases and Tableau dashboards from structured JSON and CSV datasets, cutting program-report lookup time from 15 minutes to instant KPI visibility for 5 staff.
  • Identified 6 high-demand study-abroad programs through SQL analysis, increasing summer enrollment 30% (200 → 280 students) and improving cross-department reporting.
TableauMS AccessSQLKPI Reporting

Featured Projects

13 projects pulled straight from github.com/mohitamode — each card links to the real repo

Star schema

Data Analytics · GitHub

Sales Insights · Tableau + SQL

SQL ETL pipeline and star-schema model feeding an interactive Tableau dashboard that surfaces revenue, profit, and top-customer insights for an India-based hardware company.

TableauSQLMySQLBI
View Repo →
2 datasets

Business Intelligence · GitHub

Banking Insights · Power BI

An interactive Power BI dashboard turning banking transaction and customer account data into actionable insight, with a branch efficiency rating system and credit-score risk analysis.

Power BIDAXEDAData Modeling
View Repo →
End-to-end BI

Data Analytics · GitHub

Healthcare Analytics

End-to-end healthcare data analytics: SQL cleaning, Python EDA, and interactive Power BI dashboards surfacing billing trends, doctor performance, and patient insights.

SQLPythonPower BIPandas
View Repo →
5 datasets

Data Analytics · GitHub

SQL for Financial Analysis

A SQL system that turns five financial datasets — general ledger, chart of accounts, territory, calendar, and cash flow — into P&L statements, balance sheets, cash-flow statements, and ratios.

SQLAzure Data StudioFinancial ReportingData Analysis
View Repo →
8-platform SQL

Data Analytics · GitHub

SQL Portfolio

A comprehensive SQL portfolio featuring the 8 Week SQL Challenge case studies, solved problems across 8 coding platforms, and 5 real-world data-analysis projects.

SQLData AnalysisCase StudiesQuery Optimization
View Repo →
Kimball schema

Analytics Engineering · GitHub

Analytics Engineering Prototype

Builds a Kimball-style dimensional model from Northwind OLTP data using dbt and BigQuery for fast, scalable, well-tested reporting.

dbtBigQuerySQLDimensional Modeling
View Repo →
9 agents

RAG / GenAI · GitHub

Multi-Agentic RAG

A Streamlit RAG app where nine specialized LangChain/Groq agents route queries, retrieve from uploaded files or the web, then self-correct, fact-check, and safety-check each answer.

LangChainGroqStreamlitRAG
View Repo →
Live voice

RAG / GenAI · GitHub

Multimodal Live RAG Voice

A multimodal live assistant that answers spoken questions in real time, pairing low-latency voice I/O with retrieval-augmented generation over your own knowledge base.

RAGVoice AIMultimodalReal-time
View Repo →
LLM insights

RAG / GenAI · GitHub

Financial Advisor LLM

An LLM-powered financial advisor that turns natural-language questions into personalized money insights, portfolio guidance, and easy-to-read financial summaries.

LLMPythonFinanceAI Chatbot
View Repo →
Multi-agent

RAG / GenAI · GitHub

Multi-Agent Disease Diagnosis

A multi-agent AI system where specialized conversational agents collaborate to reason through patient symptoms and converge on a likely diagnosis.

Multi-AgentLLMConversational AIHealthcare
View Repo →
5 patterns

Observability · GitHub

Microservices Observability

A Spring Boot microservices demo instrumented for distributed monitoring and tracing — custom Prometheus metrics, Grafana dashboards, and end-to-end Jaeger tracing.

Spring BootPrometheusGrafanaJaeger
View Repo →
Real-time

Streaming · GitHub

Spark + Kafka IoT Pipeline

End-to-end streaming pipeline that ingests IoT sensor data through Kafka and processes it in real time with Spark for live analytics.

KafkaSparkPythonStreaming
View Repo →
Real-time

ML Monitoring · GitHub

Log Anomaly Detection

A Python log-analysis pipeline that parses logs, extracts features, and flags security threats in real time using an Isolation Forest model with live monitoring and visualization.

PythonIsolation ForestAnomaly DetectionLog Analysis
View Repo →

Skills & Tools

Technologies and tools I work with across the analytics stack

Programming
SQLAdvanced
PythonAdvanced
RProficient
JavaScript / C / C++Working
Dashboarding & BI
Power BIAdvanced
TableauAdvanced
Looker StudioProficient
Grafana / R Shiny / StreamlitProficient
Analytics
Data Cleaning & ValidationAdvanced
Statistical & Time-Series AnalysisAdvanced
KPI & BI ReportingAdvanced
Operational AnalyticsAdvanced
Databases & Querying
MySQLAdvanced
MongoDB / NoSQLAdvanced
Query OptimizationAdvanced
Data Modeling & AggregationAdvanced
Data & Cloud Tech
JSON / CSV / Streaming DataAdvanced
GA4 / BigQuery / AWSProficient
Kafka / Prometheus / PromQLProficient
LangChain / Embeddings / GitProficient
Domain & Soft Skills
Stakeholder CommunicationAdvanced
Requirements → Insight TranslationAdvanced
ArcGIS Pro / Geospatial AnalysisProficient
Data StorytellingAdvanced

Education & Certifications

Education

M.S. in Data Science

Seattle University · Seattle, WA

September 2023 – June 2025

B.E. in Electronics & Telecommunication

Honors in Data Science · Pune University

June 2017 – June 2022

Certifications

  • Data Engineering with DatabricksDec 2025
  • Generative AI FundamentalsDec 2025
  • Google AI EssentialsNov 2025
  • The Ultimate MySQL BootcampJul 2025

Leadership

Vice President of Marketing & Communication

Graduate Student Council, Seattle University

June 2024 – June 2025

Led graduate communications, marketing, and governance — growing engagement from 150 to 650 and reaching 1,200+ students. Influenced adoption of AI coursework guidelines via the Board of Trustees Technology Committee and managed a $10K annual budget, raising average event attendance from 30 to 120.

Event Coordinator

Indian Student Association, Seattle University

June 2024 – June 2025

Planned and executed 4 recurring Indian cultural festival events, managing logistics and stakeholder coordination on time and on budget. Grew average attendance from 100 to 500+ per event and engaged a diverse campus community of 3,000+ students through targeted marketing.

Let's Work Together

Looking for a data analyst who ships dashboards that drive decisions? Let's talk.

Email

mohitshyamamode@gmail.com

Phone

(206) 331-5057

LinkedIn

linkedin.com/in/mohitamode

Open to Data Analyst roles

I'm available for full-time and contract data analytics work — dashboard development, reporting workflows, observability, and applied ML. Reach out and I'll get back to you quickly.

Send an Email