VIJAY KATIYAR

VIJAY KATIYAR

B.Tech Student

Ghaziabad, Uttar PradeshData Science and Analytics
68skills
4education
6credentials

About

B.Tech student in the 2027 batch with a foundation in Python, SQL, data analysis, and machine learning. Experienced with data preprocessing, exploratory data analysis, visualization, and data-driven solutions.

Education

Ajay Kumar Garg Engineering College

Bachelor of Technology (B.Tech)

2027

CGPA: 7.74/10; awarded fee waiver based on JEE Main score

Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology

2023 - 2027

St. Xavier's Senior Secondary School, kannauj

Intermediate(12th)

2020 - 2021

St. Xavier's Senior Secondary School, kannauj

High School Diploma

2018 - 2019

Skills

PythonSQLC++Power BIDAXMS ExcelMatplotlibSeabornDashboardsKPI TrackingScikit-learnSupervised LearningUnsupervised LearningLLMsRAGLangChainLangGraphPrompt EngineeringPostgreSQLFastAPIREST APIsMS WordMS PowerPointVS CodeJupyter NotebookGoogle ColabGitGitHubDockerPostmanAI ToolsStructured ResearchData CleaningData WranglingExploratory Data AnalysisTrend AnalysisInsight GenerationFood orderingData StructuresMicrosoft Excel MacrosVisual Basic for Applications (VBA)MacrosReal-time DataFood Cost AnalysisMicrosoft OfficeTechnology EducationJupyterKey Performance IndicatorsProfessional DevelopmentExcel DashboardsDevelopment & implementation of marketing plansBusiness InsightsIntegrated Business Planning (IBP)Web ScrapingHindiEnglishMicrosoft Power BIMicrosoft PowerPointMicrosoft WordMicrosoft ExcelPandasPython (Programming Language)CommunicationProblem SolvingData VisualizationData AnalysisNumPyData Entry

Projects

IntelliNews

NLP preprocessing with tokenization, stopword removal, and sentence cleanup; extractive news summarization; sentiment analysis with polarity, confidence, and evidence words; named entity extraction for people, organizations, locations, dates, money, and percentages; question answering using prompt-style retrieval over article sentences.

California Housing Price Prediction

Built a machine learning model to predict California housing prices using demographic and housing datasets. Performed data preprocessing, feature engineering, and exploratory data analysis. Trained and evaluated regression models using Scikit-learn with RMSE and R2 metrics. Visualized trends and model performance using Matplotlib and Seaborn.

e-commerce SQL Project

Created a full database schema for an e-commerce platform with sample data generation scripts for customers, orders, products, payments, shipping, reviews, and inventory. Developed SQL analyses for revenue, customer behavior, seller performance, product insights, and delivery metrics.

Food Ordering Behavior Analysis

Analyzed more than 50,000 customer records using Python and Pandas to understand ordering behavior. Cleaned, transformed, and organized raw data, and identified customer retention and marketing trends through exploratory data analysis.