I am freelancing database acrhitect 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 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;
• Custom PL/SQL and Pgpl/SQL development - 20 years all in all;
• Oracle front-end design - Oracle Forms, XML Published
• PostgreSQL and Oracle DBA activities incl. administration of tablespaces, data files, tracing actual memory distribution.