← В ленту
Регистрация: 07.05.2023

Alexander Bobrovski

IT
senior
Специализация: Data Analyst, BI Developer, Data Engineer, Data Scientist

Портфолио

IBM

SmartCare R&D. Managing team of developers. Data acquisition. Collecting the business needs and converting them into comprehensive dashboards. Internal IBM reporting system on IBM Cognos platform. Using intellectual platform of SPSS Modeler or/and Python for data insights (prediction of Critical Situations, churn prediction, text mining, categorization of machines in order to suggest preventive actions etc.) and following deployment of outcomes in Cognos reports or other format that fits to consumer. Developing and supporting different kinds of reports intended for internal IBM usage. Work with data sources and data preparation for further migration into internal database. Responsibilities: - Leading of developers team (BI and data science). - Data preparation – developing of SQL codes for data acquisition. - Analytics of data structure. - Participation in the data investigations. - Lead of Internal Projects. - Participation in user education sessions. - Full cycle of Cognos Developing (metadata modeling, reports design, cubes design). - Documentation development.

Petabyte Technology

Petabyte is an American startup, recently acquired by Chewy. The main product called Rhapsody provides the full-cycle EPR system intended for veterinarian clinics all over the USA and Europe. Along with full functionally for office automation it also provides a wide Analytics which helps clients to get insights on all aspects of their activities, including the financial accounts. Responsibilities: - Developing all kind of reports and dashboards in Metabase and Google Analytics studio. - Managing the data acquisition and data quality. - Work on data and reports migrations from PostgreSQL to BigQuery. - Developing the data pipelines and processes of data warehouse updates. - Interaction with data architect and developers. - Reports performance enhancements - Work with Business team.

Greyloud

Development of an Intelligent Unified Data Management Platform to manage customer (well known retailer) audit tracking process for their Compliance and Sustainability Department. This process was managed on Excel spreadsheets, which had many inherent problems. The primary goal of the Intelligent Unified Data Management Platform is to take this process completely off excel, because Excel spreadsheets have poor security as all users have access to all data at all times, and the file can easily be sent in an email to unauthorized persons. Enabling the data to be utilized by various new modules and external systems such as Business Intelligence suites, report generators, enterprise mobility applications, ERP systems, etc. Progressing of the Intelligent Unified Data Management Platform to a more fully featured application integrated within the larger IT ecosystem. The evolution of this system is described in the flowchart diagrams attached. Responsibilities: - Participation in the development of solutions to business needs satisfaction. - Development and management of requirements. - Interaction with customer to collect requirements and come up with appropriate solution (business trips to the customer location). - Creation and conducting the presentations to the customer. - Managing customer expectations. - Work on UI/UX mock-ups. - Work on technical requirements for API. - Participation in the data re-factoring process. - Interaction with project managers, team leaders and employees of other departments, helping them to discover business needs and understand requirements. - Advising teammates on any open issues, addressing possible bugs and help in finding solutions.

Скиллы

BigQuery
DB2
Figma
Google Analytics
Google Cloud Platform
Hevo
IBM Cognos Analytics
IBM SPSS Statistics
JavaScript
Knime
Linux
Lucid Charts
Metabase
MS SQL
MySQL
Oracle
Perl
PHP
PostgreSQL
Python
SPSS Modeler
SQL
Swagger
Unix
Windows family

Опыт работы

