Information Technology Data Management

Bilal Hassan

* ***** ******

Chicago, IL 703-***-**** (mobile)

*********@*****.*** www.linkedin.com/in/BilalMHassan SENIOR INFORMATION TECHNOLOGY LEADER

Driving Teams to develop high quality technology solutions Established leader driving Enterprise Architecture (EA), Application, Data and Analytic strategy implementations across different industries: Department of Defense (DOD), manufacturing, retail, banking, and healthcare organizations.

Expert knowledge in database design/analytics; metadata and application and integration architectures; software life cycle development; and technical management

Led directors, managers, architects and teams of highly skilled data/analytic and application engineering professionals in all architecture domains: Business, Data/Information, Application, Infrastructure/Platform and Security (BDATS); forecasting and managing budgets up to $50M. An expert in the Department of Defense Architectural Framework (DODAF) views and is a Certified Data Management professional (CDMP). A CDMP professional will bring very strong architecture, information and data management standards and best practices to any IT environment. Clear understanding that all IT initiatives must align to a Business Capability, Strategy and Vision – which will drive the best value for patients and / or customers. Therefore, strong collaboration and teaming is a must when providing IT capabilities for all Business Initiatives. Designed and implemented high availability and continuity of operations (COOP/HA/DR) environments across multiple data centers – on premises and on the AWS Gov-cloud and Azure. This included implementing the following data ecosystems: OLTP/NoSql databases, Data warehouse/data marts, virtual DBs, and Big Data; BI tools; IoT/IIoT, and Generative AI (ChatGPT)

He has directly advised:

Core4ce – Managing Partner

Brunswick Corp - CIO

Aim Specialty Health - CIO

The University of Chicago Medicine - Chief Architect, CTO

The Walgreens - CIO and Group Vice President

The Defense Logistics Agency – CIO, CTO, Chief Architect

The Marine Corps and Navy - CIO

Pentagon - The Deputy CIO (C4ISR)

The Defense Information Systems Agency (DISA) - CIO on their Data and Integration strategies Once organizations value data and analytics as a strategic asset and implement an Enterprise Architecture discipline that aligns with the Business Capabilities and roadmap, this will greatly increase the probability of meeting all the Business goals and vision.

Overall organizations supported: Brunswick Corp; AIM Specialty Health; University of Chicago Medicine; Walgreens Co; NASD/Nasdaq; Boeing; SunTrust Bank, Department of Defense organizations: CIA, NSA, DIA, DARPA, US Army, US Navy, Marine Corps, Defense Information System Agency (DISA); The Defense Logistics Agency (DLA); and the Department of Commerce

Key Competency / Architecture areas of knowledge: BDATS

(B) Business Architecture (Business Capability Modelling)

(A) Application Architecture (Web properties / Mobile / Back and Front office)

(D) Data Architecture (Structured and Unstructured data / storage; ERD modeling)

(T) Technology (Cloud and On-prem Infrastructure environments / High Availability / Disaster Recovery)

(S) Security (Data at Rest and in transit; Identity and Access Management) Bilal Hassan

2 Bilal Hassan

Career Accomplishments/Experience

Enterprise Architecture Solutions / Core4ce

03/2024–Present

Lead Architect / Consultant

Lead Architect supporting the design and development of a Data Management Hub for a Department of Defense customer. The Data management Hub will be built on an Event/microservices architecture in AWS Government Cloud. This includes developing a Business capability Model, Level 0 Component / infrastructure architecture, Level1 component and protocol architecture, Data flow diagram and process model. Manage the design and development sprint rituals, on driving the architecture into production. This environment is built with a – burn-bag construct. Because each customer’s environment is built via automation

(AWS CloudFormation) or infrastructure as code, in the event a customer’s request their entire environment(s) can be built or removed within minutes. These environments are Highly Available (HA) with Disaster Recovery (DR). Brunswick Corporation, Mettawa, IL

05/2021–10/2023

Vice President, Chief Architect

Enterprise Architecture and Innovation

Led a team of architects, responsible for all design patterns and target architectures for Operational Technology

