Position: Senior/Lead Oracle Pl/SQL developer
Category: SQL
English level: upper
Years of experience: 6


Development of DB Migration tools
 Development and design the architecture of projects for acquiring and issuing systems
 Investigation and improvement of Database queries on UAT and Prod environments
 Usage of Python Pandas and Numpy libraries for Data Engineering (ETL) and creation of statistical and non-statistical reports/rules
 Usage of DBA knowledge to create Databases and Schemes with dierent user roles for the whole team
 Investigation of data quality in Prod environment and development of scripts for correction of invalid data
 Creation of several DataGenerators for testing the entire platform stack
 Analyze new/old business requirements and make changes accordingly
 Conguration of projects for QA/Python teams and provide help with business logic
 Creation and maintenance of Fraud Detection rules
 Development of JSON/XML/CSV parsers
 Translation of SAS based codes to Python
 Usage of the R language for basic statistical analysis and collection of aggregations (for Fraud Rules)
 Creation of Python-based scripts to collect Data from various DBs to match PCI DSS standard
 Creation and correction of various reports (RTF, PDF, XML) for Banks
 Development of Migration Tools for Central Bank of Armenia
 BPM (Business Process Management), user information transfer using XML schemas (Account/Customer/Card to BPM transfer)
 Loan module, creation of new products related to Loans
 Data migration from Central Bank of Armenia to local banks (Customer, Loan, Transaction data migration)
 Customer module, creation of customer notication service
 A new module in EXE to control bank cash collectors (using Borland C++ Builder)  A new module in DB to control cash collector transactions (using Oracle Types, sequences, packages, procedures, triggers, tables, views, etc.)
 Mentoring newcomers for easy integration in a working environment
 Participating in logical and architectural decisions
 Providing support for clients (remote and locally)