Lead Capture and Distribution Tool

Designed and implemented a data management system that allows for companies to capture business leads information and provides a rich interface to search and tag leads. The application allows for creation of SFTP user accounts on the fly. The company users can then upload bulk data files to be processed based on mapping rules and schedule set in the company admin screen. The application also exposes APIs for companies to submit lead data directly to the database.

Implemented reports module that allows for viewing lead status and history. Used google charts api for graphical display of lead data by region, country etc. The reports also implement several complex filters to drill down and identify leads based on criteria set by user.

One of the challenges with this application was the amount of data we had to deal with. This required optimizing SQL queries and use of complex bash/shell scripts to process the data.