Open to Work — Data Analyst Roles

Raw Data.
Clear Decisions.
Business Impact.

I'm Priyanshu Sharma — a Data Analyst with a foundation in Accounting & Finance, specializing in SQL, Python, Power BI, and Excel. I build dashboards, surface KPIs, and translate data into decisions that move business forward.

View Case Studies Get In Touch
analysis.sql
-- UPI Payment Risk Analysis
WITH monthly_risk AS (
  SELECT
    month, total_txn,
    failure_rate,
    ROUND((failure_rate -
    AVG(failure_rate)
    OVER()) / STDDEV(failure_rate)
    OVER(), 3) AS z_score
  FROM npci_upi_data
)
SELECT * FROM monthly_risk
WHERE ABS(z_score) > 2;
▶ 3 anomaly months detected
5+
Live Projects
10yr
NPCI Data
4+
Certifications
About Me

Finance Brain.
Analytics Toolkit.

I hold a B.Com Honours in Accounts & Finance from Lalit Narayan Mithila University and am completing a Data Analytics certification at Aptech Learning. My dual background — financial theory plus technical analysis — means I don't just build dashboards. I understand the business context behind every metric.

My focus is BFSI and fintech: credit risk, UPI transaction intelligence, customer churn, and KPI reporting. I work with official data sources (RBI, NPCI, SEBI) and translate complex findings into clear, actionable insights for business teams.

Contact Me LinkedIn
B.Com.
Accounts & Finance Hons.
BFSI↗
Primary Target Domain
SQL✓
HackerRank Advanced
5+
GitHub Projects
Domain Focus Areas
Credit Risk UPI Analytics Customer Churn KPI Dashboards Financial Reporting Business Intelligence Anomaly Detection Data Cleaning
Technical Stack

Tools I Use to
Turn Data Into Decisions

Every tool selected because it solves a real business problem — not for the sake of adding to a list.

🗄️
SQL / PostgreSQL
Window functions, CTEs, subqueries, joins, aggregations, and performance tuning for large-scale BFSI datasets.
Advanced · HackerRank Certified
📊
Power BI
DAX measures, calculated columns, drill-through reports, KPI cards, and executive-ready dashboards.
Proficient · Simplilearn Certified
🐍
Python (Pandas)
Data cleaning, transformation, EDA, Z-score anomaly detection, and Matplotlib visualisations.
Proficient · Simplilearn Certified
📋
Excel
XLOOKUP, SUMIFS, IFS, pivot tables, dynamic arrays, and financial modelling for business reporting.
Advanced
🏦
BFSI Domain
Credit risk metrics, UPI payment flows, loan portfolio analysis, NPA concepts, and RBI data interpretation.
Strong Domain Foundation
📈
Statistics & Analytics
Descriptive stats, Z-score detection, correlation analysis, trend identification, and hypothesis framing.
Intermediate
🔄
Data Pipelines
ETL thinking, data wrangling from multiple sources (RBI, NPCI, SEBI), and building clean analysis-ready datasets.
Proficient
🤖
AI Fluency
Prompt engineering, AI-assisted analysis workflows, IBM AI Fundamentals certified — stays ahead of the curve.
IBM SkillBuild Certified
Case Studies

Real Problems.
Real Data. Real Answers.

View GitHub →
01 — BFSI · Payments · Risk Intelligence Featured
UPI Payment Risk Intelligence System
Analysed 10 years of NPCI aggregate UPI transaction data (2016–2025) to build a macro-level payment risk monitoring framework. Applied statistical anomaly detection to surface failure-rate spikes, seasonal patterns, and volume outliers that correlate with systemic risk events.
Key Business Insights
  • Identified 3 anomalous months via Z-score analysis where failure rates exceeded 2 standard deviations — flagging periods of systemic stress in the UPI ecosystem
  • Mapped transaction volume growth curve from ₹1L Cr/month (2018) to ₹21L Cr/month (2024) — quantifying the 21× scale-up challenge for risk infrastructure
  • Detected seasonal compression in Q4 (Jan–Mar) failure rates, suggesting year-end compliance-driven improvements in bank settlement systems
Python Pandas Z-Score Matplotlib Excel NPCI Data Time-Series
Data Source: NPCI Official Monthly Reports View on GitHub →
02 — BFSI · Credit · Risk
Credit Risk Analysis & Default Prediction
Built an end-to-end credit risk assessment model using RBI-published loan portfolio data. Segmented borrowers by NPA risk tier and built a scoring logic to prioritise high-default segments.
Key Insights
  • Identified top 3 borrower segments contributing to 68% of NPA volume
  • Proposed risk-tier segmentation to reduce manual underwriting review workload
