Yuriy Romanenko

Agile/Scrum team member (2 BAs, 2 devs and 1 test engineer). I was responsible for design, development and support of Oracle Data Staging system (Oracle database 11.2) for Risk Management Advisory applications as a single source of cleared, enriched and transformed data. 10+ source systems. Tools and technologies used: • Pentaho ETL tool • PL/SQL • XML • Shell programming • TeamCity • JIRA • CVS On a regular basis, I was involved in the oracle performance tuning tasks for other projects.

Member of Oracle expert’s team for eSpear trade processing system (~7 databases; up to 16Tb total size). Participated in the following projects: • Migration project for the whole system to Oracle Exadata machines. • Developers’ support in any Oracle issue or question (mostly performance tuning) • Providing expert knowledge in Oracle database features and tools usage. • Development and promotion of database development standards.

Our team (5 employees) was responsible for all Oracle databases (>100) and Oracle E-Business Suite instances (7). In addition, team took care of ~15 Linux (RedHat) servers and a few low-level disk arrays.

Database and server administration of DSS system (Oracle 9i on RedHat); • Design and development of ETL procedures (using PL/SQL, Perl and Shell programming) for PrePaid reporting system; • Design and development of marketing and financial reports (PL/SQL, Shell, Perl); • Development of various marketing loyalty programs for prepaid subscribers (PL/SQL, Shell and Java); • Oracle database administration of DSS system for core network planning (Oracle8, Delphi).

Development of different modules for client-server system. Delphi5 + Informix.