Viktorija is available for hire

Viktorija Vinogradova

Verified Expert in Engineering

Palantir Developer

Prague, Czech Republic

Toptal member since September 30, 2019

Expertise

SQL MySQL PostgreSQL Data Science Agile Development Git Jira Python Oracle Development Tableau Development Hadoop

Bio

Viktorija is a seasoned BI developer and data analyst who's been working on industry projects since 2013. She's worked with a range of tools, including databases, virtual databases (Denodo), and data analysis and visualization platforms (QlikView, Tableau, and Palantir). Viktorija highly values knowledge sharing with co-workers and is well-versed in software development methodologies and related tools.

Portfolio

Freelance Work

Python, QlikView, SQL

Deloitte Advisory

QlikView, SQL

Altus Analytics

Denodo, QlikView, SQL

Experience

SQL - 12 years
Jira - 7 years
Agile Software Development - 7 years
Git - 7 years
PySpark - 5 years
PostgreSQL - 4 years
Palantir - 3 years

Availability

Part-time

Preferred Environment

MacOS, Linux, Windows

The most amazing...

...project was developing a parameterized virtual database and data visualizations that could access a sharded database.

Work Experience

BI Consultant

2018 - PRESENT

Freelance Work

Analyzed data in digital product sales and upsell potential.
Set up Palantir projects to enable different granularity of data analytics for selected user groups.
Implemented data ingestion from HDFS into Palantir and preparation for analysis using PySpark.

Technologies: Python, QlikView, SQL

Senior Consultant

2017 - 2018

Deloitte Advisory

Negotiated the requirements and led the client through the implementation of an analytics system for digital product sales in the automotive industry.
Implemented QlikView-based visualization and data transformations/cleaning to represent the daily and monthly sales and the client portfolios with up-sale potential.
Performed on-demand SQL data extracts from Oracle and PostgreSQL to help the client support department determine how many and which clients might be affected by technical issues.

Technologies: QlikView, SQL

BI Developer

2014 - 2017

Altus Analytics

Performed data analytics for real estate investment companies.
Developed data models and specific data extraction procedures (QlikView scripts, SQL, VQL, Denodo, and Java).
Constructed data visualizations (QlikView/Tableau, JRXML in Jaspersoft Studio).
Managed a QlikView infrastructure and a Jaspersoft/Denodo infrastructure in AWS.
Implemented QlikView, Denodo, and Jaspersoft source version control in Git.

Technologies: Denodo, QlikView, SQL

Reports and Data Analyst

2013 - 2014

Stanmore Quality Surfacing

Reported for a works management system (road reinstatement work).
Implemented ad-hoc SQL reporting in MySQL for on-demand requests.
Developed a reporting and analytics solution in QlikView (scripting and visualization) to investigate the most common issues of low-quality works.
Implemented scheduled reporting in the Jaspersoft server for weekly management reports (SQL and JRXML).

Technologies: QlikView, MySQL, SQL

Experience

Data Model Optimization

As part of an industrial project, I rewrote existing ETL code in QlikView scripting for a hierarchical ownership model that was supposed to produce monthly ownership branches. However, because of overlapping ownership start/end dates for different ownership levels, it was providing duplicate data which was not detectable in data visualizations which created significant performance problems—the rewritten code noticeably improved performance.

Database Query Optimization

As part of an industrial project, I identified and optimized queries in MySQL database. A transactional system and reporting solution generated the queries. An analysis allowed me to identify regular reporting queries that were slowing down the performance of the transactional system and replace some automatically generated queries with manually written ones that were optimized to use existing indexes.

Learning New Things

In the summer of 2019, a friend asked if I can help with writing an iPhone app. (The app is currently being prepared for release). I learned Swift, and in four weeks, we managed to finish parts of the app responsible for sending/receiving asynchronous data requests and presenting the user with data once collected.

Education

2000 - 2004

Master's Degree in Computer Science

Riga Technical University - Riga, Latvia

Skills

Libraries/APIs

JasperReports, PySpark

Tools

Looker, Qlik Sense, Git, Tableau, Jira

Languages

SQL, Python 3, Python

Platforms

Denodo, QlikView 11, Qlik NPrinting, Windows, Linux, MacOS, QlikView

Storage

MySQL, PostgreSQL, Oracle 10g, Databases

Frameworks

Hadoop

Paradigms

Agile Software Development

Other

Exago, Palantir, System Requirements

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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