Thomas Schmidt
Freelancer, External DWH Developer, Bank
Germany
Timeline
Professional experience for Thomas Schmidt
Current , since Jul 2018
External DWH Developer
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
7 months, Jan 2018 - Jul 2018
Senior Developer
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)
7 months, Jul 2017 - Jan 2018
BI Architect
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.
8 months, Dec 2016 - Jul 2017
Data Warehouse Architect
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.
10 months, Mar 2016 - Dec 2016
Senior Developer
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
8 months, Aug 2015 - Mar 2016
Senior Consultant
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
1 year, Sep 2014 - Aug 2015
Senior System Analyst
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
2 years and 4 months, Jun 2012 - Sep 2014
BI Lead
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
2 years and 8 months, Nov 2009 - Jun 2012
ETL Developer
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
2 years and 6 months, Jun 2007 - Nov 2009
Software Engineer
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
Educational background for Thomas Schmidt
2 years and 7 months, Oct 2004 - Apr 2007
Computer Science
Albert-Ludwigs-University Freiburg
2 years and 10 months, Sep 2001 - Jun 2004
Digital Business and Data Science
University of Applied Sciences Europe
Languages
German
First language
English
Fluent
Spanish
Basic