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 an Analyst specializing in data analytics, product analytics, analytics engineering and applied AI — I combine data, analytics, and machine learning, and Neural Networks 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 RAG (Retrieval-Augmented Generation) 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 screenshot
Job Market Trend Analysis
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 screenshot
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 and Churn Prediction screenshot
PulseCheck AI — AI-Powered Digital Wellness Intelligence System
Machine Learning · Behavioral Analytics · LLMs · Full-Stack AI
Problem

Millions of users experience stress and burnout, but existing wellness solutions rarely combine behavioral signals with predictive analytics to identify early warning patterns. The challenge was transforming raw lifestyle data into an intelligent system capable of prediction, explanation, and personalized intervention.

Solution

Engineered an end-to-end ML application that analyzes sleep, screen time, activity, stress, and mood patterns to generate burnout risk scores and wellness personas. Built predictive models, implemented explainable decision logic, and integrated LLM-based conversational guidance through a production-ready web architecture.

Impact

Demonstrated how machine learning and generative AI can transform behavioral data into actionable insights. Delivered a scalable prototype with 97% R² prediction accuracy, explainable recommendations, and an interactive user experience bridging analytics, AI, and human-centered design.

Smart Digital Wellness project screenshot
Customer Churn & Cutomer Intelligence (Revenue Risk) Analysis
Python · SQL (SQLite) · Pandas · Matplotlib/Seaborn
Problem

A SaaS company's customer, subscription, and support-ticket data lived in three disconnected tables with inconsistent formats, missing countries, duplicate support tickets, and no visibility into churn drivers or revenue exposure.

Solution

Built a SQL-to-Insights pipeline: loaded raw data into SQLite, joined 3 relational tables via SQL/pandas, cleaned and standardized 20+ fields, engineered churn-risk features (churn_flag, tenure_days, churn_risk tiers), and ran correlation and cohort analysis (escalations vs. churn: +0.77) across 8+ visualizations to quantify revenue at risk.

Business Impact

Identified a 28.6% churn rate driving ~18% revenue loss and ₹2,047 in lost CLTV, pinpointed monthly contracts as 6x more churn-prone than annual, and delivered a prioritized retention action list for high-risk, high-value customers.

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 in an 8-week business analytics & leadership program — covered structured problem-solving, stakeholder communication, and data-backed decision-making frameworks used in real client engagements.
McKinsey Forward Program
TCS CodeVita Season 12 — Global Rank 4,500Top 0.9% among 537,000+ participants worldwide, ranked through timed algorithmic rounds testing data structures, problem decomposition, and code efficiency under pressure.
TCS CodeVita certificate
Walmart Sparkathon — AwardeeRecognized at Walmart's flagship innovation hackathon for a data-driven solution to a real retail business problem, evaluated by Walmart engineering and product mentors.
Walmart Sparkathon award
Smart India Hackathon (SIH) 2023–24Pitched an idea and cleared the college-level round, competing against student teams to design a solution for a real-world problem statement.
SIH 2023-24
Aspire Leadership ProgramSelected participant in a leadership and professional development program focused on communication, ownership, and cross-functional collaboration.
Aspire Leadership Program
Finalist — NSUT Datasphere ChallengeReached the finalist round of a competitive data analytics challenge, presenting insights drawn from a real dataset under time constraints.
NSUT Datasphere Challenge
Genius Science Olympiad — Cleared, Class 12 (Physics)Certificate of clearance in Physics.
Genius Science Olympiad Certificate
5-Star SQL BadgeHackerRank's top SQL proficiency rating — reflects strong command over joins, window functions, subqueries, and query optimization.
HackerRank 5-Star SQL badge
82 / 100 — Newton School Data Analyst Skill AssessmentScored well above the 75+ benchmark on an assessment covering SQL, statistics, and applied analytical reasoning.
Newton School Data Analyst Skill Assessment

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

quick note on git & github

Git is just a way to save snapshots of your code as you work, so you can always go back if something breaks. GitHub is where those snapshots live online — a shared home for the project that anyone on the team can pull from.

The everyday flow is simple: you commit small, meaningful changes with a clear message, work on a separate branch so the main code stays stable, and open a pull request when it's ready for someone to review before it gets merged in.

The habits that matter most: commit often, write messages that explain why not just what, keep a clean .gitignore, and read the diff before you push. Small, honest history beats one giant commit every time.

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

resume

Resume

Full Resume — PDF
Updated periodically
Download Resume