Diego F. Garzón Email & Phone Number

New York, NY, US

Cambridge, Massachusetts, US

Cambridge, Massachusetts, US

Basking Ridge, NJ, US

• Responsible for the data migration, data visualization, compliance and accuracy for clients in the pharmaceutical industry. This includes the extensive use of database technologies (MySQL, Oracle), APIs design.
• Designed and developed API schemas for the export and import of documents to several data platforms based on different premise /cloud systems (Documentum, Trackwise, Sharepoint, Sparta and Veeva Vault).
• Built large scale data-driven tools for the fully automated processes of business requirements such as the configuration of data mapping rules, scope definition, data cleansing/enrichment, migration dry runs and.
• Automated the generation of hundreds of thousands of PDF reports and data visualizations using ETL/data flow process in Crystal Reports.
• Executed client engagements with offices around the world (EU, Japan, Costa Rica, Canada, Colombia, etc.) in order to provide support to the team’s solutions, ensure regular updates, the tracking of success metrics.

Brooklyn, US

•  Identified principal data vendors and sources for KHP (Kavli Human Project). In the future, the study will use the data of 10,000 New York City residentsin approximately 4,000 households over the span of decades for.
• Tested, customized and evaluated financial APIs (Yodlee, Finicity, Mint) for collecting bank accounts data.
• Facilitated discussions between the research team and data providers to reach mutually acceptable agreements

• Part of the Capstone Project for the Masters of Science in Applied Urban developed under the supervision of New York City 311, Dept. of Information Technology & Telecommunication.
• Processed 311 and U.S. Census data. This processing included: geospatial aggregations (ArcGIS, Spark: GeoSpark, spatial RDDs (SRDDs)), transformations between JSON files and Data Tables (python pandas)
• Used geospatial processing of the workforce dynamics of New York City in order to obtain approximate demographic statistics of workers.
• Implemented Machine Learning algorithms (Lasso regressions, Cross-validated Linear regressions and Random Forest) to understand the relations between NYC 311 complaints and socio demographic variables
• Sutudied policy implications of the research and possible improvements to the NYC 311 service
• Collaborated with the implementation of a web visualization tool of the results: http://nk1877.github.io/Capstone/prototype/

• Member of the Quantified Community and Building Informatics research team.
• Processed, and aggregated data from the Longitudinal Employer-Household Dynamics (LEHD) for future research and characterization of workforce dynamics for specific groups.
• Used geospatial processing of the workforce dynamics of New York City in order to obtain the proportion of workers living near metro stations in New York City.
• Processed data and produced graphics in python for the Local Law 84 report (energy consumption of households in New York City by type of household)

 Taught Programming in C++ to 50 students Taught Linear Algebra to 48 students

Quito, Pichincha, EC

• Processed 10 Gb of court cases historic data using Oracle and SQL. Aggregated the data by Province, type of cause and year using R
• Implemented a prediction model to staff needs in the courts using cluster analysis and econometrical tools (index construction, and ARIMA models)
• Implemented a scoring model for judges based on hours worked, solved lawsuits, and other factors (index construction)

Master’S Degree, Master Of Science (M.Sc.), Applied Urban Science And Informatics, Center Of Urban Science And Progre

Bachelor Of Science (B.S.), Mathematics