Conducted data collection, manipulation, and cleaning on housing database in Python through text mining and visualizations.Developed an online housing database based on AWS RDS and optimized data structure design Performed UAT testing, validation, and maintenance on database development and modifications.Built the search algorithm in online user-friendly website through langchain framework in Python which automatically transform user inputs into SQL queries to retrieve customer data.Implemented intelligent chat functionality to enhance communication efficiency and accuracy between real estate brokerage companies and clients.

Designed and implemented a SQL database to manage data on ~10K personal and business clients, including service fees, gross sales, business size, locations, and industries, ensuring efficient data organization and retrievalPredicted client churn using clustering and classification algorithms such as logistic regression, decision tree, and XGBoost based on company performance and financial metrics, achieving a 20% increase in customer enrollmentAnalyzed operations data and visualized in Tableau dashboards, presenting findings to marketing team to facilitate informed decision-making regarding marketing plans and pricing strategies for the upcoming 2-3 accounting cyclesDeveloped a robust alert system using Python (integrated with the customer database) to proactively notify accountants about impending tax report due dates, streamlining the timely submission process

Collected stock price data from APIs and analyzed 200K+ financial records encompassing stock prices, financials since IPO, and industry valuation multiples in Python and SQL to formulate investment plansConducted operational analysis and target market research by evaluating break-even points and generating cash-flow projections for 50+ potential investments; launched 3 new market segments, resulting in a $1.2M increase in annual revenueProvided support for 5+ M&A processes and joint ventures through diligent benchmarking and impactful business negotiations, fostering successful partnerships and securing a contract worth $5M in revenue

Extracted and categorized keywords from user reviews for an auto store chain company in R; identified critical issues and drivers for negative reviews to deliver actionable recommendations, resulting in a 20% increase in customer satisfactionDeveloped an image recognition project in Python, successfully identifying cosmetic products from photographs and creating a corresponding database with attributes including product launch date, brand, price, etc.Collaborated with cross-functional teams to design a graphical recognition algorithm using scikit-image for image processing, feature extraction, and pattern recognition, enabling insightful analysis of consumer purchasing behavior