Alex Odesser

Contractor

Alex Odesser
Hamburg, Germany

Experience

Apr 2022 - Aug 2024
2 years 5 months
Munich, Germany

Contractor

Telefonica Germany GmbH & Co. OHG

  • Data-analysis, Preparation, gathering and coordination of business requirements for retrieval of monthly- and long term (CLV – relevant) cost- and revenue-components per contract for a customer–base–grouping project (HUB–Project) for B2C-Postpaid-Controlling
  • Concept and Implementation of cost- and revenue-KPIs calculation and corresponding CLV–reports (Oracle, Perl, SVN, MS SQL Server, MS Power BI, Serviceware Performance Analytics)
  • Operational support of the HUB-Project – various ad-hoc reports, deployments, job-scheduling etc. (Oracle, SVN, BICSuite–Scheduler, DWSODA etc.)
  • Analysis, implementation, retrieval and reporting of various physical and financial KPIs for B2P-Prepaid Business on an existing data-mart (Oracle, Perl)
Jan 2019 - Dec 2021
3 years
Nuremberg, Germany

Contractor

Sopra Financial Technology GmbH

  • Technical Support for Setup and Implementation of a Risk Management Solution of ParcIT GmbH (Okular v. 6.1–6.5) for several Banks
  • Concept, Architecture and Development of a Data Cleansing–Solution for Inbound–Interface of Okular (DB2, Perl, Linux, SVN)
  • Concept, Development and Coordination for Setup of Job Scheduling for Okular-Operations
  • Conception and Implementation of the customized Release Management, Packaging and Deployment (Perl, DB2, Linux, SVN, Maven, Nexus, Jenkins etc.)
  • Conception and Implementation of a Solution for anonymization of Okular–Customer Data for external Interfaces and Test-Environments (DB2, Perl, Linux)
  • Setup of a centralized market-data Database for Okular (DB2, Perl)
  • Implementation of several interfaces for market–data for Okular (Perl, DB2, XML etc.)
  • Implementation of inter-stage Transfers for Okular–Database-schemas
  • Implementation of a GDPR-compliant Erasure in Okular-Databases
  • Production–Support for the complete implemented solutions above
Jan 2017 - Present
9 years 1 month
Schwedt, Germany

Contractor

PCK Refinery GmbH

  • Concept, Architecture, Development and Support of an individual Job-scheduling solution for daily supply management reporting (Oracle, Perl, SVN)
  • Concept and Development of a Packaging - and Deployment – System to capture existing Environments to a package and to deploy a complex new Environment on an AIX and Oracle – Platform (AIX, Perl, Oracle, SVN)
  • Concept, Planning and Implementation of a full regression test for the daily supply management reporting (Oracle, Perl, PL/SQL, SVN)
  • Implementation and development - support of back-end part for the Web-Based Job Control Client (Perl, Oracle, SVN)
  • Production – support of the new fully implemented job-scheduling solution
  • Implementation and Integration of additional pipelines/interfaces into the Job scheduling
Aug 2015 - Dec 2016
1 year 5 months
Düsseldorf, Germany

Contractor

