Skills:- Expert level proficiency in MSSQL (all versions from 2008)- Index table creation and management- Working with XML and JSON with built-in functions (generate/read)- Connecting, sending requests and getting responses from web services (SOAP, REST) with built-in procedures and functions- Working with Agent (creating/modifying tasks with any number of steps, creating schedules, enabling notifications)- Working with MS MDS in web interface (creating models/entities/attributes, creating custom views, creating business rules, data validation)- Working with MS MDS in Studio (adding/modifying/deleting data, validating data)- Clear communicator in verbal and written English.- Analytics (performing analyses, drawing conclusions, making suggestions based on the analysis)- Expert level in MS Excel (functions, analysis, crosstabs, calculated fields, conditional formatting, linkins data to a source on the server for automatic updates)Intermediate level in MS Access (import of different data from different sources, export of data to different sources, creation of queries, views)- Superficial knowledge of Reporting Services- Superficial knowledge of Informatica- Superficial knowledge of VBA- Working with Teradata (writing/optimizing queries, creating stored procedures)- Working with Teradata ViewPoint tool for query monitoring- During studying at university I studied Pascal/C/C++ (term and diploma thesis - developed graphic application in C++ for Win with using graphic libraries)- During studying at the University as a hobby - writing different software solutions in Assembler and C languages on the low-level of Sony Ericsson's mobile phone firmwareHobbies:- Collecting and listening to music on Vinyl- Collecting and building Lego constructors- Traveling and wild camping- Watching a professional-scene games of computer game Dota 2 (professional leagues and tournaments)
-
Senior Data EngineerNts Aug 2023 - Feb 2024- Team's code-review- Replacement of management- DWH design using Power Designer- Building corporate Integration DWH (sys-layer, stage-layer (nonpersisted / persisted), datamart-layer)- Building corporate Analytics DWH (sys-layer, stage-layer (nonpersisted / persisted), core-layer, transform-layer, datamart-layer)- Developing ETL procedures- Developing procedures for building Data Marts- Developing procedures for integration with other information systems: 1C MCM (Manufacturing Companies Management), 1C ERP, IBM IB, own ATMC (Automated Transport Management System (MS SQL))- Working with project managers and business analyst groups to ascertain their database reporting needs- Performing data loads and routine updates on an ongoing basis -
Sql Developer / Data EngineerNts Jan 2021 - Aug 2023- Building corporate Integration DWH (sys-layer, stage-layer (nonpersisted / persisted), datamart-layer)- Building corporate Analytics DWH (sys-layer, stage-layer (nonpersisted / persisted), core-layer, transform-layer, datamart-layer)- Developing ETL procedures- Developing procedures for calculate and update Data Marts- Developing procedures for integration with other information systems: 1C MCM (Manufacturing Companies Management), 1C ERP, IBM IB, own ATMC (Automated Transport Management System (MS SQL))- Working with project managers and business analyst groups to ascertain their database reporting needs- Performing data loads and routine updates on an ongoing basis -
Team Lead Of Business-AnalyticsMagnit Dec 2018 - Jan 2021Russia, Krasnodar- Developing huge complex calculations in MS T-SQL, for example:1) Calculation of algorithms for identifying "virtual stocks" for the whole retail network (>20 000 shops in different formats). Virtual stock: products are listed in the database, but not in actual fact2) Calculation of target loss/standart loss for the whole retail network3) Calculation of losses reasons for the whole retail network4) Calculation of forecast loss for the whole retail network- Automatising calculations by creating a schedules- Loading data from various sources (DWH Teradata, other MS SQL servers, flat-files)- Creating the reports by requests of other departments- Analyzing data and reporting the results- Data visualizations in MS Excel - Management of 6 – 7 employees (junior/middle-developers) -
Senior Business-AnalyticMagnit Mar 2017 - Dec 2018- Developing huge complex calculations in MS T-SQL- Automatising calculations by creating a schedules- Loading data from various sources (DWH Teradata, other MS SQL servers, flat-files)- Creating the reports by requests of other departments- Analyzing data and reporting the results- Data visualizations in MS Excel- Management of 2 – 3 employees (junior/middle-developers) -
Business-AnalyticMagnit Jan 2015 - Mar 2017- Developing huge complex calculations in MS T-SQL- Automatising calculations by creating a schedules- Loading data from various sources (DWH Teradata, other MS SQL servers, flat-files)- Creating the reports by requests of other departments- Analyzing data and reporting the results- Data visualizations in MS Excel
Dmitry Mironenko Education Details
-
Mathematics And Computer Science
Frequently Asked Questions about Dmitry Mironenko
What is Dmitry Mironenko's role at the current company?
Dmitry Mironenko's current role is Senior MS SQL developer / Data engineer.
What schools did Dmitry Mironenko attend?
Dmitry Mironenko attended Кубанский Государственный Университет (Кубгу).
Not the Dmitry Mironenko you were looking for?
-
-
1gmail.com
-
1gowide.com
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial