Skip to content
View AjayTiwari94's full-sized avatar
🎯
Focusing
🎯
Focusing
7 followers · 9 following

Achievements

Achievement: Pull SharkAchievement: QuickdrawAchievement: YOLO

Achievements

Achievement: Pull SharkAchievement: QuickdrawAchievement: YOLO

Highlights

  • Pro

Block or report AjayTiwari94

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

Hello World, I'm Ajay Tiwari

Data Analyst | Business Analyst | SQL | Power BI | Python

B.Tech- Computer Science and Engineering (Artificial Interlligence)- Noida Institute of Engineering & Technology | Batch 2022–26

  • Currently seeking Data Analyst / Business Analyst opportunities

Quick Links

Data & Business Analytics Projects

Banking Transaction & Customer Risk Analysis *

  • Analyzed 55K+ transactions to understand customer behavior and support business decisions
  • Identified that 18% of customers contributed 62% of total transaction value
  • Found that fraud was concentrated in TRANSFER and CASH_OUT transactions, with TRANSFER having the highest fraud rate (0.94%)
  • Observed that high-value transactions had higher fraud probability (0.20%) than low-value (0.17%)
  • Built a Power BI dashboard to analyze transaction trends and fraud patterns

Layoff Trends & Workforce Analysis

  • Analyzed 2,500+ records to identify workforce trends and business insights
  • Cleaned 500+ duplicates and resolved 8+ inconsistencies
  • Used SQL queries (CTEs, Joins, Window Functions) to uncover multiple trends

Data Analysis (SQL / Excel / Tableau)

  • Wrote complex SQL queries using Joins, CTEs, and Window Functions
  • Performed data cleaning, transformation, and reporting in Excel
  • Built dashboards in Tableau for trend analysis and decision-making

AI & Machine Learning (Additional Projects)

Multi-AI Agent Medical Diagnostic System

AI Medical Imaging Diagnosis System

Tech Stack

Data Analytics
SQL | Excel | Power BI | Tableau
Python (Pandas, NumPy, Matplotlib, Seaborn)

Business Analysis
KPI Analysis | Trend Analysis | Customer Segmentation

AI / ML
Scikit-learn | TensorFlow | OpenCV | Hugging Face

GitHub Stats

What’s Next?

  • Building more real-world business analytics projects
  • Strengthening SQL and dashboarding skills
  • Exploring data-driven decision-making use cases
  • Open to Data Analyst / Business Analyst roles

Contact

Email: tiwariajay110125@gmail.com

✨ "Code with purpose, analyze with curiosity, build with impact."

Pinned Loading

  1. Banking-Customer-Risk-Transaction-Analysis Banking-Customer-Risk-Transaction-Analysis Public

    Analyzed over 55K banking transactions using MySQL to uncover fraud patterns, highlighting high-risk transaction types and value-based fraud insights using Power BI.

    Jupyter Notebook

  2. Customer_Churn_Analysis-Spotify Customer_Churn_Analysis-Spotify Public

    SQL-based analysis of Spotify user behavior to identify churn patterns, build a rule-based risk segmentation model, and design targeted retention strategies.

  3. Layoff_Trend_And_Workforce_Analysis Layoff_Trend_And_Workforce_Analysis Public

    This repository contains a complete end-to-end data cleaning workflow performed using MySQL on a real-world dataset. It demonstrates how to identify inconsistencies, remove duplicate records, handl…

    1

  4. Power-BI_Dashboards Power-BI_Dashboards Public

    Collection of interactive Power BI dashboards analyzing real-world datasets to uncover trends, insights, and data-driven decision patterns.

  5. Data_Analysis-Excel Data_Analysis-Excel Public

    This repository showcases a complete data analysis project performed entirely in Microsoft Excel, covering everything from raw data cleaning to actionable insights. It demonstrates how powerful Exc…

    1

  6. Data_Analysis-Tableau Data_Analysis-Tableau Public

    Tableau-based data analysis project using 30M+ Airbnb records joined from Listings, Calendar, and Reviews files to build interactive dashboards and visual insights.