Responsibilities:- Gathering and analyzing reporting requirements.- Analyzing and processing data to create reports in Power BI for previewing data for the website.- Compiling, supporting, and developing analytical reports for users.- Creating analytical data snapshots for user delivery.- Writing SQL queries to output metrics and charts.- Enhancing and rectifying errors in reporting.- Implementing page design as a dashboard.Achievements:- Developed sections such as Niche Analysis, Marketing, Product Information, etc., with tables and dashboards for displaying analytical data to users, and wrote corresponding SQL queries.- Developed a methodology for calculating the completeness rating of product cards on marketplaces and wrote the necessary SQL queries, as well as created the corresponding aggregate, which accelerated data retrieval for users by 2 times.- Optimized SQL queries for existing sections, speeding up data retrieval for users by 3 times.

Responsibilities:- Data analysis in Excel: analyzing parameters of electrical modes for calculation and planning needs, building graphs, pivot tables.- Compiling analytical notes based on calculation results.Achievements:- Automated daily reporting through Excel, reducing compilation time from 60 to 30 minutes.- Created an analysis form in Excel, allowing for more precise adjustment of automation and reducing the number of unnecessary consumer disconnections.- Conducted analysis of active power flow values in Excel, followed by setting device thresholds for fault protection, reducing the number of false alarms related to violations of power quality parameters.