Marek Rozenbajger, Software Developer in Gdańsk, Poland
Marek Rozenbajger

Software Developer in Gdańsk, Poland

Member since July 13, 2016
For nearly a decade, Marek has been working as a software engineer in relational database design, and for the past five in data modeling, solution architecture, and C#.NET programming. Among the companies he has worked for are BP Global., W. Capra Consulting Group, Inc., Capgemini, and Nordea. Marek is a professional who enjoys sharing his technical expertise and has had experience working in teams distributed around the globe.
Marek is now available for hire

Portfolio

Experience

Location

Gdańsk, Poland

Availability

Part-time

Preferred Environment

Git, Visual Studio, Windows Server, Microsoft SQL Server

The most amazing...

...thing I've worked on was a data warehouse that captured the activity of 80,000 PCs and 200,000 users.

Employment

  • Business Intelligence Consultant

    2016 - PRESENT
    UBS
    • Worked for UBS and the nature of the work is subject to NDA.
  • Database Consultant

    2018 - 2018
    The Dominion Group
    • Created a custom add-in for Excel 2010 and above. The add-in provides a set of functions that pull data from remote PostgreSQL instance, over the Internet.
    • Tested the product with different Microsoft Office versions: 2010, 2016, 2019, 365.
    • Prepared documentation: PDF and videos.
    • Answered users queries and provided support.
    Technologies: Microsoft Excel, PostgreSQL, Excel-DNA
  • Software Developer

    2017 - 2018
    Motorola Solutions
    • Designed and implemented a Windows service for monitoring Active Directory updates.
    Technologies: C#, SQLite, Azure Active Directory
  • Database Consultant

    2016 - 2016
    Nordea Group
    • Carried out an audit of a bespoke database system.
    • Implemented a feasibility study of new requirements and risk analysis.
    • Provided a review of the system to the management of the project.
  • Data Architect | Solution Architect

    2012 - 2016
    BP p.l.c.
    • Designed and had a key role in the implementation of a user-and-workstation-activity data warehouse; specifically a management information class system. Its purpose was to help the company to improve its business processes, operations, and financial efficiency by providing reports and data for analysis. The scope of the product were the end users, workstations, and IT services.
    • Created and implemented the system architecture, database back-end, and the ETL and WCF API design.
    • Developed the modeling process which concentrated on UML (use case, class, sequence diagrams) as well as data flow, and entity-relationship diagrams.
    • Built a database component that involved advanced programming features of Microsoft SQL Server such as a CLR integration, distributed transactions, and XML processing.
    • Designed and managed the implementation of a self-service intranet site for managing IT services (such as mailboxes, user accounts, distribution lists, and VPN tokens) for 80,000 employees. The purpose of the site was to support the ITIL processes.
    • Designed and implemented the system architecture, database design, integration with external systems (LDAP, SOAP web services, REST web services, ODBC), WCF API of the back-end component and long-running workflows.
    • Built a system using Windows Server 2008 R2 Standard, WCF SOAP web services, and an active directory with Kerberos authentication, IIS AppFabric 1.1, and C#.NET 4.0.
    • Prepared documentation for the client.
    • Liaised with client's technical authorities and infrastructure managers.
    Technologies: C#.NET, Azure Active Directory, Windows Server, Microsoft SQL Server
  • Database Administratior | SQL Developer

    2008 - 2012
    BP p.l.c.
    • Migrated a reporting platform from the Microsoft SQL Server 2000 to the 2005 version and later to 2008 R2.
    • Designed and implemented new data feeds into the reporting system.
    • Designed new reports for mid-level managers and enriched the existing ones with additional data.
    • Maintained and adapted the system to new requirements and a changing environment.
    Technologies: VB, C#, Microsoft SQL Server
  • Microsoft Access Database Developer

    2006 - 2008
    Ideal Shopping Direct
    • Developed applications for stock control, EDI, work time and performance monitoring with Microsoft Access (VBA) and Microsoft SQL Server (backend).
    • Created reports from the collected data with Microsoft Access and Excel (automatic generation of spreadsheets from VBA code).
    Technologies: SQL Server 2000, Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA)

Skills

  • Languages

    Transact-SQL, T-SQL, SQL, UML, C#, C#.NET, VB, MDX, Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET)
  • Tools

    Microsoft Access, SSRS, SSAS, Visual Studio, Excel-DNA, Microsoft Excel, Microsoft Visual Studio, TeamCity, GitHub, Git, Subversion (SVN), YouTrack
  • Storage

    Database Modeling, Relational Databases, SQL Server Data Tools (SSDT), SQL Server 2008, SQL Server 2005, Azure Active Directory, SQL Server 2014, SQL Server 2012, SQL CLR, Microsoft SQL Server, SQLite, PostgreSQL, SQL Server Service Broker, Database Administration, SQL Server Integration Services (SSIS), Database Replication, SQL Server 2000
  • Frameworks

    Windows Communication Framework (WCF), Windows PowerShell, .NET 4, .NET
  • Paradigms

    Object-oriented Design (OOD), Object-relational Mapping (ORM), Concurrent Programming, Kimball Methodology, Test-driven Development (TDD), Continuous Integration (CI), OLAP
  • Other

    Kerberos, LDAP, Data Warehouse Design, Sparx Enterprise Architecture, IIS 7, IIS 8, IIS, SOAP
  • Libraries/APIs

    ODBC, SQLite.NET
  • Platforms

    Windows Server, Windows Server 2008, Windows Server 2012

Education

  • Bachelor's degree in Computer Science
    2008 - 2012
    The School of Banking and Management in Kraków - Kraków, Poland

Certifications

  • MCP: Windows Server
    JANUARY 2010 - PRESENT
    Microsoft
  • MCTS: SQL Server 2008
    JANUARY 2010 - PRESENT
    Microsoft
  • ITIL Foundation
    JANUARY 2009 - PRESENT
    Asseco Data Systems

To view more profiles

Join Toptal
Share it with others