✈ India Aerospace Industry Intelligence System

The Complete Aerospace ERP
Built for India

A full-stack Business Development & Industry Intelligence platform covering Defence, Space, UAV, Avionics, and Aerospace Manufacturing — 58 companies, 10 modules, live analytics.

Live Intelligence Database View on GitHub Explore Modules
58
Companies
10
Modules
13
DB Tables
60+
API Endpoints
7
Industry Segments
System Modules
10 Integrated Intelligence Modules
Every module is backed by Oracle DB tables, .NET 8 REST endpoints, and a fully rendered Bootstrap 5 UI screen.
Module 01
🏢
Company Master
58+ Indian aerospace companies across 7 segments. Revenue, employees, certifications, facilities, GET programmes, careers links.
Grid ViewList ViewFiltersExport CSV
Module 02
👥
Contact Management
Full aerospace industry contact directory. Designation, department, email, LinkedIn, reporting manager, communication history.
CRM LinkedActivity LogSearch
Module 03
📊
Opportunity Tracker
Full BD pipeline — RFQ, Tender, Direct Sale, Partnership. Kanban board with drag-and-drop status. ₹840 Cr pipeline tracked.
Kanban BoardPipeline ValueWin Rate
Module 04
💼
Job & Career Tracker
Personal application status tracking across 47+ open roles. GET programmes, internships, salary ranges, closing dates, interview tracking.
My ApplicationsGET ProgramsReminders
Module 05
🤖
Technology Tracker
AI/ML adoption, Digital Twin, Additive Manufacturing, DO-178C, CAD tools, simulation software — per company intelligence matrix.
Tech RadarAI CompaniesDO-178C
Module 06
📦
Supplier Tracker
Approved vendor database with AS9100D, NADCAP certifications. Full audit workflow — pending, cleared, failed audit status tracking.
Audit WorkflowAS9100DNADCAP
Module 07
🚀
Project Tracker
Active aerospace projects — Tejas Mk1A, Gaganyaan, Vikram-1. Milestone tracking, sector classification, value, status.
MilestonesDefence/Space/UAV₹ Value
Module 08
📁
Document Management
Store brochures, annual reports, certifications, NDAs, drawings, presentations. Version control, expiry tracking, confidentiality flags.
UploadVersioningNDA
Module 09
📈
Research & Analytics
Revenue analysis, hiring trends, drone industry growth (₹300Cr→₹9000Cr), space sector startups, tech adoption radar, company comparison matrix.
Chart.jsRadar ChartComparison
Module 10
📞
CRM & Follow-Up
Call logs, meeting notes, email history, visit reports. Reminder system with 7-day rolling view, activity type filtering, outcome tracking.
RemindersCall LogsTimeline
Technology Stack
Enterprise-Grade Architecture
3-tier architecture — Browser → .NET 8 API → Oracle DB. JWT auth, Dapper ORM, Chart.js 4.4.
🌐
HTML5 + Bootstrap 5.3
Responsive dark aerospace UI, single-page app shell
📊
Chart.js 4.4
Doughnut, bar, line, radar charts — all live data
⚡
.NET 8 Web API
60+ REST endpoints, Swagger UI, Dapper ORM
🗄️
Oracle DB 19c/21c
13 tables, sequences, views, partitioning
🔐
JWT Bearer Auth
HS256, BCrypt passwords, role-based policies
📄
NPOI + iTextSharp
Excel & PDF report generation
🔍
Global Search
Company, tech, cert, contact, project search
📋
Audit Logging
Every INSERT/UPDATE/DELETE logged to AUD_LOG
Company Intelligence
58 Indian Aerospace Companies Tracked
Defence PSUs, space startups, MNC subsidiaries, drone companies, avionics firms, and aerospace software houses — all in one database.
HAL
PSU · Defence
BEL
PSU · Avionics
ISRO
Govt · Space
DRDO
Govt · Defence
Honeywell India
MNC · Avionics
GE Aerospace
MNC · Software
Cyient
Private · Software
Collins Aerospace
MNC · Avionics
Thales India
MNC · Avionics
Rolls-Royce India
MNC · Software
ideaForge
Private · UAV
Garuda Aerospace
Startup · UAV
Skyroot Aerospace
Startup · Space
Agnikul Cosmos
Startup · Space
Pixxel Space
Startup · Space
KPIT
Private · Software
Wipro Aerospace
Private · Software
BDL
PSU · Defence
TASL
Private · Mfg
Astra Microwave
Private · Avionics
+ 38 more in database
Defence / Avionics Space UAV / Drone MNC Aerospace Software
Database Schema
Oracle DB — 13 Tables, 60+ Columns
Normalised schema with sequences, foreign keys, 15 indexes, and 2 materialised views for dashboard KPIs.
MST_COMPANY
  • COMPANY_ID (PK)
  • COMPANY_NAME, TYPE
  • HEADQUARTERS, WEBSITE
  • ANNUAL_REVENUE, EMPLOYEES
  • CERTIFICATIONS, GET_PROGRAM
  • CAREERS_URL, NOTES
