Bartosz Wiecha Email & Phone Number

Zurich, Switzerland

Basel, Ch

Architecting, developing and maintaining a Data Platform for the organization's costs calculation.Acting as Data & Analytics Engineer with DevOps/DataOps and Data Architecture and Governance flavours.* Maintain and implement new features for Data Platform* Implementation of Security Model and Security Governance for data access* Design CI/CD strategy and development of full CI/CD lifecycle process in Azure DevOps* Migration from Azure DevOps to Github* Implementation of Elastic Stack (ELK)* Support development of company's Data LakeTechnology stack: Microsoft SQL Server 2019, Data Vault 2.0, dbt (core, custom macros), SQL, Python, Azure DevOps, Github, Elastic Stack (ELK), Dataiku, Cloudera Data Platform (CDP), Kafka, Docker, Red Hat OpenShift Container Platform (OCP)

Zurich, Ch

Architecting, developing and maintaining a Global Data Platform for all worldwide Credit Suisse Trust locations, including: Zürich, Liechtenstein, Singapore, Hong Kong, Bahamas, Guernsey. * Maintain Data Platform and implement new features* Implementing Security Model and Security Governance and for Credit Suisse Trust Group* Lead a solution of transforming a Reporting Platform to a Modern Data & Analytics Portal* Working on an Asset Management solution* Supporting various internal stakeholders (mostly Finance/Controlling Team and Trust Advisors Team) with ad-hoc data requests regarding Worldwide and European Directives* Developing CI/CD strategy* Automation of Financial Month End Process* Preparation and execution of migration to a new platform (SQL Server 2017)Technology stack: Microsoft SQL Server 2014/2016/2017, Microsoft BI Stack (SSIS, SSAS, SSRS), Power BI, C#, NavisionLeading project of building TCO Financial Dashboard (Total Cost of Ownership) Solution. Leading a full lifecycle of a product, from gathering the requirements, discussing with stakeholders, analysing data, building data layer, assessing possible solutions and technologies that can be used (Power BI vs Tableau) and building presentation layer - TCO Financial Dashboard for stakeholders (Cost Centres’ Owners, Projects’ Owners) on Tableau Desktop and Tableau Server.Technology Stack: SQL Server 2017, T-SQL, DAX, Power BI, Tableau, Excel3rd Credit Suisse Hackathon - The Future of Banking Hackathon 2019Technology stack: Deep Learning, Python, GCP (Google Cloud Platform)4th Credit Suisse Hackathon - The Future of Banking Hackathon 2020Technology stack: NLP (Natural Language Processing), Python, GCP (Google Cloud Platform)

Basel, Basel Stadt, Ch

* Global Data Warehouse for the entire company with focus on Sales, COGS, Inventory and Supply Chain areas, that gathers data from 45+ countries * Planning, modelling and participating in architectural decisions * Building full E2E solution based on Microsoft BI Stack * Dealing with ingestion of data from various source systems (Oracle, SQL Server, Informix, SAP) * Building a BI Portal for various stakeholders like: Management, Sales Department * Coordination of building CI/CD solution based on TFS for the project Technology: SQL Server 2016, MS BI Stack, PowerBI, TFS (Agile, CI/CD), C#, Powershell* Data Quality / Data Monitoring Center Solution for the entire company that leads to increase the quality of the data and gives a better overview over the status of the data quality * Conceptual modelling * Building full E2E solution based on Microsoft BI Stack * Reports about data qualityTechnology: SQL Server 2016, MS BI Stack, PowerBI* Platform for analysing website traffic based on Google Analytics data for Marketing Team. * Participate in all aspects of project as a main responsible person * Data modelling, database development, data ingestion from Google Analytics * Preparation of dashboards in Power BITechnology: SQL Server 2016, MS BI Stack, PowerBI, C#, Google Analytics

Santa Clara, California, Us

Data / DWH / BI concepts:Data WarehousingData VaultMicrosoft:SQL Server 2008R2 / 2012 / 2014 / 2016MS BI stack (SSAS, SSIS, SSRS)MDST-SQL, MDX, DAXPowershellBIMLExcel, Power View, Power PivotPower BISharePoint 2010/2013Azure (VM, Database, Datawarehouse, Storage, Data Lake, Data Factory)C#:General ProgrammingAPS.NETWCFREST APIOracle:Oracle Database 11g/12cPL/SQLDevOps:TFS 2015 - Configuration, Builds & Code CustomisationDWH/BI Continous Integration & Continous Delivery conceptsXebia Labs - XLDeploy, XLReleaseSome notion of BDD (Specflow)Others:Some notion in Data Science area (R & Python languages)and of course:Consulting

Utrecht, Utrecht, Nl

BI Developer in Liquidity Datawarehouse Team - Basel III regulatory framework for banksSQL Server 2012 (SSAS, SSRS, SSIS)T-SQL, MDX, BIMLC#, PowershellBI / DWH DevOps

