Managing Partner and Business Intelligence Expert
2016 - PRESENTDataProf- 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 AnalyticsData Analytics Engineers
2021 - 2023Maisonette, 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 WarehousingJava Architect
2015 - 2016Aurea- 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, JavaTechnical Leader | Architect
2013 - 2015Luxoft- 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, JavaLeading Software Developer
2010 - 2013Luxoft 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, JSP, Oracle RDBMS, Spring, JavaSoftware Developer
2006 - 2010Siemens 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
Software Developer in Lisbon, Portugal
Member since June 9, 2016
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.
Andrey is now available for hire
Portfolio
- DataProfBusiness Intelligence (BI), Amazon Web Services (AWS), Node.js, Redshift...
- Maisonette, Inc.Snowflake, Looker, Data Build Tool (dbt), Data Analysis, Databases...
- AureaAmazon Web Services (AWS), JavaScript, Python, Java
Experience
- SQL 9 years
- Data Warehousing 5 years
- Data Warehouse Design 5 years
- Amazon Web Services (AWS) 5 years
- Looker 4 years
- PostgreSQL 4 years
- Business Intelligence (BI) 4 years
- Snowflake 1 year
Availability
Part-time
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.
Employment
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
- 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 Servicehttps://likeme.chat/
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.
Skills
Languages
SQL, Java, Snowflake, JavaScript, Groovy, PythonFrameworks
Mockito, JUnit, AngularJS, Spring, JSP, JPA, PowerMockTools
Looker, Subversion (SVN), Git, IntelliJ IDEA, Servlet, Apache Tomcat, Jira, Hudson, Cucumber, Microsoft Power BIParadigms
Business Intelligence (BI), Agile, Functional Programming, Scrum, ETLOther
Data Warehousing, Data Warehouse Design, BPM, Data Build Tool (dbt), Data Analysis, Data Analytics, FivetranLibraries/APIs
JDBC, Spring REST, Node.js, Pandas, JMSStorage
Redshift, PostgreSQL, Oracle RDBMS, NoSQL, MongoDB, DatabasesPlatforms
MacOS, Oracle, Amazon Web Services (AWS)
Education
- PhD Degree in Computer Science2007 - 2011Voronezh State University - Voronezh, Russia
- Master's Degree in Computer Science2002 - 2007Voronezh State University - Voronezh, Russia
