Designing and implementing data warehouse (star schema was used) based on MS SQL Server and implementing ETL process using MS SSIS. Implementing the logging of data downloading process and notifying of successful downloading or alarm reporting. Business customer is a sales department and data source is Oracle transaction database with secondary sales.

My duties as a data analyst are: - Developing and maintaining ETL-procedures. Data transfering ((MySQL, PostgreSQL, Google tables, API services) to Amazon RedShift. - Developing Amazon Redash reporting systems for Sales Department, visualizing and developing dashboards. - Data analisys, A/B tests using Python (NumPy, Pandas, Jupyter Notebook).

The company is developing the software for public accounting organizations/payment centers. As a chief deputy I’ve done the following: · Wrote the SQL scripts for the needs of implemented programs in needs of data analysis and exchange, which allowed to speed up the exchange processes in 10 times. · Transfered DataBase using MS SSIS. · Administered 8 projects, In every done project developed the software architecture, casted parts between team members, and controlled the schedule and results. · Engineered 2 projects playing a sole role of software architect and developer, thus played all the roles of software development team. This experience allows me understand every member of my team and clearly cast the roles. · Designed the software testing system, which allowed to reduce time and maximized the results of development, either to keep development costs down.

The company is developing a software for gas supply companies. As a chief deputy I’ve done the following: · Headed 4 projects. · Engineered architectural planning. · Designed Data Bases and data load SQL-scripts to 1C: Enterprise software by SQL injections. · Configured the table sectioning of 1C: Enterprise data bases. · Developed the 1C: Enterprise external data tool for purposes of 1C: Enterprise data bases views creation

The company is the major one in the great holding of bread-bakery companies. As a chief deputy I’ve done the following: · Pioneered the software adaptation and maintenance of typical configuration 1C: Enterprise; · Developed, implemented and proceeded the maintenance of the overall software for the 24-hours-a-day working bread-baking complex, which contained such parts as production records, dispatch and shipping, and laboratory work records

The company is a major gas supply company in Volgograd region. As a senior software development engineer I’ve done the following: · Implemented and proceeded the maintenance of software total information system “Regiongas”, which contained such parts as administrative accounting, gas metrology, electronic workflow, bank exchange, booking office. · Designed a backup copy creation scheme. · Engineered high-load data base servicing plans using instruments of MS SQL 2008. · Developed data exchange process between Firebird data base and total information system “Regiongas” by ADOdb.

The company is a franchiser of 1C products. As a software development engineer I’ve done the following: · Worked out software installation and maintenance (standard programs based on 1C: Enterprise 7.7, 8.0) · Developed and implemented mechanical accounting systems based on 1C: Enterprise 7.7, 8.0 to the different types of businesses.

Microsoft SQL Server 2016, Certified specialist of Analyzing Data with Power BI (Microsoft SQL Server 2016. MCSA)

Maths Faculty, Applied Mathematics

Дальневосточный федеральный университет Университет 20.35 НТИ, Digital Economy

Computer Training Center “Specialist” of Bauman Technical University

Computer Training Center “Specialist” of Bauman Technical University, 2012

Microsoft

Microsoft