LONG TERM CARE INSURANCE
For a large insurance company specializing in long-term care insurance,
NewTech helped to staff the development team of a major application in 3 phases. Complete development spanned over 2 years. The application built was used to manage long-term care insurance as a third party administrator for policies sold in all 50 states and Canada. The requirements included the capability to maintain and manage multiple forms for multiple carriers. It also included automated decision process for new applicants based on certain criteria to increase productivity of the underwriters. A report management system utilizing Crystal Reports Web Technology for viewing and printing reports was also put in place. NewTech initially provided the core development team and subsequently played a lead role on the analysis and design of the last two development phases. A total of five NewTech Systems Engineers participated on the project during the entire project life cycle. Analysis and conversion of legacy system data to the new platform was also performed. Technologies Used: Active Server Pages, Visual Basic, ADO data access, SQL Server, MTS/COM+, DHTML, Crystal Reports, Seagate Info, Sheriden ActiveX Controls.
MUTUAL FUNDS and BROKERAGE
For a small retail chain consisting of just fewer than 20 locations, developed a system for polling cash registers remotely to gather raw sales data. Sales data was collected by a local in-store NT server, which polled each OMRON register for sales data, stored in ASCII format. These ASCII files were converted to a database format and forwarded nightly to corporate IT for subsequent “rollup” to one central database. From this central SQL-Server database, consolidated reports were generated for management analysis each week. Technologies Used: SQL-Server, ADO, .MBD/Access data, Crystal Reports, Visual Basic, Transact-SQL.
HEALTH MAINTENANCE ORGANIZATIONS CALL CENTERS
For a large Connecticut HMO, NewTech provided consultants to staff a development team that constructed a large telemarketing/call center for the HMO. Our application used computer telephony to connect callers to a database of information. Callers entered their membership number and SSN to be routed to the correct operator. The operator at the same time, using a workstation, was presented with the complete data record of the caller, allowing the operator or answer any and all questions related to the caller’ s account. The HMO client used 3 NewTech consultants fulltime to complete the project on time and under budget. Technologies Used: Visual Basic, Microsoft Telephony API, ORACLE, Active Server Pages, ADO.