IT Consultant, Founder/Owner, Oracle Migration Specialist, Automation

XTra Technology Consultancies L.L.C-FZ

Internet & IT

< 10 team member

Expanded services for clients in Europe and Middle-East

Focus still on Oracle Development & DBA incl Data modelling, architectural design, PL/SQL, data migrations, performance tuning, implementation, integration, testing, rollout, support, root cause analysis.

Automation also on Linux by scripting (shell, Perl, Python) and system integration.

Major clients: Airbus, BEW Berlin

Minor clients: global medium-sized businesses on micro projects on Oracle & Linux automation, performance optimisation, root cause investigations & solution implementation

IT Consultant, Owner/Founder, Oracle & Linux Automation & integration

CapExTra Technology Solutions Ltd.

Internal Projects:

Financial Management:
- A solution based on a combination of JavaScript, JSON, KDB+/q, Python, Node.js and Perl to manage bookings of private, business and investment accounts with categorized transactions
Business Expense Reporting:
- Aggregation of business expenses and reporting in Perl
Automated Entity Transformation:
- Automated performance benchmark testing of different data structures, code designs and methodologies with reporting, in Perl
ElasticSearch:
- Setup of ES Cluster and prototype for high performance testing, in Perl, Python, shell scripting
Router, DHCP setup & configuration, DNS server configuration
ftp server setup & configuration
Virtual Machine env setup
Oracle Database Design, Setup, Dev & performance tuning
Automated Server Setup & Deployment:
Ansible workbook Management
Workbook configuration adjustments and setup for new setup of new servers
Standardization of server setup
Linux hardening:
Linux hardening as part of Sys setup to requirements for Linux security
Root and other user security policies, system connectivity security incl BIOS hardening and more.

Quantitative Application Support and DevOps, Automation/Integration, Infrastructure Support

Deutsche Bank

Automation & Integration of monitoring and trade feed processes:

Proof of Concept, development & implementation of automated system processes
- Monitoring: linking crontab based systems to Geneos efficiently: providing more visibility of until then unrecognized issues
- re-build multi-phased feeds to external vendors and develop a single-phased more efficient solution
- Automation of validation & monitoring processes, sanity checks, release processes
- Development of new Report Management System for distributed multi-cluster environment, Stats reporting, Sanity checks
Process, Fix & Enhancement solution development
Infrastructure Support
Architectural Design:
- Requirements vs system gap analysis
- Conversion of high-level business requirements into technical specification with technical proof
- Advise on architectural improvements and alterations to minimize data loss and system outages
- Business presentations for new solutions incl impact analysis
- Investigation of current production issues, root cause analysis and re-design of current architecture
Process, Monitoring & Test automation, TeamCity regression test automation, Deployment automation to multi-cluster with over 300 nodes and evaluation, Ansible runbook management
Oracle:
- PL/SQL Development, new feed implementations & Query/index/Optimizer tuning
- Database Design, architectural review & advise, presentation of proposed solutions to management and stakeholders
- Evaluating process functionality against new requirements and draw new designs
- Migration process design & implementation
- ETL process dev & integration incl. testing and deployment; amendments/fixes of existing feeds
- Big Data analysis & statistics creation to forecast long term trends in business data usage and database usage
Production Support for Bond trading system, root cause investigations, solutions for identified workflow & security issues e.g. with multi-threaded processes
Advise on Architectural Design, tools, algorithms and methods for a scalable, most reliable distributed systems running on best performance
Security risk & impact assessment; propose solution and system-wide impact analysis before and after solution integration
TeamCity test validations, root cause investigations, process management
Firewall/Proxy configuration changes
New host setup & business app installation, validations
CI/CD pipeline development, test & deployment automation
Linux: shell, Perl, Python, Perl, Java, SQL, Oracle, SQL Server, Maria database, git

Key Tools: Linux system management, Grafana, TeamCity, Prometheus, Sys Config Management, BitBucket, JIRA, Confluence, ServiceNow, CI/CD Agile, Oracle SQL*Loader & internal loader tools

Unix Engineer, Deployment Automation/Integration

UBS

