United Kingdom: Freelancer profile Thomas Frank from CH-Zürich, Data Warehouse und Business Intelligence Experte | Profiles from freelancers and companies
Thomas Frank, Data Warehouse and Business Intelligence Expert from CH-Zürich
Thomas Frank
Data Warehouse and Business Intelligence Expert
79194 CH-Zürich
available
Hourly-/Daily rates:
100.00 €/hour
800.00 €/day
Last update: 03.08.2010 21:19
Attachments
- none -
Language skills
german (first language)english (business fluent)
Abilities, knowledge, experiences:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Project Management, PMI, Project estimation, Communication
Business Intelligence, Management Information System,
Cognos, ReportNet, PowerPlay, OLAP, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio
Datawarehouse, Decision Stream, Data Manager, SQL, Reporting, Analyse, Scorecarding, Alerting, ETL
• Requirements Analysis
• Software Evaluation
• Implementation
• Project Management
• Application Planning
• Application Installation and Implementation
• Quality Assurance
• Coaching
• Gap Analysis
• Application Redesign
References:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Bank Vontobel AG Zürich 07/2010 – today
Projektbeschreibung: Realization of a Management Information System for analyzing customer profitability in the investment bank of Bank Vontobel.
Gathering of requirements, data discovery within the data universe, setup and implementation of the data mart und creation of a reporting application on this foundation.
Realisiert unter: Windows, MS SQL 2005, MS SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Cognos 8
UBS Zürich 10/2007 – 06/2010
Description: Involved into various projects within the Cognos Competence Center of UBS.
• Supervision of projects in Risk Control, Sales Controlling, Cost Center Reporting, Marketing and Frontdesk Applications.
• At this Gathering of Requirements, Design, Implementation, Roll Out, Customer Care and Support.
• Ongoing development of existing applications, migration from IWR to Cognos 8, modification of the environments.
• Supervision and execution of the requirements from Data Warehouse/ETL Layer up to the Reporting and Analysis Frontend, Push Mails and Alerting.
Examplary:
Cognos Competence Center
Central point of contact for reporting requirements which should be realized with Cognos as the strategic BI platform within the UBS
• Support of the business departments with any questions regarding technical Limitations and Options.
• Integration and ongoing optimization of the interaction between the Cognos Software with the existing applications in the UBS systems network according to UBS policies and legal terms and conditions.
• 3rd level support and Cognos Customer Support contact
• Maintenance and improvement of the Cognos infrastructure within UBS on an ongoing basis.
\"During the almost three years of his engagement at UBS Cognos Development Mr. Frank gave valuable support in the most different projects in multiple areas of UBS. His extensive knowledge in the Cognos sphere and his ability to comprehend and understand the business requirements made him a valuable team player.”
Thomas Dubach, Teamleiter Cognos Visualisierung, Global Finance IT (GFIT), UBS, Zürich
?
History of Projects - 2/6
Project Marketing Management Information System
Implementation of the reporting requirements in Marketing Controlling along detailed
Umsetzung der Reportinganforderungen im Marketing Controlling nach präzisen specifications.
• Realisation of dynamic reports for flexible but still standardized reporting requirements.
• Elaborate design specifications according Corporate Design policies of UBS.
• Presentation of marketing campaigns with key performance indicators, as a Gantt diagram in HTML, Excel and PDF format.
“In the project Marketing Management Information System (MMIS) Mr. Frank migrated the application over various Cognos versions and implemented new requirements into the existing application quickly and very dependably. The cooperation was always smooth and flawless, his work swiftly and reliable.
Oliver Rothenbach, Teamlead, Sales & Campaign Management, Group Finance IT (GFIT), UBS, Zürich
Project Risk Datamart
Overall responsibility for the reporting application in the project Risk Datamart. Supervision and analysis of the country and counterparty risks of UBS on group level.
• Migration, tuning and ongoing development of the Cognos components and their direct environments.
• Administration and single point of contact for 2nd und 3rd level support.
• Range of responsibilities from UNIX scripting over Process Monitoring, DB Tuning and Security Administration to Development of the Frontend with Push Mails and Alerting Features.
\"In the project Risk Datamart Mr. Frank was responsible for designing and implementing the risk reports and cubes. In this role he has coordinated the developer team in Singapore to make sure resources are smoothly allocated. Additionally Mr. Frank worked fast and reliable on all issues arising from the periodical processing of the data and the generation of the cubes & reports and served in the 3rd level support in a proactive way. Many of his good ideas were taken for improving processes and for implementing new reports with additional benefit which was greatly appreciated by the users.”
Robert Niggli, Datamarts & Projects, Risk Control Operations, Risk COO, UBS, Zürich
Realized with: Solaris, AIX, IWR, Cognos ReportNet, Cognos 8.2, Cognos 8.4 BI, Report Studio, Query Studio, Event Studio, Cognos 7.2 & 7.4 PowerPlay, Oracle, DB2, JCS, div.
Zurich Versicherung Zurich 04/2007 – 09/2007
Description: Business analysis, design and implementation of a reporting application for a pricing system for property, liability, D&O and motor fleet insurances for corporate customers.
Redesign, Maintenance and Migration of the reporting application in an asset system in the department of global corporate customers.
Realized with: Windows, Business Objects 5.1/6.5, MS SQL 2000, DB2 UDB
\"After a very short prep time Mr. Frank was able to support our needs very well. His valuable experiences in the field of Business Intelligence were a major asset and helped us in various projects to build a solid foundation for fulfilling the reporting requirements.”
Guido Jaeger, Program Manager, Global Corporate Europe IT, Zurich Financial Services
History of Projects - 3/6
Telekom Austria Wien 02/2007 – 04/2007
Description: Implementation of a reporting application for the department Whole Sales National for analysing and reporting open phone line orders and the current service assets.
Realized with: Windows, Cognos Series 7, Cognos ReportNet, Teradata
\"Apart from his BI implementation and project management skills Mr. Frank was able to provide us with optimal support after a very short introductory time and deliver main parts to the project success. I can warmly recommend Mr. Frank.”
Dr. Thomas Pisar, DWH & BI CC, Controlling Applications, Telekom Austria AG
DAK – Health Insurance 07/2006 – 11/2006
Description:
Project management creating and implementing a Management Dashboards for top corporate management. Central key metrics are extracted from numerous source systems and represented by traffic light status indicators.
Realized with: Windows, Cognos 8 BI
Schering 10/2006 –
Description:
Implementation of an automated batch reporting system. Data is extracted from various process control systems into a data warehouse and automatically reported upon for legal requirements are archived.
Realized with: Windows, Cognos DecisionStream, Cognos 8 BI, Oracle
GEMA 05/2006 – 12/2006
Description:
Support of the implementation of a dialog system for controlling, correcting and analyzing a royalty payment system.
Realized with: UNIX, Windows, Cognos 8 BI, Oracle
BASF 06/2004 – 07/2005
Description:
Project management implementing an analysis system for financial results of the corporate group. Extraction of the consolidated results from SAP BW in a multi dimensional Cube and supply to worldwide controllers.
Realized with: Windows, Cognos Series 7, Cognos ReportNet
tesa 04/2004 – 01/2005
Description:
Project management and support of the implementation of a quality- and logistics control system. Data from heterogeneous data sources will be pulled into a data warehouse, consolidated and reported and analysed upon.
Realized with: Windows, Cognos DecisionStream, Cognos Series 7, Cognos ReportNet, Oracle
Fiducia 11/2002 – 02/2006
Description:
Support of the implementation of a Business Intelligence Solution in the computing center of Germans mutual savings banks.
Realized with: Windows, UNIX, Cognos Series 7, Cognos ReportNet, Cognos 8 BI, DB2
Cognos 04/2001 – 12/2006
Description:
Numerous bigger and smaller implementation projects of Business Intelligence Solutions often in connection with a Data Warehouse at various customers (Examples):
Insurances: Allianz, Euler-Hermes, AachenMünchener, AOK Niedersachsen, AOK Berlin, BKK, Nürnberger, Wüstenrot & Württembergische
Finance: Dresdner Bank, GAD
Healthcare: Boehringer, Sanofi Aventis, GlaxoSmithKline
Telecommunication: O2, TollCollect
Automotive: BMW, DaimlerChrysler, GM
Others: Olympus; ifm
Realized with: Windows, UNIX, Cognos 6, Cognos Series 7, Cognos 8 BI, Cognos DecisionStream, SQL, Oracle, DB2, MS SQL
K|S associates 12/2000 – 03/2001
Description:
Business analysis, concept and implementation of financial reorganization at an engineering company for civil engineering and landfill building in northern Germany.
Realized with: MS Office
Abakus Wertkontor AG 05/2000 – 11/2000
Description:
Management and creation of an Internet StartUp. Recruitment of employees, financial planning, product development, installation of office infrastructure, business plan, search for investors
Realized with: Windows, MS Office
Landesbank Baden Württemberg 03/1999 – 09/2000
Description:
Support and improvement of the electronic asset trade system Reuters Kondor
Realized with: Windows, UNIX, Sybase, SQL, Skript, Kondor
Landesbank Baden Württemberg 03/1999 – 09/2000
Description:
Improvement and enhancement of the electronic booking system in the back office of the derivate trade.
Realized with: Windows, UNIX, Sybase, SQL, Skript
SAP 09/1998 – 11/1998
Description:
Quality Management R3-FI. Implementation of a hierarchical system of Computer Aided Test Tools (CATT).
Realized with: Windows, SAP R3 FI, CATT
Siemens 03/1998 bis 05/1998
Description:
Development and Implementation of a software simulation for a special scheduling algorithm for a telecommunication system.
Realized with: Windows, C++
Deutsche Bank 07/1997 – 10/1997
Description:
Implementation of an application for managing risk and credit lines in inter bank business.
Realized with: Windows, OS2, UNIX, DB2, SQL, REXX
Price Waterhouse Coopers 07/1996 – 03/1998
Description:
System administration und PC-Support
Realized with: Windows, Lotus Notes, Datev, MS Office, zahlreiche Tools und Utilities
Humboldt Universität Berlin 10/1995 – 02/1997
Description:
Implementation and maintenance of the web site of the Institute for Operations Research
Realized with: UNIX, HTML, MySQL
IT-Services and Solutions GmbH 02/1996 – 04/1996
Description:
Implementation of a internal Application for reporting work time.
Realized with: MS Excel, VBA, Windows
Temporal and spatial availability.:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
- international
- asap
Other:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Project Management, PMI, Project estimation, Communication
Business Intelligence, Management Information System,
Cognos, ReportNet, PowerPlay, OLAP, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio
Datawarehouse, Decision Stream, Data Manager, SQL, Reporting, Analyse, Scorecarding, Alerting, ETL
• Requirements Analysis
• Software Evaluation
• Implementation
• Project Management
• Application Planning
• Application Installation and Implementation
• Quality Assurance
• Coaching
• Gap Analysis
• Application Redesign
References:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Bank Vontobel AG Zürich 07/2010 – today
Projektbeschreibung: Realization of a Management Information System for analyzing customer profitability in the investment bank of Bank Vontobel.
Gathering of requirements, data discovery within the data universe, setup and implementation of the data mart und creation of a reporting application on this foundation.
Realisiert unter: Windows, MS SQL 2005, MS SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Cognos 8
UBS Zürich 10/2007 – 06/2010
Description: Involved into various projects within the Cognos Competence Center of UBS.
• Supervision of projects in Risk Control, Sales Controlling, Cost Center Reporting, Marketing and Frontdesk Applications.
• At this Gathering of Requirements, Design, Implementation, Roll Out, Customer Care and Support.
• Ongoing development of existing applications, migration from IWR to Cognos 8, modification of the environments.
• Supervision and execution of the requirements from Data Warehouse/ETL Layer up to the Reporting and Analysis Frontend, Push Mails and Alerting.
Examplary:
Cognos Competence Center
Central point of contact for reporting requirements which should be realized with Cognos as the strategic BI platform within the UBS
• Support of the business departments with any questions regarding technical Limitations and Options.
• Integration and ongoing optimization of the interaction between the Cognos Software with the existing applications in the UBS systems network according to UBS policies and legal terms and conditions.
• 3rd level support and Cognos Customer Support contact
• Maintenance and improvement of the Cognos infrastructure within UBS on an ongoing basis.
\"During the almost three years of his engagement at UBS Cognos Development Mr. Frank gave valuable support in the most different projects in multiple areas of UBS. His extensive knowledge in the Cognos sphere and his ability to comprehend and understand the business requirements made him a valuable team player.”
Thomas Dubach, Teamleiter Cognos Visualisierung, Global Finance IT (GFIT), UBS, Zürich
?
History of Projects - 2/6
Project Marketing Management Information System
Implementation of the reporting requirements in Marketing Controlling along detailed
Umsetzung der Reportinganforderungen im Marketing Controlling nach präzisen specifications.
• Realisation of dynamic reports for flexible but still standardized reporting requirements.
• Elaborate design specifications according Corporate Design policies of UBS.
• Presentation of marketing campaigns with key performance indicators, as a Gantt diagram in HTML, Excel and PDF format.
“In the project Marketing Management Information System (MMIS) Mr. Frank migrated the application over various Cognos versions and implemented new requirements into the existing application quickly and very dependably. The cooperation was always smooth and flawless, his work swiftly and reliable.
Oliver Rothenbach, Teamlead, Sales & Campaign Management, Group Finance IT (GFIT), UBS, Zürich
Project Risk Datamart
Overall responsibility for the reporting application in the project Risk Datamart. Supervision and analysis of the country and counterparty risks of UBS on group level.
• Migration, tuning and ongoing development of the Cognos components and their direct environments.
• Administration and single point of contact for 2nd und 3rd level support.
• Range of responsibilities from UNIX scripting over Process Monitoring, DB Tuning and Security Administration to Development of the Frontend with Push Mails and Alerting Features.
\"In the project Risk Datamart Mr. Frank was responsible for designing and implementing the risk reports and cubes. In this role he has coordinated the developer team in Singapore to make sure resources are smoothly allocated. Additionally Mr. Frank worked fast and reliable on all issues arising from the periodical processing of the data and the generation of the cubes & reports and served in the 3rd level support in a proactive way. Many of his good ideas were taken for improving processes and for implementing new reports with additional benefit which was greatly appreciated by the users.”
Robert Niggli, Datamarts & Projects, Risk Control Operations, Risk COO, UBS, Zürich
Realized with: Solaris, AIX, IWR, Cognos ReportNet, Cognos 8.2, Cognos 8.4 BI, Report Studio, Query Studio, Event Studio, Cognos 7.2 & 7.4 PowerPlay, Oracle, DB2, JCS, div.
Zurich Versicherung Zurich 04/2007 – 09/2007
Description: Business analysis, design and implementation of a reporting application for a pricing system for property, liability, D&O and motor fleet insurances for corporate customers.
Redesign, Maintenance and Migration of the reporting application in an asset system in the department of global corporate customers.
Realized with: Windows, Business Objects 5.1/6.5, MS SQL 2000, DB2 UDB
\"After a very short prep time Mr. Frank was able to support our needs very well. His valuable experiences in the field of Business Intelligence were a major asset and helped us in various projects to build a solid foundation for fulfilling the reporting requirements.”
Guido Jaeger, Program Manager, Global Corporate Europe IT, Zurich Financial Services
History of Projects - 3/6
Telekom Austria Wien 02/2007 – 04/2007
Description: Implementation of a reporting application for the department Whole Sales National for analysing and reporting open phone line orders and the current service assets.
Realized with: Windows, Cognos Series 7, Cognos ReportNet, Teradata
\"Apart from his BI implementation and project management skills Mr. Frank was able to provide us with optimal support after a very short introductory time and deliver main parts to the project success. I can warmly recommend Mr. Frank.”
Dr. Thomas Pisar, DWH & BI CC, Controlling Applications, Telekom Austria AG
DAK – Health Insurance 07/2006 – 11/2006
Description:
Project management creating and implementing a Management Dashboards for top corporate management. Central key metrics are extracted from numerous source systems and represented by traffic light status indicators.
Realized with: Windows, Cognos 8 BI
Schering 10/2006 –
Description:
Implementation of an automated batch reporting system. Data is extracted from various process control systems into a data warehouse and automatically reported upon for legal requirements are archived.
Realized with: Windows, Cognos DecisionStream, Cognos 8 BI, Oracle
GEMA 05/2006 – 12/2006
Description:
Support of the implementation of a dialog system for controlling, correcting and analyzing a royalty payment system.
Realized with: UNIX, Windows, Cognos 8 BI, Oracle
BASF 06/2004 – 07/2005
Description:
Project management implementing an analysis system for financial results of the corporate group. Extraction of the consolidated results from SAP BW in a multi dimensional Cube and supply to worldwide controllers.
Realized with: Windows, Cognos Series 7, Cognos ReportNet
tesa 04/2004 – 01/2005
Description:
Project management and support of the implementation of a quality- and logistics control system. Data from heterogeneous data sources will be pulled into a data warehouse, consolidated and reported and analysed upon.
Realized with: Windows, Cognos DecisionStream, Cognos Series 7, Cognos ReportNet, Oracle
Fiducia 11/2002 – 02/2006
Description:
Support of the implementation of a Business Intelligence Solution in the computing center of Germans mutual savings banks.
Realized with: Windows, UNIX, Cognos Series 7, Cognos ReportNet, Cognos 8 BI, DB2
Cognos 04/2001 – 12/2006
Description:
Numerous bigger and smaller implementation projects of Business Intelligence Solutions often in connection with a Data Warehouse at various customers (Examples):
Insurances: Allianz, Euler-Hermes, AachenMünchener, AOK Niedersachsen, AOK Berlin, BKK, Nürnberger, Wüstenrot & Württembergische
Finance: Dresdner Bank, GAD
Healthcare: Boehringer, Sanofi Aventis, GlaxoSmithKline
Telecommunication: O2, TollCollect
Automotive: BMW, DaimlerChrysler, GM
Others: Olympus; ifm
Realized with: Windows, UNIX, Cognos 6, Cognos Series 7, Cognos 8 BI, Cognos DecisionStream, SQL, Oracle, DB2, MS SQL
K|S associates 12/2000 – 03/2001
Description:
Business analysis, concept and implementation of financial reorganization at an engineering company for civil engineering and landfill building in northern Germany.
Realized with: MS Office
Abakus Wertkontor AG 05/2000 – 11/2000
Description:
Management and creation of an Internet StartUp. Recruitment of employees, financial planning, product development, installation of office infrastructure, business plan, search for investors
Realized with: Windows, MS Office
Landesbank Baden Württemberg 03/1999 – 09/2000
Description:
Support and improvement of the electronic asset trade system Reuters Kondor
Realized with: Windows, UNIX, Sybase, SQL, Skript, Kondor
Landesbank Baden Württemberg 03/1999 – 09/2000
Description:
Improvement and enhancement of the electronic booking system in the back office of the derivate trade.
Realized with: Windows, UNIX, Sybase, SQL, Skript
SAP 09/1998 – 11/1998
Description:
Quality Management R3-FI. Implementation of a hierarchical system of Computer Aided Test Tools (CATT).
Realized with: Windows, SAP R3 FI, CATT
Siemens 03/1998 bis 05/1998
Description:
Development and Implementation of a software simulation for a special scheduling algorithm for a telecommunication system.
Realized with: Windows, C++
Deutsche Bank 07/1997 – 10/1997
Description:
Implementation of an application for managing risk and credit lines in inter bank business.
Realized with: Windows, OS2, UNIX, DB2, SQL, REXX
Price Waterhouse Coopers 07/1996 – 03/1998
Description:
System administration und PC-Support
Realized with: Windows, Lotus Notes, Datev, MS Office, zahlreiche Tools und Utilities
Humboldt Universität Berlin 10/1995 – 02/1997
Description:
Implementation and maintenance of the web site of the Institute for Operations Research
Realized with: UNIX, HTML, MySQL
IT-Services and Solutions GmbH 02/1996 – 04/1996
Description:
Implementation of a internal Application for reporting work time.
Realized with: MS Excel, VBA, Windows
Temporal and spatial availability.:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
- international
- asap
Other:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
==>> CONTACT VIA TFRANK(a)TFRANK.NET
-----------------------------------------------------------------------------------------------------------------------------------------------------------
 |  |  |  |  |  |
 |  |  |  |  |  |
Register now
Profile Navigation
New profile
New Company Profiles
Statistic
The average daily rate of our Freelancer amounts to 507 €, the hourly rate 59 €.
The facewall
Do you know someone?
New projects
RSS feeds
Read the newest projects in your favorite rss reader.
 
|
|
Deutschland | Österreich | Schweiz | United Kingdom | USA | Russian Federation | España | Italy | Ukraine | Liechtenstein | Hungary | New Zealand | France | Slovakia | India | United Arab Emirates
Theme related Websites :