Anlai Shi Email and Phone Number
Hi everyone, I’m Anlai. I am a Data Analyst at Polen Capital. I graduated from Boston University’s Mathematical Finance program in January 2023.I have extensive experience in Machine Learning and Big Data Analysis in the Investment Management industry, focusing on data-driven insights and solutions for decision-making. I'm a collaborative team player with strong communication skills, eager to learn and contribute.· Skills:· Programming: Skilled in SQL, Python (Pandas, NumPy, Matplotlib, PyTorch), R, Excel, and Matlab· Data Visualization: Proficient in PowerBI for creating insightful visualizations· Market Data Systems: Exposure to Bloomberg and FactSet.· ETL & Data Warehousing: Familiar with ETL processes and data warehouse design, including experience with Microsoft SQL Server, Snowflake, Kimball Methodology, and Azure Data Factory· Agile & CI/CD Experience: Competent in Agile environments and applying CI/CD principles to enhance workflow efficiency.I enjoy playing tennis, hiking, swimming, skiing, and snowboarding.Thanks for dropping by my profile.
Sprague Operating Resources Llc
View- Website:
- polencapital.com
- Employees:
- 114
-
Quantitative Portfolio AnalystSprague Operating Resources LlcBoston, Ma, Us
-
Data AnalystPolen Capital May 2024 - PresentBoston, Massachusetts, United States1. Developed and maintained Python scripts and applications supporting Azure Data Factory (ADF), Azure Storage Explorer, and complex SQL statements in Snowflake, ensuring efficient and reliable data processing and storage2. Assisted with ad hoc client requests and collaborated closely with the team to deliver customized solutions that met specific data reporting needs3. Collaborated with the data warehouse team to analyze, prepare, and export data from the warehouse to external client reporting systems4. Supported month-end data processing, ensuring accurate and timely completion every month5. Developed and optimized processes for data intake, validation, mining, and output, enhancing efficiency6. Created and implemented quality controls and standards to meet organizational expectations7. Proactively sought opportunities to automate and improve data processes8. Collaborated with Polen Capital teams to drive discovery and requirements gathering for data management and business analytics efforts -
Data AnalystEdenred Jan 2023 - May 20241. Designed an AI-based Chatbot using NLP and intent recognition techniques, developed in Python2. Extracted data from SQL Server, made API calls, and utilized Databricks for data preparation, employing Python, SQL and stored the output file in the Azure Storage Account via Data Lab3. Assisted the Marketing team with various campaigns by providing data to target direct clients with the highest potential for re-engagement on the ordering platform4. Analyzed client data using SQL and Python and designed various Power BI dashboards to highlight ordering volume, participation rates and activity patterns, and presented recommendations to the manager in alignment with business goals5. Developed detailed reports, including Monthly Business Reviews, Participant Number Reports, Revenue Generating Reports, Engagement Activity Report, and Quarterly Operational Report6. Collaborated with the IT team to resolve JIRA tickets, writing complex SQL queries to explore the database and reduce workload by 20% -
Data Analyst InternAnda Real Estate Llc May 2022 - Aug 2022Cambridge, Massachuset, United States1. Researched rental market trends in the Boston area to find potential growth opportunities and give business recommendations 2. Analyzed over 20k+ rental property, tenant, and landlord records using SQL queries to identify the total addressable market across 3 regions in the Boston area, resulting in a 17% increasing in customer acquisition3. Developed predictive models using regression analysis to forecast rental income and access the influence of key factors4. Created dashboards of 7 years of market data using Power BI and presented results to the Marketing Manager -
Undergraduate Teaching AssistantStony Brook University Sep 2020 - May 2021Stony Brook, New York, United States1. Provided tutoring sessions for students on the principles of macroeconomics and microeconomics2. Liaised with students and professors to improve teaching methodologies -
Quantitative Analyst InternHuatai Securities Co., Ltd. Jun 2020 - Aug 20201. Analyzed information about the industries and exam-related economic and financial factors of stocks, summarized the factors that would influence stocks (fundamental analysis), discussed in the daily meeting2. Utilized Black-Scholes valuation models to value stocks and bonds (Python), estimated the P/L of the valuation model, wrote stock analysis report and made stock selection suggestions to investors3. Conducted literature survey about the effectiveness of the Fama-French three factors model on China’s A-share market4. Analyzed regression results by the CAPM model and Fama-French model, implied stronger excess returns from small market capitalization stocks -
Risk Analyst InternBank Of China Jul 2019 - Aug 2019Dalian, Liaoning, China1. Visited factories with the account manager to better understand the company’s operations2. Collaborated with manager to analyze business prospects used to evaluate corporate creditworthiness3. Assisted account manager to prepare credit proposal
Anlai Shi Education Details
-
Financial Mathematics
Frequently Asked Questions about Anlai Shi
What company does Anlai Shi work for?
Anlai Shi works for Sprague Operating Resources Llc
What is Anlai Shi's role at the current company?
Anlai Shi's current role is Quantitative Portfolio Analyst.
What schools did Anlai Shi attend?
Anlai Shi attended Questrom School Of Business, Boston University, Stony Brook University.
Who are Anlai Shi's colleagues?
Anlai Shi's colleagues are Matthew Shirilla, Alyssa Keith, Nasim Choudhury, Jill Forgea, Samuel Oppe, Murat Gülboy, Paul Williams.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial