Mario Rothe - Owner / Founder, IT Consultant

Q: Where is Mario based?

Mario is based in Dubai, United Arab Emirates and can operate in on-site , hybrid , and remote work models.

Q: What languages does Mario speak?

Mario speaks the following languages: German (Native), English (Advanced) .

Q: How many years of experience does Mario have?

Mario has at least 25 years of experience. During this time, Mario has worked in at least 6 different roles and for 6 different companies . The average length of individual experience is 4 years and 3 months . Note that Mario may not have shared all experience and actually has more experience.

Q: What is Mario's latest experience?

Mario's most recent position is Owner / Founder, IT Consultant at XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd. .

Q: What companies has Mario worked for in recent years?

In recent years, Mario has worked for XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd. .

Q: Which industries is Mario most experienced in?

Mario is most experienced in industries like Banking and Finance , Information Technology , and Professional Services .

Q: Which business areas is Mario most experienced in?

Mario is most experienced in business areas like Information Technology , Business Intelligence , and Quality Assurance . Mario also has some experience in Operations .

Q: Which industries has Mario worked in recently?

Mario has recently worked in industries like Banking and Finance , Information Technology , and Professional Services .

Q: Which business areas has Mario worked in recently?

Mario has recently worked in business areas like Business Intelligence , Information Technology , and Quality Assurance .

Recommended expert

Dubai, United Arab Emirates

Check rate

Experience

Sep 2015 - Present

10 years 9 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

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Banking and Finance, Information Technology, and Professional Services.

Banking and Finance

Information Technology

Professional Services

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Quality Assurance, and Operations.

Information Technology

Business Intelligence

Quality Assurance

Operations

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

Statistics

Experience

Total positions 6

Experience in Banking and Finance 25.5 y

Avg length 4 y 3 m

Longest experience 10 y 8 m

Expertise

Recent roles Owner / Founder, IT Consultant, Data Analyst, Senior Production Support Analyst (AVP), Senior eFX/FX/FIX Support Analyst

Main industries Banking and Finance, Information Technology, Professional Services

Main business areas Information Technology, Business Intelligence, Quality Assurance

Qualifications

Highest degree Master

Certifications earned 1

Profile

Created

March 2024

Last Update

June 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Mario based?

Mario is based in Dubai, United Arab Emirates and can operate in on-site, hybrid, and remote work models.

What languages does Mario speak?

Mario speaks the following languages: German (Native), English (Advanced).

How many years of experience does Mario have?

Mario has at least 25 years of experience. During this time, Mario has worked in at least 6 different roles and for 6 different companies. The average length of individual experience is 4 years and 3 months. Note that Mario may not have shared all experience and actually has more experience.

What roles would Mario be best suited for?

Based on recent experience, Mario would be well-suited for roles such as: Owner / Founder, IT Consultant, Data Analyst, Senior Production Support Analyst (AVP), Senior eFX/FX/FIX Support Analyst.

What is Mario's latest experience?

Mario's most recent position is Owner / Founder, IT Consultant at XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd..

What companies has Mario worked for in recent years?

In recent years, Mario has worked for XTra Technology Consultancies L.L.C-FZ & CapExTra Technology Solutions Ltd..

Which industries is Mario most experienced in?

Mario is most experienced in industries like Banking and Finance, Information Technology, and Professional Services.

Which business areas is Mario most experienced in?

Mario is most experienced in business areas like Information Technology, Business Intelligence, and Quality Assurance. Mario also has some experience in Operations.

Which industries has Mario worked in recently?

Mario has recently worked in industries like Banking and Finance, Information Technology, and Professional Services.

Which business areas has Mario worked in recently?

Mario has recently worked in business areas like Business Intelligence, Information Technology, and Quality Assurance.

What is Mario's education?

Mario holds a Master in Mathematics, Physics; Information Technology, Astronomy from Martin-Luther-University Halle-Wittenberg.

Does Mario have any certificates?

Mario has 1 certificate: BPSS Security Clearing.

What is the availability of Mario?

Mario is immediately available full-time for suitable projects.

What is the rate of Mario?

Mario's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.