Adastra Bulgaria Ltd. – Sofia, Bulgaria

Data Warehouse Consultant / Oracle PL/SQL Developer

Jul 2017 – Present

Projects: (CZ)

P1.   Home Credit – ETL Developer (Aug 2017 – June 2018)

§  Developing new database objects (tables, views, triggers, MVs)

§  Creating PL/SQL packages for data fixing in the created database objects

§  Responsible for database tuning and performance

§  Developing and maintaining of new data marts

Environment:

§  Oracle 11g, Oracle Workflow Builder, Oracle SQL, Oracle PL/SQL, PLSQL Developer

P2.   Volkswagen (D)- ETL Developer (July 2018 – September 2018)

§  Developing new database objects (tables, views, triggers, MVs)

§  Creating PL/SQL packages for data fixing in the created database objects

§  Responsible for database tuning and performance

§  Developing and maintaining of new data marts

§  ETL Tool Informatica

Environment:

§  Oracle 11g, Oracle Workflow Builder, Oracle SQL, Oracle PL/SQL, PLSQL Developer

P3.   DZI Rainbow (EUR)- ETL Developer (September 2018)

§  Developing new database objects (tables, views, triggers, MVs)

§  Creating PL/SQL packages for data fixing in the created database objects

§  Responsible for database tuning and performance

§  Developing and maintaining of new data marts

§  Working with Oracle Workflow Builder

§  ETL Tool SAP Data services

Environment:

§  Oracle 11g, Oracle Workflow Builder, Oracle SQL, Oracle PL/SQL, PLSQL Develope

P4.   Adastra Bulgaria Ltd., Data Warehouse Consultant – Data Warehouse Internal Training (Jul 2017)

§  Utilized DWH Fundamentals

§  Fact table designing – transactions, snapshots, and accumulating snapshots

§  Conformed Dimensions

§  Hierarchies and attributes

§  Slowly changing dimensions

§  Dimensions, facts, SCD, cubes and granularity

Environment:

§  Microsoft Windows 10

Synergy – Sofia, Bulgaria

Senior Oracle PL/SQL Developer

Jul 2016 – Jul 2017

Responsibilities:

§  Participated in the migration of Flexcube core banking system

§  Created stored Oracle PL/SQL procedures/functions/packages

§  Responsible for functional and performance testing

§  Worked on the database tuning

§  Analyzed the database consistence

Environment:

§  Oracle, SQL, PL/SQL

IGSoft – Sofia, Bulgaria

MS SQL Developer

Nov 2015 – Jul 2016

Responsibilities:

§  Created stored procedures/functions designing and development of user requirements

§  Responsible for the Functional testing and Database tuning

§  Analyzed the DB consistence

§  Worked on the Database design

§  Analyzed the situations, issues and fixed them

Environment:

§  Windows, MS SQL Server, SQL

Luxoft – Sofia, Bulgaria

Oracle Developer

Jun 2014 – Oct 2015

Responsibilities:

§  Successfully participated in projects for Deutsche Bank AG

§  Created stored procedures/functions/packages designing and development user requirements

§  Functional testing

§  Performance testing

§  Database tuning

§  Analyzed the DB consistence

§  Worked on the Database design

Environment:

§  Oracle, PL/SQL

Validata – Sofia, Bulgaria

Database Developer & DBA

Mar 2008 – Jun 2014

Responsibilities:

§  Created stored procedures/functions/packages design and development of user requirements

§  Database design

§  Created and supported Oracle and MS SQL Server (recreating Oracle DB to MS SQL Server DB)

§  Created stored procedures/functions/packages design and development requirements(Oracle /MS SQL Server)

§  Worked on the functional testing (Oracle / MS SQL Server)

§  Performance testing (Oracle / MS SQL Server)

§  Responsible for the Database tuning (Oracle / MS SQL Server)

§  Performance improvement (Oracle MS SQL Server)

§  Prepared documentation (Oracle / MS SQL Server)

§  Designed and developed DB reports – Stored Procedures/Excel/Cristal (Oracle / MS SQL Server)

§  Analyzed the situations, issues and fixed them (Oracle / MS SQL Server)

§  Client and customers support (Oracle / MS SQL Server) – Installing support and administration of Oracle / SQL Server client DB-s (Credit Suisse, Nordea, BEA)  

§  Analyzed DB consistence (Oracle / MS SQL Server)

§  Data Migration – migrated data from different DBs (MSSQL, DB2, Informix) trough mapping

§  procedures to Oracle DB

Environment:

§  Oracle, MS SQL, PL/SQL, T-SQL

Travelstoremarker.com – Sofia, Bulgaria

Oracle Developer

Mar 2007 – Mar 2008

Responsibilities:

§  Created stored procedures/functions/packages design and development of user requirements

§  Worked on the function testing

§  Responsible for the performance testing and database tuning

§  C++ functions for middle level APP

§  Java/Selenium for APP automation testing

Environment:

§  Oracle, SQL, PL/SQL, HTML, Java, C++, Selenium

DZI – Sofia, Bulgaria

Oracle Developer

Apr 2006 – Mar 2007

Responsibilities:

§  Developed stored procedures/functions design and development of user requirements

§  Created HTML/JavaScript reports

§  HTML/JavaScript ports- Security system, Information system, System for techniques and materials

Environment:

§  Oracle, SQL, PL/SQL, HTML, Java, JavaScript

Information Service – AD – Sofia, Bulgaria

Oracle Developer

Aug 2001 – Apr 2006

P5.   Responsibilities:

§  Developed stored procedures/functions design and development of user requirements

§  HTML/JavaScript/XML APP

§  Successfully participated in several projects:

§  Internet bank payment

§  Internet handing over of the DDS journals for firms

§  Program for the Central Election Commission in BG for local elections 2003

§  Program for National Information Assurance Commission

§  Internet handing for income tax declarations

§  Program for the Central Election Commission in BG for elections 2005

Environment:

§  Oracle, SQL, PL/SQL, HTML, Java, JavaScript

Technical Proficiencies

Technology

Tools

Operating Systems

 Windows, Linux

Development Languages

 PL/SQL, SQL, T-SQL, Java, C++, HTML, JavaScript

Databases

 Oracle 9g/10g/11g, MS SQL Server, MySQL, Informix, DB2

Reporting Tools

 Oracle SQL Developer

Data modeling Tools

 PL/SQL Developer, Oracle Designer

Education

Qualification

Institute

Master's Degree in Mechanical Engineering

 Technical University Sofia

TRAINING and Certificates

Training

Introduction to Oracle: SQL and PL/SQL

Enterprise DBA: Performance and Tuning

QA – Testing of Software Products

languages

Languages

Level

English

Advanced

Bulgarian

Native