Pankaj Kumar
Gandhinagar
Summary
Detail-oriented and analytical MBA candidate specializing in Forensic Accounting and Fraud Investigation. Experienced in applying advanced data analytics, including machine learning and forensic tools (IDEA, Python, Tableau), to detect and prevent financial fraud. Proven ability to analyze large datasets for anomalies and develop predictive models, supporting high-quality data analysis and integrity. Seeking a Financial Fraud Analyst role to leverage technical expertise in ensuring regulatory compliance and enhancing data workflows.
Overview
1
1
Certification
Work History
Customer Experience Specialist
Etech
Gandhinagar
11 2022 - 06 2023
- Monitored customer feedback to identify trends, assisting in enhancing product offerings and overall customer experience.
- Implemented customer recognition program that increased repeat business and customer satisfaction.
- Created a knowledge base for staff members that provided quick access to important company information, frequently asked questions, and troubleshooting guides.
- Responded to high volume of incoming calls utilizing listening and communication skills to identify customer problems, needs, and opportunities.
- Negotiated solutions with dissatisfied customers, turning potential negative reviews into positive testimonials.
Financial Fraud Detection with IDEA & Excel
- 05.2025
- Applied Benford's Law, duplicate testing, and gap detection on a dataset of 50,000+ transactions using IDEA, identifying 120+ anomalous entries.
- Utilized stratification and aging analysis to isolate high-risk transactions, streamlining the investigation process.
- Developed an interactive Excel Dashboard with PivotTables, Slicers, and Timelines to visualize key risk indicators.
Tableau Fraud Analytics Dashboard
- 05.2025
- Designed and developed an interactive Tableau dashboard to automate the monitoring of key fraud indicators from processed financial data.
- Integrated multiple data sources to visualize critical metrics, enabling proactive fraud detection.
- Implemented user-friendly filters and parameters to allow investigators to slice data, drastically reducing time needed for initial case assessment.
Power BI Financial Investigation Report
- 05.2025
- Built an end-to-end Power BI reporting solution for a forensic audit case, connecting to and transforming raw transactional data using Power Query.
- Developed a comprehensive executive summary page with KPIs and card visuals to highlight flagged transactions and potential loss exposure.
- Designed drill-through pages to allow users to click on a summary metric and view all underlying transaction details.
Machine Learning for Fraud Prediction
- 05.2025
- Built a predictive ML model using Python (Pandas, Scikit-learn) with Logistic Regression & Random Forest.
- Achieved 94% accuracy in detecting fraudulent activity through model optimization and cross-validation.
- Visualized results and feature importance using Matplotlib to communicate key fraud indicators.
Data Analysis for Anomaly Detection
- 05.2024
- Imported and analyzed large transactional datasets using Python (Pandas, NumPy) to detect irregularities.
- Performed comprehensive data cleaning and transformation using Excel Power Query.
- Created fraud risk scoring models using Excel formulas and conditional formatting to flag suspicious transactions.
Education
MBA - Forensic Accounting and Fraud Investigation
National Forensic Sciences University
Gandhinagar, Gujarat01.2026
Bachelor of Computer Application -
Kadi Sarva Vishwavidyalaya
01.2018
Skills
- Forensic Tools
- Tableau
- Data Cleaning
- Excel
- Predictive Modeling
- Report Writing & Documentation
- Machine Learning
- Dashboard & Slicer Creation
- IDEA
- Python
- SQL
- Fraud Detection Techniques
- Anomaly Detection
- Financial Laws
- Conditional Formatting
- Relationship Building
Certification
- AWS Certified Data Engineer, Amazon Web Services, 05/01/25
- Tableau Desktop Certified, Tableau Software, 05/01/25
- Certified IDEA Data Analyst (CIDA), CaseWare Analytics, 05/01/25
- Power BI Data Analyst, Microsoft, 05/01/25
Hobbies and Interests
- Travelling & Cultural Exploration
- Football
- Cricket
Timeline
Customer Experience Specialist
Etech
11 2022 - 06 2023
Financial Fraud Detection with IDEA & Excel
- 05.2025
Tableau Fraud Analytics Dashboard
- 05.2025
Power BI Financial Investigation Report
- 05.2025
Machine Learning for Fraud Prediction
- 05.2025
Data Analysis for Anomaly Detection
- 05.2024
MBA - Forensic Accounting and Fraud Investigation
National Forensic Sciences University
Bachelor of Computer Application -
Kadi Sarva Vishwavidyalaya