# Charan Shivaram

Charan Shivaram is a remote worker on Himalayas, Analytics Specialist at Razorpay, based in India.

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

```text
Payments data analyst at Razorpay who built monitoring pipelines and uncovered ₹1.5 Cr in late-authorised payments.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 2500k+ INR |
| Job categories | Data Analyst, Payments Analyst, Analytics Specialist |
| Skills | Data Analysis, Payments Analytics, SQL, Trino, Redshift, Python, Airflow, Tableau, Looker, Power BI, Metabase, Anomaly Detection, Root Cause Analysis, Funnel Analysis, A B Testing |
| LinkedIn | https://linkedin.com/in/charanshivaram |

## About

```text
At Razorpay, I built an automated GMV monitoring pipeline that compares each in-store merchant against 28-day baselines, ranks alerts by severity, creates tickets for owners, and posts daily summaries to Slack.

I also built a Python pipeline that classifies POS support tickets with an LLM, and onboarded two product domains to Razorpay’s AI self-serve analytics platform with a 17-metric catalogue.

My payments analysis uncovered ₹1.5 Cr in late-authorised payments that banks auto-refunded across 950+ merchants. I independently rebuilt the numbers to challenge a bank’s ₹1.8 Cr claim, and flagged anomalies including a UPI routing misconfiguration behind 90% of monthly QR failures.

For a platform migration, I built a seven-stage Airflow pipeline and multi-bank Tableau dashboards, pre-validating 15,000+ merchants and catching 190K+ record discrepancies before go-live. Earlier, at Polco Maven, I built web-scraping and NLP insight reports using Python, NLTK, and SpaCy.
```

## Experience

### Analytics Specialist (current)

[Razorpay](https://himalayas.app/companies/razorpay). Jun 2023 - Present

```text
Built automated monitoring pipelines and AI-driven analytics tools for payments, uncovering significant revenue leaks and improving operational efficiency. Led onboarding of product domains onto self-serve analytics and built dashboards for platform migrations.
```

Skills: SQL, Python, Tableau, Airflow, AI-Agents, LLM, Freshdesk, Slack, UPI, Cards, QR決済, Reconciliations, KYC, Anomaly-Detection, Root-Cause-Analysis, A-B-Testing

### Data Science Intern

Polco Maven. Feb 2023 - Jun 2023

```text
Built web scraping and NLP insight reports using Python, NLTK and SpaCy.
```

Skills: Python, NLTK, SpaCy, Web-Scraping, NLP

### Data Analyst Trainee

AlmaBetter. Jun 2022 - Dec 2022

```text
Developed expertise in feature engineering, EDA and data visualisation using Power BI and Tableau. Completed projects and SQL case studies, ranking in the top 5% among 400 students.
```

Skills: Feature-Engineering, EDA, Data-Visualization, Power-BI, Tableau, SQL

## Education

### AlmaBetter

Data Analyst Trainee, Data Analytics. 2022 - 2022

Activities and societies: Ranked in the top 5% among 400 students, leading to an opportunity as a Subject Matter Expert (SME).

```text
Completed a Data Analyst training program, developing expertise in feature engineering, EDA, and data visualization using Power BI and Tableau.
```

### University of Agricultural Sciences, Bengaluru

Bachelor of Technology, Agricultural Sciences

```text
Completed a Bachelor of Technology degree from the University of Agricultural Sciences, Bengaluru in 2020.
```

## Tech stack

- Tableau
- Looker
- Metabase
- Python
- NLTK
- SpaCy
- Git
- Airflow
- SQL
- Trino
- Power BI
- Claude

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

## People also viewed

- [Gunal Krish](https://himalayas.app/@gunalkrish): AI Powered Data Analysis Intern, Excelerate
- [Balaji Reddy](https://himalayas.app/@balajireddy1): Business Analyst Traineeship, MedTourEasy
- [Arunima Rai](https://himalayas.app/@arunimarai1): Team Lead, Data Analyst, Paytm
- [Sanjana Goyat](https://himalayas.app/@sanjanagoyat): Data Analyst Business Finance, Razorpay
- [Animesh Trivedi](https://himalayas.app/@animeshtrivedi): Associate Technical Consultant, Razorpay
- [Ujjwal Kharayat](https://himalayas.app/@ujjwalkharayat): Data Analyst, Airtel Payments Bank
- [Bhoumesh Kumar Dutta](https://himalayas.app/@bhoumeshkumardutta1): Data Analyst Intern, Techcoder Software (OPC) Pvt. Ltd.
- [Sahithi Pendyala](https://himalayas.app/@sahithipendyala): Analyst, Genpact
- [Yash Soni](https://himalayas.app/@yashsoni7): Data Analyst Intern, Zero to One AI Product Studio
- [omkar shelke](https://himalayas.app/@omkarshelke1): Machine Learning Intern, Techqkonnect