toptal.com
Contact us: +1.888.867.7001
Sebastian Więckowski, Business Analyst and Software Developer in Warsaw, Poland
Sebastian Więckowski

Business Analyst and Software Developer in Warsaw, Poland

Member since August 31, 2021
Sebastian is an experienced business analyst and developer in the data warehouse and integration area. He has a background in financial instruments, banking, and telecom sectors. Sebastian held technical analyst, developer, business analyst, and IT project management positions during his career.
Sebastian is now available for hire
Hire Sebastian

Portfolio

  • SimCorp
    Investment Banking, Financial Data, Finance, Financial Institutions...
  • Deutsche Bank
    Oracle, Workflow, UML, Visio, IT Business Analysis, Systems Analysis...
  • StatConsulting (Project for Plus)
    SAS, SQL, Teradata SQL Assistant, Teradata Databases, SAS Enterprise Guide...

Experience

  • SQL 15 years
  • Oracle 12 years
  • IT Business Analysis 11 years
  • Reporting 10 years
  • Financial Data 9 years
  • Systems Analysis 7 years
  • SQL Performance 6 years
  • PL/SQL 5 years

Location

Warsaw, Poland

Availability

Part-time

Preferred Environment

Windows, Oracle, SAS, Enterprise Architecture, SimCorp, Toad, Visio

The most amazing...

...was data mart I've designed and developed covered the whole reporting for the biggest telecom company in Poland in warehouse management, wholesale, and retail.

Employment

  • Business Consultant

    2017 - 2021
    SimCorp
    • Built integration for two central banks between SimCorp Dimension and their internal systems as well as external counterparties. Worked from clarification and design phase, implementation, and support during UAT.
    • Enhanced, maintained, and customized the interface to IHS Markit for OTC instruments confirmation for client's needs. The interface allows the OTC trade confirmation process to be fully automated.
    • Implemented interfaces during SimCorp Dimension implementation projects using SimCorp's communication server, filter toolbox, data extractor, and data import.
    • Built an interface to import financial positions managed by external managers into SimCorp Dimension for a Reserve Fund led by a European government. The interface transformed and imported data from various sources.
    Technologies: Investment Banking, Financial Data, Finance, Financial Institutions, Securities, Derivatives, XML, XSLT, SQL, Message Queues, Oracle, APIs, ETL, Crystal Reports, Integration, Data Integration, Dashboards, Data-driven Dashboards, REST APIs, Office 365

  • Business Analyst | IT Project Manager

    2012 - 2017
    Deutsche Bank
    • Served as a business analyst and IT project manager for the loan application supporting system project. I was accountable for the project budget, plan, and schedule, reporting the steering committee's project and financial status.
    • Acted as a business analyst during the wealth management system implementation that consolidates all client's investments view and supports investment advisors' decisions about the client's portfolio.
    • Analyzed business requirements and designed changes in the data warehouse and the data marts. Supported business units during UAT.
    • Worked as a business analyst and IT project manager during the implementation of a commission and incentive system.
    Technologies: Oracle, Workflow, UML, Visio, IT Business Analysis, Systems Analysis, IT Project Management, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), SQL, ETL, Databases, Data Marts, Kimball Methodology, Microsoft Excel, Microsoft Access, Excel 2010, Excel 2013, Excel 2007, Architecture, Data Architecture

  • Data Warehouse Engeneer

    2009 - 2011
    StatConsulting (Project for Plus)
    • Developed and maintained the analysis platform containing data marts and reports.
    • Supported business users by gathering and analyzing requirements, designing and developing reports in Teradata or SAS.
    • Developed and maintained reports for the controlling department and top management.
    Technologies: SAS, SQL, Teradata SQL Assistant, Teradata Databases, SAS Enterprise Guide, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), Databases, Data Analytics, Data Analysis, Database Management, Excel 2010, Microsoft Access, Microsoft Excel

  • Senior ERP System Analyst

    2007 - 2009
    Orange
    • Built an integration layer in Oracle PL/SQL between the ERP and warehouse management systems.
    • Supported business users by gathering and analyzing requirements, designing changes, and working with the system vendor to implement changes.
    • Performed unit and integration testing changes delivered by the system vendor and supported business users during the UAT phase.
    Technologies: SQL, PL/SQL, IFS System, UML, Enterprise Architecture, Databases, Database Schema Design, Oracle

  • Data Warehouse Engeneer

    2005 - 2006
    Orange
    • Designed and developed a data mart covering the whole reporting for the biggest telecom company in Poland in areas like warehouse management, wholesale, and retail sales.
    • Built many SQL and PL/SQL-based reports for various business areas like marketing, finance, warehouse management, and billing.
    • Tuned many existing cyclical SQL reports, significantly improving their performance.
    Technologies: Oracle, SQL, PL/SQL, SQL Performance, Data Warehouse Design, Data Warehousing, Business Intelligence (BI), Databases, Database Architecture, Data Analytics, Data Analysis, Database Schema Design, Database Management, Database Management Systems (DBMS)

