Data Quality governance, procedures and policy creation, quality staff management.

Lead Data Architect in Data Warehouse division, data modeling, modeling standards, database architecture, sql tuning, partitioning standards, data quality governance standards development, data dictionary, data glossary, data reconciliation and data quality roadmap, data warehouse data definition and table/index/partition development, standards development, governance and standard Togaf type application architecture document standards,procedures and templates, data metrics and data classifications, project planning, archive and data retention analysis, internal system architecture diagrams, data relationship diagrams and documentation, data warehouse and data mart design, road map document development, major redevelopment database support and design, security design, service level agreements, data quality standards, project control standards, enterprise architecture and application architecture procedures and standards manuals, testing standards, data governance manual, data management manual, information management architectural components, security design, Informatica, SSIS, SQL Server, HL7, AI training and usage, Snowflake and others.

Technology Principal Data Architect– Solution Architect, Analytics Delivery, Data/Solutions Architect Big Data, Property and Casualty Insurance, communications, data warehouses, infrastructure, data delivery, data governance, accounting, data management and tools/training/deployment architect. Architecture activities included authentication and security APIs integration to application security (internal and external), application integration to service management, geospatial mapping integration, source code control and application deployment, performance testing management, Application architecture standards development including, Agile, Project control checklists, Analytics Application Architecture Procedures manual, and architecture template development including Scope Document, Software Architecture Document, File Storage Standards, User Interface Specification, Business Requirements Document, Test Strategy and Test Plan documents, Data Management Charter, Data Management and Data Quality program implementation, and Data Architecture Document standards. JavaScript, AJAX, Service Now, AWS Technical Professional Certification, Power Designer, Mark Logic, Hadoop, Hive, Accumulo, Ignite, Teradata, JSON, Agile, and other NoSQL technologies.

• Conducted interviews and produced technology roadmap. Performed planning and research and produced a Data Warehouse Design model, for a new data warehouse implementation. This includes data warehouse scope, source system evaluation, initial data model creation(high level,, logical, physical), ETL Management and integrated data quality systems design, Data Management and Governance Procedures and Standards, ETL processing flow design, ETL architecture, data analysis and profiling, production of the data warehouse design specification, subject area staging and presentation layer design including logical and physical model production, management of ETL programming activities, presentation layer architecture creation, business glossary production, and data object naming standards. Technologies include ER/Studio, SSIS, SSRS, Cognos, Visio, DB2, SQL Server, IBM Genelco, Process 360, Microsoft Dynamics GP, and others.

Provided consulting services which included serving as the Architecture senior staff member for a state department, the development of Data Governance and Enterprise Architecture programs including charters, design of artifact templates, data management and application architecture procedure manuals, enterprise lifecycle management, data warehouse design standards and software and hardware portfolio management procedures. Produced data designs, data quality standards, data integration and interface specifications/standards and enterprise procedures for the performance of software and data integration initiatives. Project consulting and participation included interface replacement, data migration, data warehouse design, data governance, enterprise reporting, and message queue implementation. This included work as a Data Architecture consultant for the State of Arizona including data security, RFI/RFP creation, and large project procedures evaluation. TOGAF, COBIT, ITIL, HL7, test data management, data security, business glossary and metadata management.

Business Process Analysis, data application design, search facilities design, database design and search optimization data architecture, geospaital, SSRS, SSIS, SSMS and Tableau. Business requirements gathering for outward facing applications, user interface design and specification, and dashboard design. Data warehouse data architecture, technical documentation production, ETL development, query tuning, goverance procedures development. Data Management and Data Quality initiative lead for analytic datasets, data quality measurement, data dictionary and other data quality improvement initiatives.

• Data Management architecture, data warehouse design, cloud services and analytics warehouse implementation, data architecture for predictive analytics, data quality, etl, columnar databases, health care data operations data integration, infrastructure, Hadoop (internal, SaaS, IaaS), master data management, metadata management procedures development, information architecture projects and procedures implementation. This includes Data Governance, data stewardship definitions and implementation, metadata requirements, data strategy creation and specification. Warehouse initiation development SDLC systems and procedures design, governance charter development, workflow design, modeling and etl and specification document standards development. Multi-vendor services coordination.

• Responsibility for applications architecture for large scale software integration for Medical Management, Claims, Enrollment, and data warehouse/operational data store systems. Requirements analysis, architecture specifications (databases, operational datastores, data warehouse, API components, SOA components, stored procedure components), including interaction specification development, email and document construction integration, systems conversions (conversion and retirement), reporting efficiency maintenance, medical management systems integration architecture lead for cross domain projects. Technologies include IBM Rational (RTC/RSA), DB2, and integration architecture for internal and external services integration. Medicare, Medicaid regulatory requirements analysis and data architecture design, Medicaid data warehouse, data management, metadata management, standards and query re-usability, data dictionaries, user interfaces and user interactions for reporting and data delivery. Implementation of Lean engineering methods. Information Life Cycle Management, Discovery, ETL planning and Data mart management, and Content Management systems database design, user interface design, testing, and deployment.

