Summary


I'm John, and I like to help! I have done a lot of Information Technology, Analytics, and Adjacent Work. Contact me if you'd like to collaborate.


Education


Experience


Military

Philanthropy

Operation Care Kit - an organization that works to assemble care packages for people experiencing homelessness in the Indianapolis area.

Visit the Operation Care Kit Facebook Page

Timeline


2023-Present
Business Intelligence Developer II
University of Pittsburgh Medical Center, Insurance Division
Design, Develop, and Maintain Pipelines, Subscriptions, Dashboards, Database Processes. Consult with users and stakeholders to develop novel reporting and processes. Evaluate, Improve, and Document existing artifacts to retain corporate knowledge.
2020-2022
Database Report Writer
Aspire Indiana Health, Noblesville, IN
Design & Develop data pipelines to move health data around the Cloud. Design & Develop novel reporting using tabular and advanced visualization tools. Consult with users and stakeholders about best courses of action to maintain and improve business information systems.
2019-2020
Undergraduate Researcher
Indiana University Purdue University Indianapolis (IUPUI)
Design and Develop React & React Native Cloud Hosted Web and Mobile Platform to Research Educational Efficacy and Mentor individuals and groups of peers while Document Solutions and communicating directly to Stakeholder

Teaching Assistant
Indiana University Purdue University Indianapolis (IUPUI)
Presented an hour of online video content as part of a weekly course teaching Agile Methodologies for Software Development Evaluated, gave feedback, and assisted grading for a class of two dozen students

Student Tutor
Indiana University Purdue University Indianapolis (IUPUI)
Assisted students in a variety of Software Engineering subjects to help them succeed in coursework Taught problem solving techniques and identified gaps in learning as well as resources to help the learner self-teach Promoted the use of data as a way to summarize group performance and identify opportunities

2016-2019
Data Analyst
Chewy Fulfillment Operations, Clayton, Indiana
Created, operated, and maintained automated systems that compiled and delivered specific reporting for seven warehouses Developed Excel models as a way to help to help managers identify successful staffing models Created and implemented processes to help employees in Training, Safety, and Operations departments collect and analyze operational and tactical data in order to elevate data-driven decision making

2012-2016
Reporting Analyst
Interactions LLC, Indianapolis, Indiana
Created, updated, and maintained spreadsheets used to support business processes creating macro programs where appropriate to support process automation Created, updated, and trained payroll computation process to support performance based compensation models supporting two thousand hourly part time employees Mentored and trained peers in the use and of complex spreadsheet formula and macro solutions Assisted and supported forecasting and scheduling plans adhering to requirements in half hour increments Created, Updated, and Supported spreadsheets used to manage employee performance Created, Updated, and Supported spreadsheets used to monitor and manage staffing levels
subject school work_outline security tag_faces timeline
contact_mail