Prateek Yadav

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

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.

Experience

Data Analyst

Bluestock™🔺 · Jun 2026 – Jul 2026

Not yet confirmed

• 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.

Data Analyst

Cognifyz Technologies · Jun 2026 – Jun 2026

Not yet confirmed

• 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.

Amigo

InAmigos Foundation (IAF) · Jun 2025 – Aug 2025

Not yet confirmed