Schlagwörter
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 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
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
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
Amazon Redshift, SQL Data Warehouse, Oracle Data Warehouse, and Vertica.
03/2016 - 12/2016
Position: Senior Developer (Freelancer)
Client: Bank
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
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
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
Microsoft SQL 2005 Toolkit, SSMS, SQL Server Data Tools (SSDT), SQL Server Profiler
11/2009 - 06/2012
Position: ETL Developer
Client: Insurance Company
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
CodeCharge Studio 5.1. , Cloud9 IDE, Delphi XE3, Eclipse PHP Developer Tools
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