Prateek Yadav

Prateek Yadav

+•• ••••• •••••••••••@•••••.com

Data Analyst | I help businesses find revenue and cost insights hidden in their data | SQL · Python · Power BI · ETL | 5⭐ HackerRank SQL · 0.2 yrs

Data Analyst turning numbers into decisions — not just reports nobody reads. I got into data analysis because I liked a very specific feeling: taking a messy spreadsheet nobody wanted to touch and turning it into three charts that made a manager say "oh, now I get it." That feeling hasn't gotten old. I work across SQL, Python, Power BI, Tableau, and PostgreSQL — but the tools are just the how. The what is business insight: revenue trends, customer behavior, demand forecasting, and the KPIs that actually move a conversation in a meeting room. Here's what that's looked like in practice: I've built 3+ end-to-end analytics projects spanning sales, customer behavior, and retail demand forecasting, working across 270K+ records. I wrote advanced SQL using JOINs, CTEs, window functions, and case logic to segment high-value customers and surface seasonal demand patterns. I designed interactive Power BI dashboards tracking Revenue, Profit Margin, AOV, and Growth Trends — the kind stakeholders actually open every week instead of ignoring. I also hold a 5-star HackerRank SQL rating. Right now, I'm working as a Data Analyst at Bluestock Fintech, where I analyze financial and customer datasets, build SQL queries for KPI reporting, and support stock and mutual fund trend analysis for investment reporting. I'm currently open to Data Analyst, Business Analyst, MIS Executive, Reporting Analyst, and BI Analyst roles — anywhere a team needs someone who can take raw data and hand back a decision, not just a dashboard. If you're hiring for a role like that, or just want to talk data — my inbox is open. Let's connect.

  • Greater Lucknow Area
  • Open to Delhi · Noida · Gurgaon
  • Hybrid, On-site, Remote

Ask about Prateek

Skills

Claimed

Work Planning and PrioritizationData Type & Feature UnderstandingTabular Data Cleaning & ValidationHandling Data SparsityMarket Trend AnalysisProfitability AnalysisSales AnalysisReturn on Investment CalculationRisk Appetite AssessmentFinancial AnalysisMutual Fund AnalysisData-Driven Recommendations

Proof of Experience

Bluestock™🔺

Data Analyst

Bluestock™🔺 · Jun 2026 – Jul 2026

  • Analyzed 25K+ financial and customer records using SQL and Python to identify customer behavior patterns and business trends.
  • Built 15+ advanced SQL queries using CTEs, Window Functions, and Joins for KPI reporting.
  • Developed ETL workflows improving data accuracy and reducing reporting inconsistencies.
  • Conducted stock and mutual fund trend analysis to support investment reporting.
Cognifyz Technologies

Data Analyst

Cognifyz Technologies · Jun 2026 – Jun 2026

  • Processed and analyzed 120K+ sales transaction records using Python and PostgreSQL to uncover revenue trends and customer purchasing patterns.
  • Built optimized SQL queries using JOINs, CTEs, Window Functions, and Aggregate Functions for business analysis.
  • Conducted EDA to identify seasonal demand fluctuations, top-performing product categories, and high-value customer segments.
  • Designed interactive Power BI dashboards with KPIs including Revenue, Profit Margin, AOV, and Growth Trends.
  • Performed end-to-end customer behavior analysis using Python, SQL, and Power BI to identify purchasing trends and customer preferences.
  • Cleaned and transformed raw transactional data using Pandas and SQL for analytical accuracy.
  • Developed SQL-based customer segmentation analysis to identify loyal and high-spending customers.
  • Built an interactive Power BI dashboard with KPIs and trend visualizations for business intelligence reporting.
  • Performed advanced retail sales analysis using PostgreSQL on transactional datasets to derive revenue and customer insights.
  • Wrote complex SQL queries using JOINs, GROUP BY, CTEs, CASE Statements, and Window Functions.
  • Analyzed sales trends, category performance, customer behavior, and discount impact across regions.
  • Built KPI-driven analytical reports including Top-Selling Products, Revenue Contribution, and Sales Growth Metrics.
InAmigos Foundation (IAF)

Amigo

InAmigos Foundation (IAF) · Jun 2025 – Aug 2025

Proof-of-Work

No completed sessions yet. Anything Prateek finishes shows up here with the evidence behind it.

Proof of Education

Bachelor of Computer Science

Veer Bahadur Singh Purvanchal University (VBSPU), Jaunpur · 2022 — 2026

intermediate

dr rizvi learners academy Jaunpur

A Proof CV — one profile, kept current, with the proof attached. Back to the portal