Experience

The NPD Group

• United States
• Market Research
• 700 & Above Employee

• Sr. Data Analyst

  • Sep 2019 - Present

  New York Worked on the extraction, classification and analysis of various data sets including financial transaction data from Yodlee TXN, GPS data from Safegraph, and item receipts data from Receipt Pal. Used a combination of python scripts and alteryx, Airflow and Azure logic apps to automate the ETL processes for these data sets. Transcribed these ETLs into deployable and maintainable code using Terraform. Extracted application telemetry data using Splunk query language and… Show more Worked on the extraction, classification and analysis of various data sets including financial transaction data from Yodlee TXN, GPS data from Safegraph, and item receipts data from Receipt Pal. Used a combination of python scripts and alteryx, Airflow and Azure logic apps to automate the ETL processes for these data sets. Transcribed these ETLs into deployable and maintainable code using Terraform. Extracted application telemetry data using Splunk query language and built guardrail reports to monitor the health of ETL applications. Wrote complex Snow SQL scripts to generate ad hoc reports. Automated the production of these reports using Snow SQL views for the distribution of newly acquired data to our product and Ops team. Created a python script for the automation of anomaly detection within our financial transaction data. Created Tableau and PowerBI Dashboards on top of this system to facilitate the detection and exploration of data anomalies. Trained NLP classifiers to identify and tag raw receipt data from a survey panel (Receipt Pal dataset). Developed character mapping algorithms for fuzzy matching and scoring to boost purchased item classification accuracy. Show less



Troutbrookco

• Data Analyst

  • Jan 2015 - Apr 2019

  Worked on commercial real estate Data Verifications and Validations using A/B testing with t-test and R square contingencies. Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart. Extensively worked on data modeling using SQL. Designed and developed Ad-hoc looks and dashboards in Tableau with KPIs for the team. Created POC and prototype Tableau reports and dashboards also with key indicators… Show more Worked on commercial real estate Data Verifications and Validations using A/B testing with t-test and R square contingencies. Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart. Extensively worked on data modeling using SQL. Designed and developed Ad-hoc looks and dashboards in Tableau with KPIs for the team. Created POC and prototype Tableau reports and dashboards also with key indicators. Used Pentaho data integration tool to make project specific transformations before loading into a snowflake data warehouse. Proficient in loading data from flat-file and cloud storage services such as Amazon S3 into snowflake warehouse. Expertise in developing and documenting domain specific logistic and multiple linear regression models in R for predictive analysis. Expertise in generating graphs using MS Excel Pivot tables. Documentation of scripts, specifications, other processes and preparation of Technical Design Documents. Wrote a low level python script using the Scrappy framework to generated land, rent and sales value comparables from CRE platforms such as Loopnet or CBRE projects . Created annual budgets with variance analyses, ADR, Occupancy and RevPar projections for Hotels owned by the company using MS Excel Models. Show less



Albert Einstein College of Medicine

• United States
• Higher Education
• 700 & Above Employee

• Student Researcher OBGYN

  • May 2012 - Jul 2013

  Greater New York City Area Applied Immunostaining techniques to identify various ovarian epithelial progenitors Performed survival surgery to obtain or remove tissues in mouse models Applied qualitative analysis techniques to determine hormonal cycle in mouse models (hierarchical clustering, Chi-Square Test, Chip on Chip)



Albert Eistein School of Medecine

• Biophysics and physiology

  • Apr 2010 - Jul 2011

  Greater New York City Area Applied immunohistochemistry techniques to target specific neurons in the brain i.e GnRH neurons Prepared tissue samples for both western blotting and immunohistochemistry Applied quantitative analysis techniques such as regression analysis to get a better understanding of results obtained from experiments. Prepared various solutions and equipment for experiments