Skip to main content
Top expert badge
Recommended expert
Profile header background

Ulm Paunel-Freelance IT Specialist

Ulm Paunel - Freelance IT Specialist - profile avatar
Profile header overlay
Steinbach (Taunus), Germany

Check rate

Experience

Feb 2025 - Jun 2025

DataStage ETL Expert

ING Bank

Expertise details
Position Summary
DataStage ETL Expert at ING Bank
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
  • Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
  • Storage of the silver layer on Hadoop and the gold layer in Oracle.
  • Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
  • Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
  • Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
  • Versioning changes in GitHub and deployment via the CI/CD portal.
  • Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
  • Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
  • Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
  • Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
  • Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.
Nov 2024 - Nov 2025
Hanover, Germany

DataStage ETL Expert

KKH Hannover

Expertise details
Position Summary
DataStage ETL Expert at KKH Hannover
Industries
Insurance
Business Areas
Business Intelligence
Information Technology
Quality Assurance
  • Datastage 11.7, Talend 8.3, DB2 zOs, DB2 LUW, Postgres, MongoDB, Redhat 8, AWS (Lambda, Terraform), Git, Shell, Spark/Scala, Python
  • Validation of data mappings to align migration requirements with the current table structure and contents.
  • Building DataStage pipelines on the source system for data migration of inpatient and outpatient rehab topics, partners, legal entities, rehabilitation, and handling claims from abroad.
  • Development of Talend pipelines to move data from S3 into databases as well as from S3 to Spark, in order to share master data with other IT systems, calculate metrics and KPIs, and make them available in Qlik.
  • Reimplementation of large XML data processing as a Spark application based on DataFrames as part of the post-migration, when DataStage was no longer available.
  • Development of shell scripts to integrate the new Spark processes into the existing main execution plan.
  • Enhancement of a Python-based gateway for quality and integrity checks of migrated data on S3.
  • Deployment of the Python functionality as a Lambda using Terraform scripts.
  • Participation in the agile process, including creating user stories, estimations, and planning.
  • Handling JIRA tickets, maintaining the Confluence documentation, and synchronizing JIRA tickets with the respective job versions.
Apr 2020 - Jul 2024
Frankfurt, Germany

Expert in Data Modeling, ETL, and API Development

Deutsche Bundesbank

Expertise details
Position Summary
Expert in Data Modeling, ETL, and API Development at Deutsche Bundesbank
Industries
Government and Administration
Business Areas
Business Intelligence
Information Technology
  • Datastage 11.7, IBM MQ Series, Kafka, DB2 zOs 12, Oracle 19.1, SVN, Git, Confluence, Jira, Power Designer, C++, Python, Cobol, JCL, CICS, Tivoli TWS, TSO/ISPF, Java, Spring Boot, Apache Camel, VS Code, GoLang, Redhat Linux 7.6-8, Azure SQL Database, Azure Data Factory (SSIS in Azure), PowerBI
  • Development of DataStage pipelines for loading the core warehouse layer, business vault, and enterprise layer.
  • Development of C++ extension routines for DataStage as well as Bash and Python scripts for deployment between environments.
  • Addition of DataStage sequences within the Tivoli TWS orchestration.
  • Design and extension of a REST-based RTGS API (Real-Time Gross Settlement) in Go to provide KPI and payment transaction information.
  • Development of Apache Camel routes based on Spring Boot for secure transfer of JSON files.
  • Maintaining and extending the logical and physical data model (PDM) using PowerDesigner, including automating SQL generation.
  • Publishing data to Azure SQL DB and transferring it to Azure Data Lake for further processing by Data Factory.
  • Using Pandas (Python) to clean data before integration.
  • Development of PowerBI dashboards to display payment processing KPIs using DAX.
  • Connecting Power BI to the business vault layer of a data vault–based data warehouse.
  • Development, debugging, and execution of VSAM data migration into DB2 tables using COBOL, CICS, and JCL.
  • Further development of the business vault data model and ETL pipelines to provide dashboard data.
  • Execution of incident, problem, and change management processes according to ITIL guidelines for the Target2 data warehouse.
Oct 2019 - Aug 2022
Karlsruhe, Germany

Expert in ETL, database modeling and development

L-Bank

