Portfolio · 2026

Manas Srivastava

Building analytics systems that drive business decisions

I’m interested in the space between curiosity and creation. I ask questions, explore ideas, and build things that turn possibilities into something valuable.

sql>
  query_result.sql
fieldvalue
records_analyzed700,000+
peak_model_accuracy95%
codevita_rankTop 0.9% Global
hackathonWalmart Sparkathon Awardee
programMcKinsey Forward
linkedin_network1.6K+
6 rows returned

profile

About

Manas Srivastava
@manas0540

I'm a Data Analyst specializing in analytics engineering and applied AI — I combine data, analytics, and machine learning to solve real business problems. My work spans SQL, Python, and Machine Learning, from exploratory analysis and predictive modeling to business reporting and AI-powered analytics automation that stakeholders can act on.

I've analyzed 700,000+ records, pushed model accuracy as high as 95%, ranked in the top 0.9% among 537,000+ participants at TCS CodeVita, and was selected for the McKinsey Forward Program. I hold a completed Engineering from KNIT Sultanpur, and I've been working as a freelance Data Analyst — building AI-powered analytics automation — since January 2026.

Open to Roles B.Tech Graduate · 2022–2026 Freelancing since Jan 2026 1.6K+ LinkedIn network
English — Fluent Hindi — Native Japanese — Learning

now

Currently Working On

actively learning
Product Analytics LLMs MLflow MLOps AWS

skills

Technical Skills

programming

SQLPythonPandas Scikit-learnOOPs (Object-Oriented Programming)

data engineering

DatabricksETL Pipelines Data Cleaning & WranglingQuery Optimization Excel (Pivot, VLOOKUP, XLOOKUP)

analytics

Exploratory Data AnalysisKPI Reporting Statistical AnalysisData Storytelling A/B TestingRegression Analysis Time Series Analysis

bi & visualisation

Business Intelligence (BI)Dashboard Design Power BIMatplotlib

machine learning

Supervised LearningUnsupervised Learning Ensemble MethodsFeature Engineering Artificial Neural Networks (ANN)

ai

AI Agents & AutomationApplied LLMs

cloud

AWSCI/CD PipelinesAWS Cloud Practitioner (Certified)

experience

Work Experience

Freelance Data Analyst current
Jan 2026 – Present
Remote / Independent
Self-Employed
  • Delivered end-to-end Data Analysis, AI, and Web Development solutions for 3 clients, transforming business requirements into practical, production-ready outcomes.
  • Built AI-powered analytics automation agents that reduced repetitive reporting and data-cleaning effort through intelligent workflow automation.
  • Owned complete client engagements independently—from requirement scoping and data analysis to solution delivery, deployment, and iteration based on client feedback.
Data AnalysisAutomation AgentsPythonSQL
Business Strategy Intern
Jul 2025 – Sep 2025
Founder's Office, USA (Remote)
DefineCareer
  • Built and maintained an Excel-based tracker for 500+ TPO, improving outreach tracking and registration pipeline visibility.
  • Standardized institution records and tracked outreach activities, improving data accuracy and institutional engagement monitoring.
  • Recommended a resume review initiative to strengthen the programme's value proposition and support student career development.
Microsoft ExcelCRM Reporting
Data Analyst Intern
Feb 2025 – May 2025
Remote
Infosys Springboard
  • Developed predictive models for performance metrics (sales, churn rate, etc.) using regression and ensemble techniques, achieving 86.70% and 83.6% accuracy respectively.
  • Performed data preprocessing by handling 15% missing values through imputation and feature engineering, improving dataset reliability by 7%.
  • Supported data validation, cleaning, and preparation workflows, ensuring analysis-ready datasets for model development and evaluation.
PythonPandasScikit-learnMachine Learning

projects

Projects

Job Market Analysis Dashboard
SQL · Power BI
Problem

Companies need clear insight into hiring demand, in-demand skills, and regional employment trends buried across 700K+ raw job postings.

Solution

Analyzed the postings with SQL (CTEs, joins, window functions) and wrote reusable scripts to automate data prep, then built an interactive Power BI dashboard for salary, hiring, and skill-demand trends.

Business Impact

Cut manual analysis time by 30% and gave stakeholders a self-serve view of hiring trends.

Tribological Behaviour Prediction & Optimization
Python · Scikit-learn · Pandas
Problem

Measuring Wear Rate and Coefficient of Friction (COF) for Cu–Gr–TiC composites through lab testing is slow and expensive.

Solution

Built an ML framework comparing ANN, Random Forest, SVR, and KNN models to predict Wear Rate and COF, then identified Applied Load as the most influential parameter.

Business Impact

Achieved up to R² = 0.96 (COF) and R² = 0.89 (Wear Rate), reducing dependence on costly lab experiments and pinpointing optimal conditions (30N load, 8000m distance, 4.5 wt.% TiC).

