Jack Tsai Email & Phone Number

New York, Ny, Us

San Francisco, California, Us

New York, Ny, Us

(Python, Scala, Spark, Kinesis, Airflow, AWS EMR, S3, Lambda, Redshift, Big Query, DynamoDB, SQL, DBT, Logstash)- Led the development of Meetup's user behavior data pipeline, handling TB-level data daily, utilizing Airflow, PySpark, and AWS Kinesis, S3, EMR, Redshift. Achieved a 30% increase in processing efficiency and a 20% reduction in operational costs.- Designed and implemented a PySpark and AWS SAM-based data pipeline for Braze and Sendgrid, enhancing email campaign effectiveness by 15% through improved real-time reporting.- Developed a GA4 data pipeline in BigQuery using PySpark, AWS Kinesis, S3, Redshift and Lambda, improving data reporting accuracy by 25% and streamlining analytics across departments.

New York, Ny, Us

(Python, Scala, EMR, Spark, Airflow, Kinesis, Big Query, AWS, Redshift, AWS Kinesis, Lambda, NLP)- Create and maintain optimal data pipeline architecture, Assemble large, complex data sets that meet functional / non-functional business requirements. - Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies. - Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. - Keep our data separated and secure across national boundaries through multiple data centers and AWS regions. - Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

New York, Ny, Us

(Python, SQL, Docker, AWS EC2, S3, Redshift, Kinesis, Linux, Data Pipeline, Airflow, NLP, Circle CI) - Designed and implemented distributed pipeline and cloud infrastructure to process more than 8 billion customers and vehicles information in real-time by Spark, Lambda, Redshift, and EMR.- Integrated and built pipelines to move more 4 databases data into Data Lake by python, Spark, AWS Lambda, AWS Glue, and AWS Data migration service.- Improved 100% of the performance for vehicle rebates program ingestion by distributing the system with python, Airflow.

New York, Ny, Us

(Python, SQL, Docker, AWS EC2, S3, Redshift, Kinesis, Linux, Data Pipeline, Airflow, NLP, Circle CI) - Developed and monitored the NLP pipeline to extract rebates from over 2000 vehicle programs by Airflow, NLP, and Python.- Designed and built a large-scale (terabyte) inventory streaming pipeline to serve more than 800 dealerships in the US by Python, Docker, Redis, and Flask API.- Maintain and support inventory pipeline and price pipeline with 3 databases.

New York, Ny, Us

(Python, Pandas, D3.js, Flask, Selenium, Postgres SQL, Mongo DB, GCP, Spark)

New York, Ny, Us

(Django, Python, unittest, pandas, selenium, Beautifulsoup, celery, ETL pipeline, Postgres SQL)- Built, maintained and refactored more than 50 scrapers and collected 50 sources from websites into our Django based system by Python, requests, Selenium, Beautifulsoup- Designed, built, tested, monitored, and deployed ETL data pipelines in a continuous integration environment improved quality rate from 75% to 95% by Python, unittest, Django and pandas- Improved 30% of the efficiency of each scraper and increase 200 % server capacity to run scrapers by refactoring program and scheduling with distributed task system by Python, Selenium, Celery- Developed Django 2 APIs to migrated with ETL pipeline system by Python, Pandas and Django

Brooklyn, Ny, Us

(C++, Python, OpenCV, Mathematica, CityGML, Qgis)3D Urban Heat Transfer Model x MIT Lab- Developed C++ program to automatically remove the inner walls for all buildings in New York City more than 8,000 lots from 3D model which improved 80% efficiency and accuracy for Urban Heat Transfer Model- Extracted New York City CityGML (3D model) and reshaped the format for data preprocessing by Mathematica- Mapped the 2D heat images to the 3D model of buildings by Open CV and PythonSpatial Analysis by open source(Python, Qgis, OpenStreetMap)- Designed 3D visualization of cities tutorial- Visualized the 3D buildings in Manhattan by Qgis and OpenStreetMapIdeal City Website(http://idealcities.info/)

New Taipei City, Taiwan, Tw

(PHP, CSS, JavaScript, Python)Official Website -Constructed and designed the official website including the contact info, content, layout, precedence, speed, the server using PHP, JavaScript and CSS-Optimized the website performance from 22 to 99 (Google analysis scores) including mobile speed, mobile friendliness, desktop speed, and raised the search engine rank from page 10 to 1-Built data-driven marketing strategies across search engine (Yahoo, Google, Baidu) and social media (Facebook, Google +) and increased more than 7,000 views, 1,900 visitors, and 5 times incomers than the former website.

Taipei City, Taiwan (R.O.C.), Tw

(PHP, JavaScript, CSS)Google Adwords & Analytics-Created 10% fourth-quarter company profits via Google Adwords and 3 times incomers, using Google Analytics and optimizing the market strategy based on the users‘ feedback applying Ads A/B testing.-Standardized the Google Adwords guideline included the highest click keywords sets for 8 products and the target audience preference in each season.-Bettered AdWords advertising 3 times return on investment in 3 months, enhanced 8.55 times cumulative clicks per month, reduced 49% of cost-per-click, lowered 15.18% of bounce rate.Web Developer-Designed the mobile web pages and added highest clicks 8 products sets using PHP.

Redmond, Washington, Us

(R, Azure, Machine Learning, C#, Kinect, Power BI)Machine Learning and Semantic analysis(R, Azure, Machine Learning, C#)-Predicted Taiwan E-News reading behavior by training data on Microsoft Azure Machine Learning models and designing R script to processing data.-Conducted Chinese Lexical Crawler for predicting Taiwan the trend of politic by mapping out each word and corresponding emotion scores using C#.Motion Detection Development and Image Analysis(Kinect, C#)-Developed Motion Detection Financial Advertisement application using Kinect with C# including image analysis and facial recognition which increased 3 times of viewers.-Detected the facial expression by Kinect-Analyzed the viewer behavior data from Kniect and feed the different type of advertisementApp develope and Data Analysis Instructor(Power BI, C#)-Instructed the Microsoft business intelligence platform(Power BI) course for data analysis team of Taiwan Millennium Health Foundation.-Taught development of Windows App in Microsoft developer community (Channel 9), MicrosoftMicrosoft Data Center-Managed and implemented the enterprise software environment in Microsoft internal server and reported and solved the payment issues.

Master'S Degree(With Scholarship), Applied Data Science

Bachelor Of Science (Bs), Bio-Enviromental System Engineering

Executive Mba, Information Technology

Research Exchange(With Scholarship), Data Science

Exchange, Summer Session