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.

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.
• 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.

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..
• 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