Viktorija is available for hire
Hire ViktorijaViktorija Vinogradova
Verified Expert in Engineering
PostgreSQL Developer
Prague, Czech Republic
Toptal member since September 30, 2019
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, SQL, Palantir Foundry, Palantir, PySpark, PostgreSQL...
Deloitte Advisory
QlikView, SQL, QlikView 11, PostgreSQL, Qlik Sense, Git, Jira, Databases...
Altus Analytics
Denodo, QlikView, SQL, QlikView 11, PostgreSQL, Qlik Sense...
Experience
- PostgreSQL - 12 years
- SQL - 12 years
- Agile Software Development - 10 years
- Jira - 10 years
- Git - 7 years
- Palantir Foundry - 5 years
- Palantir - 5 years
- PySpark - 5 years
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
- Analysed data and prepared data models in digital product sales and upsell potential, user interaction, and other areas.
- Set up Palantir projects to enable different granularities of data analytics for defined user groups.
- Built and optimized Palantir pipelines and set up monitors for data health checks.
Technologies: Python, SQL, Palantir Foundry, Palantir, PySpark, PostgreSQL, Agile Software Development, Git, Jira, Hadoop, Databases, System Requirements
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, QlikView 11, PostgreSQL, Qlik Sense, Git, Jira, Databases, System Requirements
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, QlikView 11, PostgreSQL, Qlik Sense, Agile Software Development, Git, Jira, JasperReports, Looker, Databases, System Requirements
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, JasperReports, Qlik NPrinting, Databases
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.
Education
2000 - 2004
Master's Degree in Computer Science
Riga Technical University - Riga, Latvia
Skills
Libraries/APIs
PySpark, JasperReports
Tools
Git, Tableau, Jira, Qlik Sense, Looker
Languages
SQL, Python 3, Python
Platforms
Palantir Foundry, 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.
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