// Data Analyst · Bengaluru, India

Anuj Oraon

Power BI Developer|

Turning messy business data into clear, decision-ready insights. 9 months of real-world analytics at a 470+ store US retail network — now open to the next challenge.

-- Who is this analyst?
SELECT name, experience, stack
FROM analysts
WHERE has_skills('Snowflake, DAX, Python') = TRUE
AND availability = 'Immediate';
-- ✓ 1 row returned: Anuj Oraon
View Projects GitHub ↗ LinkedIn ↗ ↓ Download CV
Anuj Oraon
9
Months Experience
35
SQL Questions
470+
Stores Supported
▸Giant Eagle GCC
▸Snowflake
▸Databricks
▸Power BI
▸SQL Advanced
▸DAX
▸Tableau
▸Python
▸Retail Analytics
▸470+ Stores
▸Immediately Available
▸HackerRank Certified
▸Giant Eagle GCC
▸Snowflake
▸Databricks
▸Power BI
▸SQL Advanced
▸DAX
▸Tableau
▸Python
▸Retail Analytics
▸470+ Stores
▸Immediately Available
▸HackerRank Certified
// 01 — About

The person behind the queries

I'm a Data Analyst with 9 months of hands-on experience at Giant Eagle's Global Capability Center in Bengaluru — supporting one of the largest US supermarket chains with analytics across pricing, promotions, category performance, and customer intelligence.

My work wasn't theoretical. I built automated Smart Narrative frameworks that cut a 3–4 day reporting cycle to under 10 minutes. I wrote parameterised SQL frameworks in Snowflake and Databricks adopted team-wide. I delivered competitive intelligence on Aldi, Kroger, Meijer, and Target to stakeholders across India and the US.

I hold an MSc in Big Data Analysis from St. Joseph's University, Bengaluru (2025), and I'm HackerRank SQL Advanced certified. I'm immediately available and actively looking for my next role.

HackerRank SQL Advanced
Tableau Certified
Snowflake + Databricks
Power BI + DAX
Immediately Available
Bengaluru Based
Primary Stack
SQLSnowflakeDatabricksMySQL
Visualisation
Power BIDAXTableauSmart Narratives
Python
PandasNumPyMatplotlibSeaborn
Domain
Retail AnalyticsPricing & MarginCategory Analytics
Analytics Skills
Market SegmentationA/B TestingEDAKPI Reporting
// 02 — Experience

Where I've done the work

Enterprise Insights Analyst
Giant Eagle Global Capability Center
May 2025 – Feb 2026  ·  Bengaluru, Karnataka  ·  Hybrid  ·  9 months
Rotational Program
📊
Category Analytics
💰
Pricing & Margin
📣
Promotional Analytics
🧠
Market Intelligence
Power BI & Visualisation
  • Built end-to-end Power BI dashboards with DAX measures, time intelligence (52W/26W/13W), category hierarchies, and KPI tracking across 470+ stores
  • Developed geospatial competitive intelligence dashboard — visualised competitor store openings within 0–15 miles; used by US and India leadership
SQL & Data Engineering
  • Wrote advanced SQL daily in Snowflake and Databricks — built reusable parameterised query frameworks with dynamic date filters, adopted team-wide
  • Integrated Databricks pipelines with Circana market intelligence (TDP & SOW) — resolved cross-source mapping inconsistencies
Pricing & Competitive Analytics
  • Managed 8–10 SKU pricing forms per cycle — applied psychological pricing logic (.79/.99 bands); conducted 2024–2026 margin erosion analysis
  • Delivered weekly competitive intelligence — benchmarked Aldi, Kroger, Meijer, Target pricing; presented to Director and ~60 analysts
Python & Automation
  • Used Python (Pandas, NumPy) for data cleaning, transformation, and pipeline automation across promotional and category datasets
  • Conducted multi-year promotional effectiveness analysis (TY vs LY) — evaluated discount depth, margin trade-offs across key categories
⚡
Key Achievement: Designed and deployed an automated Smart Narrative framework across 20+ Power BI report pages — cut manual insight generation from 3–4 days to under 10 minutes. Adopted as the analytics team standard.
// 03 — Skills

Tools I use every day

SQL & Data Platforms
SQL (Advanced)95%
Snowflake85%
Databricks80%
MySQL90%
Power BI & Visualisation
Power BI88%
DAX82%
Tableau80%
Advanced Excel85%
Python & Analysis
Python (Pandas, NumPy)80%
EDA & Segmentation85%
Matplotlib / Seaborn78%
Statistical Analysis75%
Domain & Business Skills
Retail & Pricing Analytics88%
Market Segmentation82%
Competitive Intelligence85%
KPI Dashboard Development87%
// 04 — Projects

Work that speaks for itself

PROJECT 01
SQL
Smartphone Market Intelligence Analysis
35-question SQL business intelligence project on 980 smartphones across 46 brands. Full analytics workflow from aggregations to advanced window functions.
980 phones · 46 brands · 26 attributes
Window functions, CTEs, correlated subqueries
MySQLRANK()CTEsWindow Functions
View on GitHub →
PROJECT 02
Python · EDA
Telecom Customer Churn Analysis
End-to-end customer retention analysis on 7,043 telecom customers. Identified highest-risk segments and quantified revenue at risk.
54.6% churn rate in highest-risk segment
5-dimension customer segmentation
PythonPandasSeabornEDA
View on GitHub →
PROJECT 03
Python · Analytics
Retail Analytics — Quantium / Forage
Simulated real-world retail analytics engagement. Customer segmentation, control store selection, and A/B uplift testing delivered as a consulting-style report.
Pearson correlation control store selection
Statistical significance uplift testing
PythonA/B TestingStatisticsSegmentation
View on GitHub →
// 05 — Certifications

Verified credentials

HackerRank · Apr 2026
SQL Advanced
Credential: ca49a04ddacf ✓
HackerRank · Apr 2026
SQL Intermediate
Credential: dc667f94f047 ✓
HackerRank · Mar 2026
Python Basic
✓ Verified
Quantium / Forage · Mar 2026
Data Analytics Job Simulation
EDA · A/B Testing · Reporting
Tableau · Aug 2024
Tableau Desktop Specialist
Data Visualization & Analysis ✓
Microsoft · May 2024
Power BI Introduction
Data Modeling · DAX · Dashboards

Let's work together

I'm immediately available and actively looking for Data Analyst, Business Analyst, or Reporting Analyst roles in Bengaluru and beyond. If your team needs someone who can hit the ground running with SQL, Power BI, and Python — let's talk.

✉Send Email 💼LinkedIn 🐙GitHub 📞+91 99341 33104 ↓Download CV
⚡ Immediately Available · Bengaluru · Open to Hybrid / Remote
Apollo