John Haake II

Analyst | Consultant

Experience developed through knowledge, skills, and a natural technical aptitude is essential to any analyst role.  Below are samplings of work I have completed at previous employers for transparency and illustration.  More can be provided upon request.


Workday Metrics

Chart Drill Through

Large sets of data can be viewed in multiple graph formats quickly; data elements can be drilled into for additional graphs and/or to view the detailed data that comprises the report.

Workday


Dashboard Worklets

Chart Attrition View

Workday's seemingly infinite reporting flexibility has the advantage of Worklet capabilities that enable a person to view and manipulate detailed data in a graphical format easily.

Workday


Excel

Logic & Calculation

Formula identifies employees eligible for bonus based on dates and calculates the prorated percentage for those eligible employees.

Excel Formula


Excel

Logic & Formatting

Formula chooses between First or Preferred name and combines choice with Last name to generate email address.  Second formula identifies non ASCII characters for editing.

Excel Formula

Excel Formula


Excel

IF Statement

Multiple formulas to round, group, and evaluate employment tenure and assign a predefined value range to the employee.

 Excel Formula

 Excel Formula


User Guide

User Guide

Manager User Guide

Manager Quick Start User Guide developed to supplement training and aide in user adoption for program roll out.

Education


User Guide

User Guide

New Hire Guide

New Hire Benefit Enrollment guide.  Used in conjunction with New Hire Orientation documentation as part of the Onboarding Process.

Education


User Guide

User Guide

User Application Guide

Created for internal use to enable low frequency Excel users with the ability to merge data from multiple Excel sheets.

Education