Expertise details
Position Summary
Expert in ETL, database modeling and development at L-Bank
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Talend 7.3, Java 11, SAP Hana, Informix, Oracle 19, SQL Server, Postgres, REST, Spring Boot, SVN, Git, Jenkins, Ansible, Python, Docker, Prometheus, Grafana, Confluence, Jira, Redhat 8
  • Analysis of business department requirements and interfaces of various software modules.
  • Integration of interfaces and the central data model.
  • Migration of an old JSF/Spring document management system to a new Python/Django-based GUI.
  • Development and testing of queue-based approval process modules.
  • Provision of test data, execution of tests, and defect handling.
  • Development of Talend pipelines to migrate documents and reports into the target DMS.
  • Transfer of data between Informix, Oracle, and SAP Hana databases.
  • Implementation of microservices for data propagation to the new frontend.
  • Design and implementation of Talend jobs for monthly anonymized processing of claim order data sets.
  • Definition of processes in Confluence and maintenance of JIRA tickets.
  • Development of Jenkins scripts for deploying artifacts to Nexus and target environments.
  • Development of scripts to execute Talend pipelines and UC4 scripts for shell script control.
Oct 2018 - Sep 2019
Karlsruhe, Germany

ETL Expert

Atruvia (Fiducia)

Expertise details
Position Summary
ETL Expert at Atruvia (Fiducia)
Industries
Banking and Finance
Information Technology
Business Areas
Business Intelligence
Information Technology
  • Datastage 11.5, C, Redhat Linux, AWS (S3, Snowflake, Databricks, Lambda, Airflow, Terraform, Quicksight, GitLab), DB2 zOs 12.0, SQL Server, Python, Cobol, TSO/ISPF, JCL, CICS, Oracle, Navicat Data Modeler
  • Validation checks and further development of technical concepts and data mappings.
  • Reverse engineering of COBOL programs to identify query and aggregation logic for report data generation.
  • Creation of logical and physical data models based on a star schema for the reporting module in Snowflake.
  • Analysis of flat files and DB2 data sources and definition of dimension and fact tables.
  • Manipulation of data in Snowflake using Snowpark DataFrames.
  • Creation of PDF reports with ReportLab in AWS Lambda and storage on S3.
  • Definition and deployment of Lambda functions with Terraform and orchestration via AWS Step Functions and EventBridge.
  • Building DataStage pipelines for savings, loan, and payment processing as well as controlling topics (FATCA, CRS).
  • Creation of complex SQL queries, functions, and procedures for Snowflake on AWS.
  • Development of shell scripts to automate administrative tasks such as versioning and deployment.
Mar 2018 - Sep 2018
Heilbronn, Germany

Database Modeling, Development and Talend Expert

Intersport AG

Expertise details
Position Summary
Database Modeling, Development and Talend Expert at Intersport AG
Industries
Retail
Sport
Business Areas
Business Intelligence
Information Technology
  • Talend 6.5.1 / 4.2, SVN, Java, Maven, PowerShell, Elasticsearch, Spring Boot, Mulesoft ESB, Windows 10, Exasol 6.0 / 4.0, MSSQL Server 2017, SAP Hana 4, SAP BW 7.0
  • Analyze business requirements and integrate them into a central data model.
  • Reverse-engineer data models from SQL Server and PostgreSQL and adapt them for Exasol.
  • Migrate and enhance Talend jobs for sales, orders and controlling.
  • Develop and optimize T-SQL views, functions and procedures on SQL Server.
  • Develop ETL processes to transfer order data between SAP BW and Exasol and load Elasticsearch indexes.
  • Develop Maven scripts for continuous integration of generated Java artifacts.
  • Automate administrative tasks and provide test data using PowerShell scripts.
  • Implement sales data transfer to recommendation services via REST/JSON APIs using Mulesoft ESB.
  • Design a solution for data transfer to the web shop via web services with Java and Spring Boot.
Oct 2017 - Mar 2018
Frankfurt, Germany

Data Warehouse and Talend Expert

DB Energie AG

Expertise details
Position Summary
Data Warehouse and Talend Expert at DB Energie AG
Industries
Energy
Business Areas
Business Intelligence
Information Technology
  • Amazon AWS (Redshift, DynamoDB, Lambda, Glue, S3), Teradata, SQL Server 2016, Talend 6.2, Java, Tableau 10.4, Python, Git
  • Develop Talend jobs for controlling and marketing.
  • Migrate Teradata BTEQ scripts to Talend.
  • Enhance existing BTEQ loading scripts.
  • Develop Python scripts for test data provisioning and result evaluation.
  • Create JIRA stories to populate specific warehouse layers following Data Vault 2.0 principles.
  • Develop business views and Tableau dashboards for KPI visualization.
