lead software and azure architect, data architect
Uniper
(Energy, water and environment, >10.000 employees)
Keywords
Skills
Data Warehouse, system design, Azure Solution Architect, Big Data, Operating systems:
IX BS 2000, GCOS, MSDOS, OS/390/MVS, SINIX, SOLARIS, WINDOWS 95, 98, NT, ME, XP, 2000, LINUX,
Programming:
PHP, ASSEMBLER, C, C++, COBOL, ESQL/C, SQL, Java, Javascript, HTML, PL/SQL, Python, C#,
Databases:
ACCESS, DB/2, INFORMIX, ORACLE, Sybase, TERADATA, MySQL, SQL server, Snowflake,
Tools:
HP Quality Center, ARIS Toolset, Oracle Designer, PL/SQL Developer, ODI, BTEQ, Fastload, Multiload, Intrexx, COGNOS, Weblogic, Microstrategy, Business Objects, Business Objects Data Service, Power Designer, Tableau, Talend 6.4, 7.3,
Special Knowledge:
IoT, Scrum, CRM, Information retrieval, ETL Processing, UML, MS Dynamics, OOA, OOD, SOA, azure, data management system, Databricks, Talend 6.4, Talend 7.3, Python, C#, Azure batch account, Azure blob storage, Azure web jobs, database, Telecommunication, Salesforce, Server, Oracle 11g, SQL Server 2008 R2, Endur, Lexifi, PL, T-SQL, Net Framework, SSIS, SSRS, Business Objects Data Services, BOXI, OWB, Power, IT Security, XHTML, Flash, Pearl, Apache, Billing, KISS, SOX, ETL, AIX, UNIX, JDBC, quality control, data modelling, DB, Interface, SUN SOLARIS, NeXtt, AIMre AIMbase, AIMbpm, BEA WEBLOGIC, COGNOS Report Net VISUAL BASIC, Systems analysis, Intranet, KIAS 2000, SAP/R3, PROVIS, ASP, Windows 2000, Stored Procedures, OS/390, business process modelling, database server, C/C++, data transfer, MVS, JCL, Workflow, Web server, Windows 95, ISDN, system administration, Windows NT at SNA over SNA servers, COBOL Workbench, HP-UX, LOTUS Notes, SCO UNIX, Novell 3,12, OS/2, Windows 3,11, Ms Office, AMI PRO, LOTUS 1-2-3, macros, keyboard, software development methodology, OAS, graphic system, Windows, ODBC, SQL servers, Btrieve, OAS data, Visual C++, ISAM, UNIX networks, UEUCP, API, UNIX system V, CICS 1, MVS for DB/2, IMS, UNIX system, Windows SDK, CISAM, CASE-Tool ASES, 3COM, network architecture, Dbase, LAN, IBM 4381, SUN, CPIC, CICS, TSO, databases, data capture, network administration, MS DOS
IX BS 2000, GCOS, MSDOS, OS/390/MVS, SINIX, SOLARIS, WINDOWS 95, 98, NT, ME, XP, 2000, LINUX,
Programming:
PHP, ASSEMBLER, C, C++, COBOL, ESQL/C, SQL, Java, Javascript, HTML, PL/SQL, Python, C#,
Databases:
ACCESS, DB/2, INFORMIX, ORACLE, Sybase, TERADATA, MySQL, SQL server, Snowflake,
Tools:
HP Quality Center, ARIS Toolset, Oracle Designer, PL/SQL Developer, ODI, BTEQ, Fastload, Multiload, Intrexx, COGNOS, Weblogic, Microstrategy, Business Objects, Business Objects Data Service, Power Designer, Tableau, Talend 6.4, 7.3,
Special Knowledge:
IoT, Scrum, CRM, Information retrieval, ETL Processing, UML, MS Dynamics, OOA, OOD, SOA, azure, data management system, Databricks, Talend 6.4, Talend 7.3, Python, C#, Azure batch account, Azure blob storage, Azure web jobs, database, Telecommunication, Salesforce, Server, Oracle 11g, SQL Server 2008 R2, Endur, Lexifi, PL, T-SQL, Net Framework, SSIS, SSRS, Business Objects Data Services, BOXI, OWB, Power, IT Security, XHTML, Flash, Pearl, Apache, Billing, KISS, SOX, ETL, AIX, UNIX, JDBC, quality control, data modelling, DB, Interface, SUN SOLARIS, NeXtt, AIMre AIMbase, AIMbpm, BEA WEBLOGIC, COGNOS Report Net VISUAL BASIC, Systems analysis, Intranet, KIAS 2000, SAP/R3, PROVIS, ASP, Windows 2000, Stored Procedures, OS/390, business process modelling, database server, C/C++, data transfer, MVS, JCL, Workflow, Web server, Windows 95, ISDN, system administration, Windows NT at SNA over SNA servers, COBOL Workbench, HP-UX, LOTUS Notes, SCO UNIX, Novell 3,12, OS/2, Windows 3,11, Ms Office, AMI PRO, LOTUS 1-2-3, macros, keyboard, software development methodology, OAS, graphic system, Windows, ODBC, SQL servers, Btrieve, OAS data, Visual C++, ISAM, UNIX networks, UEUCP, API, UNIX system V, CICS 1, MVS for DB/2, IMS, UNIX system, Windows SDK, CISAM, CASE-Tool ASES, 3COM, network architecture, Dbase, LAN, IBM 4381, SUN, CPIC, CICS, TSO, databases, data capture, network administration, MS DOS
Project history
01/2017
-
Present
Creation of the governance concept for setting up new cases within the data lake. As data steward and project manager serving several use cases. Design and implementation of the first real time trading use case. Lead architect and project manager for the digitalization of power generation actual in snowflake with azure components. Scheduling and job creation with Talend. Lead architect for building the new digital asset data management system.
Azure, Event hub, Databricks, Talend 6.4, Talend 7.3, Tableau, Snowflake, SQL data warehouse, Python,, C#, Azure batch account, Azure blob storage, Azure web jobs, function apps
04/2016
-
12/2016
Business Analyst, Architect, ETL and Database Developer
Uniper
(Energy, water and environment, >10.000 employees)
As business analyst, architect and developer gathering requirements and creating a new database reporting solution for analyzing KPI’s and performance indicator on the efficiency and performance of power generation for the different power plant units owned by the client. Additional economical analysis for the plant units in correlation to the trading unit, considering also market and production risks. Integration into the whole IT landscape and strategical design for the upcoming years. Setting up the operational management and the support for the system.
01/2016
-
03/2016
Business Analyst
Vodafone
(Telecommunications, >10.000 employees)
Gathering requirements for a CRM and KPI reporting tool, to manage the service deliveries for the different local country companies. Also assessing a tool for building a tactical solution, that should run until the strategic solution has taken place.
06/2010
-
12/2015
Business Analyst, Architect, Developer, Project Manager
Uniper
(Energy, water and environment, >10.000 employees)
As project manager, business analyst and architect part of the implementation project for an
strategic enterprise reporting solution (data warehouse), as successor for the system created by myself (see below).
Project management (PNP and scrum) of several business critical IT projects, responsible for budgets within the area of risk management, risk and regulatory reporting. Management of mixed international business and IT teams.
Project manager and business analyst for an IT project within the area of risk management and reporting for an energy and commodity trading company. Design and implementation of an BI solution for risk management, kpi’s, PnL/MtM numbers and position information trade based and aggregated. Trading systems: ENDUR, Right Angle, Lexifi, Zainet.
08/2009
-
04/2010
Full Stack Developer, Project Manager
Human Information Technology
(Internet and Information Technology, < 10 employees)
Design and Development of an international trading portal, incl. business workflow and payment systems with complete functionality of an online shop. Support of customers, optimization of service processes. Project management for the international developer team and coordination of all operating activities.
02/2009
-
07/2009
Business Analyst
Vodafone
(Telecommunications, >10.000 employees)
Business analysis of invoice reconciliation between device producer and supplier of services and the customer, a mobile telecommunication company.
Creation of a business concept and making the software requirement specification for the it-project to establish a monthly automized reconciliation process, creating forecasts and the interface of data exchange between the two parties. Base of data was build within the datawarehouse. Coordination of the different departments during the feasibility phase and during the solution concept phase.
03/2005
-
01/2009
Second Level Support, Developer
Metro AG
(Consumer goods and retail, >10.000 employees)
Second Level Support, Business Analysis and Development for all of the international data warehouses based on TERADATA
Incident Management and Development of patches for the incidents. Tracking of projects
Business Analysis, Development of new architecute strategies and methodics for ETL-processing, Development of new features
12/2003
-
02/2005
Project Manager
DHL
(Transport and Logistics, >10.000 employees)
Project Management of 4 offshore development teams:
Project management of a project to the quality control in the Hub’s with the aim, to build reports based on the events of the separate Hub’s centrally recallable on the Internet.
Moreover belonged the data modelling for COGNOS, the draft of the reports, as well as the concept of the import interfaces. Afterwards the control of the complete development team and coordination of the activities with the specialized division.
Project Management for the integration of the Track and Trace information of bought out daughter's enterprises into the central Track and
Trace system "NeXtt" with the strategic aim to integrate all daughter's enterprises till the end of 2004 on a platform. This aim was reached
Business process analysis of the existing production processes in the Hub’s. Reverse engineering of the existing application
(moduls, scripts, PL/SQL-procedures, interfaces, DB-structure) as basis of the migration into the Data Warehouse.
Process analysis of the customer relationships with the international contracting partners. Coordination of the data exchange and integration of new partners.
Management of the " daily business " and the maintenance, control of the project team. Interface to the external service providers.
Development of a migration concept of the existing application into “NeXtt” as a central international Track and Trace system
Local Availability
Open to travel worldwide
Zur Zeit am liebsten nur Remote, ansonsten je nach Konditionen und Absprache unbegrenzt
