DB / JSON / XML / REST / SOAP Developer
with basic Java skills

• Healthcare project
  - (investigating) PySpark, Parquet, SQLite, Amazon Redshift, Amazon S3 : generating Parquet files using PySpark from different db types, checking result using SQLite locally, uploading into Amazon and making queries;
  - (dba) SQL Server: backup, restore, check and interpret audit tables, create users, grant access rights; PostgreSQL RDS and self-hosted instance: enable and configure logical decoding for audit usage
  - (support) MySQL, basic perl scripting: uploading csv files into remote MySQL API using perl, data validation - (data integration) preparing backend to store Sendgrid API data in PostgreSQL
  - (dealing with legacy) transforming legacy database into structured and documented one
  - (data science) data cleaning, deduplication, comparing records etc.
  - (migration) SQL Server -> PostgreSQL (custom scripts); Legacy MySQL -> Prod MySQL (mysqldump); Legacy MySQL -> stage PostgreSQL (pgloader)
  - (reporting) dealing with advanced excel-like formulas in Klipfolio in order to pass various input parameters; creating product's dashboard with essential business values
  - (qa) checking result product after going live, bug tracking, describing findings in details in order to fix by related devs
  - (linux infrastructure administrating) obtaining https certificate from Let's Encrypt; configuring ssh tunnels to access databases; configuring virtual hosting for API
  - some organizational stuff for offline meetings
  - (learning) basic .NET c# LINQ Entity Framework usage

• Freelance network. Design a database to manage information on the collection of various types of taxes.

• (remote work for one customer) creating sql connectors; main technologies, tools & processes used on project: estimation, implementation planning; development, integration and deployment; client/server interaction using HTTP GET/POST/PUT/DELETE; data storage and retrieval; oracle, mysql, postgresql, redshift, memsql, dwh, sql, sql pipes, xml, json, jdk, maven, jboss, svn, unix & windows vps, web services, jira, fisheye & crucible, multitenancy
• API used on project: - google spreadsheets api - pingdom api - intercom api - xero accounting api - typeform api - NewVoiceMedia api - searchmetrics api - facebook api - many others
• The main aim is to create modules of application that accesses, manages and integrates databases and cloud services.

Creating of management accounting parameters, writing of sql-requests, programming for Excel & Access, preparing of technical tasks for creating new and upgrading of existent banking software based on Oracle, reporting. PostgreSQL projects

• PLS logistics services – comparing Oracle and PostgreSQL functionality in order to prepare migration for mobile development.
• GrubHub – creating a set of views in order to calculate complicated math expressions using prepared input data
• personal development & hobby – got PostgreSQL 9.3 database server and pgAdmin v1.18.1 at my personal PC for different home tasks

Implementing of corporate reporting system based on Oracle Business Intelligence 11g (methodology of Basel II and ARZ). Creating and refining of existent Oracle 11g packages, procedures, views, tables, indexes, triggers, jobs, functions, etc. (including performance tuning) for filling data into Data WareHouse, OLAP and displaying results in SAP Business Objects, Oracle Business Intelligence, CS B2, FastReport.NET, Excel+VBA due to bank departments' needs. In the course of my work I've started to use C# for creating simple applications in order to select data from Oracle and save in Excel format based on customer's needs. Got some experience in supporting of front-end system (printing forms, table settings). One of my distinguishing projects is developing and supporting of fraud prevention alarm system for internet banking (including e-mail and sms-informing). Also I've implemented client risk evaluation system based on information about client's operations.

Creating of management accounting parameters, writing of sql-requests, programming for Excel & Access, preparing of technical tasks for creating new and upgrading of existent banking software based on Oracle, reporting. PostgreSQL projects

• PLS logistics services – comparing Oracle and PostgreSQL functionality in order to prepare migration for mobile development.
• GrubHub – creating a set of views in order to calculate complicated math expressions using prepared input data
• personal development & hobby – got PostgreSQL 9.3 database server and pgAdmin v1.18.1 at my personal PC for different home tasks