Profilbild von Thomas Schmidt DWH Developer aus Hamburg

Thomas Schmidt

verfügbar

Letztes Update: 10.07.2019

DWH Developer

Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)

Skills

Oracle SQL & PL/SQL; ETL/DWH; RDBMS 11g/12c; Unix; SAS Data Management; Vertica; Snowflake; Oracle RAC; XML, Oracle Data Integrator (ODI)

Projekthistorie

07/2018 - present
Position: External DWH Developer (Freelancer)
Client: Bank
  • Oracle SQL & PL/SQL development
  • Performance tuning
  • ETL/DWH development
  • Mapping customization
  • Quality Control & Testing

Oracle RDBMS 11g / 12c, PL/SQL, SQL, Data Warehousing, Job Scheduling, XML, CSS,     JavaScript, Oracle Warehouse, Builder (OWB) 11.2, Microsoft Office, Putty, Subversion, UC4 Automation, SAP Business Objects


01/2018 - 07/2018
Position: Senior Developer (Freelancer)
Client: Telecommunications Company
  • Maintain and extend the current functionality of an enterprise data warehouse
  • Support multiple data marts
  • Team support and introduce best practices

formatica7,8 Powercenter and Power Analyser, DB2, Unix, Data Migrator (IBI), SQL Server Integration Services (SSIS)



07/2018 - 01/2018
Position: BI Architect (Freelancer)
Client: Technologies Company
  • Create Business Objects Universes
  • Deliver substantial ETL improvements.
  • EDW data latency reduction
  • Manage Data Warehouse & BI issues SharePoint sites

SQL Data Warehouse, Oracle Data Warehouse, and Vertica, SAP Data Services, IBM Infosphere Information Server, SAS Data Management, Elixir Repertoire for Data ETL.


12/2016 - 07/2017
Position: Data Warehouse Architect (Freelancer)
Client: Global Investment Firm
  • Pilot project of a special data mart implementation
  • Design a new recursive data model   
  • Create several BO Universes

Amazon Redshift, SQL Data Warehouse, Oracle Data Warehouse, and Vertica.


03/2016 - 12/2016
Position: Senior Developer (Freelancer)
Client: Bank
  • Establish and implement efficient SDLC processes
  • Design end to end DW solution
  • Unified data model design and marts reporting

MS SQL server, ETL technologies, SAP BW, Snowflake, Netezza, and Teradata Data Warehouse Appliance



08/2015 - 03/2016
Position: Senior Consultant (Freelancer) 
Client: Financial Service Company
  • Develop ETL solutions
  • Mobilize data into a core data warehouse 
  • Populate downstream marts
  • Portfolio performance calculation
  • Asset static analysis
  • Anti money laundering trade query analysis
  • Portfolio rebalancing

Informatica Powercenter, IBM Infosphere Information Server, Oracle Data Integrator, Microsoft SSIS, Ab Initio, CloverETL

09/2014 - 08/2015
Position: Senior System Analyst (Freelancer)
Client: Bank
  • Requirement analysis
  • Manage solution definition and technical design
  • Develop an Oracle Data Warehouse
  • Design Oracle AWM 10 cube, Oracle Warehouse Builder 10g ETL pipelines
  • Design of Data Vault modeling 

Oracle RDBMS 11g, Oracle RAC, PL/SQL, SQL, Data Warehousing, Job Scheduling, Talend Integration Studio, XML, Oracle Warehouse Builder (OWB) 11.2, Oracle Data Integrator (ODI), Oracle Application Server, Oracle WebLogic



06/2012 - 09/2014
Position: BI Lead
Client: Bank
  • Manage the specification, design and implementation of an enterprise data warehouse solution
  • Manage the development of SSIS ETL solutions
  • Manage the design, tuning & deployment of SSAS OLAP cubes
  • Develop SSRS reports

Microsoft SQL 2005 Toolkit, SSMS, SQL Server Data Tools (SSDT), SQL Server Profiler


11/2009 - 06/2012
Position: ETL Developer
Client: Insurance Company
  • Manage the DWH Teradata DWH project
  • Rationalize the development processes 
  • Manage the reusability of ETL modules 

Oracle RDBMS 11g / 12c, PL/SQL, SQL, Data Warehousing, Job Scheduling, XML, CSS,     JavaScript, Oracle Warehouse, Builder (OWB) 11.2, Microsoft Office, Putty, Subversion, UC4 Automation, SAP Business Objects


06/2007 - 11/2009
Position: Software Engineer
Client: Business Services Company
  • Transfer project domain
  • Set up a local development and testing environment
  • Ensure on time project UAT completion

CodeCharge Studio 5.1. , Cloud9 IDE, Delphi XE3, Eclipse PHP Developer Tools

Reisebereitschaft

Verfügbar in den Ländern Deutschland
Profilbild von Thomas Schmidt DWH Developer aus Hamburg DWH Developer
Registrieren