Dmitriy Seratila
Lead BI Developer at SIMPLE- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Russian Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Implementing Data Models and Reports with Microsoft SQL Server
MicrosoftOct, 2017- Sep, 2024 -
Querying Microsoft SQL Server 2012/2014
MicrosoftMay, 2017- Sep, 2024 -
Amazon Web Services Solutions Architect - Associate
Amazon Web Services (AWS)Jun, 2023- Sep, 2024
Experience
-
SIMPLE
-
Software Development
-
Lead BI Developer
-
Feb 2018 - Present
Stack: Microsoft SQL Server (SSAS, SSIS, SSRS), Power BI, C#. Modeling and development corporate data warehouse (Kimball). Moving analytics from Qlik to Microsoft BI. • Development and support of data integration processes from corporate systems and external sources (Navision, CRM, Web services, Excel, Flat Files, 1C, Bitrix) using SSIS and C#. • Data Warehouse development and maintenance (stored procedures, query optimization, performance and ETL monitoring). • Development of SSRS reports (reports and dashboards for over 150 daily users – stock monitoring, sales reports). • Development of Tabular models (10 models in total, over 1000 measures). —Tabular models for supply team (stock and forecasts history, customs). —Tabular models for management and sales team (sales and discounts, RFM, forecasts). Show less
-
-
-
Wildberries LLC
-
Russian Federation
-
Apparel & Fashion
-
100 - 200 Employee
-
Data Warehouse Developer
-
Mar 2013 - Feb 2018
Stack: Microsoft SQL Server (SSAS, SSIS, SSRS), Vertica, C#. • Development and maintenance of a corporate data warehouse (40 TB of data in total). • Development of a near real-time data mart for marketing team (Kimball, 150 tables, 100 stored procedures, 1 million rows of data daily). Up to 5 minutes refresh rate. • Development of a data mart for ML and analysts team based on Vertica (ETL, query optimization, data partitioning, reports). • Development and support of a database for CRM. — Business logic implementation using SQL. — Development of stored procedures that provide clustering over 5 million of customers using over 30 parameters. — Development of stored procedures that provide data for e-mails, SMS and push notifications for customers (SQL, XML, Service Broker). — Development of ETL, a Multidimensional Model and SSRS reports for marketing communication analysis (8 billion of rows a year). • Data Integration between company systems (ETL). 2 integration servers; 200 integration packages between different parts of company data infrastructure (MS SQL Server, Vertica, PostgreSQL, Web-services, Informix, Excel and Flat Files) using SSIS and C#. • SSRS reports design and implementation for various company departments. Over 100 SSRS reports (decision support, marketing statistics, stock, call-center efficiency). Show less
-
-
Education
-
2009 - 2015
Higher School of Economics
Bachelor's degree, Computer Science
Community
