T-SQL: Stored Procedures, Functions, Queryes, Views, Jobs, Linked Servers, Trigers OLAP ETL VBA. Microsoft Excel 2019: VBA, PowerPivot, PowerQuery, Pivot, Array Formulas, Data Model, DAX. Microsoft Office 2019 Parsing and structuring JSON, XML, HTML 1C - 8. 3 creation of reports and queries (both standard and through the query console) Working with large amounts of information