Jul 2017 - Sep 2017
Frankfurt, Germany

ETL Expert

Bausparkasse – Deutsche Bank AG

Expertise details
Position Summary
ETL Expert at Bausparkasse – Deutsche Bank AG
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • MS SQL 2016, SSIS, SSAS, SSRS, Git
  • Develop SSIS packages to load Data Vault 2.0 satellite, hub and link tables.
  • Develop test cases for technical and functional validation of SSIS jobs.
  • Develop point-in-time tables for quick KPI access.
  • Create materialization scripts to optimize queries before SSRS report execution.
  • Support test and rollout phases.
  • Develop shell scripts to automate administrative tasks and provide test data.
Apr 2017 - Sep 2017
Hanover, Germany

DB2, Java and Talend Expert

VHV Versicherungen

Expertise details
Position Summary
DB2, Java and Talend Expert at VHV Versicherungen
Industries
Insurance
Business Areas
Information Technology
Quality Assurance
  • Talend 5.4, Java, Scala, DB2 LUW 10.1/10.5, Redhat Enterprise 6.6, LDAP
  • Enhance Talend jobs to anonymize personal data.
  • Enhance the data-at-rest authorization concept on DB2 using LDAP groups.
  • Create test cases using HPQC and support the production rollout.
  • Enhance a Spring Boot-based Java application for claims and entitlement APIs.
  • Implement REST-based microservices for the portfolio project.
  • Develop and test jobs to derive domain data from customer interactions in a Data Vault model.
Jan 2017 - Mar 2017
Bonn, Germany

Oracle, Linux and UC4 Expert

Postbank AG

Expertise details
Position Summary
Oracle, Linux and UC4 Expert at Postbank AG
Industries
Banking and Finance
Business Areas
Information Technology
Operations
  • JBoss/Tomcat, UC4, Bash, Oracle 12c, Nagios, Solaris 11.3, Redhat Enterprise 6.6
  • Enhance UC4 workflows for file transfers and related shell scripts.
  • Monitor UC4 job processes, analyze errors and deploy fixes.
  • Process orders for hardware, software and activations.
  • Install and adjust security settings for UC4 and UC4 agents.
Apr 2016 - Dec 2016

Oracle, PowerCenter and XML Expert

Sopra Steria

Expertise details
Position Summary
Oracle, PowerCenter and XML Expert at Sopra Steria
Industries
Information Technology
Government and Administration
Business Areas
Information Technology
Quality Assurance
  • XML, XSLT, XPath, Oracle 12c, Oracle Data Integrator 12, Solaris, KSH, UC4, Enterprise Architect
  • Development of Oracle queries and PL/SQL packages.
  • Development of ODI workflows, KSH scripts and UC4 jobs to load a reporting data mart.
  • Monitoring of UC4 processes, error analysis and defect management using HPQC.
  • Documentation of database changes with Enterprise Architect.
  • Generation of CRS reports in XML format for the Federal Tax Office.
May 2015 - Mar 2016
Bonn, Germany

DWH Packet Warehouse Support

Sopra Steria

Expertise details
Position Summary
DWH Packet Warehouse Support at Sopra Steria
Industries
Transportation
Business Areas
Business Intelligence
Information Technology
  • WebSphere MQ 7.5, Oracle 11g, Teradata 14.1, MS SQL 2012, Talend 5.6.1, PowerCenter 9.6, Business Objects, PHP 5, Red Hat Linux 6.6, Nagios, Control-M, Shell (Bash), SVN
  • Design and development of ETL pipelines using Talend for loading, historization and data aggregation of new products (DHL parcel lockers).
  • Maintenance and further development of existing Informatica PowerCenter workflows.
  • Planning and execution of load and performance tests for up to 3000 XML messages per second.
  • Development of shell scripts to monitor queues and storage during LUP tests.
  • Development of BTEQ and shell scripts to cleanse large customer data.
  • Loading data from REST queries (JSON) from warehouses and parcel lockers.
  • Adjustment of about 40 reports in PHP and PDF.
  • Development of RPMs to automate deployments.
