Pinned Loading

1. MS_Excel_Operational_Tasks_Scheduling_tool MS_Excel_Operational_Tasks_Scheduling_tool Public

   The tool is macro based program written in VBA and implemented in MS Excel office application. It's intend for back office corporate operations when it is necessary to allocate people and plan work…

2. AdventuresWork_Sales_Dashboard AdventuresWork_Sales_Dashboard Public

   This tableau dashboard was created and presented during the study period at Turing College. The dashboard were created for fictitious company named AdventuresWork. The business problem was to analy…

3. Compliance_Business_Rules_Improvements Compliance_Business_Rules_Improvements Public

   This is real example of one business process in the compliance area (FCP) which was changed and improved together with other team support. It took 2 - 3 month to change and optimize process steps f…

   VBA

4. Self_Project_Notes_Logger Self_Project_Notes_Logger Public

   Python script that logs notes and uploads them to persistent space (CSV file)

   Python

5. Optimized_MSSQL_Weekly_Statistics_Scripts Optimized_MSSQL_Weekly_Statistics_Scripts Public

   This was the task to optimize our department SQL queries whose we're running every week. The request process time was slow and required more than 1 server to get the data. Solution was to parameter…

6. ORMs_Test_PythonSQL ORMs_Test_PythonSQL Public

   MySQL data manipulation with python

   Python