Learn Data Skills
Beta
John Clark

John Clark

Data Architect

Oracle | Kalamazoo, MI

Technologies

My Portfolio Highlights

My New Track

Understanding Data Topics

My New Course

Introduction to Python

My New Track

Understanding Data Topics

Data guru, harnessing the power of information for actionable insights.

My Work

Take a look at my latest work.

course

Understanding Data Science

course

Introduction to Python

course

Intermediate Python

course

Understanding Data Science

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate Python
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Oracle | Oct 2022 - Present

Data Architect

N/A

Cerner Enviza | May 2022 - Mar 2023

Data Architect

Develop an organizational data strategy that addresses industry requirements through collaboration with IT teams and management Build an inventory of existing and new data needed to implement the architecture Identify and evaluate current data management technologies Develop data models for database structures Design, document, construct and deploy database architectures and applications Implement measures to ensure data accuracy and accessibility Monitor, refine and report on the performance of data management systems Merge new systems with existing warehouse structures
Show More

Ascension | Jul 2021 - May 2022

Data Analyst

N/A

Ascension | Mar 2021 - Jul 2021

Service Delivery Manager

-Trained development and leadership teams on Kanban process and workflow -Ensured all active work items moved smoothly through Kanban system -Facilitated Kanban ceremonies -Created reports to help monitor process in ServiceNow and Jira -Created dashboards in ServiceNow and Google Sheets for internal and external customers to help monitor progress of backlog -Utilized Jira reporting to monitoring process efficiency metrics, including cycle time, cumulative flow, and created/resolved gap -Worked with development and leadership teams to implement Kanban and achieved a 25% improvement in value add activities compared to the previous Scrum process -Worked with Service Request Manager in the intake and prioritization of new requests

Ascension | May 2020 - Mar 2021

Scrum Master

-Coordinated with leadership team to merge the Custom Programming team and another team that supported alerting and automation create a new Custom Solution Development team -Trained development and leadership teams on Scrum process and workflow -Facilitated Scrum ceremonies -Removed development team barriers and roadblocks -Worked with Product Owner to maintain and prioritize backlog -Created reports to help monitor process in ServiceNow and Jira -Created dashboard in Jira to help monitor progress of backlog -Created dashboard in Google Sheets to measure process efficiency, including sprint velocity trending and projection, average sprint scope change, sprint commitment reliability, and backlog health -During the COVID-19 pandemic, worked with several teams to architect a solution to automatically flag patients’ COVID-19 testing status in health systems across 9 states

Ascension | Mar 2019 - May 2020

Scrum Product Owner

-Worked with development and leadership teams to begin utilizing agile methodologies, first among the electronic health record product line -Trained development and leadership teams on Scrum process and workflow -Worked with customers and development team to maintain and prioritize backlog -Facilitated refinement and sprint planning ceremonies -Created reports to help manage backlog in ServiceNow and Jira -Created dashboard in Excel for internal and external customers to monitor backlog and team performance -Worked with Director and Senior Director to create series of dashboards used to negotiate pricing between organization and primary electronic health record vendor, saving the organization anywhere between $10 and $20 million dollars over the course of 3~5 years utilizing datasets from 3 different disparate systems

Ascension | Dec 2018 - Mar 2019

Solution Development Lead

-Worked with manager to assign tickets based on developer skillset -Facilitated bi-weekly (twice a week) meetings to assign work and capture status updates -Worked with development team to remove any barriers and roadblocks -Worked with customers to review and prioritize backlog

Ascension | Sep 2018 - Dec 2018

Interim Manager

-Operated in a interim-manager role due to previous manager's departure from the organization -Coordinated with leadership to form Custom Programming team in electronic health record product line whose focus was to create various custom solutions that was not natively available from vendor -Responsible for mentoring and/or facilitating the mentorship of new team members and other associates through job shadowing, mentorship, and structured courses. -Worked with Director to address any issue or concerns raised by the team -Assigned tickets based on developer skillset -Facilitated bi-weekly (twice a week) meetings to assign work and capture status updates -Worked with development team to remove any barriers and roadblocks -Worked with customers to review and prioritize backlog

Ascension | Oct 2015 - Sep 2018

Team Lead II

