IT-Consultant / Data Science

freiberufler IT-Consultant / Data Science auf freelance.de
Referenzen
offline
Verfügbarkeit einsehen
Europa
de  |  en
auf Anfrage
40595 Duesseldorf
22.08.2016

Kurzvorstellung

“I provide useful information and insights to the right people at the right time.”

Ich biete

IT, Entwicklung
  • MicroStrategy
  • Datawarehouse / DWH

Projekt‐ & Berufserfahrung

Participants
Data Science Retreat, Berlin
4/2016 – 7/2016 (4 Monate)
Hochschulen und Forschungseinrichtungen
Tätigkeitszeitraum

4/2016 – 7/2016

Tätigkeitsbeschreibung

Participants at the Data Science Retreat in Berlin, studying analytical methods to manage complex data sources, extract knowledge and insights from data and interpret the results. Practical experience in core analytics methods such as regression, classification, dimension reduction, clustering and optimization.

Project: Forecasting next month order quantity for a wholesale fashion company. To create a forecast for next month, the history of all stores placing orders for different product groups is needed. I used SQL to access the database and store the data in CSV files. With Python the data got extracted from the file and transformed to fit a regression model. Additional features like google trend analysis, stock market changes and other economic factors were added as features to improve the accuracy of the forecast. To predict next month order quantity, I created a stacker of five ensemble models and ran a linear regression on top of it. The reported measure of error is r2: 0,93, making it a very good prediction of next month order quatity.

Eingesetzte Qualifikationen

Data Mining


Lead Developer and Architect MicroStrategy
CBR Fashion Group (Street One & CECIL), Celle
10/2014 – 4/2016 (1 Jahr, 7 Monate)
Großhandel
Tätigkeitszeitraum

10/2014 – 4/2016

Tätigkeitsbeschreibung

Successful introduction of a enterprise-wide, uniform business intelligence solution, integrating design, marketing, sales and supply chain department. Based on a in-memory Data Warehouse technology (Exasol 5) and MicroStrategy 9.5 and 10.2, standardized dashboards and documents, data-driven management of business processes.
The scope of the position:
• Introduction of MicroStrategy in 19 countries with 500 users.
• Modelling and implementaion of the analysis layer in DWH for optimized access to the dimension and fact views (Star / Snowflake schema)
• Design and Reenginieering the analysis scheme in MicroStrategy (incl. attributes, facts, hierarchies and transformations, logical tables)
• Defining authorization concept in MicroStrategy with privileges, roles and accesses to objects (ACL).
• Maintanance and upgrade of development, test and production environment for MicroStrategy 9.5.1und 10.2
• Requirement anaysis and implemenation of complex Dashboards and Report Service Documents for Web and PDF print.

Eingesetzte Qualifikationen

MicroStrategy, Datawarehouse / DWH


IT-Consultant
Metro AG, Düsseldorf
6/2014 – 10/2014 (5 Monate)
Großhandel
Tätigkeitszeitraum

6/2014 – 10/2014

Tätigkeitsbeschreibung

Requirement analysis and definition of a new Campaign Management Reporting solution for the Corporate Marketing department. With a standardized set of mobile and web-based dashboard and report, an improved and state of the art reporting solution was created to support marketing analysts and management. The integration of business relevant KPIs with campaign response data builds the data foundation of this reporting solution.

Implementation of a monthly campaign performance dashboard in MicroStrategy 9.4.1 for mobile devices (IPad & IPhone) to prodive a showcase for the management.

Eingesetzte Qualifikationen

Business Intelligence (BI), Marketing (allg.)


MicroStrategy Consultant
Bausparkasse Schwäbisch Hall, Schwäbisch Hall
3/2014 – 5/2014 (3 Monate)
Banken
Tätigkeitszeitraum

3/2014 – 5/2014

Tätigkeitsbeschreibung

Design of Credit Management Report Service Documents and Dashboards in Micorstrategy v9.2 based on Oracle 11g Data Mart.
Introduction of a new data acceptance and approval process for the controlling department. Training and knowledge transfer of MicroStrategy Data Mining techniques.

Eingesetzte Qualifikationen

MicroStrategy, Oracle Database


Data Warehouse Consultant
METRO SYSTEMS GmbH, Düsseldorf
9/2011 – 12/2012 (1 Jahr, 4 Monate)
Großhandel
Tätigkeitszeitraum

9/2011 – 12/2012

Tätigkeitsbeschreibung

Department: Business Intelligence Development and Deployment
Designed an efficient and automated Business Performance Management tool, with regards to scalability and performance based on an international DWH (Teradata V12).
Transforming business requirements into SQL queries calculating KPIs.
Review of functional specification and creation of IT concept.
Rollout of a Total-Profitability-Tool used by over 20 countries.
Design and implementation of ETL-processes (Shell,SQL) within a very large DWH architecture.

