Mario Rothe

Owner / Founder, IT Consultant

Avatar placeholder
Dubai, United Arab Emirates

Experience

Sep 2015 - Present
10 years 4 months

Owner / Founder, IT Consultant

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

  • Oracle database migration lead engineer for multi-regional PLM system: solution design, source data analysis, data mapping, cleansing, test and validation, process automation, storage management, ETL by ODI and SQL*Loader
  • Quantitative application support and DevOps for monitoring and trade feed processes: automation & integration, Python Pandas dashboards, report management system, infrastructure support, FIX client onboarding automation, architectural design, QA automation, deployment automation, PL/SQL development, OEM performance monitoring, Oracle APEX dashboards, database design, ETL development, big data analysis
  • Unix engineer for deployment automation/integration of regulatory validation application: system gap analysis, automated deployment with Nexus, Puppet, Artifactory, CI/CD, Tomcat & ElasticSearch setup and tuning, QA test strategy, Oracle ETL tuning, DBA backup and recovery, security risk analysis
  • Software engineer, automation/integration engineer, data architect for AI data consolidation: system and data analysis, proof of concepts, scripting, OEM performance tuning, Excel dashboards, Tableau integration, data quality correction, ODI, data architecture, schema design, ETL, chair meetings with stakeholders
  • Data centre migration specialist and production support: automation of migration and validation processes, config management, PL/SQL migration code, Linux performance tuning, KDB+/q FX data processing, API & FIX latency troubleshooting, change and release management, Java component debugging
  • Production engineer for high-performance file & content validation solution: Perl/shell development, security assessment, test automation, Oracle PL/SQL dev, ETL, Oracle APEX frontend, change and release management, system integration, dashboard development
  • Microprojects: system architecture proposals, prototypes, workflow optimization, real-time dashboard reporting with Tableau, KDB+/q data pipelines, financial management solution, business expense reporting, entity transformation benchmarks, CI/CD data pipelines, ElasticSearch, PostgreSQL, infrastructure setup (router, DNS, firewall, VMs), Oracle installation and tuning, APEX reporting, AWS configuration, Ansible automation, Linux hardening
Jun 2012 - Apr 2015
2 years 11 months

Data Analyst, Senior Production Support Analyst (AVP)

Credit Suisse

  • 1st, 2nd & 3rd line production support for equities & fixed income: system stability, availability, data analysis, business report generation
  • Automation of manual and scheduling processes, reconciliation, backend calculations
  • Oracle PL/SQL development for database migration, data transfer, enhancements; Informatica PowerCenter, ODI, PowerBuilder, Snowflake schema design
  • Backup & recovery using RMAN; scheduling with crontab, Control-M, Windows scheduler
  • Batch processing design, restructuring, root cause analysis, fixes implementation
  • SQL*Loader mass data upload, stored procedure development, performance tuning via explain plan, OEM
  • Environment automation for pre-prod on Solaris and Linux; OS and database migrations via scripting
  • FIX, API & TCP/IP latency investigations; client communications with global users
  • Sybase, Oracle, PostgreSQL management; Control-M, Nagios, internal monitoring tools
  • Mentoring and leading distributed teams (APAC, NY, Europe); release and environment management
Nov 2010 - Sep 2011
11 months

Senior eFX/FX/FIX Support Analyst

UnicreditGroup

  • 1st & 2nd line trading floor support for 300+ traders; client onboarding in Reuters RET AD for multiple portals
  • Trading backend configuration: FX market data, trading connections, limits, margin groups
  • Change control, release & environment management; planning, implementation, documentation
  • Team management: task prioritization, status reporting, mentoring junior members
  • Mass onboarding process architecture, capacity forecasting, scalability proposals
  • Performance issue analysis and architectural tuning; FIX connectivity and latency troubleshooting
  • SUN Solaris to Linux migration for trading system; shell, Perl, SQL and PL/SQL scripting
  • Collaboration with traders, sales, network, internal and 3rd party teams; training juniors
