Yuriy — Data Solution Architect

(Expedia): Build Data Warehouse for Human Resource department integrating data from various internal and external data sources (including WorkDay). (Microsoft): Built solution for data mart and dashboards where Business metrics KPIs correlated with IT infrastructure health telemetry data. That is internal project to automate Finance Platform Services. Primary role functions: 1) built overall solution architecture and projects roadmap; 2) built data models; 3) established development process (managing onshore and offshore resources – up to 8 people); 4) delivered solutions to the client Extra activities: Pre-sales projects estimations, requirements gathering and scope negotiations with clients. Technologies/Applications: MS SQL 2014 full stack, VS, Tableau, PowerBI, Business Objects Web Intelligence, Azure services, ER Studio, AWS (Redshift)

Achievements: Successfully delivered architecture and roadmap of enterprise data warehouse integrating core business data sources (HR, ERP, Finance, and Engineering) along with other sources. Developed BI platform architecture based on data warehouse and data marts - integrating Tableau and SSRS. Implemented core components of DW and ETL. Successfully trained and guided team of BI developers in technologies and methodologies how to design, develop and maintain DW and BI infrastructure. Technologies/Applications: MS SQL 2008/2012, SSIS, SSAS, SSRS, VS TFS, Cognos, Tableau

Product: XBOX Insights and Business Intelligence Product Description: That is enterprise-level DW and BI system for collecting and analysis of data from XBOX gaming consoles and XBOX Live activities. It's constantly sourcing data (sessions, played games, watched videos, purchased content, subscriptions and etc.) from XBOX consoles around the world, content publishers and other sources. DW is implemented on distributed system COSMOS. BI part is on SQL stack. Responsibilities/Achievements: Developed set of new functionality in DW/ETL. Including build/deployment automation. Made significant performance improvements and optimizations in critical components of ETL. Provided day-to-day sustain engineering, adding new features, consulting on technologies, managing requirements, interacting with other teams and business users. Implementation of Big Data ETL components using distributed system COSMOS Technologies/Applications: MS SQL 2008, SSIS, SSAS, SSRS, VS TFS, COSMOS

Division: Windows Fundamentals, Windows Telemetry Product: Reliability Analysis Component (RAC) as the part of Windows Telemetry Product Description: RAC is client and backend component in Windows OS that provides detailed customer experience data for computers running the Windows operating system. Client component collects various statistical data on a machine and sends it to backend (in Microsoft data center). Collected data from millions machine gets transformed into RAC backend component (SQL databases) for further warehousing, data analysis and reporting. Daily incoming data volume wasover 80GB. Responsibilities/Achievements: Designed data model of DW and ETL infrastructure; Developed and supported data warehouse and ETL from end to end. Design, development, implementation and support of data marts (DM), Cubes and Reports. Large databases management – dozens GB of daily incoming data volume Technologies/Applications: MS SQL 2008, SSIS, SSAS, SSRS, SharePoint WebParts

Projects: 1) MySalesMetrics Scorecards (internal project) – datamart to compute and visualize various metrics and KPIs for Sales department of Microsoft. 2) Business Investment Funds (BIF) database and OLAP cube to support budgets planning. Position: Database/BI Developer, Team Lead Responsibilities: Design and development of DW data model, data profiling, data mapping, ETL processes design ETL development (SSIS + T-SQL), OLAP Cubes, SSRS reports, ad-hoc reports and Excel pivots Development leadership (onshore and offshore) Technologies/Applications: MS SQL 2005, SSIS, SSAS, SSRS, SharePoint

Responsibilities: Manage clients' requirements, databases design and development, data processing workflows/procedures development; OLAP DW development Projects management, offshore teams interaction. Facilitating between the programming teams, project managers, project coordinators and technical leads Requirements management - clients communication, analysis of client's needs, gap analysis, requirements modification tracking; prepare feasibility studies, proposals, cost/benefit analysis Technologies/Applications: MS SQL Server 2000/2005, Sybase IQ, ASP.NET

Responsibilities: Product environment development; Product QA and testing. Marketing researches, promotional schemes development, presentations development, writing documentation Databases development for product for demo and testing purpose (MS SQL, Oracle, DB2, MySQL, MS Access) Technologies/Applications: Java, Eclipse, client/server, Crystal Reports, MS SQL and other DBs.

Responsibilities: Sales and logistics data analysis – created various data reports (SQL, Business Objects, Excel), data mining Sales forecasting and planning – design and development of sales forecasting and sales planning model (databases design and development, T-SQL and stored procedures development) Database management (data loading, database replication model design and implementation, DTS packages development, T-SQL development) Data warehouse design and development – Developed data warehouse and analytical systems utilizing Cognos ePlanning, MS OLAP, data warehouse design and development, design and configuration of applications on Cognos platform Technologies/Applications: HTML, ASP, Cognos ePlanning (Adaytum), MS SQL 7/2000, MS Office Visual Basic, Business Objects