Jan 2015 - Apr 2015

OSPlus Financial Warehouse Support

Finanz Informatik – Solutions Plus

Expertise details
Position Summary
OSPlus Financial Warehouse Support at Finanz Informatik – Solutions Plus
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Oracle 11g, Postgres EnterpriseDB, Gupta SQL, Talend Data Integration 5.5.1, Talend Big Data 5.6, Jasper Reports 5.6/6.0, Ubuntu Linux 14.04, Bash, SVN, Git
  • Design and development of ETL pipelines for loading and historization of new products into the warehouse.
  • Automation of processes through shell scripts and job exports.
  • Development of deployment scripts for the Talend Administration Center.
  • Handling JIRA tickets for ETL pipelines and reports.
  • Upgrade of the Talend Data Integration Server and installation of Talend Big Data and Cloudera.
  • Development of ETL pipelines using tSpark components with Spark-enabled clusters.
  • Upgrade of Jasper Reports from version 5.6 to 6.0.
Oct 2013 - Dec 2014
Germany

Release and Product Management Support

DFV – Deutsche Familien Versicherung

Expertise details
Position Summary
Release and Product Management Support at DFV – Deutsche Familien Versicherung
Industries
Insurance
Business Areas
Information Technology
Product Development
  • vSphere v5.1, Windows Server 2008, MS SQL Server 2012, DB2 LUW 9.6, SSIS, SSAS, SSRS, Red Hat 6.6, PowerDesigner 16, SVN
  • Installation and maintenance of SQL Server 2012 environments.
  • Development of SSIS-based data migration pipelines and PowerShell scripts.
  • Execution of the migration and development of repair scripts.
  • Design and development of a column-oriented reporting database (ODS) using PowerDesigner.
  • Migration and further development of operational reports from Cognos to a Microsoft BI architecture.
  • Building an SSAS tabular model as a semantic layer with DAX measures.
  • Development of scripts for job execution and log analysis.
Feb 2013 - Sep 2013
Germany

Oracle and JBoss Expert

DER Touristik

Expertise details
Position Summary
Oracle and JBoss Expert at DER Touristik
Industries
Tourism
Business Areas
Business Intelligence
Information Technology
  • WebLogic 10.3.9, MongoDB, Elasticsearch, HTML/CSS/JavaScript, Oracle 11gR2, PL/SQL, SQL Developer, Gupta SQL, Spring, Eclipse, Tibco EMS, JUnit, Oracle Enterprise Linux 6.1, Informatica PowerCenter, Nagios
  • Definition and further development of interfaces between the tourism application and SAP financial accounting.
  • Development of a PowerCenter-based solution to handle changes in travel contracts.
  • Performance optimization by moving hotel search from Oracle to MongoDB.
  • Development of shell and Perl scripts to automate the PowerCenter rollout.
  • Storage and loading of test data for different scenarios using PowerCenter.
Jun 2012 - Feb 2013
Germany

Expert in Data Modeling and ETL Processes

SEB Bank

Expertise details
Position Summary
Expert in Data Modeling and ETL Processes at SEB Bank
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Bash, Perl, DB2 LUW 8.5, MS SQL 2008, MySQL, Oracle 11, PL/SQL, Toad Data Modeler 4.1, PowerDesigner 16, Java, PowerCenter 8.6/9.1, Talend Open Studio, Red Hat Enterprise 5.4
  • Support for PowerCenter workflows for account creation and customer data.
  • Performance optimization using indexes, statistics, and materialized views.
  • Extraction and archiving of retail customer data in GDPdU format.
  • Building a MySQL data warehouse in a Linux environment using Talend.
  • Ensuring extraction quality by loading into IDEA applications.
  • Designing and implementing separation ETL workflows in PowerCenter for data partitioning.
  • Executing separation jobs and preparing data deliveries according to Ministry of Finance requirements.
Jun 2011 - Jun 2012
Germany

Database Expert

HRS

