.7+ years of experience as DB Developer.Understanding of relational database concepts;estimation, implementation planning; development, integration and deployment;Good knowledge of SQL, PL/SQL and Transact-SQL; + sql statements performance tuning; + reverse engineering of undocumented sql and pl/sql code;
Experience with Oracle 11g, MS SQL Server 2005, mysql, postgres and other db;Experience with DWH and OLAP; Experience with Oracle BI (repository, analysis, dashboard, agent development) and SAP Business Objects (universe and report development);
Experience with data quality & validation; Experience with VBA, C# (basics), unix shell scripts (basics), VPN, TeamViewer, SVN, DTS; Experience with support of front-end system (printing forms, table settings); Experience with support of Basel II and ARZ reporting systems; English: C1 Advanced level;
Polish: almost fluent speaking and very good writing level; Freelance experience with Oracle, MS SQL Server, Postgres and MySQL; Finished Java Syntax and Java JDBC & MySQL, started Java Core course (8/10 so far), my next course will be Java Collections.
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
Creating and maintaining Oracle database objects required by business; L3 support of business users; creating of Oracle database objects documentation; DWH; reporting; data quality & validation; UNIX bash scripting.
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, data aggregation (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.
Master's degree, Finance, Genera
Sublieutenant, ground forces