Eingesetzte Qualifikationen

ETL, Teradata, SQL, Bash (Shell)


Lead Developer MicroStraetgy
Bundesagentur für Arbeit, Nürnberg
9/2009 – 4/2011 (1 Jahr, 8 Monate)
Öffentliche Verwaltung
Tätigkeitszeitraum

9/2009 – 4/2011

Tätigkeitsbeschreibung

Responsible to provide information for the project plan and creating the functional and IT concepts for the migration of multiple Data Marts from Informix to SQL Server 2008, which are the data sources for the monthly press release of labour market statistics.
Lead developer for the migration of multiple MicroStrategy projects to new data sources, incl. installation and administration of development and test environments, support of UAT tests and support of business users.
Provided an efficient concept to upgrade MicroStrategy V8 to V9 incl. test environment, metadata migration and user acceptance tests.
Good knowledge of development, quality assurance and performance optimization of static, dynamic and ad-hoc reports based on user requirements in MicroStrategy with high regard of business needs.

Eingesetzte Qualifikationen

MicroStrategy, Microsoft SQL-Server (MS SQL)


MicroStrategy Consultant
Lidl Stiftung & Co. KG, Neckersulm
1/2009 – 8/2009 (8 Monate)
Handel
Tätigkeitszeitraum

1/2009 – 8/2009

Tätigkeitsbeschreibung

Department: Business Intelligence
Successful rollout of MicroStrategy into the subsidiary location in an international environment. First and second Level support for MicroStrategy power users.
Quality assurance as well as requirement management for the DWH system, including the analysis of requested business information and prioritizing the requirements for future releases. Analysis, development and test of data correction scripts for international DWH based on Teradata V12.

Eingesetzte Qualifikationen

MicroStrategy, Teradata


Solution Architect
METRO SYSTEMS GmbH, Düsseldorf
1/2008 – 12/2008 (1 Jahr)
Großhandel
Tätigkeitszeitraum

1/2008 – 12/2008

Tätigkeitsbeschreibung

Department: Business Intelligence Deployment
• Solution Architect DWH (Teradata V6) for international data migration projects.
• Analysis of requirements and close consultation with local business teams
• Proposition of technical IT-concepts, based on business requirements
• Development of data migration scripts (SQL, BTEQ, Shell) and quality assurance
• Development and module test of data correction for DWH (SQL, BTEQ, Shell).

Eingesetzte Qualifikationen

Datawarehouse / DWH, Teradata


IT-Consultant
WestLB AG, Düsseldorf
1/2007 – 12/2007 (1 Jahr)
Banken
Tätigkeitszeitraum

1/2007 – 12/2007

Tätigkeitsbeschreibung

Department: Credit Risk Application
• Proposition of technical concept for a secure IT-Architecture according to requirements outlined by Bafin
• Deployment of software releases and upgrades of Credit Risk applications
• Development of reporting system to monitor data exchange from credit rating agencies
• Development of Shell- and PL/SQL scripts for Oracle 11

Eingesetzte Qualifikationen

Oracle Database, Bash (Shell)


Data Warehouse Consultant
BenQ Mobile GmbH & Co. OHG, Kamp-Lintfort
4/2006 – 12/2006 (9 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

4/2006 – 12/2006

Tätigkeitsbeschreibung

• Introduction of MicroStrategy 8 as the standard reporting tool for the Research & Development Software Department.
• Desing of schema object, metrics, filter, custom groups, etc.
• Successfully implementation of the Data Warehouse, including the analysis and implementation of the ETL process within the Project Planning and Controlling department using Oracle Data Warehouse Builder 10.
• Good knowledge of database design (star vs. snowflake schema, dimensions, facts and aggregation).
• First experience with analysis of customer and business requirements as well as design of user friendly reports.

Eingesetzte Qualifikationen

MicroStrategy, Datawarehouse / DWH


Zertifikate

MicroStrategy Data Mining v.9.3
Juni 2013

MicroStrategy Administrator v9.3
April 2013

Ausbildung

Data Science
(Ausbildung)
Jahr: 2016
Ort: Berlin

Wirtschaftsinformatik
(Master of Science)
Jahr: 2015
Ort: Duisburg-Essen

Wirtschaftsinformatik
(Diplom (FH))
Jahr: 2006
Ort: Dortmund

Qualifikationen

Data Science Retreat, Berlin Project: Predicting order quantity placed by stores for a wholesales fashion company in order to automize the forecasting process.

MicroStrategy Data Mining and Advanced Analytics v9.3
MicroStrategy Certified Platform Administrator v9.3

Persönliche Daten

Sprache
  • Deutsch (Muttersprache)
  • Englisch (Fließend)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
763
Alter
36
Berufserfahrung
13 Jahre und 4 Monate (seit 04/2006)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden »