Scroll To View More
Josip Šaban, Project Management Professional (PMP) Developer in Zagreb, Croatia
Josip Šaban

Project Management Professional (PMP) Developer in Zagreb, Croatia

Member since November 9, 2016
Josip is an experienced database guy who's developed websites, created banking DWH systems, and led development teams to deliver great products which are still in production today. He has advanced knowledge of the entire SQL Server stack and working knowledge of .NET, Business Objects, R, BizTalk, Microsoft Project, and MS Project Server. Along with his primary expertise, he is also a proficient technical writer and team lead.
Josip is now available for hire

Portfolio

  • Erste Group IT
    SharePoint, Microsoft Office, Tableau, Oracle PL/SQL, SAP PowerDesigner
  • Hypo Alpe Adria
    SQL Server, SAP Business Objects, Tableau
  • Oikon
    SQL Server, SharePoint, .NET

Experience

  • Microsoft Office, 15 years
  • SQL, 12 years
  • Waterfall Development, 10 years
  • Microsoft SQL Server, 10 years
  • C#, 8 years
  • .NET, 5 years
  • Microsoft Project, 5 years
  • Project Management Professional (PMP), 2 years
Zagreb, Croatia

Availability

Part-time

Preferred Environment

SQL Server Management Studio, Visual Studio

The most amazing...

...thing I've done was to redesign an old database design—increasing the performance tenfold while adding many new features on top.

Employment

  • Lead BI Architect | Team Lead

    2015 - PRESENT
    Erste Group IT
    • Planned and supervised the IT education and summer student program.
    • Led proof-of-concept activities for testing new technologies and/or development methodologies.
    • Served the role of single point of contact for all the demand activities of two major clients.
    • Analyzed new technologies and products during the vendor selection process.
    • Created IT recruiting tests and held interviews.
    Technologies: SharePoint, Microsoft Office, Tableau, Oracle PL/SQL, SAP PowerDesigner
  • Senior Business Intelligence Analyst

    2013 - 2015
    Hypo Alpe Adria
    • Analyzed and documented business requests.
    • Developed the implementation strategy and BI architecture, based on SQL Server technology stack.
    • Managed and executed IT projects and successfully led a team of consultants.
    • Conducted hands-on development of important and/or more complex database modules.
    • Held education sessions for internal company employees.
    • Deployed new features to production and effectively fulfilling the role of a release manager.
    Technologies: SQL Server, SAP Business Objects, Tableau
  • Software Engineer

    2011 - 2013
    Oikon
    • Built analytic modules in SQL Server (SSIS).
    • Developed web pages using ASP.NET MVC.
    • Implemented a SharePoint modification according to specific business user needs.
    • Managed EU projects specifically on parts of IT implementation.
    • Took part in internal company education events.
    Technologies: SQL Server, SharePoint, .NET
  • Business Intelligence Consultant

    2009 - 2011
    Alfatec Group
    • Worked as the team lead in the project of creating a new data warehouse for one of the largest banks in the country, based on Oracle and Data Integrator.
    • Implemented a business-objects reporting system in the third largest tobacco company in the world.
    • Developed a first production-level data warehouse in the cargo and shipping industry in the region, using SQL Server Analysis Services and PowerPivot.
    • Created teams and ensured that people worked effectively together.
    • Held internal and external educational sessions.
    Technologies: BO Data Integrater, Oracle, SQL Server
  • Business Intelligence Consultant

    2007 - 2009
    CrmT
    • Designed and developed a web solution for distribution of EU funds in Slovenia based on SQL Server and ASP.NET.
    • Designed and developed a high-availability DWH solution for parsing, testing, and reporting on call records for the largest Slovenian telecom.
    • Organized the company's presales technical conference, focusing on Business Objects and SQL Server.
    Technologies: ASP.NET, Informatica, SQL Server
  • Software Engineer

    2004 - 2007
    IN2
    • Developed an ASP.NET application for primary health care.
    • Implemented BizTalk, as a part of a key integration project in the country's largest telecom company.
    • Constructed a web application for the country's chamber of commerce.
    • Held technical education sessions for the company's junior staff.
    Technologies: ASP.NET, SQL Server, BizTalk

