Enterprise Data Architect, Data Architect, Data Modeler, Developer, DBA, Systems Analyst, Technical Leader with 30+ years’ experience in information technology and engineering. Strong background in mathematics, engineering, analytics, and problem-solving. Decades of experience in systems analysis, design, application development, testing and management of large-scale data centric projects.
Extensive domain expertise in Healthcare, Life Insurance, Blood Transfusion, and Quantitative Marketing. Subject Matter Expert (SME) in Producer Management, Sales, Policy Administration, Eligibility, Enrollment, Consumer (Member), and Claims.
Sizable experience in data modeling: conceptual, logical, physical, dimensional, and master data. As well as expertise in data architecture, database design, and ETL/ELT.
Defined and modeled Sales, Producer, Consumer, Claims and Billing Operational Data Stores (ODS). Designed and implemented enterprise (Inmon-Kimball) and logical (integrating RDBMS with the Hadoop Ecosystem) data warehouses, numerous dimensional Data Marts, and cloud analytics solution.
Designed, developed, and implemented eligibility, enrollment, billing, and claims systems for the healthcare enterprises as well as Quantitative Marketing and Producer Compensation data centric frameworks. Additionally, designed and built on-premises and cloud-based systems to implement a concept described as the Universal Operating Model for the Blood Transfusion Domain.
Skills encompass systems analysis, data architecture, data modeling, data analytics, technical leadership, system design, software development, and database administration.
Co-authored a book published in 2022, ImmunoHematology Framework (IHF): A Universal Operating
Model for the Blood Transfusion Domain.
Work Experience
April 2023 – Present
Project - ImmunoHematology Framework (IHF): A Universal Operating Model for the Blood Transfusion Domain Author, Inventor, Lead Engineer, Data Modeler, Data Scientist
Team member of the group of medical scientists, engineers and data scientists who put forth original medical research, foundational concepts, models, methods, and algorithms along with their proofs and implementation in a book published in 2022 (see publications section). 1
Defined the invention’s logical framework, and developed models, methods, algorithms, classification schemes, built computer system (working prototype) to optimize and quantify the many aspects of patient– donor matching requirements and patient–unit selection for different groups of red blood cell (RBC) recipients while satisfying patient needs efficiently and economically as well as to optimize RBC blood bank inventory. Additionally, developed a method to measure outcomes of decision-making processes.
1 Led a pilot project that was completed in a combined immunohematology research laboratory - medical facility that is devoted to support patients with complex clinical conditions.
Designed and developed IHF technology solution prototype (on-premises and cloud versions): • Defined framework conceptual architecture • Developed conceptual, logical, physical, and dimensional (star schema) data models • Developed data specifications, ETL/ELT components, and matching algorithms • Created and maintained the databases • Defined and developed framework data visualization and analytics • Converted on-premises system version to Azure cloud • Designed framework cloud analytics solution
Data modeling tools: erwin, ER/Studio Data Architect
Environment: IHF pilot system – on-premises version SSIS, T-SQL; SQL Server; Data Mart: SQL Server; Power BI IHF pilot system and framework analytics solution– cloud version (Azure) Data Factory, T-SQL; Data Lake, SQL database, Synapse Analytics; Power BI
November 2012 – March 2023
Horizon Blue Cross Blue Shield of New Jersey Newark, NJ, USA Enterprise Data Architect, Data Architect, Data Modeler Enterprise Architecture/Data Architecture Team, Consultant
Leading Data Architect, Data Modeler and Design Leader for Enterprise initiatives. Subject Matter Expert (SME) in Quantitative Marketing, Sales, Producer, Customer, Eligibility, Enrollment and Specialty Product domains.
Horizon Blue Cross Blue Shield Enterprise Data Framework included Operational MDM, new generation Data Warehouse, Data Lake, Member & Provider ODS, (CRM) Marketing database, Sales ODS and Producer Information Platform.
Producer Information Platform
Defined, designed, and implemented new data centric framework to support sales, broker compensation, enrollment and reporting/analytics including business process, data models, databases, data integration, ETL, data quality/reconciliation and front-end applications for Medicare Advantage, D-SNP and Medigap products as well as Health, Dental, and Vision for commercial individual, and group market segments.
Sales & Producer Compensation ODS (Operational Data Store) and Data Mart
Producer information stored throughout ancillary systems within Horizon BCBSNJ integrated in the new ODS. Supports the incentive-based compensation system used in determining commissions and bonuses to be paid out to various sales channels. Approach: 3rd Normal Form party data model; Conformed Dimensions; Star Schema 2 • Defined data sources and data integration approach • Designed and modeled Operational Data Store (ODS) including producer profile/credentials, book of business, complaints, and payment subject areas • Designed, developed, and optimized for performance ODS Data Access Layer • Modeled dimensional (Star Schema) Data Mart • Documented Data Dictionary and Data Lineage. Performed data profiling and data analysis • Led ETL and application framework design and development
Data modeling tool: ER/Studio Data Architect
Environment: Oracle, Informatica, SAS EBI, SAP (CallidusCloud) Commissions application
Customer Relationship Management (CRM)
Quantitative Marketing data centric framework & Marketing Database
Foundation for all Horizon direct marketing operations, analytics, and reporting. Approach: SAS Marketing; time variant 3rd Normal Form party data model
• Defined CRM data centric architecture. Created Proof-of-Concept Prototype
• Developed conceptual, logical, and physical Marketing Database data models • Developed and tuned optimized for performance database access layer components • Acted as a primary technical contact for SAS, Acxiom, Infogroup and IBM vendors • Designed metadata driven ETL framework. Led ETL design and development • Maintained dev. Oracle database • Designed marketing campaigns, developed data merging and matching algorithms
Data modeling tool: ER/Studio Data Architect
Environment: Oracle, Informatica, SAS Marketing Automation application, MDM data hub, Siebel CRM, Salesforce, Horizon Sales Portal, Zipari Broker Portal, Acxiom, Infogroup and direct mail/email
Enterprise Data Model (EDM)
Modeling approach – Party/Universal Patterns (Len Silverston), 3rd Normal Form Defined and modeled Prospect, Party, Contact, Enrollment, Product, Communication Event, Rate, Underwriting, and Sales subject areas (topics)
Data Strategy for Sales and Marketing domains
Developed enterprise data strategy for Horizon BCBS Sales and Marketing domains
New generation Data Warehouse and Data Analytics (BI) Platform
Hadoop Data Lake, one Teradata database, and Domain Data Mart (Hadoop, Hive)
• Designed Enterprise Data Warehouse framework to integrate and aggregate enrollment, claim, state surcharge, provider payment and settlement topics to support underwriting, actuarial and finance domains. • Developed conceptual, logical and dimensional (Star Schema) data models • Defined data flows, data sources and framework architecture
3 • Led physical data modeling and Data Mart design • Guided data strategy, data governance and ETL development • Designed and modeled Logical Data Warehouse (LDE) component to integrate infrastructure, application, security and technology information from multiple sources.
IBM BPM platform; dimensional, star schema Data Mart.
Designed and modeled Data Mart to support operational reporting and SLA metrics.
March 1997 – August 2012
Cigna Group Insurance Philadelphia, PA, USA Lead Data Modeler, Principal Database Consultant, Application Development Manager
Selected projects and responsibilities:
Subject Matter Expert (SME)
Life, Accident, and Disability products - Consumer, Policy, Client, and Claims domains
Data Architecture
• Prepared guidelines and Proof-of-Concept prototypes for Cigna Group Insurance projects • Developed Data Models to support Cigna Group Insurance applications • Developed Enrollment conceptual, logical, and physical data models Model provided pattern for policy, eligibility, and coverage subject areas for the enterprise projects (Book of Records and authoritative databases) • Developed conceptual, logical, and physical data models for Consumer Domain databases - Consumer Authoritative (BOR), Staging, Process Control and Metadata Repository • Designed and modeled data warehouse Data Warehouse Architecture – Corporate Information Factory. Single repository of integrated sales, financial, policy and eligibility data. Data Marts – star schemas with a subject area focus. Environment: DB2 LUW, SQL Server, DataStage
ETL & ELT design and development
Designed and developed ETL & ELT components. Environment: UNIX, z/OS, Windows, DB2 - SQL PL stored procedures, SQL Server - T-SQL stored procedures, SSIS, COBOL, DataStage
Application Development Designer/Data Modeler/Technical Leader/Developer
Consumer Feed (Eligibility and Enrollment data intake; B2B interface):
• Developed eligibility and enrollment data exchange standards (based on EDI 834) between Group Insurance and Employers (Clients)
4 • Designed, developed, and implemented automated metadata driven system to accept eligibility and enrollment files, audit, validate and load consumer data into several Group and vendor database
Cigna Group Insurance Enrollment System
• Application supported Life, Accident, and Disability products. System interfaces included complex batch, Internet, IVR and desktop components as well as data movement between various data sources including billing database and data warehouse • Responsible for the system design, development, implementation, ongoing production support (onsite & offshore models) and problem resolution
Project DBA Created and maintained development and test DB2 and SQL Server databases.
National Account implementation
Technical Leader
• Leading role in 30+ national account implementations (Honeywell, Administaff, UAL, Philips Electronics, Cornell University, Meijer, EDS, Kellogg, Aramark, AT&T, CompUSA, CSX, J.B. Hunt, Sprint, etc.) for Group Insurance products • Acted as a primary system’s contact to account managers, business owners, users, Cigna technology groups, clients, brokers and TPAs (3rd party administrators)
Systems Analysis Created systems requirements for database centric projects.
Training
• Prepared and taught DB2 class for Cigna developers
• Provided SQL, SQL PL and T-SQL coding and tuning guidelines
Production Support Facilitated Consumer Domain applications conversion from in-house to offshore production support model.
March 1999- August 2002
Advanced Computer Concepts and Technologies (ACC&T) Pikesville, MD USA Part time instructor responsible for teaching courses and providing hands-on training in relational & dimensional data modeling, database design, and Oracle SQL & PL/SQL intermediate and advanced.
June 1995 - March 1997
CGI Systems Inc. (CGI an IBM Company) Berwyn, PA USA Consultant Served as Information Technology consultant for large corporations • Towers Perrin: Converted mainframe/DB2 application to UNIX/Oracle. • PECO Energy & Nuclear: Supported DB2 and Oracle applications. • Prudential Insurance: Supported mainframe applications.
5 May 1994 – May 1995 Hospital Billing & Collection Service (HBCS) New Castle, DE USA Senior Programmer Analyst Developed and supported Mainframe and UNIX components of the billing application.
1981 - 1992 Moscow, Russia
Moscow Institute of Technology Senior Engineer Designed software and hardware used in different types of industrial facilities. Performed sophisticated calculations, data and process modeling.
PUBLICATIONS Book ImmunoHematology Framework (IHF): A Universal Operating Model for the Blood Transfusion Domain / Gennady Peysakhovich, et al., 2022 (1)
Book defines a unique and novel platform for the resolution of several of the difficulties associated with transfusion medicine. Book offers a comprehensive approach for ensuring patient safety, ideal donor selection, optimal red blood cell unit distribution, and efficient long-term blood bank inventory operations. This logical framework combines original medical research with novel scientific concepts and is implemented utilizing systems engineering tools, models, and processes along with data analytics techniques.
PATENTS
Patent № 17449802 of the United State; 10/19/2022.
Publication No: US-2023-0104903-A1 Date: April 6, 2023 “Comprehensive approach to blood transfusion information analysis to ensure patient safety, optimal donor selection, red blood cell unit distribution optimization, and blood bank long-term operational efficiency”. Inventors: Peysakhovich Gennady, Butina Elena, Friedman Garrett.
EDUCATION and CERTIFICATION
1975 – 1981 Moscow, Russia
Moscow Power Engineering Institute – Technical University MPEI (TU) Master of Science in Electrical Engineering (Degree is evaluated by UNESCO the Commission for Equivalence. Registration N 003179)
IBM Certified Solutions Expert: DB2 UDB Database Administrator
6 OTHER
Languages: English (full professional proficiency), Russian (native proficiency), Belarusian (fluent), Ukrainian
Interests: Chess master and coach.
Winner of the 1995 and 1996 New-York Open Chess Championships
Citizenship: US Citizen
INFORMATION TECHNOLOGIES
Database Management System & Data Architecture
Oracle, SQL Server, DB2, Teradata, Hadoop ER/Studio Data Architect, erwin, Power BI, SAS EG, Informatica Cloud Azure: Data Factory, SQL database, Data Lake, U-SQL, Synapse Analytics Programming and Scripting Languages SQL, DB2 SQL PL, Oracle PL/SQL, SQL Server T-SQL JSON, C, UNIX shell, COBOL, JCL, Easytreave Plus, CICS Tools LeanIX, Jira/Confluence, Visio
SKILLS & CONCEPTS
Data Architecture: Data Warehouse, Data Mart, Data Lake, Data Lakehouse, Data Integration, ETL, ELT, Business Intelligence (BI), Master Data Management (MDM), Metadata, Data Profiling, Data Governance Data Modeling: Conceptual & Logical & Physical data models, 3rd Normal Form, Time Variant 3rd Normal Form, Dimensional, Star Schema, MDM Star, Enterprise Data Model Development: Mainframe, UNIX, DB2, SQL Server and Oracle development frameworks Methodology: Waterfall, Rapid Applications Development (RAD), Agile Performance: Relational Data Model optimization, SQL performance tuning
References and recommendation letters upon request
