Thomas Schmidt

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

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)

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.

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.

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

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

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

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

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

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