(OT) and Information Technology (IT) for back-office and front-office capabilities. This includes all business units: Mercury Engines, Boat Group, Navico Group, Business Acceleration and Enterprise Services. Brunswick IT/OT spans across multiple Cloud vendors (Azure, GCP, AWS) and Onprem data centers, across 27 countries. Interacts with Executive Business leadership on general consultations, strategic business initiatives and roadmaps. The Enterprise Architecture (EA) team (Business / Enterprise / Application / Solution architects) represents the following domain areas: Business capabilities, Application, Data / Database and Analytics, Infrastructure (Network, Compute, Storage), and Security (BDATS).

Provided the following Business Value for major initiatives:

● Stood up an Enterprise Architecture organization where Brunswick did not have before his arrival. This meant developing an EA Governance/processes: EA Principles, Architecture Review Board (ARB), Design standards, Assessments, Estimates, Strategies (Cloud, DR (RTP/RPO), Data, Network, Agile). o Built SharePoint site that contains all meeting rituals/logs; EA Artifact registry, Engagement model, project support model

As a result, this drastically improved the project pipeline, better design and code standards and implementation, logging monitoring and alerting of applications and infrastructure and most importantly less tech debt and bugs in production. In most cases this has led to cost avoidance and cost reductions.

● Implemented Enterprise Architecture tool - LeanIX Business partners are able to see the entire Brunswick eco-system: Business, Data, Applications, Technology and Security (BDATS) - all aligned. This allows the Business to see the maturity of their Business Capability align with People / Process / Technology

This allows all facets of the eco-system to have relationships between BDATS - driving impact analysis from the Business goals and capabilities thru infrastructure. This is not a static capability but a living dynamic that Bilal Hassan

3 Bilal Hassan

the Business (business application leaders, sales, back office, PMO) and IT (architects, data/developers, infrastructure) update and use daily.

● Supported connectivity architecture for Brunswick ACES - Autodock technology

● Aligned Manufacturing Execution System (MES); Shop Floor, video Training, o Supported the Purdue Model for manufacturing network segmentation

● Implemented Azure Data Lake house environment (IIoT)

- This environment was setup to support each of the Brunswick Business Units

● Implemented Generative AI environment (ChatGPT)

Within the Brunswick Azure cloud environment/tenant:

- Safe Search

- Safe Search augmented with Brunswick documents

- Prompt Engineering modifications

- Large Learning model modifications

AIM Specialty Health, Chicago, IL

07/2018–03/2021

Vice President, Chief Architect

Information Services & Technology

Led a team of architects responsible for all design aspects of the AIM eco-system to include customer facing systems (Rehabilitation, Sleep, Musculoskeletal, Radiology, Oncology, Cardiology), and back office facing systems

(Marketing, Finance, etc.) to include the infrastructure required to support. This includes High Availability, Disaster Recovery (RTO/RPO) strategies.

Interacts with Executive Business leadership on general consultations, strategic business initiatives and roadmaps. The EA team (Enterprise, Application and Solution architects) represents the following domain areas: Business capabilities, Member (patients), Provider (doctors and healthcare professionals), Clinical Services, Shared Services, Integration, Data, Claims matcher, Enterprise warehouse, Security, Infrastructure (Network, Compute, Storage), DevOps

Provided the following Business Value for major initiatives:

● Stood up an Enterprise Architecture organization where AIM did not have before his arrival. This meant developing an EA Governance/processes: EA Principles, ARB, Design standards, Assessments, Estimates, Strategies (Micro-services, Cloud, DR, Data, Network, Agile). As a result, this drastically improved the project pipeline, better design and code standards and implementation, logging monitoring and alerting of applications and infrastructure and most importantly less tech debt and bugs in production. In some cases this has led to cost avoidance and cost reductions.

● Implemented Enterprise Architecture tool - iServer As a result, our Business partners are able to see the entire AIM eco-system: Business, Data, Applications, Technology and Security (BDATS) - all aligned.

This allows all facets of the eco-system to have relationships between BDATS - driving impact analysis from the Business goals and capabilities thru infrastructure. This is not a static capability but a living dynamic that the Business (business application leaders, sales, back office, PMO) and IT (architects, data/developers, infrastructure) update and use daily. This is not a static capability but a living dynamic that the Business

(business application leaders, sales, back office, PMO) and IT (architects, data/developers, infrastructure) update and use daily.

Bilal Hassan

4 Bilal Hassan

● Designed and Implemented NextGen Platform

