people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontakt

Kontakt

people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Mo-Fr 9.oo - 17.oo Uhr
+49 (89) 55 29 39 -40

Kontaktdaten anfordern


Freelancerprofil: -0631822

DB-Entwickler Oracle, ETL/DWH, e-Commerce, Perl, Python, SQL, BI, Qlikview, MySQL, XML

Position:
IT Datenbankentwicklung
Software-Entwicklung / Programmierung
Projekte im Werdegang
01/2016 - MS Sharepoint Portal Server
MS SharePoint 4 Expert

01/2016 - QlikView
Qlikview 3 Senior Solution Years of hands-on Months Year when Experience evaluation (junior) experience of hands-on used last time senior, expert, professional Senior

01/2016 - ODI 2 Senior Talend 4 2016 Senior Senior

11/2015 - 12/2015 ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, Oracle, Oracle, XML
ETL designer ETL - OBIEE, DB - Oracle SQL, Oracle PL/SQL OBIEE installation (OBIEE) Data sources mappings scripting (OBIEE) Conversion of reporting templates from Oracle reports to Oracle BI XML Publisher Freelancing technical consultant,Obiee consultant for construction management reporting DW

11/2015 - ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, ETL - Extract/Transform/Load, Changemanagement, Python, Oracle
Freelancing technical consultant, investment commission calculation system project for renowned Swiss bank Nowadays ETL - Talend, DB - Oracle SQL, Oracle PL/SQL Requirements collection ETL jobs design (funds transactions management) Change management work Automated test cases design (Python) Performance engineering (Oracle 11G - slow query logging, performance testing) Freelancing technical consultant

05/2015 - 12/2015 ETL - Extract/Transform/Load, SQL, Oracle, PL/SQL, Python, Oracle, Oracle, PL/SQL, ETL - Extract/Transform/Load, ETL - Extract/Transform/Load, Python
ETL job design for project costs DW ETL designer ETL - Talend, DB - SQL, Oracle PL/SQL Data mappings design (Talend) Data transformation scripting (Python) Staging area design (Oracle DDL, Oracle PL/SQL) ETL job design (Talend) ETL job performance testing (Python) Freelancing technical consultant

01/2015 - Mercury WinRunner/QualityCenter
HP Quality Center 4 Expert WinCVS 4 2015 Expert Expert

01/2015 - IBM 2 Scripting Expert

01/2014 - Oracle, SQL
Oracle SQL 7 Loader Expert

11/2013 - 06/2014 ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, Oracle, Oracle, PL/SQL, Oracle, ETL - Extract/Transform/Load, Oracle, SQL, Unix Allgemein, ETL - Extract/Transform/Load
IngoNord Insurance Co (Helsinki, Finland, www . ingonord .com) ETL - ODI , DB - Oracle SQL, Oracle PL/SQL Oracle DW implementation for claim reporting Data mappings design (ODI) Data aggregation logic (Oracle PL/SQL) Staging area design (ERWin, Oracle DDL) ETL job design (production DB --> DW) (ODI) Data loading scripting (Oracle SQL Loader, UNIX environment to set Cron jobs) ETL performance testing Technical consultant

01/2013 - Oracle
Solution Years of hands-on Months Year when Experience evaluation (junior, experience of hands-on used last senior, expert, professional) experience time Oracle Warehouse Builder 2 Senior junior

12/2011 - 10/2015 IT-Beratung/ IT-Support, ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, Perl, Python, Oracle, Oracle Forms, Oracle, Oracle, Oracle, SQL
ETL - OBIEE , DB - Oracle SQL, Oracle PL/SQL, SCRIPT - Perl, Python Front-end technical specifications definition and insurance app modules development (technology - Oracle) 10,11, Oracle Forms and Oracle Reports, activities - designing, reviewing, coding, fine-tuning Back-end technical specifications definition and insurance app packages development (technology - Oracle 10,11, activities - designing, reviewing, coding, fine-tuning) Database performance management (technology - Oracle 10,11; activities - cost metrics definition, allocating degrading SQL queries, batch jobs review for performance leaks) Internal consultancy inside distributed development team (methodology - Waterfall with prototyping, teams - Helsinki, Tallinn, Vilnius, Bangalore, activities - capturing best development practices, coaching off-shore teams) IT consultant

11/2011 - 10/2013 ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, Oracle, Oracle, PL/SQL, Oracle, ETL - Extract/Transform/Load, Oracle, SQL, Unix Allgemein, ETL - Extract/Transform/Load
IngoNord Insurance Co (Helsinki, Finland, www . ingonord .com) ETL - ODI , DB - Oracle SQL, Oracle PL/SQL Oracle DW implementation for claim reporting Data mappings design (IBM Datastage) Data aggregation logic (Oracle PL/SQL) Staging area design (IBM Datastage, Oracle DDL) ETL job design (IBM Datastage) Data loading scripting (Oracle SQL Loader, UNIX environment to set Cron jobs) ETL performance testing (IBM Datastage) Technical consultant

10/2011 - 12/2011 Wirtschaftsprüfung
Exigen Services Co (St. Petersburg, Russia, www . exigenservices .ru) Pre-study and definition of customer business case for international insurer (methodology - Agile, teams) San Francisco, Toronto, Riga, Vilnius, St.Petersburg and Suzhou, activities - insurance app architecture audit and segmentation, requirements collection, best practices consultancy Coordination of team resources inside distributed development team (methodology - Agile, teams - San) Francisco, Toronto, Riga, Vilnius, St.Petersburg and Suzhou, activities - collaborating and coaching development team at Chinese city of Suzhou Preparation of best practices policies for distributed development team (activities - capturing and documenting best practices and lessons learned throughout project sprints) Business analyst

