Scroll To View More
Piotr Dziubinski, Data Warehousing Developer in Warsaw, Poland
Piotr Dziubinski

Data Warehousing Developer in Warsaw, Poland

Member since December 27, 2016
Piotr is a veteran full-stack developer with over 15 years of experience, mainly focusing on Oracle development. He ie experienced with SQL databases (Oracle, MS, MYSQL, and more) as well as big data. He has worked on the front end and back end—developing with Java, Java EE, HTML, CSS, Angular, JavaScript, Oracle, ETL, DWH, Oracle BI, and many others.
Piotr is now available for hire

Portfolio

  • Roche
    Oracle, PL/SQL, Informatica PowerCenter, Java, Python, HTML, CSS, SAP, SAP ERP
  • Flo Technologies
    Elasticsearch, AWS (EC2, S3), Matillion, Snowflake
  • AGB Nielsen
    Microsoft SQL, BI, MySQL, Tableau, Google Data Studio, Java 8, HTML, CSS...

Experience

  • Oracle PL/SQL, 15 years
  • Database Design, 15 years
  • SQL, 15 years
  • Data Warehousing, 15 years
  • Java, 12 years
  • Informatica PowerCenter, 6 years
  • Snowflake, 3 years
  • Matillion ETL for Redshift, 3 years
Warsaw, Poland

Availability

Part-time

Preferred Environment

All

The most amazing...

...things I've coded were the first radio-streaming service in Poland, a VOD IPTV platform, and my work with native ETL development.

Employment

  • Data Architect | Full-stack Developer

    2018 - PRESENT
    Roche
    • Created ODS and DWH marts.
    • Optimized the DWH performance with Informatica as well as PL/SQL procedures.
    • Standardized the architecture, e.g., naming conventions and so on.
    • Created the software architecture.
    • Developed an SAP Hybris data integration via SAP Data Hub using the ImpEx engine and Java SOAP/REST web services.
    • Built a SAP Hybris Oracle DB data integration and a SAP Hybris flat file data integration.
    • Tuned the performance.
    Technologies: Oracle, PL/SQL, Informatica PowerCenter, Java, Python, HTML, CSS, SAP, SAP ERP
  • Data SaaS Architect

    2019 - 2019
    Flo Technologies
    • Shaped the solution's architecture.
    • Worked with software as a service technologies (SaaS).
    • Collected data.
    Technologies: Elasticsearch, AWS (EC2, S3), Matillion, Snowflake
  • Data Architect | Full-stack SaaS Developer

    2018 - 2018
    AGB Nielsen
    • Optimized the structure of the database this included partitions, indexes, normalization, and many others.
    • Improved the database procedures and SQL queries.
    • Built the back end (Java web services with SQL and NoSQL data sources).
    • Implemented a MongoDB along with the indexing—created structure according to business requirements (business and system analysis and design).
    • Created the MongoDB design and interface as well as API (a source for Tableau).
    • Deployed the product with Apache, PHP, and Tomcat.
    • Implemented Tableau server administration and dashboard development.
    • Created ODS and DWH marts.
    Technologies: Microsoft SQL, BI, MySQL, Tableau, Google Data Studio, Java 8, HTML, CSS, Angular, PHP, Tomcat, Apache
  • Senior DWH Architect

    2016 - 2018
    HypoBank
    • Worked with an Oracle, MS SQL, Informatica Power Center data warehouse.
    • Reported to all bank departments via the intranet.
    • Implemented process analysis and development.
    • Analyzed performances.
    • Performed PL/SQL and Java code optimization.
    • Analyzed and optimized SQL code.
    • Developed intranet reporting tools.
    • Implemented a MS SQL data acquisition.
    Technologies: Oracle, PL/SQL, Informatica PowerCenter, Java, Perl, HTML, CSS, AngularJS, React
  • Freelance Technical Writer (Data-related Topics)

    2017 - 2017
    IOD (via Toptal)
    • Wrote technical advice about Redshift queues and queries optimization.
    • Optimized Redshift user parameters to achieve an optimal performance of big data queries.
    Technologies: Amazon Redshift
  • Analyst | Oracle Developer

    2014 - 2016
    Canal+
    • Built a billing system.
    • Developed a CRM system.
    • Created a rights management system.
    • Performed analysis, development, and optimization of PL/SQL, SQL, and Java code.
    • Design and development of 'Advice System' (for Call Center)  based on Java and MongoDB incl. contextual search based on customer's history and preferences.
    • Developed an internal system (CRM, selling platform, and others) using PL/SQL, Java, AngularJS, CSS, HTML, JavaScript, and some PHP.
    • Created an access management system (Nagra).
    Technologies: Oracle, Java, AngularJS, JavaScript, HTML, CSS
  • Solution Architect | Business Analyst

    2013 - 2014
    Orange S.A. (a telecom)
    • Built an ERP system (industrial and financing system).
    • Developed with Oracle DWH and Oracle OWB.
    • Created a storage and reporting system for whole telecom including a sell forecasting system.
    • Acted as the solution architect of a company joining during Polish telecommunication joint-stock company and Orange S.A.
    Technologies: Oracle, Reporting, Java
  • Technical Adviser to President

    2000 - 2013
    POLSAT
    • Managed and developed a wide range of systems and applications for TV Polsat.
    Technologies: Oracle, Java, MS SQL, TV streaming, ERP, SAP, CRM

