Andrey Isakov Email & Phone Number

Санкт-Петербург, Россия

Directly responsible individual for managing the governance of data-services, domains and datasets within projects of digital transformation: BI, Self-Service BI, analytics, architecture, data delivery, data quality, regulatory & reference information management systems, implementation and provision of data management requirements.Responsible for providing infrastructure and staffing resources for the implementation of tasks.DWH Greenplum/Arenadata DB. Integrations, ODS, DDS layers and data marts (PostgreSQL, MS SQL, Dremio, ClickHouse). Analytical applications and Self-Service BI.Main projects:>Data collection and distribution system:acceleration of receiving and converting external data (leading information agencies)Solution architecture: Greenplum/Arenadata DB, NiFi, Apache Airflow, Debezium, Dremio>Fraud Management: IT solution for detecting signs of fraud and automation manual operations. Solution architecture: Greenplum/Arenadata DB, LuxMS BI Competencies:Digital Transformation, DWH, MDM, Data Governance, Data Quality, Project Planning, Informatica EDC, Alteryx, Agile1. BI Semantic Models, SQL Server Analysis Services (SSAS), Anaplan, Dremio, ClickHouse2. Python Data Analytics: Pandas, Numpy, SQLAlchemy, Pyodbc, Matplotlib.3. Microsoft Visual Studio, SQL queries, MDX/DAX queries, Integration services.4. Anaplan connected planning experience. Data modelling and integration with relational and dimensional data models.5. Power BI service, QlikView business intelligence and reporting

Санкт-Петербург, Россия

Achievements:1. OLAP cube operations (in connection with finance OLAP cube). All data concentrated in a single place and available to the end user via Excel and PowerBI dashboards. Reduced processing time, enhanced quality and increased level of efficiency in services.2. Logistics factors driven model (Pandas, SSAS).3. Agency brands Cost of goods sold model. Entity Relationship Diagram. Technical requirement. Anaplan implementation. Integration with DWH and semantic models (Microsoft Analysis services).4. PL US GAAP: Transport & Logistic to Customers Costs. Warehousing Costs. SKU distribution. MS SQL Server implementation.5. Anaplan logistics module implementation.General Solutions:1. Consolidation and transformation of business statements. Reporting and analysis.2. Data warehouse modelling and analysis. Master data management (MDM). Identification of ways to improve information delivery, data capture and design.3. Relational and dimensional data modelling. Integration of cubes/reports with Anaplan/Power BI assemblies. Data replication, extraction, loading and data mining.4. Data consolidation and evaluation as per business needs. KPI and dashboard design. Scorecards.5. Connected planning and budgeting process. A methodology and technical aspects of implementing semantic models: Anaplan, Cognos TM1 and write back in OLAP cubes of MS SQL server Analysis services.6. Scoring, data mining (some examples https://clck.ru/33ThYu)