Corporate Redesign

---

Situation - Five people were inputting, managing, reporting, and scouting for talent, each using a different file. They used three excel files and two Access databases. The concern was for accuracy, reporting. 

Goal - Design and create an application to replace ~5 files with common data into one database. The application frees up the time for actual work instead of repetitively inputting common data.

The application was created in industry-standard Microsoft Visual Studio .NET C# with a SQL Server database backend. I also set up SQL Server Reporting Services to display reports of  data.

Users

Interviewed all the people who would use the application and generated personas.

• Human Resources - Lisa and Trina
• Business Development - Bob
• Administrative - Kitty
• Management - Daniel

Team

• Leah Berry - customer
• Leslie Palmer – lead, coding, design, and database.
• Debbie Hensley – database
• Dwight Cross– IT support

Application - Worked with clients using Adobe XD, once layout was created, the fun began.

Weekly Reports - A weekly report of the list of priorities and code dumps to QA site while I remained working in Dev.

SQL Reports - SQL Server Reporting designed reports, and management. Creation of views, queries, stored procedures, and more.

Published and trained users with presentations and How-to Manual