Experience

  • Central Bank Reserve Management System Integration

    I implemented interfaces integrating the SimCorp Dimension system for two central banks. I integrated SimCorp Dimension with the bank's internal systems as well counterparties systems. I was working from the clarification and design phase, implementation, and supporting users during UAT.

  • Data Marts and Reporting Project

    I have designed and developed data marts covering the whole reporting for the biggest telecom company in Poland in warehouse management, wholesale, and retail. I worked as an analyst and developer on that project.

  • Regulatory Changes in The Mortgage Application System

    I completed a project with regulatory changes in the mortgage application system, working as the IT project manager. The deadline to implement changes was very short, and we were able to meet it. Completing the project in time allowed the bank to continue selling mortgages

  • B2B Portal Project

    I worked as a business and system analyst to implement B2B portal in Orange, Poland. A vendor delivered the system. My role was to analyze internal client-specific requirements and work with the vendor to implement them. I was also responsible for unit test the whole system and supporting business units during UAT.

Skills

  • Languages

    SQL, SAS, UML, XML, XSLT, C++, Java, C, ABAP

  • Paradigms

    Kimball Methodology, Business Intelligence (BI), Database Design, ETL, Testing, PRINCE2, Agile Project Management, ITIL, User Acceptance Testing (UAT), B2B

  • Storage

    SQL Performance, PL/SQL, Databases, Teradata Databases, Microsoft SQL Server, Database Architecture, Data Integration, MySQL, Database Management, Database Management Systems (DBMS)

  • Other

    IT Business Analysis, SimCorp Dimension Connectivity, Data Warehousing, Data Analytics, Data Analysis, Data Marts, Business Analysis, SimCorp, Systems Analysis, Financial Institutions, Securities, SimCorp Dimension, Reporting, Data Architecture, Data Warehouse Design, Database Schema Design, Excel Expert, Enterprise Architecture, Decision Support Systems, SAP, IFS System, Workflow, IT Project Management, Investment Banking, Financial Data, Finance, Derivatives, Message Queues, APIs, Communication Server, Financial Market Data, Integration, Dashboards, Data-driven Dashboards, Vendor Management, Architecture, Office 365

  • Tools

    Toad, Excel 2010, Microsoft Excel, Excel 2013, Excel 2007, Visio, MATLAB, Teradata SQL Assistant, SAS Enterprise Guide, Crystal Reports, Microsoft Access

  • Platforms

    Oracle, Windows

  • Libraries/APIs

    REST APIs

Education

  • Master's Degree in Computer Science
    2002 - 2008
    Warsaw University of Technology - Warsaw, Poland

Certifications

  • SimCorp's Certified Connectivity Specialist
    OCTOBER 2017 - PRESENT
    SimCorp
  • Simcorp's Certified Reporting Specialist
    SEPTEMBER 2017 - PRESENT
    SimCorp
  • SimCorp Dimension Specialist
    SEPTEMBER 2017 - PRESENT
    SimCorp
  • Agile Project Management Foundation
    SEPTEMBER 2015 - PRESENT
    APMG International
  • PRINCE2 Practitioner
    MAY 2014 - MAY 2019
    APMG International
  • PRINCE2 Foundation
    JUNE 2013 - PRESENT
    APMG International
  • ITIL Foundation
    SEPTEMBER 2012 - PRESENT
    EXIN

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM