Project Overview:
The Smart Archive project addressed the challenge of fragmented Electronic Medical Record (EMR) data across multiple legacy systems. I led the development of a centralized reporting solution to provide clinicians and staff with a unified view of patient information, significantly improving data accessibility and reducing operational costs.
Business Challenge:
Northwestern Medicine faced difficulties in efficiently retrieving complete patient records due to data residing in 11 disparate legacy systems. This resulted in:
- Time-consuming and incomplete data retrieval for patient care.
- Increased operational costs associated with maintaining multiple legacy applications.
Solution:
I designed and implemented a comprehensive data integration and reporting solution using Microsoft SQL Server technologies. Key components included:
- Data Integration: Developed SSIS ETL packages to extract, transform, and load data from the 11 legacy systems into a centralized data warehouse.
- Data Modeling: Created a relational database schema optimized for reporting and data retrieval.
- Reporting: Designed and deployed interactive reports using SSRS, providing users with a unified view of patient information.
My Role:
As Data Architect, I was responsible for the end-to-end delivery of the Smart Archive solution. My key contributions included:
- Collaborating with business users to gather and define requirements.
- Analyzing source system data structures, metadata, and business rules.
- Developing source-to-target mappings and data transformation logic.
- Writing complex T-SQL queries, stored procedures, and common table expressions.
- Developing and optimizing SSIS ETL packages.
- Ensuring data quality through rigorous validation and testing.
- Designing and developing SSRS reports.
- Managing the product backlog and prioritizing development tasks.
- Conducting user acceptance testing (UAT) and supporting user adoption.
Results/Impact:
The Smart Archive solution delivered significant benefits:
- Accelerated data retrieval by 10x, enabling clinicians to access patient information more efficiently.
- Ensured completeness of EMR records, improving the quality of patient care.
- Reduced legacy application maintenance costs by over $2 million annually.
More Projects
A curated showcase of data-driven projects, insightful dashboards, and creative problem-solving.
TradeSpark is a Power BI-driven analytical solution designed to analyze global trade flows, identify import trends, assess market opportunities, etc. This project highlights my expertise in advanced data modeling, complex DAX calculations, crafting interactive visualizations, and delivering compelling data narratives.
The Smart Archive project addressed the challenge of fragmented Electronic Medical Record (EMR) data across multiple legacy systems. I led the development of a centralized reporting solution to provide clinicians and staff with a unified view of patient information, significantly improving data accessibility and reducing operational costs.