Andrey Lozenko

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

Contractor 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

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)

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

Competitive Strategy Choosing

Business Informatics / Information Systems Management