Expertise details
Position Summary
Database Expert at HRS
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
  • JBoss 4.2 / 7.1, Spring, Maven, HTML/CSS/JavaScript, IBM DB2 LUW 9.5, Postgres, PostGIS, Nagios, MS SQL Server 2005, Pentaho Kettle
  • Tuning and enhancing SQL queries to improve performance.
  • Replacing Hibernate-generated queries with optimized DB2 queries.
  • Developing DB2 scripts for maintenance and test data provisioning.
  • Liaison for projects developed in Russia (handling change requests in JIRA).
  • Converting C++ and shell-based loading workflows into Pentaho workflows.
  • Creating ETL jobs with Pentaho Kettle to extract data from DB2 to MS SQL for reporting.
Jun 2009 - May 2011
Germany

Expert in DataStage, Oracle, and XML

IBM Germany

Expertise details
Position Summary
Expert in DataStage, Oracle, and XML at IBM Germany
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
  • XML, XSLT, XPath, Oracle 10g, PL/SQL, DB2 LUW 8.1, Cobol, JCL, CICS, Connect Direct, BMC, Tivoli TWS, Sybase IQ, IBM WebSphere MQ 6.0, DataStage 8.1
  • Maintaining DB2, WebSphere MQ, and DataStage across multiple environments and instances.
  • Implementing security concepts and developing scripts.
  • Developing Oracle packages to process XML strings via SOAP.
  • Creating ETL jobs to back up and restore data snapshots.
  • Orchestrating DataStage load processes using Tivoli TWS.
  • Enriching customer data with portfolio data from Sybase IQ.
  • Writing shell scripts for software distribution and component automation.
Jun 2008 - Apr 2009
Germany

Expert in WebLogic, MS SQL, XML, and Java/J2EE

Amadeus Germany

Expertise details
Position Summary
Expert in WebLogic, MS SQL, XML, and Java/J2EE at Amadeus Germany
Industries
Tourism
Business Areas
Information Technology
Product Development
  • JBoss 4.0x, WebLogic 10, XML, XSLT, XPath, Talend 4.x, Oracle 10g, JSP, Struts2, HTML/CSS/JavaScript, IBM WebSphere MQ 6.0, MS SQL 2005
  • Documenting XML interfaces for data exchange according to the OTA data model.
  • Developing a WSDL/SOAP-based interface for communication between CRM and front office.
  • Implementing data persistence for various components.
  • Implementing interfaces with airline and tour operator systems.
  • Creating Talend ETL jobs to provide test data.
Jun 2007 - May 2008
Germany

Front Office Intranet Application Developer

Europäische Zentralbank

Expertise details
Position Summary
Front Office Intranet Application Developer at Europäische Zentralbank
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Solaris, Tomcat, XML, XSLT, XPath, HTML/CSS/JavaScript, Oracle 10g, PL/SQL, Jasper Reports, Aptech Gauss Engine
  • Implementing PL/SQL packages to prepare data for reports.
  • Documenting XML interfaces between national central banks and the ECB.
  • Developing a software layer for data integration into staging tables.
  • Visualising data from the Aptech Gauss Engine.
  • Developing reports using Jasper Reports.
Jun 2006 - May 2007
Germany

Expert in JBoss, Oracle, XML and Java/J2EE

Amadeus Germany

Expertise details
Position Summary
Expert in JBoss, Oracle, XML and Java/J2EE at Amadeus Germany
Industries
Tourism
Business Areas
Information Technology
Product Development
  • JBoss 4.0x, XML, XSLT, XPath, HTML/CSS/JavaScript, Oracle 10g, JSP, Struts, IBM WebSphere MQ 6.0
  • Documentation of XML interfaces for the Amadeus search engine.
  • Development of a WSDL/SOAP-based interface for capturing travel offers.
  • Implementation of data persistence.
  • Development of a lifecycle mechanism for offer updates.
  • Development of transformations from the OTA format to internal XML representations, including performance optimization.
  • Development of an MQ-based interface for interacting with the portal.
  • Creation of a JSP-based admin console for tour operators.
Oct 2005 - May 2006
Germany

Expert in Oracle, JBoss, and Informatica PowerCenter

Lufthansa Systems AG

Expertise details
Position Summary
Expert in Oracle, JBoss, and Informatica PowerCenter at Lufthansa Systems AG
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
  • HP-UX, Oracle 9i, PL/SQL, Tibco Data Exchange, Toad, XML, XSLT, JBoss, Struts, Microstrategy 8
  • Design and implementation of transformations for the data warehouse.
  • Extension of a snowflake data model for capacity and revenue planning.
  • Development of shell scripts to fetch PowerCenter workflows from version control systems.
  • Implementation of AutoSys scheduling to reduce manual interventions.
  • Development of ETL workflows for payment reports in Microstrategy.
