Data Architect Resume
5.00/5 (Submit Your Rating)
Phoenix, AZ
SUMMARY
- Motivated and results - oriented developer with broad experience designing and creating data applications. Diverse background includes extensive knowledge of web technologies, data analysis, modeling and migration, ETL architecture and implementation. Demonstrated ability to quickly grasp complex concepts, analyze, develop, and implement logical solutions.
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
Data Architect
Responsibilities:
- Assisted with Implementation and Documentation for Slicer Dicer and Cogito
- Custom ETL Development and Support for Vendors (Crimson and PHS)
- Liaison for Data Warehouse Vendors (HealthCatalyst)
- Completed SQL Development for Validation of Clarity tables against Cogito Data Warehouse
- Designed and Implemented Event-Based (Insert, Update, Drop,Delete) Solution for Backup of production SQL reporting objects.
- Backup Support for Business Objects Administration, Clarity Database, Cogito Data Warehouse, and more.
- Demonstrated desire and ability to quickly learn any application/data model that is required for duties. (Clarity, Cogito, HealthCatalyst, ITIL, and More)
Confidential
Consultant
Responsibilities:
- Design database queries and running client-level data reports on a regular basis to fulfill reporting requirements.
- Acting as a liaison between Confidential and the EMR Host to ensure seamless management of the EMR database.
- Provide application-troubleshooting support for Centricity EMR. Resolve the issue, forward it to the correct group for remediation, or elevate it to the EMR Host if required.
- Administer application security and access controls.
- Monitor application issues and evaluate issues as they arise.
- Create system specifications from user requirements.
Confidential, Chicago, IL
Sr. Data Architect/Analyst
Responsibilities:
- Designed and Implemented custom Data Warehouses/Marts for analysis of Patients, based on medical conditions. Provided custom SQL scripts/Crystal reports to external sites to enable reporting/analysis that was previously impossible for them to accomplish.
- Independently designed and created ETL workflows necessary to securely gather, encrypt, and upload key patient data to multiple national research networks for projects ranging from1 - 32 different databases.
- In first 3 months, gathered requirements, developed database, coded, implemented and created reports for complex analysis of potentially Undiagnosed Hypertension across 32 health centers and thousands of patient electronic health records.
- Provided production database backup strategy and design/implementation for over 30 databases; Acknowledged by senior staff for extraordinary effort during critical recovery after hardware-based down-time event.
- Created reporting database environments for sites within the network that resulted in substantial resource improvements and more effective utilization of the production database servers.
- Recognized and presented for several leaders and multiple community health care organizations within the Health Information Technology spectrum at Northwestern University, Purdue, and more.
- Migrated and optimized over fifty outdated Excel spreadsheets and reports to a universe-based Business Objects/SQL Server platform.
- Created several Utilization and Efficiency Dashboards, measuring Physician and Patient goals against government specified benchmarks. These Excelsius dashboards and Crystal reports were critical to the continued funding of many nationwide community health centers.
- Quickly learned and utilized Electronic Health Record codes (ICD, SNOMED), standards (HIPAA, HL7), lab observations, and data models to successfully deliver solutions.
