Parcel Data Aggregation for Leading Data Aggregator Led to High Performing Database

HabileData’s Solution

• A seamless workflow was planned for entering data from property documents.
  • The process was automated and semiautomated with custom logic and macros, saving time on predictable and repetitive tasks.
  • Data was captured from images and other disparate sources both structured and unstructured.
  • Data was further classified, standardized, validated, integrated and entered in structured manner.
  • Resources with high level of analytical and comprehension skills and eye for detail along with pre-defined 80 logical rules and 52 micros created internally ensured following deliverables:
    • More than 650,000+ records processed monthly
    • 98% accuracy
• The workflow was broken into modules and resource allocated as per the expertise of the team member.
• Classification and tagging:
  • Client uploaded the images on the FTP server.
  • The images were classified and routed through custom macros to different folders based on their counties; macro ensures 100% accuracy in county-wise data segregation.
  • Folders were auto created; custom macros ensure that only the valid images move to the assigned folder.
  • Valid documents taken for data entry in the specified fields.
  • Real estate data was scraped from multiple real estate sites and collected from property document images as well.
  • Scheduled web crawlers paced up online data capture process.
  • Parcel data was validated and mapped against GIS mapping, location tracking details, and data from other real estate multi listing sites.
  • New property information was added with help of programmable bots.
• The data to be entered was categorized into three sections – Yellow entry, Double D entry and Gray entry.
  • Double D Entry – These are the extremely critical fields where two teams entered the same data and the files were verified and merged using macros.
  • Gray Entry – The lesser critical fields such as buyer info and property data etc.
  • Yellow Entry – Complex data fields requiring significant comprehension skills and hence addressed by specialized teams.
  • All the three fields (Gray, Double D and Yellow) are merged using in house developed macros.
• Quality check and audit
  • Automated quality check through predefined rules ensured accuracy.
  • Additional audits were done before submission.
• Submission
  • The files submitted into the client interface/application.
  • Append property parcel data on client’s portal through API credentials.
  • Reports/dashboards at granular level were shared with client.