An Oracle SQL project to store, clean, and analyze employee workforce and salary data.
The project starts with Excel/CSV data and converts it into a structured relational database for business reporting.
- Oracle SQL
- Oracle SQL Developer
- Excel / CSV
- VS Code
- Git & GitHub
- Jira / Scrum
- Raw data import and validation
- Data cleaning and duplicate removal
- Department, Job Role and Location master tables
- Employee Master table
- Salary History tracking
- Primary Key and Foreign Key constraints
- Salary and workforce analysis
- SQL joins, subqueries, CTEs and window functions
- Reporting views
- Indexes and execution plan analysis
- Final data validation
- EMPLOYEE_RAW
- EMPLOYEE_CLEAN
- EMPLOYEE_MASTER
- DEPARTMENT
- JOB_ROLE
- LOCATION
- SALARY_HISTORY
Excel/CSV → Data Quality Check → Data Cleaning → Database Design → Oracle Tables → SQL Analysis → Reporting Views → Testing & Validation
- Raw Records: 200
- Final Records: 199
- Departments: 8
- Job Roles: 25
- Locations: 8
- Department-wise employee count
- Average and total salary
- Highest-paid employees
- Employees above company average
- Top employees by department
- Salary history analysis
- Hiring trends
- Workforce by location and status
This is a personal portfolio project created to gain practical experience in SQL Developer work, database design, data cleaning, reporting, Git/GitHub, and Agile workflow.