Healthcare BC/BS
Enterprise Information Technical Architect
Responsible for guiding and managing the information technical architects, data modelers, etl architects, deployment and testing utilizing agile / scrum / time-box methodologies. Responsible for the architecture, engineering and design of both the Information Delivery Hub and OLTP application database. Responsible for working with the various project teams and business analysts.
Reported to the CIO / VP Information Management Design and implementation of an Integrated Information Delivery Hub supporting BCBSIL / BCBSND / BCBSNE / BCBSWY plans. Developed medical codification, i.e. ICD9, ICD10, CPT, HCPCS, ACGs models.
Using SPARX / EA - Established the Enterprise Information Management Principles and Enterprise Information Management Guideline framework that included: Data Modeling Guidelines, Data Profiling Guidelines, Naming Entity and Attributes, Data Access and Recording Guidelines incorporating PHI and PII HIPAA rules, Information Reporting Guidelines, ETL Architecture Guidelines, Information Security Guidelines, Auditing, Balancing and Control Guidelines, Deployment Guidelines, Testing Guidelines, Metadata Design Guidelines
Responsible for: Data architecture, data development and design, data quality management, reference and master data management, data integration, data governance.
Also: Data architecture, data workflow logical models, physical source data models, data profiling reports and data audits, data definitions, data taxonomy, data metrics, meta-data, data lineage, data cleansing services.
Pharmacy Benefit Management
Sr. Enterprise Data Warehouse Architect / Data Architect / Modeler
Architected, modeled and implemented a unified data hub for storing Medispan, Pharmacy, Claims, and Providers.
Sr. Enterprise Data Warehouse Architect / Data Architect / Modeler
Architected, modeled and implemented a unified data hub for storing Medispan, Pharmacy, Claims, and Providers.
- Architected, designed and implemented MediSpan Data Model / Data Marts.
- Architected, designed and implemented Pharmacy (NCPDP) Data Model / Data Marts.
- Architected, designed and implemented Claims Data Model / Data Marts.
- Thoroughly experienced sourcing from MediSpan, ICD, NPI, NCPDP, etc data sources.
- Developed medical codification, i.e. ICD9, ICD10, CPT, HCPCS, ACGs models.
Education
Enterprise-Wide Information / Data Architect / CTO reporting to the President
Integrated K – 16 and Government Testing Services databases into a consolidated enterprise-wide data architecture requiring significant design, implementation and management of both business and technical data dictionary / metadata information. This includes architecting the creation and management of Test Items, Delivery of Test Items and Scoring those Test Items. Also included is the architecting and delivery of a Business Intelligence reporting solution.
Provided:
· Information and Enterprise Architecture Modeling
· Managing / Coaching Development Staff
· Project Planning
· Database Design and Support
· Data Integration Design and Development
· Financial Planning and Budgeting
Enterprise-Wide Information / Data Architect / CTO reporting to the President
Integrated K – 16 and Government Testing Services databases into a consolidated enterprise-wide data architecture requiring significant design, implementation and management of both business and technical data dictionary / metadata information. This includes architecting the creation and management of Test Items, Delivery of Test Items and Scoring those Test Items. Also included is the architecting and delivery of a Business Intelligence reporting solution.
Provided:
· Information and Enterprise Architecture Modeling
· Managing / Coaching Development Staff
· Project Planning
· Database Design and Support
· Data Integration Design and Development
· Financial Planning and Budgeting
Financial
SR. Data Modeler, Data Architect / Data Warehouse Lead
Developed, updated and documented data lineage from the operational IBM Financial Transaction Management into the ODS, and then into the HADOOP Hive environment. This allow the business (SMEs) to understand the source and transformations as related to the Cognos reports and queries and information delivery from the HADOOP Hive environment.
Performed data analysis and metadata management.
Performed data profiling, documenting source data, data flow, documenting load process into both the DB2 ODS and Hadoop environments and managing metadata.
Built replication jobs to move the between the databases and then do the reporting. Tech Stack DB2 OLTP (Transactional Database) plus a second DB2 OLAP (Analytical Database) via Replication jobs between the 2 databases.
SR. Data Modeler, Data Architect / Data Warehouse Lead
Developed, updated and documented data lineage from the operational IBM Financial Transaction Management into the ODS, and then into the HADOOP Hive environment. This allow the business (SMEs) to understand the source and transformations as related to the Cognos reports and queries and information delivery from the HADOOP Hive environment.
Performed data analysis and metadata management.
Performed data profiling, documenting source data, data flow, documenting load process into both the DB2 ODS and Hadoop environments and managing metadata.
Built replication jobs to move the between the databases and then do the reporting. Tech Stack DB2 OLTP (Transactional Database) plus a second DB2 OLAP (Analytical Database) via Replication jobs between the 2 databases.