Bolin(Berlin) Y. Email & Phone Number

Ballwin, Mo, Us

St Louis, Missouri, Us

St. Louis, Missouri, Us

• Performed exploratory data analysis on large customer and agronomic datasets with millions of records, utilizing Python libraries such as Pandas and Numpy to identify significant trends and behaviors. • Maintained data pipelines utilizing Python and AWS, as well as Pyspark and SQL, to collect, process, and deliver large datasets accurately and timely to stakeholders.• Created dashboards to analyze the completeness and coherence between customer's transactional and planting records, resulting in improved decision-making across 10+ teams in the organization.• Optimized a machine learning model to provide actionable recommendations to internal and external stakeholders, resulting in a 10% increase in customer retention rate, enhancing the farming experience. • Identified commonly combined product traits and crop protection products in a dataset of 30,000 customer accounts, generating in a 25% increase in potential cross-sell opportunities.• Implemented data validation and unit testing to ensure the accuracy and reliability of data pipelines, reducing errors by 20%.• Conducted peer review of team members' code and documentation, ensuring high quality and maintainable code. • Assisted in onboarding new team members, providing guidance and training on technical tools and processes.

St. Louis, Missouri, Us

•Implemented modeling methods of yield demand forecasts vs. human intuition to improve efficiency in inventory management.•Categorized products by demand volume and volatility with ABC-CV matrixes to discover sales pattern using Tableau.•Built Time Series and Random Forecast models in Python to predict probability and quantity of non-zero sales. •Advanced demand forecast accuracy by 30% and reduced inventory holding cost by 42%.

• Developed and managed ETL processes with a cross-functional team to collect, aggregate, clean, and load data from various sources into a data warehouse using MySQL, enabling efficient reporting and analytics. • Automated and streamlined the analysis of risk methods by developing calculators using Excel VLOOKUP, resulting in a 30% reduction in time spent on data management tasks.• Consolidated data from multiple sources to establish a functional database for ergonomics practitioners and students, which increased visibility for the company and convenient access to knowledge for the ergonomics community.

St Louis, Mo, Us

• Conducted a pilot survey to find out the target customers and their preferences on the digital investment platform. • Applied K-means clustering in R-radiant to cluster target customers into different groups by their investing characteristics.• Provided keyword marketing strategies in search engine optimization based on the clustering results.• Offered suggestions on collaborating with ‘Hidden-gem’ social media influencers according to relative popular keywords.

St Louis, Missouri, Us

• Developed a benchmarking report with Human Resource Metrics to evaluate the performance of HR department in different agencies• Complied a survey on Human Resource Metrics and analyza data from 166 Catholic Charities organizations nationally

Beijing, Cn

• Conducted equity research on a Chinese e-commerce platform to determine investment risk• Queried GDP per capita data in different tiers of cities from Wind-Economic Database and plotted out retail sales growthusing a time series model with R to evaluate performance in each city• Forecasted the targeted company to maintain a high customer acquisition and retention rate due to economic factors• Organized daily and weekly reports, maintained databases, and monitored the tech companies• Wrote industry reports to investigate the growth of media and Internet companies

Frankfurt Am Main, Hessen, De

Explored and compiled data on medical and education sectors in Excel to construct Cost of Living Index in 72 Chinese cities• Analyzed and discovered the discrepancy between prices of medical services and education and economic developmentstatus on data from 72 cities in SQL• Designed timeline tracking sheets to ensure effective communication and seamless coordination

• Led a team of 10 to organize the first Club Culture Festival among 32 school clubs with more than 200 attendants under tight deadlines• Facilitated the reimbursement applications of club events for over 60,000 RMB and supported all areas of responsibility

• Collected and documented client data for future management• Worked with marketing team to publish articles about company developments and events on social media

Master'S Degree, Business Analytics

Ms In Business Analytics, Customer Analytics Track

Bachelor Of Business Administration - Bba, Finance, General

Bachelor Of Business Administration - Bba, Finance

Education record