Mario Rothe

Owner / Founder, IT Consultant, Unix/Linux, Oracle, Infrastructure & more

Dubai, Vereinigte Arabische Emirate

Erfahrungen

Sept. 2015 - Bis heute
9 Jahren 10 Monaten
Dubai, Vereinigte Arabische Emirate
Hybrid

Owner / Founder, IT Consultant, Unix/Linux, Oracle, Infrastructure & more

XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd.

  • 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

MeTechnology AG; Brokat Infosystems AG; bbv AG; Apoll AG; Fernbach Software S.A.; ClarITeam S.A.

  • Core Java front and backend development
  • 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