Deployment Automation & Integration of Regulatory Validation Application:
* System Gap Analysis, identification of safety issues and proposals to fix them
* Proof of Concept & implementation of new automated deployment processes incl. manual tasks
restricted by external vendor and internal UBS constraints
* Automation of deployment process incl setup & development of a solution interfacing third
party deployment components, security policies and administrative account permissions with
Nexus, Puppet, Artifactory etc., Test automation within CI/CD pipeline
* Deployment Automation of Fenergo (external vendor product) incl. Tomcat & ElasticSearch (incl
SearchGuard plugin) setup on single- and multi-clustered nodes (incl. load-balanced/failover
hosts) in different environments incl documentation & evaluation
* Configuration of required Tomcat Apache & ElasticSearch & SearchGuard plugin with host
specific configs and certificates
* Configuration & performance tuning to host specific requirements
* System architecture proposals to run deployment of external vendor's software more efficiently
and specify requirements for external vendor's deployment packages
* Architecture adjustments to avoid deployment failures of current deployment processes and
advice design changes with best practice process management to reduce certain risks
* Automation and standardization of Tomcat & ElasticSearch CA certification constrained by UBS
internal tools & policies
* Oracle: ETL process root cause investigation, performance tuning, PL/SQL, SQL, query analysis
& upload process root cause investigation & fine tuning
* Gap Analysis based on new requirements
* Partial re-design of database model plus new database tables and other objects incl stored
procedure
* Security Risk Analysis & Risk Assessment; proposal, development & integration of new solutions
incl impact evaluations
* Linux: Process automation, shell, Perl, Puppet
* Windows: SQL, IIS & MySQL DB environment setup
Key Tools: Nexus, Puppet, Artifactory, Maven etc., Documentation: Confluence, Wiki

Software Engineer, Automation/Integration Engineer, Data Architect

BAE Systems - Applied Intelligence

Automation & Integration of aggregated business information:
* System & Data Analysis based on Linux/Oracle backend & Web Frontend
* Proof of concepts, development of new AI data referencing solutions
* Automation of multi-facetted data consolidation processes, scripting etc. incl upstream
ElasticSearch
* Advisory and execution on
* Test automation, development strategy adjustments involving now data integrity and
completeness
* Data architecture, development strategy & architectural design incl incoming and outgoing
data feeds
* Database schema design, setup and implementation of new structure incl code
* Process code analysis, identification of short comings, bugs resulting in impact
analysis, code fixes and proof of concept incl process to fill gap of missed data incl
all dependencies
* Scalability, archiving, high availability
* General architecture & design issues
* Chair of meetings with Business users & stakeholders with presentations, presenting new
strategies and what their business could get from a new solution even beyond the
requirements, demonstrating also the safety of a solution
* Linux: Process automation, Perl, Python, ElasticSearch
* Oracle: SQL, PL/SQL Development, performance tuning (SQL statement, index, optimizer tuning),
data analysis & aggregation, database design & normalization; database migration optimization,
ETL process management & solutions
* BPSS Security clearing

Data Centre Migration Specialist, Production Support

JP Morgan Chase

Automation of multi-phased migration processes of global datacentre:
* System Analysis, gap analysis
* Automation of migration & validation processes (Perl)
* Configuration Management (incl YAML, JSON, XML, sdc)
* Development of analysis, validation and control processes, Agile, GIT
* System architecture & design; Code & Config Standardization
* Gap Analysis and system design advice incl. documentations
* Collaborate with internal Dev, network, infra & QA teams for system setups etc.
* Oracle: new database host integration, PL/SQL migration code dev, data analysis &
transformation, performance tuning: query-, index-, optimizer-tuning, ExplainPlan etc.
* Linux: high performance tuning (process CPU & memory management, Linux shielding, capacity
management etc.), shell, Perl, Python scripting; Kernel & TCP network tuning, window scaling,
bandwidth usage optimization etc.; Linux shielding setup and configuration, benchmark &
aggregated testing
* KDB+/q: root cause investigation, troubleshooting of integrated solution
* API & FIX Connectivity & Latency troubleshooting; FX feed optimizations, Perl, shell
Support of FX Prod Env, high availability:
* root cause investigation, process and memory interrogation
* Change & Release Management, Automation, Performance Tuning
* new features & bug fixes, strategy and architectural design
* root cause analysis, troubleshoot, debug Java based backend components, latency
troubleshooting, GC issues etc.
* dealing directly with internal and external users, traders, brokers, front office

Production Engineer, shell/Perl Development, System Integration

LCH Clearnet Ltd.

