John Pyott Email & Phone Number

Seattle, Wa, Us

Responsible for assisting in the design, development and administration of the compensation programs and HR analytics. This position provides complex data analysis and services in support of the staff compensation plan, processes and pay structures. Provide, as well as write and maintain, complex reporting from the HRIS system. Complete compensation, finance, and other survey submissions by analyzing requirements and preparing responses. Responsible for independently administering select HR annual projects and HR reporting. Be a resource within the department and assist/train others in the use of Excel for HR processes. Be a resource to other department requests for HR data.

Seattle, Wa, Us

• Developed data mining and reporting tools using Tableau and Excel. Very experienced utilizing v-lookup, pivot tables and “if” statements etc...• Created several reporting tools and dashboards supporting compensation, attendance, turnover metrics, salary budgets, annual government reporting, audits and financials. Data extractions typically from HRIS (ADP and Ceridian).• Developed performance management tools utilizing Excel and Tableau.• Resident compensation analyst responsible for compensation survey submission and analysis including job analysis and evaluation.• Preparation, research and analysis of compensation data. Responsible for compiling compensation data for annual salary budgets and developing salary administration tools and dashboards.• Responsible for sourcing and recruiting Executive, Management, IT, Actuarial, Marketing, Claims, Underwriting, Operations & administrative staff. • Responsible for developing and launching a web presence for GIA to support recruiting initiatives.

Seattle, Wa, Us

Human Resources Specialist 1999 - 2002 • Supported a 600+ IT customer base. Responsible for sourcing and recruiting Managers, Architects, Developers, Business Analysts, QA and Networking professionals. • Provided performance management and employee relations counsel to management team. Certified SAFECO Trainer. Provide management training to new managers which include selection, compensation and performance management. Participated in campus recruiting efforts. Business Analyst 1997 – 1999 • Wrote detailed description of business user needs, program functions, and requirements to develop or modify computer applications.• Developed and managed project plans.Data Center Lead 1995 – 1997