Independent Information Technology Consultant

• Apr 2020 - Present

Application Development Senior Analyst

• Dec 2018 - Mar 2020

Work in finance industry - bankTechnology:Data Warehouse - Oracle 12cData Integration tools - PL/SQL for transformations within the Data Marts, Informatica Power Center for other ETL tasks.Python - implementation of parsers for files with unusual structureLinux Shell - managing server for flat files loaded into and extracted from the Data Warehouse.Most notable achievements:Taking part in succesful migration as part of merge into one of the biggest banks in Poland.Implementation of IFRS9 reporting standard - Expected Credit Loss calculation, booking and reporting mechanismMain responsibilities:Maintenance of Database Warehouse - implementation of new dimension and fact tables in various Data Marts, using SQL and PL/SQL procedures.Implementation of PL/SQL processes managing transformation of data within the warehouse.Implementation of advanced Oracle Database mechanisms, such as Row Level Security, for the merger project.Performance tuning of existing PL/SQL code.Development of ETL processes in Informatica Power Center managing data from multiple heterogenous sources (Oracle Database, SQL Server, flat files generated by other systems)Development of more sophisticated file parsers' mechanisms in Python Show less

Application Development Analyst

• Sep 2017 - Nov 2018

Regular contractor

• Feb 2016 - Aug 2017

CIS - Corporate Information SystemProgramming:Creating SQL queries for business needs.Creating simple PL/SQL procedures in order to create statistic tables and reports. (Oracle SQL Developer 8).Deployment of new PL/SQL jobs to the Database (AIX shell).Modifying and extending excel reports with macros (Basic).Regular usage of SVN repository for checking out and committing PL/SQL jobs' code modifications.Testing:Creating scenarios for system tests of new PL/SQL packages.Performing system tests of new PL/SQL packagesPerforming system tests of new business SAS Enterprise Guide plug-insPerforming system tests of SAS Enterprise Miner application.Creating system test reports.Analytics:Data analysis of business processes (data usage, retention, annexes etc.)Analysis of database structure in order to implement new PL/SQL jobs.Creating and modifying reports of analysis. (Microsoft Excel)Other:Writing documentation of new tables and jobs added to the database. Show less

Regular Contractor, Intern

• Jan 2015 - Jan 2016

Project RAS - Recommendation Automation System (system for marketing campaigns) for one of the biggest polish telecom company.Assisting in System Maintenance (resolving SD tickets)Creating reports and extracting information from databases (Oracle SQL & MS SQL)Creating simple PL/SQL functionsBasic database administration:- Managing users' priviledges- Creating indexes- Managing PL/SQL functions and stored proceduresSupporting business in campaign analysisAssisting in new system version migration: - Translation of documentation and functional/feature requirements. - Creating and executing functional and feature tests. - Migrating Oracle SQL Views and Functions to a new database version. Show less