← Back to list
Registration: 12.03.2024

Portfolio

PIK Group

● Spearheaded data pipeline overhaul from ERP systems to Tableau, cutting out inefficient Excel and Power BI processes. Utilized SQL, API integrations, and advanced Tableau features (Data Blending, LODs, Table Calculations) for enhanced data analysis and reporting across various projects including ERP system integration and external system reporting (Asana, Confluence). ● Developed a comprehensive reporting system for Technical Support, leveraging database API connections, SQL and Google Sheets scripting. Enhanced data visuali ation and decisionmaking for managers, ServiceDesk staff, and executives with tailored Tableau reports. ● Improved operational efficiency by automating business processes and ERP system enhancements using a mix of SQL techniques (window functions, CTEs), Excel (VBA, Power Query), Power BI, and internal query languages, managing diverse database environments (Postgres, MSSQL, MySQL).

Luxoft

● Developed and maintained Tableau reports using SQL, published data sources, and advanced Row-Level Security (RLS), employing Python with libraries like requests, pandas, and xml.etree. ElementTree for specific projects. Areas: Billing and Invoicing, HR Domain. ● Led a significant project to enhance the transparency of Schedules, Extracts, and Workbooks on the Tableau Server, focusing on creating and maintaining a data pipeline and utili ing Tableau Server's API for streamlined data customer access. ● Adapted and refined the Confluence Parser project, focusing on data collection and storage in databases, while emphasi ing work with Atlassian APIs (Jira, Confluence) to generate insightful reports from the gathered data. Extensively engaged with corporate systems including Oracle, Salesforce, and internal invoicing systems.

CustomerTimes

● Led the development of reports for various user levels, from conducting customer interviews to hosting Q&A sessions and embedding reports as tabs in Salesforce ● Directed an initiative to review existing reports, improving aesthetics and performance, resulting in the creation of reports based on Tableau Cloud sources like Viz Load Times and reducing average report load times by 73%. Also directed another initiatives related to Tableau Cloud API. ● Collaborated with the DWH team on driving the huge Self-Service Tableau initiative, developing data sources, pre-calculating metrics, and creating report templates for users, fostering autonomy in data exploration and reporting. ● Increased user engagement in the reporting system by conducting training sessions on Tableau Cloud and Tableau Desktop features. This effort boosted user activity and the average report lifetime by 22%, and the average session duration by 56%, leading to enhanced business insights. ● Participated in management and PreSales initiatives, preparing report mockups and prototypes, conducting cost calculations for PreSale projects, and presenting the architecture of proposed BI solutions to potential clients. Also involved in reviewing existing projects to refine and transform the reporting system.

Skills

Tableau 9
Power BI 7
Python 6
Cloud API
ClickHouse
SQL 8
PostgreSQL
Airflow
Excel 10
Excel
ERP
Asana
Confluence

Work experience

Senior Tableau Consultant
since 06.2023 - Till the present day |CustomerTimes
Tableau
● Led the development of reports for various user levels, from conducting customer interviews to hosting Q&A sessions and embedding reports as tabs in Salesforce ● Directed an initiative to review existing reports, improving aesthetics and performance, resulting in the creation of reports based on Tableau Cloud sources like Viz Load Times and reducing average report load times by 73%. Also directed another initiatives related to Tableau Cloud API. ● Collaborated with the DWH team on driving the huge Self-Service Tableau initiative, developing data sources, pre-calculating metrics, and creating report templates for users, fostering autonomy in data exploration and reporting. ● Increased user engagement in the reporting system by conducting training sessions on Tableau Cloud and Tableau Desktop features. This effort boosted user activity and the average report lifetime by 22%, and the average session duration by 56%, leading to enhanced business insights. ● Participated in management and PreSales initiatives, preparing report mockups and prototypes, conducting cost calculations for PreSale projects, and presenting the architecture of proposed BI solutions to potential clients. Also involved in reviewing existing projects to refine and transform the reporting system.
Data Analyst
12.2022 - 12.2023 |Beresnev Games
Tableau
● Engineered a reporting pipeline from Google Sheets to Tableau, utilizing Airflow for orchestration and scripting for efficient data collection and integration. ● Leveraged ClickHouse and PostgreSQL for robust data storage and transformation, facilitating enhanced analytics and reporting capabilities within Tableau. Areas: Gaming Data, Finance Data.
BI Analyst
10.2021 - 06.2023 |Luxoft
Python, SQL, Jira, Confluence
● Developed and maintained Tableau reports using SQL, published data sources, and advanced Row-Level Security (RLS), employing Python with libraries like requests, pandas, and xml.etree. ElementTree for specific projects. Areas: Billing and Invoicing, HR Domain. ● Led a significant project to enhance the transparency of Schedules, Extracts, and Workbooks on the Tableau Server, focusing on creating and maintaining a data pipeline and utili ing Tableau Server's API for streamlined data customer access. ● Adapted and refined the Confluence Parser project, focusing on data collection and storage in databases, while emphasi ing work with Atlassian APIs (Jira, Confluence) to generate insightful reports from the gathered data. Extensively engaged with corporate systems including Oracle, Salesforce, and internal invoicing systems.
Analytics Specialist
02.2017 - 10.2021 |PIK Group
Postgres, MSSQL, MySQL
● Spearheaded data pipeline overhaul from ERP systems to Tableau, cutting out inefficient Excel and Power BI processes. Utilized SQL, API integrations, and advanced Tableau features (Data Blending, LODs, Table Calculations) for enhanced data analysis and reporting across various projects including ERP system integration and external system reporting (Asana, Confluence). ● Developed a comprehensive reporting system for Technical Support, leveraging database API connections, SQL and Google Sheets scripting. Enhanced data visuali ation and decisionmaking for managers, ServiceDesk staff, and executives with tailored Tableau reports. ● Improved operational efficiency by automating business processes and ERP system enhancements using a mix of SQL techniques (window functions, CTEs), Excel (VBA, Power Query), Power BI, and internal query languages, managing diverse database environments (Postgres, MSSQL, MySQL).

Educational background

Financial systems
2010 - 2015
ITMO University

Languages

EnglishAdvancedRussianNative