Adam Mao Email & Phone Number

Boston, MA, US

Andover, Massachusetts, US

- Designed and implemented a medallion architecture ETL framework using Microsoft Fabric and Great Expectations, creating a scheduled pipeline with the capability to schedule additional ones for automated data quality checks.- Constructed multiple KQL queries and Grafana dashboards to verify data accuracy post-Azure tenant migration.- Executed ADF.

Richmond, Virginia, US

- Consulted with a top 5 bank and a sports non-profit as a data analyst. - Developed automated reports, rearchitected data environments, and performed numerous quality control assessments.- Reduced report generation time from one week to four hours.- An active member of CapTech's Asian Employee Resource Group.

Richmond, Virginia, US

- Developed and implemented an AWS-based ETL pipeline for extracting, cleansing, and transferring streaming service and IMDB data from Kaggle to S3 and MySQL.- Built an automated workflow analyzing survey results from Microsoft Forms as a proof of concept demonstrating the capabilities of Microsoft Power Tools.

Grinnell, Iowa, US

- Helped students and faculty members integrate data analysis into research and classroom work. - Assisted in data collection and analysis and provided assistance for students, faculty, and staff with data-driven software.

Grinnell, Iowa, US

- Developed interactive Shiny Apps to support data analysis and modeling statistical curriculum games. - Created game simulations and visualizations based on data gathered from games and ran statistical tests on game data to develop winning strategies.

Cleveland, Ohio, US

- Used Adobe Analytics to assess consumer usage of various client company’s landing pages. - Generated reports analyzing spending and usage metrics in our company's products using PowerBI and Excel and was also responsible for quality control of up to 200+ reports.

Champaign, IL, US

Worked in a laboratory research environment growing various mutations of breast cancer cells and testing the effects of environmental estrogen and compounds on the different mutations.

I was a summer worker that hand-pollinated corn. Different corns were to be either self-pollinated or cross-pollinated, and my job was to make sure that the corn was correctly pollinated. I also pulled weeds away from the corn. In my third summer, I was promoted to crew leader, where I managed a team of pollinators to efficiently pollinate corn.

I was a second-degree black belt. I taught groups of 20-30 students of varying skillsets and ages and gained micro/macro management skills. I assessed needs and set short-term and long-term goals to motivate and foster growth in students and delegated responsibilities to assistants for the completion of tasks. I also worked and spoke at various events and.

Master Of Science - Ms, Applied Data Analytics

Bachelor Of Arts - Ba, Computer Science

Education record