Skip to content
View RajayJain's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report RajayJain

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.

Content in all repositories owned by your account will be closed.
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
RajayJain/README.md

Hi folks, I'm Rajay Ajay Jain! 👋 ✨


Data Analytics

Typing SVG


🔗 About Me


I am a passionate & aspiring Data Analyst from Goa, India, dedicated to optimizing queries and finding the stories & why hidden within numbers. I transform raw data into clear, actionable business strategies using analytical tools.

  • 🎓 B.Tech in Electrical Engineering
  • 📊 Passionate about Data Analytics & Business Intelligence
  • 💼 Experienced in Power BI Dashboard Development
  • 🌱 Currently strengthening skills in SQL, Python & Data Engineering
  • 📈 Love transforming raw data into actionable insights
  • 🎯 Targeting Data Analyst roles at top companies
  • ⚡ Fun Fact: I enjoy turning complex datasets into simple business stories

🛠️ Tech Stack & Toolkit

Python SQL Pandas Power Query DAX Power BI Excel GitHub


📂 Featured Data Projects

Here is a look at what I've been building across my repositories:


🏦 LendScope — Bank Loan & Card Portfolio Analytics (FY2026)

🔗 View It Here 🔎

  • Built an interactive Streamlit dashboard for loan & card portfolio analytics with an XGBoost default scorer.
  • Analyzes borrower behavior, repayment performance, risk distribution, and revenue impact.
  • Combines Python, SQL, and machine learning to surface high-risk segments and portfolio-level insights.
  • Designed for business users to explore loan performance and default risk interactively.

📉 Credit Risk and Portfolio Analysis

🔗 View It Here 🔎

  • Analyzes a bank’s loan portfolio to understand borrower behavior, repayment performance, risk distribution, and revenue impact.
  • Uses Python for data processing and visualization to identify high-risk segments.
  • Highlights patterns in loan defaults, repayment delays, and customer risk profiles.
  • Supports data-driven credit risk monitoring and portfolio decision-making.

📦 Vendor Performance & Inventory Analysis

🔗 View It Here 🔎

  • Focuses on analyzing vendor performance, inventory lifecycles, and sales profitability.
  • Establishes a robust ETL pipeline to ingest raw inventory and purchase data into a relational database.
  • Identifies underperforming vendors, slow-moving inventory, and margin improvement opportunities.
  • Delivers actionable insights for procurement and inventory optimization.

🚚 Supply Chain Performance Intelligence

🔗 View It Here 🔎

  • Analyzes why shipments miss scheduled timelines and where operational improvements have the greatest commercial impact.
  • Transforms operational data into performance intelligence using Python and SQL.
  • Tracks delivery delays, carrier performance, and bottleneck patterns across the supply chain.
  • Helps prioritize fixes that improve service levels and reduce operational cost.

🛒 Blinkit Sales Analysis

🔗 View It Here 🔎

  • Analyzed 8,523 retail transactions generating $1.20M+ in total sales across multiple outlet types and product categories.
  • Built an executive Power BI dashboard featuring 15+ KPIs, including Total Sales, Average Sales, Outlet Performance, Customer Ratings, and Inventory Distribution.
  • Developed advanced DAX measures and interactive visualizations to identify top-performing product categories and revenue-driving outlets.
  • Delivered actionable business insights that improved visibility into sales trends, outlet efficiency, and customer purchasing behavior.

📈 Global Salary Market Analysis

🔗 View It Here 🔎

  • Designed and developed multiple end-to-end Power BI solutions covering data extraction, transformation, modeling, and business reporting.
  • Created 15+ DAX measures and KPIs to track revenue, profitability, customer performance, and operational efficiency.
  • Implemented star-schema data models and optimized report performance using Power Query and advanced DAX techniques.
  • Built interactive dashboards with drill-through functionality and dynamic filtering, enabling data-driven decision-making for stakeholders.

🏪 Predictive Sales Data Intelligence

🔗 View It Here 🔎

  • Analyzed 1,000+ customer transactions across multiple Walmart branches to evaluate revenue performance and consumer purchasing behavior.
  • Performed exploratory data analysis using SQL and Power BI to uncover sales trends, customer preferences, and product demand patterns.
  • Identified peak sales periods, top-performing product lines, and branch-level performance opportunities through data-driven insights.
  • Developed an interactive business dashboard with 10+ key performance metrics supporting strategic planning and operational monitoring.

📊 Excel Salary Dashboard

🔗 View It Here 🔎

  • Analyzed survey data from 630+ data professionals across various countries, experience levels, and job roles.
  • Built a fully interactive Excel dashboard using Pivot Tables, Power Query, Slicers, and Dynamic Charts to visualize compensation trends.
  • Automated data preparation and transformation workflows, reducing manual analysis effort by approximately 80%.
  • Generated insights into salary benchmarks, high-paying skills, and regional compensation differences within the data analytics industry.

📝 Market Intelligence Architecture

🔗 View It Here 🔎

  • Peak Remote Salary Identified: $650,000 (Top-tier remote Data Analyst roles).
  • High-Compensation Salary Floor: $184,000 minimum threshold for the top 10 highest-paying roles.
  • Top-Paying Skill Premium: Up to $208,172 average yearly salary for specialized data pipeline skills (PySpark).
  • Core Skill Market Baseline: Highly demanded programming skills (Python, R) maintain an average baseline salary of ~$101,000.

📌 Other Notable Projects


📜 Certifications

🏅 Microsoft Power BI Data Analyst
🏅 SQL for Data Analytics
🏅 Data Analytics Professional Certificates
🏅 Python for Data Analysis


📊 Skill Distribution & Ecosystem


🌐 Let's Connect!

Feel free to reach out if you want to collaborate on a data project, discuss query optimization, or talk about market insights!


💡 Quote of the Day

Quote of the Day


Pinned Loading

  1. Excel_Salary_Dashboard Excel_Salary_Dashboard Public

    This data jobs salary dashboard was created to help job seekers investigate salaries for their desired jobs and ensure they are being adequately compensated.

    1

  2. Predictive-Sales-Data-Intelligence Predictive-Sales-Data-Intelligence Public

    This project is an end-to-end data analysis solution designed to extract critical business insights from Walmart sales data. I utilized Python for data processing and analysis, SQL for advanced que…

    Jupyter Notebook 1

  3. Netflix Netflix Public

    Netflix SQL Business Analysis is a data analytics project that explores 8,807 Netflix titles using PostgreSQL. It solves 15 business questions covering movies vs TV shows, ratings, genres, countrie…

    2

  4. Credit-Risk-and-Portfolio-Analysis Credit-Risk-and-Portfolio-Analysis Public

    This project analyzes the bank’s loan portfolio to understand borrower behavior, repayment performance, risk distribution, and revenue impact. The bank receives loan applications from a diverse cus…

    Jupyter Notebook 1

  5. End-to-End-Logistics-Analytics-Samsung-Data-Model End-to-End-Logistics-Analytics-Samsung-Data-Model Public

    "A robust Star Schema BI solution that uses advanced DAX to transform raw data into actionable insights, tracking the complete product lifecycle from supplier lead times and inventory to platform-s…

    1

  6. Vendor-Performance-Inventory-Analysis- Vendor-Performance-Inventory-Analysis- Public

    This project focuses on analyzing vendor performance, inventory lifecycles, and sales profitability. By establishing a robust ETL pipeline, raw inventory and purchase data is ingested into a relati…

    Jupyter Notebook 1