Roman Garanin

Project Examples

About

Hi there!

I'm Roman, a passionate Data Engineer with experience building robust and reliable applications.

On this page, you'll find a selection of my projects that showcase my skills in development and problem-solving

Portfolio

Wuckert Group Retail: Retool, n8n, NocoDB, Supabase, Min.io, AWS

This project encapsulates a comprehensive transformation endeavor initiated for our client to migrate their retail solution from a deprecated custom setup to a cutting-edge cloud-based infrastructure.
By leveraging modern tools and technologies, we aimed to enhance efficiency, scalability, and data management.
‍

Wilkinson Free Ads: Bubble, NocodeAPI, Google Sheets, Zapier

Wilkinson Free Ads is a streamlined platform built on Bubble enabling you to easily post local classifieds at no cost. This web application allows users to create accounts, log in securely, and submit ads through an intuitive interface.

The Portal is integrated using NocodeAPI. Newly posted ads are automatically dispatched to a CRM system through Zapier for additional processing and review.
‍

Tea Store: Webflow

It is an e-Commerce application for Tea Store powered by Webflow

Published to: https://bit.ly/garanin_prtfl_tea_store
‍

Ecoly: Figma, Google Sheets

Ecoly is a mobile app concept I designed to streamline ordering healthy meals in urban areas.
Using Figma, I brought this idea to life through an interactive prototype.I crafted the UI/UX design system in Figma, employing component libraries and constraints to ensure a consistent user experience across all screens.
I integrated Figma plugins to pull data from a Google Sheet database right into the mockups, demonstrating how real dynamic data can populate the app.

Published to: https://bit.ly/garanin_prtfl_ecoly
‍

Portfolio (old version): Webflow

Previous version of my portfolio site powered by Webflow

Published to: https://bit.ly/garanin_prtfl_portfolio_old
‍

Sample Data for E-Commerce: Python, Jupyter Notebook

Data generation for projects to populate databases

GitHub: https://bit.ly/garanin_prtfl_retail_goods_and_prices
‍

Warsaw Soccer Club: Webflow

A Webflow concept for Fireball Club

Published to: https://bit.ly/garanin_prtfl_warsaw_fireball_soccer_club
‍

Glendower ETL Process for E-Commerce: Parabola/n8n, Google Sheet, Firebase(API), Airtable

Glendower ETL is an automated data pipeline I developed to aggregate e-commerce data from diverse sources into a unified analytics dashboard.
This project showcases my expertise in designing and implementing ETL processes.
The pipeline extracts data from various endpoints including the Firebase API, Google Sheets, Airtable databases, and CSV files with helps Parabola
See DetailsVideo Demo

Glendower BI Dashboard for E-Commerce: Google Sheets

The Glendower BI Dashboard is an interactive data visualization tool I built to provide insights into key e-commerce metrics. This dashboard visualizes sales data aggregated via my Glendower ETL pipeline.

Published to: https://bit.ly/garanin_prtfl_glendower_bi
‍
See DetailsVideo Demo

Goaddress - Random European Address Scrapper: Automa, Google Sheets

Goaddress is an automated web scraping pipeline I developed to generate randomized geographic address data for use in other projects.

The pipeline uses Automa to programmatically navigate to a website that generates random addresses based on user input.

GitHub: https://bit.ly/garanin_prtfl_goaddress
‍

Firebase Item Filler: Automa, Google Sheets, Firebase

Firebase Item Filler is an automation pipeline I developed to populate Firebase databases, providing an alternative to CSV importing in the free Firebase plan.

GitHub: https://bit.ly/garanin_prtfl_firebase_filler
‍

Samly BI MVP: Bubble, NocodeAPI, Google Sheets

Samly BI MVP is a minimum viable product dashboard I rapidly developed using the Bubble no-code platform.
This project demonstrates an ability to quickly build functional web apps and dashboards using no-code tools.
‍

Targetent Retail BI Dashboard: Microsoft Excel, MS SQL Server

Targetent is an interactive retail analytics dashboard I built in Excel using Power Query, Power Pivot, and other advanced features.
The dashboard consolidates retail sales data from multiple sources including SQL Server databases, CSVs, and Excel files. Using Power Query, I transformed and combined the data into a unified model optimized for reporting.
‍

