John Cao Email and Phone Number

- Orchestrated over 80 data pipelines using technologies like Airflow, Kubernetes, JFrog, Python, SQL, Docker, and Git to design and implement near real-time and batch data pipelines supporting manufacturing quality.- Pioneered the use of distributed processing techniques within the team, exemplified by a use case analyzing early-life failures of powertrain parts, processing upwards of 120GB of data weekly. Leveraged technologies such as Hadoop YARN, Hadoop Hive, Apache Spark, AWS EMR, and TrinoDB. Currently team expert in Spark.- Enhanced team's DevOps practices by implementing unit testing, data validation, DAG migration tool, common data utilities, secrets rotation, and data monitoring. Resulting in a 33% week-over-week increase in overall data pipeline uptime and reliability achieving SLA level of 99.9% availability.

- Built an ETL pipeline from scratch using databricks to call over 40 data tables averaging over 20 million records to assist the firm in building a big data distributed system. - Assisted clients in delivering mission-critical analyses of national security clearance application errors to over 200 agencies using advanced text mining and natural language process techniques presented in Tableau dashboards- Leveraged Azure Cosmos DB, Azure Blob Storage, and python for scripting to build an ETL pipeline that extracted and preprocessed over 60,000 public comments and file attachments for regulation proposals in minutes

- Defined and tuned a type system with 60+ entities and 1,000+ dictionary entries in Watson Knowledge Studio to inform a named entity recognition and information extraction model utilized in a firm-wide recommender solution- Assisted the Data Scientist team in analyzing over 1,000 courses by using topic modeling and sentiment analysis on course feedback to discover unique findings such as food and environment led students to rate courses higher- Created a valuation model identifying the benefits of automation for a software contract compliance service line proposing $9.4 million in total bottom-line savings over 5 years

-Developed an investment case delivered to the CEO of a healthcare client highlighting a cognitive automation solution for procurement process approximating $9 million in savings to the operation. Assisted in developing the high-level design of the solution architect identifying new resolution steps and KPIs previously unrecognized. -Co-led a project management engagement to deliver cognitive automation to the firm. Worked with Technical Solution Architects and Consultants outside the firm to develop a cognitive automation tool. Led workshops and interviews with lead Partners, Managing Directors, and Managers.