Open to Work · Data Analyst

Rudra Narayan
Usrethe
Data Analyst

CS graduate turning raw data into actionable business insights. Skilled in Python, SQL, Power BI, and data visualization — building dashboards that tell stories.

3,900+
Records Analyzed
2+
BI Projects
4+
Certifications
7.2
B.Tech CGPA
👥 LinkedIn Profile 💻 GitHub Get in Touch
Scroll
About me

Who I am

I'm a Computer Science graduate from Gyan Ganga Institute of Technology and Sciences, Jabalpur, with a strong passion for transforming raw, messy data into clean, meaningful insights.

My work spans the full analytics pipeline — from data cleaning and transformation using Python and Pandas, to building interactive Power BI dashboards that stakeholders actually use to make decisions.

I've worked with datasets of 3,900+ records, performed customer segmentation, revenue analysis, and subscription impact studies — always with the goal of answering the "so what?" behind the numbers.

Location Chhindwara, Madhya Pradesh, India
Education B.Tech CSE — 7.2 CGPA
Email usretherudranarayan@gmail.com
LinkedIn rudra-narayan-usrethe
GitHub Rudra-usrethe
Programming & Databases
Python SQL MySQL PostgreSQL
Libraries & Analysis
Pandas NumPy Matplotlib Seaborn EDA Statistical Analysis
Data Visualization & BI
Power BI DAX Microsoft Excel Dashboards
SQL Concepts
Joins Stored Procedures Aggregation Subqueries
Tools
Git GitHub VS Code
Projects

Work I'm proud of

Real data. Real insights. End-to-end analytics projects from raw CSV to polished dashboard.

01 / Featured
📊
Customer Shopping Behavior Analysis
End-to-end data analytics project analyzing 3,900 transactions across 18 features to uncover customer purchasing patterns, segment behavior, and drive business recommendations.
3,900 Transactions
18 Features
3 Segments
$233K Total Revenue
Python Pandas SQL PostgreSQL Power BI Seaborn Matplotlib
Key Insights
  • Male customers generated 2× more revenue ($157,890) than female customers ($75,191) across all transactions
  • Loyal segment: 3,116 customers — the dominant cohort driving repeat purchase value
  • Subscription doesn't drive higher per-order spend — $59.87 vs $59.49 avg (non-subs vs subs)
  • 73% non-subscribers contributed ~$170K vs 27% subscribers at $62.6K revenue
  • Young adults led revenue contribution; all age groups had near-equal avg spend of $59.76
  • Review rating imputed by category median; snake_case normalization applied across 18 columns
  • Age group & purchase frequency features engineered for segmentation modeling
Business Recommendations
  • Launch exclusive subscriber perks to boost the 27% subscriber base
  • Build loyalty reward programs targeting the Loyal segment (3,116 customers)
  • Review discount policy to balance sales lift against margin erosion
  • Prioritize high-revenue age groups & express-shipping users in marketing spend
02
💹
E-Commerce Sales Analysis Dashboard
Comprehensive sales performance analysis using transactional data. Built end-to-end pipeline from SQL extraction to Power BI visualization — monitoring revenue, profit, and product metrics.
  • Sales trend analysis revealing seasonal patterns and top-performing categories
  • SQL joins, stored procedures & aggregation for structured data pipeline
  • Real-time Power BI dashboard tracking revenue, profit margins, and SKU performance
  • Data-driven recommendations delivered to improve understanding of sales trends
Python SQL Power BI Matplotlib Stored Procedures
03
⚡
Mahadev Power BI Dashboard
Interactive business intelligence dashboard built in Power BI — designed for real-time KPI monitoring with dynamic filters and drill-through capabilities for stakeholder reporting.
  • Interactive slicers for subscription, gender, category & shipping filters
  • DAX measures for custom KPIs, revenue aggregation, and trend calculations
  • Multi-page layout with drill-through for granular segment analysis
  • Optimized data model for fast report rendering on large datasets
Power BI DAX Data Modeling KPI Design
Background

Education & Training

2020 – 2024
B.Tech — Computer Science Engineering
Gyan Ganga Institute of Technology and Sciences, Jabalpur, MP
Graduated with a CGPA of 7.2/10. Coursework included Database Systems, Data Structures, Computer Networks, and Software Engineering. Developed strong foundations in programming and system design that feed directly into data analytics workflows.
Training
Data Analytics Training
Samyak Computer Classes
Hands-on training in end-to-end data analytics workflows — covering data cleaning, exploratory data analysis, visualization techniques, and business intelligence reporting using industry-standard tools.
Ongoing
Self-Directed Learning
GitHub Projects & Online Certifications
Continuously building real-world projects on GitHub, earning certifications in Python, SQL, and Power BI. Active contributor to data analytics projects — from Jupyter notebooks to full dashboard deployments.
Certifications

Credentials

Verified skills across the modern data analytics stack.

📈
Data Analytics Training
Samyak Computer Classes
🐍
Python Programming Certification
Verified Credential
🗄️
SQL for Data Analysis
Verified Credential
📊
Power BI Certification
Microsoft Ecosystem
Contact

Let's connect

I'm actively looking for Data Analyst roles where I can apply my skills in Python, SQL, and Power BI to drive real business impact. If you're hiring or want to collaborate — reach out.

Available for opportunities
✉️
Email
usretherudranarayan@gmail.com
→
💼
LinkedIn
rudra-narayan-usrethe
→
🐙
GitHub
Rudra-usrethe
→
📱
Phone
+91 82691 88683
→