Joseph Dunlop Email & Phone Number

Salt Lake City Metropolitan Area

Maintaining and optimizing Workday platform.Testing Workday release functionality.Writing and maintaining reports both scheduled and ad-hoc.Revising business processes to streamline and meet new business needs.

Draper, Ut 84020

Preparation and Processing weekly and semi-monthly payrolls.Maintaining payroll and timekeeping system.Preparing ongoing and ad-hoc reporting.Creating and balancing payroll GL’s on monthly and quarterly basis.Tracking and accounting for all equity transactions

Draper, Utah

Preparation and Validation of Payroll import dataReconciliation of Payroll and HR systemsPreparation of Monthly, Quarterly and Yearly departmental performance reviewsEstablishing reporting metrics for Payroll shared servicesGenerating regular and ad-hoc reporting for Payroll related metricsIdentifying processes for automation and simplificationProgramming initial automation steps in IBM Cognos and Excel

Greater Salt Lake City Area

Providing regular and ad-hoc reporting for talent acquisition, compensation and benefits, learning and organizational development and HR executivesAutomating manual processes through the use of SQL database tools and Tableau to save 8 man-hours a week and increase report accuracyDevelop HR related infographics for executive staffAnalyze trends in HR data and provide forecastingDevelop and manage SQL based HR related data analytics warehouse with Tableau dashboards for HR leadersCreating Excel based macros to accelerate current reporting processes to save time and to decrease manual errorsCollaborate with HR leadership team to develop global scorecard to evaluate HR departmental successGather reporting requirements from stakeholders and transform these into reports providing meaningful insights

Greater Salt Lake City Area

Developed Excel based target setting and performance management model used in lines of business across the globeGenerated ad hoc and standardized reports for HR and performance metrics Collaborated with various global teams to assess the validity and trends of performance metricsDesigned global HR metric dashboard for use across all lines of business toevaluate headcount and attrition trendsAssisted in generation of promotional and performance evaluation review processesManaged and improved global performance evaluation processDeveloped Excel based reward processing systemsPresented data based information for strategic decisions to senior leadershipCreated web based talent acquisition tracking tool

Completed analysis for alternative workload management process, resulting in$4 million per year cost savingsManaged inventory of around 100,000 itemsBudgeted in excess of $12M annuallyScheduled local and contracted global workloadsGenerated specialized reports for workforce and asset availability and movementCommunicated with internal and external customers for work requestsPrepared regular reporting

Budgeting and accounting for officeOrganizing and managing projectsAssignment of projectsHiring and training professionalsManaging client relationships

Handling sensitive documentsInterviewing courier staffSimplifying interior mail system

Mba, Operations

Ba, Business Management

Ba, German