Ayush Kumar
Business Analyst
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 (Looker, 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
6
6
years of professional experience
Work History
Business Analyst
ONE97 Communications Pvt Ltd
Noida
08.2021 - 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.
- 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
01.2020 - 08.2021
- Company Overview: via Startek
- 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.
- Via Startek
Education
Bachelor of Computer Application -
CSJM University
Kanpur06.2016
Skills
- SQL databases: Hive, Starburst, BigQuery, Oracle
- Business intelligence and data visualization: Looker Enterprise, Google Data Studio, Superset
- Spreadsheet and data modeling: Google Sheets, advanced Excel
- Python programming: Basic
- Data analysis techniques
- A/B testing methodologies
Languages
Hindi
First Language
Hindi
Proficient (C2)
C2
English
Upper Intermediate (B2)
B2
Timeline
Business Analyst
ONE97 Communications Pvt Ltd
08.2021 - Current
Data Analyst
Bharti Airtel Africa
01.2020 - 08.2021
Bachelor of Computer Application -
CSJM University