Igor Orlov

Technical Architect for Analytical and Operational Data Storage layers during enterprise DWH implementation (Oracle Exadata) for big e-commerce company. Developed integration with sources using ESB (Enterprise Service Bus) Developed difficult features personally (Client unification algorithm, PL/SQL ETL Package, optimisations of complex transformations).

Group head of IFRS reporting module team which provides DWH solutions into banks: - planning and coordination work of analysts/developers/QA on projects - development of project architecture - development of DWH solution within Data Vault Model paradigm - developed internal system of data orchestration mechanism on PL/SQL

Implementation of automatic IFRS reporting solutions into banks: - DWH Development (on Oracle 11g/12c): data modeling, PL/SQL or Informatica transforms, data mart calculations; - Data integration from several sources using Oracle GG (CDC), Informatica PowerCenter or Web-services API; - designed well-organised ROLAP-universes in SAP BO from scratch (loan and deposit modules) - developed internal package for automatic testing of new CDC load procedures

Manager of small group of internal BI resources. As a developer: - Administration of Russia & Ukraine Schemas (Oracle 11g); - Developing reporting system based on OBI EE for Russian & Ukrainian clients: - negotiation; - draft alignments; - design logical model - design Publisher and Dashboard reports - providing final PPT with conclusions to Customer on meetings and conferences. Partly consulting from May 2014 - December 2014

Duties: - creating logical QC on data - creating BMM models, dashboards and reports in Oracle BI complex data mart calculations, scorecards - integrating of POS tracking system inside Oracle BI using Google Maps and Geodata from auditor mobile cellphones Data analysis, finding insights in Client data See less

Main courses are: Math analysis, signal processing (from censors), theory of flight, flight modeling, neural networks (MatLab)