Arthur Dattner Email & Phone Number

Systems Architect / Data Modeler• Designed Operational Data Stores for secondary auto insurance market.• Implemented and enforced database and data element naming standards.For the SIU Fraud Detection Unit:• Designed data warehouse and data marts that combined multiple databases greatly simplifying their investigation process.• Discovered and corrected existing query program errors that resulted in approximately four thousand new insurance applications not being interrogated each month.• Designed and implemented an auto run query process that reduced the manual effort of team member to run over fifty monthly queries from three days to under five minutes.

1996 – 2001 PRICE WATERHOUSE COOPERS - Data Warehouse PracticeProject Manager / Senior Business Analyst / Developer Factory Mutual Group - Norwood, MA• Designed a methodology using Visual Basic for converting their manual of acceptable roof constructions from its print image form to a data base repository.• Developed physical design for Oracle database containing material combinations and construction techniques for insurable roof construction.• Designed data mart used to provide users access to construction information through the Internet.Definity Health Care - Dot-Com startup company - Minneapolis, MNProject Manager for the data warehouse and Internet interface implementation for startup company Using Summit D methodology, managed five person development team that accomplished the following:• Using Erwin and Oracle, Designed Operational Data Store and Dimensional databases for managing financial and claim records as well as members, client companies and providers.• Using Mercator, designed and implemented HIPAA compliant client/provider interfaces for Operational Data Store and Dimensional databases.CIGNA Insurance - Defined Benefits - Hartford, CT• Developed ER and multi-dimensional data models to support transactional systems, data staging, reporting and data analysis using OLAP/ROLAP technology.• Designed data integration solution across multiple data marts.Delta Dental - Charlestown, MA • Translated client requirements for product costing into a functional model for a costing data mart.• Defined the data extract requirements from multiple legacy systems and their conversion and integration into a data warehouse. Boston Gas Company Roxbury, MABuilders FirstSource - Wholesale lumber company - Frederick, MYDelta Dental - Charlestown, MA Data General, Westborough, MACommerce Insurance, Douglas, MAAllied Domecq, Parent Company of Dunkin Doughnuts. Raynham MA

1988 – 1990 Systems Manager/Business Systems Managed staff of six Programmer Analysts.Evaluated and customized commercial prospecting systems:• Managed the corporate relationship with Computer Intelligence, a vendor that provided information pertaining to over 100,000 computer sites in the US.• Negotiated contract to have CI customize their system to meet company needs.• Transformed this service into a viable sales and marketing tool.Managed the design, programming and testing of a shipment scheduling system. 1981 – 1987 Senior Project Specialist Financial Planning and Analysis Managed staff of three Programmer AnalystsDesigned, programmed and implemented a Cost and Revenue Information System for the Customer Services Division. The system provides revenue trend reporting, exception reporting and an interactive forecasting module. System that resulted in the acceleration of revenue collection and the recovery of approximately $45K each month that would have otherwise been lost.Served on task group to aid in determining life cycle cost for the US Navy SNAP program which was the largest single contract, $604 million, ever awarded Honeywell.• Designed Database and access programs that enabled the task group to determine the parts expense, repair cost and capital asset adds required by month over a 10-year project life.• Built model used to determine the total cost and margin percentage based on ship schedules, proposed revenue, failure rates and the assignment of various overheads.• Use of models reduced financial evaluation time from 6 weeks to 2.5 hours enabling task group to test over 150 variations to optimize cost/revenue stream.Designed and programmed a major financial reporting system, that generated divisional monthly financial statement of costs/revenue, associated with each maintained product line. Resulted in a reduction from 5 workweeks to 4 workdays each month with improved accuracy and functionality.

Mmaster Of Science, Operations Research

Bachelor Of Engineering (Beng), Industrial Engineering