Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Karan Kapoor

Atlanta

Summary

Dynamic and results-oriented technology leader with extensive experience in aligning technological innovations with strategic business objectives. Expertise in harnessing the potential of teams and advanced technologies to initiate transformative change and deliver high-impact solutions that drive organizational success. Demonstrated ability to navigate complex challenges, successfully revitalizing underperforming projects and significantly enhancing overall business value through innovative data strategies. Specialized knowledge in developing sophisticated data solutions, including master data management, business intelligence, and data governance, tailored for Fortune 500 companies, complemented by a strong foundation in enterprise data architecture design and implementation.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Sr Wherescape/Data Architect

BJC Healthcare
11.2024 - Current
  • Led the architecture, design, and implementation of a modern Supply Chain Data Warehouse using WhereScape RED and WhereScape 3D, enabling scalable and automated data integration workflows.
  • Directed a team of data engineers and modelers to deliver high-performance ETL pipelines across multiple source systems including ERP, inventory, and procurement data sources.
  • Ensured data lineage and traceability to support regulatory reporting and internal/external audit requirements.
  • Collaborated with compliance and audit stakeholders to validate data models supporting healthcare regulatory standards.
  • Maintained metadata documentation in alignment with data governance and operational risk frameworks.
  • Designed and enforced Data Vault 2.0 and Dimensional models using WhereScape3D, ensuring consistency, auditability, and extensibility across hubs, satellites, and links.
  • Created Data models for Data bricks pipelines.
  • Streamlined metadata-driven automation by leveraging WhereScape’s scripting and scheduling capabilities for rapid prototyping and deployment.
  • Established naming conventions, source-to-target mappings, and standardized transformation logic to accelerate development and enhance maintainability.
  • Partnered with business stakeholders and supply chain analysts to define KPIs, reporting needs, and data definitions, driving alignment between business goals and technical delivery.
  • Integrated Azure Synapse Analytics for scalable cloud-based storage and processing, with data visualization support through Power BI and Tableau.
  • Conducted performance tuning, version control setup, and documentation of ETL processes to ensure compliance, quality, and maintainability.
  • Mentored junior architects and developers on best practices for WhereScape development, data modeling, and automated documentation strategies.
  • Ensured data lineage and traceability to support regulatory reporting and internal/external audit requirements.
  • Collaborated with compliance and audit stakeholders to validate data models supporting healthcare regulatory standards.
  • Maintained metadata documentation in alignment with data governance and operational risk frameworks.

Sr. Data Architect

Blue Cross and Blue Shield of California
01.2024 - 10.2024
  • Retired old legacy systems, creating integrated data warehouses, moving data to cloud platforms like AWS, AZURE, GCP & Big Data ecosystems.
  • Established and maintained data governance policies to ensure the integrity, confidentiality, and availability of data.
  • Architected & designed Data Lake warehouse architecture with Microsoft Azure/Data Lake Gen 2.
  • Enforced data governance and lineage tracking in alignment with regulatory standards (e.g., GLBA, SOX).
  • Designed and supported risk-aware data architecture for financial reporting and compliance analytics.
  • Integrated audit trails into Data Vault models to enable historical recordkeeping and traceability across business domains.
  • Data visualization: Created visualizations for data extracted with Tableau Designing dashboards in tableau to meet business needs.
  • Expert level Implementation with Azure Cloud.
  • Working on creating data lineage between multiple systems with collibra.
  • Involved in creating and maintaining Data vault 2.0, conceptual, logical and physical Data Models in Erwin & Erstudio(Idera) for Snowflake.
  • Created 3NF and Dimensional Models/Star schema tables for Clinical and Pharmacy claims.
  • Modeled Claims data from multiple sources into Data vault Models.
  • Designed Data pipelines in Azure data factory & data workflows.
  • Understanding Snowflake Micro partitions and indexing strategies to fine tune queries.
  • Developing strategies and systems for integrating data from various sources, including electronic health records (EHRs), MHR, DHR and Nurse Advice Care line.
  • Collaborating with data analysts and healthcare professionals to support the development and deployment of analytics and business intelligence tools.

