Anna Kuks Email & Phone Number

Saint Petersburg, Ru

St Petersburg, St Petersburg City, Russia

St Petersburg, St Petersburg City, Russia

Qlik and Power BI report development.Qlik:- ETL (mostly use DWH as source)- Data models with a large number of tables- Link tables, Data bridge- Section Access- Set-analysis of any complexity- Triggers- External scripts- VBA macros- Code optimization- Code reviewPBI:- Writing pipelines, using parameters and custom functions- Bookmarks, buttons, hidden objects- DAX- Calculation groups- What If parameters- RLS… Show more Qlik and Power BI report development.Qlik:- ETL (mostly use DWH as source)- Data models with a large number of tables- Link tables, Data bridge- Section Access- Set-analysis of any complexity- Triggers- External scripts- VBA macros- Code optimization- Code reviewPBI:- Writing pipelines, using parameters and custom functions- Bookmarks, buttons, hidden objects- DAX- Calculation groups- What If parameters- RLS, OLSPlatforms administration (working with QMC and PBIRS), working with Qlik components (Distribution Service, QlikView Server, QMS) - understanding what's responsible for, and what the consequences of restarting services, solving non-standard problems (for example, we faced with missing CALs problem in Qlik).Consulting and training fellow developers.Working with DWH (MS SQL): creating new and modification of existing stored procedures, functions, views, jobs.Finalizing SSIS packages.Working with SSRS: administration, finalizing RDL.Experience of integration with Yandex.Direct API through Python. Show less

St Petersburg, St Petersburg City, Russia

About the project:The implemented analytical reporting system includes 18 applications on QlikView, which allow on-line monitoring of equipment reliability KPI's (failures, repairs, operating time, mechanical availability, etc.). Data from 7 Gazprom Neft subsidiaries have already been connected to the system and the connection of 3 more is being prepared.Role:- Application development on QlikView (including design of business solution architecture)- Reports in Qlik… Show more About the project:The implemented analytical reporting system includes 18 applications on QlikView, which allow on-line monitoring of equipment reliability KPI's (failures, repairs, operating time, mechanical availability, etc.). Data from 7 Gazprom Neft subsidiaries have already been connected to the system and the connection of 3 more is being prepared.Role:- Application development on QlikView (including design of business solution architecture)- Reports in Qlik NPrinting- Testing, debugging and refining of applications- Preparation of technical documentation- Partially acting as a system analyst due to lack of resources in the project (interaction with product owner, discussing business requirements, correcting functional requirements)- Consulting users on methods of calculations and work in Qlik- Working with corporate data warehouse (MS SQL). Validation of data and interaction with counterparties on improving data quality, setting tasks to create integrations with source systems and acceptance of work- Working with SAP and 1C as an end user (for processes analysis)Accomplishments:1. Gained the experience of participating in a big project as a core developer + solution architect2. Gained the experience of developing complex, related applications involving: - use of set analysis, script variables, calculation and display conditions, triggers; - diagrams with drill-down measurements; - state preservation during transitions between applications; - complex data preprocessing: working with dates, "collapsing" of intersecting time intervals, moving average calculation in 4 versions: for 12, 24, 36, 48 months; - automatic sending of regular reports in .pptx format to e-mail.3. Independently mastered and continues to develop skills in developing QlikView and Qlik NPrinting4. Improved SQL skills and understanding of source system integration principles with DWH5. Experience of working in a product team with an Agile approach Show less

St Petersburg, St Petersburg City, Russia

