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 large mutual fund company, provided programming services used to implement tax-efficient mutual fund stock trades. In any mutual fund, capital gains are due when shares are sold. Sold shares are often first purchased in blocks, with each block purchased at a specific price on a specific date. Our system suggested to traders how to ‘sell specific shares’ on a specific date to increase tax efficiency and lower capital gains taxes. The functionality was later extended to retail customers through the trading interface of the firm’s brokerage web site. Technologies used: Visual Basic, DHTML, Active Server Pages, JavaScript, COM, and ADO.
RETAIL
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.
PROFESSIONAL SERVICES
For a large consulting firm with a national operational scope, designed an Internet-based timesheet that allowed consultants all over the world to enter billing data in a timely, efficient manner. NewTech engaged two consultants for over 5 months to complete the project, which saved the constituent company over 1.5MM in procedural effort in the first year of operation. Technologies Used: Active Server Pages, HTML, DHTML, JavaScript, COM, Visual Basic, IE5 Document Object Model, ADO, SQL-Server.
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.
