Mario Rothe
Owner / Founder, IT Consultant, Unix/Linux, Oracle, Infrastructure & more
Erfahrungen
Sept. 2015 - Bis heute
9 Jahren 10 Monaten Dubai, Vereinigte Arabische Emirate
HybridOwner / 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
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.