Sr. Solution Architect/ Data Governance Consultant

Sammons Financial
05.2023 - 12.2023
  • Involved in created Data strategy Road Map for 2024.
  • Focused on Data lineage creation in Informatica Governance suite.
  • Developing and enforcing data governance policies and standards.
  • Suggested and Implemented Data Mesh architecture focusing on self-service BI services.
  • Designed Micro services with Node.js and React.
  • Designed data model for Snowflake.
  • Understanding Snowflake Micro partitions and Indexing strategies to fine tune queries.
  • Created and maintained GCP Big query data models. Conceptual, logical & physical.
  • Leveraged Apache Kafka to design pipelines for self-service BI Portal.
  • Ensuring compliance with data privacy laws and other regulatory requirements.
  • Designing AWS Glue pipelines with models pertaining to Redshift. Designing Amazon kinesis architecture for real time data needs. Advocating for data quality and integrity across the organization.
  • Defining the strategic direction for the company's data
  • Creating and maintaining a vision for the data analytics team that aligns with the overall business strategy.
  • Designing Data Vault models according to the business requirements and the Data Vault 2.0 standards.
  • Proposing design strategies for common data model
  • Creating Hubs, Links, and Satellites as per the Data Vault modeling techniques.
  • Developing a scalable and flexible data model that can accommodate changes.
  • Ensuring the model supports data lineage and audibility.
  • Analyzing business data requirements and translating them into data models.
  • Identifying and documenting business keys, relationships, and dependencies.
  • Ensuring the quality and integrity of data through normalization and other techniques.
  • Managing the metadata associated with the Data Vault structures. Collaborating with ETL developers to implement the Data Vault model into a physical database.
  • Assisting with data migration from legacy systems to the new Data Vault-based warehouse.
  • Creating scripts or models for automated Data Vault data loading processes.
  • Enforced data governance and lineage tracking in alignment with regulatory standards (e.g., GLBA, SOX).
  • Designed and supported risk-aware data architecture for financial reporting and compliance analytics.
  • Integrated audit trails into Data Vault models to enable historical recordkeeping and traceability across business domains.

Sr. Data Vault Modeler (Consultant)

CHS
03.2022 - 05.2023
  • Created Hubs, Links, and Satellites as per the Data Vault modeling techniques.
  • Developed a scalable and flexible data model that can accommodate changes.
  • Ensured the model supports data lineage and audibility.
  • Analyzed business data requirements and translating them into data models.
  • Identified and documenting business keys, relationships, and dependencies.
  • Ensured the quality and integrity of data through normalization and other techniques.
  • Managed the metadata associated with the Data Vault structures.
  • Collaborating with ETL developers to implement the Data Vault model into a physical database. Assisting with data migration from legacy systems to the new Data Vault-based warehouse.
  • Created scripts or models for automated Data Vault data loading processes.

Sr. Enterprise Architect (Consultant)

DataSite
05.2021 - 03.2022
  • Proposing and POC of data mesh architecture. scientists, and data engineers. Educating the team on Microsoft fabric Leading and developing a team of data analysts, data
  • Responsibilities included operational execution of data governance priorities aligned with digital technology deliverables, including data policies and best practices aimed at achieving the required level of consistency, accuracy, validity, and completeness of enterprise data.
  • Designing dashboards in tableau to meet business needs.
  • Manage stakeholder communication and progress reporting at various levels of the organization including leadership and executives.
  • Evaluate internal functions, business development strategies, IT processes and suggesting improvements.
  • Proposed/Created & Lead Data Warehouse project to integrate multiple legacy sources.
  • Built an Enterprise Data Warehouse team from scratch. Created GCP cloud POC including data modeling and data pipeline MVP.
  • Accounted for possible project challenges on constraints including, risks, time, resources, and scope.
  • Conducting system architecture evaluation and collaborating with project management and IT development team to improve the architecture.
  • Helped established master data management strategies and projects.
  • Conducted and implemented multiple POC's with vendors like Informatica, Collibra & Idera
  • Established data modeling guidelines and processes to help data quality needs. Established metadata management policies, standards & procedure.

