Profile:
- Hybrid Support/Data Analyst / Oracle Developer (Unix/Linux scripting, SQL & PL/SQL), Automation, Integration, Perf Tuning
- eFX/ FX FIX (Equities) Dev / Support Analyst & Oracle Development for Financial Exchange, spot & derivatives Trading Systems as well as AI (21 years)
Technical Summary:
- FIX protocol based low and ultra-low latency trading platforms: client onboarding, latency root cause investigations, configuration management & automation (10 years)
- Architectural Design of System & Databases (9+ years)
- Oracle database modelling & normalization: Snowflake/Star schema, SQL, PL/SQL dev, performance tuning, Query & Optimizer tuning, ExplainPlan, tkprof, OEM, ODI, data transformation & ETL process management & root cause analysis, testing & deployment (22+ years)
- Data Quality Analysis and implementation of enforcing processes and constraints leading to more efficient data storage and process performance improvement Unix/Linux sys management, shell/Perl scripting, Windows as well (18 years), Python (8 years)
- Data Analysis, Data Architecture, architectural design, Security & Risk Analysis & Solution Architect System Integration & Implementation, Issue & Data Analysis, root cause investigation, rollout of fixes & enhancements from DEV via QA to Prod (16+ years)
- 1st, 2nd & 3rd line Production/trading floor Support & project delivery (16 years)
- Mentoring, coaching and leading other team members through new projects (11 years)
- Business User & Stakeholder Management (16 years)
Oracle Skill Summary
? Oracle Database Design, Modelling, Development and Performance Tuning & Administration ?
- Since 1998 ? 2004 as Core Oracle Database Development
- Since 2004 in Production / Application Support, Oracle Development, ETL, DatawareHouse Processes
- Since 2012 equivalent Data Analytics on also Sybase, PostgreSQL, SQL Server, MySQL
Oracle Database Design & Modelling
- Development of Logical Entity Relationship Models and Physical Database Models, Star- & Snowflake Schema, Normalisation of Database models based on Business requirements incl maintenance of historical records, performance and process optimisations, multi-language capabilities, mechanisms for archiving and more
- Database metadata normalisation to eliminate redundant data, enable efficient querying, simplification of updates
- Database Model Management either manually in scripts but better also with e.g. Oracle SQL Developer Data Modeller (or similar tools also for Sybase, MS SQL Server, MySQL like Visio etc.) to keep the database model inline with generated scripts to create all database objects
Oracle Database Development (SQL, PL/SQL) & Administration
- Development of scripts to setup the entire database systematically and in a modular way inclusive Tablespaces, Users, Roles with appropriate permissions and all required database objects (e.g. tables, views, constraints, (primary-, foreign keys, check-, unique constraints etc.), triggers, indexes, sequences, materialized views, partitioned tables and indexes, database links and more
- Storage-, Session- & Tablespace Management
- Development of Stored Procedures, functions, triggers based on Business requirements
- Implementation and integration of ETL processes to
- Upload mass data of streamed data and files to database level
- Process & transform data based on non-IT-specific guidelines
- Provide data for the presentation level (DWH) to provide ready data for a frontend
- Full data pipeline development, & maintenance in DWH through Staging, Transformation and Presentation stages, ETL, ELT, sourcing data from difference structured sources, transform and interrelate them to each other
- Data Migrations: data analysis & cleansing, Oracle analytical functions
- Data mapping if source and target database structure are different
- Source/target data validation after migration
- Development of Data extraction, loading and transformation processes (ETL, ELT), complete automation
- ETL process tools: SQL*Loader, Informatica, SQL scripting, advanced Oracle features, SQL combined with Unix/Linux shell and Perl scripting
- New developments for frontend applications in Oracle Forms & Reports, Oracle APEX AppBuilder & SQL Workshop (Apps, reports, dashboards), backend Stored Procedures, packages, functions, triggers etc. incl system integration, scheduling
- Development of new links based on data of different data sources (AI)
- Frontend App creation and configuration with Oracle AppBuilder and SQL Workshop (part of APEX)
- Implementation and integration of business logic in PL/SQL, migration (PL/SQL, Unix/Linux), Performance Tuning (query-, index-, optimizer, I/O, process and workflow tuning, ExplainPlan, tkprof) but also Oracle Enterprise Manager (OEM):
- Realtime query monitoring, Performance monitoring & tuning, Dashboard configuration
- CPU, memory, storage monitoring in distributed environments
- Alert setup, configuration & management for outages, security breaches and more
- Datamart integration and process automation
- Data Analysis: source code, query and data analysis; generation of business reports
- Root Cause Analysis incl performance bottlenecks and provide appropriate solutions
Consultancy Services
- Hybrid Support / Linux Engineering / Oracle Development
- Collaboration with clients technical teams and business users/stakeholders
- Deployment-, Monitoring-, Test-, Process Automation, Integration, Networking, Connectivity, Infrastructure
- Unix/Linux scripting (shell, Perl, Python), Sys Admin
- Oracle Development (SQL & PL/SQL), Data Analyst, System Architect
- Process Optimizations, Migrations, Data transformations, DWH, ETL Process dev, Performance Tuning
Portfolio
09/2015 - today:
Role: Unix/Linux Engineering, Automation, Integration, Oracle Data Analysis/Dev
Customer: XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd.
Tasks:
- Airbus
- PLM Database Migration, DWH, ETL process dev, Data Analysis, -Mapping, -Cleansing, Oracle/Linux, complete system setup
- Deutsche Bank
- Monitoring-, Connectivity & Authentication Validation Automation, Prod Support, Process analysis & optimizations, Geneos
- UBS
- Deployment Automation, Nexus, Artifactory, Puppet, Apache Tomcat, Certificate generation/validation, ElasticSearch, internal deployment tools
- BAE Systems
- Data Analysis & Oracle Development of new AI, pipeline data flow root cause investigation, implementation of solutions for found bugs and data corrections
- JP Morgan Chase
- Data Centre Migration, Configuration transformation, Automation, Linux, Athena
- LCH / London Stock Exchange
- Deve?lopment of new Report Management System
- Business User/Stakeholder engagement, requirement interrogation, discussion & solution presentation, requirement analysis & translation into technical specifications, management of global projects & teams
- Data Consolidation on MS: Excel, PowerPoint, Confluence, SharePoint, Wiki, JIRA, ServiceNow, Agile, ITIL
- PostgreSQL, Oracle: SQL Developer, SQL*Plus, SQL*Loader, SQL, PL/SQL, SQL Server: sqlcmd, bcp, SQL
- Linux: Python, shell, Perl, Sys-Admin, Integration, Infrastructure, Storage
Built-on Legacy ?
06/2012 - 04/2015:
Role: Data Analyst, Senior Production Support Analyst (perm)
Customer: Credit Suisse - London / Great Britain
Tasks:
- 1, 2 & 3rd line Production Support, Data Analysis for Equities & FI Commission Mgmt system
- Linux, Sybase, Oracle, SQL Server, PostgreSQL, MySQL, Excel, PowerPoint
08/2004 - 09/2011:
Role: Senior Equities eFX/FX & FIX Support Analyst (freelance & perm)
Customer: UnicreditGroup, BGC Partners, NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd. - London / Great Britain
Tasks:
- Technical Support of Trading Floor Applications, eTrading ULT platforms, client/sales support
- Unix (AIX, HP-UX, SunSolaris), Linux RedHat, shell (bash, sh, ksh), Perl, Win, Control-M, Nagios, SQL
11/1998 - 07/2004:
Role: Core Java/Oracle Developer, DBA for Financial Exchange/Services (perm)
Customer: MeTechnology AG, Brokat Infosystems AG, bbv AG, c.a.r.u.s. AG, Apoll AG, Fernbach Software S.A., ClarITeam S.A. ? Germany / Great Britain
Tasks:
- Core Java/Oracle Development, Oracle DBA, Performance Tuning in all aspects, Forms & Reports