Sign in

DWH Developer

Moscow, Moscow, Russian Federation
December 20, 2018

Contact this candidate


H*-B visa sponsorship required.

Ilia Davidovich

Phone Number: +7-910-***-**-**



Oracle PL/SQL Developer, Oracle Hyperion, Oracle BI Publisher.


Development and implementation of solutions for medical institutions based on Oracle Database, using Oracle Pl/SQL Developer and JIRA.

Development and implementation of solutions based on Oracle Hyperion (using Calculation Manager, Essbase Administration Services and other software) and IBM Cognos TM1 (using TM1 Architect and TM1 Web). Development of Oracle BI Publisher reports using MDX, SQL.


Languages: calcScript, Java, HTML, Visual Basic, MDX, SQL, XML, Pascal, C#.

Applications: Oracle Hyperion Planning, Essbase Administration Services, Enterprise Performance Management Architect, Shared Services Management, TM1 Architect, TM1 Web, Oracle PL/SQL Developer, MS SQL Server, OpenScript (Tester), Oracle Load Testing.

Databases: Oracle, Essbase, Access, MS SQL.

Operating systems: MS Windows.

Other programming environment: MS Visual Studio, IntelliJ IDEA, Eclipse, Embarcadero RAD Studio, Delphi.




Program languages: javaScript, ABAP/4, C++, SAS Base.

Databases: MS Access.

Operating systems: z/OS.

Other programming environment: SAP/r3, SAS.

Work Experience

03.05.2018 – current time

«Renaissance Insurance»

Data Warehouse Developer

-developing OLAP cubes in SQL Server

-developing queries in Oracle BI and Oracle PL/SQL Developer

-developing processes for data loading in ODI

18.04.2016 – 16.04.2018


Oracle PL/SQL Developer

Developing databases for medical institutions based on Oracle:

- writing queries, also with analytical functions;

- creating tables and views, also materialized views;

- creating packages, functions and procedures.

20.05.2014 – 07.04.2016

«IBS Soft Ltd.»

Implementation of budgeting and forecasting system based on Oracle Hyperion Planning.

Development of screen forms with Oracle Hyperion and calculation rules with Calculation Manager, setting up dimensions using EPMA and setting OLAP database using Essbase Administration Services;

metadata migration with Shared Services Management;

Development of reports in Oracle BI Publisher (including MDX and SQL queries);

Testing solutions and reports.

Users technical and consulting support;

Development of automated budgeting control system based on IBM Cognos TM1 using TM1 Architect and TM1 Web.

Development of screen forms and calculation rules;

Data and metadata migration with processes;

Setting up dimensions using TM1 Architect;

Solution testing.

10.10.2013 – 01.03.2014


Work with ERP-system “Galaktika”, MS SQL, С#.

Users technical support using programming language VIP.

Writing queries on Transact-SQL.

Integration of ERP-system “Galaktika” and MS SharePoint web-application.

08.06.2011 - 31.07.2011


University practical training: SAP/r3 (ABAP/4).

Development of ABAP/4 module for fast data access.


2008 - 2013

Moscow State University of Railway Transport (MIIT)

Information Technology and Control Institute.

Chair: “Automated Control Systems”.

Specialization: “Automated systems of information processing and management”.

Degree: “Engineer” (5 years).


Advanced training for the course: Oracle Database: PL/SQL Fundamentals

IELTS General Training certificate with overall band score 5.5


Russian – native

English – upper-intermediate


Educability, efficiency, responsibility, punctuality.

Contact this candidate