Scroll To View More
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
Oleksandr Vasylenko, SQL Developer in Kyiv, Ukraine
Oleksandr Vasylenko

SQL Developer in Kyiv, Ukraine

Member since July 17, 2018
Alex has over 15 years of database development experience working in various roles (ETL, business intelligence, analyst) in large corporate data warehouse projects. Over the course of his career, he has developed strong analytical skills and the ability to get necessary data from any data source in any required form.
Oleksandr is now available for hire
Hire Oleksandr

Portfolio

  • Xenial
    MongoDB, S3, RedShift, AWS, Python, SQL
  • Citi
    QlikView, SAP Business Objects, Oracle Database, SQL, uDeploy
  • Oracle
    OBIEE, Oracle DB, SQL, Virtual Box

Experience

  • Database Modeling, 15 years
  • Data Modeling, 15 years
  • SQL, 15 years
  • Oracle, 15 years
  • SAP BusinessObjects (BO), 10 years
  • QlikView, 4 years
  • Oracle Business Intelligence Enterprise Edition 11g (OBIEE), 3 years
Kyiv, Ukraine

Availability

Part-time

Preferred Environment

SQL Developer, Visual Studio Code, GitHub

The most amazing...

...thing I've coded was a mathematical model to build a social network simcard to determine churn possibility & distinguish alpha leaders for marketing promotions.

Employment

  • Big Data Architect

    2018 - PRESENT
    Xenial
    • Designed, developed, and optimized data warehouses.
    • Worked on the full cycle of ETL; including development and performance optimization and custom data transformation.
    • Architected database designs.
    • Wrote business reports and developed dashboards.
    • Trained, mentored, and implemented best-practice policies for the team.
    Technologies: MongoDB, S3, RedShift, AWS, Python, SQL

  • Senior QlikView Developer

    2014 - 2018
    Citi
    • Developed QlikView dashboards as part of a larger effort with a team using Scrum methodology.
    • Spearheaded requirements analysis.
    • Built QVD feeds.
    • Created data models and visualizations.
    • Provided thorough documentation for solutions and processes as well as implemented data quality assurance.
    Technologies: QlikView, SAP Business Objects, Oracle Database, SQL, uDeploy

  • Senior BI Presale Developer

    2011 - 2014
    Oracle
    • Provided technical support for presale activities.
    • Developed and demonstrated various types of proof of concept (POC).
    • Created customer presentations and demonstrated the products while attending forums and conferences.
    • Developed and conducted workshops and trainings.
    Technologies: OBIEE, Oracle DB, SQL, Virtual Box

  • Database Developer

    2010 - 2011
    Teradata
    • Implemented a social network activity project.
    • Created technical specification designs.
    • Wrote solution documentation.
    • Designed and verified ETL scripts.
    Technologies: SQL, PL/SQL, ODI, Teradata Database

  • BI Architect

    2008 - 2010
    Teradata
    • Implemented data warehouses.
    • Created BI architecture designs.
    • Built data models.
    • Designed and developed a business objects universe.
    • Developed web reports.
    • Planned and reviewed tasks.
    Technologies: SAP BO, SQL, Teradata Database

  • BI Developer

    2007 - 2008
    Teradata
    • Implemented data warehouses.
    • Conducted requirements analyses.
    • Designed the technical specifications.
    • Tracked and fixed bugs.
    • Wrote solution documentation.
    • Created data models.
    Technologies: SAP BO, SQL, Teradata Database

  • Freelance Engineer

    2005 - 2007
    Freelance Work
    • Provided data for analytical departments.
    • Gathered user requirements.
    • Developed reports.
    • Worked with billing statistics.
    • Created data models.
    • Implemented SQL tuning and developed with PL/SQL.
    Technologies: SQL, PL/SQL, Oracle HTML Database, Oracle Database

  • Database Developer

    2003 - 2005
    Citia BTC
    • Implemented an automated budgeting system for the bank.
    • Implemented a mathematical model.
    • Worked on database development.
    • Designed ETL scripts and specifications.
    Technologies: Oracle Express, Oracle Financial Analyzer, SAP Business Objects, Oracle DB

Experience

  • QlikView Monitoring Dashboard (Development)

    A dashboard which enables the user to monitor the reload status of a number of other QlikView dashboards. It needed to be able to crawl by the folder structure to find the logs for each of located dashboards, parse them, and store the gathered data in an internal database. The dashboard also provided info visualizations on the statuses and found errors for each dashboard for the whole monitoring period.

Skills

  • Languages

    SQL, Python, Bash, C#, C#.NET, HTML, CSS

  • Tools

    Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Shell, AWS ECS, Tableau

  • Platforms

    Oracle, QlikView, Linux, MacOS

  • Storage

    Database Modeling, SQL Developer, PostgreSQL, PL/SQL, MongoDB, Teradata, Redshift

  • Other

    SAP BusinessObjects (BO), Data Modeling, Shell Scripting, Bash Scripting, Oracle VM VirtualBox

  • Paradigms

    Agile, Scrum, Kanban, REST

  • Frameworks

    .NET

  • Libraries/APIs

    API Development

Education

  • Master's degree in Applied Mathematics
    2004 - 2006
    National Technical University of Ukraine “Kyiv Polytechnic Institute” - Kyiv, Ukraine
  • Bachelor's degree in Applied Mathematics
    2000 - 2004
    National Technical University of Ukraine “Kyiv Polytechnic Institute” - Kyiv, Ukraine
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
To view more profiles, join ToptalJoin Toptal
I really like this profile
Share it with others