SQL Python Power BI RBI Data
Source: RBI DBIE Portal View →
03 — Fintech · Retention · Churn
Customer Churn Intelligence — Fintech
Modelled customer retention patterns for a fintech lending product. Identified the top behavioural indicators of churn using cohort analysis and segmentation, enabling targeted retention interventions.
Key Insights
  • Churn probability 3× higher for customers with 0 transactions in months 2–3
  • Early repayment correlated with 40% lower churn — flagged as retention signal
Python Pandas Cohort Analysis Excel
Synthetic + Public Dataset View →
04 — E-Commerce · Operations
E-Commerce Failure & Delay Analysis
Diagnosed order failure, delay, and cancellation patterns across an e-commerce dataset. Delivered root-cause findings and a Power BI dashboard highlighting operational bottlenecks by region and category.
Key Insights
  • Payment gateway failures accounted for 34% of all order drop-offs
  • Tier-2 cities showed 2.1× higher delivery delay rates vs. metro regions
SQL Power BI Excel Root Cause Analysis
Kaggle Dataset View →
Value Proposition

Why I'm Different
From Typical Fresher Candidates

01
Domain-First Thinking
I come with a Finance Honours background. I don't just run queries — I understand credit cycles, NPA classification, payment flows, and what a KPI actually means to a business stakeholder.
02
Official Data Sources
My projects use RBI, NPCI, and SEBI data — not Kaggle toy datasets. This demonstrates I can source, clean, and interpret real regulatory and institutional data that financial organisations actually work with.
03
End-to-End Delivery
From raw messy data to a clean report or Power BI dashboard — I handle the full pipeline. Data sourcing, cleaning, transformation, analysis, visualisation, and business interpretation. No handoffs needed.
04
SQL at Depth
HackerRank Advanced SQL certified. I write production-quality queries: window functions, CTEs, Z-score logic in SQL, multi-condition JOINs — not just SELECT * FROM table basics.
05
Insight-Led Communication
I present findings in business language — not just charts and tables. Every analysis ends with a "so what?" that a manager or executive can act on. That's rare at fresher level.
06
AI-Literate Analyst
IBM AI Fundamentals certified. I use AI tools to accelerate analysis workflows — prompt engineering, AI-assisted EDA, and intelligent tool chaining. Ready for the modern data team environment.
Background

Education & Certifications

B.Com Honours
Aptech Learning
Certifications
Self-Built Projects
B.Com — Accounts & Finance Honours
Lalit Narayan Mithila University
2021 – 2025 · Darbhanga, Bihar
  • Graduated with specialisation in Accounts, Finance, Taxation, and Business Economics
  • Strong foundation in financial statements, cost accounting, and banking concepts directly applicable to BFSI analytics roles
  • Complemented academic coursework with self-directed learning in SQL, Python, and data analysis tools throughout degree tenure
Data Analytics Certification Program
Aptech Learning, Konnagar
2025 – Present · West Bengal
  • Intensive program covering the full analytics stack: SQL, Excel, Python, Power BI, and Statistics
  • Practical assignments on real-world datasets with emphasis on business reporting and dashboard creation
  • Developed project-based portfolio work alongside coursework to demonstrate applied skills
Professional Certifications
HackerRank · Simplilearn · IBM SkillBuild
2024 – 2025
  • HackerRank: SQL Basic, Intermediate, and Advanced — covering complex queries, optimisation, and window functions
  • Simplilearn: Power BI for Business Intelligence — DAX, reports, and dashboard publishing
  • Simplilearn: Python for Data Science — Pandas, NumPy, Matplotlib
  • IBM SkillBuild: Data Analytics Fundamentals and AI Fundamentals
SQL Advanced Power BI Python DS IBM Data Analytics IBM AI Fundamentals
Independent Portfolio Projects
GitHub: itsPRIYANSHUUU
Jan 2026 – Present
  • UPI Payment Risk Intelligence — 10-year NPCI macro data, Z-score anomaly detection, Python pipeline
  • Credit Risk Analysis — RBI loan portfolio data, NPA segmentation, Power BI dashboard
  • Customer Churn Model — Fintech cohort analysis, retention signal identification
  • E-Commerce Failure Analysis — SQL root cause analysis, operational bottleneck dashboard
  • Hospital Readmission Analysis & YouTube Trending Algorithm Analysis
Let's Connect

Looking for a Data Analyst
Who Understands Your Business?

I'm actively targeting Data Analyst and Business Analyst roles in BFSI and fintech. If you're hiring — or know someone who is — I'd like to connect.

✉️
Email itspriyanshuuu@gmail.com
💼
LinkedIn priyanshu-sharma
🐙
GitHub itsPRIYANSHUUU
📱
Phone +91 8102858878
Send Me a Message →