Mohan Zhang Email & Phone Number

- Data analysis & reporting: Extracted and analyzed data from banking databases using advanced SQL queries. Generated comprehensive reports and visualizations in Power BI, providing actionable insights that informed strategic decisions. (ERP, CRM)- Created detailed monthly reports, including, New Onboardings by Month, Fraud Accounts by Branch Channel: Fraud Accounts by Identification Channel. Improved fraud detection processes by examining trends across identification channels.- Quality Control & Performance Evaluation: Conducted quality assessments by evaluating fraud investigators' calls, ensuring compliance with internal standards, and generating performance reports for management review. - Data Process Automation: Automated data integration from multiple sources, including internal banking systems and third-party vendors, using Python scripts, optimized data process by automated code on avg save 86 hours manual work per month.- SSRS Reporting: Developed and maintained SQL Server Reporting Services (SSRS) reports to support the AML and Fraud teams, converting complex SQL queries into easily accessible reports. Key reports included member search and online ID lookup.

United States

- Enabled targeted outreach by utilizing machine learning to analyze user conversations, extracting key topics and generating reports for the marketing team for promotional campaigns, successfully identified user interests and trends.- Enhanced risk management by building real-time visualization system on Tabular to monitor unusual deposit and withdrawal patterns, detecting sudden spikes in deposits or withdrawals, out-of-character transactions for users.- Reduced potential fraud transactions by 30% by building ML random forest model using translation data like deposit frequency, amounts, time of day, etc to predict potential fraud; successfully minimized risks in cryptocurrency exchanges.

- Data Cleaning: Conducted meticulous data cleaning and preprocessing of raw questionnaire data to ensure accuracy and validity for analysis. (Excel, Python)- Consumer Insights: Performed significance testing to identify key trends and validate findings within the data. Supported the preparation of detailed reports, analyzing consumer profiles, product appeal, promotion mechanisms, after-sales performance, and membership status. (Excel)- Sales Insights & Reporting: Compiled findings into comprehensive reports, highlighting key insights such as the most engaging content, underperforming pages, and the impact of different traffic sources on conversion rates. - Ad Effectiveness: Assisted in evaluating the effectiveness of advertising campaigns by analyzing reach, brand asset performance, and content recall.- Data Reporting: Contributed to comprehensive reporting that included key metrics on ad reach, brand reputation, and audience engagement.

• Delivered advanced analysis of the company’s return on investment from 2021 to 2025 by using methods of PE, PS and EV EBITDA to create evaluation & prediction models.• Visualized investment datasets with R using libraries such as ggplot2 and dplyr which assisted downstream users and upper management to grasp a clear view and understanding of company investment status.• Created workflow diagrams and organization charts in Visio for upper management to increase overall productivity and time management for the finance team.

Master'S Degree, Analytics

Bachelor'S Degree, Business Concentrate In Finance And Mis