Publication
Write Tests That Matter: Tackle The Most Complex Code First
https://www.toptal.com/developers/software/coupling-and-cyclomatic-complexity
Andrey is available for hire
Hire AndreyAndrey Shalitkin
Verified Expert in Engineering
Software Developer
Lisbon, Portugal
Toptal member since June 9, 2016
Bio
Andrey's passion is to help companies become truly data-driven and succeed in business by making correct and informed decisions. He performs consultancy, implements business intelligence solutions, and designs data warehouses using Snowflake, BigQuery, Redshift, DBT, and Looker.
Portfolio
DataProf
Business Intelligence (BI), Amazon Web Services (AWS), Node.js, Redshift...
Maisonette, Inc.
Snowflake, Looker, Data Build Tool (dbt), Data Analysis, Databases...
Aurea
Amazon Web Services (AWS), JavaScript, Python, Java
Experience
- SQL - 9 years
- Amazon Web Services (AWS) - 5 years
- Data Warehousing - 5 years
- Data Warehouse Design - 5 years
- PostgreSQL - 4 years
- Looker - 4 years
- Business Intelligence (BI) - 4 years
- Snowflake - 1 year
Preferred Environment
Git, IntelliJ IDEA, MacOS
The most amazing...
...business intelligence solutions based on Snowflake, DBT, and Looker stack I've implemented from scratch involved management and technical levels.
Work Experience
Managing Partner and Business Intelligence Expert
2016 - PRESENT
DataProf
- Co-founded Togeton.ru and Likeme.chat services.
- Implemented BI solutions for several clients based on Snowflake + DBT + Looker stack.
- Managed multiple teams in the area of BI systems implementation.
Technologies: Business Intelligence (BI), Amazon Web Services (AWS), Node.js, Redshift, Microsoft Power BI, Python, Looker, PostgreSQL, Snowflake, Data Warehouse Design, Data Warehousing, SQL, Data Analytics
Data Analytics Engineers
2021 - 2023
Maisonette, Inc.
- Implemented a BI solution for marketing channel performance tracking. It involved setting up pipelines gathering data from different tracking platforms, joining it with the CRM data, and designing and implementing the dashboards in Looker.
- Designed and implemented data pipelines and a set of dashboards for the website performance, joining this data with the sales information to figure out the correlation.
- Created performance metrics for the DBT project and then refactored the DBT project to simplify it and optimize the data warehouse cost.
Technologies: Snowflake, Looker, Data Build Tool (dbt), Data Analysis, Databases, Data Analytics, ETL, Fivetran, SQL, Business Intelligence (BI), Data Warehouse Design, Data Warehousing
Java Architect
2015 - 2016
Aurea
- 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), JavaScript, Python, Java
Technical Leader | Architect
2013 - 2015
Luxoft
- 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, Servlet, Jakarta Server Pages (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: Java Message Service (JMS), Spring, Java
Experience
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
Clustering Algorithm
An algorithm that is a stack alternative to a recursive one. We have a board of squares called "geoblock." Each square or geo can be filled, owned, or not. If two squares have the same edge, then they belong to the same cluster. The algorithm does such clusterization.
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
https://likeme.chat/I developed a type of dating service. You can see more at the link attached.
Education
2007 - 2011
PhD Degree in Computer Science
Voronezh State University - Voronezh, Russia
2002 - 2007
Master's Degree in Computer Science
Voronezh State University - Voronezh, Russia
Skills
Libraries/APIs
JDBC, Spring REST, Node.js, Pandas, Java Message Service (JMS)
Tools
Looker, Subversion (SVN), Git, IntelliJ IDEA, Servlet, Apache Tomcat, Jira, Hudson, Cucumber, Microsoft Power BI
Languages
SQL, Java, Snowflake, JavaScript, Groovy, Python
Frameworks
Mockito, JUnit, AngularJS, Spring, Jakarta Server Pages (JSP), JPA, PowerMock
Paradigms
Business Intelligence (BI), Agile, Functional Programming, Scrum, ETL
Storage
Redshift, PostgreSQL, Oracle RDBMS, NoSQL, MongoDB, Databases
Platforms
MacOS, Oracle, Amazon Web Services (AWS)
Other
Data Warehousing, Data Warehouse Design, BPM, Data Build Tool (dbt), Data Analysis, Data Analytics, Fivetran, Algorithms, Clustering, Clustering Algorithms
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring