Skip to content
View GauravN471's full-sized avatar

Block or report GauravN471

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
GauravN471/README.md

Hi, I'm Gaurav Nikam 👋

Data Analyst · SQL · Power BI · Excel · Bloomberg Terminal
📍 Pune, India  |  💼 Open to Data / MIS / BI / Finance Analyst roles


👨‍💼 About Me

I'm a Data Analyst with 14 months of professional experience at Wipro, where I worked on ESG data operations for 1,700+ global companies using Bloomberg Terminal — maintaining 90%+ QA accuracy on structured financial data workflows.

I hold an Masters in International Business & Finance from the University of Dundee, UK, and have completed virtual internships with PwC Switzerland and Accenture via Forage.

I build end-to-end analytics solutions — from SQL queries and Excel P&L models to multi-view Power BI dashboards — and translate raw data into decisions that businesses can act on.


🛠 Tech Stack


📌 Featured Projects

Project Tools What I Built
📊 Business Insight 360 Power BI · DAX · SQL 5-view enterprise dashboard on 1.8M rows — Finance, Sales, Marketing, Supply Chain, Executive
🔍 AtliQ SQL Business Insights MySQL · CTEs · Window Functions 10 executive business questions answered on 1M+ sales records
🏨 Hospitality Revenue Analytics Power BI · DAX RevPAR / ADR / Occupancy % KPI dashboard — 13 hotels
💰 Financial P&L Analytics Excel · Power Query · Power Pivot P&L report suite — GM% by market, fiscal year & quarter
📈 Sales Performance Analytics Excel · Pivot Tables 8-report sales suite — customer, division, market vs target
🎵 Music Store SQL Analysis PostgreSQL · CTEs · Window Functions 11 business queries — genre trends, customer spend, regional analysis

🏢 Virtual Internships

Company Focus Link
PwC Switzerland Power BI call centre KPI dashboard — telecom client View Repo
Accenture Social Buzz content analytics — IPO data audit & stakeholder presentation View Repo

🎓 Education & Background

  • 🎓 Master's in International Business & Finance — University of Dundee, UK
  • 🏢 Data Analyst — Wipro (14 months · Bloomberg ESG · 1,700+ companies)
  • 📜 Certifications: Power BI · SQL · Excel — Codebasics

📊 GitHub Stats


📫 Let's Connect

I'm actively looking for Data Analyst / MIS / BI / Finance Analyst roles in Pune, Bangalore, Hyderabad or Remote.


"Turning raw data into decisions that businesses can act on."

Pinned Loading

  1. Business_Insight_360 Business_Insight_360 Public

    5-view Power BI suite on 1.8M rows — Finance, Sales, Marketing, Supply Chain & Executive

  2. AtliQ_SQL_business_insights AtliQ_SQL_business_insights Public

    10 SQL business queries — CTEs, window functions, joins on 1M+ sales records

  3. PWC-virtual-internships-dashboard- PWC-virtual-internships-dashboard- Public

    PwC Switzerland x Forage — Power BI call centre KPI dashboard for telecom client

  4. Hospitality-Domain-Analytics-Revenue-Performance Hospitality-Domain-Analytics-Revenue-Performance Public

    RevPAR / ADR / Occupancy % KPI dashboard — 13 hotels, Power BI + DAX

  5. Financial-analysis-project Financial-analysis-project Public

    Excel P&L report suite — GM% by market, fiscal year, month & quarter

  6. Accenture-virtual-internship- Accenture-virtual-internship- Public

    Accenture x Forage — Social Buzz content analytics & IPO data audit