The EA team is designing and driving the implementation of a new Next Generation healthcare Pre- Authorization Utilization Management application and platform for AIM. This Micro-Service domain and event driven architecture will enable our business to deliver faster capabilities to market. NextGen system components: Docker/containers, RabbitMQ, Java/SpringBoot, .Net, Mongo, SQL Server, Axway, Tibco BW, Elastic Stack (APM, Search, logging, etc.), Elastalert, Appian; AWS; private data center To correctly implement and maintain this eco-system in the iServer tool, it requires an established Governance organization to define policy and standards for oversight and enforcement. Co-Chairs the Enterprise Architecture Steering Committee. Committee members are AIM Senior executive leaders who all have a stake in implementing and using iServer. This committee defines the Standards and Policies for the EA steering committee across the AIM organization. Small workgroups spin off to drive the policy and standards implementations.

Chairs the Domain Technology Working group. Working group members are AIM technology executives and directors. This working group prioritizes IT specific enterprise projects, defines the yearly (running) roadmap. University of Chicago Medicine (UCM)

03/2016–06/2018

Assistant Director - Head of Enterprise Architecture Enterprise Architecture, Data Warehouse, BI Reporting Led the Data Warehouse, Enterprise Architecture (EA) and BI Reporting teams at the University of Chicago Medicine (UCM) Biological Services (CBIS).

Provided the following Business Value:

● Developed an Enterprise Architecture organization which has allowed consistent standards, patterns, and best practices for application development to include cloud integration with vendors; Reduced integration rework (get it right the first time); elimination of unapproved vendor and application integration patterns; partner with Compliance and Security offices

● Developed a new Data Warehouse (Unified Data Platform) for UCM that crosses all primary data assets: clinical, HR, supply chain, and other data sources. This will allow one version of the truth, and the elimination of redundant data warehouses and analytics. Led to reduction in server and storage cost;

● Continue to drive Self-service analytic and report development. Self-service is allowing immediate access to data: OLTP, ODS and the Data warehouse; Analytic practitioners no longer spend (70%) time performing data engineering task, now spend (70%) developing analytics

● EA Team developed the following Strategies: Data Strategy; Metadata Management Strategy; Enterprise Architecture Strategy; Integration Architecture Strategy; Master Data Management Strategy Enterprise Architecture

The EA team consists of the following Domain architects: Business architect, Integration architect, Infrastructure architect, Enterprise Data architect, Back office Application Architect, Clinical Architect and Security architect. The team is responsible for the delivery of all architecture artifacts, including standards, and architecture guiding principles for UCM.

The EA origination was non-existent before Mr. Hassan’s archival. He was tasked with building the entire EA practice, processes, PMO integration, Standards and patterns for architecture products and implementations. This consisted of creating the following:

● Defined the following roles: Business architect, Integration architect, Infrastructure architect, Enterprise Data architect, Back office Application Architect, Clinical application Architect and Security architect Bilal Hassan

5 Bilal Hassan

● Creation of the Architecture Review Board (ARB)

● Adoption of: The Open Group Framework (TOGAF); Health IT Standards for Health Information (AHIMA)

● Creation of architecture tasks and product deliverables required within the Software Development Lifecycle

● Integration of architecture task within the Program Management processes

● Developed the EA Feasibility Assessment Process; Delivered 150+ FA’s within the first year

● Development of the EA Repository

The Feasibility Assessment (FA) process allows for a formal project assessment request and outcome report from the Enterprise Architecture team. The FA process was implemented in SharePoint. This greatly reduced the amount of request for Feasibility Assessments occurring after a project was started or well inside the SDLC. This also eliminated vendor contracts signed or S/W vendor implementations before an FA has been completed. Now FAs occur before a project has started. FAs are now completed in days not a month or more. Mr. Hassan also led the design, development and implementation of the CBIS Enterprise Architecture Repository. The EA repository is currently maintained in SharePoint. It contains a user-friendly GUI, containing the CBIS Architecture Framework. Before the repository was implemented some domains had no documented standards, and those documented were not easily accessible. Now each domain maintains their respective Standards, Patterns, and Guidelines in the EA Repository. This allows for an impact analysis of standards and patterns across projects aligned to Business Capabilities.

Mr. Hassan is an advising member of the Data Governance Council; and supports the Analytics Core working group.

