Swadhin Kumar
Data Analyst | Power BI · Python · SQL · Excel
Hire this person
Send a job offer directly to this candidate
About
Data Analyst combining hands-on internship experience building end-to-end analytics in Python, Power BI and SQL with 12 years of retail business operations running my own grocery store. Delivered a fixed-income risk platform covering 300 bonds and 6 currencies — Monte Carlo VaR, yield-curve modelling, 50 DAX measures and 74 automated tests — and I bring a shopkeeper's instinct for margins, stock and cash flow to every dataset.
Experience
Data Analyst Intern at Zetheta Algorithms Private Limited (2026-10 – 2026-10)
Bond Portfolio Risk Analytics & Gamified Bond Risk Lab (confidential project)
- Priced a 300-bond, ₹3.21 Cr multi-currency portfolio (6 currencies, 44 attributes) in Python — price, Macaulay/Modified Duration, convexity, DV01, OAS and key-rate duration, verified against benchmark values.
- Fitted yield curves (Nelson-Siegel, cubic spline) on 264 daily observations; decomposed curve moves into level, slope and curvature factors via PCA.
- Designed a 1,000-scenario Monte Carlo engine producing VaR(99%) ₹25.17 L and Expected Shortfall ₹29.99 L, validated with Kupiec backtests (95%/99%) and a delta-gamma cross-check within 5%.
- Delivered the reporting layer as a Power BI star schema with 50 DAX measures plus a multi-sheet Excel validation workbook; trained RF/XGBoost/PyTorch models with SHAP explainability and replicated the analysis in R (test-set R² 0.97–0.99).
- Wrote 74 automated pytest tests across analytics, model, benchmark and reconciliation suites; 11 documented commits on a private repository.
Entrepreneur & Proprietor at Self-Employed Grocery Retail (2014 – 2026)
Family grocery store, full operations ownership
- Ran end-to-end retail operations for 12 years: procurement and vendor negotiation, stock replenishment cycles, pricing, daily cash handling and manual accounting of sales and customer credit (khata).
- Managed inventory across fast- and slow-moving categories, adjusting purchase volumes to seasonal demand and shelf-life limits to control waste and keep working capital moving.
- Handled customer relationships, staff scheduling and month-end reconciliation — the margin, stock-turn and cash-flow instincts I now apply analytically in retail and e-commerce datasets.
Freelance Copy Checker at Physics Wallah (2026-02 – Present)
Study-material proofreading, ongoing
- Review and correct study-material copy to accuracy and formatting standards, delivering every assigned batch on or before deadline.
Education
Bachelor of Science (B.Sc.) – T.N.B. College, Bhagalpur (2014 – 2017)

