• Developed an automated condo scrapping program that analyze the condo prices in New York City• Scraped, structured, and filed public data from NYC.gov with Selenium and Beautifulsoup. Crawled real estate data from Zillow and composed analysis for the underwriting packages. Designed and built an automation pipeline to obtain tabular data from internal and external data sources for machine learning models that predict real estate prices based on property features. Reduced model error rate and improved R-squared by introducing new data sources and optimization methods• Collected real estate data from us census website and Zillow to analyze demographic and economic factors around the properties. Presented visualization results to stakeholders through diverse data visualization methods such as pyramid chart, bar chart, and line chart. Compose analysis report for stakeholders• Initiated technological and business-related side projects for the company

• Implemented and maintained ERP systems of Oracle for the client. Supported the ERP data conversion and deployment strategy by collaborating with IT and business team members to define site conversion approaches, requirements definition, and development, validation, and reconciliation of data• System design: designed partial front end and middle-ground functions and delivered to developers, organized consultants defining the required fields, filled the fields with records and adjusted the data regarding to the business logic• Data collections: collected and sorted out static and dynamic data for the procurement and settlement phase based on company's business process, verified the data with sales team, utilized SQL to encode in database and kept maintaining and updating• UI polishing: tested and made further refinement of developed functions. Provided technical and process support with other team members to realize system port testing and optimizing• System testing: Troubleshooting data gaps in ERP deployments and process improvements. Initiated clients testing and conditional testing according to the developed functions before ERP went online. Maintained all relevant change control and validation documentation including preparation, execution, review/approval, and closure• The ERP system optimized the company's operation and improved interdepartmental communication. Saved the company’s resource costs for 65%.

• Researched clients’ news and trends in the financial markets, evaluated fixed income investment opportunities, modeled and summarized the business financial status, and prepared investment recommendations to Portfolio Managers