SaaS Sales & Churn Prediction
Python · Scikit-learn · Jupyter Notebook
Problem

13,000+ SaaS subscription records with 5%+ missing values made it hard to forecast churn, revenue, and usage patterns manually.

Solution

Built an end-to-end ML pipeline: cleaned the data into a modeling-ready dataset, engineered 10+ business features, ran 20+ exploratory visualizations, and trained Linear Regression and Decision Tree Regressor models (R², MAE, MSE, RMSE) to forecast subscription duration and revenue.

Business Impact

Automated ~90% of manual analysis steps.

Smart Digital Wellness — Mental Health Guidance Platform
Python · Jupyter Notebook · EDA
Problem

Emotional and psychological wellbeing patterns were scattered across raw survey data with no clear, data-backed way to surface them.

Solution

Cleaned and explored a mental-health and wellbeing dataset, then prototyped a smart digital wellness concept for instant, personalized guidance.

Business Impact

Surfaced actionable, data-backed wellbeing insights that could inform a personalized guidance product.

experiments

Experiments

Random Jokes
Just for fun

A small, lighthearted project that serves a random joke from a curated collection on each run — built to experiment with content randomization logic.

achievements

Achievements

McKinsey & Company Forward ProgramSelected trainee — 8-week business analytics & leadership program.
TCS CodeVita Season 12 — Global Rank 4,500Top 0.9% among 537,000+ participants.
Walmart Sparkathon — AwardeeRecognized at Walmart's flagship innovation hackathon.
Smart India Hackathon (SIH) 2023–24Pitched an idea and successfully cleared the college-level round.
SIH 2023-24
Aspire Leadership ProgramSelected participant — leadership and professional development program.
Finalist — NSUT Datasphere ChallengeCompetitive data analytics challenge.
Genius Science Olympiad — Cleared, Class 12 (Physics)Certificate of clearance in Physics.
Genius Science Olympiad Certificate
5-Star SQL BadgeHackerRank.
82 / 100 — Newton School Data Analyst Skill AssessmentBenchmark score: 75+.

media & workshops

Media & Workshops

Guest Speaker — Digital Fraud, e-KYC & Digital Literacy Awareness CampKNIT Sultanpur × Punjab National Bank, under the UP Govt.'s "Sewa Bhi, Sanskar Bhi Aur Samman Bhi" campaign — covered in Aaj, Lucknow (16 Jun 2026).
Newspaper coverage of the Digital Fraud Awareness Camp, Aaj Lucknow
Attended — SERB-Sponsored Workshop on Carbon Utilization for NET-ZERO Vision"Carbon Utilization and Other Needed Technologies for NET-ZERO Vision of Atmanirbhar Bharat" · RGIPT, Jais, Amethi · Oct 2024.
RGIPT NET-ZERO workshop programme details

github

GitHub Activity

stats GitHub stats for manas0540 — repositories, stars, commits
contribution graph GitHub contribution graph for manas0540

volunteering

Volunteering & Leadership

Social Media Executive
Koshish Educational & Welfare Society
Managing social media presence and outreach content for the society's educational and welfare initiatives.
3+ years · Ongoing

education

Education

Bachelor of Technology, Mechanical Engineering
Kamla Nehru Institute of Technology (KNIT), Sultanpur
2022 – 2026 · Completed
CGPA
7.14 / 10
Industrial Training — Mechanical Engineering
Kisan Sahkari Chini Mills Ltd, Sultanpur (Awadh)
Jun 2025 – Jul 2025 · Non-stipendiary

Completed a one-month industrial training in the Maintenance department, gaining hands-on exposure to the complete sugarcane-to-sugar production cycle at the mill.

certifications

Certifications

AI Fluency Framework & Foundations active
Anthropic
Issued Mar 2026
Credential ID: sax47uocp58c
AWS Cloud Practitioner Essentials active
AWS Academy
Completed
Google Analytics Certification active
Google
Career Essentials in Data Analysis active
LinkedIn Learning
Product Design and Manufacturing active
NPTEL
Issued Feb 2026

credibility

Mentors & Collaborators

Guided a sales-data-analyst internship — building a baseline ML model to predict performance metrics, with daily work in data validation and interpretation.

Vinay Kumar
Mentor · Infosys Springboard

Supervised the final-year Cu–Gr–TiC composites project — verifying experimental vs. predicted results, comparing models (including feature importance) to close gaps, and optimizing for future work. The findings were appreciated by both examiners.

Prof. Ankit
Project Mentor · KNIT Sultanpur

Oversaw a Founder's Office internship spanning the full range of the work — from outreach and database management in Excel to strategy design and service implementation.

Sagar Gulati
Founder · DefineCareer

online presence

The Timeless Analyst

My personal brand, built in public across Substack, X, and YouTube — projects, learnings, and work in progress.

AIProduct AnalyticsA/B Testing Root Cause AnalysisCase StudiesData Storytelling
Read on Substack