dmitry alfymenkov

technician lead

About

SKILLS Java – good skills, 10+ years (but fragmented) experience, using currently. Database modelling and design – good skills, 15 years experience, using currently. Oracle 10,11,12 fundamentals, SQL, PL/SQL – good skills, 12 years experience, using currently. Informatica Power Center – average skills, 1 year experience, 1 year ago. Delphi – good skills, 16 years experience, 2 years ago. Btrieve(Pervasive) RDBMS – average skills, 10 years experience, 2 year ago. Oracle performance tuning and query optimization – good skills, 9 years experience, using currently. OLAP – basic skills, 8 years experience, 2 year ago. PHP – basic skills, 2 years experience, 15 years ago. Postgres– basic skills, 2 years experience, 13 years ago, slightly updated (but most theoretically) recently. MS SQL – basic skills, 1 year experience, 15 years ago. Auxiliary tools: Svn, Git, Maven, Jira, Redmine, Liquibase, ut(p)sql, Power Designer, XMLSpy. IDEs: Delphi, SQLDeveloper, SQLNavigator, PL/SQL Developer, Jdeveloper, NetBeans, Eclipse, Intellij IDEA.

Country

romania

City

romania

Industry

information technology and services

Skill

oracle, databases, pl/sql, sql, microsoft sql server, performance tuning, java, postgresql, enterprise javabeans

Experience

technician lead

luxoft

2016-3 - Present · 10 yrs 7 mos

oracle developer

luxoft

2015-1 - Present · 11 yrs 9 mos

* Luxoft Ukraine (Kiev) then Luxoft Romania (Bucharest). DB Regulatory and control, CFTC Remediation. * Developing code fixes for DB TDW reporting solution, including Oracle and Informatica parts. * Analysis and investigation of PROD data for data-fixes purposes. * Support team in performance-critical cases * Interview candidates on regular and seniors Oracle developer positions.

lead programmer

pivdennyi bank

2003-8 - 2014-12 · 11 yrs 5 mos

* Pivdenny Bank, Odessa, Bank Information Technologies department. Developer team of department (stand-alone software company in the past) had created software core of the bank and supported it since 1997. * 1. Development analytic application for bank metrics measurement (Delphi client + Btrieve RDBMS, later Oracle). * 2. Oracle server-side development for various bank applications. Including SQL frameworks for other Delphi developers. * 3. Bank DWH design (relational). * 4. Design and leading of development ETL process. * extracting from Btrieve and loading into Oracle. * data transport based on Sonic MQ MOM (JMS). * data transformation using: Delphi, Java, EJB(Glassfish), Oracle PL/SQL and Java stored procedures. * 5. Design ad-hoc queries and applications for financial analysis purposes, GUI on Desktop OLAP Delphi components. * 6. Performance tuning database related parts of team applications. * 7. Support and code (SQL+PL/SQL) review for a team.