Додаткова інформація
Особисті якості, хобі, захоплення, навички: • design databases, data warehouses and data marts (star/snowflake);
• develop ETL processes with SSIS packages;
• design OLAP cubes;
• design fixed reports (SSRS);
• provide data mining modeling;
• SQL Server administration, issues fixing, performance monitoring;
• 15 years of Information Technology experience;
• Work with all versions of MS SQL Server (6.5 – 2012)
• DBs / DWH / OLAP architect;
• Solid understanding of OLTP principles, 3NF.
• Understanding of BI and DWH principles, best practices and technologies (Inmon vs. Kimball methodology);
• Solid skills with Microsoft Business Intelligence stack
• High level of experience using SQL Server, SSRS, SSIS, SSAS tools
• Understanding of DataMining algorithms
• Transact-SQL programming (stored procedures, functions, triggers)
• Microsoft SQL Server administration and maintenance
• Query optimization (SQL Profiler, statistics, indexes, query tuning)
• Designing maintenance plans (backup/restore)
• English - read/write technical documentations, intermediate level.Master’s degree in Computer and Intelligence Systems and Networks (1993-1998). Higher Military Institute of Control and Communication, Kyiv, Ukraine.Certificates (https://mcp.microsoft.com/authenticate/validatemcp.aspx Transcript ID:821719,Access Code: qazxswed):
• 2008: (MCTS) SQL Server 2005, Implementation and Maintenance
• 2010: (MCTS) SQL Server 2008, Business Intelligence Development and Maintenance
• 2013: Microsoft Certified Solutions Associate (MCSA) SQL Server 2012
• Courses in Computer Networks (1998). Ukrtelecom, Kyiv, Ukraine.
• Courses in OС UNIX, FreeBSD, Linux and Solaris (2003). Ukrtelecom, Kyiv, Ukraine.
• Seminar Building Data Storages with Sybase IQ (2007).
• Microsoft seminar Using Data Mining (2007).
• Microsoft course M2796 “Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005” (2007). Incom, Kyiv, Ukraine.