Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Dayakar Ejnavarzala

Aurora,IL

Summary

As a seasoned Data Specialist having 15+ years of experience; I’ve an ability to work on various aspects of Data Management including data governance, data modeler, data architecture, data analysis, data quality and data visualizations. Ability to perform requirement gathering workshops and turn them into Business Models, Logical and Physical models for both Data Governance and Data Analytics use cases. Based on the project nature, I could use any one or combination of the design techniques like Normalization, Dimensional Data modeling, Enterprise Data warehouse , Data Vault for modern data storages like Data lake, Delta Lake, NoSql and Graphical DB besides RDMS. I have extensive experience querying underlying data structures like structure and unstructured data using SQLs, Excel, Python, R, Databricks, Redshift, Synapse, Snowflake, and Power BI. Proficient developing validation scripts for data quality in terms of completeness, uniqueness, validity, accuary, consistency, timeliness, integrity, range checks, pattern matting and cross fields validations. Proactively socialize with cross-functional teams like architects (Data/ETL/BIE), data analysts, business stakeholders.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Data Governance Analyst and Data Modeler

Blue California (BCA)
05.2024 - Current
  • Company Overview: At Blue Shield of California, I contributed to strengthening the existing data governance framework by meticulously following standards and supported data cataloging and quality monitoring tools to the deepest possible. This helped ensure regulatory compliance, improved trust in healthcare data, and enabled cleaner analytics for value-based care initiatives.
  • Harvested and standardized metadata from EDW and its sources, including Facets and Epic, using reverse engineering techniques in ERWin.
  • Developed and implemented data quality rules for key subject areas such as Member, Products, Provider, Medical Records, Claims, and Pharmacy, improving deduplication, completeness, uniqueness, and accuracy.
  • Created an efficient method to upload Source-to-Target mapping documents onto the Collibra Catalog platform.
  • Collaborated closely with data stewards to collect missing metadata definitions, Critical Data Elements (CDEs), and Personally Identifiable Information (PII).
  • Trained offshore and onsite teams on metadata ingestion into Collibra, fostering consistency and best practices.
  • Configured custom views for business users to streamline navigation of data lineage within Collibra.
  • Partnered with the Sr. Data Modeler to integrate ongoing Logical Data Model (LDM) and Physical Data Model (PDM) work into the Collibra platform.
  • Reconciled data quality metrics between DQ tools and on-prem data quality KPIs (via Excel) and shared insights with management, enabling informed decision-making.
  • Provided regular support for Conceptual and Logical Data Modeling activities.
  • Assisted in consolidating Erwin data models from various sources to ensure consistency and usability.
  • Project Environment: Collibra, Snowflake, Databricks, EDW, Facets, Epic, ERWin, Confluence, Jira, SharePoint, Excel Macros, MS AccessDB, HL7, FHIR, HIPAA, NCQA, CMS, Data Stewardship Principles

Collibra DQ and data modeler

Nike (Remote)
06.2022 - 12.2023
  • Company Overview: This project focused on establishing a comprehensive Data Governance framework to support regulatory compliance, data quality, and enterprise-wide metadata management within a modern cloud-based data ecosystem.
  • Collaborated with business and technical stakeholders to define business glossaries, critical data elements(CDE), and stewardship responsibilities across domains like Sales, Inventory, Budget and Forecasting etc.
  • Worked collibra administration team to learn how to onboard users to the platform.
  • Used APIs to ingest source-to-target mappings (S2Tms) into the Collibra Data Catalog to support traceability, data lineage, and impact analysis across systems.
  • Created and maintained enterprise data dictionaries with complete conceptual, logical, and physical model mappings to support data discovery and reuse.
  • Developed over 30 + Data Quality (DQ) rules to continuously monitor and validate critical datasets, ensuring trust and compliance.
  • Customized the Collibra platform to align with customer-specific taxonomy, approval workflows, data domains, and business rules.
  • Enabled data transparency and collaboration across teams by integrating Collibra APIs with upstream systems for real-time metadata synchronization.
  • Project Environment: Collibra, Amazon S3, RDS, DynamoDB, Redshift, Snowflake, Postgres, Data Bricks, Matillion, Oracle EDW, ERWin, Hackolade, Power BI, Tableau, Jira, Confluence, Slack

Data Architect and Business Intelligence Support

