I am freelancing Oracle architect and BI developer with more than 17 years of experience in designing, implementing and maintaining reporting solutions and data integration platforms for financial reporting systems.
I have been mostly focused on financial industry (insurance, banking) helping to automate multiple reporting processes and making sure that the reporting solution is seamlessly integrated to business systems.
My database stack consists of design, development and fine-tuning of data models, procedural code and data integration scripts across Oracle (17 years), MySQL (3 years), PostgreSQL (2 years).
My ETL stack comprises visual tools Talend (3 years), ODI (2 years), IBM Datastage (2 years), scripting tools Perl (4 years), Python (3 years) and database native loaders of Oracle (10 years) and PostgreSQL (2 years).
My data modelling and architectural experience covers :
• Oracle DW modelling tasks for major German and Nordic banks (staging, transformation and datamart layers), focused on Data Vault;
• Distributed Oracle DB modelling for major Nordic bank;
• Architectural consultancy to Danish-based insurance SW vendor (extensions to product DB as per client’s needs);
• ETL jobs design and implementation (database VS database, sequential file VS database, database migrations) – ODI, Datastage, Talend;
• 17 years of day-to-day experience in Oracle back-end development : PL/SQL, SQL incl. technical design, technical reviews, technical implementations.