Sr. Big Data Architect (Consultant)

TCF Bank
05.2020 - 05.2021
  • Provided a solution architecture/blueprint for each new feature to be brought in retail banking side.
  • Provide design solution in big data ecosystem technology like Hadoop – Spark -Hive
  • Provide design recommendations on batch processing and real time processing of data.
  • Provide recommendation on partitioning and bucketing strategy for Hive.
  • Create conceptual and logical data models from scratch.
  • Maintain data dictionary and a wiki to provide value to the business.
  • Provide recommendation metadata management and data catalogue techniques.
  • Provide solution to create re-usable assets across platform teams.

Sr. Data Architect (Consultant)

Sleep Number
05.2019 - 05.2020
  • Designed Data Architecture blueprint for the project.
  • Sole Architect to design customer 360 journey through Layered connected solution

Data Architect/Data Analytics Consultant

Bridgestone
03.2018 - 05.2020
  • Partner with the business and analytics teams to scope business questions and identify where analytics can have the greatest impact.
  • Used random forest algorithm to help identify loyal customers and predict the likelihood of customers buying a recommended product.
  • Developed intricate algorithms based on deep-dive statistical analysis and predictive data modeling that were used to deepen relationships, strengthen, longevity, and personalize interactions with customers.
  • Analyzed and processed complex data sets using advanced querying, visualization, and analytics tools like Tableau.
  • Created and maintained Conceptual, Logical & physical data model in Powerdesigner 16.6
  • Exposed Data models to the business users through the Powedesigner portal Create Data quality model template for the organization.
  • Train developers to understand the art or modeling, educate them on the data architecture methodologies.
  • Transformed complex source system data to simple Data model.
  • Created source to target mapping for between multiple data layers.
  • Worked with Microsoft Azure Managed Sql Instances to create data model from scratch for the commercial portal phase 2 projects.
  • Create Application Based data model from scratch.
  • Gathered business requirements, working closely with business users, project leaders and developers.
  • Analyzed the business requirements and designed conceptual and logical data models.

Sr. Data Modeler (Consultant)

Allianz Life Insurance
12.2015 - 12.2017
  • Allianz desired to simplify and improve its database environment by rationalizing multiple databases into a single database (the iHub) and associated databases.
  • Applied Data warehousing techniques using Kimball & Inmon Methodology
  • Created Dimensional and transactional model using Erwin & powerdesigner
  • Created Source to target mapping documents to help developers implement the solutions.
  • Built integrated Data Vault models that support compliance, audit readiness, and legal defensibility in financial services. Enabled credit and market risk data integration through normalized and historical data structures.
  • Contributed to data architecture that supports financial crimes detection and prevention through enhanced traceability.
  • Used The Data Vault 2.0 Modeling approach to design the IHUB database that enables both integration hub and data warehouse processing.
  • Built integrated Data Vault models that support compliance, audit readiness, and legal defensibility in financial services.
  • Enabled credit and market risk data integration through normalized and historical data structures.
  • Contributed to data architecture that supports financial crimes detection and prevention through enhanced traceability.

Sr. Data Architect (Consultant)

Merrill Corporation
04.2015 - 11.2015
  • Solely responsible for Data Architecture build for workflow system
  • Responsible for creating Conceptual, Logical and Physical Model's for workflow system using Power esigner from scratch.
  • Creating models for cloud bases service architecture
  • Implementing and Creating Data Architecture standards & documentation
  • Implementing Policies, process, and audit guidelines
  • Generating DDL scripts to be implemented in MS SQL Server 2012 Creating different data layers to accommodate large data volumes.
  • Implementing data security standards
  • Creating data provisioning techniques and creating Interim solution for managing Master Data
  • Help in creating RESTful server to share data with the enterprise.
  • Creating Data Quality and Data Validation documents
  • Helping in creation of Data Backup strategies
  • Helping solution architects with system architecture design
  • Ensuring data integrity and support data quality operations like Consolidations
  • Guiding ETL & Developer team
  • Developed IT strategic vision and drove key departmental objectives.

Data Modeler Lead (Consultant)