Data Warehouse and ETL team

The DBAs support new and existing projects, design and delivery. The DBA team supports a 24/7 operation maintaining data that covers Clinical applications and Back-office applications: Finance, Human Resources and Supply Chain. The database eco systems has the following platforms: Netezza, Oracle, MS SQL, MongoDB, covering over 300+ databases, some being Highly Available with a Disaster Recovery (DR) component. These databases are Online Transaction Process (OLTP) and data warehouse instances. These database systems support: Clinical operations: Electronic Health Record (EHR), and many ancillary clinical systems: for ex. radiology, oncology, etc. The ETL team supports the DBAs using DataStage and Microsoft SSIS tools. Enterprise Reporting

The BI Reporting team supports reporting and analytics across multiple platforms: EPIC/Clarity, Oracle, SQL Server and others. The team supports the following BI tools: Business Objects, Tableau, Cognos and Crystal reports. Team supports over 300+ Business Objects and Tableau users across the University of Chicago Hospital. Mr. Hassn defined the following processes to better refine the reporting practice for a more efficient business value and outcomes: (1) Reporting as a Service (RaaS), (2) Self Service Reporting, (3) Users Group, (4) Report creation estimation process

Walgreens Corporation, Chicago, IL 02/2014–03/2015 Divisional Vice President

Data, Analytics and Customer Solutions

Led the Data, Analytics and Customers solutions (DACS) organization, which includes the following teams: Data Warehouse, BI Extract, Translation, Load (ETL), Master Data Management (ESB), Customer Solutions This organization contained ~100 FTE and 300 contractors nearshore/offshore. Eco-system components: Teradata; Netezza, HortonWorks/Hadoop; Oracle Exadata; IBM: Master Data Management, DataPower, WebSphere MQ and App server; Ab Initio, Oracle: Datastage, Exadata, and GoldenGate. Provided the following Business Value:

● Defined the Data Warehouse Strategy; this strategy integrated data warehouses across the enterprise; once fully implemented would greatly reduce server and storage cost; Designed and developed the Big Data Hadoop Bilal Hassan

6 Bilal Hassan

capability, once fully implemented it would provide a 360-degree view of the customer; increased off-shore consultants for development and implementation of commodity services

● Developed the Data and Analytic Strategy; this strategy began to reduce data and analytic duplication and development cost, as well as provide one source of truth for all analytics.

● Implementation of the Analytics Competency Center and the Analytics Metadata Repository; reduced analytic duplication; reduced the need for additional analytic practitioners; enterprise agreement on analytic calculations Bilal Hassan

7 Bilal Hassan

Data Warehouse, BI and ETL team

The DBAs support new and existing projects, design and delivery. The DBA team supports a 24/7 operation. Led a new data warehouse eco system design and delivery; This also included implementing the Big Data (Hadoop) solution to support customer affinity and segment marketing to find/predict the best customer and provide the best offers; as well as to support patient wellness and outcomes. His organization delivered over 100+ small and big projects per year, including re-platforming the Enterprise Data Warehouse in Teradata. BI reporting team supports over +350 Business Objects users.

Master Data Management and Enterprise Service Bus team (One Walgreens) The One Walgreens team consisted of managing the Enterprise Services Bus (ESB) and customer/location/product/vendor mastering implementations. This Master Data Management implementation consisted of mastering customers and patients. The ESB was the distribution and integration capability for data movement via web services, files, and video throughout the Walgreens environments.

Customer Solutions team

The Customer Solutions team drove customer-based solutions delivery, like the loyalty program, for Walgreens business units - integrating data and analytics solutions. The loyalty program consisted of over 130 Million customers and patients, which were mastered via the ESB. Led the development and implementation of the Walgreens - Analytics Competency Center (ACC). The ACC is made of over 200+ analytic practitioners across all LOBs within the enterprise. The ACC has four core objectives:

(1)Analytic Best Practices, (2) Analytic Training and Education, (2) Special Projects, and maintaining and managing

(4) Analytic Metadata via a Repository. The Analytics Metadata repository contains all analytic algorithms, and their respective reports and dashboards, across the Walgreens enterprise. Novetta Solutions / Defense Logistics Agency (DLA), DC / VA / MD (DMV)

10/2011–02/2014

Provided the following Business Value:

● Provided Data and Analytic Strategies; reduced data redundancy; server and storage cost

● Implemented the Department of Defense Architectural Framework views (DODAF); reduced refactor-ing; consistent code development and integration patterns

● Development of the DoD Metadata Repository; contains XML and integration artifacts across the DoD; greatly decreased time to integrate and deploy projects

● Defined Data Warehouse and BI tool implantations; reducing data inconsistencies; and analytic accuracy Advisor to the DLA CIO

Enterprise Deployment Lead / Enterprise Data Architect The Defense Logistics Agency (DLA) is an agency in the United States Department of Defense, with more than 26,000 civilian and military personnel throughout the world. Located in 48 states and 28 countries, DLA provides supplies to the military services and supports their acquisition of weapons repair parts and other material. The DLA Information Technology environment consists of a system of systems design with the DLA supply chain logistics Enterprise Resource Planning (ERP) tool, based in SAP, being the flagship. The DLA supply chain tool executes billions of transactions daily moving items all over the globe. Supported a special project as the Deployment Lead on the Defense Logistics Agency (DLA) / Integrated Composite Application Network Suite (ICAN) Retirement program. ICAN is the distribution tool used by the DLA ERP – Bilal Hassan

8 Bilal Hassan

Enterprise Business System (EBS). Mr. Hassan led the effort of managing the removal of all 425+ ICAN interfaces from the SAP suite and replacing/deploying 425+ new SAP PI interfaces. Enterprise Data and Metadata Architect / 07/2003-02/2014 Advisor to CIOs / Enterprise System Architect

DLA Data Strategy / Data Governance

Enterprise Architect and Enterprise Data Architect for the Defense Logistics Agency (DLA). Supported the development of the DLA Data Strategy. The DLA CIO, CTO and Chief Architect, all agreed to the recommendations from the strategy, and as a result DLA began to move towards a Net-Centric paradigm. Provided oversight and direction for implementing the Data Strategy initiatives. One of the first initiatives was standing up the Data Governance structure at DLA.

Chaired the following Working Groups (WG):

● Integrated Data Environment (IDE) Data Working Group (DWG)

● The Interface Architecture WG defines the procedures and policies around how, when and where DLA distributes data to the Department of Defense (DOD) services and agencies.

● the DLA Interface Architecture WG.

The IDE DWG governs all data management related issues, i.e. defining data naming conventions, logical & physical modeling design, and enterprise metadata standards for DLA IT personnel and systems. Implementing the strategies has allowed DLA to begin to decrease overall IT cost/budget with respect to Data management. Advisor to the Defense Logistics Agency (DLA) CIO/CTO – Enterprise Data/System Architect Advised the DLA CIO/CTO on numerous data architecture and data management issues, which led to a direct appointment to the following special projects:

Chair of the Interface Architecture Strategy Team (IAST) The focus of the IAST working group was to provide a recommendation to the DLA CIO on which data distribution tool should be used in support of the DLA SAP ERP tool. ERP Data Distribution solutions - Analysis of alternative (AOA) The AOA document defined the best COTS tool available to support the SAP ERP. The AOA was developed based on the ERP requirements and end-of-life schedule for the current distribution tool - ICAN. Interface Architecture Design document (IADD)

When developing the AOA it became clear that DLA needed an Interface Architecture design. Recommended, and gained approval by the DLA CIO, to document the interface architecture design for all DLA IT systems. Technical Lead / Lead Architect for the Integrated Data Environment (IDE) Technical Lead responsible for the system and data architecture, development and sustainment operations for the IDE Program Managements Office (PMO).

Performed PMO oversight over the Lockheed Martin/Accenture, IT managers, system and data architects, and their supporting staff of software engineers for the IDE. This consisted of: Project schedule review (earned value management), review/development of design documents; system development best practices and standard operating procedures and technical testing oversight and deployment - to ensure the system and data architectures are designed, built, tested and deployed on time and on budget. Lead Data Architect on the design team that developed the IDE. The IDE is the data broker for DLA systems that send and or receive DLA and DOD data. IDE currently feeds data to all DOD services (i.e. Army AF, Navy, Marine Corp) and Government agency systems. The IDE is based on a Service Oriented Architecture (SOA) utilizing an Bilal Hassan

9 Bilal Hassan