Lead Data Analyst, BI developer
с 12.2021 - По настоящий момент |NDA
Google BigQuery, Google Analytics, PostgreSQL, Metabase, Jira, Confluence, Hevo
Petabyte is an American startup, recently acquired by Chewy. The main product called Rhapsody provides the full-cycle EPR system intended for veterinarian clinics all over the USA and Europe. Along with full functionally for office automation it also provides a wide Analytics which helps clients to get insights on all aspects of their activities, including the financial accounts. Responsibilities: - Developing all kind of reports and dashboards in Metabase and Google Analytics studio. - Managing the data acquisition and data quality. - Work on data and reports migrations from PostgreSQL to BigQuery. - Developing the data pipelines and processes of data warehouse updates. - Interaction with data architect and developers. - Reports performance enhancements - Work with Business team.
Team Lead, Data Scientist, BI Developer, Data Analyst
09.2020 - 12.2021 |IBM
SQL, IBM SPSS Modeler, DB2, Python, JavaScript, IBM Cognos Analytics, Knime
SmartCare R&D. Managing team of developers. Data acquisition. Collecting the business needs and converting them into comprehensive dashboards. Internal IBM reporting system on IBM Cognos platform. Using intellectual platform of SPSS Modeler or/and Python for data insights (prediction of Critical Situations, churn prediction, text mining, categorization of machines in order to suggest preventive actions etc.) and following deployment of outcomes in Cognos reports or other format that fits to consumer. Developing and supporting different kinds of reports intended for internal IBM usage. Work with data sources and data preparation for further migration into internal database. Responsibilities: - Leading of developers team (BI and data science). - Data preparation – developing of SQL codes for data acquisition. - Analytics of data structure. - Participation in the data investigations. - Lead of Internal Projects. - Participation in user education sessions. - Full cycle of Cognos Developing (metadata modeling, reports design, cubes design). - Documentation development.
Lead Technical Business Analyst
07.2019 - 08.2020 |Greyloud
Confluence, Jira, Figma, DBeaver, Lucid Charts, Swagger
Development of an Intelligent Unified Data Management Platform to manage customer (well known retailer) audit tracking process for their Compliance and Sustainability Department. This process was managed on Excel spreadsheets, which had many inherent problems. The primary goal of the Intelligent Unified Data Management Platform is to take this process completely off excel, because Excel spreadsheets have poor security as all users have access to all data at all times, and the file can easily be sent in an email to unauthorized persons. Enabling the data to be utilized by various new modules and external systems such as Business Intelligence suites, report generators, enterprise mobility applications, ERP systems, etc. Progressing of the Intelligent Unified Data Management Platform to a more fully featured application integrated within the larger IT ecosystem. The evolution of this system is described in the flowchart diagrams attached. Responsibilities: - Participation in the development of solutions to business needs satisfaction. - Development and management of requirements. - Interaction with customer to collect requirements and come up with appropriate solution (business trips to the customer location). - Creation and conducting the presentations to the customer. - Managing customer expectations. - Work on UI/UX mock-ups. - Work on technical requirements for API. - Participation in the data re-factoring process. - Interaction with project managers, team leaders and employees of other departments, helping them to discover business needs and understand requirements. - Advising teammates on any open issues, addressing possible bugs and help in finding solutions.
Data scientist, BI Developer, Analyst
11.2012 - 06.2019 |IBM
Python, SPSS Modeler, DB2, Javascript, IBM Cognos
Cognos Support for Client Care. Internal IBM reporting system on IBM Cognos platform. Using intellectual platform of SPSS Modeler or/and Python for data insights (prediction of Critical Situations, churn prediction, text mining, categorization of machines in order to suggest preventive actions etc.) and following deployment of outcomes in Cognos reports or other format that fits to consumer. Developing and supporting different kinds of reports intended for internal IBM usage. Work with data sources and data preparation for further migration into internal database. Responsibilities: - Leading of Data Science team. - Data science job – developing and adoption of Predictive, Prescriptive models. - Data preparation – developing of SQL codes for tables creation and filling. - Analytics of data structure. - Participation in the data investigations. - Lead of Internal Projects. - Participation in user education sessions. - Full cycle of Cognos Developing (metadata modeling, reports design, cubes design). - Documentation development.
Web Developer
10.2011 - 01.2013 |IBM
IBM HTTP Server, PHP, Javascript, Ajax, DB2, Perl, SSL, LDAP, TDI
MIES (Mainframe Identifier Extractor System) project. Development of MIES console operator WEB application based on the TDI (Tivali Data Integrator) server.Development of the WEB site from scratch for the operator of the TDI server. This site supports the full life cycle starting with the installation, new account creation, housekeeping to daemons creation. Responsibilities: - Distributed development of the Web interface, code. - Participation in the improvement of the design. - Documentation development.
BI Developer
12.2010 - 09.2011 |IBA, Application Development Division
IBM Cognos 10 BI, Oracle 10gR2, SAP R/3
Development and implementation of managerial reporting and production performance analysis system at the Belarusian Steel Works. The system is based on the methods of suggested in the Theory of Constraints, Total Productive Maintenance and Lean manufacturing. The system is designed to improve production efficiency of the enterprise. It also supports: - Monitoring and analysis of production efficiency. - Consolidated and detailed reporting. Provision of performance indicators for organizational subdivisions (holding, companies, departments, shops, divisions), lines of business, products, and product groups. - Unified source of operational and analytical information. - Efficiency indicators that help develop a personnel motivation system. The system provides a foundation for continuous production improvement. Responsibilities: Metadata modeling in IBM Cognos Framework manager, data analysis, developing professional reports, dashboards.
BI Developer
07.2010 - 12.2010 |IBA, Application Development Division
SPSS Data Collection 5.6, SPSS Statistics 18.0, MS SQL 2008, MS Visual Studio 9.0
Development of the Automated Survey System. The system allows Beltelecom (RUE Beltelecom is a National Telecommunications Operator of the Republic of Belarus) to carry out integration with the telephone system, to automate the processes of survey creation and implementation via telephone and internet, to keep survey process records, and to perform all types of statistic and forecasting analysis. The system establishes hidden dependencies, implements the principle of prediction and action, and creates comprehensive and indicative reports. The main challenges were resolved by me of this project were: 1. The reports included a variety of quotes – in order to assure their correct functioning, it was necessary to make changes to the built-in shell script, responsible for the quote’s logic. 2. Telephony’s and poll-system’s databases synchronization to allow the creation of the complex reports related to the system operation. 3. UI design, merging the polling and telephony system interfaces. Out team consisted of four developers. Responsibilities: Software/Hardware/DB architecture, team coordination, communications with customers, performing analytic, statistic and forecasting analysis, developing all kind of reports.
BI Developer
04.2010 - 07.2010 |IBA, Application Development Division
IBM Cognos 8 BI 8.4, IBM Cognos 8 Planning 8.4, Oracle 10.2
Analytical system and data warehouse development. Alfabank, Belarus. The main task of this project is consolidation bank data into the data warehouse for easy and fast analysis and creation reports with using IBM Cognos 8 BI. The second part of the project is development and deployment planning system with using IBM Cognos 8 Planning product. Responsibilities: - Creating reports and dashboards. - Technical support.
Senior Engineer
04.2008 - 03.2010 |The National Centre of Legislation and Legal Research of the Republic of Belarus
MS SQL Server, Pervasive, Oracle
Database administration. AD, servers, databases on MS SQL Server, Pervasive, Oracle. Writing SQL scripts, java scripts. Working with Windows XP/2000/Server 2000/2003. Consultations of employees. Website imposition and development. Administration of network and telephony.
Main Expert
10.2002 - 04.2008 |The Minsk municipal government of the Ministry for Emergency Situations of the Republic of Belarus
MS SQL Server, Pervasive, Oracle, Delphi
Database administration, analyzing database data, reporting. AD, DNS, servers, databases on MS SQL Server, Pervasive, Oracle, Interbase, Informix. Working with Windows 98/XP/2000/Server 2000. Consultations of employees. Development of Delphi applications for various departments. Administration of network.

Образование

Software Engineering
По 2002
Belarusian National Technical University

Дополнительное образование

B5263 IBM Cognos Cube Designer
По 01.2014
Special Trainings / Courses
OG 096 Time Series Analysis and Forecasting with IBM SPSS Forecasting
По 01.2014
Special Trainings / Courses
Training courses «SPSS Statistics 18.0 Base, Decisions Trees, Custom Tables, Complex Samples»
По 01.2010
Special Trainings / Courses
Training courses «Cognos 8.4.1»
По 01.2010
Special Trainings / Courses

Языки

РусскийРоднойАнглийскийПродвинутыйПольскийБазовый