Summary
Overview
Work History
Education
Skills
Websites
Certification
Project
Extracurricular Activities
Languages
Timeline
Generic

Prashant Bhardwaj

New Delhi

Summary

Aspiring Data Analyst with hands-on experience in fraud detection using SQL and Excel. Successfully built a rule-based system to analyze banking transactions, flag suspicious activity, and present insights through dashboards. Strong foundation in data cleaning, logic building, and reporting. Highly motivated, quick learner, and ready to contribute to real-world business solutions.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Transactional Analyst – Cigna Process

Concentrix
01.2022 - 01.2024
  • Handled U.S. medical billing and claims analysis using Excel.
  • Managed high-volume customer calls as part of the SDA team, ensuring accurate claim resolutions and strong client communication.

Business Partner

Prashant & Rishi Teck-source
New Delhi
07.2017 - 12.2021
  • Managed sales of computer peripherals and software.
  • Used Excel to analyse sales trends, identify reasons for drop-offs, and improve business performance.
  • Helped build a community-driven gaming platform tailored to customer needs.
  • Co-founded the business and led technical operations until closure due to COVID-19.

Education

Bachelor’s - Computer Applications

Trinity Institute of Professional Studies (IP University)
Dwarka sec-9
08-2017

Skills

  • MySQL database management
  • Data analysis
  • Time management
  • Problem solving
  • Excel data analysis
  • Power BI visualisation

Certification

  • Google data analytics cert
  • SQL bootcamp zero to hero by josh portlia (udemy)
  • SQL basic hacker rank

Project

Fraud Detection in Banking Transactions using SQL & Excel

  • Analysed a dataset of 500+ customer transactions to detect fraud patterns based on amount thresholds, account balance, and transaction frequency using MySQL.
  • Identified 120+ high-risk transactions where amounts exceeded ₹50,000 or post-transaction balances dropped below ₹1,000, signalling potential fraudulent activity.
  • Designed an Excel dashboard with pivot tables and conditional formatting to visualise suspicious activities by customer, location, and transaction type.

Extracurricular Activities

Esports Tournament Participant, Competed and won in online LAN tournaments for games like Counter-Strike and Valorant, showcasing strategic thinking, quick decision-making, and collaboration under pressure.

Languages

English, fluent

Timeline

Transactional Analyst – Cigna Process

Concentrix
01.2022 - 01.2024

Business Partner

Prashant & Rishi Teck-source
07.2017 - 12.2021

Bachelor’s - Computer Applications

Trinity Institute of Professional Studies (IP University)
Prashant Bhardwaj