High Performance, High Security Solution: Design, Development, Implementation & testing of
high-performance file & content validation solution for Reporting:
* Setup, development, test and integration of high-performance Perl (and shell) scripts to
validate authenticity of generated reports by internal teams for LCH members/clients and
assure data integrity
* Security assessment, analysis and validation; architectural design from scratch
* Shell (Korn shell, bash)/Perl development on Linux: multi-threaded, procedural & OO; (plus
temporary smaller Windows solution) incl. file, SQL, JSON, YAML, XML
* Test Automation: Unit, Integration, Regression testing and automated functional testing
Database Management:
* Oracle Setup & Implementation of new business logic, PL/SQL Dev & index-, query-,
Optimizer-tuning, Explain Plan, ETL process management incl testing and deployment
* Development of data aggregation and validation processes
* Gap Analysis & architectural design improvements, proof of concept
Production Support:
* Change and Release Management
* Setup of environments, prod and pre-prod, and run testing in pre-prod envs
* Coordinate testing with QA teams in pre-prod envs
* Dealing also directly with internal/external clients, users
System Integration:
* Automation of Deployment process from dev into higher envs up to production env.
* Integration of new components into system architecture, also Java based apps
* Scalable deployment methods & procedures delivering long term time savings with reliable
deployment procedures after Agile methodology
* Automation of test processes, configuration management & verifications

Data Analyst, Senior Production Support Analyst (AVP)

Credit Suisse

1, 2 & 3rd line Production Support:
* BAU/Adhoc Production Support for Equities & Fixed Income
* ensuring system stability and high availability with clients & front-end users
* Data Analysis, research for data inconsistencies, business report generation
* Automation of manual processes, environment setup processes, reconciliation and business
processes as well as backend calculations etc.
* Oracle Development: PL/SQL for database migration, data transfer and fixes and enhancements
with new business logic implementation
* Scheduling across network as well as on dedicated servers (crontab, Control-M, inhouse build
scheduler with dependency logic, Windows scheduler etc.)
* Batch processing: implementation, maintenance & development/design, restructuring,
simplifications, analysis
* analysis, root cause investigation, fixes
* implementation/integration SQL & PL/SQL in Oracle Data Warehouse backend
* reworking C++ code into Perl with new features on top of existing functionality
* bringing fixes and enhancements from Dev forward to Production via QA
* data, query and code analysis
* environment setup & automation
Project work:
* Oracle Data Warehouse development: PL/SQL development, mass data upload and transfer by
SQL*Loader, stored proc dev, database migrations, performance tuning; Implementation & Support
of concepts, logical and physical DB models
* successful decommissioning of major components of an old trading/reporting system and
switching over to new one based on Oracle data warehouse
* Setup and fully automation of pre-prod envs with daily rolling environments on Unix (Solaris)
and Linux (Redhat) fully scheduled setups and feed and calculation/batch processing incl
reconciliations
* OS (SUN Solaris to Linux RedHat) and database migrations using scripting (SQL, PL/SQL, shell,
Perl etc.)
* FX trading: FIX, API & TCP/IP network latency root cause investigations, FIX connectivity
issues on low latency platform
On all: reconciliations to ensure proof of no data/logic breaks etc.
By:
* cooperate with Clients, Network, internal development teams, in/external Business users
globally
* Sybase/Oracle Database management, feed management/development/automation
* Oracle database design, development SQL, PL/SQL & stored procs, packages etc, Performance
Tuning, SQL*Loader, *LOB cols
* Incident management covering Dev, test and prod envs
* Development of new procedures/scripts
* Documentation, specification and description/documentation for Releases
* Utilization & performance monitoring & improve processes & procedures
* release & environment management/automation
* mentor & train more junior team members (up to 3 locally and 6 abroad (Singapore, India, New
York))
* lead small teams through new projects, distributed team: 4 in APAC, 2 in NY, 2 in Europe,
chair team meetings and inter-relational team meetings (2NY, 3 Singapore and India)
* mentor and coach university apprentice (1) locally
Key Technologies:
* Unix/Linux shell (sh, ksh), Perl scripting, Unix/Linux System tools & management, Windows
* Sybase/Oracle, SQL, PL/SQL, SQL Server
* Control-M, Nagios, self-developed monitoring tools
* FIX: FIX connectivity, latencies, Cameron FIX Engine
* Issue tracking: Remedy, Jira, internal tools, ITIL, Agile; Versioning: svn SubVersion

Senior eFX/FX/FIX Support Analyst

UnicreditGroup

