Pl Sql Developer

Working visa is required.

Ilya Davidovich

Phone Number: +972*********

Email: **********@*****.***

SUMMARY:

Database creation and maintenance. Implementation of physical database design and structures. Development data provisioning solutions for business-analytics in risk management, insurance and medicine based on Agile and Continuous delivery principles using Oracle PL/SQL Developer, SAS, JIRA, Oracle BI Publisher, Oracle Data Integrator, SQL Server and OLAP cubes. Also development and implementation of solutions based on Oracle Hyperion using Calculation Manager, Essbase Administration Services and other software. Reports development on Oracle BI Publisher using MDX, SQL. SQL performance tuning. PL/SQL code review.

Work Experience

27.08.2023 – current time

«G-STAT»

Data Analyst at Menora Mivtachim

•Implementation of physical database design and structures on SAS.

•SAS scripts development using SAS Base and SAS Macro.

•Documentation and description of processes.

30.01.2020 – 09.08.2023

«Renaissance Credit»

Data Engineer

•Implementation of physical database design and structures on SAS and Oracle.

•SAS scripts development.

•Data marts development on Oracle using analytical functions, packages, procedures.

•Schedule jobs on Oracle and SAS.

•SQL performance tuning.

•PL/SQL code review.

•Data exchange with third parties (load data and reports).

03.05.2018 – 24.01.2020

«Renaissance Insurance»

Data Warehouse Developer

•Implementation of physical database design and structures on Oracle and SQL Server.

•OLAP cubes Development using Oracle, SQL Server, Visual Studio.

•SQL development in Oracle BI and Oracle PL/SQL Developer.

•ETL development in ODI.

•SQL performance tuning.

•PL/SQL code review.

18.04.2016 – 16.04.2018

«Medintegrator»

Oracle PL/SQL Developer

Database development for medical institutions based on Oracle:

•Implementation of physical database design and structures on Oracle.

•SQL development, also with analytical functions.

•PL/SQL packages, functions and procedures development.

•SQL performance tuning.

20.05.2014 – 07.04.2016

«IBS»

Hyperion Consultant

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.

10.10.2013 – 01.03.2014

«SST»

Technical Specialist

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

«OCRV»

ABAP Developer

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

•Development of ABAP/4 module for fast data access.

Education

2008 - 2013

Moscow State University of Railway Transport (MIIT)

Chair: “Automated Control Systems”.

Specialist degree in “Automated systems of information processing and management” (5 years).

Certifications

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

IELTS General Training certificate with overall band score 5.5

Languages

Russian – native

English – upper-intermediate

Other

Educability, efficiency, responsibility, punctuality.

Contact this candidate