Project Description: ETL processes for storing and reporting in the highest rated Russian real estate data base.Technologies and platforms used within project:HDFS, Kafka, Hive, Cassandra, Presto.Bash, Python, SQL, XML, JSON.

Project Description: ETL processes for financial and accounting reporting (including regulatory) in the highest rated Russian private bank. Technologies and platforms used within project: T-SQL, pl sql, db2, ADX, MDX, J-Rules, Unix. Tools used within project: SSMS, SSIS, SSAS, SSDT, Microsoft Visual Studio, PL SQL Developer, System i Navigator, GIT, IBM Notes.Methodologies: KANBAN. Overall project team is distributed in two different locations. Team size – 19 FTEs.Roles/Accomplishments:- Develop test and tune database code and information.- Support product development and quality assurance teams.- Design and maintain T-SQL scripts and Stored Procedures.- Provide technical support and guidance to staff.- Generate reports and spreadsheets detailing database changes and performance.- Move all ETL processes to new database with rescripting Stored Procedures and changing datasources

Project Description: testing of reporting system for Management in one of the biggest russian investment company. Tools used within project: MySQL, RStudio ,Excel.Team size – 25 FTEs.• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.• Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.• Extensively investigated different data issues and communicated with clients to resolve the issues.• Created and integarated R forecasting script, based on ARIMA model.

Project Description: database design for OLAPTools used within project: T-SQL, Excel, Bitrix CRM.Team size – 7 FTEs.• Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures.• Designed database schema contains over 30 tables such as users, groups, stock and customers.

Project Description: stock and daily operations analysisTools used within project: SQL, Power Point, Excel, 1С.Team size – 7 FTEs.• Analyzed data from the monthly business plans and actual statistics to identify profitable revenue growth opportunities/insights.• Provided oversight to the daily operations, including data pulls, research assignments, file transfers, data processing and data quality management.• Managed professional relationships with clients.

Project Description: reporting system for marketing analysisTools used within project: MySQL, MS Access, Excel, VBA.Team size – 5 FTEs.• Performed analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts.• Imported, exported and manipulated data sets in million-row• Collaborated with project managers, legal counsel, and other team members to gather data for projects.

• Moderated focus groups to obtain insights that allowed products to better meet customer needs.• Analyzed data using both quantitative and qualitative methods.• Created and presented results reports to product development and marketing teams within Pearson.