Alexander Shereshevsky, Developer in Tel Aviv-Yafo, Israel
Alexander is available for hire
Hire Alexander

Alexander Shereshevsky

Verified Expert  in Engineering

ETL Development Developer

Location
Tel Aviv-Yafo, Israel
Toptal Member Since
June 18, 2020

Alexander is a data professional with over 15 years of experience with different data solutions development (building DWH, ETL, data streams), data analysis, and data science (machine learning, deep learning, computer vision) background. He has a solid understanding of cloud and serverless architecture.

Portfolio

Independent Consulting
Data Warehouse Design, Data Warehousing, Python, PostGIS, Oracle...
Motionlogic GmbH
Pgpool-II, Python, QGIS, PostGIS, PostgreSQL, Database Architecture...
Amdocs
Microsoft SQL Server, MongoDB, XML, Oracle, Database Architecture

Experience

Availability

Part-time

Preferred Environment

PyCharm, Zsh, Ubuntu

The most amazing...

...algorithm I've made recognizes train/car/pedestrians with movement. The API detects best match properties using geolocation, full-text search, and attributes.

Work Experience

Data Architect

2012 - PRESENT
Independent Consulting
  • Developed a document-processing pipeline using AWS Steps, Lambda, and Batch. Processed thousands of documents daily using AWS infrastructure, developed NLP processies under Lambda constraints, communicated, and stored extracted attributes.
  • Ingested webstreams with Amazon Kinesis, short-time analysis, and events manipulations in the data stream. Used Redshift for storage and Batch analysis.
  • Provided a complex social media analysis pipeline based on MongoDB, Redshift, Elasticsearch, PostgreSQL, AWS Step Functions, AWS Lambda, Redshift, Python, NLTK, scikit-learn, and Gensim.
  • Supported data analyses of entity movement in different European countries with a very large geospatial DB with telecom data (25TB-size with 500GB of daily updates) based on PostgreSQL/PostGIS, Python, QGIS, and GeoPandas.
  • Supported the discovery of closest matches in properties DB (location) based on geometric proximity, full-text search, Python, Falcon, Gunicorn, scikit-learn, and PostgreSQL/PostGIS on a RESTful API.
  • Designed and implemented a startup's (banking) full-data infrastructure: Databases with cascading replication, monitoring solution, and data pipeline set up to support all the data science needs with Luigi, Python, PostgreSQL, Redshift, and Airflow.
Technologies: Data Warehouse Design, Data Warehousing, Python, PostGIS, Oracle, Microsoft SQL Server, PostgreSQL, Data Architecture

Senior Data Architect

2013 - 2015
Motionlogic GmbH
  • Reviewed, analyzed, scaled, and documented the database design according to best practices.
  • Designed, constructed, and managed VLDB redundant clusters.
  • Designed and implemented ETL processes to make sure data is collected reliability.
  • Implemented and analyzed data with GIS system (PostGIS) using geospatial pattern discovery.
  • Tuned database performance, optimized queries, and tuned indices.
  • Developed PL/pgSQL.
  • Managed data backups, configurations, documentation, monitoring, and logging.
Technologies: Pgpool-II, Python, QGIS, PostGIS, PostgreSQL, Database Architecture, Data Architecture, AWS Step Functions, AWS Lambda, AWS Batch, AWS Glue, Data Lakes

Senior Oracle DBA

2011 - 2012
Amdocs
  • Scripted for automation of work processes.
  • Developed utilities DBA every day (ERD management, comparing content, copy data).
  • Maintained real databases and development environments (over 30 major environments).
  • Tuned SQL performance.
  • Wrote procedures, functions, and triggers PL/SQL.
Technologies: Microsoft SQL Server, MongoDB, XML, Oracle, Database Architecture

Applicative DBA, VB Programmer

2009 - 2012
Kamada inc
  • Implemented ERP business logic.
  • Designed and developed financial monitoring reports.
  • Designed and developed BI tools for management.
  • Developed and supported an ERP applications complement system (. NET, VB).
  • Developed functions, triggers, and procedures.
  • Provided infrastructural support of MS SQL servers for the company (2000, 2005, 2008 R2).
Technologies: Crystal Reports, SQL, Microsoft SQL Server

PostgreSQL Extension

https://github.com/shereshevsky/pg_grants_manager
Simple extension for permission management.
2012 - 2015

MBA Degree in Finance

Ben Gurion University - Beer Sheva, Israel

2003 - 2006

Bachelor of Science Degree in Bioinformatics

Ben Gurion University - Beer Sheva, Israel

Libraries/APIs

Flask-RESTful

Tools

AWS Glue, AWS Batch, AWS Step Functions, Pentaho Data Integration (Kettle), Zsh, PyCharm, Navicat, Crystal Reports, GIS

Paradigms

Database Development, ETL, Spatial Databases, Database Design, Data Science

Storage

Database Administration (DBA), Database Architecture, Databases, Redshift, PostgreSQL, PostGIS, Data Lake Design, Data Pipelines, Data Lakes, Oracle PL/SQL, VoltDB, Microsoft SQL Server, MongoDB

Languages

PL/pgSQL, Python, SQL, Bash, XML

Platforms

Ubuntu, Amazon Web Services (AWS), Docker, AWS Lambda, Oracle

Frameworks

Flask

Industry Expertise

Bioinformatics

Other

Data Engineering, Data Warehousing, ETL Development, Big Data, Data Warehouse Design, Data Architecture, Data, Amazon Kinesis, Computer Vision, Google BigQuery, QGIS, Pgpool-II, Finance

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