I am freelancing database designer 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.
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 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 technology experience comprises following
• ETL jobs design and implementation (database VS database, sequential file VS database, database migrations) – ODI, Datastage, Talend;
• Scripting support of database migrations – Perl, Python;
• PostgreSQL and Oracle DB design and data modeling (logical and physical models, ER diagrams);
• 17 years of day-to-day experience in Oracle back-end development : PL/SQL, SQL incl. technical design, technical reviews, technical implementation and coaching works – the actual code will be queries, stored procedures / functions / packages, DBMS scripts;
• PostgreSQL and Oracle DBA activities incl. administration of tablespaces, data files, tracing actual memory distribution.