Viktorija is available for hire
Hire ViktorijaViktorija Vinogradova
Verified Expert in Engineering
Palantir Developer
Location
Prague, Czech Republic
Toptal Member Since
September 30, 2019
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
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.
Skills
Languages
SQL, Python 3, Python
Libraries/APIs
JasperReports, PySpark
Tools
Looker, Qlik Sense, Git, Tableau, Jira
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
Education
2000 - 2004
Master's Degree in Computer Science
Riga Technical University - Riga, Latvia
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