Simple analyst and data projects

Below are screen shots of two projects. The first one is a designed application based on customer requirements, CRM type for a car dealership, made in Visual Paradigm. The second is a database and data warehouse for a sales company, the project was made in SQL Server Management Studio.




UML

Class diagram

The UML Class diagram is a graphical notation used to construct and visualize object oriented systems.

UML

Requirement Diagram

A requirements diagram created from the customer description, first described in the documentation and transferred to the software where I added the verification method, severity and risk level and assigned to the appropriate department for implementation.

UML

Sequence Diagram

Adding an individual customer to the system.

UML

Use case diagram

A use case diagram represents a model of an application system and its environment. Actors are users - employees of a sales company, the diagram contains system functionality along with extend, include relationships.

UML

Activity diagram

Customer addition with verification code to the system, algorithm.

UML

State Machine Diagram

The diagram shows the steps for taking a salon customer for gita trial drive.

UML

User interface

Five-step form adding a new customer to an application.

SQL

Database

Production company database.

SQL

Data warehouse

The data warehouse is a reflection of the database, but in a more detailed breakdown.