Junior Data Analyst
CurrentResponsibilities:◽️ Preparation of visual reporting in Qlik Sense.◽️ Generating SQL queries and downloads from various accounting systems.◽️ Analytics of financial and economic activities of the Division in Excel.◽️ Ensuring data correctness in Oracle PL/SQL.◽️ Automation of reporting "Transactions by Banks and Countries", "Customer Summary Data" from Excel to Qlik Sense for management.Main achievements:☑️ Developed a dashboard "Transactions by Banks and Countries" in Qlik Sense, which is used by more than 10 people and has reduced decision-making time by more than 2 times.☑️ Developed an interactive dashboard “Customer Summary Data” in Qlik Sense (20+ million rows).☑️ Developed an interactive turnkey foreign economic activity dashboard in Qlik Sense for one of the headquarters teams.☑️ Normalized the names of banks in SQL using regular expressions.☑️ Implemented an ad-hoc constructor in dashboards in Qlik Sense and taught it to my teammates.☑️ Database correctness - 100%.