• Process re-engineering, planning and business analysis. Technology review and planning for technology replacement and business process re-modeling. Healthcare including enrollment, claims, financial, provider networks, master data management implementation planning and analysis. SOA Architecture, software design and modernization design, and planning, BPM/BPEL development and implementation. Geocoding and Address Management design using BPEL. Legacy integration tools implementation design. Data analysis, technical writing, systems architecture planning, as is/future state analysis, infrastructure, geospatial/provider network analysis, and new technology implementations (master data management). Testing planning and strategy. ACO, HIPPA, CMS, Medicaid, Medicare, PCP, enrollment processing, data architecture, Ingenix/OptumInsight geospatial, EDI (834, 4010/5010), IDX, Ensemble. Technology roadmaps, project management of technology replacement projects, Change Advisory Board participation. Management of advanced technical projects in performance tuning, address standardization, web services servers, disaster recovery, provider networks and master data management.(waterfall/POC-prototyping) . Hadoop investigation for application/analysis applicability. Data Governance/technology governance, testing of proof of concept and infrastructure changes.

• Included User Experience Lead Architect, Financial Accounting Data Architect, ETL Lead Data Architect, Leader of Business Analysis, Web Testing and Quality Assurance Analysis, Documentation/Technical Writing Lead, Test Plan and Strategy lead (on and offshore).• Interpretation of FASB statements, requirements gathering, requirements and use case production, management of analysts and graphic artists, database modeling, database analysis, database tuning and database changes specifications, offshore software production planning and management, backup and archive planning, security planning, design of processes and process requirements, web page design management, applications database design, specification of programming requirements for Java, Windows, HTML, SQL Server data architecture, security domains, .net, ITIL, reporting systems implementation, long term product architecture planning. Project Management and Change Management for major organizational combination financial integration projects. Management and directional lead on Securities Accounting, Requirements Analysis, User Interface Design, Specifications production, documentation and data dictionary production, Data Modeling and Data Integration. Operations Combination Project Management, design of interfaces for ASP hosting operations. Produced long term roadmaps of data requirements including data load from customers and partners. SSRS Architecture, virtualization planning and security.

• Strategic planning, budgeting, management of ETL staff and reporting staff. Model development management, management of DBA’s, storage analysis and management, model design and model management, senior management planning sessions, hiring, employee evaluations, formalization of procedures, production of Business Intelligence Procedures Manual, database tuning management, management of quality assurance of data flow from source to staging to presentation, efficiency evaluation and planning. Internal data quality initiatives, testing and compliance for medical claims, prescription and premium accounting. ER/Studio, Microsoft Foundation Framework (ITIL) implementation.• Business Intelligence Procedures manual and standards development which included standards for model design, requirements gathering techniques and procedures, dimensional testing and analysis of data sources, managed the production of user manuals and user communication standards• Management of DBA staff, Lead on SAN/storage array reorganization and disaster recovery planning.• Loading multi-tier databases using ETL data transformations, tracking data from mid-tier staging systems to operational /warehouse data stores (terabyte size databases), metadata management, data quality program development, governance and stewardship procedures development.• Managed reporting, ETL staff, new model production, reporting requirements, and schema design for insurance staging and presentation data warehouse layers. Worked with DBA,s software vendors, systems support, accounting, and other operations personnel in planning data warehouse priorities.• Software contracts, software procurement.

Produced general ledger, and financial reporting systems for the automatic and integrated posting of the general ledger and generation of financial statements. Worked with customers to handle automation of complex general ledger postings, multi-company and multi-departmental allocations, taxation calculation, insurance regulatory compliance, consolidation, revenue recognition and other advanced accounting related software implementations using iterative processes.• Led the product management function for terminal host, client server and application server (web) implementations of software products, including user interface design, application software functional design, Service Oriented Architecture projects (SOA) and software production. Managed software projects and determined functions and content of software (including new release planning, customer training, and quality assurance/data governance), managed user group relationships, served as executive level primary customer contact and executive product manager. • Designed and produced as lead designer, lead project manager, database specialist and e-commerce designer, XML functionality to allow processing requests from other systems and web pages for customers multiple internal systems and internal development groups, including UPS (package insurance) and Marsh, Inc. and various insurance companies. Implemented data quality assurance, testing and software delivery standards.• Managed the company from inception, formed vendor relationships, determined technology selection, grew company to a successful software production and support firm with 50 installed servers and thousands of users.• Consulted to independent software companies, providing project management and planning, leading to re-implementation of legacy systems into new technologies.