Rightsize and Refresh Employee Base

Overall Description

Pewlett-Hackard is a large established company with over 300,000 employees worldwide. They have a large number of people near retirement age, and the company wants to offer early retirement packages to move those employees on to retirement, do succession planning in the management ranks and refresh the workforce. Senior Managers and HR need reports to answer the following questions:

1. How many employees overall will be offered the retirement package?
2. How many retirees are there by each of the 9 functional departments?
3. Who are the managers of those departments who will need the lists for planning?
4. What is the impact on overall salary costs?
5. What is the impact by job title?
6. Who are potential mentors which might be able to help train the new hires?

Resources

• 6 CSV files from HR on employee and department data. • PregresQL Database (free version) • QuickDBD ERD Design Tool (free version) • Visual Studio (capturing queries)

The FULL ANALYSIS is contained in the pdf file entitled Pewlett_Hackard_Analysis.

All QUERIES are contained in 3 text files in this repository.

ALL CVS output files are located in the DATA FOLDER of this repository.