toptal.com
Contact us: +1.888.867.7001
Oleksandr Vasylenko, Data Modeling Developer in Kyiv, Ukraine
Oleksandr Vasylenko

Data Modeling Developer in Kyiv, Ukraine

Member since June 18, 2020
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
    Amazon Web Services (AWS), SQL, Python, Redshift, Amazon S3 (AWS S3), MongoDB
  • Citigroup
    uDeploy, SQL, Oracle Database, SAP BusinessObjects Data Service (BODS), QlikView
  • Oracle
    VirtualBox, SQL, Oracle...

Experience

Location

Kyiv, Ukraine

Availability

Part-time

Preferred Environment

GitHub, Visual Studio Code, SQL

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: Amazon Web Services (AWS), SQL, Python, Redshift, Amazon S3 (AWS S3), MongoDB

  • Senior QlikView Developer

    2014 - 2018
    Citigroup
    • 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: uDeploy, SQL, Oracle Database, SAP BusinessObjects Data Service (BODS), QlikView

  • 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: VirtualBox, SQL, Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE)

  • Database Developer

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

  • 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: Teradata, SQL, SAP BusinessObjects (BO)

  • 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: Teradata, SQL, SAP BusinessObjects (BO)

  • 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: Oracle Database, HTML, PL/SQL, SQL

  • 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 Database, SAP BusinessObjects Data Service (BODS), Oracle, Oracle Application Express (APEX)

Experience

  • QlikView Monitoring Dashboard

    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, Bash Script, Python, Bash, C#, C#.NET, HTML, CSS

  • Tools

    Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Shell, GitHub, VirtualBox, uDeploy, Oracle Application Express (APEX), Amazon ECS (Amazon Elastic Container Service), Tableau

  • Platforms

    Oracle, QlikView, Linux, MacOS, Visual Studio Code, Oracle Data Integrator (ODI), Oracle Database, Amazon Web Services (AWS)

  • Storage

    Database Modeling, PostgreSQL, PL/SQL, Amazon S3 (AWS S3), MongoDB, Teradata, Redshift

  • Other

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

  • 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

To view more profiles

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