Senior Data Analyst & Power BI Developer with 9+ years of experience in Business Intelligence, MIS Reporting, KPI Dashboard Development, and Telecom Analytics.
I specialize in converting complex raw data into actionable insights that drive business decisions for CXO and leadership teams.
- Build enterprise Power BI dashboards analyzing 500K+ records across telecom and logistics
- Automate MIS reporting pipelines using Power Query & DAX — reducing manual effort by 30%+
- Design Star Schema data models with Row-Level Security (RLS) for multi-stakeholder access
- Deliver churn analysis, KPI scorecards, and trend forecasting for strategic business decisions
| Category | Skills |
|---|---|
| BI Tools | Power BI Desktop, Power BI Service, Power BI Gateway |
| Languages | SQL (Joins, Window Functions, CTEs, Stored Procedures), DAX, M (Power Query) |
| Reporting | Advanced Excel, Pivot Tables, VLOOKUP, VBA Macros |
| Data Modeling | Star Schema, Snowflake Schema, ETL, Data Cleaning |
| Analytics | MIS Reporting, KPI Dashboards, Churn Analysis, Telecom Analytics, RLS |
| Other | MS Access, Power Automate, Stakeholder Management |
| Role | Company | Period |
|---|---|---|
| Senior Data Analyst & Power BI Developer | Shyam Spectra Pvt. Ltd., Gurgaon | Jun 2024 – Present |
| Data Analyst Team Lead | DEN Networks Ltd., New Delhi | Sep 2022 – Jun 2024 |
| Data Analyst Executive | Om Logistics Ltd., New Delhi | Feb 2019 – Sep 2022 |
| Audit Executive | Sohanlal Commodity Mgmt. Pvt. Ltd. | Apr 2017 – Feb 2019 |
- ⭐ Built 12+ enterprise Power BI dashboards — adopted as primary BI infrastructure
- ⭐ Automated MIS reporting saving 30%+ manual effort across 20+ stakeholder reports
- ⭐ Best Employee of the Month — DEN Networks Ltd.
- ⭐ Best Employee of the Month — Sohanlal Commodity Management Pvt. Ltd.
- ⭐ Reduced report generation time by 25% through VBA macro automation at DEN Networks
| Project | Tools | Link |
|---|---|---|
| Zomato Sales Analytics Dashboard | Power BI, DAX, Power Query | View → |
| Supply Chain & Logistics Dashboard | Power BI, DAX, Star Schema | View → |
- 🌐 Portfolio: ramkumar-bi.netlify.app
- 💼 LinkedIn: linkedin.com/in/ram-kumar-a52640140
- 📧 Email: rkumar.vgp@gmail.com
- 📍 Location: New Delhi, India | Open to: Delhi NCR, Gurgaon, Noida, Bangalore, Hyderabad, Pune
📌 Note: The PDF resume in this repository is being updated. For the latest version, please visit my Portfolio or connect on LinkedIn.