Oct 2004 - Jan 2005

Data migration consultant

Moore Wallace

Expertise details
Position Summary
Data migration consultant at Moore Wallace
Industries
Information Technology
Business Areas
Information Technology
  • Solaris, Sybase, Oracle, Java, Perl, Shell
  • Consulting and development in data migration from Sybase to Oracle in a Solaris environment.
Feb 2004 - Sep 2005
Canada

Integration consultant

Aviva Canada

Expertise details
Position Summary
Integration consultant at Aviva Canada
Industries
Insurance
Business Areas
Business Intelligence
Information Technology
  • Linux, Eclipse, JBoss, WebSphere 5.1, IBM WebSphere MQ, XML, PostgreSQL, Oracle, PL/SQL, OpenLDAP, PowerCenter 7.1, Perl, Shell
  • Documentation of data exchange between mainframe, Oracle Financials, DB2, and the Netezza warehouse.
  • Use of WebSphere MQ and JBoss JMS for XML-based business events according to the OAGIS 8.1 standard.
  • Development of requirement specifications with use cases and interaction diagrams.
  • Development of Java/MQ processes for storing mainframe information in staging tables.
  • Design and development of PowerCenter ETL workflows for loading Netezza tables.
May 2003 - Oct 2003

Financial reporting subsystem consultant

Swiss Re Global Development Services

Expertise details
Position Summary
Financial reporting subsystem consultant at Swiss Re Global Development Services
Industries
Insurance
Business Areas
Business Intelligence
Finance
Information Technology
  • Solaris, Oracle 9i, JReport, WebSphere 5.1, Eclipse, CVS, Rational Rose, Business Objects
  • Consulting and development of a financial reporting subsystem.
  • Conducting business process analysis and documentation.
Mar 2002 - Apr 2003

Developer and Integrator for Data Mining

The Monitoring Company

Expertise details
Position Summary
Developer and Integrator for Data Mining at The Monitoring Company
Industries
Professional Services
Business Areas
Business Intelligence
Information Technology
Research and Development
  • Java, WebLogic, XML, Sybase, Oracle, MS SQL
  • Worked on trademark and patent data mining.
Oct 2000 - Mar 2002
Canada

Architect / Senior Developer

Entertainment Partners Canada

Expertise details
Position Summary
Architect / Senior Developer at Entertainment Partners Canada
Industries
Media and Entertainment
Business Areas
Information Technology
Product Development
  • Java (Swing, J2EE), XML, XSLT, IBM WebSphere 4, IBM DB2 7.2, Mac OS X, Linux
  • Implemented cross-platform Java Swing-based scheduling applications for film production.
  • Developed the Movie Magic Scheduler as a standalone application with XML data synchronization.
  • Applied the RUP development process.
Nov 1999 - Oct 2000
Canada

Application Integrator

BCE Emergis, Assure Health Group

Expertise details
Position Summary
Application Integrator at BCE Emergis, Assure Health Group
Industries
Healthcare
Business Areas
Information Technology
Quality Assurance
  • Solaris, Oracle, Java, WebLogic, HL7
  • Integrated the eFilm application with Cerner HMS.
  • Prepared the product for ONC certification.
Nov 1998 - Oct 1999
Toronto, Canada

Developer Team Support

Merge Technologies

Expertise details
Position Summary
Developer Team Support at Merge Technologies
Industries
Healthcare
Information Technology
Business Areas
Information Technology
Product Development
  • Solaris, MS SQL 6.5, Java, C++, HL7
  • Implemented a workflow management system with reporting for radiology.
  • Implemented the solution at the pilot customer Mount Sinai Hospital in Toronto.
May 1998 - Oct 1998
Canada

Banking and Financial Solutions Consultant

IBM Canada

Expertise details
Position Summary
Banking and Financial Solutions Consultant at IBM Canada
Industries
Banking and Finance
Insurance
Business Areas
Information Technology
Product Development
  • Consulted during the design and implementation phase of a thin client PoS for the banking and insurance industry.
May 1997 - May 1998
Canada

