Azure Cloud Health Care

ILYA TSEITLIN, MS

Buffalo Grove, IL 847-***-**** **********@*****.*** https://www.linkedin.com/in/ilyatseitlin SUMMARY

Result-oriented PRINCIPAL DATA AND SOLUTION ARCHITECT with 20+ years of Expert Level experience. The effective combination of decision-making and leadership skills, along with a team-player attitude have always been keys to forming successful and productive relationships with co-workers and business partners.

Domains: Health Care/Finance/Insurance/Retail Data Architecture, Solutions & Design 20+ years

Data Modeling (Conceptual, Logical & Physical) Data Flow; Data Lineage; MDM; Data Profiling;

(ERwin; Lucid Chart) 20+ years Standards & Principals; Performance Tuning 20+ years

Team Leadership/Staff Training 20+ years EHR, HIE, EDW, HL7, Payer Mart; Data migration 15 years

Agile Framework; DevOps; GitHub 5 years Azure Cloud based Lakehouse 5 years

Databricks; Synapse; Python; Spark; ADF 4 years Quality Assurance Strategies 20+ years

Databases: SQL Server; Oracle; No SQL; Mango ETL/ELT Data Mapping & Transformation Rules 20+ years

POC Agile Framework 5 years

PROFESSIONAL EXPERIENCE

SSM HEALTH, St. Louis MO 2021 – 2024

Data Architect Principal

Expert in modern (Cloud-based Lakehouse and on premises EDW solutions) and industry standard data practices and technologies: Designed and architected transition to Azure Cloud based Lakehouse for Health Care enterprise with 30+ hospitals. Responsible for strategic planning and tactical solutions. Tech Stock: Azure Cloud, Lucid Chart, ERwin, SQL Server (on prem and Cloud), Oracle, Databricks, Synapse, Python, Spark, Azure Data Factory (via pipelines), BI, DevOps, GitHub.

Assessed and documented current data consumption and ETL practices within the organization. Defined a future state architecture that supports scalable, secure, and compliant data infrastructure both for on premises as well as for AZURE cloud platform. POS included Synapse and Databricks.

Developed and documented data architecture that aligns with the business needs. Performed data quality checks, analysis, and drove data integration. Influenced the data strategy and ensured alignment with business objectives, regulatory requirements, and best practices. Delivered E2E roadmap and design for EDW via Lakehouse (Databricks & Synapse).

Responsible for design and maintenance of all aspects of data solutions including modeling, data diagrams and data dictionaries (MDM), along with technical documentation (Data Flow, Data Lineage, Transformation Rules (ELT via pipelines), ERDs, DDLs, and technology choices). Solution included loading Data from multiple sources to Azure Data Lake, processed using Databricks (Raw – Bronze – Silver – Gold), presented via Star Schemas for BI. ADF pipelines were used for the orchestration. Entire E2E Solution is source and presentation layer agnostic. Both POCs were made for (Databricks & Synapse).

Built strong relationships with business partners and technology teams. Ensured that data architecture and solutions are aligned with the technologies to provide the best outcome for the business.

Delivered Enterprise-level LDM with multi-phase approach to achieve strategic target state along with intermediate, tactical, tangible (time to market). Collaborated with partners, data scientists, and stakeholder teams to deliver data-driven solutions designing, documenting, and implementing scalable, secure, and future-ready data architecture solutions.

Evaluated emerging tools and technologies and recommended adoption that will provide competitive advantage and development/delivery efficiencies.

Implemented measures to ensure data accuracy, accessibility, and security, adhering to best practices and compliance requirements. Provided guidance and hands-on help in performance tuning; defined data standards and principals (MDM).

Established standards and guidelines for the design & development, tuning, deployment and maintenance of information and advanced data analytics.

ILYA TSEITLIN, MS PAGE TWO

RUSH HEALTH, Chicago IL 2012 – 2021

Solution & QA Supervisor, Lead Solution Architect & Lead Data Architect Expert in the BI/DW Solutions and Architecture: Designed, architected, set ETL mappings, supported implementation and led Design, Architecture, and QA for multiple Data Marts and pre-existing DW.

End-to-end Data Flow and Data Transformation solutions. Translated business requirements into technical specifications, including data streams, integrations, transformations, databases, data warehouses, and data marts.

Led Requirement Gathering – BRD – Technical Specification – QA – Deployment

Provided Conceptual, Logical, and Physical database modeling.

ETL mapping with entire rule set; design and implementation of comprehensive ETL QA methodology.

Managed DA and QA teams.

Performance tuning lead with more than 50% performance gains; Data Profiling lead; Reverse/Forward Engineering lead.

TEKSYSTEMS, Schaumburg, IL 2011 - 2012

Consultant, Data Architect/Data Modeler (client – Office Max, Naperville, IL) Expert in the BI/Data Warehouse architecture (retail client). Performed full cycle of Data Analysis and Data Modeling.

HSBC (Bank), Mettawa, IL 2009 - 2011

Sr. Consultant, Database Management

Hands-on senior Data Management Consultant. Successfully built and maintained multiple complicated data models along with metadata analysis, always received the highest rating from both business partners and peers. CNA INSURANCE, Chicago, IL 2000 - 2009

Sr. Data Architect & Reporting Repository Manager

Hands-on team leader: Data Architect, and Data Modeler. EDUCATION

Master’s Degree in Computer Science

Moscow State University of Railway Transport, Moscow, Russia

Contact this candidate