Doctor Scrap is the identification & valuation & global trading platform for scrap recycling, leveraging AI and computer vision technology.Doctor Scrap will help you on:☞AI recognition of recycle and recovery rate in hundreds of categories. ☞Provide real-time price estimation. ☞Link to global recyclers.☞Automatically manage your scrap photo by category, time and location.☞Detect prohibited materials within milliseconds before you ship it.☞Real-time view of global scrap and one-click to reach a deal.

• Leaded BI Platforms development for Expedia various departments including: Operations, Finance, Payment, Data Science, Risk, Security, Auditing and Sanction Screening etc.; support on business planning, operation optimization, enterprise risk and security management, financial and budget planning, cost saving recommendations etc。• Delivered manly large-scale and high-quality BI services through entire life cycle including gather requirements, define metrics, design and build data warehouse, integrate data, test design, develop ETL and dashboard, analysis, data validation and documentation.• Managed reporting for Expedia Security team to monitor Expedia’s cloud environment including S3, Redshift, EC2, Lambda, Aurora; provided visibility on AWS Cloud Control Compliance, Cloud Tagging, and Splunk data.• Managed Atomic Model contribution platform and Anomaly Detection Alert System for Expedia Data Scientists team to monitor Model Contribution and performance, and provided optimization recommendations.• Defined, designed, developed and managed data models, data warehouses, PowerPivot Models, Analysis Service Models, Self-Services Cubes for Expedia global customer operations.

• Build machine learning predictive models with R to analyze customer’s value, propensity, attrition, frequency and loyalty for clients including The North Face, Kohl’s, Oakley and etc.• Create weekly and quarterly advanced analysis reports and dynamic dashboards for clients in different industries including Retail, Finance, Sports and Energy.• Assist in database modeling, ETL development and warehouse design for fast and efficient data extraction.• Create shape files for Sacramento King with 17,000 seats and create dynamic dashboard to analyze ticket sells in seat level and section level.• Gather, review and evaluate terabytes data, and convert data into insights to assist data-driven decisions.

• Developed and maintained enterprise scale BI reporting platform (CCGInsights) for Microsoft Consumer Channels and Central Marketing Group (3CMG). • Built and Optimized Multi-Dimensional Model (Tabular Model and Power Pivot Model), data warehouse, ETL process, SSIS packages, SQL procedures and functions.• Developed reporting and analytics solutions with SSRS, Power View and Excel service.• Built and Maintained SharePoint site and dashboard with SharePoint Designer and Performance Point Service.• Built Excel reports with “Export to PPT” functionality in SharePoint by creating mappings. • Provided training to users and new developers on the BI system.

• Assisted in the development of a SQL query recommendation and optimization platform (SQLSHARE) for ad hoc databases in cloud (Microsoft SQL Azure) with SnipSuggest features.• Analyzed over 1,000,000 SQL queries with a set of machine learning algorithms for data mining tasks in order to identify users’ query behavior.• Analyzed large and complex data with methods including TF-IDF, EM, Simple K Means, PCA, 10-folder cross- validations and etc. • Evaluated recommendation system performance with two algorithms: SSAccurary and SSCoverage.• Implemented data pre-processing, classification, regression, clustering and visualization with WEKA, R and MATLAB.

• Implemented the Auto-update application to effectively update company’s database (reduced update time from 3 month to 3 days).• Implemented the Network Monitoring System to monitor Internet traffic by user, application and threat.• Maintained MS SQL Server for the company, including security, configuration and install service upgrades.• Configured scheduled task for regular database backup, optimized some stored procedures and functions.• Performed regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.• Developed several detail and summary reports to assist decision making.