Jonathan Lindstrom Email & Phone Number

Hawaii, United States

Hawaiian Islands

Started as the first hire, to initiate an Enterprise Data Warehouse (EDW) and analytics program at Queen's with our partner vendor Health Catalyst. Served as a lead, to inform and execute EDW architectural decisions. Managed ETL batch processing and monitoring; designed automated SQL validations to ensure source data quality. Developed and implemented security architecture to sustainably manage access to data.Conducted numerous end-user training of physicians, organizational leaders, and senior executives explaining what the EDW program is, and how to leverage data in our applications to support process improvement.Developed extensive onboarding, training documentation, and team interviewing methodologies, scaling a team of 3 to a team of 16, including Data Architects, Project Managers, Analysts, BI/Application Developers, and DBAs.Served on Data Governance Sub-Committee to implement master data management strategies, centralize enterprise metrics and definitions, and to standardize visualization "look and feel."Initiated Queen's IT Automation program, introducing business process automation, automated testing, workload automation, and RPA to business units in a DevOps operating model. Epic Clarity on Oracle; Allscripts EPSi on MS SQL; HealthCatalyst Analytic Platform on MS SQL; QlikView; SSRS; Microsoft Sharepoint; ServiceNow; Asana; Slack;Internal Promotion: Data Architect II, up to Data Architect I (September 2016)Internal Promotion: Data Architect I , up to Senior Data Architect (December 2017)Internal Promotion: to formally initiate IT Automation Program (February 2019)Internal Promotion: to Manager (September 2019)

Hawaiian Islands

Designed, constructed, and maintained database objects driving annual NCQA HEDIS reporting (Reporting years: 2014, 2015).Leveraged regional Electronic Medical Record (EMR) data to build automated reports revealing trends in health system resource utilization, as well as chronic condition prevalence (supporting population health initiatives).Developed and maintained numerous quality and effectiveness-of-care measures; facilitated the reporting of rates and cohort values to drive outreach and inreach initiatives; as well as, tracked data through the life of each initiative to measure outcomes.Utilized data spanning multiple enterprise-level database platforms including DB2, Microsoft SQL Server, Oracle 11g, and Teradata DB.Utilized SQL Server Reporting Services (SSRS) to construct reports for on-demand, end-user consumption/distribution including data quality managment.Developed and maintained SQL Server Integration Services (SSIS) packages for scheduled/automated data integration and ETL: Epic EMR, Pharmacy, External Claims data.Epic Clarity on Oracle;KP Legacy and ePIMS Pharmacy;KPOPS and Epic Tapestry Claims;Microsoft Sharepoint;IBM Rational Team ConcertInternal Promotion: Developer I, up to Developer II (December 2014)

Hawaiian Islands

Architected and deployed tailored business solutions, including server and workstation deployments, managed antivirus protection, Microsoft Exchange, and Sharepoint; Microsoft Dynamics software - Great Plains (GP), Solomon (SL), Customer Relationship Management (CRM), Laserfiche document imaging solutions, and more.Specialized in virtualization, scripting/automation, and software development.Initiated software development division of High Performance Systems, Inc specializing in building custom solutions that automated and empowered workflows across various Microsoft technologies including: IIS; SQL Server; CRM; SL; Sharepoint.Attended Microsoft SharePoint Conference 2011.Deployed and maintained custom-built solutions through entire software development lifecycle (SDLC), such as, remote backup service client applications, Content Management Systems (CMS) deployments, Asterisk (VOIP) desktop caller-ID notification linked to CRM.

Hawaiian Islands

Conducted comprehensive data migration from IBM Maximo platform to SAP. Mapped all power plant equipment into KKS Classification System format via custom Microsoft Excel workbooks/VBA macros before mass import into SAP. Participated in corporate-wide shared-learning meetings.*AES Hawaii was the premier SAP migration site for the corporation (international).Designed BI dashboards using OSIsoft's PI System (real-time performance data analysis software for various power plant sensors); integrated logic in VB.NET.Developed and implemented custom maintenance calandar presentation software backended by IBM's Maximo asset management software, before their migration to SAP (Oracle via ODBC).Created Microsoft Access database to manage/maintain file server links to MSDS safety sheets - as a pseudo document library.

Hawaiian Islands

Maintained team's active and upcoming construction project schedules in Microsoft Project and Oracle's Primavera P3 and Primavera P6 project management software. Participated in formal corporate training in effective project scheduling practices utilizing this technology (primarily Gantt charting).

Master Of Business Administration - Mba, Healthcare Management

Course Project (Capstone Consulting Practicum): worked on a team of 3 - conducted internal and competitive market analysis for local.

B.S., Computer Science

Activities and Societies: ACM ICPC 2009, Computer Science Club Course Project: worked on a team of 3 - designed, developed, and deployed.