Summary
Overview
Work History
Education
Skills
Websites
Recognition
Timeline
Generic

NIHARKIA KATIPELLY

Bengaluru

Summary

Dynamic Senior Data Analyst with 3.7 years of total expercience, specializing in Python, Dashboarding and SQL. Achieved a 70% reduction in manual efforts through innovative data solutions and enhanced fraud detection, showing great stakeholder management and showcasing strong analytical skills and effective communication. Proven track record in driving impactful results in banking and e-commerce analytics.

Overview

3
3
years of professional experience

Work History

Senior Data Analyst

Razorpay
04.2023 - Current
  • Streamlined ED/LEA data requests through automation using Databricks, Python, and SQL, reduced the team's efforts by 70%.
  • Performing impact assessment and RCA for the product changes.
  • Identified opportunities for automation, which reduced bandwidth of stakeholders by up to 40%.
  • Developed a comprehensive dashboard consolidating all metrics, saving 50% of the time previously spent on weekly and monthly reviews.
  • Contributing to OKRs:

1. Enhancing shield rules, which led to a reduction of risk declines by 15%.

2. Revamping transaction monitoring alert criteria, reducing false positive alerts by 35%, and conserving operational bandwidth.

3. Resolved dashboard issues by creating Directed Acyclic Graphs (DAGs), and optimizing SQL queries.

Ecommerce - Data Analyst

ADA India
Bengaluru
01.2023 - 03.2023
  • Comprehensive Overview Dashboard of Click Stream Data on the Client Platform.
  • Executed an in-depth root cause analysis of anomalous transactional behavior across e-commerce, pharmacy, and airline sectors, identifying 15+ distinct patterns leading to a 35% reduction in fraudulent transactions within three months.
  • Performing impact assessments for all the product changes and KPIs on a weekly and monthly basis, respectively.

Instant Loan Online Transactions

Govt Agency
01.2022 - 12.2022
  • Initiated a detailed investigation into transactional data patterns associated with money laundering, resulting in the identification of over 150 potentially fraudulent accounts, and collaboration with regulatory teams strengthened anti-money laundering compliance.
  • Designed and executed a comprehensive data cleansing framework that processed over 1M records, ensuring compliance with data quality standards; this framework is now adopted by 10+ teams for ongoing data management efforts.
  • Conducted correlation analysis on transactional trends and criminal behavior across 15+ companies, identifying key patterns that informed strategic decision-making and enhanced risk assessment protocols for future operations.
  • Developed and delivered over 15 comprehensive reports analyzing anti-money laundering data, which provided critical insights and facilitated informed decision-making on more than 35 cases of suspected financial misconduct.

Education

Bachelor Of Science - MSCs., Mathematics, Statistics, Computer Science

Osmania University
10.2020

Professional Data Science Program - Data Science & AI

08.2020

Skills

Skills: Python, SQL, R, Machine Learning

, Numpy, Pandas, Excel, PySpark, Sklearn, Matplotlib, Seaborn, Regression, Classification, and Time Series

Tools: Databricks, Queerybook, DBeaver, Google Sheets, Google Docs, Power BI, Looker, Tableau, PowerPoint,Snowflake

Recognition

  • Distinguished Service Award, Enforcement Directorate, 2022
  • MVP Award - Analytics, 02/24

Timeline

Senior Data Analyst

Razorpay
04.2023 - Current

Ecommerce - Data Analyst

ADA India
01.2023 - 03.2023

Instant Loan Online Transactions

Govt Agency
01.2022 - 12.2022

Bachelor Of Science - MSCs., Mathematics, Statistics, Computer Science

Osmania University

Professional Data Science Program - Data Science & AI

NIHARKIA KATIPELLY