03/18/2025 updated

**** ******** ****
verified
Premium member
100 % available

Big Data, DWH and Cloud Architect, Projectmanager, Business Analyst

Triesen, Liechtenstein
Worldwide
Organisationsprogrammierer
Triesen, Liechtenstein
Worldwide
Organisationsprogrammierer

Profile attachments

CV Stefan.Schmidt deutsch.doc
CV Stefan.Schmidt english.doc

Microsoft AccessASP.NETC (Programming Language)Adobe FlashHTMLJava (Programming Language)JavaScript.NET FrameworkPHPExtensible HyperText Markup Language (XHTML)IBM OS/2 (Software)Microsoft WindowsApplication Programming Interfaces (APIs)IBM AIXApache HTTP ServerMicrosoft AzureTelecommunicationsOracle WebLogic ServerBig DataBillingCustomer Relationship ManagementBusiness Process ModelingBusiness RequirementsC Sharp (Programming Language)UnixC++ (Programming Language)Customer Information Control System (CICS)Cloud EngineeringCOBOL (Programming Language)Cognos ReportNetComputer SecurityComputer ProgrammingDatabasesNovell NetWareData As A ServicesData CollectionData TransmissionsExtract Transform Load (ETL)Data ModelingData WarehousingIBM DB2Database ServersDBaseLinuxDOS (Disk Operating System)Microsoft Dynamics CRMEmbedded SQLVisual C++ (Programming Language)Unix System VGraphic DesignHP Quality CentersHP-UXWeb ServersIBM Cognos Business IntelligenceJob Control Language (JCL)IBM NotesInformation RetrievalSystems AnalysisIntegrated Services Digital NetworksIntranetIndexed Sequential Access Method (ISAM)Java Database ConnectivityPython (Programming Language)Local Area NetworksMicrosoft OfficeMicrosoft SQL ServersMicroStrategyMySQLMVS (OS)Network ArchitectureNetwork AdministrationOpen Database ConnectivityObject-Oriented Software DevelopmentOperational SystemsOracle DatabasesOracle ApplicationsScrum MethodologyAzure Data LakeSalesforce.ComSAP R/3Service-Oriented ArchitectureSoftware EngineeringSolaris (Operating System)Solution ArchitectureSarbanes-Oxley Act (SOX) ComplianceStored ProcedurePL-SQLSQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesSystems DesignSalesforce TableauTalendTeradata SQLTransact-SQLUMLInformixMacrosSybaseQuality ControlInternet of Things (IoT)SAP BusinessObjectsOracle DesignerSystem AdministrationData Management SystemsVba Programming LanguageOs/390 Operating SystemNetwork ServerDatabricks
Data Warehouse, system design, Azure Solution Architect, Big Data, Data Engineer, Cloud computing, Data Architect
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, Azure SQL, Synapse
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, Confluence, Jira
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, python panel, Data Sience

Languages

GermanNative speakerEnglishGood

Project history

Enterprise Architect, Solution Architect

ThyssenKrupp AG

Industry & Mechanical Engineering

>10.000 team member

Architectural support as preparation for a migration project of a legacy system into the Cloud and  the further architectural design to become a data ware house solution. DB model setup for the new data model within the DWH. Design of the complete Application infra structure, decision preparation for the senior management, support and consulting as architect for the development teams during the implementation phase.

Azure, snowflake, PostgreSQL, Azure SQL database, T SQL, SQL, Azure Data Factory

Enterprise Architect, IT-Consulting

Loh Services GmbH

Industry & Mechanical Engineering

5000-10.000 team member

Creating of a strategical study es decision enabler for the new enterprise warehouse platform, which is to be built within the company. Creating a longlist with vendors, evaluating a vendor shortlist. Build a presentation with all pros and cons for the A-Level management and Company owners as a decision paper.

Microsoft Azure, Google Cloud Platform, SAP Datasphere has been the options on the shortlist

Data Engineer, Data Science

Sanofi

Pharmaceuticals & Medical Technology

>10.000 team member

As data architect, data scientist and data engineer design and implementation of a new data model in snowflake as preparation for the automated quality assurance of the produced devices, from sensor data out of the production lines and supplier companies. Further design and preparation of the ELT process flows.

Amazon Cloud, snowflake, Airflow, python

lead software and azure architect, data architect, project manager

Uniper

Energy, Water & Environment

>10.000 team member

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

Business Analyst, Architect, ETL and Database Developer

Uniper

Energy, Water & Environment

>10.000 team member

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.

 

Business Analyst

Vodafone

Telecommunications

>10.000 team member

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.

Business Analyst, Architect, Developer, Project Manager

Uniper

Energy, Water & Environment

>10.000 team member

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.

Full Stack Developer, Project Manager

Human Information Technology

Internet & IT

< 10 team member

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.

Business Analyst

Vodafone

Telecommunications

>10.000 team member

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.

Second Level Support, Developer

Metro AG

Goods & Retail

>10.000 team member

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

Project Manager

DHL

Transport & Logistics

>10.000 team member

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


Recommendations

"Ich arbeite seit vielen Jahren sehr erfolgreich mit Stefan Schmidt zusammen. Besonders schätze ich sein breites Fachwissen und seine pragmatische Arbeitsweise."

Uniper Global Commodities

Senior Vice President Digital Trading Development and Operations (Dr. Stephan van Aaken)


Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in