Siming Kang

Generative AI - Imagine Me - AI Media Foundation Model Quality - Offline Human Eval Data foundation - AI Media Model Launch Holdout Reporting - AI Media Model UXR Eval Data Foundation - AI Media Model Data Flywheel Ads Ranking AI Global Ads Score Attribution / Conversion reporting - translates Ads Ranking model performance to company increased revenue - credits attribution reporting for Ranking AI Org - provides visibility to the progress of meeting the half goal of Ranking model launches Model Exploration Data Foundation - set up data foundation and framework to understand the impact from model config edits / model technique adoption, for both production and exploratory Ranking models - observes opportunities to accelerate revenue growth by tracking model technique adoption - provides visibility to how model techniques owned by Ranking AI Org contributes to company revenue Ads Prediction Robustness - prevent revenue loss from SEVs in the ranking system Central Data Hub - develop complex / generic feature extraction pipelines Enterprise Infra & Security Data Protection x2prod client platform security

Archival process for corp DB Qualified Dividend Income calculation program（Dimensional modeling，C# coding） ETL pipeline development（python） Couple of reconciliation reports

Architect, Design and Develop Data Financial/Compliance Reporting system/solutions. Design and analyze data Model, Uses Case model and test procedures. Design and implement ETL processes. Creating, troubleshooting and deploying SSRS reports Migration for existing objects to AWS environment.

Develop and modify reporting and integration process according to requirements. Develop，modify and automate SAS programs. Writing complex TSQL and DSQL queries according to requirements. Creating and modifying ETL packages on SSIS. Reporting development by SSRS. Maintain, monitor whole process of integration and reporting for 11 markets across the world and provide technical support for international business team. Writing HiveSQL to populate data from hadoop. Writing SPL code to create alerts on Splunk. Creating forecasting model by R.

Participated in JAD and JRD and helped making plans for development. Making data mapping documents for ETL. Creating ETL packages to extract data from operational system(DB2) and load data into staging area(SQL server). Data cleansing, data profiling and data transformation on SSIS. Writing complex TSQL and DSQL queries to extract specified data according to requirements. Prepared queries for reporting team.