-Responsible for development of reports and support of Meaningful Use and NHQM initiatives. -Leading the Cerner CCL (Cerner Command Language) team, encompassing 8 health systems across the nation, in the development and management of new and existing reports. Additionally support reporting of all EH Meaningful Use objectives. -Responsible for mentoring and/or facilitating the mentorship of new team members and other associates through job shadowing, mentorship, and structured courses. -Performed review and intake of new report requests and modifications to existing ones across 8 hospital systems. Worked with clinical transformation and other clinical resources to gather specifications and prioritize work at said locations. -Created Excel and PowerBI dashboards for executives, prioritization committee members, and clinical staff at 8 hospital systems. This includes identifying potential data points to capture and analyze as well as developing and visualizing metrics to support organizational goals. -Created dashboard that automatically generated a Gantt chart from primary ticketing system, ServiceNow, to communicate expected delivery dates for reports and extracts -Supported clinical and support staff with well-defined documentation and education materials. Coordinated building and driving CCL (Cerner Command Language) team on-call rotations in order support clinical staff, including providers and nursing. -Maintained and facilitated maintenance of Cerner production domain, three non-production domains, and two training domains with build, database, and code level changes in coordination with ITGC and Change Control procedures -Facilitated the testing all system changes impacting reporting technologies. Developed and ran queries for all clinical and IT staff. -Created skillset analysis dashboard for over a hundred employees in order to assist product line support leadership to better reorganize teams according to skillset and experience

Ascension | Sep 2013 - Oct 2015

Solution Development Senior Analyst

-Responsible for development of reports, non-pharmacy based Clinical Decision Support (rules and alerts), MPages, and support of Meaningful Use and NHQM initiatives. -Responsible for leading the Cerner CCL team in the development and management of new and existing reports. Additionally supported Lighthouse Quality Measures and reporting of all EH Meaningful Use objectives. -Responsible for mentoring new and fellow CCL team members and other associates through job shadowing, mentorship, and structured courses. -Responsible for review and intake of new report requests and modifications to existing ones. Working with clinical transformation resources to gather specifications and prioritize work. -Maintained Cerner production domain, three non-production domains, and two training domains with build, database, and code level changes in coordination with ITGC and Change Control procedures -Tested all system changes impacting reporting, MPage, and Clinical Decision support technologies. Develop and run queries for all clinical and IT staff. -Coordinated with hospital leadership to create an internal electronic health record webpage used by nursing to help document and communicate patient information during shift handoff. Results of the work was co-presented between a hospital leader and myself at the 2015 International Conference on Healthcare Information Technology Advancement at Western Michigan University. -Created a program to automatically disable user accounts that were underutilized after 180 days -Created ED Throughput dashboards that were utilized to measure various patient throughput metrics (door to check-in, check-in to bed, bed to discharge, etc.) in over 10 emergency departments across the state of Michigan -Created automated backup system to store digital copies of paper blood bank order requisitions in case of planned or unplanned printer downtime

Ascension | Aug 2011 - Sep 2013

Solution Development Analyst

-Responsible for development of reports, non-pharmacy based Clinical Decision Support (rules and alerts), MPages, and support of Meaningful Use and NHQM initiatives. -Coordinated with fellow Cerner CCL (Cerner Command Language) team members in the development and management of new and existing reports. Support Lighthouse Quality Measures and reporting of all EH Meaningful Use objectives. Additionally, supported the maintenance and development of Clinical Reporting (Win32). -Support clinical and support staff with well-defined documentation and education materials. Participated in on-call rotation in order support clinical staff, including providers and nursing. -Maintained Cerner production domain, three non-production domains, and one training domain with build, database, and code level changes in coordination with ITGC and Change Control procedures -Tested all system changes impacting reporting, MPages, Clinical Reporting, and Clinical Decision support technologies. Develop and run queries for all clinical and IT staff.

Ascension | May 2010 - Aug 2011

Solution Development Associate

-Solution Development Associate specializing in Cerner Millennium (Electronic Health Record) front-end applications and back-end design, build, reporting, Clinical Decision support, and support tools for all health care venues including: Inpatient, Emergency, Hospital Outpatient, Ambulatory, and Ancillary (Radiology and Laboratory). -Sole resource responsible for development of reports, non-pharmacy based Clinical Decision Support (rules and alerts), MPages, and Clinical Reporting (Win32). Additionally, supported Cerner core, orders, and PowerForms. -Supported clinical and support staff with well-defined documentation and education materials. Participated in on-call rotation in order support clinical staff, including providers and nursing. -Maintained Cerner production domain, three non-production domains, and one training domain with build, database, and code level changes in coordination with ITGC and Change Control procedures -Tested all system changes impacting reporting, MPages, Clinical Reporting, and Clinical Decision support technologies. Develop and run queries for all clinical and IT staff.

Memorial Hospital of South Bend | Jun 2007 - May 2010

Computer Operator / Part Time Programmer

-Supported Data Center operations -Distributed batch print jobs -Created C# program to automate configuration file deployment to hundreds of devices on network -Completed deployment of web-based viewer of sunsetted electronic health record system using C# and ASP.NET

Best Buy | Oct 2009 - Jan 2010

Geek Squad Agent

Assisted customers in troubleshooting issues with desktops, laptops, and mobile devices

My Education

Take a look at my formal education

Bachelors of Science, Computer ScienceIndiana University South Bend | 2009

About Me

John Clark

Self proclaimed data nerd with a passion for life sciences

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free