LYLE ORR

Lead architect and developer of enterprise-scale, history-based Enterprise Data Warehouses (EDWs) designed to provide a single source of truth with complete audit trails and traceability from source system to reporting layer. Specialized in building BI-ready data platforms that minimize downstream development effort and enable rapid delivery of analytics, dashboards, and executive reporting.

Designed and implemented multi-system EDWs integrating data from DB2, SQL Server, cloud applications, financial systems, EMR platforms, CRM solutions, and operational source systems. Developed straightforward, maintainable source-to-target transformation frameworks with clear lineage, enabling organizations to quickly trace metrics from Power BI reports back to originating transactions.

Led projects through the full lifecycle including requirements gathering, data modeling, architecture, ETL development, data governance, testing, deployment, and executive analytics delivery. Successfully delivered large-scale data warehouse initiatives on time and within budget, resulting in production systems used daily for operational, financial, and strategic decision-making. Focused on delivering business outcomes rather than simply moving data, creating trusted analytical platforms that drive operational efficiency, revenue growth, and informed decision-making.

Industry Experience:

• Healthcare
• Telecommunications
• Insurance
• Professional Services

Healthcare Domain Experience:
Multi-system healthcare and EMR environments including:

• Anesthesia
• Dental
• Vision & Orthodontics
• Hospice & Palliative Care
• Behavioral Health / Mental Health
• Revenue Cycle and Financial Reporting
• Clinical Operations and Provider Analytics

Core Specialization:

• History-based Enterprise Data Warehouses (EDW)
• Dimensional Modeling (Kimball Methodology)
• BI-Ready Data Architecture
• Data Governance and Data Lineage
• Executive Dashboards and KPI Frameworks
• Power BI, SQL Server, Azure, AWS, Snowflake
• Source-to-Target Mapping and Traceable ETL Design
• Multi-System Data Integration and Master Data Management

• Responsible for the data organization and all team members both onshore

and offshore.

• Designed and deployed data warehouse and analytical solutions for

companies in multiple business sectors, majority in healthcare. Healthcare

including Anesthesia, Vision, Dental, Ortho, Staffing/Travel, Hospice and

Palliative.

• Experience with rapid growth private equity acquisition models

incorporating new acquisitions into business intelligence platforms.

• 100% deployment and adoption success rate with major business

intelligence platforms

• Constant eye on security and practices to prevent risk of client data exposure.
• Design and modeling for various business applications (transactional).

• Responsible for all analytic structures for largest Long Term Care Insurance

Third Party Administrator in the US

• Extensive understanding of insurance products, underwriting and post policy issue analytics in both group and individual insurance markets.
• Responsible for all relationships with Actuarial departments internal and at

customers for accurate reserving data management. Spoke at several Long

Term Care Actuarial conferences.

• Frequently engaged with C-Suite at top 10 Insurers in the US.
• Managed data collections and analytics for acquired company that provided

3 in 1 home health services (Nursing, Durable Medical Equipment, Infusion)