Oleksandr Vasylenko Email & Phone Number

Kyiv

Performance and structural optimization of the Reporting component of the cloud-based restaurant management platform - Project Planning - Data Modeling - Database Development - Code Review - Database Migration

Kyiv

Development of QlikView and Tableau Dashboards as part of the Scrum team:• Requirements Analysis • Data Modeling & QVD feeds• Data Visualization & Optimization• Data Quality Assurance • Solution and Process Documentation

Ukraine

• Presales activities support• Demonstration of Oracle BI and related products• Presentations to the customers and partners• Leading workshops and trainings about the product• Public presentations on the conferences and forums• Prof of Concepts: building mini DWH from scratch

- Reports and universes development in Business Objects and MicroStrategy environment- Business consulting: gathering requirements, work with users- Analysis of deviations between data in Taradata database and existing systemsProjects:- 2007-2008: Telco project in Ukraine for leading local mobile operator Kyivstar, owned by Telenor; Kyivstar DWH project as PS consultant (reporting development, industry consulting, bug tracking, data modelling, reports development)- 2008-2009: Telco project in Poland for one of the three local major mobile operators; Polcomtel Plusconnect II project as BI Architect (architecture development and development, industry consulting, data modelling, reports and universes development)- 2009: banking presales in Russia; presales activities (building DWH prototype) for SberBank (central bank of Russia) project as BI architect (architecture development, reports and universes development)- 2009-2010: DWH migration in Ukraine for leading local mobile operator Kyivstar owner by Telenor; BI Architect, Reporting group lead (architecture development, task planning, reports and universes development)-2010-2011: Social Network Activity project implementation for Russian mobile operator MTS; ETL development & Analyst (ETL scripts development and automation, solution documentation development)

- Gathering billing system statistics (DB size ~ 2 Tb):--- Daily distribution of reports with subscriber’s acquisition/churn, sim and scratch card activations.--- Delivering subscriber’s statistic (traffic, financial transactions, fraud, …) to corresponding divisions.--- Developing and distribution of reports in corporate reporting system.- Development and maintenance of corporate reporting system on the basis of Crystal Reports 7.- Modification and update of corporate reporting system from Crystal Reports 7 to Oracle HTML DB 2.0.- Participate in the project on Data Warehouse development:--- Problem statement.--- Consulting and controlling of vendor company.- Data Warehouse maintance.- Administration of Business Objects Enterprise Server XI

- Participating in the project on introduction of the Automated Budgeting System building for the mobile communication operator “Kyivstar G.S.M.” on platform Oracle Finacial Analyzer 11i--- Developing procedures using Oracle PL/SQL, Oracle Express Language, Oracle Express Objects- Participating in the project on introduction of the Automated System of Budgeting for “Raiffeisen Bank Ukraine” on platform Oracle Finacial Analyzer 11i--- Developing procedures using Oracle PL/SQL, Oracle Express Language--- Creating ETL procedures using Oracle Warehouse Builder- Installing and administrating Oracle Express Server 6.3.4.- Participation in development of Warehouse on Oracle Warehouse Builder 10g- Developing applications on Oracle Express Objects- Realization of financial models in OFA 11i - Developing reports using Buisness Objects and Crystal Reports- Writing program of representation OFA’s financial models in Crystal Report’s environment using VS.NET resources in C#.

Master'S Degree, Applied Mathematics

Bachelor'S Degree, Computational And Applied Mathematics