Data Analyst
🤹 Skills
📥 Data Collection & Querying
MySQL, Excel
🧹 Data Cleaning & Validation
Pandas, NumPy, Excel
📊 Analysis & Manipulation
Python, Jupyter Notebook, Pandas, NumPy
📈 Visualization
Tableau, Power BI, Matplotlib, Seaborn
🤖 Machine Learning
Scikit-learn (sklearn)
🛠️ Tools & Platforms
Git/GitHub, Excel, Jupyter Notebook
💡 Generative AI
ChatGPT for productivity, storytelling, and rapid ideation
🌐 Languages
English, Hindi
🧑🎓 Education
| 🎓 Exam/Degree | 🏫 Institution | 📅 Year | ⭐ Score |
|---|---|---|---|
| Common Admission Test (CAT) | Indian Institutes of Management (IIMs) | 2024 | Percentile: 96.06 |
| B.E., Electronics and Communication (ECE) | UIET, Panjab University, Chandigarh | 2024 | CGPA: 8.59 |
| Class 12th | Govt. Model Sr. Sec. School, Chandigarh | 2020 | 92.8% |
🔧 Work Experience
Junior Research Analyst
GreyB Research Pvt. Ltd.
Jan 2024 – June 2024
- 🔍 Conducted in-depth prior art searches using Derwent and Orbit across global patent and technical databases.
- 📝 Delivered comprehensive search reports highlighting key insights, claim charts, and critical prior references to support legal and R&D teams.
- ✅ Contributed to patentability, invalidity, and freedom-to-operate (FTO) assessments, enabling informed IP decisions.
- 🏅 Certified as a Specialist-level Patent Analyst for exceeding quality and speed benchmarks.
🚀 Projects
🏏 IPL Data Analysis (Season 2024 and 2025)
- 😎 Interactive Power BI Dashboard built for IPL 2024 & 2025 seasons.
- 🗃️ Extracted datasets on seasons, players, and matches using structured SQL queries.
- 🧪 Performed EDA at player and team level using Python (Pandas, Matplotlib, Seaborn).
- 📊 Created dynamic KPIs, trend charts, and filters in Power BI for match behavior and performance.
- 🧠 Used ChatGPT to assist in storytelling, querying logic, and content generation.
- 💡 Dashboard designed to help stakeholders explore season insights, team performance, and player impact.
🛍️ Sales Data Comparison & Analysis (2023–2024)
- 🐍 Created realistic synthetic sales data for 2023 and 2024 using
Faker,NumPy, and Python logic blocks. - 🧹 Cleaned and structured datasets to match realistic product, customer, and date patterns.
- 📊 Built a multi-page Power BI dashboard with maps, tooltips, slicers, KPIs, and charts.
- 🤖 Used ChatGPT as a co-pilot for debugging, markdown writing, and visual planning.
- 🔁 Focused on understanding growth trends, top customers, and product performance.
⚽ Football Striker Performance Analysis
- 🧠 Explored what separates an average striker from an exceptional one using data on 500 professional footballers.
- 🧪 Used Python (pandas, seaborn, matplotlib, sklearn, statsmodels) for EDA, hypothesis testing, clustering, and logistic regression.
- 🧹 Applied encoding, imputation, and scaling techniques for preprocessing.
- 📈 Clustered players into “Top Strikers” and “Regular Strikers” using K-Means.
- 🤖 Leveraged Generative AI (ChatGPT) to validate logic, speed up exploration, and clean documentation.
🏠 House Sales Analysis Dashboard
- 📊 Designed an interactive Tableau dashboard to analyze house sales in King County.
- 🎯 Implemented filters and slicers for dynamic insights into pricing, sales trends, and demographics.
- 🗺️ Used maps, KPIs, and bar charts for visual exploration.
- 🧑💼 Tailored for real estate stakeholders to derive actionable insights.