CRM_CONTACT
  • CONTACT_ID (PK)
  • COMPANY_ID (FK)
  • CONTACT_NAME, DESIGNATION
  • EMAIL, MOBILE, LINKEDIN
  • CONTACT_STATUS
  • LAST_COMM_DATE
BIZ_OPPORTUNITY
  • OPP_ID (PK)
  • COMPANY_ID, CONTACT_ID (FK)
  • RFQ_NUMBER, TENDER_NUMBER
  • OPP_VALUE, PROBABILITY_PCT
  • STATUS, SUBMISSION_DATE
  • EXPECTED_AWARD_DATE
JOB_POSTING
  • JOB_ID (PK)
  • COMPANY_ID (FK)
  • POSITION_TITLE, DEPT
  • SALARY_MIN, SALARY_MAX
  • STATUS, JOB_TYPE
  • MY_APP_STATUS (personal)
TECH_PROFILE
  • TECH_ID (PK)
  • COMPANY_ID (FK, 1:1)
  • USES_AI, USES_ML
  • USES_DIGITAL_TWIN
  • CAD_TOOLS, SIM_TOOLS
  • CERTIFICATIONS_SW
SUP_SUPPLIER
  • SUPPLIER_ID (PK)
  • PRODUCTS_OFFERED
  • CERTIFICATIONS
  • APPROVAL_STATUS
  • AUDIT_STATUS
  • LAST_AUDIT_DATE
PRJ_PROJECT
  • PROJECT_ID (PK)
  • COMPANY_ID (FK)
  • PROJECT_NAME, SECTOR
  • START_DATE, END_DATE
  • PROJECT_VALUE
  • MILESTONE_1/2/3
DOC_DOCUMENT
  • DOC_ID (PK)
  • COMPANY_ID, OPP_ID (FK)
  • DOC_TYPE, DOC_TITLE
  • FILE_PATH, MIME_TYPE
  • VERSION, EXPIRY_DATE
  • IS_CONFIDENTIAL
CRM_ACTIVITY
  • ACTIVITY_ID (PK)
  • COMPANY_ID, CONTACT_ID (FK)
  • ACTIVITY_TYPE (CALL/MEET)
  • SUBJECT, OUTCOME
  • NEXT_ACTION_DATE
  • REMINDER_DATE
ERP_USERS / ROLES
  • USER_ID, ROLE_ID (PK)
  • USERNAME, EMAIL
  • PASSWORD_HASH (BCrypt)
  • LAST_LOGIN
  • ROLE_NAME, ROLE_DESC
  • IS_ACTIVE
ERP_MODULE_PERMS
  • ROLE_ID + MODULE_CODE
  • CAN_VIEW, CAN_CREATE
  • CAN_EDIT, CAN_DELETE
  • CAN_EXPORT
  • 13 modules × 5 roles
AUD_LOG
  • LOG_ID (PK)
  • TABLE_NAME, RECORD_ID
  • ACTION (INSERT/UPDATE)
  • OLD_VALUES (CLOB JSON)
  • NEW_VALUES (CLOB JSON)
  • CHANGED_BY, IP_ADDRESS
REF_LOOKUP
  • LOOKUP_TYPE, CODE
  • Company types, segments
  • Opportunity statuses
  • Job statuses
  • All dropdown values
  • Seeded on install