Rating System Consultant

Chubb Insurance Company of Canada

Expertise details
Position Summary
Rating System Consultant at Chubb Insurance Company of Canada
Industries
Insurance
Business Areas
Information Technology
Product Development
  • Consulting during the design and implementation phase of a system for rating private policyholders.
Jan 1997 - Dec 2025

Founder

Netup Communications

Expertise details
Position Summary
Founder at Netup Communications
Industries
Information Technology
Telecommunication
Business Areas
Information Technology
  • Founded Netup Communications.
  • Carried out various fixed-term contracts and projects as a freelance consultant.
Jul 1996 - May 1997

PowerBuilder/Sybase Solutions Consultant

Deloitte & Touche Consulting Group

Expertise details
Position Summary
PowerBuilder/Sybase Solutions Consultant at Deloitte & Touche Consulting Group
Industries
Information Technology
Professional Services
Business Areas
Information Technology
  • Improved a PowerBuilder/Sybase solution for secure remote work over WANs using IBM DCE.
Sep 1995 - Jul 1996

GIS Application Developer

SHL Systemhouse

Expertise details
Position Summary
GIS Application Developer at SHL Systemhouse
Industries
Information Technology
Business Areas
Information Technology
Product Development
  • Developed applications using PowerBuilder and Oracle.
  • Handled hardware and software integration and deployment for GIS.
Nov 1994 - Sep 1995
Toronto, Canada

Software Developer

Delrina Corporation

Expertise details
Position Summary
Software Developer at Delrina Corporation
Industries
Information Technology
Business Areas
Information Technology
Product Development
  • Developed software as part of an international team.
Jan 1994 - Dec 1994
Hamilton, Canada

Clinical Procedure Developer

McMaster University, Hamilton

Expertise details
Position Summary
Clinical Procedure Developer at McMaster University, Hamilton
Industries
Healthcare
Business Areas
Information Technology
Product Development
  • Developed clinical procedures using C, Motif, and SunOS.

Industry Experience

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

Experienced in Information Technology, Telecommunication, Banking and Finance, Insurance, Government and Administration, and Healthcare.

Information Technology
Telecommunication
Banking and Finance
Insurance
Government and Administration
Healthcare
Profile match chart

Business Area Experience

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

Experienced in Information Technology, Business Intelligence, Product Development, Quality Assurance, Research and Development, and Finance.

Information Technology
Business Intelligence
Product Development
Quality Assurance
Research and Development
Finance
Profile match chart

Summary

Mr. Paunel is an ETL & Database Specialist with more than 20 years’ systems engineering experience, working heavily within banking, insurance, and consulting businesses, with actual focus on ETL, database and integration projects. In early 2000 he worked on multiple Java development and integration projects

He has been registered in Germany as a Freelance IT Specialist (Freiberufler) since 2005 and has participated in many production rollout projects, where he took over challenges related to database performance and optimization, in environments where ETL pipelines interact with Oracle, db2, MS SQL, Postgres, MySQL databases. His experience with migration projects has enabled him to enhance his ETL skills and develop and expertise with the following tools: Talend, Datastage, SSIS and Azure Data Factory.