Best Buy Co., Inc.
01.2014 - 04.2015
  • Created and maintained the Data Model repository as per company standards.
  • Reverse Engineered existing databases into PDW specific Data models.
  • Involved in creating the Dimensional Logical Data Model & Physical Data Model from Scratch
  • Created DDL scripts for implementing Data Modeling changes.
  • Created and maintained CDM/LDM/PDM using 3NF modeling.
  • Conducted data profiling assessment that helped design a better solution and reduce project risk by quickly identifying and addressing potential data issues. Solely responsible for maintaining and creating Power designer BBY Repository Worked closely with clients for the duration of projects.
  • Created and implemented complex business intelligence solutions.
  • Ensured the immediate resolution of issues so that all project deliverables were met key milestones as defined by stakeholders.

Data Modeler

MoneyGram International
10.2013 - 01.2014
  • Solely responsible for creating Enterprise Conceptual Data Model for MoneyGram International from scratch.
  • Used top-down approach to define enterprise level concepts first and then drill down to identify and depict detail or lower-level concepts.
  • Conducted review sessions with subject matter experts to gather knowledge on the existing domains, concepts, and process.
  • Created business rules indicating how entities relate to each other represented through relationship between data concepts.
  • Created Business definition for each data concept identified in the Model.
  • Reverse Engineered existing data models.
  • Created Data quality validation templates to help reviewing logical and conceptual data models.

Data Modeler/Engineer

Super Seven (PTY) LTD
08.2008 - 12.2012
  • Studied in-house requirements for the Data warehouse to be developed.
  • Conducted one-on-one sessions with business users to gather data warehouse requirements.
  • Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements
  • Development sessions
  • Developed a Conceptual model using Erwin based on requirements analysis.
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
  • Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis.
  • Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
  • In Data Management Center of Excellence, this is a common place for all data management strategies were.
  • Architects and modelers are shared resources across any and all projects.
  • Directing and leading a team of modelers to ensure that architecture vision and guidelines are followed.
  • Sandbox testing of new findings in the database environment and enhancing the implementation Modeling standards

Education

Masters of Data Science -

University of St.Thomas
Saint Paul, MN

Master of Software Systems - undefined

University of St. Thomas

BSC(Hons) - Computer Applications

University of Sunderland

Graduate Certificate - Big Data Analytics

University of St. Thomas
Saint Paul, MN
01-2019

