Pavan Kumar Magandi

Data Analytics · Financial Risk · Business Intelligence

I turn scattered economic and transaction data into decisions worth trusting.

---

About

Analytics professional with an MBA in Finance & Analytics and 2.5+ years of experience in data analysis, MIS reporting, and business intelligence. This repository hosts the source for my portfolio site — built to showcase work that's meant to be interrogated, not just admired: real datasets, real data-integrity issues found and fixed, and dashboards built for actual decision support.

Highlights:

• 🌍 Built an early-warning sovereign risk model across 183 countries using IMF WEO & World Bank data
• 🧹 Deduplicated 23,149 raw records → 1,627 verified country-year observations, catching 5 distinct data-integrity defects
• 📊 Delivered 6 interactive Tableau dashboards spanning 20+ worksheets and 150+ calculated fields
• 🧠 Wrote 10 PostgreSQL analytical queries using CTEs, window functions, and multi-table joins
• ✅ Backtested the risk model against 3 real sovereign crises (Sri Lanka, Ghana, Pakistan)

Featured Projects

Project	Impact	Tools
🚩 Global Sovereign Risk Dashboard	Early-warning risk model across 183 countries; deduplicated 23K→1.6K records; backtested against 3 real sovereign crises	PostgreSQL, Tableau, Excel, Python
Northwind Traders Sales Analytics	Customer intelligence, logistics benchmarking, and margin visibility dashboards for a retail dataset	SQL, Tableau
Movie Rental Analytics	Customer value, inventory utilisation, staff performance, and revenue trend dashboards	SQL, Tableau
Portfolio Optimisation & Financial Risk Management	10-asset portfolio from a 50-asset universe using CAPM/Efficient Frontier; VaR & Monte Carlo stress testing	Excel

Tech Stack

• Structure & Styling: HTML5, CSS3 (custom, no framework)
• Interactivity: Vanilla JavaScript — scroll-reveal animations, KPI count-up, active nav highlighting, cursor-tracked card spotlight, and a screenshot lightbox gallery
• Fonts: Space Grotesk, Inter, IBM Plex Mono (Google Fonts)

Project Structure

Portfolio_Website/
├── index.html          # Main site markup
├── style.css            # All styling
├── script.js             # Scroll reveal, KPI counters, nav, lightbox
└── assets/
    ├── profile-photo.jpg
    ├── Pavan_Kumar_Magandi_Resume.pdf
    ├── dashboards/       # Sovereign Risk Dashboard screenshots
    ├── northwind/        # Northwind Traders dashboard screenshots
    └── movierental/      # Movie Rental Analytics dashboard screenshots

Running Locally

No build step required — it's a static site.

git clone https://github.com/PavanKumarMagandi/Portfolio_Website.git
cd Portfolio_Website

Then simply open index.html in a browser, or serve it locally:

python -m http.server 8000

Visit http://localhost:8000 in your browser.

Deploying with GitHub Pages

1. Go to Settings → Pages in this repository.
2. Under Source, select the main branch and / (root) folder.
3. Save — your site will be live at https://pavankumarmagandi.github.io/Portfolio_Website/.

Contact

📍 Rajahmundry, India · 📞 +91-8143233934 · ✉️ pavanmagandi@gmail.com · 🐙 @PavanKumarMagandi

---

⭐ If you found this portfolio interesting, consider giving the repo a star!