Gregory Niehoff Email & Phone Number

Lexington, Sc, Us

Columbia, South Carolina Area

Tallhahassee, Florida

Provides overall direction for all information technology systems, planning, policies and standards, purchases, project and vendor management, and infrastructure components. Responsible for the implementation of a Policy and Claims Data Warehouse solution performing third party vendor coordination, project management, and architecture and design reviews.• Developed the corporate Information Technology Policies and Procedures, with focus on overall information security, access, and usage policies.• Leads monthly IT Steering and Project Management meetings with all company management for strategic and operational review and decision making.• Manages a Data Manager for the design, development and implementation of data warehouse data load and reporting solutions utilizing SQL Server and SSIS ETL.• Conducted industry research, analysis, company reviews of Business Intelligence / Analytic tool vendors with the completion of a MicroStrategy solution purchase.• Works with senior and department management on reporting requirements and designs of all analytical and operational dashboard and reporting solutions.• Provides reviews, assessments, and recommendations of contractual agreements, vendor security policies, standards, and SOC reports.• Manages a Business Systems Analyst for vendor and project management activities of Policy Administration and Claims Management system managed service providers.• Successfully completed the coordination, project management, data analysis, and integration design for the implementation of a new Claims Management system in a short 3-month period.• Works with an IT Infrastructure and Network managed service provider for hardware and software purchases, installations, and system and network administration, including Active Directory and File Share implementations.• Maintains hardware equipment and software inventory, tracking, cost controls, and standard configuration for the organization.

Tallahassee, Florida Area

Responsible for the growth and maintenance of a Claims and Policy dimensional data warehouse utilizing IBM Cognos Business Intelligence and SQL Server.Co-developed the Enterprise Information Management Program on a corporate level.• Managed a $2.6 million annual expense budget and quarterly variance analysis• Led a group of 25 data warehouse professionals for Policy, Claims, and Actuarial data warehouse solutions• Directed the data warehouse integrations and reporting solutions for a next generation insurance suite, utilizing Guidewire Suite products and its associated Data Mart solution• Chaired the EIM Committee and led a Data Stewards Center of Excellence group• Led key EIM Program initiatives, including Data Governance, Data Principles, Data Standards, Data Quality Processes, Data Management Processes, Data Flow Diagram Standards• Expanded Information Security efforts, including a Data Classification Framework and development of Personally Identifiable Information and related data controls• Managed four data analysts in the maintenance of data models, entity relationship diagrams, data dictionary reports and data flow diagramsResponsible for initiation and implementation of a Data Warehouse from a few Policy Analytics cubes to numerous Claims and Policy reporting solutions.Managed Database Administrators for design and development of database structures, processes, and administration of all organizational databases.• Managed a group of 8 data warehouse analysts and 5 database administrators utilizing IBM Cognos Business Intelligence, SSIS ETL tools, and SQL Server RDBMS• Led an improvement project to automate an Analytic Cube process from 12 to 4 days, eliminating many manual steps• Managed administration and maintenance of data integration between OLTP applications utilizing DTS packages and SQL routines• Led the planning, design, and implementation of claims incremental data load processes, reducing load times from 7+ hours to 30 minutes

Dayton, Ohio Area

Led a group of 14 DBA’s for the Accounting application of Reynold’s next generation Dealer Management System, managing project deliverables, timelines, and resource allocation.• Developed enterprise data modeling standards, guidelines, design methodologies, and documentation templates• Led and conducted requirements analysis, database design, design reviews, procedure development, code reviews, testing and test plan reviews, implementation, and maintenance activities• Generated accounting data model data dictionary reports utilizing Erwin data model software• Produced design documentation, table structures, views, stored procedures, and triggers for product releasesLed, designed, and documented Systems and Data Architecture for a Dealership CRM solution.• Contributed to the system, application, and network architecture initiatives for third party software product integration into a CRM data mart• Led and assisted in design of the physical database, data flow, data movement and automation processes for a Sales and Services data mart in an Oracle RDBMS• Designed data movement strategies, processes, integration, and automation activities for use in Informatica ETL and Broadbase load routines• Developed, tested, and executed data analysis and scrubbing processes for external data interfaces utilizing SQL and UNIX scriptsDesigned Database and System structures for a large automotive dealership Data Warehouse solution.• Led a group of 4 DBA's in the design, development and maintenance of data warehouse database structures and data load processes• Designed database structures using PowerDesigner DataArchitect modeling tool and utilizing MicroStrategy data modeling methodologies• Designed and developed Operational Data Store and data mapping structures for OLTP databases integrated into the Data Warehouse• Designed and developed data mapping, transformation and load procedures utilizing SQL Server DTS, SQL scripts, and Sagent Extract-Transform-Load tools

Dayton, Ohio Area

Led and contributed to the architecture, design, development, and implementation of key Global Financials and Customer / Order Relationship Management data warehouse solutions.• Led a small team of data warehouse developers for the data integration processes, reporting solutions, system designs and procedural reviews• Analyzed Oracle Financial OLTP data structures and designed related Teradata data warehouse structures, batch sourcing, and data load processesResponsible for the design, development, and implementation of award winning General Ledger, Accounts Receivable, Revenue, Customer Profit Statements, and other Financial information data warehouse solutions.• Led information requirements and report design review sessions with business users in financial and accounting organizations for the implementation of drill-down and standard reports, and an end-user ad-hoc query solutions• Designed and developed data structures, data transformations and load processes for data from mainframe and midrange server databases, Micro Control and Hyperion applications into a Teradata data warehouse environmentDesigned, developed, and maintained UNIX server, Progress database, and mainframe OLTP financial and accounting related applications. Functioned as UNIX Systems Administrator.