Sihao (Owen) Wang

● Built and maintained Machine Learning Pipelines using AWS MWAA. ● Developed a batch inference processor using Spark for concurrent read/process of large datasets. ● Designed and implemented a secure Machine Learning API authentication system using AWS Lambda, API Gateway, and Secret Manager. ● Developed AWS Aurora RDS deployment templates and integrated MWAA logging into the RDS system. ● Designed and implemented real-time data streams from DynamoDB to Redshift using Firehose, EMR, and MWAA. ● Developed ETL pipelines from data lake to various data warehouses. ● Optimized data read/write operations using Iceberg table format. ● Designed and implemented data models and relationships for Redshift. ● Developed reusable SQL queries to support cross-team data requirements.

• Developed and implemented cross-channel data-driven marketing campaigns and customer lifecycle campaigns which including email, SMS, social media and push notifications using Salesforce CRM system and Marketing Clouds platform. • Created and tested responsive html email template using HTML/CSS, Salesforce AmpScript language and data extensions. • Developed and implemented end-to-end cross-channel customer journeys based on requirements from CRM Program Managers. • Conducted QA and testing process for marketing campaigns and customer journeys, identifying and troubleshooting any issues. • Conducted data analytics and generated reports on customers’ behaviors data through RedShift Database and web tracking data on Adobe Cloud platform using complicated SQL query and Database technology. • Participated CRM Recommender project team to develop a CRM Recommender system based on deep learning algorithm and customers behaviors data.

• Developed DoubleClick placements QA automation tool using JavaScript that automatically analysis Ads placements file, scraped important data and validate various parameters based on setting rules, take only minutes to validate thousands of ads placements otherwise would take days to do manually. • Developed a web tracking validation automation tool using Python and Selenium framework, significantly saving validation efforts and improving accuracy. • Monitored real time business performance, report anomalies, identified root causes and provided order impact analyses for SEVs for various products. • Transformed Excel-based order impact analysis into Tableau with better visualization and user interaction. In addition, leveraged statistical algorithm to provide more accurate estimation. • Leveraged Tableau data source and SQL to extract and transfer traffic and transaction data from Amazon Redshift Database and compared results with data from other platforms such as Adobe Analytics using Alteryx. • Generated optimization analysis report for various Experian website pages such as landing pages, user signup pages and order pages, compared and quantified the impact of different A/B testing plans. • Conducted visits path flow analysis for various Experian email campaigns using Adobe analytics path flow tool and custom tracking variables to monitor email campaign performance.