# Pranay Shrivastava

Pranay Shrivastava is a remote worker on Himalayas, Marketing Analytics Dashboard at GitHub, based in Zimbabwe.

Source: https://himalayas.app/@pranayshrivastava

```text
Data Analyst skilled in SQL, Power BI, and Python—turning marketing and customer data into actionable insights.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Zimbabwe |
| Authorized to work in | Zimbabwe |
| Job categories | Data Analyst, Business Intelligence, Marketing Analytics, Business Analytics, Customer Data Analytics, Analytics Analyst, Data Analytics Specialist, Data Analyst |
| Skills | Microsoft Office, SQL, Power BI, Excel, Python, DAX, Power Query, Data Modeling, ETL, EDA, Data Cleaning, Data Preparation, Data Validation, data transformation, Data Manipulation, Data Extraction, Statistical Analysis, Business Analysis, Market Research, Problem Solving, KPI Design, Business Intelligence, Funnel Analysis, Customer Segmentation, Trend Analysis, Revenue Analytics, Requirements Analysis, Dashboard Development, Data Visualization, Business intelligence reporting, Interactive Sales Dashboards, Executive Reporting, KPI Reporting, DBMS, NLP, Sentiment Analysis, ChatGpt, Gemini, GitHub, Agile, Remote Team, Data And Research, Generative AI tools |

## What I'm looking for

```text
I’m looking for a junior Data Analyst role where I can build SQL + Power BI dashboards, analyze customer and marketing funnels, and turn data into clear, actionable recommendations in an Agile team.
```

## About

```text
I’m a Data Analyst with hands-on experience in Business Intelligence, Data Analytics, and Business Analytics, using SQL, Power BI, Excel, and Python to analyze large datasets and support data-driven decision-making. I’ve worked across end-to-end analytics—from data cleaning and transformation to KPI analysis, funnel insights, and stakeholder-ready reporting.

In my client-facing Digital Marketing Analytics engagement as a Data Analyst Intern, I analyzed 52K+ campaign records to identify customer behavior, acquisition patterns, and campaign performance insights. I built interactive Power BI dashboards and BI reports, and conducted data cleaning, validation, and marketing funnel analysis to uncover conversion drop-offs and recommend improvements. I also developed analytics projects covering marketing/customer engagement (including Python-based NLP sentiment analysis), banking customer risk/financial behavior segmentation, and sales performance intelligence with BI dashboarding and revenue trend insights.
```

## Experience

### Marketing Analytics Dashboard

[GitHub](https://himalayas.app/companies/github). Mar 2026 - Apr 2026

```text
Built a marketing analytics and customer engagement dashboard analyzing 38K+ customer interaction records to evaluate campaign effectiveness and identify user abandonment across conversion stages. Used Python-based sentiment analysis (NLP) and created interactive Power BI dashboards for campaign monitoring, retention, and conversion-focused reporting.
```

Skills: SQL, Power-BI, Python, Excel, NLP, Sentiment-Analysis, Data-Visualization

### Data Analyst Intern

Trigunasoft. Mar 2025 - Oct 2025

```text
Collaborated on a client-facing Digital Marketing Analytics engagement, analyzing 52K+ campaign records using SQL, Power BI, and Excel to identify customer behavior, business trends, and campaign performance insights. Performed data cleaning/transformation/validation and marketing funnel analysis across 216K impressions to 25.4K clicks to 1.3K purchases, and built interactive Power BI dashboards a
```

Skills: Agile, SQL, Power-BI, Excel, Data-Cleaning, data-transformation, Data-Validation, Funnel-Analysis, Marketing-Analytics, KPI-Analysis, Dashboarding

### Banking Risk Analytics Project

[GitHub](https://himalayas.app/companies/github). Jul 2025 - Aug 2025

```text
Analyzed 24K+ financial customer records to study borrowing behavior, repayment trends, and credit exposure, and built risk segmentation models using credit utilization and loan-to-deposit ratios. Designed Power BI risk intelligence dashboards to support credit evaluation and portfolio/biz risk assessment, including identifying a high default-probability segment where loan-to-deposit ratio exceeds
```

Skills: SQL, Power-BI, Excel, Python, Credit-Utilization-Analysis, Loan-To-Deposit-Ratio-Analytics, Data-Modeling, Dashboard-Development

### Sales Performance Intelligence

[GitHub](https://himalayas.app/companies/github). Apr 2025 - May 2025

```text
Processed 1.2B+ commercial sales data to analyze revenue performance and profitability across regions and product categories, including identifying that top products drove over 40% of total sales. Conducted trend analysis to uncover 10–12% recurring seasonal demand patterns (May–July) and built Power BI dashboards for regional performance tracking and business planning.
```

Skills: SQL, Power-BI, Excel, Business-Intelligence, Revenue-Analysis, Profitability-Analysis, Trend-Analysis, Dashboard-Development

## Education

### LNCT Group of Colleges

Bachelor of Technology (B.Tech), Artificial Intelligence & Data Science. 2022 - 2026. Grade: CGPA: 7.80

```text
Pursuing B.Tech in Artificial Intelligence & Data Science at LNCT Group of Colleges, Bhopal (2022–2026), with a CGPA of 7.80.
```

### Vandana Convent Sr. Sec. School

Senior Secondary, Senior Secondary Education. Grade: Percentage: 86.2%

```text
Completed Senior Secondary education at Vandana Convent Sr. Sec. School, scoring 86.2%.
```

### Vandana Convent Sr. Sec. School

Secondary, Secondary Education. Grade: Percentage: 92.6%

```text
Completed Secondary education at Vandana Convent Sr. Sec. School, scoring 92.6%.
```

## Tech stack

- GitHub
- Gmail
- Remote Team
- Gemini
- SQL
- Make
- Remote
- ChatGPT

To contact Pranay, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [akriti Suman](https://himalayas.app/@akritisuman): Data Analyst Intern, Elevate Labs
- [Kash Sharma](https://himalayas.app/@kashsharma): Data Analyst, Self Employed
- [ANAND KUMAR](https://himalayas.app/@anandkumar10): Recruiter, Exotic Learning
- [Hashir Khan](https://himalayas.app/@hashirkhan1): Business Data Analyst, Self employed
- [Harshini User](https://himalayas.app/@harshiniuser2): Data Analyst Intern, CodTech
- [Ziad Hamdy](https://himalayas.app/@ziadhamdy1): Data Analysis Intern, UneeQ
- [Lazarus Mapfurira](https://himalayas.app/@lazarusmapfurira): Data Analyst, Kalekt Analytics
- [Bandla Anusha](https://himalayas.app/@bandlaanusha): Certified Data Analyst, Datamites
- [Abul Hasan](https://himalayas.app/@abulhasan1): Data Analyst Intern, Bluestock
- [Manikanta Dannuri](https://himalayas.app/@manikantadannuri): AI Analyst Assistant, GitHub