Skills

  • Problem Solving
  • Communication
  • Enterprise Architecture
  • AWS Data Architect
  • Azure Data Architect
  • Snowflake
  • 3NF Modeling
  • Big Data Ecosystem Architect
  • Data Modeling
  • Data Vault 20
  • Data Governance Visionary
  • Dimensional Data
  • Agile Software Development
  • Airflow
  • Data Cleansing
  • Data Mart
  • Amazon S3
  • GCP Data Architect
  • Microsoft Data Fabric
  • Infrastructure
  • SAP Hana
  • Data Models
  • Data Mapping
  • Data Science
  • Supervised Learning
  • AWS Glue
  • Key Performance Indicators (KPIs)
  • Dimensionality Reduction
  • Neo4j
  • Java (Programming Language)
  • Spark Streaming
  • Online Transaction Processing
  • MongoDB
  • Logistic Regression
  • Reduction (Complexity)
  • Production Support
  • Er Diagrams
  • Business Savvy
  • Confusion Matrix
  • Deep Learning
  • Critical Thinking
  • SAS (Software)
  • HyperText Markup Language (HTML)
  • Transaction Processing (Computing)
  • Data Normalization
  • Linear Regression
  • Databricks
  • PHP (Scripting Language)
  • Conceptual Model
  • Technology Assessment
  • Team Building
  • Informatica
  • Digital Technology
  • Data Profiling
  • Predictive Modeling
  • Innovation
  • Data Analytics
  • Tableau (Business Intelligence Software)
  • Data Dictionary
  • Hierarchical Clustering
  • Apache Kafka
  • Retail Banking
  • Profiling (Computer Programming)
  • Machine Learning
  • Data Layers
  • Scikit-learn (Machine Learning Library)
  • Data Quality
  • Business Requirements
  • Scala (Programming Language)
  • Leadership
  • Progress Reporting
  • SQL (Programming Language)
  • Integration
  • Database Development
  • Visualization
  • Project Management
  • Logical Data Models
  • WhereScape
  • Amazon Web Services
  • Business Intelligence
  • Data Privacy Laws
  • Team Management
  • Data Migration
  • Data Management
  • Emerging Technologies
  • Data Mining
  • Metadata
  • Database Administration
  • Indexing
  • Data Security
  • Transformation Rules
  • Python (Programming Language)
  • Power BI
  • Solution Architecture
  • Reverse Engineering
  • C (Programming Language)
  • Star Schema Management
  • Data Extraction
  • SQL Server Integration Services (SSIS)
  • Random Forest Algorithm
  • Budgeting
  • PowerDesigner
  • Software Development
  • Operations
  • Data Analysis
  • Data Management Planning
  • Master Data Management
  • Technical Support
  • Apache Tomcat
  • Nodejs
  • SQL
  • ETL development
  • Security protocols
  • SQL expertise
  • Data migration
  • Data quality management
  • Data analytics
  • Database design
  • Data lake management
  • Data governance
  • Data security
  • Real-time analytics
  • Key performance indicators
  • Machine learning
  • Data warehousing expertise
  • Data modeling
  • Performance tuning
  • Data warehousing
  • Master data management
  • Data cataloging
  • API development
  • Business intelligence
  • NoSQL databases
  • Data profiling
  • Change data capture
  • Big data management
  • Data lineage
  • Graph databases
  • Data virtualization
  • Enterprise information architecture
  • Semantic modeling
  • Big data technologies
  • Attention to detail
  • Problem-solving
  • Time management
  • Multitasking Abilities
  • Multitasking
  • Critical thinking
  • Excellent communication
  • Active listening
  • Decision-making
  • Self motivation
  • Analytical thinking
  • Goal setting
  • Professionalism
  • Python programming
  • Time management abilities
  • Written communication
  • Adaptability
  • Project management
  • Professional demeanor
  • Database optimization
  • Software development
  • Microsoft SQL server
  • Metadata management
  • Data replication
  • Relationship building
  • Team building
  • Continuous improvement
  • RDMS design
  • Data integrity assurance
  • Data acquisitions

Certification

  • Graduate Certificate in Big Data Ecosystems
  • Graduate certificate in artificial intelligence.
  • Certified Data vault 2.0 practitioner.
  • Certified in Wherescape Red and 3D

Languages

English
Hindi
Afrikaans

Timeline

Sr Wherescape/Data Architect

BJC Healthcare
11.2024 - Current

Sr. Data Architect

Blue Cross and Blue Shield of California
01.2024 - 10.2024

Sr. Solution Architect/ Data Governance Consultant

Sammons Financial
05.2023 - 12.2023

Sr. Data Vault Modeler (Consultant)

CHS
03.2022 - 05.2023

Sr. Enterprise Architect (Consultant)

DataSite
05.2021 - 03.2022

Sr. Big Data Architect (Consultant)

TCF Bank
05.2020 - 05.2021

Sr. Data Architect (Consultant)

Sleep Number
05.2019 - 05.2020

Data Architect/Data Analytics Consultant

Bridgestone
03.2018 - 05.2020

Sr. Data Modeler (Consultant)

Allianz Life Insurance
12.2015 - 12.2017

Sr. Data Architect (Consultant)

Merrill Corporation
04.2015 - 11.2015

Data Modeler Lead (Consultant)

Best Buy Co., Inc.
01.2014 - 04.2015

Data Modeler

MoneyGram International
10.2013 - 01.2014

Data Modeler/Engineer

Super Seven (PTY) LTD
08.2008 - 12.2012

Master of Software Systems - undefined

University of St. Thomas

BSC(Hons) - Computer Applications

University of Sunderland

Masters of Data Science -

University of St.Thomas

Graduate Certificate - Big Data Analytics

University of St. Thomas

Similar Profiles

CREATE PROFILE