Fausto Lopez Email & Phone Number

New York, Ny, Us

• Design and develop infrastructure for an Analytics Platform designed for Data Scientists across the Federal Government space. • Design and build complex web applications solving internal and external big data problems. • Work in a 5 person team developing R packages and web applications that assist over 45 of the most remote countries across the world process valuable big health data to obtain funding assistance.

33 Beaver Street Ny Ny

• Analytics: Define KPIs and automate R/Python/SQL scripts to produce internal and public-facing metrics. • Data Engineering: Design and built analytics database using R fst package by leveraging a MapReduce framework to run scripting jobs in parallel. This led to a 400% increasing in reporting speeds. • Data Warehousing: Create schema & design for, and management of, Postgres and ClickHouse databases leading to a 500% increase in reporting speeds. • Data Visualization: Build various rapid prototype tools using R-Shiny and Tableau for public and external use, including a driver income calculator which is utilized by over 180,000 for-hire drivers in New York City. • Policy Design: Spearhead landmark driver income study, which led to the first national vehicle cap on ridesharing companies, as well as the first national requirements on minimum driver pay for over 180,000 drivers. • Machine Learning: Applied regression and random forest models to predict taxi volume and k-means clustering to improve 311 complaint categories for taxis.• Content Discovery: Launched agency-wide analytics blog showcasing innovative industry visualizations and insights.• Leadership: Select and lead a team of four data analysts to provide support for various data and policy initiatives.

• Defined KPIs and automated Python, R and SQL scripts to produce internal and public-facing metrics. • Designed schema and managed Postgres and ClickHouse databases. • Implemented parallelization in R and SQL scripting jobs that lead to a 400% increase in reporting speeds. • Prototyped and built a driver income calculator which is utilized by over 180,000 taxi drivers in New York City. • Built and released an R-Shiny-based public dashboard, the TLC Data Hub, which showcases taxi KPIs and trends.• Spearheaded landmark driver income study, which led to the first national vehicle cap on ridesharing companies, as well as the first national requirements on minimum driver pay for over 180,000 drivers. • Applied regression and random forest models to predict taxi volume and k-means clustering to improve 311 complaint categories for taxis

12-11 40Th Avenue

• Data Warehousing: Oversaw and managed six databases to track outcomes and reporting to assist low-income New Yorkers in gaining access to banking services.• Analytics: Developed evaluation protocols and analytical tools for testing program models.• Statistics: Aided with studies on financial stress as a predictor of counseling outcomes.• Reporting: Provided quantitative and qualitative assistance for the Healthy Aging Study, a qualitative report recommending resource upgrades for senior citizens in Far Rockaway.

Long Island City New York

• Analytics: Designed and administered surveys on financial counseling outcomes.• Evaluation: Developed evaluation protocols for testing efficacy of interventions for all programs.

Brooklyn Ny

Worth Motorcycle Company, Inc. is a not-for-profit organization whose aim is to impart at-risk youth and marginalized young people with the various social and professional competencies required to excel within the specialized field of vintage European motorcycle restoration.I worked with the executive director, to plan fund-raisers, construct websites, and lay the empirical foundation for the organization's model of aid for at-risk youth.

Master Of Science (M.S.), Social Research/Sociology

Bachelor'S Degree, Sociology