Enterprise Service Bus (ESB-WebMethods). It uses ESB technology as part of its messaging transportation mechanism. It supports metadata publishing and discovery. Provided on-site management of the physical installation of the IDE system for both the classified and unclassified environments.

DLA Data Discovery Portal – Project lead / Enterprise Architect Led the architecture and design of the DLA Data Discovery Portal (DDP). The Data Discovery Portal contains a metadata repository consisting of a DLA Data Dictionary. For every data element on an interface or data service that flows through IDE, its metadata is being registered in the DDP metadata repository. This allows other organizations to see what data services / interfaces are flowing through DLA. Those organizations can then request data services. This eliminates duplicate interfaces/data services and moves towards one version of the truth. The DDP is DOD Discovery Metadata Specification (DDMS) compliant. FGM, Inc., a Novetta Solutions Company supporting

the following Depart of Defense Organizations

02/1999-07/2003

Advisor to the Marine Corp CIO – Enterprise Data Architect Enterprise Data Architect to the Marine Corps’ CIO in support of their Enterprise Shared Data Environment

(ESDE).

Developed the architectural approach for an enterprise-level, net-centric solution for Marine Corps data requirements. The ESDE was defined to have a hub, where data could be distributed more effectively and efficiently – reducing the existing “spaghetti” distribution process. Performed the re-design of the Marine Corps HR database, which consisted of 346 tables. This database is mostly unconstrained and in the 1st and 2nd normal forms using SSNs as the primary key throughout. This was in direct violation of a DOD CIO directive on the use of PII in database design. The database was reverse engineered into the Erwin modeling tool. It was then re-normalized in 3rd normal form broken down into 5 subject areas in the IDEF1X notation using aggregate keys instead of SSNs throughout.

Department of Commerce - United States Export (USXPORTS) License Processing Program – Enterprise Data Architect

Enterprise Data Architect for the Department of Commerce - United States Export (USXPORTS) License Processing Program.

The USXPORTS License Processing System supports the Department of Defense and Department of State in managing and reviewing requests for Dual Use and Munitions licenses. Responsible for database design and implementation, XML design, database hardware and software configuration and implementation, data movement, as well as High Assurance Guard filter design via SOAP/XML messages. Led a team of DBAs and software developers for this effort. The database was designed in 3rd normal form consisting of 7 different subject areas with over 100 tables and implemented in Microsoft SQL Server. There was a logical and physical model in IDEF1X notation using the Erwin Modeling tool. Along with the design and creation of the USXPORTS XML tags, the tags and related metadata were also put into the Controlled Exports (CXP) namespace in the DOD XML Registry.

United States Army - Defense Integrated Military Resource System (DIMHRS) program – Data Architect Data Architect on the Defense Integrated Military Resource System (DIMHRS) prototype program. The DIMHRS system received Army human resource data via XML over the High Assurance Guard (HAG) to the SIPRNET where the DIMHRS database was located. The DIMHRS database was designed in 3rd normal form, physically modeled in IDEF1X notation using the Erwin modeling tool and implemented in Oracle. . Bilal Hassan

10 Bilal Hassan

Defense Information Systems Agency (DISA) Global Command and Control System (GCCS) – Data Architect

Data Architect on the Global Command and Control System (GCCS) program. Responsible for the database design and implementation. Led a database team for this effort. Mr. Hassan optimized the existing database design and started managing the structure in an IDEF1X notation using the Erwin modeling tool.

Defense Information Systems Agency (DISA) / DOD Metadata Repository – Data and Metadata Architect Technical Lead / Data Architect on the XML Registry project. The XML Registry was the first official Metadata Repository in the DOD. National Association of Security Dealers

(NASD/Nasdaq Stock Exchange)

02/1998–01/1999 and 02/2006-06/2006

Technical Project Manager

Technical Project Manager (TPM) for the Data Staging Hub (DSH) project. The DSH project will be the data Hub for NASD. Currently there are 19 different data feeds from consumer and provider database systems within NASD interacting with DSH. Responsible for leading a team of developers, modelers, and analysts performing the full life cycle design and development of DSH using the Rational Unified Process (RUP) for (iterative) software development. ETL/Software Engineer

Lead Software and Data Engineer for NASD and NASDAQ, Data and Architecture / Migration team.

Contact this candidate