Enbit Retail BI Dashboard: PowerBI, Microsoft Excel, MS SQL Server

Enbit is an interactive retail analytics dashboard I developed in Power BI to visualize key business metrics.

The dashboard consolidates retail sales data from multiple sources including SQL Server, CSV files, and Excel spreadsheets. I combined these datasets and modeled the data using Power BI's data prep tools to optimize analytics performance.
‍

Portfolio Site: Webflow

This portfolio site

:-)

Powered by Webflow
‍
COMING SOON

Nicole Consulting Dashboard: Webflow, Wized, NocodeAPI, Google Sheets, MySQL

Nicole Consulting Dashboard is an analytics dashboard I developed using a modern no-code tech stack (likeWebflow, Wized, NocodeAPI, MySQL).
On page load, the Webflow site makes API calls to Wized to fetch the latest metrics and render within the dashboard. This could include KPIs, charts, tables and other visualizations that are dynamically updated.By assembling these complementary no-code tools,
I built a powerful data reporting solution without needing to code.
‍
COMING SOON

OCP Group Sales Portal: Retool, Bubble, Google Sheets, Firebase

OCP Group Sales Portal is an administrative interface I am building using Retool to provide insights into key e-commerce metrics.
The portal visualizes sales data from the OCP Group's Bubble-based e-commerce platforms.
Using Retool's API connectors, I integrated data sources like Bubble databases and third-party services.
‍
COMING SOON

ZX Rental Portal: FlutterFlow, Google Sheets, Firebase

ZX Rental Portal is a mobile app I'm building using FlutterFlow to enable booking accommodations on-demand.
I'm designing and developing the entire app in FlutterFlow's visual editor, including:    
- An appealing, easy-to-use interface with a map for browsing and searching rentals
- Integration with a backend database to manage listings and availability
- User authentication and accounts to save bookings
- Stripe integration to process payments securely
- Responsive UI supporting both Android and iOS devices

‍
‍
COMING SOON

SiiCorp Ltd Solution: Figma, AWS Amplify, AWS S3, AWS RDS

The SiiCorp Ltd solution is an e-commerce platform I'm building using AWS Amplify and integrating Figma designs.

Key technical features include:    
-User interfaces implemented based on Figma mockups provided by the design team
- Integration with AWS services (S3, Cognito, RDS etc.) via Amplify's libraries
- Serverless backend infrastructure set up through Amplify CLI
- Usage of React and AWS Amplify libraries for front-end and APIs
‍

Experience

Senior Data Engineer

“Cassin PLC”, Warsaw, Poland

July 2023 – present
  • Designing, building, and maintaining data pipelines to move data from Excel, CSV, API, Airtable, Databases, S3, and Min.io into the data warehouse (AWS Redshift, PostgreSQL) for analysis, Spark/PySpark
  • Preparing and testing data for visualization tools (PowerBI, MS Excel, Google Spreadsheets, Airtable)

DevSecOps / Data Engineer

“EPAM Systems”, Warsaw, Poland

October 2021 – July 2023
  • Test Automation Framework development on Python
  • Data preparation for PostgresQL

‍

QA / QA Automation Engineer, Team Lead

“Eurasian Processing Company”, Brest, Belarus

July 2019 – October 2021
  • Developing test automation framework (C#/.NET, nUnit, MS SQL Server/T-SQL, RestSharp, PowerShell): direct architecture and encoding
  • Mobile testing: mobile payments application
  • Testing of interaction with messaging system (RabbitMQ)
  • Data testing (Python, Pandas, SQLAlchemy)
  • API-testing (Postman, SoapUI)

‍

Software Engineer

“Itworks”, Brest, Belarus

May 2015 – July 2019
  • Organizing automated testing from scratch (Python, PyTest, Docker, Selenium/Selenoid), including mobile automation (Java, TestNG, Gradle)
  • Developing API Python applications
  • Developing emulators for external systems, data generators, documentation
  • Usability Testing
  • HTML/CSS/JavaScript/Python Development

Education

Professional Scrum Master I

Issue date:
February 27, 2023
Show Credential

DataOps Fundamentals Certification

Issue date:
May 8, 2023
Show Credential

Webflow Essentials Course

Issue date:
September 7, 2023
Show Credential
Know more

Contact

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Roman Garanin, 2023
Powered by