NTT Data Germany/E-Plus/Telefonica

  • Data Management, Migration issue resolution and Data Cleansing for the most migration paths—adjustment of data on the source stack to be acceptable by migration tooling and on the target stack systems (Oracle SQL, EII, Perl, Linux, git, CASS, KUBIS, Lucent IN, SALCUS, SPAIN)
  • Concept and Data Mining for product mapping solution of the B2P Post- and Prepaid subscriber-migration from E-Plus- to Telefonica CRM- and Billing environment (Oracle SQL, MS SQL Server, EII, Perl, Linux, git, CASS, KUBIS, Lucent IN, SALCUS, SPAIN)
  • Taking over and 3-rd level application support for billing– and CRM-relevant applications of E-Plus, setup of development- and test-environments in Docker-container and VM-Boxes with own development infrastructure (Linux, git, setup of Oracle and Informix DB Servers and Databases etc.)
  • SBS–Billing solution for fix net customers (Oracle, PL-SQL, C#)
  • CSC-Toolbox–Tools for support of CRM for some server–based operations in MNP- and Product-management (Unix, Shell, Perl, Informix, CASS)
Jun 2013 - Present
12 years 8 months
Büdelsdorf, Germany

Contractor

mobilcom-debitel GmbH

  • Investigation and redesign of the production script framework in order to support the new enterprise financial balancing requirements (Perl, JOX, Informix, Linux, MCBS)
  • Concept and implementation of JCC – JOX Cassandra Connectivity – a JDBC driver for Cassandra Database 2.0 (Datastax Java driver, Apache Cassandra DB, JOX)
  • Support by creation of a B2B test platform (JOX, Perl, Linux, Informix)
  • Concept and Implementation of load balancing functionality and virtualisation solution for the Process Automation Tool JOX (JOX, Java, Oracle, Perl)
  • Concept and consulting of source code versioning for the billing – satellite systems in terms of packaging and release management (Subversion)
  • Support of rating and billing automation implementation in JOX – replacement of the legacy scheduling solution (SOS) by JOX
  • Concept, development and production support for Server Configuration Capturing (SCC) solution – for monitoring and reporting of configuration changes on virtual application servers (JOX, Perl, SLES, NFS)
  • Concept and implementation support for a separated integration test environment (IP Network, JOX, Informix, Oracle, Perl, MCBS)
  • Concept and Implementation of a reconciliation process for a migration of 15 Informix – based instances containing billing system data (Informix, MCBS, JOX, Perl)
  • Concept and implementation of the Copy Entity – process for the billing system MCBS. The process allows copying any object like contract, invoice, product etc. from one database to another.
  • Support of Migration of multiple DBMS – Systems under JOX-Control from Informix to PostgreSQL
  • Migration of JOX Java source code to Java 8 and later to Java 17 (JOX, Java, Eclipse)
  • Concept and Implementation of a new Archiving – solution for JOX based on Partitioning by Reference – Functionality of Oracle DB (JOX, Oracle Partitioning by reference, Java 8)
  • Concept and Implementation of a new database – independent SQL-Interface for the JOX – Repository (JOX DBMS Descriptor, Java 17, SQL, Oracle, Python)
  • Setup of an Environment and Implementation of a JOX DBMS Descriptor for Snowflake – Database (AWS, Snowflake, Java 17, Python)
  • JOX – 3-rd Level Application Support
Aug 2011 - Jun 2013
1 year 11 months
Zürich, Switzerland

Contractor

UBS AG

  • Third Level support for an AML (Anti Money Laundering) Application—problem analysis, change and release management, solution implementation, testing, packaging (Actimize Fortent, DB2, AIX, Perl, Websphere WAS & MQ, SVN etc.)
  • Setup of the scheduler–controlled batch processing and administration of Engineering, Development and UAT Environments
  • Implementation of an additional alerting configuration interface (Actimize Fortent, Perl, XML, DB2, AIX)
  • Providing solution for the rolling back of the daily, weekly or monthly-batch processing in AML Database
  • Providing authorization concept and solution for the security and compliance of the AML production
  • Providing solution for the data migration of the AML Database to a separated environment
  • Migration of several Oracle-based DWH-Applications from Oracle 10.1/Solaris sparc to Oracle 11.2/Solaris x86
Nov 2004 - Jul 2011
6 years 9 months
Vienna, Austria

Contractor

A1 Telekom Austria

  • Concept, providing technical documentation (DTD) and development of an OLTP-archiving solution for Maxbill (JOX, Oracle, AIX, Perl)
  • Concept and implementation of migration of the billing system Meta, Customer-, Service-data for A1 Telekom Austria AG: Maxbill, Simba, JOX, Oracle, DB2, AIX
  • Functional improving and tuning of the billing system Maxbill in different areas (CSM, Web-services, OS, Billing, Rating, SAP-, DWH-Interface, PLSQL, Oracle, AIX)
  • Concept and development of the Delta-Migration for sync of service data in Simba and Maxbill (Perl, Oracle, AIX)
  • Support of the test department for UAT & EAI/E2E (consulting, concept of test plans, generation of data for test cases, script–implementation, reports, execution of performance- and functional tests for billing, rating, OS, DWH and CM modules, error analysis and error management)
  • Build-, release- and deployment-management
  • Change- & problem management, third level production support for application and database performance tuning (Oracle)
  • Administration of migration- and development-environments (AIX, Oracle, DB2, SVN)
  • Setup, implementation and administration of a distributed SVN Repository
  • Migration of several Oracle-Instances and associated applications from 9.2i to release 11.2g
  • Development of the process automation tool JOX—multithreaded, server- and client-side application to build up performance critical business processes (Java SE, Oracle)
Jan 2002 - Oct 2004
2 years 10 months
Hamburg, Germany

Co-Founder & Head R&D

ex eventu GmbH

  • Development of Business Intelligence components, a mediation device for a project in tariff simulation/revenue assurance area, optimization of data marts (Oracle, Perl, Linux)
  • Project lead and implementation of billing process automation in Amdocs Ensemble area (JOX, Oracle, Solaris, Perl)
  • Implementation of loading processes for Metadata, CARMEN–files for service provider invoice verification, BI (Perl, Shell, Digital UX, Oracle)
  • Several different projects for process automation in telco/BI
  • Several system administration tasks (Unix/Linux, Oracle DBA etc.)
  • Development of the process automation tool JOX (Java, Oracle)
Mar 2001 - Dec 2002
1 year 10 months
Elmshorn, Germany

Contractor

Talkline GmbH

  • Development of the process automation Tool JOX (Java, Oracle)
  • Project lead and implementation of billing process automation in Amdocs Ensemble area (JOX, Oracle, Solaris, Perl)
  • Development of an application for CDR-formatting (Oraperl)
Feb 1998 - Mar 2001
3 years 2 months
Quickborn, Germany

Product manager, System analyst, Software developer

Solution 42 AG (later Portal Software Quickborn)

  • Product management for a UNIX-Batch-processing Scheduler jobManager, development of the corresponding server application in C++
  • Migration of the meta- & account related data of a service provider between two billing systems (JobManager, Informix, Oracle, Perl, Visual Basic)
  • Concept and development of different internal and external critical hardware environments in SUN, HP & Linux areas (Enterprise Server, RAID-Systems etc.)
  • Development and setup of the Unix- and database infrastructure for the company (Oracle, Solaris, Linux, HPUX, IRIX, Digital UX, AIX)
  • Setup of the Datawarehouse-development and production environments (JobManager, Oracle, Solaris, Perl)
  • Production support of multiple telco–Revenue Assurance/Tariff Simulation/DWH-solutions (JobManager, Oracle, Solaris, Perl)
  • Administration, performance analysis and optimizing (Oracle, Solaris)
  • Setup of backup solutions (Oracle, Solaris, Linux)
  • Concept of disaster recovery scenarios (Oracle, Solaris, Linux)
Oct 1996 - Jan 1998
1 year 4 months
Elmshorn, Germany

Billing production operation support

Talkline GmbH

  • Optimizing of the standard processing in the billing production area (Job Maintenance, Oracle, Solaris, Perl)
  • Developed a Job Maintenance Tool for the batch module scheduling and administration in BSCS (BSCS, Solaris, Windows NT, PERL/OraPERL, Gupta/Centura SQLWindows, Oracle 7)
  • Migration/fusion of two BSCS-Systems (Oracle, Job Maintenance, Solaris, Perl, Delphi)
  • Developed a generic database migration tool for Oracle (Oracle, Job Maintenance, Solaris, Perl, Delphi)
  • BSCS-Database performance tuning (Oracle)
  • Developed a Pegasus Mail Enhancement for internal communication (Windows 95, Borland C++ 4.5)
Jan 1996 - Dec 1996
1 year
Hamburg, Germany

Software developer, Project lead

ox Group GmbH

  • Developed a DBMS application (Windows NT, Visual Basic 4.0, MS Access)
Jan 1995 - Dec 1996
2 years
Hamburg, Germany

Software developer

gfs

  • Developed an ODBC-ISAM driver (BS2000, C, ISAM, MS Windows, ODBC)
Jan 1994 - Dec 1995
2 years
Hamburg, Germany

Software developer

Gauss GmbH

  • Developed a DB application (MS Access, MS Visual Basic 3.0, ODBC)
  • Developed a Network Management tool for a bank (SINIX, TCP/IP, BS2000, Shell, C, SCCS, Make etc.)
  • Developed a UNIFACE-DBA driver (SINIX, MS-DOS, BS2000, DBA, UNIFACE, ESQLC, MS Visual C++, Informix, SESAM)
Jan 1990 - Dec 1992
3 years
Moscow, Russian Federation

Software developer

Soyusgasautomatika

  • Migration of an INES DB to dBase (OSES, MS-DOS, INES, Clipper, FoxPro, PL/1)
  • Concepted and implemented a mathematical optimization package (OSES, MS-DOS, Fortran, BASIC, dBase)

Summary

The in-depth knowledge of the Software Development, Testing, System Integration and Production areas. More than 15 years of experience in using of my own Process Automation Tool JOX for support customers in Data Migration, Archiving, Billing, Order Synchronization, Revenue Assurance, ETL and System Management Projects. High level of expertise in Oracle (SQL, PLSQL, DBA), DB2, Informix, Unix, Perl, Java and C allows me to provide rapid solutions and implementations especially for massive data processing.

Skills

Operating Systems

  • Unix-derivates Aix, Solaris/sun Os, Linux, Hp Ux, Osf1, Sinix
  • Mainframe Bs2000
  • Pc Ms-dos, Ms-windows 95, Nt, 2000, Xp, Vista, 7
  • Storage Management Solstice Volume Manager, Veritas Vm

Dbms’s

  • Dba Experience Oracle 7.3 - 11.2 Incl. Ha/rac, Informix, Versant
  • Development Experience Oracle 7.3 – 12, Db2, Postgresql, Cassandra, Informix Se And Online, Ingres, Ms-access, Sesam/sql, Uds/sql, Dbase/foxpro/clipper

Programming

  • Programming Languages C, C++, Esqlc, Proc, Java (J2se, Jdbc, Swing, Gwt), Perl, Basic, Cobol, Fortran, Pascal/delphi, Pl/1, Shell-scripting, Awk, Cygwin Etc.
  • Ddl/dml Sql
  • 4gl & Stored Procedures Plsql, Informix-4gl, Uniface-4gl, Gupta/centura Sqlwindows
  • Markup Html, Css, Xml, Xlst, Json, Rest

Methods And Tools

  • Batch Control Jox, Jobmanager, Jobmaintenance, Tivoli Maestro, Jcl
  • Dbms-tools Toad, Tora, Squirel, Owb (Oracle Warehouse Builder), Odi (Oracle Data Integrator), Sybase Power Designer, Erwin
  • Application Server / Messaging Tomcat, Websphere Was, Websphere Mq
  • Project Management / Qa / Source Control/communication/test Itil V.3 (Foundation Certificate), Agile Development, Bss ( Behavior Driven Development), Ibm/rational Clearquest, Mercury/hp Quality Center, Jira, Git, Gnatz, Junit, Subversion (Svn), Tortoise, Cvs, Sccs, Mks Source Integrity, Ms Source Safe, Citrix, Dns, Ftp, Ftps, Ftam, Net8, Nis, Nfs, Osi, Servicenow, Ssh, Telnet, Vpn Etc.

Industrial Sector Knowlege

  • Telco Mobile And Fixnet Vendors And Service Providers – Billing, Mediation, Datawarehouse, Eai. Standard Solutions: Amdocs Ensemble, Bscs, Cass, Eppix, Integrate, Kubis, Maxbill, Mcbs, Salcus, Spain Etc.
  • Banks It-infrastructure, Aml Actimize Fortent, Dwh, Bbs, Several Interfaces

Languages

Russian
Native
German
Advanced
English
Advanced

Education

Oct 1985 - Jun 1991

Institute of oil and gas Moscow

Computer Science, spec. Process automation systems · Moscow, Russian Federation

Certifications & licenses

ITIL V.3 (Foundation Certificate)

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

Similar Freelancers

Discover other experts with similar qualifications and experience

Anton Klonov
Anton Klonov

Head of Technical Overall Integration NSC / Hadoop Cloud Development

View Profile
Rainer Diekmann
Rainer Diekmann

Enterprise Architecture Management / Software Developer Backend

View Profile
Jens Rehsack
Jens Rehsack

Technical Product Owner

View Profile
Daniel Friedrich
Daniel Friedrich

Senior Delphi / C# Developer

View Profile
Jan Lüders
Jan Lüders

Senior Developer

View Profile
Rolf Gardewischke
Rolf Gardewischke

Developer & Designer

View Profile
Robert Raźniewski
Robert Raźniewski

Software Developer

View Profile
Olaf Taesch
Olaf Taesch

BI Architect in the Kanban Team

View Profile
Rainer Langbehn
Rainer Langbehn

Senior IT Consultant, Senior Software Architect, Senior Software Developer, Senior DevOps Engineer

View Profile
Ulrich Cech
Ulrich Cech

Java Architect/Developer – Freelancer

View Profile
Thomas Jarnot
Thomas Jarnot

Backend Developer, DevOps Engineer

View Profile
Achille Chimi
Achille Chimi

Backend/Frontend Developer

View Profile
Rolf Mainka
Rolf Mainka

Lead Developer and Tester of Domain Applications for the Zensus2021 Project

View Profile
Johannes Erchen
Johannes Erchen

Senior Application Developer

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Knud Werner
Knud Werner

Lead Programmer, Architect and Deputy Product Owner

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile
Michael Pförringer
Michael Pförringer

Setup Azure cloud, Java development, CI/CD pipelines

View Profile
Thorsten Matzner
Thorsten Matzner

Senior Test Engineer for an OpenShift Data and Analytics Platform

View Profile
Thomas Hoefkens
Thomas Hoefkens

Senior MLOps, DevOps Engineer

View Profile
Ralf Scholler
Ralf Scholler

Senior Consultant / Developer

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Oliver Bodemer
Oliver Bodemer

Senior Software Architect

View Profile
Jan Mönnich
Jan Mönnich

Interface project at HR Solutions GmbH for Rhineland-Palatinate / BAMF

View Profile
Dimitri Simon
Dimitri Simon

Fullstack Developer, Integrator

View Profile
Jens Grassel
Jens Grassel

Remote

View Profile
Robin Sadlo
Robin Sadlo

Senior Cloud & Backend Engineer

View Profile
Florian Fladung
Florian Fladung

Senior Backend Developer

View Profile
Christoph Bewerbung
Christoph Bewerbung

Architect, Business Analyst, Developer

View Profile