David Olive Email & Phone Number

Charlotte, Nc, Us

Charlotte, North Carolina, United States

Responsible for maintaining, deploying, coding, monitoring, validating fraud strategies in various fraud platforms.

Charlotte, North Carolina, United States

Senior Microstrategy Developer

Columbus, Ohio Area

Contractor position developing Microstrategy BI Applications

Columbus, Ohio Area

Delivered customer billable consulting with a focus on implementing Business Intelligence best practices. Advised clients on developing infrastructure and processes designed to deliver high-quality reporting and analytics applications, and assisted in the development of data governance and data lineage capabilities.

Madison, Wisconsin Area

Data and Business Consultant working on an Enterprise Data Warehouse.

Columbus, Ohio Area

• Responsible for systems used for determining geographic attributes (Protection Class and Rating Territory) for personal lines policies. • Designed a Data Warehouse initiative to facilitate Nationwide’s ability to accurately store and analyze geographic rating variables. • Business Lead on a strategic program to integrate GIS technology with Nationwide’s property policy platform.• Partnered with Data Warehouse Associates to design and implement a new subject area in the Data Warehouse, which involved Logical Data Model design, ETL development and documenting Business Intelligence requirements. • Created report templates, rules and procedures used to develop MicroStrategy reports. Wrote complex SQL against Teradata and SQL databases in response to data requests. • Performed analysis utilizing Access, SAS and Excel and distilled data into usable information.

Delivered customer billable consulting in the areas of Data Warehouse Assessments, Customer Relationship Management systems and Data Model translations. Related business problems to the underlying data and the articulated the ability of Data Warehouse technology to solve the business problems. Consulted on Logical Data Model development for Insurance and Financial industries.

• Developed databases, merged data from different sources and utilized complex data manipulation to produce reports, dashboards, scorecards and statements.• Developed job specifications, hired, trained and managed two systems contractors, both of whom became Nationwide employees. • Project Lead on Siebel CRM and Oracle Data Warehouse/Business Intelligence projects. Acted as virtual manager and led projects through the systems development life cycle, performing the following functions:• Determined user needs & BI requirements • Evaluated software and made recommendations• Wrote requirements and UAT documents • Led systems partners in applying technology solutions• Developed and managed Technology and Data Warehouse budgets totaling $2.5 million• Developed all databases and reporting to support the operations of Agency Financial Sales, including dashboards based on an Oracle Data Warehouse, commission statement generation, and budget reporting.• Teamed with external consultants to perform operational and financial audits of selected Nationwide agents and prepare audit reports.• Designed and developed a Unit Costing application enabling Agents, Consultants and Management to measure the costs of acquiring and servicing clients, and to identify non-value added processes and unprofitable business practices.• Developed a system to identify mis-rated auto policies which incorporated the following: Databases to receive and analyze extracts from the Data Warehouse; GIS applications which identified mis-rated policies (and associated premium leakage); and a system to create and publish reports. This application continues to capture $3 million in premium leakage per year.