Pavel Koltashev solution architect

A

Data architect/senior backend engineer

Architech NYC

Jan 2020 - Jan 2022 (2 years 1 month)

Job advertising platform: developing data pipelines, designing and configuring cloud infrastructure (Google Cloud, AWS. Apache Airflow, Apache Beam, Python, Kubernetes, MySQL, BigQuery, Docker, Kafka, Postgres); Computer vision project: creating AI pipelines to capture video stream, detect people and generate their demographic metrics on the single board computers (python, computer vision, cv2, tensorflow, face recognition, docker, k8s); Creating data pipelines to deliver IOT data to analytical platform (Airflow, python, pandas, AWS Redshift, Postgres)

P

Senior software architect

Perfect Art

Jan 2017 - Jan 2020 (3 years 1 month)

Data warehouse projects for worldwide logistic operator: 1. Integration platform which extracts, consolidates, cleans and retains data about employees of enterprise from diverse sources (CSV,XML,JMS,Oracle) and provides exchange of processed data between enterprise systems. Target architecture design, database modeling, ETL development (Informatica). 2. Big Data Platform project - installation and configuration of Informatica PowerCenter 10.2 in AWS (on Linux), ETL development for data exchange between hadoop cluster and database/file servers. 3. Analytics Platform - data intake and processing development (AWS Glue API, AWS Lambda, Python, AWS CloudFormation)

O

Billing system administrator, developer

OJSC

Oct 2006 - Mar 2008 (1 year 6 months)

D

Developer in analytical

Apr 2003 - Oct 2006 (3 years 7 months)

• Created various financial reports in "SAP Business objects" • Developed lots of scripts and applications in UNIX and WINDOWS environment in PL/SQL, Delphi, python, perl.

Solutions architect

Provectus

Jan 2022 - Current (4 years 6 months)

"

Software developer

"Universal Systems" (NVision Group - Ural)

ETL,BI modeling/developing. projects: • Analytic Information System - aimed to efficient analytic reporting of provider's equipment load(base station traffic); • System for accounting SS#7 traffic (statistics collection, tariffication, reports); • "HLR-decoder" – application for converting HLR-dump (data from equipment) from binary files to CSV to compare HLR data before and after Functional Changes; • HP IUM Statistics collection (from Cisco Netflow). IBM Datastage, Oracle, Business Objects, MS Visual C++ .NET

Lead Architect

Bell Integrator

• Work with analysts to convert requirements into data aspects • Architectural design, data warehouse modeling (conceptual/logical/physical) • Lead a group of developers to new and refactoring/reengineering the existing ETL processes and legacy procedures • Create reports (metadata layer, ad hoc & standard reports) using BI tools • Project documenting in the form of application and technical architecture, technical specification, admin/user guides, release plan, test scenarios • Supervision of test, go-live and support phases • Interviewing candidates, coaching, resource estimating, participation in presale activities IBM Datastage, IBM DB2, Oracle, SAP Business Objects, ERwin Data Modeler, IBM Data Architect, IBM Cognos BI, Unix shel

E

Software Developer

EAST WINDSOR VOLUNTEER FIRE CO 1

providers. Product installation/integration on customer's site, data migration from old system. Developing SQL-queries/procedures, reports. T-SQL (Microsoft SQL Server), Borland C++, HTML.

Pavel Koltashev

About

Detail

Timeline

Résumé