1st & 2nd line Trading Floor Support:
* BAU/Adhoc Trading Floor Production Support for up to 300+ traders worldwide, Front Office
* Client Onboarding: client/user/account setup and configuration in RET AD (Reuters) for trading
portals as Quantus, 360T, Currenex, Bloomberg, FXall, RTFX, RET Admin, RET Trader/Client
applet
* Trading backend configuration: FX Market Data, MM, trading connections, limits, margin groups
and configurations
* Change Control / Release & environment management: planning to implementation & documentation
of new releases
Team Management
* Leading small local team through mass onboarding project (Java based)
* Set tasks and prioritize
* Gather regular status reports
* Chair team meetings to discuss open issues and alternative solutions
* Monitor progress of tasks assigned to team members and discuss new estimates
* Mentoring more junior team members
* Assist and support in technical matters where technical skills are not efficient or
advanced as expected. All team members should be able to support trading platforms on all
levels reliably due to shift works; so no risk periods.
Project Work:
* Plan concept and realisation of mass onboarding process
* Provide capacity forecasts for next 1, 3, 6, 12 months and 3 years
* Propose architectural changes to ensure scalability of entire trading system based; storage
changes, process and storage separation concepts etc.
* Analysis of performance issues of trading system and rectification by architectural changes
* FIX connectivity and latency issue troubleshooting on low latency trading for third projects
* Latency investigations based on TCP/IP sniffer results/network captures
* Architecture tuning
By:
* cooperate with Traders, Sales, Test, Network, internal development teams, internal/external
Business users and 3rd party vendors
* plan and implement new trading strategies, data handling, onboarding procedures, upload,
synchronization and migration tools
* Coordinate implementations with infrastructure, NOC and network teams
* SUN Solaris to Linux RedHat migration of trading system, covering shell, Perl scripts, SQL and
PL/SQL codes, setup and implementations on new systems incl scheduling etc.
* lead team members through mass onboarding project (6 support, integration and development)
* train more junior team members up to scratch (4 locally, 1 abroad (Munich))
Key Technologies:
* Unix/Linux, shell (bash, sh, ksh), Perl, SQL scripting, Windows
* Control-M, Nagios
* Reuters RET, SQLServer, Apache configuration & certificate management, JavaScript, Windows, Remedy
, HP QC & SM, Jira, AMD Reuters, GIT.

Senior FX FIX Support Analyst

Velocity Systems International Ltd., BGCPartners Inc.

Front Office Trading Floor Support for FX Sales/Liquidity team
* FIX Support Production environment, setup, configuration & monitoring
Project Work:
* Deal/cooperate with up to 8 external clients as sole point of contact
Main issues:
* Onboarding new clients
* Latency issue investigation and resolution
* Client connectivity testing/issues
* Setup and configure FIX Market Data & Trading connections
* Exchange connectivity: upgrades, integration work, implementations
* FX Low Latency Trading Platform: trading connections, market data & pricing/rates feeds;
performance & latency root cause investigations and fixes
* FIX protocol: Onboarding of new clients from pre-production environments until go live in
production
* providing initial information to clients
* setup, FIX connectivity tests
* conformance certification testing & test plans
* upgrades, migrations
By:
* troubleshoot issues on FIX, API, network, TCP/IP (sniffer analysis, l/r roundtrip times,
re-transmission of TCP packages), router and firewall levels in Production and pre-production
environments
* Release & environment management
* Development of internal applications (latency reports)/scripts (shell, nawk, Perl (incl
debugger)), perf tuning on Linux/Solaris. JavaScript
* Development of FIX connector enhancements; onboarding & test automation, FIC client simulator
for stress test and to reproduce performance issues
* Control Management: Bugzilla, Perforce issue tracking/management system to support traders &
internal teams and keep agreed SLA's
* Leading small projects for integration work with 1.5 people locally, 1 off-shore in New York.
In cooperation with client's technical teams.
Key Technologies:
* Unix/Linux shell (bash, sh, ksh), Perl scripting, XML; Unix tools and management processes

Senior Equities/FX Support Analyst

NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd.

NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd. - London
/ Great Britain
Senior Equities/FX Support Analyst [contract & perm]
1st Line Technical Support of Trading Floor Applications, eTrading platforms, FIX based low latency
trading platforms incl external client support

Core Java/Oracle Developer, DBA for Financial Exchange/Services

MeTechnology AG, Brokat Infosystems AG, bbv AG, c.a.r.u.s. AG, Apoll AG, Fernbach Software S.A., ClarITeam S.A.

Core Java/Oracle Development, Oracle DBA, Performance Tuning in all aspects

Oracle Developer, Linux Engineer, Deployment Automation/Integration, Data Analyst, Prod Support

Profile attachments

About me

Languages

Project history