Reyes Holdings, LLC, Chicago, IL – ItechUS
06.2018 - 06.2022
  • Company Overview: Reyes Holdings, LLC, is an American foodservice wholesaler and distributor company with several business entities, including Reyes Beverage, Martin Brower, Reinhart Food Service, Great Lakes Coca-Cola bottling, and Reyes Coca-Cola bottling. The primary objective is to modernize the existing Data Ingestion and Business Intelligence solutions to enhance data insights and analysis capabilities.
  • Resolved more than 100 + data related ServiceNow tickets within SLAs and allowed the Dev team to work on their development activities.
  • Provided an innovative solution which was taking 13+ hours PowerShell script to 2 hours.
  • Identified many routine tasks for the automation team.
  • Designed and supported metadata modeling in Power BI, Power Query processes.
  • My commitment to continuous improvement led me to acquire new technology knowledge in ADF, Snowflake, and Power BI through customer workshops and Capgemini Learning University sessions. I played a crucial role in training and empowering the offshore team to achieve continuous delivery excellence.
  • As part of my responsibilities, I actively participated in Change Advisory Board (CAB) meetings for CONA and Reyes Holdings, contributing valuable insights to the decision-making process.
  • Project Technical Environment: Microsoft Azure Data Factory, SSIS, MSSQL, KRONS, GIT, Cognos 10, OPALIS, Orchestrator, SAP, MS batch jobs, Power BI, Erwin, PowerShell, Snowflake, R, JAVA, Python and Salient Margin Minder and Infosphere MDM

Data Modeler

SDW, Schaumburg, IL - ItechUS
04.2016 - 06.2018
  • Company Overview: MSI Service Data Warehouse (SDW) was designed and developed to support an enterprise customer service analytics platform. I worked on data topics such as assets (hardware/software), products (Astro, Wave, and Tetra)

Data Modeler

Toyota Manufacturing IT, Florence, KY - ItechUS
07.2014 - 03.2016
  • Company Overview: Toyota Manufacturing IT systems produces different kinds of data and grains from Logistics, Suppliers, Parts Visibility, Quotations Forecast, MDM, Shipment, Overseas Shipment, Route, Trade Compliance etc.

Data Modeler

TJX Companies Inc., Framingham, MA
01.2011 - 07.2014
  • Company Overview: TJX Companies, Inc., is the leading off-price retailer of apparel and home fashions in the US. My role was to architect, define standards and guidelines, data governance and policies, and technology roadmaps for TJX.
  • Project Environment: Erwin7, MS Visio, Mainframe, MSI, MS SQL Server, Netezza Data warehouse Appliance, IBM Infosphere Information Server 8.7, DataStage, TOAD, MKS, MS EXCEL, Erwin Macros, Oracle MDM, RPAS,RMS, Oracle, Oracle DRM/Site Hub

Data modeler

Zurich NA, Schaumburg, IL
02.2007 - 12.2010
  • Company Overview: Zurich is a leading commercial property-casualty insurance provider. I modeled very complex claims and underwriting transaction source systems into a centralized data warehouse platform by examining ZEM enterprise Data warehouse landscapes. Zurich NA followed the industry standard data models called GEM.
  • Project Environment: Erwin 6, Talend, MS Visio, Mainframe, Oracle, MS SQL Server, Informatica 8, FileZilla, Enterprise data model (ZEM)

Education

Master - Computer Science and Application

NU
01.1996

Skills

  • Cloud AWS, GCP, Azure, Databricks, Synapse, Cloudera, Snowflake and Power BI
  • MDM/DQ/DG Collibra, Atacama, IBM Infosphere Master Data and Informatica DQ
  • Modeling Tools Erwin9x, SAP Power Designer 16, Visio, Hackolade
  • Data Analysis Excel, SQLs, Scala/Spark, Power BI, DAX, Tableau, NumPy and Pandas
  • Modeling Practice Corporate Factory, Enterprise Bus Matrix and Data Vault
  • Databases SQL Server, Oracle, DB2, NoSQL, Graph DB
  • ETL Informatica 96, MS SSIS, IBM Data stage 9, SAS
  • BI Tools Tableau 82 and Power BI
  • Data Quality Informatica IDQ, Trillium, Collibra
  • Frameworks DAMA, TOGAF9, Zachman, PMP and SOA
  • Scripting UNIX, Perl, PowerShell and Python

Certification

TOGAF 9, Tableau Analyst, SnowPro certification, DAMA & Power BI

Timeline

Data Governance Analyst and Data Modeler

Blue California (BCA)
05.2024 - Current

Collibra DQ and data modeler

Nike (Remote)
06.2022 - 12.2023

Data Architect and Business Intelligence Support

Reyes Holdings, LLC, Chicago, IL – ItechUS
06.2018 - 06.2022

Data Modeler

SDW, Schaumburg, IL - ItechUS
04.2016 - 06.2018

Data Modeler

Toyota Manufacturing IT, Florence, KY - ItechUS
07.2014 - 03.2016

Data Modeler

TJX Companies Inc., Framingham, MA
01.2011 - 07.2014

Data modeler

Zurich NA, Schaumburg, IL
02.2007 - 12.2010

Master - Computer Science and Application

NU

Similar Profiles

CREATE PROFILE
Dayakar Ejnavarzala