Feb 2010 - Jul 2010
6 months

Senior FX FIX Support Analyst

Velocity Systems International Ltd.; BGCPartners Inc.

  • Front office trading floor support for FX sales/liquidity team; FIX production environment setup, configuration & monitoring
  • Client onboarding, latency investigation, connectivity testing, conformance certification
  • Setup and upgrade of FIX market data & trading connections; exchange integration
  • Issue troubleshooting at FIX, API, network, TCP/IP, router and firewall levels
  • Development of internal latency report applications/scripts (shell, nawk, Perl)
  • FIX connector enhancements, onboarding & test automation, client simulator for stress testing
  • Release & environment management; Bugzilla, Perforce for tracking
Aug 2004 - Jun 2009
4 years 11 months

Senior Equities/FX & FIX Support Analyst

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

  • 1st line technical support of trading floor applications and eTrading platforms
  • Support of FIX-based low latency trading platforms and external clients
  • Unix (AIX, HP-UX, Solaris, Debian) and Linux (RedHat, SuSE) management; scripting, root cause investigation
  • Release & configuration management; solution design and implementation
  • Windows server and middleware setup and tuning; database dev (Oracle, Sybase, MySQL)
  • Process automation, report management and optimization
Nov 1998 - Jul 2004
5 years 9 months

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 and DBA
  • ERM modeling, performance tuning, Oracle Forms & Reports
  • Unix/Linux environments

Summary

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) 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) Implementation of Validation Processes to confirm compliance with regulatory requirements (12 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)

Skills

  • Oracle Database Design, Modelling, Development And Performance Tuning & Administration – Since 1998
  • Since 2004 In Production / Application Support, Oracle Development, Etl, Datawarehouse Processes
  • 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 In-line 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 Different 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

Languages

German
Native
English
Advanced

Education

Sep 1990 - Jul 1995

Martin-Luther-University Halle-Wittenberg

Equivalent to British master's degree · Mathematics, Physics; Information Technology, Astronomy · Halle (Saale), Germany

Certifications & licenses

BPSS Security Clearing

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Jorge Machado
Jorge Machado

Data Architect

View Profile
Jürgen Fey
Jürgen Fey

AR/VR/XR Architect

View Profile
Christoph Wagner
Christoph Wagner

System Architect / System Engineer / Programmer

View Profile
Josef Kroiss
Josef Kroiss

Architect / Senior Consultant

View Profile
Yahya Vall
Yahya Vall

Co-founder & CEO

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Ildar Allayarov
Ildar Allayarov

Senior Data Engineer

View Profile
Lothar Hinsche
Lothar Hinsche

Solution Manager for PoC investigation and replacement and refinement of an existing cloud and IoT power plant control system

View Profile
Sanchit Katiyar
Sanchit Katiyar

Global Data Analytics & Business Intelligence Consultant

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Jörg Trappschuh
Jörg Trappschuh

Database Expert and Software Developer

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Anton Klonov
Anton Klonov

Head of Technical Overall Integration NSC / Hadoop Cloud Development

View Profile
Finn Hinrichsen
Finn Hinrichsen

Data Architecture

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile
Reinhold Schätz
Reinhold Schätz

Senior Software Developer

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Max Ritter
Max Ritter

Cloud (AWS) | AI | DevOps | Data

View Profile
Niko Schmuck
Niko Schmuck

Developing Architect, Technical Lead "gridlytics"

View Profile
Rodrigo Herrán
Rodrigo Herrán

Data Engineer and Founder

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Albert Frischmann
Albert Frischmann

Lead Product Owner

View Profile
Henning Uiterwyk
Henning Uiterwyk

Senior Expert Data Governance, Master Data Quality and Data Migration

View Profile
Germo Görtz
Germo Görtz

BI Developer

View Profile
Thomas Hoefkens
Thomas Hoefkens

Senior MLOps, DevOps Engineer

View Profile
Peter Brungs
Peter Brungs

Data Warehouse Consultant (Development and Analysis)

View Profile