Skills

  • Industries: Banks: Ecb, Deutsche Bundesbank, Commerzbank, Seb Bank, Deutschebank, Postbank, L-bank, Ing; It Consulting: Fiducia, Sopra-steria, Finanz Informatik Solutions Plus, Ibm Global Solutions, Lufthansa Systems, Deloitte & Touche, Bce Emergis; It Companies: Symantec/delrina; Insurance: Kkh, Vhv, Da Direkt, Helvetia Versicherungen, Dfv-deutsche Familien Versicherung, Aviva Canada, Assure Health, Chubb Insurance, Swiss Re; Tour Operators: Der Touristik, Hrs, Amadeus; Logistics: Dhl, Intersport, Lufthansa Cargo

  • Databases: Oracle (11j), Ibm Db2 (8j), Sybase (4j), Ms-sql Server (2000-2022, Including Ssis, Ssrs, Ssas – 5j), Mongodb, Postgres, Sybase As And Iq, Mysql, Exasol

  • Etl: Datastage (8.1, 11.7 – 8 Y), Talend (V4, 8.3 – 6 Y), Pentaho (4.1-9.0), Dbt, Informatica Powercenter (V7.1-9.6), Ssis Including Azure Data Factory

  • Bi/reporting: Qlik, Tableau, Powerbi, Business Objects, Jreport, Cognos Analytics (V8, V11), Microstrategy (V8, V9, V10.1)

  • Tools: Quest Toad, Spotlight For Oracle, Dbartisan, Powerdesigner, Erwin, Redgate For Ms Sql

  • Programming Languages: Java (14 Y), Python (4 Y), Xml Technologies (6j), C/c++ (2 Y), Powerbuilder (3j), Scripting Languages (Php, Perl, Bash, Ksh, Powershell)

  • J2ee Technologies: Servlets/jsf, Hibernate, Swing, Jms, Jmx, Web Services

  • Application Servers: Ibm Websphere (3j), Weblogic (2j), Apache/tomcat, Mq Series 5-8.5, Jboss (5j – Certified Consultant)

  • Operating Systems/cloud: Windows, Linux (Ubuntu, Redhat), Aws (S3, Glue), Azure (Adlsv2, Azure Sql Database, Data Factory, Terraform), Aix 5.3, Solaris, Osx

  • Ooa/ood: Rup, Uml (Magicdraw, Rational Rose, Together J)

  • Web: Jsp/servlets, Struts, Jsf, Javascript, Html, Css

  • Other: Ant, Maven 3, Active Directory, Liquibase, Cvs, Svn, Git, Jenkins, Docker, Ansys, Jprofiler, Openldap, Soapui, Postman

Languages

Romanian
Native
German
Advanced
English
Advanced
French
Advanced

Education

Oct 1985 - Jun 1990

University of Bucharest

Master’s, focus on measurement and control technology · Applied Physics · Bucharest, Romania

Certifications & licenses

JBoss Certified Consultant

Statistics

Experience

Total positions 36
Experience in Information Technology 31 y
Avg length 1 y 9 m
Longest experience 28 y 11 m

Global Experience

Countries worked in 2 (Germany, Canada)
Primary country Germany

Expertise

Recent roles DataStage ETL Expert, Expert in Data Modeling, ETL, and API Development, Expert in ETL, database modeling and development
Main industries Information Technology, Telecommunication, Banking and Finance
Main business areas Information Technology, Business Intelligence, Product Development

Qualifications

Highest degree Master
Certifications earned 1

Profile

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

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Ulm based?

Ulm is based in Steinbach (Taunus), Germany.

What languages does Ulm speak?

Ulm speaks the following languages: Romanian (Native), German (Advanced), English (Advanced), French (Advanced).

How many years of experience does Ulm have?

Ulm has at least 32 years of experience. During this time, Ulm has worked in at least 34 different roles and for 34 different companies. The average length of individual experience is 1 year and 11 months. Note that Ulm may not have shared all experience and actually has more experience.

What roles would Ulm be best suited for?

Based on recent experience, Ulm would be well-suited for roles such as: DataStage ETL Expert, Expert in Data Modeling, ETL, and API Development, Expert in ETL, database modeling and development.

What is Ulm's latest experience?

Ulm's most recent position is DataStage ETL Expert at ING Bank.

What companies has Ulm worked for in recent years?

In recent years, Ulm has worked for ING Bank, KKH Hannover, Deutsche Bundesbank, L-Bank, and Netup Communications.

Which industries is Ulm most experienced in?

Ulm is most experienced in industries like Information Technology, Telecommunication, and Banking and Finance. Ulm also has some experience in Insurance, Government and Administration, and Healthcare.

Which business areas is Ulm most experienced in?

Ulm is most experienced in business areas like Information Technology, Business Intelligence, and Product Development. Ulm also has some experience in Quality Assurance, Research and Development, and Finance.

Which industries has Ulm worked in recently?

Ulm has recently worked in industries like Information Technology, Telecommunication, and Government and Administration.

Which business areas has Ulm worked in recently?

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

What is Ulm's education?

Ulm holds a Master in Applied Physics from University of Bucharest.

Does Ulm have any certificates?

Ulm has 1 certificate: JBoss Certified Consultant.

What is the availability of Ulm?

Ulm will be available full-time from April 2026.

What is the rate of Ulm?

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

How to hire Ulm?

To hire Ulm, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Rate comparison chart
Market avg: 872-1032 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.