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