Andrey Lozenko
Bis 2023, Senior Business Intelligence Consultant, MultiBase GmbH
München, Deutschland
Über mich
Data Warehouse, ETL, Business Intelligence, Reporting Developer 15+ years’ experience in Business Intelligence, ETL and DWH, and Data Mart design, implementation, and support 5+ years’ experience in Marketing & Sales Data Analysis Experienced in complex BI solutions for service requests with sophisticated logic or special business requirements Skilled and self-motivated professional, who can see a “big picture” with keeping its details in mind Critical thinking and creative work approach are natively combined with a positive attitude and ability to explain concepts of any complexity both to IT-professionals, and managers and business users, with simple words and obvious examples Able to ask proper questions and find useful answers, which allow me to define and effectively manage business requirements to exactly respond to them. Can successfully deliver a result even in the situation of unclear requirements and necessity of fast extending of business or technical expertise
Werdegang
Berufserfahrung von Andrey Lozenko
9 Jahre und 2 Monate, Feb. 2014 - März 2023
Sr. Developer: Data Warehouse, ETL, Business Intelligence, Reporting
MedeAnalytics
Project: analytic web-solution across the healthcare and health insurance system for gathering, cleaning, integrating, and representing complex data from multiple sources to provide clients with support of decision making. Designed and developed ETL, DWH and reporting for product solution. Investigated and resolved calculation performance issues. Implemented “impossible” and “tricky” OLAP metrics and dimensions. Mentored and coached 30+ BI&BigData interns in US Office and jr. engineers in UA office
1 Jahr und 6 Monate, Sep. 2012 - Feb. 2014
Developer in Proof-of-Concept Team: Business Intelligence and Reporting
Brightgrove LtdContractor on Aginity (coginiti.co) project. Designed and implemented DWH and Datamart objects for reporting purposes. Configured and tuned data model and environment for reporting layer (Cognos BI). Developed and supported reports for proof-of-concept projects and demo sites. Configured Cognos BI environment
6 Jahre und 7 Monate, März 2006 - Sep. 2012
Developer: Data Warehouse, ETL, Business Intelligence, Reporting
Stella Systems
Designed, implemented, and supported relational DWH and OLAP Data Marts (Finances in US Healthcare), developed and maintained ETL procedures. Investigated and fixed data issues and discrepancies, business logic implementing bugs. Migrated 3 DWH to MS SSAS with deep refactoring and optimizing (per DWH: 100+ dimensions, up to 500 measures and MDX calculations in each of 10+ cubes). Optimized ETL automated testing (parallel processing reduced execution time from 3h to 30m)
6 Jahre und 5 Monate, Feb. 2000 - Juni 2006
Marketing and Sales Analyst
Retailers, Wholesalers and Manufacturers of FMCG
Performed: sales analytics, planning and forecasting; costs/incomes/profit analytics by facilities, brands, SKU; price monitoring management and analysis, pricing. Optimized retail products assortment and list of suppliers
Ausbildung von Andrey Lozenko
1998 - 2002
Marketing Management
Simon Kuznets Kharkiv National University of Economics
Competitive Strategy Choosing
1993 - 1998
Business Informatics / Information Systems Management
Simon Kuznets Kharkiv National University of Economics
Business Informatics / Information Systems Management
Sprachen
Englisch
Fließend
Deutsch
Grundlagen
Russisch
Fließend
Ukrainian
Fließend