Alex O. - Freelance Work

Go to Website

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

8 years 8 months

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 the 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 3 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, etc., 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 (until end of 2003). (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

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 Maintainance Tool for the batch module scheduling and administration in BSCS (BSCS,Solaris, Windows NT, PERL/OraPERL (embedded SQL), 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 math. optimization package (OSES, MS- DOS,FORTRAN, BASIC, Dbase)

Summary

I have extensive knowledge in process automation, business analysis, software development, testing, system and application integration. I have over 10 years of experience using my self-developed Process Automation Tool JOX for various projects in the following key categories: Data Management, Billing (e.g. billing and rating), Order Management, ETL, System Management, Migration, Business Intelligence and Revenue Assurance. My database expertise (data modeling, SQL, PL/SQL, DBA, partitioning, performance tuning), Unix, Perl, Java and C allow me to find and implement fast and effective solutions in complex environments. Performance-critical mass data processing is my specialty.