Garrett Shields Email & Phone Number

• Analyze human capital data of more than 350,000 employees and contractors across a Fortune 5 organization• Consult on more than 100 report/analysis requests of varying employee data domains and strategic talent initiatives• Lead and influence the implementation of new project and work management processes and best practices• Streamline and optimize work intake methodology of shared services team within large, matrixed organization• Design user-friendly, self-service, interactive dashboards containing key talent metrics and performance indicators• Manage relationships of stakeholder clients and data partners within organization• Coach clients through the learning and adoption of new digital analytics tools• Assist with enterprise-wide employee experience survey initiatives including data validation and post-survey analysis• Transform, model, and validate varied datasets using Alteryx, SQL Developer, Domo Magic ETL, and Power BI

Greater Minneapolis-St. Paul Area

• Support more than 50 reports daily for 200+ business users across 4 product segments totaling $4B revenue• Consolidate and blend data from SAP, SalesForce, CMMP, SAP Business Objects, Access, and Excel via Alteryx• Execute projects using agile methodology to deliver high value products amidst changing priorities and criteria• Develop integrated data solution for highly complex $1.5B pricing team valuing over $7mm in efficiency gains• Architect data using Alteryx for sales campaign tool to track a $700mm pipeline of annual business• Deliver training to introduce 40 analysts from across the United States to Power BI data visualization tools• Coach new analysts in variety of analytical tools including Power BI, SAP Business Objects, and Alteryx• Define, scope, and evaluate new projects to ensure prioritization of high-impact work• Optimize daily sales reports to leverage enterprise system data, replacing spreadsheets for $12mm sales team• Validate business data end-to-end from enterprise source systems and ETL middleware to final reports• Design interactive catalog tool in Power BI for end-users to browse available analytics reports• Query large amounts of information from Hadoop big data environment using SQL

Greater Minneapolis-St. Paul Area

• Fulfilled 6 month contract, and 3 month extension, in Global Talent & Performance Center of Expertise of a large food and agriculture industry client • Developed custom talent dashboard and deliver quarterly to HR leader of 80,000 employee business function• Generated quarterly and annual talent scorecards for 6 unique enterprises/functions within client organization• Fulfilled more than 20 data requests for enterprise leaders, HR leaders, and business partners• Utilized custom Tableau dashboards for cloud-based, self-service metrics reporting• Utilized Excel to conduct advanced ad-hoc reporting on client’s more than 130,000 employees• Conducted in-depth statistical analyses using SPSS for annual talent report insights• Managed survey administration for more than 15 internal Qualtrics surveys across client organization• Provided survey troubleshooting support to quickly resolve technical or logistical issues in the survey process• Developed standard operating procedures document for survey administration within Qualtrics• Trained international employee to conduct survey administration and ad-hoc reporting projects over 1 month• Assisted with cleaning, massaging, and formatting data from HRIS systems and employee databases

St. Cloud, Minnesota Area

• Consulted 50+ client projects in research design, data collection, and data analysis• Supported clients by creating surveys, coding, computing statistics, and presenting results to clients• Analyzed descriptive, inferential and multivariate statistics using SPSS, R, and Minitab statistical software• Managed projects for clients by meeting deadlines, communicating updates, and tracking billable hours• Served Master’s and Doctoral graduate students, university faculty, and external clients

Le Sueur, Mn

• Managed applicant tracking system for 6 branch locations and 38 requisitions• Created 14 requisitions, advertised job openings and sourced leads to continually bring in new talent• Conducted behavioral-based interviews with 45+ candidates for varying positions• Conducted 9 phone screens in addition to multiple reference checks• Assisted with employee investigation at an off-site branch location• Verified 60+ job descriptions for accuracy in performed duties and position requirements• Ensured EEO, ADA and ACA compliance with employment practices affecting more than 300 candidates• Developed intern needs assessment, 360 performance review, and department metrics scorecard• Created content for new-hire orientation, managerial training, and standard operating procedures• Cross-trained in high-turnover positions to describe duties to potential candidates

Mankato

• Supported on-boarding of new interns for Northwestern Mutual’s Top 10 Internship program• Assisted with recruiting efforts on campus by networking and setting up student seminars

Mankato, Mn

• Screened 14,000+ resume profiles using LinkedIn Recruiter to build pipeline of passive candidates • Created over 15 job profiles using Microsoft Word and marketed postings to online job boards• Researched 24 different applicant tracking systems and evaluated prospects through needs assessment

Master’S Degree, Industrial And Organizational Psychology

Activities and Societies: Co-President of Upward ConsultingCompleted coursework: Personnel Selection Psychometrics Training &.

Bachelor Of Arts (B.A.), Psychology

Activities and Societies: Mavericks for SHRM (Society for Human Resource Management), Industrial/Organizational Psychology Undergraduate.

Bachelor Of Science (B.S.), Ethnic Studies (Business/Corporate Concentration)

Activities and Societies: Mavericks for SHRM (Society for Human Resource Management), Industrial/Organizational Psychology Undergraduate.

High School Diploma

Activities and Societies: Wrestling, Lacrosse