Tech lead to build data lake to support new product across Meta family of apps.

● BI Product development on insurance data using Looker● Revisit current solution on data ETL and pipeline, work on improvement of data warehouse schema, workflow setup, metadata management, query performance● Third party visualization tool integration in the core insurance platform application

● End-to-end Facebook data pipeline development and dashboard visualization. Based on user requirements from Marketing Science Research team, designed data warehouse schema and data modelling, extracted big data from different sources and validated data quality. Optimized and streamlined data pipeline to best satisfy dashboard users’ requirements and balance the resource utilization.● Identified upstream pipeline issues and limitations. Collaborated with cross functional teams to improve data quality and extract additional information.● Data pipeline workflow management(configure, schedule, and backfill) using Dataswarm

● Worked closely with engineers and program managers to identify system issues and propose new UI features. Understood business needs and developed product KPIs.● Restructured and aggregated various datasets to allow for accurate data extraction of pipeline KPIs related to latency, quantity & quality.● Created automated dashboards to monitor system status. Metrics are used for bi-weekly department wide business meetings and monthly trending meetings.● Refined system pipeline workflow by adding automated features, reduced production average latency by 48%.● Conducted statistical analysis on prediction model developed by SWE, which have been used as a template for other statistical reports to validate models in each version.

● Collected, assessed, analyzed, and disseminated public health surveillance and program data and data obtained from other sources.● Produced statistical and epidemiological reports, including tables, charts, slides, maps and other descriptive formats. Performed ANOVA analysis, trends analysis, logistic regression analysis, multivariate analysis, and geospatial analysis.● Disseminated results of investigations, special studies, routine surveillance, and analysis of health data.