IT consultancy enterprise businesses dealing with global clients in the financial, government and aviation sector covering European and Middle East markets
Juni 2012 - Apr. 2015
2 Jahren 11 Monaten
London, Vereinigtes Königreich
Data Analyst, Senior Production Support Analyst (AVP)
Credit Suisse
BAU and ad hoc production support for equities and fixed income ensuring system stability and high availability for clients and front end users
Data analysis and research for inconsistencies and business report generation
Automation of manual processes, environment setup, reconciliation and backend calculations
Oracle development in PL/SQL for database migration, data transfer, fixes and enhancements with new business logic implementation
Informatica PowerCenter mapping, ETL pipeline design and execution
PowerBuilder development
Backup and recovery using RMAN
Scheduling across network and dedicated servers using crontab, Control-M, custom scheduler and Windows scheduler
Batch processing implementation, maintenance, development, restructuring, simplification and analysis
Root cause investigation and fixes
SQL and PL/SQL implementation and integration in Oracle Data Warehouse backend
Rewriting C++ code into Perl with additional features
Deployment of fixes and enhancements from development to production via QA
Data, query and code analysis
Environment setup and automation
Oracle Data Warehouse development with PL/SQL, SQL*Loader, stored procedures, migrations and performance tuning
Informatica migration process setup and configuration
Implementation and support of logical and physical database models
Decommissioning legacy trading and reporting system and switching to new Oracle data warehouse system
Setup and full automation of pre-production environments with daily rolling environments on Unix and Linux with feed and calculation batch processing and reconciliation
OS and database migrations from Sun Solaris to Linux RedHat using SQL, PL/SQL, shell and Perl scripting
FX trading latency and connectivity investigations using FIX, API and TCP/IP with reconciliations to ensure no data or logic breaks
Collaboration with clients, network, development teams and business users globally
Sybase and Oracle database management and feed automation
Oracle database design, development and performance tuning
Report creation with Oracle APEX AppBuilder
Nov. 2010 - Sept. 2011
11 Monaten
London, Vereinigtes Königreich
Senior eFX/FX/FIX Support Analyst
UnicreditGroup
BAU and ad hoc trading floor production support for up to 300 traders worldwide
Client onboarding with user account setup and configuration in Reuters RET AD for trading portals
Trading backend configuration of FX market data, market making, trading connections, limits and margin configurations
Change control and release management planning, implementation and documentation
Led a small local team through a mass onboarding Java-based project including task prioritization, status reporting, meetings and mentoring
Mentoring and support for team members to ensure reliable trading platform support across shifts
Planning and realization of mass onboarding process
Capacity forecasting for up to three years
Proposed architectural changes for trading system scalability
Performance analysis and rectification through architectural adjustments
FIX connectivity and latency troubleshooting on low latency trading platforms
Latency investigations using TCP/IP sniffer results
Collaboration with traders, sales, test, network, development teams, business users and third party vendors
Planning and implementation of new trading strategies, data handling, onboarding and migration tools
Coordination with infrastructure, NOC and network teams
Sun Solaris to Linux RedHat migration of trading system including scripting, SQL, PL/SQL setup and scheduling
Training of junior team members in London and Munich
Feb. 2010 - Juli 2010
6 Monaten
London, Vereinigtes Königreich
Senior FX FIX Support Analyst
Velocity Systems International Ltd.; BGCPartners Inc.
FIX support production environment setup, configuration and monitoring
Onboarding of new clients as sole point of contact handling up to 8 external clients
Latency issue investigation and resolution
Client connectivity testing and issue resolution
Setup and configuration of FIX market data and trading connections
Exchange connectivity upgrades, integration work and implementations
FX low latency trading platform performance and latency troubleshooting
FIX protocol onboarding from pre-production to production including client information, connectivity tests, conformance certification and test plans, upgrades and migrations
Troubleshooting FIX, API, network, TCP/IP, router and firewall issues in production and pre-production environments
Release and environment management
Development of internal latency reporting applications and scripts in shell, nawk and Perl with performance tuning
Enhancement of FIX connectors including onboarding and test automation and client simulators for stress testing
Control management using Bugzilla and Perforce
Led small integration projects with offshore cooperation
Aug. 2004 - Juni 2009
4 Jahren 11 Monaten
London, Vereinigtes Königreich
Senior Equities/FX & FIX Support Analyst
NYSE Euronext Ltd.; Allegro Development Ltd.; FX Alliance Ltd.; EMC2/Documentum Europe Ltd.
First line technical support of trading floor applications, eTrading platforms and FIX based low latency trading platforms including external client support
Unix (AIX, HP-UX, Sun Solaris, Debian) and Linux (RedHat, SuSE) system management and scripting for root cause investigation, solution design, implementation, release and configuration management
Windows system management
Database development in Oracle, Sybase and MySQL and data analysis
Frontend, middleware and backend system management and application and web server setup, configuration and tuning
Process automation, optimization and report management
Nov. 1998 - Juli 2004
5 Jahren 9 Monaten
Deutschland
Core Java/Oracle Developer, DBA for Financial Exchange/Services
Oracle development, DBA tasks, ERM modeling and performance tuning for forms and reports
Unix and Linux administration
Katar
Software Engineer, Automation/Integration Engineer, Data Architect
BAE Systems – Applied Intelligence
System and data analysis based on Linux and Oracle backend and web frontend to recognize data patterns, trends, relationships and faults
Proof of concept development of new AI data referencing solutions
Automation of multifaceted data consolidation processes with scripting and upstream ElasticSearch
Oracle Enterprise Manager performance monitoring and tuning to hardware level and alert setup and management
Excel data aggregation, consolidation, formulas, dependencies, pivot tables, lookup functions and dashboard creation
Dashboard development and backend process integration with Tableau and ElasticSearch
Data quality analysis and implementation of correction processes adjusting ETL and reloading missed or incorrect data
Test automation advisory and development strategy adjustments for data integrity and completeness
Data architecture, development strategy and architectural design for incoming and outgoing data feeds
Database schema design, setup and implementation of new structures and code
Process code analysis to identify shortcomings and bugs with impact analysis and fixes including proofs of concept for dependency filling
Scalability, archiving, high availability and general architecture and design including source data cleansing, mapping, ETL and transformation
Chair meetings with senior business users and stakeholders to present new concepts, process flows and demonstrate solution safety
Linux process automation, Perl, Python and ElasticSearch
Oracle SQL, PL/SQL development, performance tuning, data analysis, aggregation, database design, normalization and migration optimization for ETL and data upload to Oracle DWH
Oracle SQL Developer and Excel and Linux scripting for automation
BPSS security clearing
London, Vereinigtes Königreich
Quantitative Application Support and DevOps, Infrastructure Support, Automation/Integration
Deutsche Bank
Proof of concept development and implementation of automated system processes
Monitoring by linking crontab based systems to Geneos to provide visibility of previously unrecognized issues
Rebuilt multi-phased feeds to external vendors and developed a single-phased efficient solution
Validation and restructure of calculations using Python Pandas
Dashboard chart creation and publication in Jupyter Notebooks
Automation of validation, monitoring, sanity checks and release processes
Development of a new report management system for a distributed multi-cluster environment including stats reporting and sanity checks
Development of process fixes and enhancements in Python and C++
Infrastructure support with process and workflow optimization and automation
Kerberos authentication setup, troubleshooting, root cause analysis and fixes
SAN/NAS storage configuration, attachment troubleshooting and verification
FIX client onboarding automation, FIX latency troubleshooting, FIX adaptor setup and FIX issue root cause investigations in production
Requirements versus system gap analysis and conversion of high-level business requirements into technical specifications with proof
Overall IT system analysis and advisory on process optimizations and architectural improvements to minimize data loss and outages
Business presentations including impact analysis and stakeholder meetings
Investigation of production issues, root cause analysis and redesign of architecture
Test strategy development and implementation for integration, regression, smoke and stress tests
Process, monitoring and test automation including TeamCity regression test automation and bug root cause investigation
Deployment automation to over 300-node multi-cluster with Ansible playbook and inventory management, troubleshooting and standardization
PL/SQL development including new feed implementations and query, index and optimizer tuning
OEM in a distributed environment for performance and hardware usage monitoring, real-time query monitoring and tuning of CPU, memory and storage
Frontend application, report and dashboard development with Oracle APEX
Data quality assessment and standardization of metadata constraints using complex PL/SQL, forwarding backend errors to frontend users to reduce operational risks
Database design, architectural review and advice with management presentations
Process functionality evaluation against new requirements and redesign
Migration process design and implementation
ETL development and integration including testing, deployment and amendments of existing feeds
Big data analysis and statistics creation to forecast long term trends in business and database usage
Visualization of proposed process flows for business and stakeholder presentations
Production support for a bond trading system with root cause investigations and workflow and security issue resolutions
Security risk and impact assessment with solution proposals and system-wide impact analysis
Firewall and proxy configuration changes
New host setup, business application installation and validation
CI/CD pipeline development, test and deployment automation
Linux shell, Perl, Python (NumPy, Pandas, Jupyter Notebooks), C++, Java, SQL, Oracle, SQL Server, MariaDB and Git
London, Vereinigtes Königreich
Data Centre Migration Specialist, Production Support
JP Morgan Chase
System analysis and gap analysis
Automation of migration and validation processes in Perl
Configuration management including YAML, JSON, XML and sdc
Development of analysis, validation and control processes using Agile and Git
System architecture and design and code and configuration standardization
Gap analysis and system design advice including documentation
Collaboration with development, network, infrastructure and QA teams for system setups
Oracle new database host integration, PL/SQL migration code development, data analysis, transformation and performance tuning
Linux high performance tuning including CPU and memory management, process and network tuning, shell, Perl and Python scripting, kernel and TCP network tuning and benchmarking
KDB+/q data capture, processing, calculations, aggregations and reconciliations from price and data feeds for dashboards
Statistical and business data report generation including validation and publishing
Root cause investigation and troubleshooting of integrated solutions
API and FIX connectivity and latency troubleshooting and FX feed optimizations in Perl and shell
Support of FX production environment including high availability and process and memory root cause investigations
Change and release management, automation and performance tuning
New features and bug fixes development with strategy and architectural design
Root cause analysis and debugging of Java backend components and latency and garbage collection issues
Interaction with internal and external users including traders and brokers
London, Vereinigtes Königreich
Production Engineer, Shell/Perl Development, System Integration
LCH Clearnet Ltd.
Setup, development, testing and integration of high-performance Perl and shell scripts to validate authenticity of generated reports and ensure data integrity
Security assessment, analysis and validation with architectural design from scratch
Shell and Perl development on Linux including multi-threaded procedural and object oriented scripting handling file, SQL, JSON, YAML and XML
Test automation including unit, integration, regression and automated functional testing
Oracle setup and implementation of new business logic, PL/SQL development, index, query and optimizer tuning, Explain Plan and ETL process management including testing and deployment
Frontend application development using Oracle APEX App Builder and SQL Workshop
Development of data aggregation and validation processes
Gap analysis and architectural design improvements with proofs of concept
Change and release management and production support
Setup of production and pre-production environments and test coordination with QA teams
Automation of deployment process from development to production
Integration of new components into system architecture including Java applications
Scalable deployment procedures following Agile methodology
Automation of test processes, configuration management and verifications
Dashboard development for system performance and processing validation and business reports using Tableau and Oracle APEX
London, Vereinigtes Königreich
Unix Engineer, Deployment Automation/Integration
UBS
System gap analysis with identification of safety issues and proposal of fixes
Proof of concept and implementation of new automated deployment processes including interfacing third party components, security policies and administrative account permissions with Nexus, Puppet and Artifactory
Automation of deployment process including test automation within CI/CD pipeline
Deployment automation of Fenergo external vendor product including Tomcat and ElasticSearch with SearchGuard plugin on single and multi-clustered nodes
Configuration of Tomcat, Apache, ElasticSearch and SearchGuard plugin with host-specific configurations and certificates
Configuration and performance tuning to host requirements
System architecture proposals for efficient external vendor software deployment and specification of deployment package requirements
Architectural adjustments to avoid deployment failures and advice on best practice process management to reduce risks
QA test strategy implementation and execution to validate data generation accuracy
Automation and standardization of Tomcat and ElasticSearch CA certification within internal tools and policies
Oracle ETL process root cause investigation, performance tuning, PL/SQL, SQL and query analysis and tuning of upload processes
Gap analysis based on new requirements
Partial redesign of the database model including new tables and stored procedures
Informatica data migration validation and reconfiguration
DBA backup and recovery strategy development for full and incremental backups using RMAN
Security risk analysis and assessment with proposals, development and integration of solutions and impact evaluations
Linux and Sun Solaris process automation, shell, Perl, Python and Puppet
Windows SQL, IIS and MySQL environment setup
Consultant
Various Microprojects
Introductory engagements for external clients in EU and Middle East including proposals for new system architecture
Proof of concept development through prototypes
Proposals for HDD space scaling for Linux production hosts
Gap, impact and process analysis with workflow optimization and automation
Process data aggregation for real-time dashboard reporting using Tableau
KDB+/q data capture, processing, calculations, aggregations and reconciliations for dashboards
Statistical and business data report generation including validation and publishing
Root cause investigation and troubleshooting of integrated solutions
Financial management solution development using JavaScript, JSON, KDB+/q, Python, Node.js and Perl for account booking and data pipeline refinement in Python with GitHub
Business expense reporting aggregation and reporting in Perl
Automated entity transformation including performance benchmark testing of data structures, code designs and methodologies in Perl and Python with reporting
Development and test automation of CI/CD data pipelines including aggregation, transformation and validation in Python
ElasticSearch cluster setup and high-performance testing in Perl, Python and shell
Infrastructure tasks including router, DHCP, DNS and firewall configuration and analysis
FTP server setup and virtual machine environment setup
Oracle database installation, configuration, design, development and performance tuning
ETL process design and pipeline development for data accumulation and loading from data lake
APEX AppBuilder and SQL Workshop dashboard and business reporting development
AWS configuration management including account and IAM user setup
Python development on AWS Cloud9 IDE and regression test automation
Automated server setup and deployment with Ansible configuration and inventory management
Server setup standardization, root cause investigation and upgrades validation
Linux hardening including security policies and BIOS hardening
Deutschland
Database Migration Lead Engineer
ZFL / AHTech / Airbus
Solution design and implementation of data export/import and transformation processes including system integration and validation
Proof of concept with new restructured migration concept minimizing and eliminating key critical risks and time-consuming processes
Source data analysis including identifying data quality issues and proposing rectifying measures to comply with migration constraints
Chair meetings with business stakeholders to present proposed solutions and resolve conflicts between business requirements and data quality issues
Architectural design presentations and documentation with discussions on source data quality, scope, adjustments and progress updates with management, stakeholders and business users
Database structure and data analysis including database size estimation for subsets of source databases and transformed target database
Data mapping, cleansing and correction according to discussed and agreed rules
Test and validation processes including unit and full QA integration testing
Process automation
Linux automation to standardise and automate migration processes
Storage management including storage administration, configuration and mounting of NAS, CIFS and SMB shares
Oracle ETL and data transformation processes
Conversion of business requirements into technical transformation strategy including validation, verification processes and documentation
Axalant Vault stored files validation against referencing database records with consistency checks and file extraction processing
Zusammenfassung
FIX protocol based low and ultra-low latency trading platforms: client onboarding, latency root cause investigations, configuration management & automation
Architectural Design of System & Databases
Oracle performance tuning, SQL, PL/SQL, Query & Optimizer tuning, ExplainPlan, tkprof, OEM, data transformation & ETL process management & root cause analysis, testing & deployment
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, Python
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
1st, 2nd & 3rd line Production/trading floor Support & project delivery
Mentoring, coaching and leading other team members through new projects
Databases: Oracle, SQL Server, MySQL, Sybase, MariaDB, PostgreSQL and others
Sprachen
Deutsch
Muttersprache
Englisch
Verhandlungssicher
Ausbildung
Sept. 1990 - Juli 1995
Martin-Luther-University Halle-Wittenberg
Mathematics, Physics, Information Technology, Astronomy · Halle (Saale), Deutschland
Zertifikate & Bescheinigungen
BPSS Security Clearing
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.