Vijay Kumar
Greater Noida,UP
Summary
Results-driven Business Analyst with 5+ years of experience delivering data-driven insights in fintech and telecom. Proficient in SQL (Hive, Starburst, BigQuery), BI tools (Google Data Studio, Superset), and advanced Excel. Proven track record in building automated dashboards, optimizing business processes, and enabling strategic decision-making. Adept at collaborating with stakeholders to translate complex data into insights that drive merchant retention, revenue growth, and operational efficiency.
Overview
5
5
years of professional experience
3
3
Languages
Work History
Business Analyst
Paytm - ONE97 Communications Pvt Ltd
Noida
07.2023 - Current
- Designed and automated a market-share analytics framework for Paytm’s fuel merchants, built a transaction-level data mart and Looker dashboards.Applied geospatial analytics to identify weak regions and leveraged customer data to target high-value third-party merchants, driving revenue growth.
- Designed and implemented an SQL-based merchant fraud risk framework, creating 10 key fraud-risk parameters and a scoring system to flag high-risk merchants.
- Developed monitoring pipelines and automated alerts to detect suspicious transaction patterns, including odd-hour activity, repeated card usage, and high failed transaction ratios.
- Implemented credit card concentration and usage analysis to identify merchants with unusual card-level transaction patterns, reducing potential fraud exposure.
- Built interactive dashboards in Looker and Google Data Studio, automating daily reports to reduce manual effort by 40%, and provide real-time insights on key metrics.
- Automated recurring data pulls and reporting pipelines in SQL/Hive/Starburst, reducing turnaround time by 30% and freeing analyst capacity for strategic initiatives.
- Supported the User Growth team with pre- and post-campaign analyses of cashback offers, delivering insights on acquisition, retention, and weak areas to optimize strategy.
- Coordinated with Oil Marketing Companies (IOCL, BPCL, HPCL, Shell, Nayara) to automate reporting and provide merchants with clear visibility into transactions, settlements, and charges, improving transparency.
- Calculated and validated partner-bank commissions on transaction GMV, collaborating with the RA team to ensure accurate reporting and timely invoice generation, supporting revenue reconciliation and compliance.
- Managed and analyzed diverse datasets (transactional, configuration, payout, financial, commission) using Hive and Starburst, ensuring data accuracy and supporting business decisions.
- Performed ad-hoc data analyses to investigate operational issues, uncover trends, and provide actionable recommendations.
Data Analyst
Bharti Airtel Africa - Via Startek
08.2018 - 03.2022
- Monitored fraudulent transactions using SQL, SAS, and visualization tools (SAS VA, Google Data Studio).
- Designed and optimized SQL queries for fraud detection, reducing revenue leakage by 5%.
- Created dashboards and reports to analyze transaction trends and identify anomalies.
- Collaborated with international teams across Africa to investigate and close fraud cases.
- Performed data cleansing, standardization, and validation to maintain data integrity.
- Built interactive dashboards in Google Data Studio, automated daily reports to reduce manual effort by 30%, and provide real-time insights on transaction/fraud pattern.
Education
Bachelor Of Engineering - Computer Science And Engineering
SDM College of Engineering And Technology, VTU
Dharwad Karnataka 06.2016
Skills
- SQL: Hive, Starburst, BigQuery, Oracle
- Business intelligence and data visualization: Google Data Studio, Superset
- Spreadsheet and data modeling: Google Sheets, advanced Excel
- Python programming: Basic
- Data analysis techniques
- A/B testing methodologies
Languages
Hindi
Native language
Hindi
Advanced (C1)
English
Upper intermediate (B2)
Technical Skills
- Data mining strategies
- Statistical analysis methods
- Data cleansing processes
Languages
4,B2,6,C2
Timeline
Business Analyst
Paytm - ONE97 Communications Pvt Ltd
07.2023 - Current
Data Analyst
Bharti Airtel Africa - Via Startek
08.2018 - 03.2022
Bachelor Of Engineering - Computer Science And Engineering
SDM College of Engineering And Technology, VTU