Loading data from related systems and transform to report view. Responsibilities: Developer on the project. Development of functions and procedures that record and upload data from several automated banking systems and their further transformation to report view in DWH. Tools: Oracle PL/SQL, SQL, SyBase.Loading data from different data sources, developing workflows for loading data from different banking systems. Tools: Hadoop ecosystem, Spark, Hive, Hue, MS Office

Every day I worked with a consumer database containing more than 200 thousand customers. I processed significant amounts of data using the Microsoft package, on the basis of which I conducted analytics and performed forecasting of the activities of the branch accounting service.I carried out the maintenance of information and computing complexes of electricity metering systems. Extracted, transformed and loaded data into the CPI with the means available in them.Organized the work of accounting services in production departments.Developed long-term development programs and energy service contracts.

I worked with a large number of indicators of electricity and technological process coming continuously in real time.Conducted system administration of the technological network of the CHP.Provided maintenance and troubleshooting of the automated control system of the 100 MW CHP.Developed and maintained documentation on the automated process control system.Organized the work of contractors on automated control systems and fire alarm systems.

I Installed, configured and changed the equipment of the automated system of the 25 MW power complex.I worked with the SCADA system of the energy complex and developed schemes and kept documentation on automated process control systems and instrumentation.Conducted diagnostics of controllers Schneider Electric, SIEMENS.I wrote a scientific and technical paper in which has been propose the modernization of the cooling system of diesel generator sets based on frequency conversion in order to reduce costs and simplify the work of personnel. Paper took the first place at the competition of scientific and technical papers LLC LUKOIL-ENERGOSETI.

Designed 0.4 kV overhead and cable lines, as well as related equipment.