Snr Oracle ETL Developer / Team Leader, 01.05.2014 – present Luxoft, Deutsche Bank ODC, Ukraine• Program: Regulatory & Control• Projects: Production Service Level 3 (SL3) including x-Jurisdictions (CFTC/CANADA/HKMA/ESMA/MAS/ISIC) and x-Assets (IR/CMD/FX/CR/EQ) + EMIR Valuations; Environment Stability• Description: The Depository Trust & Clearing Corporation (DTCC, www.dtcc.com) is the world’s largest post-trade financial services company, authorized by The U.S. Commodity Futures Trading Commission (CFTC, www.cftc.gov, an independent agency of the United States government that regulates futures and option markets) to gather ongoing financial, operational and regulatory reports.The projects mission is to furnish and support regulatory reporting for DTCC. The solution allows loading data from different source systems, consolidating it in data warehouse, validate data, calculate financial indicators and populates specific data marts, generate reporting and send financial data to DTCC. • Duties: o Lead the team up to 16 FTE (BA, Oracle, Java, ETL);o Following full software development cycle (requirements gathering, development, integration testing, quality assurance, user acceptance test, production deployment and post-production support);o Technical Leadership, tasks decompositions, retrospectives, code review;o Responsible for delivery and deployment into SIT/UAT/PROD Environments;o Clarification requirements with Customer (PM), participate in regular call-meetings and presentation solutions for Business Customer;o Transformation functional requirements into technical tasks after daily call-meetings;o Cooperation with QA Team for fast bug-fixing for getting QA sign-off «In Time»;o Control and coordinate deployment patches (DB and UI) creation/applying, Backlog prioritization;o Loading data from different sources into landing tables using Informatica Power Center, Oracle, JMS, Web-services, Java;Senior Oracle/ETL Developer, 01.06.2012 - 01.05.2014 Luxoft

Deputy Chief of Development Database in the Kiev Police, 01.08.2007 - 01.06.2012 The Kiev Police, Ukraine • Projects: The Police management of Information Systems and Technologies• Description: The main goal of the project is creating and supporting Ukraine Police. Special finding and filling forms for suspects within Europe to cooperate with Interpol databases.• Duties:o Development and optimization of the various database objects (tables, views, indexes, packages, ETL-packages, triggers, etc.);o Tuning and query optimization (hints, traces, indices, etc.);o Understanding of the internal architecture of Oracle database applications for the development of optimal app;o Development, support, bug fixing programs on PL/SQL and PHP;o Creation and registration of technical tasks;o Role of "playing" the coach;o Administration next OS:- Windows 2003/2008 (installation and configuration of OS, DB Oracle 9-11, Web servers IIS 6.5-7.5/Apache 1.3-2.2, PHP 5, FTP, bat scripts);- Solaris 11 (installation and configuration of OS, DB Oracle 11, Web server Apache 2.2, PHP 5, shell scripts, cron, zones);o Administration of a DB of Oracle:- database migration of Oracle from versions 8-9 to 10-11;- development and support of databases in Oracle 10/11;- provide automatic backup and recovery strategy (Data Pump, RMAN, Data Guard, Flashback);- installation patches on Oracle 10/11;- installation of communication with other DB (DB links, heterogeneous service);- partitioned tables and indexes;- optimizing the performance of the database Oracle (optimizing SGA, defragment the database, fixing of large objects in the shared pool);- mathematical forecasting, performance analysis of an Oracle database and the removal of the existing problems.