Dmitry Mironenko

Dmitry Mironenko Email and Phone Number

Senior MS SQL developer / Data engineer
Dmitry Mironenko's Location
Ko Phangan, Surat Thani, Thailand, Thailand
About Dmitry Mironenko

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)

Dmitry Mironenko's Current Company Details

Senior MS SQL developer / Data engineer
Dmitry Mironenko Work Experience Details
  • Nts
    Senior Data Engineer
    Nts 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
  • Nts
    Sql Developer / Data Engineer
    Nts 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
  • Magnit
    Team Lead Of Business-Analytics
    Magnit Dec 2018 - Jan 2021
    Russia, 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)
  • Magnit
    Senior Business-Analytic
    Magnit 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)
  • Magnit
    Business-Analytic
    Magnit 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

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?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.