avatar

Joseph DiCastro

Data Engineer and Data Visualization Developer

Phone:
+1 (646) 234-8458
Email:
joe@josephdicastrollc.com
Location:
Brooklyn, NY

Hi. I'm Joe.

I'm an accomplished data engineer with specialties in database development, data analysis, and data visualization. Creative leader with 20 years of professional experience and a certificate in Data Analysis and Data Visualization from Columbia University’s School of Engineering and Applied Science. Expertise building data-driven applications, websites, and other interactive visual experiences that combine analytical rigor with creative presentation. Recognized ability to successfully collaborate with multiple levels of an organization’s hierarchy to deliver best-in-class business solutions. Thrives in creative and analytical environments, and looking for positions to make a positive difference in the world around us.

Download CV

Resume_

Employment

Joseph DiCastro LLC

2019 - Current

Data Engineer and Data Visualization Developer, Owner

Business owner of Joseph DiCastro LLC, a boutique software engineering consultancy specializing in interactive data visualizations, data analysis and engineering, database application development, and systems integration.

Belluck & Fox

2007 - 2019

Director of Data Systems and Marketing

Director‐level position responsible for all business solutions related to data system development, database management, business practice analysis, and workflow automation for Belluck & Fox, LLP, ranked by US News & World Reports as one of the “Best Law Firms of America”. I also directed the firm’s marketing and advertising initiatives and was often the primary person responsible for designing and implementing these initiatives. It was with respect to the over‐sized scope of my responsibilities that the firm created the title of “Director of Data Systems and Marketing” especially for me.

Curtis, Mallet‐Prevost, Colt & Mosle LLP

2005 - 2007

Marketing Knowledge Coordinator

Database and web design, content development, information management for all marketing‐related activities for major international law firm.

Multiple Contract & Freelance Projects

2002 - 2007

Marketing Knowledge Coordinator

Database development, web and visual design, and content creation for a variety of short‐ and long‐term contracts spread throughout multiple industries, including academic research, e‐commerce, healthcare, and independent filmmaking.

Education

Columbia University, School of Engineering and Applied Science

2019-2020

Certificate in Data Analysis and Data Visualization

Emerson College

1993-1997

Bachelor of Science: Mass Communications, with minor in Philosophy.

Major Projects_

project-img

Visualizing SEP

Designed and developed interactive Data Visualization of the Stanford Encyclopedia of Philosophy, a 1700+ article encyclopedia that is one of the web’s greatest resources on philosophy’s history and practice. This application is a new kind of visual search engine for exploring and navigating large-scale, interconnected datasets with ease and power.

Used stack:

  • D3
  • Javascript
  • HTML
  • Python
  • Beautiful Soup
  • MongoDB
www.VisualizingSEP.com
project-img

Data Engineering for Major International Food Distributor

Design, development, integration, management, and maintenance of multiple databases for international food distributor with revenues greater than $100 million. The databases are responsible for processing and distributing food products and providing quality control across its entire supply chain, which spans North, Central, and South America.

Used stack:

  • MS Access
  • MS SQL Server
  • SQL
  • VBA
  • MS Excel
project-img

Database Managing More Than $1 Billion in Settlements and Verdicts

Custom MS Access/MS SQL Server application that tracked more than $1 Billion in settlements, trial verdicts, and client payments for major mass tort law firm. Developed the entire system, from architecture to interface to its reporting capabilities, providing a real‐time representation of the status of every case, settlement, payment, and distribution among more than ten thousand actions, cases, and filings. No other law firm at the time had a system matching its scope.

Used stack:

  • MS Access
  • MS SQL Server
  • SQL
  • VBA
project-img

Business Intelligence Application Integrating Multiple Databases

Engineered a custom BI application for major mass tort law firm that integrated information from the firm's settlements & verdicts database, their trial and client management database, and their accounting system, to provide a complete window into the firm’s entire business operations.

Used stack:

  • MS Access
  • MS SQL Server
  • SQL
  • VBA
  • Javascript
  • LexisNexis TimeMatters
  • LexisNexis PCLaw

Technical Experience_

Domains:
  1. Interactive Data Visualization
  2. Data Engineering and Analysis
  3. Database Design and Development
  4. Web Design and Development
  5. Workflow Automation
  6. Systems Integration
Databases & Data Analysis Applications:
  1. MS Access (Expert Level)
  2. MS SQL Server
  3. MongoDB
  4. PostgreSQL
  5. MS Excel
  6. PANDAS
  7. SQL Alchemy
  8. Flask
General Applications:
  1. VSCode
  2. Jupyter Notebooks
  3. Adobe Photoshop
  4. LexisNexis TimeMatters
  5. LexisNexis PCLaw
  6. MS Word and VBA-Automation of Word API
Languages:
  1. Python
  2. SQL
  3. VBA
  4. Javascript
  5. HTML
  6. CSS
Visualization & Web Frameworks:
  1. D3
  2. Plotly
  3. MatPlotLib & Seaborn
  4. Bootstrap
  5. Beautiful Soup

Get in touch_