Krzysztof Lechowski, Relational Database Design Developer in Dublin, Ireland
Krzysztof Lechowski

Relational Database Design Developer in Dublin, Ireland

Member since May 29, 2019
Krzysztof is a successful data engineer, analyst, and entrepreneur who has built many data-centric solutions over the past decade for companies like Santander TFI and Franklin Templeton Investments. He's familiar with a variety of data technologies and combines that knowledge with a thorough understanding of clients' needs to ensure goals are met for each project.
Krzysztof is now available for hire

Portfolio

Experience

  • SQL, 10 years
  • Database Development, 9 years
  • Database Design, 9 years
  • Agile Software Development, 9 years
  • Relational Database Design, 9 years
  • Relational Databases, 9 years
  • Database Modeling, 9 years
  • Linux, 8 years

Location

Dublin, Ireland

Availability

Part-time

Preferred Environment

DataGrip, MS SQL Server Studio, Mercurial, Git

The most amazing...

...DB I've built was an investment professional database for Franklin Templeton Investments that included database modeling, back-end, and front-end development.

Employment

  • IT Consultant

    2017 - 2017
    Franklin Templeton Investments
    • Elicited, understood, and organized business requirements.
    • Guided team members through project phases. Mentored and brought talents to light.
    • Designed the database for the system, and built logic most suitable to be placed in the database layer.
    • Built a significant portion of server-side application logic in PHP with Laravel framework.
    • Built a large portion of the frontend - display layout (Blade, Bootstrap 3, HTML5+CSS3). Added minor JS usability improvements (jQuery UI).
    • Provided timely and clear project status updates.
    Technologies: MySQL, PHP, Python, Laravel, JavaScript, jQuery, MS Access, Excel
  • Senior Research Manager

    2012 - 2017
    Franklin Templeton Investments
    • Coordinated three site teams and directly managed one of them. We were responsible for product data governance, data structures development and the automation of data processes. We managed over 1600 products and over 2,000 data elements.
    • Built several automated ETL processes regarding product data. They filter, merge, reclassify, and restructure the data reducing days of high-skill manual work every month.
    • Designed and built a self-service financial product data extraction system serving over 600 reports per month.
    • Built a travel coordination system for key client-facing personnel, reducing manual work (3x) and producing reporting capabilities.
    • Helped team members to manage business logic residing in MS Access.
    • Recruited, onboarded, trained, and mentored nine team members.
    • Assisted in system demonstrations and trainings.
    Technologies: Tibco Data Virtualization, MySQL, MS Access, MySQL, Python, PHP
  • Business Analyst

    2008 - 2012
    Santander TFI
    • Redesigned mathematical model for trader's bonus system.
    • Learned business processes hands-on.
    • Elicited and managed requirements for a software integration platform.
    • Designed a large proportion of the integration platform database.
    • Developed functions, procedures, and other database objects to meet data process requirements.
    • Developed significant parts of the C# application layer of the integration platform.
    Technologies: MS SQL Server, MS SSIS, C#

Experience

  • hopcar.pl (Development)
    https://hopcar.pl/

    A unique ride-sharing platform. Allows for short and long-distance, single and repetitive ride-sharing in Poland. Full-stack development.

Skills

  • Languages

    SQL, T-SQL, Python, Python 3
  • Paradigms

    Database Design, Database Development, ETL, Agile Software Development, Scrum
  • Storage

    MariaDB, MySQL, PostgreSQL, Database Modeling, Relational Databases, SQL Server Integration Services (SSIS), Microsoft SQL Server, Redshift
  • Platforms

    Linux, Windows, Mac OS
  • Other

    Relational Database Design, Finance, Optimization, Data Reporting, Data Analysis, Data Analytics, Complex Data Analysis, SQL Design & Reporting
  • Tools

    Apache Airflow

Education

  • Master's degree in Economics
    2003 - 2008
    University of Economics in Poznan - Poznan, Poland

To view more profiles

Join Toptal
I really like this profile
Share it with others