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.

Analytics:
- Analyzing Information using Spreadsheets
- Recommending Comprehensive Solutions
- The Process & Management of Software and Operational Performance
- Reporting, Data, and Data Visualization
Computer Programming:
- Microsoft
- Google
  - Google Apps Script
  - Google Cloud
  - Google Assistant
  - Google Drive Automation
- Open Source Languages
  - Java
  - Python & Associated Libraries
    - Pandas
    - Numpy
    - Seaborn
    - Beautiful Soup
  - JavaScript & Associated Frameworks / Libraries
    - Node JS
    - jQuery
    - React JS
    - D3 JS
    - P5 JS

Education

Purdue School of Engineering & Technology, IUPUI || Expected Graduation: May 2020
- Bachelor of Science in Computer Information Technology
- Concentration: Software Development
- Major GPA: 3.6 on 4.0 scale

Ivy Tech Community College || Graduated June 2018
- Associates of Applied Science in Computer Information Networking & Systems
- Concentration: Database Development, Software Development
- Certificate in Java Development

Experience

Business Intelligence Developer II || December 2022 to Present
- Implemented SQL Server Reporting Services, Power BI, SQL Server Integration Services, and Scripting.
- Maintained, Updated, and Expanded Documentation Library hosted on Atlassian Wiki.
- Implemented Power Platform (Power BI, Power Automate, Power Apps) solutions.
Database Report Writer || February 2020 to December 2022
- Implemented Python Scripts, SQL Server Database, Apache Airflow Scripts
- Utilized Google Data Studio to implement dashboard visualizations to enhance reporting.
- Maintained, Updated, Constributed to reporting Libraries, Created Documentation
Operations Analyst || September 2016 to January 2019
- Implemented C#, SQL, VBA programs and scripting in support of process automation
- Utilized Tableau to implement programs and scripts to stage and aggregate data enabling data visualization
- Illuminated business problems in ways that allowed for insight, decisions, and improvements
- Trained peers in the use of office tools to enable operational processes and collect meaningful data
Reporting Analyst for Workforce Asset Management at the Interactions Corporation || March 2015 to September 2016
- Established employee attrition recording tools creating an ‘automated’ dashboard for Executive Leadership
- Implemented binning systems to show labor surpluses and shortages in high detail
- Taught team members complex formula operations in MS Excel and Google Sheets
Operations Specialist (Payroll) at the Interactions Corporation || November 2012 to March 2015
- Created and implemented Excel / VBA scripting, increase payroll processing speed and accuracy
- Reduced Payroll discrepancies to less than $1.00 on up to $500,000 / week payroll for 1500 employees
- Saved 20 labor hrs / week in processing/accounting labor costs using scripts and templates to analyze labor costs
Software Requirements Analyst at Intelligent Software Solutions || June 2012 to November 2012
- Collaborated with Global team to prioritize and queue development for stakeholders across four distinct platforms
- Evaluated database schemas enabling database administrators to ingest incumbent data for stakeholders
- Completed Software Requirements documentation identifying mockups, and tables for stakeholder requirements
Software Training Specialist at Intelligence Software Solutions || August 2011 to June 2012
- Trained various teams of Military specialists informing decision making and job specific reporting requirements
- Performed System Demonstrations and Training for Individuals, Small Groups, and Classrooms
- Created and Managed User Accounts Information for the System, collaborating with team leaders to capture hierarchy

Military

Indiana National Guard 38th Division Military Intelligence Analyst || May 2009 to May 2015
- Used Military Intelligence Analysis Training to analyze and assess probable Enemy Courses of Action
- Created mobilization information database in MS Access for Indiana National Guard J1 Mobilization Team

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