Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

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
Kanpur
06.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
Ayush KumarBusiness Analyst