Experience

  • Development and Analysis | Johnson & Johnson (via Toptal) (Development)
    https://www.jnj.com/

    This project required knowledge of a wide technology stack (Excel/VBA, Access, SQL database, Salesforce, and Qlik) and analysis of the existing business process.

    My role, as part of the reporting department, was to get myself up to date with the existing setup, propose improvements, and develop modules that would support new requirements of the marketing and sales departments. The work focused on updating the reporting/database solutions and to remove the use of Excel, as much as possible in daily business operations.

  • Schneider Electric (via Toptal) (Development)
    https://www.schneider-electric.com/ww/en/

    This project required the creation of migration scripts from an existing SQL Server database to a new installation of SQL Server database. As users on the other side were not very familiar with this technology, the project included very detailed documentation so that they can do some easier modifications on their own without any specialized support. Also created a proof-of-concept on how to use Azure PowerBI instead of Excel reporting.

  • Life Church (via Toptal) (Development)
    https://www.life.church/

    On this project, my role was as the data warehousing expert—working on the SQL Server and I was ultimately responsible for designing data warehouse tables. I also implemented the ETL processes using SSIS and SQL and optimized the existing data warehouse loading procedures.

  • Technical Writer for Project Management (via Toptal) (Development)
    http://sterlingcapitalbrokers.com/

    I wrote a software development lifecycle guide (SDLC) for a software company that needed to map its development processes in a formal document.

  • American Taekwondo Association (via Toptal) (Development)
    http://www.ataonline.com/

    For this project, I worked on the migration of an existing web application. My tasks were making sure that the Oracle database was properly migrated to a new SQL Server to support a newly purchased solution. I did everything from analysis, implementation, testing, and finally cutover procedures.

  • Briefing: The Data Warehouse (Development)
    https://www.toptal.com/insights/future-of-work/briefing-the-data-warehouse

    While often overlooked, the data warehouse enables companies to reveal valuable insights concealed within their vast data troves. In this article, as a domain expert, I share foundational principles and applications that are essential knowledge for all modern managers.

  • Blog: SQL Server 2016 Always Encrypted (Other amazing things)
    https://www.toptal.com/sql-server/sql-server-2016-always-encrypted

    Data is a key asset of any company, particularly transactional data which holds business secrets such as financial or health records. Data is most vulnerable in transit between the server that stores it and that client that requests it.

    The standard approach to ensuring security is to encrypt data on the server and use the SSL-enabled HTTPS protocol to secure data in transport. However, what if we could increase the level of security even further, by using HTTPS and sending data in an encrypted format over the communication line, only to decrypt data on clients who have valid certificates? That approach would make a traditional man-in-the-middle (MITM) attack much more difficult.

    Microsoft’s solution to this problem is Always Encrypted, a way to send encrypted data over the pipeline and decrypt it only by users with access to valid certificates. So, even if the attacker gets the data, without a proper certificate stored on the client machine, the data would be useless.
    This article describes how to set up and use Always Encrypted, and it’s recommended reading for anyone who is sending important data over the public communication lines, even if they are secured with SSL.

  • SQL Server 2016 Always Encrypted: Easy to Implement, Tough to Crack (Publication)
    Security has always been a primary concern for database experts, and with the advent of new, decentralized services, it’s become even more crucial. Microsoft addressed the need for an added level of security in SQL with the introduction of Always Encrypted functionality in SQL Server 2016. In this blog post, Toptal Freelance Software Engineer Josip Saban explains how Microsoft’s Always Encrypted concept works, how it’s implemented, and why developers can’t afford to ignore it.

Skills

  • Languages

    SQL, T-SQL, C#, R
  • Tools

    Microsoft Project, Tableau, Microsoft Office, Microsoft Power BI
  • Paradigms

    Waterfall Development, Agile
  • Storage

    Microsoft SQL Server, RavenDB, Azure SQL, PostgreSQL
  • Other

    Business Analysis, Team Leadership, Project Management Professional (PMP), Quality Assurance (QA), Microsoft Project Server, Project Management, BizTalk, Informatica, ITIL V3 Foundation Certified, SAP BusinessObjects (BO)
  • Frameworks

    .NET
  • Platforms

    Oracle, SharePoint, Azure

Education

  • Master of Business Administration (MBA) degree in General Management
    2011 - 2012
    COTRUGLI Business School - Zagreb, Croatia
  • Master of Science degree in Computing
    1998 - 2004
    University of Zagreb, Faculty of Electrical Engineering and Computing - Zagreb, Serbia
Certifications
  • Project Management Professional (PMP)
    SEPTEMBER 2017 - PRESENT
    PMI Institute
  • ITIL Foundation V3
    JUNE 2014 - PRESENT
    Axelos
I really like this profile
Share it with others