Michael D.'s Linkedin Analytics

Oracle Trained Technologist SQL since 99, PL/SQL since 2000 Interested in Data, Technical/Systems Analysis, working with stakeholders to improve a product. Background in commercial software development for Oracle and in-house development in the the financial sector. industry. Focus on database development, data migration and data integration using ETL/ELT tools. Best practices, establishing design patterns and reusable automated frameworks. Full SDLC. Specialisms Microsoft Power BI, Power Query, DAX, Star schema modelling Oracle 8i - 19c, SQL, PL/SQL, ETL, ELT, Dynamic SQL on UNIX, Linux and Windows Applications: • Bisam/Bone - v3.0 to v3.85 upgrade, re-implementation, rewrite and hardware migration • Markit EDM/CADIS - First pricing system implementation • Eagle PACE - v5.7 to 9.1.3 upgrade and hardware migration • TWS, Automic, Pega, RPA, Power BI Dealing with • End to End Implementations within an Asset Management Environment • Aspects of Systems Architecture during Upgrades • Architecture / Schema Design • Technical Documentation and Analysis • Performance Tuning • Release Management • Code/Technical Reviews • Normalization / Denormalisation • Reusable automated frameworks Oracle Skills in Detail Results Cache, Merge, Dynamic Sql PL/SQL, Code Generation, DDL Generation, Subquery Refactoring, Autonomous Transactions, Externally Organized Tables, Flashback, Dbms_scheduler, Utl_mail, Utl_recomp, Triggers, Materialized Views, Objects and Methods, Clobs, Application Context, Function Based Indexes, Statistics and Histograms, Index Compression, Table Compression, Exception Handling, Role Based Access Rights, Row Level Security, Partitioning