Experience

  • WiMAX Project for the Whole Country (Development)

    This project of the WiMAX network covers the whole country area including financial and technical analysis.

  • DataWarehouse and BI Solution for AGB Nielsen (Development)

    I developed a data warehouse and BI solution for AGB Nielsen based on their own DWH architecture and reports; I also used BI.

  • Data Warehouse Design for a Bank (HypoBank) (Development)

    I created the data warehouse design for a bank acquiring data from all of the processing systems.

Skills

  • Languages

    JavaScript, Java, SQL, HTML/CSS, Python, Ruby, T-SQL, Snowflake, Elixir, XHTML, Objective-C, PHP 7, PHP, VB, Visual Basic for Applications (VBA)
  • Frameworks

    Bootstrap, Angular, Swagger, Adobe Flex, Android Bootstrap, Bootstrap 2, Bootstrap 3, Bootstrap 4, JavaServer Faces, JavaServer Pages (JSP), Android SDK, JPA, iOS SDK
  • Tools

    MySQL Workbench, Tableau Desktop Pro, Informatica PowerCenter, Informatica ETL, Flash, Matillion ETL for Redshift, Tableau, AWS SDK, Google Analytics, Oracle Application Express (APEX), Eclipse IDE, Oracle Business Process Management (BPM), Talend ETL, Microsoft Power BI, Adobe Flash, Flash Builder, Microsoft Access, SAP Hybris, GitHub, Subversion (SVN), SoapUI, WinSCP, Bower, Postman
  • Paradigms

    W3C, Database-driven Web App Development, Business Intelligence (BI), ETL, ETL Implementation & Design, Database Design, PRINCE2, REST, Agile Software Development, SOA, Continuous Integration (CI), Continuous Delivery (CD), Continuous Deployment, Oracle ODI
  • Platforms

    Oracle, Azure, Amazon Web Services (AWS), Java EE, Android, JSE, NetBeans, Linux, Azure IaaS, AWS EC2, Windows, iOS, Salesforce
  • Storage

    AWS RDS, SQL Workbench, PostgreSQL, PL/SQL Developer, SQL Server 2012, Microsoft SQL Server, SQL Server 2008, PostgreSQL 10.1, SQL Server 2016, MySQL, SQLite, Oracle 12c, Oracle PL/SQL, JSON, Oracle 11g, PL/SQL, SQL Stored Procedures, Database Modeling, Database Triggers, Oracle Database Tuning, Elasticsearch, Redshift, Databases, Azure SQL, SQL Azure, Google Cloud, Google Cloud SQL, JSON/XML Schemas, MongoDB, AWS S3, NoSQL, SQL Server Management Studio, Azure Queue, Azure SQL Databases, Data Pipelines, RDBMS, Spring Data JPA
  • Other

    Google Data Studio, Data Warehousing, Data Warehouse Design, ETL Development, ITIL V3 Foundation Certified, Database Analytics, Informatica Data Quality, Data Analysis, Database Optimization, SaaS, Software as a Service (SaaS), Big Data, Tableau Server, SOAP, DHTML, Reverse Engineering, Data Visualization, Angular Bootstrap, Financial Data Analytics, SAP, SAP ERP, Pipelines, Oracle RMAN
  • Libraries/APIs

    Spring REST, REST APIs, RESTXQ, React, Node.js, iOS API, jQuery, ReactXP

Education

  • Postgraduate work in Red Hat Administration
    2013 - 2014
    Technical University of Lodz - Łódź, Poland
  • Postgraduate work in Java EE Business Applications
    2012 - 2013
    Technical University of Lodz - Łódź, Poland
  • Postgraduate work in Mechatronics and Information Systems (Java, Oracle, Oracle Warehouse, JSP, PHP, MS-SQL, IBM DB2)
    2010 - 2011
    Technical University of Lodz - Łódź, Poland
  • Master of Business Administration (MBA) degree in Marketing and Management
    2003 - 2004
    Kozminski University - Warsaw, Poland
  • PhD degree in Technical Physics, Information Technology and Applied Mathematics
    1986 - 1988
    Technical University of Lodz - Łódź, Poland
  • Master of Science degree in Electronics (Digital and Analog Devices)
    1981 - 1986
    Technical University of Lodz - Łódź, Poland
Certifications
  • ITIL in IT Management
    OCTOBER 2017 - PRESENT
    APMG International
  • Oracle BI Enterprise Edition
    JULY 2017 - PRESENT
    Oracle
  • Android Certified Application Developer
    JUNE 2015 - PRESENT
    ATC
  • Oracle Certified Professional, Java SE Programmer
    JANUARY 2015 - PRESENT
    Oracle
  • Oracle PL/SQL Advanced
    OCTOBER 2013 - PRESENT
    Comarch
  • RH124 - Red Hat System Administration
    JANUARY 2013 - PRESENT
    Altkom
  • OMG UML Certified Professional
    NOVEMBER 2012 - PRESENT
    OMG
  • Oracle OCA Administration
    NOVEMBER 2012 - PRESENT
    Oracle
  • Prince2
    JULY 2012 - PRESENT
    APMG International
I really like this profile
Share it with others