Andrey Shalitkin, Data Warehouse Design Developer in Lisbon, Portugal
Andrey Shalitkin

Data Warehouse Design Developer in Lisbon, Portugal

Member since August 5, 2015
Andrey is an IT specialist with over 12 years experience in different business streams including eCommerce, real estate, and investment banking. Since 2016, he's been mostly working in the data engineering and BI technical areas specializing on cloud solutions.
Andrey is now available for hire


  • DataProf
    Business Intelligence (BI), Amazon Web Services (AWS), Node.js, AWS, Redshift...
  • Aurea
    Amazon Web Services (AWS), AWS, JavaScript, Python, Java
  • Luxoft
    Oracle RDBMS, Spring, AngularJS, JavaScript, Groovy, Java



Lisbon, Portugal



Preferred Environment

Git, IntelliJ IDEA, MacOS

The most amazing...

...project was leading a team to create a service from scratch.


  • Co-founder

    2016 - PRESENT
    • Co-founded and services.
    • Implemented a BI solution (as part of a team) based on AWS stack for a NY-based startup.
    • Managed multiple teams in the area of BI systems implementation.
    Technologies: Business Intelligence (BI), Amazon Web Services (AWS), Node.js, AWS, Redshift, Microsoft Power BI, Python, Looker, SQL
  • Java Architect

    2015 - 2016
    • Successfully implemented a project of integration of BPM product with the monitoring system.
    • Made a significant contribution to the project of the product virtualization in the AWS cloud by creating a central logging mechanism.
    • Performed a codebase analysis for a legacy codebase and identified the most critical parts of the system that allowed to create efficient test coverage strategy; used Python for this project.
    Technologies: Amazon Web Services (AWS), AWS, JavaScript, Python, Java
  • Technical Leader | Architect

    2013 - 2015
    • Built, along with my colleagues, a new web component based on Spring REST and AngularJS.
    • Implemented a Groovy-based validation framework that allowed us to control almost all UI behavior via rules invoked from the back end.
    • Performed architectural refactoring to transform the existing component from monolithic to SOA.
    • Led (technically) five distributed development teams working on financial regulatory requirements.
    • Ported reporting rules from AbInitio to IBPM rules with a Java intermediary.
    Technologies: Oracle RDBMS, Spring, AngularJS, JavaScript, Groovy, Java
  • Leading Software Developer

    2010 - 2013
    Luxoft Russia
    • Developed an ETL-like tool to get IB clients data from external sources.
    • Participated in "small changes" project fixing a lot of bugs, doing minor functional changes, and a lot of refactoring in the existing Workflow tool for client onboarding.
    • Integrated multiple existing components via REST and WS within a new business process (implemented in IBM BPM) for a client account creation.
    Technologies: BPM, Servlets, JSP, Oracle RDBMS, Spring, Java
  • Software Developer

    2006 - 2010
    Siemens IT Solutions and Services
    • Developed, as part of a team, a communication system for the Siemens Buyside Marketplace. The biggest part was to integrate with third-party solutions.
    • Developed a web application for JMS messages monitoring and troubleshooting.
    • Implemented documentation generation module based on UML for a MDA solution (open architecture ware).
    • Participated in the portlet development for a portal for a big communications company.
    Technologies: JMS, Spring, Java


  • Virtualization of an Existing Product

    The project virtualized an existing product in AWS with minimal changes to the product itself. We had to solve such problems as centralized logging, configuration updates, and to make each node autonomous.

  • Web Tool

    I led a team that created a new web tool. The purpose of the tool was to make the first engagement with the IB clients and monitor activities happening during the whole onboarding process.

  • Porting of Financial Regulatory rules

    I led a team that did reverse engineering of existing rules in Ab Initio and ported them to the IBM rules with a Java intermediary.

  • ETL Tool

    As a development team member, I participated in the project where we need to build a system loading IB (Investment Bank) client information from external sources, applied some validation, transformation and matching rules and saving the data into the MDM (Master Data Management) system

  • Architectural Refactoring

    I performed architectural refactoring to transform an existing monolithic component to SOA architecture

  • Togeton

    It's a service for self-employed people in the beauty area that helps them to easily manage their schedules and provide clients with some kind of self-service.

  • Data Warehouse

    A data warehouse in AWS cloud based on Redshift and DBT

  • BI Implementation

    I developed a BI management system by the means of Looker on top of a Redshift data warehouse.

  • Dating Service

    I developed a type of dating service. You can see more at the link attached.

  • Write Tests That Matter: Tackle The Most Complex Code First (Publication)
    In today's world, code is expected to change as quickly as requirements do, and tests play an important role in making that possible. Many modern projects boast great test coverage, making them more resilient to regression issues. However, that is not true for all projects - especially some legacy projects which have little in the way of testing. In this article, Toptal Freelance Software Engineer Andrey Shalitkin discusses two metrics, coupling and cyclomatic complexity, that are important in identifying which portions of code to include in test coverage.


  • Languages

    SQL, Java, Snowflake, JavaScript, Groovy, Python
  • Frameworks

    Mockito, JUnit, AngularJS, Spring, JSP, JPA, PowerMock
  • Tools

    Looker, Subversion (SVN), Git, IntelliJ IDEA, Apache Tomcat, Jira, Hudson, Cucumber, Microsoft Power BI
  • Paradigms

    Business Intelligence (BI), Agile, Functional Programming, Scrum
  • Other

    Data Warehousing, Data Warehouse Design, AWS, Servlets, BPM
  • Libraries/APIs

    JDBC, Spring REST, Node.js, Pandas, JMS
  • Storage

    Redshift, PostgreSQL, Oracle RDBMS, NoSQL, MongoDB
  • Platforms

    MacOS, Oracle, Amazon Web Services (AWS)


  • PhD Degree in Computer Science
    2007 - 2011
    Voronezh State University - Voronezh, Russia
  • Master's Degree in Computer Science
    2002 - 2007
    Voronezh State University - Voronezh, Russia

To view more profiles

Join Toptal
Share it with others