With the largest wholesale distributor of landscape supplies, I work to improve the application of People Analytics to further the influence of HRIS and HR as a strategic force. Builds and visualizations include the use of PowerBI, SQL, Excel PowerPivots, and Project Management Skills.Worked with IT to build datasets in the data warehouse with HR data extracted via ETL. Metrics were built by IT in our data model using specs provided by me such as Average Headcount, Turnover %, Retention Rate, DE&I data percentages, etc. Testing and validation of the datasets at different organizational levels and different filters applied as well as enhanced custom DAX calculated fields created to confirm the data was working as expected.Experience here resulted in organization-wide exposure and impact. Strong written and verbal communication skills with a variety of backgrounds and specialties were necessary to ensure deliverables.

Provided knowledge based support for reporting and data analysis

Instituted the first reporting and visualizations for HR using Cognos, PowerBI, and Excel bringing the organization clear data analysis with statistical results that could be acted upon.Present stakeholders with strategic and tactical level solutions supported by research and statistical level analysis. These activities contributed to organization-wide goals working with leaders and individual contributors at all levels of the organization. Data focus included turnover, retention, engagement, attendance metrics, and salary analysis with focus on key metrics (Termination Rate, Retention Rate, Attendance Rate, Time to Hire, Time to Fill, Time to Time to Start and Cost per Hire). These metrics combined to tell the story of AZEK's status toward to goal of becoming a recognized leader and employer of choice.

Created and tracked ongoing performance metrics for Customer Service Representatives to be measured against on established or newly created standards of performance. This was at individual, site, and org level metrics that rolled up through senior leaders. Data provided support for annual performance reviews and performance improvement plans providing documentation for leaders and HR to effectively support employees in their career goals. Data measured was Time per Contact, Effectiveness of Contact, Time to Delivery, Rates of Improvement, Coaching activities from leaders and the results associated with coaching employees)

Created, tested, and ongoing support for online assessments specific to differing candidate populations. Worked with multiple teams including recruiting, Salesforce (internal team), iCIMS (internal team), and PSI (external vendor). Measurement of candidate results and percent hires per assessment type were gathered and anyalized.

Provided ongoing support to seasonal employees and took part in the creation of the seasonal workspace creation throughout Amazon Services on all Pepsi co-locations within the continental United States throughout the employee lifecycle.

Created a formalized onboarding process, reduction in turnover, and employee engagement activities.

Run standard and build ad hoc reporting. Build internal databases for data entry and records tracking as needed.