Sayan Kumar Mandal
Jersey City,NJ
Summary
Data-driven Analyst with 3+ years of experience in Risk Analytics, Business Intelligence, and Fraud Prevention. Skilled in data extraction, transformation, and visualization using SQL, Python (Pandas, NumPy, Scikit-learn), Power BI, and Tableau. Adept at identifying fraudulent transactions, developing data-driven insights, and optimizing business processes. Currently pursuing an M.S. in Business Intelligence and Analytics at Stevens Institute of Technology.
Overview
3
3
years of professional experience
Work History
Risk Specialist
Amazon Pvt Ltd
Hyderabad, India
10.2020 - 07.2023
- Led and managed four teams (16+ analysts) in risk management, fraud detection, and operational efficiency enhancements
- Analyzed and optimized transaction data using SQL, Python (Pandas, NumPy, Matplotlib) to detect fraud and prevent revenue leakage
- Designed and implemented advanced data models and fraud detection algorithms, reducing fraudulent transactions by 20%
- Automated data extraction and validation processes, decreasing manual effort by 30% and increasing team productivity by 15%
- Conducted risk assessments and monitored fraudulent activity using Amazon’s proprietary tools (Paragon, SILS, Fence)
- Created real-time dashboards using Power BI and Tableau, providing deep data insights for process improvement and risk management strategies
- Collaborated with data science, compliance, and engineering teams to refine fraud detection methodologies and improve fraud-prevention workflows
- Led operational enhancements, implementing Standard Operating Procedures (SOPs) that streamlined fraud detection processes, reducing false positives by 18%
Data Analyst Intern
Glossary IT Solutions
06.2019 - 06.2019
- Conducted data mining and statistical analysis using SQL to identify customer trends
- Automated reporting processes, reducing manual data processing time by 30%
Data Analytics Intern
Tech Tychon IT Solutions
06.2018 - 06.2018
- Assisted in cleaning and analyzing large datasets using Python (Pandas, NumPy) and SQL
- Developed automated reporting dashboards in Tableau, enhancing business intelligence insights
Education
Master’s - Business Intelligence and Analytics
Stevens Institute of Technology
01.2025
Bachelor of Technology - Computer Science
Sreenidhi Institute of Science & Technology
01.2020
Skills
- Data Analysis
- Exploratory Data Analysis (EDA)
- Data Wrangling
- Data Cleaning
- Data Mining
- ETL
- Feature Engineering
- Programming Languages
- Python
- Pandas
- NumPy
- Scikit-learn
- Matplotlib
- R
- C
- SQL
- Databases
- PostgreSQL
- MySQL
- Oracle DB
- PG Admin
- BigQuery
- Data Visualization & BI
- Power BI
- Tableau
- Seaborn
- Machine Learning
- Supervised Learning
- Unsupervised Learning
- Predictive Modeling
- Time Series Analysis
- Anomaly Detection
- Tools
- Jupyter Notebook
- MS Excel
- Pivot Tables
- VLOOKUP
- Macros
- Risk & Fraud Analytics
- Transaction Risk Modeling
- Fraud Prevention
- Pattern Recognition
- Trend Analysis
Projects
Physical Health Record System (Data Encryption & Security), Developed a secure health record platform using Python and SQL, implementing encryption methods to ensure patient data security. Online Voting System (Data Integrity & Real-Time Analytics), Designed a digital voting system with real-time data analytics and security features, utilizing SQL and Power BI for insights. Hale – AI-Based Mental Health Analysis (Ongoing Project), Creating an AI-driven mental health prediction model using NLP to assess mental well-being trends and generate reports.
Certifications Training
Google Data Analytics.
Google Project Management.
Google IT Support.
Google IT Automation with Python.
Google UX Design.
Google Advanced Data Analytics.
Google Cybersecurity.
Google Business Intelligence.
Google Agile.
Affiliations
- Represented the college at the All India Smart Hackathon organized by the Ministry of Micro, Small & Medium Enterprises (MSME) in 2018.
- Actively participated in the Inter-College Basketball Tournament as a representative of the college from 2017 to 2019.
- Volunteered, managed, and organized Excelsior MUN, one of the largest Model United Nations conferences in South India, from 2017 to 2020.
Accomplishments
- Achieved 1st place while representing the college in an Inter-College Hackathon Competition.
- Competed in multiple Inter-College Basketball Tournaments, earning several awards for outstanding performance.
- Honored with numerous accolades at Amazon, including the "Best Employee" award, in recognition of exceptional contributions and performance.
Timeline
Risk Specialist
Amazon Pvt Ltd
10.2020 - 07.2023
Data Analyst Intern
Glossary IT Solutions
06.2019 - 06.2019
Data Analytics Intern
Tech Tychon IT Solutions
06.2018 - 06.2018
Master’s - Business Intelligence and Analytics
Stevens Institute of Technology
Bachelor of Technology - Computer Science
Sreenidhi Institute of Science & Technology
Similar Profiles
KEERTHISHREE H SKEERTHISHREE H S
FinOps Analyst - AP at Amazon Pvt LtdFinOps Analyst - AP at Amazon Pvt Ltd
Saniya SiddiqueSaniya Siddique
FinOps Analyst - AP at Amazon Pvt LtdFinOps Analyst - AP at Amazon Pvt Ltd
Karthik KumarKarthik Kumar
Human Resources Administrator at Amazon Pvt LtdHuman Resources Administrator at Amazon Pvt Ltd
Santosh PandeySantosh Pandey
Operation Manager – UK MKPL-Belgium at Amazon Pvt LtdOperation Manager – UK MKPL-Belgium at Amazon Pvt Ltd
Rena SinghRena Singh
Assistant Coach at University Academy Charter High SchoolAssistant Coach at University Academy Charter High School