Security
Role-Based Access Control
JWT Bearer auth with 5 roles and per-module CRUD + Export permissions stored in Oracle.
RoleCompanyOpportunitiesJobsTechnologyAnalyticsUsers
SuperAdminCRUD + ExportCRUD + ExportCRUD + ExportCRUD + ExportFullFull
AdminCRUD + ExportCRUD + ExportCRUD + ExportCRUD + ExportFullLimited
BDManagerView + ExportCRUDCRUViewReadNone
AnalystCRU + ExportViewCRUDCRUDFullNone
ViewerView onlyView onlyView onlyView onlyReadNone
Development Roadmap
7-Phase Build Plan — 16 Weeks
From Oracle schema to full AI-powered intelligence platform.
Phase 1 · Weeks 1–3
Foundation
Oracle schema + .NET 8 setup + JWT auth
  • 13-table DDL + seed data
  • JWT login + refresh
  • Swagger UI
  • Role permissions seeded
Phase 2 · Weeks 4–5
Company Master
Core module + frontend wiring
  • CRUD + pagination + filters
  • Grid + list view
  • Tech profile upsert
  • CSV export
Phase 3 · Weeks 6–7
Contacts & CRM
CRM activity + reminder engine
  • Contact CRUD
  • Activity log (call/email/meeting)
  • 7-day reminder view
  • Follow-up timeline
Phase 4 · Weeks 8–9
BD Pipeline
Opportunities + Projects + Kanban
  • Opportunity Kanban board
  • Pipeline funnel chart
  • Project milestone tracker
  • Win rate analytics
Phase 5 · Weeks 10–11
Jobs & Suppliers
Career tracking + vendor management
  • Personal application tracking
  • Supplier audit workflow
  • Document upload + storage
Phase 6 · Weeks 12–13
Analytics & Reports
Live charts + Excel/PDF reports
  • Dashboard KPIs from Oracle views
  • 8 pre-built reports
  • NPOI Excel + iTextSharp PDF
Phase 7 · Weeks 14–16
AI Integration
GPT-4o + ML models
  • Company URL summarizer
  • NLP job-skill matcher
  • Opportunity scoring (XGBoost)
  • Contract risk analyser
Future AI Integration
8 Planned AI Features
Phase 7 will transform AeroLens from a data system into an intelligent aerospace BD co-pilot.
🧠
Company Summarizer
Input a company URL → GPT-4o extracts key intel, products, tech stack, hiring outlook and saves to the company record.
GPT-4o + Playwright
🎯
Job-Skill Matcher
Score your profile against any JD using TF-IDF cosine similarity. Surfaces best-fit roles across 47+ openings.
Python + spaCy + scikit-learn
📉
Opportunity Scorer
ML model predicts win probability based on company history, segment, value, and BD activity pattern.
XGBoost + Oracle ML
📜
Contract Analyser
Upload an NDA or RFQ → AI extracts key clauses, flags risks, summarises obligations.
GPT-4o + RAG + LangChain
🔔
Competitor Alerts
Daily automated crawl of competitor news → AI summary pushed as CRM activity with action recommendation.
Newspaper3k + GPT-4o
🔍
Smart Search
Natural language queries: "Defence companies using AI in Hyderabad with GET programme" → instant results.
OpenAI Embeddings + FAISS
📊
Report Writer
Generate narrative intelligence reports from raw Oracle data — sector analysis, BD summaries, hiring outlooks.
GPT-4o + Handlebars
🧩
Skill Gap Analyser
Compare your current skills against market demand across 58 companies — gap report with learning priorities.
NLP + Oracle Analytics
Built By
Author
MN
Mahin Nandipa
Fresher ML Engineer · Hyderabad, India
B.Tech Aerospace — VIT Bhopal PG AI/ML — IIIT Hyderabad (TalentSprint × Accenture) LLMs & RAG Pipelines LoRA Fine-Tuning FastAPI · LangChain · HuggingFace Aerospace + AI/ML intersection
Aerospace engineer turned ML engineer — building at the intersection of defence tech, autonomous systems, and generative AI. AeroLens is a personal BD intelligence tool for navigating India's aerospace industry job market and business opportunities.
mahin-aeroai AeroLens Repo SignERP