Warsaw, Mazowieckie, Pl

Business Intelligence ConsultantProject: Data Warehouse migrationTechnologies: Oracle 11g, PL/SQL, SQL Server 2008 R2, T-SQL, SSIS, SSRSDescription: Data Warehouse migration from Oracle 11g into SQL Server 2008 R2Migration included: * understanding data model and migration it into SQL Server; * rewriting all business logic from PL/SQL into T-SQL; * query analysis and optimization; * migration of data loading processes; * migration of the bank reporting platform (rewriting existing reports, creating a new ones)Project: System for automatic orderingTechnologies: SQL Server 2005, SQL Server 2008 R2, T-SQL, SSIS, SSRS, C#Description:Development of a system for automatic ordering. Migration of the whole solution from SQL Server 2005 platform into SQL Server 2008 R2 platformDevelopment of a several adjustments, including: * producing invoice files (FlatFile, XML); * Data-Driven Subscription to Crop Managers; * implementation of EDI standard (Electronic Data Interchange)Project: System for project budgetingTechnologies: SQL Server 2012, T-SQL, SSAS, SSIS, SSRS, MDX, SharePoint 2013Description:Analysis and implementation of a system for project budgetingData model implementationETL layer for processing data from SharePoint lists into databaseCreation of analytical cube and reports for managersCreation of a site in SharePoint (GUI and SharePoint lists)

Warszawa, Woj. Mazowieckie, Pl

Consultant with Business Intelligence specialization.July 2012 - April 2013 : ConsultantJanuary 2012 - July 2012 : Junior ConsultantProject: CRM systemClient: City of WrocławTechnologies: Dynamics CRM 2011, CRM 2011 Online, SQL Server 2012 (T-SQL), SSRS (Reports), FetchXML- Reports developing (FetchXML and T-SQL) in SSRSProject: CRM systemClient: Leasing company (Raiffeisen-Leasing Polska S.A.) Technologies: SQL Server 2008R2 (T-SQL), SSIS (ETL), SSRS (Reports), WCF- Implementation of data batch loading process from several external systems into ODS (Operational Data Store) database, and CRM database.- Participation in data migration analysis- Developing migration processes- Minor reports developing- CRM database optimizationProject: Vindication and Restructuring systemClient: Bank for Corporate Customers (BRE Bank)Technologies: ASP.NET (MVC3), SQL Server 2008R2, EF, WFTechnical demo implementation of a system which supports vindication and restructuring processes for Vindication and Restructuring Department. Project: Data Warehouse and Business IntelligenceClient: Investment Fund Company (PKO TFI)Technologies: SQL Server 2012 (SSIS), Sharepoint 2010, TFS, C#Participation in implementation of a Business Intelligence system and a Data Warehouse for Sales Department.- Participation in analysis of Transfer Agent source database- Implementation ETL packages for DW and staging area- Implementation metadata database for DW & BI Project: Group Insurance applicationClient: Insurance corporation, Financial Services (ING Financial Services, ING Usługi Finansowe)Technologies: SQL Server 2008R2 (T-SQL), Access 2003, VBAImplementation of a system which supports group insurance for Corporate Clients Department.- Analysis of customer's business processes- Design and implementation database structure- Implementation the whole business logic (T-SQL, VBA)- Participation in design and implementation of a GUI (Access 2003)

Amersfoort, Nl

BI Developer in Business Intelligence teamProject: Reporting systemClient: Public transport company (Miejskie Przedsiębiorstwo Komunikacyjne w Krakowie)Technologies: SSRS, Informix 7.3 (SPL)Implementation of a series of reports as a part of reporting system for public transport company in one of the biggest polish city- Reports in SSRS- Stored procedures in Informix (SPL)Project: Business Intelligence systemClient: Insurance company (Liberty Direct)Technologies (1): SQL Server 2008R2, SSISTechnologies (2): C#, WinForms, LINQ, AMO, SMO, CLR, T-SQLTechnologies (3): C#, LINQ, AMO(1)ETL processes implementation as a part of Business Intelligence system for Claims Department.(2)Implementation of an application for testing database queries.(3)Implementation of a series of “add-in” for Visual Studio, which support maintenance lifecycle of Business Intelligence system.

Kraków, Pl

Junior Developer in APUS sector (Administracja Publiczna, Utilities, Samorządy; Public Administration, Utilities, Autonomies)Project: Document workflow applicationClient: Municipal OfficeTechnologies: Python, PostgreSQL, Java SEDevelopment of an application for management documents' workflows for Municipal Office in one of the biggest polish city.Project: CMS portalCustomer: Region Authority OfficeTechnologies: Java EE (Servlets), PostgreSQL, JavaScriptDevelopment of a CMS portal; new functionalities connected with: BIP (Biuletyn Informacji Publicznej, Public Information Bulletin); SAAS pricing model; layoutingMigration to SAAS (Software-as-a-Service) delivery model

Bachelor Of Science (Bsc), Information Technology

Education record