Unit Manager of Data Platform Unit/Service Area Delivery Manager
2018 - PRESENTLuminor Bank AS- Released the first version of the transaction search which provides search capabilities for interactive account statement service to end-users of the internet bank.
- Migrated customer transaction history from the old core system into a new data platform.
- Introduced pub-sub message delivery semantics for data integration between backend components.
- Built an internal team that took over the development of a data platform from an external consultancy.
- Supervised and coordinated the implementation of functional and non-functional requirements.
- Designed and defended various solution proposals in front of the enterprise architecture committee.
Technologies: Performance Tuning, Performance Analysis, Cloud Architecture, Amazon Web Services (AWS), APIs, Business Intelligence (BI), Streaming, Requirements Analysis, Business Analysis, Impact Analysis, Big Data Architecture, Big Data, Data Visualization, Remote Team Leadership, Remote Work, Team Leadership, Leadership, ETL Implementation & Design, Elasticsearch, NoSQL, Database Architecture, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, Database Modeling, SQL, Kafka Streams, Kibana, Amazon EKS, Apache NiFi, Amazon S3 (AWS S3), Amazon MSKBI Engineer
2017 - 2020LeoVegas Group- Developed various BI applications with QlikView and Tableau for business areas such as marketing, customer acquisition, CRM, responsible gaming, payments, and finance.
- Created and supported various automated reports with Qlik NPrinting.
- Developed ETL and data marts with QlikView and jobs orchestration with QlikView Publisher.
- Built the DWH on Google Cloud Platform (dimensional modeling).
- Developed a BI application that helps to configure payment providers' pricing models and automatically calculate commissions. Developed with Google Sheets (configuration tool), Google Big Query (ETL), and Data Studio (reporting).
Technologies: Performance Analysis, Google Cloud Platform (GCP), APIs, Business Intelligence Training, Business Intelligence (BI), Requirements Analysis, Business Analysis, Impact Analysis, Analytical Thinking, Analytics, Analytical Dashboards, Visualization Tools, Visualization, Dashboard Design, Dashboards, Dashboard Development, Big Data, Data Visualization, Team Leadership, Remote Work, Database Architecture, Data Architecture, Data Pipelines, Data Lakes, Database Modeling, Data Modeling, SQL, ETL Implementation & Design, ETL, Google Data Studio, Google BigQuery, Tableau, Qlik NPrinting, QlikViewBI Data Engineer
2016 - 2017Betsson Group- Implemented a self-service BI environment with Qlik Sense—from setting up the environment, data modeling, development of applications, and user training.
- Developed various BI applications such as CLV for marketing and customer classification with Qlik Sence.
- Created the POC of real-time analytics with ELK (Elastic stack).
- Developed the POC of data analytical layer for a big data platform to accelerate data queries speed with Jethro data.
Technologies: SQL Performance, Performance Tuning, Performance Analysis, APIs, Business Intelligence Training, Business Intelligence (BI), Analytical Dashboards, Analysis, Analytics, Visualization Tools, Visualization, Dashboard Development, Dashboards, Dashboard Design, Big Data, Data Visualization, ETL Implementation & Design, Elasticsearch, NoSQL, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, SQL, Kibana, Kibi, Tableau, Microsoft SQL Server, ELK (Elastic Stack), Jethro Data, Apache Hive, QlikView, Qlik SenseLead Software Developer
2015 - 2016Intrum Justitia- Developed an analytical layer on top of the Big Data (Cloudera CDH) with the help of Apache Hive (ETL), Apache Impala (query engine), and Tableau (BI application layer).
- Built a consolidated dimensional model that brought data from different sources into a single data model that fit many business reporting needs.
- Introduced self-service BI to business users. Participated in many internal conferences in different offices around the EU to promote self-service BI with Tableau.
Technologies: Performance Tuning, SQL Performance, Performance Analysis, APIs, Business Intelligence Training, Business Intelligence (BI), Analytical Thinking, Analysis, Analytics, Visualization Tools, Dashboards, Analytical Dashboards, Visualization, Dashboard Development, Dashboard Design, Big Data, Data Visualization, ETL Implementation & Design, NoSQL, Database Architecture, Big Data Architecture, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, Database Modeling, SQL, Apache Kylin, Apache Hive, Apache Impala, TableauSystems Analyst
2009 - 2015Idea Port Riga- Developed and maintained DWH, ETL, and BI application processes for the insurance, telco, and pharmacy retailer companies.
- Customized CRM system to fix reporting data gaps and improve ETL processes (CDC).
- Built a data archiving tool to offload historical data from CRM to improve CRM's performance, which helped to decrease customer service response time.
- Developed POC of fraud detection BI application, which helped find fraudulent cases and analyze the reasons behind insurance claims.
- Created the POC of a product recommendation engine for pharmacy retailers, which could increase sales by offering similar products based on transactional data.
Technologies: SQL Performance, Performance Tuning, APIs, Business Intelligence Training, Business Intelligence (BI), Visualization Tools, Visualization, Dashboard Design, Dashboard Development, Dashboards, Data Visualization, ETL Implementation & Design, Database Architecture, Data Architecture, Data Pipelines, Data Modeling, Database Modeling, SQL, Oracle Siebel CRM, Oracle Data Miner, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Oracle Warehouse Builder (OWB), Informatica PowerCenter, IBM Cognos Business Intelligence, Oracle RDBMS, Oracle BI EE 11gSecurities and Financial Market Department, Analyst Programmer
2007 - 2009Rietumu Bank- Built the customer investment portfolio performance report for customers.
- Created customer account statements and other regulatory reports automation.
- Developed the automated generation of customers' account statements and send-outs by email.
Technologies: SQL Performance, Performance Tuning, Performance Analysis, APIs, Business Intelligence (BI), Data Visualization, ETL Implementation & Design, Database Architecture, Data Architecture, Data Pipelines, Data Modeling, Database Modeling, SQL, Bloomberg API, Reuters API, Excel VBA, Microsoft Excel, Microsoft Access, T-SQL, Microsoft SQL Server, Crystal ReportsSenior Developer
2006 - 2007Accenture- Developed the integration layer between legacy systems and Oracle Siebel CRM (Java).
- Customized various Siebel CRM applications for clients.
- Improved performance of Siebel CRM system for a few clients by reviewing and refactoring custom scripts.
Technologies: Performance Tuning, Performance Analysis, APIs, Data Modeling, Database Architecture, SQL, Java, Oracle Siebel CRM