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.
• 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

• 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.
• 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.

Mmaster Of Science, Operations Research

Bachelor Of Engineering (Beng), Industrial Engineering