David Herber Email & Phone Number

Phoenix, Az, Us

Legacy Data Warehouse Retirement - Create Migration and Integration paths, Consolidation of 2 legacy Data Warehouses into a single entity. Source/Target Mapping, SQL creation.Created Data Governance Framework for TriCare Project. SME for TriCare Data Platform.Data Model and approval SME for triCare Project.Manager responsible for all BI Development (data delivery), and Data Warehousing. Managing a team of 20+ Data Architects, Business Analysts and ETL Developers in a Jira / Agile / Kanban development environment utilizing SQL Server (2016), SSIS and Erwin.T5 (TriCare) Data Technology SME. Data Design and Strategy for Active Duty / Uniformed Military Personnel proposal.CCN (Region 4, 5 and Pacific Islands) & PGBA Claim Adjudication replacement. Major projects with DeltaDental, ESI, Veteran Affairs Contractual Reporting and High Performing Providers.

Phoenix, Az, Us

Provider Data Architect/Lead for Data Warehouse re-engineering project. Provider Master design (pseudo-MDM Design), data ingestion and integration. Data Mapping, SQL, ETL and Agile/SCRUM development.Veteran Affairs Provider extraction, Pharmacy and Dental Provider ingestion and export.Call Center/IVR Analytics, Workforce Management employee ODS, Demand Capacity, Outreach Billing and contractual operational data feeds to Veteran Affairs.

Datamaniax consults on Data and Business Analysis, MDM and Data Governance, Data Conversions, Data Migrations, Analytics, and Data Architecture. We specialize in Data Quality Solutions and helping our clients maximize the potential and value added return of their data. We can find lost customers, increase marketing and campaign return, limit mailing waste, improve the long term efficiency and health of your organization's lifeblood, or design and build your data repository from the ground up.

Phoenix, Arizona, Us

Informatica MDM implementation for Product data stream. SQL Server Data Analysis, Profiling and Auditing. Data Governance service support.

Us

Several short-medium non-concurrent contract positions in this period.Agile line Senior Data Analyst. Data Management, Profiling, Mapping utilizing both Microsoft SQL and Oracle. TOAD, Informatica Data Quality. IBM Data Architect. Data Modelling for RAPID Project and Underwriting Solution Project.Extraction of data from various AS400 legacy systems and Guidewire source. Transform and Load to staging environment for downstream reporting functionality. Heavy use of SQL Server (2008 R2), building of T-SQL and Stored Procedures. Delivery of ETL Agile/Kanban stories.Determination of record survivorship rules.

Bellevue, Washington, Us

Data Quality Lead for 38 million client database conversion / migration. Responsible for the Data Quality strategy and execution of a multi-franchise organization conversion to a cloud solution.

Phoenix, Az , Us

Several non-concurrent positions (on-site and remote/out of hours) utilizing Data Analysis and Data Architecture skills during this period. Sole responsibility for Client Data Conversions using SQL Server (2008 R2), T-SQL and Stored Procedures performing both direct data pulls and flat file ingestion. Created and maintained standardized staging environment.Data Analysis and ETL design for integration of new client data (CIS / Billing Systems) into FATHOM's Advanced CIS platform. Transformation included Data Quality and Data Integrity checks and remediation.Position involved client data analysis and profiling to produce current state data models to allow for data mapping and generation of T-SQL transform and load scripts. DBA tasks when needed. Completion of Zephyrhills, Hillsborough, Copperas Cove, Visalia, El Cajon, Cedar Hill and Goleta conversions.

Beaverton, Or, Us

Product Data Reset umbrella projects including Attribute Optimization, MMX Enhancements, Global Store, Global Rebuy. Common Product Structure Think, Study, and Research phases for the Nike backbone for Product Line Planning and Merchandising.

National Customer Loyalty System for Office Depot. Project Lead for requirements gathering, design, development and implementation. Call Center and store kiosk UI design. Data Quality, Data Integrity and Data Management using Microsoft SQL, Visual FoxPro, HTML/ASP and .NET framework.Client data management, cleansing, deduplication and data marketing projects for Office Depot, Royal Caribbean, Dirmark, Dun & Bradstreet.

Data Warehousing, Business Intelligence and Regulatory (including KPI) Analytics and Reporting. Decision Support Systems. Analysis and Design of Business Reporting Systems, Data Conversion, Migration and Integration.Extraction and transformation of individual client data sets/files from government (AUSTA Electric) repository as part of the state electricity deregulation.Equipment data collection, analysis and Mean Time Between Failure determination for operational support.

Applied Certificate In Data Processing, Data Processing

Education record