Chirag Jain

Data Analyst

2roles
23skills
2education

About

Data Analyst with a strong foundation in SQL, Python, Excel, Power BI, and data visualization, skilled in transforming complex datasets into actionable business insights.

Experience

Intern

Skode Web Innovations

Jan 2025 - June 2025

Analyzed large datasets using SQL, Excel, and Python to identify trends, patterns, and business opportunities, transforming raw data into insights that supported strategic decision-making and improved reporting accuracy. Performed data cleaning, validation, preprocessing, and transformation to ensure high data quality and prepare reliable datasets for analysis, visualization, and business reporting. Developed interactive dashboards and automated reports using Power BI to track KPIs, monitor business performance, and provide stakeholders with real-time, data-driven insights. Collaborated with cross-functional teams to understand business requirements, perform exploratory data analysis, prepare analytical reports, and develop recommendations that enhanced efficiency and optimized business processes.

Sub-head

PECFEST

2025

Managed end-to-end logistics and stakeholder coordination for a 10,000+ attendee event, leading cross-functional teams of 30+ volunteers and demonstrating leadership, communication, and operational decision-making.

Education

Punjab Engineering College, Chandigarh

B.Tech

2022-2026

Relevant Coursework: Machine Learning & Artificial Intelligence, Data Structures & Algorithms, Object Oriented Programming, Operating Systems, Database Management Systems

Colonel Public School, Chural

Senior Secondary (12th CBSE)

2021-2022

Percentage: 92.8%

Skills

PythonSQLExcelPandasNumPyPower BIData CleaningData ProcessingKPI DefinitionData InterpretationStructured Problem SolvingPerformance Metrics AnalysisBasic Financial & Revenue ModellingMySQLGitGitHubLinuxVS CodeMachine Learning & Artificial IntelligenceData Structures & AlgorithmsObject Oriented ProgrammingOperating SystemsDatabase Management Systems

Projects

Fake News & Plagiarism Detection System

NLP and data analytics project that developed an NLP-based content validation system for fake news and plagiarism detection. Built a preprocessing pipeline for textual datasets from PDFs and images, conducted exploratory data analysis and feature engineering, evaluated classification performance using precision, recall, F1-score, and confusion matrix, and integrated the analytical backend with a frontend through API-based workflows.

SaralBuy – Buyer Driven E-Commerce Platform

Full-stack and data-oriented e-commerce platform designed to streamline requirement posting, bidding, and transaction workflows. Designed a relational database schema, optimized SQL queries, analyzed operational metrics, and built a revenue and commission projection model for transaction growth, unit economics, and profitability analysis.