Project Agency Inspection Application
Organization ALLSTATE Insurance Corp., Dallas, Texas
Project Type Off-site Consultant and project development
Duration June 1996 – Nov 1998
Platform/OS Windows NT 4.0, Windows 2000
Position Access Developer and System Analyst
Software Access 2.0/95/VBA
Description Agency inspection application is an insurance inspection system for big insurance corporations. It takes all the inspection orders then assigns them to inspectors based on their area zip codes. Then it bills the agents based on their status by creating invoices. The application can handle 50 concurrent users. It has extensive management reporting features.
 
Key Features 
  • Inspection Order Entry
  • Agent Invoice Creation
  • Inspector Order creation
  • Tax record checking
  • Reporting
  • Payment Entry
My Tasks 
  • Designed forms, reports, macros, modules and queries for underwriters, agents, inspectors, payments, inspection orders and coaching data entry info.
  • Created internal, external, mobile home and boat inspection reports and worksheets that shows the statistics data in graphs.
  • Designed forms, reports, macros, modules and queries for Help Desk Agent Call Tracking Application (HD). The application tracks each call, shows last five calls of the agent and calculates the agent’s financial, auto and property quality statistics.
  • Created reports that filters call data by date, underwriter, agent, and market segment.