Market Research Data Modeling
Resume:
YIFAN NI
+1-646-***-**** ******@********.*** linkedin.com/in/yifan-ni-bbaa4128b
EDUCATION
Columbia University
Master's, APPLIED ANALYTICS
University of California - Davis
September 2023 - January 2025
Bachelor's, Applied Mathematics
September 2018 - June 2022
PROFESSIONAL EXPERIENCE
Zhongtai Securities
Assistant Analyst
Shanghai, China
June 2024 - August 2024
•
•
•
•
•
Tie Neng Construction Engineering Co.
Generated comprehensive industry reports by organizing and analyzing extensive financial datasets using advanced Excel functions and data analysis tools like Wind, providing actionable insights. Reviewed financial data of clients through the implementation of streamlined data handling processes, ensuring accurate and timely evaluation.
Enhanced strategic project planning and execution by assisting in the development of detailed project proposals through synthesizing complex data, improving committee decision-making. Facilitated data-driven decisions and ensured project alignment with business objectives by collaborating effectively with cross-functional teams using data modeling techniques. Enhanced project deliverables and strategic impact by actively pursuing professional development opportunities in financial analytics and market research, including training in Tableau, SQL, and Salesforce. Assistant Analyst
Shanghai, China
Janaury 2021 - September 2023
•
•
•
•
•
Uncovered significant market trends by leading a dynamic team in a comprehensive three-month market research project, analyzing extensive client feedback data using SQL and Excel. Reduced issue resolution time by establishing an efficient data anomaly handling process with daily monitoring, ensuring seamless and stable business operations.
Enhanced operational efficiency by executing and analyzing multiple A/B tests using SQL and Excel, proposing impactful optimization recommendations.
Improved cross-departmental insights by crafting detailed market analysis reports and regularly presenting strategic recommendations to various company departments.
Optimized data handling processes by implementing strategies using Visual Studio and Netsuite, leveraging ERP systems and data modeling techniques to enhance data accuracy. MATLAB Programming Project
PROJECTS & ACADEMIC EXPERIENCE
Team member
Davis, CA, USA
May 2022 - June 2022
•
•
Data Visualization: Tableau Project
Enhanced image classification accuracy by 15% through collaboration with a team to design and implement an app for automatic image identification and classification using MATLAB, leveraging deep learning datasets. Streamlined data processing workflows by utilizing Python to incorporate advanced data modeling techniques into app development, enhancing efficiency.
Business Intelligence Analyst
New York, NY, USA
Enhanced stakeholder understanding and decision-making by developing interactive dashboards and compelling infographics using Tableau's advanced features as part of a comprehensive data visualization initiative. Pinpointed and analyzed critical organizational challenges by leading a Tableau project focused on identifying challenges through data modeling and analysis, crafting strategic solutions. Supported informed decision-making across the organization by utilizing Excel and SQL to prepare and analyze datasets for visualization in Tableau.
October 2023 - December 2023
•
•
•
Skills: Adept in MATLAB, R, Python, Tableau, Business Analytics, MySQL, Microsoft Office Languages: Fluent in
SKILLS & LANGUAGES
Japanese, Chinese
Contact this candidate