09/2008 - 10/2011 ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, MySql, PHP, Finanzwesen, Finanzwesen, QlikView, Oracle, PL/SQL, ETL - Extract/Transform/Load, SQL, HTML/XHTML, CSS, JavaScript, PHP, Unit Tes
IngoNord Insurance Co (Helsinki, Finland, www . ingonord .com) ETL - ODI , DB - Oracle SQL, Oracle PL/SQL, MySQL, WEB - PHP Business analysis of distribution channels, potential business opportunities (activities - metrics definitions, allocation of trends, stakeholders collaboration) Participating in financial reporting activities and projects e.g. quarterly and annual closings Insurance system upgrade definition (activities - process review, business case definition, requirements collection, technical and integration specification preparation, vendor and technology selection) Financial reporting systems and data warehouse development (technology - Qlikview, Oracle 8, activities - PL/SQL coding, DW tables modelling and creation, DW performance tracking and composite indexes creation, ETL layer implementation - integration scripts heavily using SQL loader) Front-end web sales system UI design (technology - HTML, CSS, Javascript; actions - design, scripting, integrating) Back-end development of web sales system (technology - PHP; activities - design, coding, unit testing) Back-end development of insurance app (technology - Oracle 8,9, mainly SQL, PL/SQL; activities coding, reviewing, fine-tuning, allocating performance issues, coaching) Database performance management (technology - Oracle 8,9; activities - cost metrics definition, allocating degrading SQL queries, batch jobs review for performance leaks, utilization of temporary tables, utilization of pre-population tables) DBA operations (technology - Oracle 8,9; activities - database installations, database migrations incl. single-time and recurring, tablespaces / datafiles management, memory distribution monitoring, table indexes management, deploying dashboard for resource-consuming sessions monitoring) Business analyst

11/2007 - 08/2008 Finanzwesen, Wirtschaftsprüfung
Upgrade and optimization of brokers' sales processes (activities - process review, organization planning, team leading) Financial processes and environment development (activities - process review, upgrade plan composition, reporting stakeholders collaboration) Consulting CEO in business and operational development matters (activities - financial and stakeholder reporting composition, due diligence support, auditing team support) Establishing back-office team (activities - team building and leading) Development manager

10/2004 - 10/2007 ETL - Extract/Transform/Load, Oracle, SQL, Oracle, PL/SQL, MySql, Wirtschaftsprüfung, Delphi, VBA, Oracle Forms, Oracle, Oracle, Oracle, SQL, PL/SQL, Oracle, SQL, Oracle
ETL - ODI , DB - Oracle SQL, Oracle PL/SQL, MySQL Managing IT partners network and IT contracts portfolio (activities - partners contracting management, system definitions, technical stakeholders collaboration) IT budget preparation and IT costs controls (activities - budget preparation, budget approval negotiations, follow-up of budget performance) System architecture audits, collaboration with external auditing teams (activities - re-engineering insurance app model, preparation of information security policies to suit auditors' opinion) Core business systems definition and choosing (activities - business cases definition, requirements collection, system and vendor selection, system integration definition) Front-end development of insurance app (technologies - Delphi, VBA, Oracle Forms, Oracle Reports; activities - UI design, coding, reviews, coaching) Back-end design of insurance app (technology - Oracle 8,9; activities - tables, indexes, constraints, triggers design) Back-end development of insurance app (technology - Oracle 8,9, mainly SQL, PL/SQL; activities coding, reviewing, fine-tuning, allocating performance issues, coaching) Database performance management (technology - Oracle 8,9; activities - cost metrics definition, allocating degrading SQL queries, batch jobs review for performance leaks, utilization of temporary tables, utilization of pre-population tables) DBA operations (technology - Oracle 8,9; activities - database installations, database migrations incl. single-time and recurring, tablespaces / datafiles management, memory distribution monitoring, table indexes management, deploying dashboard for resource-consuming sessions monitoring) IT manager

01/2004 - 01/2016 SourceSafe 2 Expert Github 2 2016 Junior Expert,Junior

 
Branche
 
 
Kenntnisse
Hardware
Betriebssysteme
Apache Webserver
Microsoft SharePoint Server
Unix
Programmiersprachen
C++
CSS
Delphi
Groovy
HTML / XML
Java
JavaScript
Perl
PHP
PL/SQL
Python
SQL
VB (Visual Basic)
XML

Datenbanken
Interbase
MS SQL Server
MySQL
Oracle
Oracle Forms
Postgres SQL (psql)

Datenkomm. / Netzwerk

Design / Entwicklung

SAP / ERP Module

Software / Tools
Mercury WinRunner/QualityCenter
MS Office
QlikView

Standards / Prozesse
Anwendungsbetreuung
Changemanagement
ETL - Extract/Transform/Load
Problem Management
Rechnungswesen
 
Ausbildung & Zertifikate
k.A  
 
Sprachen
englisch (++++)
finnisch (++++)
russisch (++++)


Sonstiges
 

We love Freelancing
& project work

die people4project Recruiting-Spezialisten unterstützen IT Fachbereiche und Unternehmensberatungen mit der Auswahl von geeigneten Freelancer / IT Fachkräften

Kontakt

Wir freuen uns auf Sie...

people4project GmbH
Lörenskogstr. 3
85748 Garching b. München

Tel: +49 (89) 55 29 39 -40

  Google Map  |  Kontakt

 

über uns

wir sind Recruiting-Spezialisten für die temporäre Unterstützung von IT Entwicklungs- und Betriebsthemen, sowie das Managen von Freelancer-Einsätzen bei unseren Kunden.

...mehr

Â