Business Analysis communication with the client and developers to prepare an project documentation.
Creating databases from scratch in MS SQL or Amazon Redshift.
Creating tables, views, procedures, triggers etc. Designing the DB structure based on the clients needs.
Optimization of existing databases.
Data modeling with ERwin.
Developing DWH and Reporting databases.
Creating reports with Crystal Reports.
QA on the software and data in the DB.
Working with JIRA for creating project sprints and tracking spent time.