Risk management departmentInterleasing is a leasing company with offices all over Russia. The staff is about 400 people. Role:- Worked on improving the data quality in the corporate data warehouse.- Participated in the creation of an OLAP-cube based on MS SQL Server Management Studio.- Introduced initiatives to improve leased assets tracking.- Tested the reporting automation in Qlik Sense.- Prepared regular reports in Excel.Results:1. Successfully… Show more Risk management departmentInterleasing is a leasing company with offices all over Russia. The staff is about 400 people. Role:- Worked on improving the data quality in the corporate data warehouse.- Participated in the creation of an OLAP-cube based on MS SQL Server Management Studio.- Introduced initiatives to improve leased assets tracking.- Tested the reporting automation in Qlik Sense.- Prepared regular reports in Excel.Results:1. Successfully completed the transfer of the OLAP-cube to the side of the company itself (before that the cube was formed on the side of the bank that owns the company).2. Improved my SQL skills.3. Accelerated the reporting process at the department.4. Identified mistakes in existing reporting templates as well as in the corporate data warehouse.5. Introduced ideas for process optimization.I quit due to lack of career prospects and low potential for acquiring new skills. Show less

St Petersburg, St Petersburg City, Russia

HR Department Role:1. Developed of a model to calculate the optimal number of employees at the filling stations.2. Analyzed the filling station operation (clustering, anomaly detection).3. Prepared weekly / monthly reports for the management to monitor the main indicators for filling stations.4. Introduced ideas to improve existing reporting forms.Accompanying responsibilities:1. Collecting and processing badly matched data from different sources.2… Show more HR Department Role:1. Developed of a model to calculate the optimal number of employees at the filling stations.2. Analyzed the filling station operation (clustering, anomaly detection).3. Prepared weekly / monthly reports for the management to monitor the main indicators for filling stations.4. Introduced ideas to improve existing reporting forms.Accompanying responsibilities:1. Collecting and processing badly matched data from different sources.2. Extracting of data from QlikView and CRM by request.3. Checking the data quality in the data warehouse.4. Preparation of manuals on using the QV applications for the management.5. Interaction with QV developers during the creation of applications for reporting automation.Results:1. Learned to work in multitasking and stressful conditions.2. Learned to quickly process badly consistent data from different sources.3. Improved the Excel skills to an advanced level (formulas of any complexity, summary tables, database queries), created the necessary frameworks that helped to simplify and speed up my work, as well as that of my colleagues.4. Took an SQL course and had experience in writing basic queries (joins, analytical functions, generalized table expressions). Also gained some experience in Python (but the main language of work at the moment is R).I resigned at my own request because I moved to Germany to study. Show less

St Petersburg, St Petersburg City, Russia

Data Management Office Task: building a predictive model of the impact of marketing expenditures on sales and brand awareness of the company.Role:- Collection, validation, and preparation of data for analysis- Building a predictive model in R (used algorithms: linear regression, decision tree, random forest, XGBoost on trees)- Forming recommendations for optimizing budgets to achieve key business metricsResults:- Built two machine learning models for… Show more Data Management Office Task: building a predictive model of the impact of marketing expenditures on sales and brand awareness of the company.Role:- Collection, validation, and preparation of data for analysis- Building a predictive model in R (used algorithms: linear regression, decision tree, random forest, XGBoost on trees)- Forming recommendations for optimizing budgets to achieve key business metricsResults:- Built two machine learning models for predicting the impact of marketing campaigns on brand awareness and sales. The models were based on the decision trees and XGBoost algorithms. Both performed on R. These models allowed the business customer to predict targets for different levels of spending on marketing channels (TV, radio, sponsorship, etc.), to identify ineffective channels, to optimize and justify the budget.- Gained experience of work with a large amount of data and work on data collection and preparation.Upon completion of the internship, I received an analyst position at the HR department. Show less

Master'S Degree, Statistics

Erasmus+ scholarship holder. Exchange student.

Master'S Degree, Mathematical Methods In Economics

Diploma with honors. RF Government scholarship holder.

Bachelor'S Degree, Business Administration, 1.4 (Out Of 1.0)

Erasmus+ scholarship holder. Exchange student.

Bachelor'S Degree, Mathematical And Statistical Methods In Economics, 4.9 (Out Of 5.0)

Diploma with honors. RF Government scholarship holder. Recipient of the Viking Bank's personal scholarship for talented students.