Ēriks K.

Experience

• 

  SIA "Avoko"​

  Jan 2010 - Jan 2012

  Database Administrator

  During my time in SIA "Avoko" as a Database Administrator, I held responsibility of maintenance and optimization of surveillance systems, including DVR (Digital Video Recorder) and NVR (Network Video Recorder). My responsibilities included physical system installation and enhancement of system automation through external remote systems. Key accomplishments include:- Handling of installation, configuration, and maintenance of surveillance systems, ensuring their consistent performance and reliability.- Leveraged technical expertise to improve system automation, streamlining surveillance operations through the integration of external remote systems.- Collaborated with cross-functional teams to design and implement solutions that elevated the efficiency and effectiveness of surveillance infrastructure.- Actively monitored and maintained surveillance databases, ensuring data integrity and system security.My role as a Database Administrator at SIA "Avoko" allowed me to gain proficiency in surveillance system management, automation, and database administration, making contribution to the company's security and operational excellence. Show less

• 

  SIA "Arēna Rīga"​

  Jan 2012 - Mar 2012

  Computer Systems Technician

  In my role as a Computer Systems Technician at SIA "Arēna Rīga," I was responsible for support, installation, monitoring, coordination, and automation of surveillance systems. During my time with the company, I accomplished the following:- Remotely and directly provided technical support by swiftly addressing issues and ensuring the uninterrupted operation of surveillance systems.- Installed and configured surveillance equipment, ensuring its optimal performance and reliability.- Monitored surveillance systems to detect anomalies, ensuring the security and safety of the premises.- Coordinated activities related to surveillance system management, facilitating efficient teamwork and operations.- Implemented automation solutions to enhance the efficiency and functionality of the surveillance systems.This role allowed me to keep my expertise in surveillance system technology and develop proficiency in remote support and automation. Show less

• 

  SIA "Klondaika"​

  Apr 2012 - Jul 2015

  Computer System Specialist

  As a Computer System Specialist at SIA "Klondaika," I participated in the successful installation, maintenance, and automation of surveillance systems. During my time working, I achieved the following:- Installed and configured surveillance systems, ensuring their seamless operation and reliability.- Conducted routine maintenance to proactively address issues and ensure the continuous functioning of surveillance equipment.- Implemented automation processes to optimize surveillance operations, enhancing efficiency and reducing manual intervention.This position allowed me to cultivate expertise in surveillance system technology and automation, contributing to the overall security and operational efficiency of the organization. Show less

• 

  Accenture

  Jul 2015 - Feb 2016

  Oracle Database Developer

  In my role as a Database Administrator at Accenture, I contributed to development and maintenance of Oracle Essbase servers, specializing in database modifications to meet specific project requirements. My responsibilities included:- Collaborating with a developers to enhance Oracle Essbase server performance and functionality, ensuring data management.- Conducting database modifications and optimizations based on project requirements, resulting in improved data accuracy and system performance.- Gaining practical experience in Oracle tools. Show less

• 

  Accenture

  Jun 2016 - Jan 2017

  Java/C++ Developer

  During my time working as a Java and C++ developer, I helped designing and developing Java-based applications. My responsibilities included:- In collaboration with different departments, analyzing project requirements and designing software solutions.- Writing reliable Java code while adhering to coding standards and best practices.- Conducting code reviews to ensure code quality and identifying areas for improvement.- Debugging and troubleshooting issues to ensure smooth application functionality.- Utilizing Java frameworks, libraries for development processes and productivity improvement. My experience as a C++/ Java developer allowed me to strengthen my C++/ Java programming skills and contribute effectively to the success of various projects. Show less

• 

  IBANPAY

  Feb 2017 - now

  Data Analyst

  - Collaboration with shareholders, business analysts, and merchants to gather and define business requirements for data analysis, reporting, and database management projects.- Development of interactive and visually appealing Power BI dashboards/Tableau to track key performance indicators (KPIs), providing actionable insights to drive business decisions.- Utilization of SQL for data extraction, transformation, and reporting, ensuring data accuracy and reliability.- Conducting thorough data analysis to identify trends, patterns, and anomalies, leading to data-driven recommendations for process improvements.- Creation and maintenance of data pipelines, automation of data extraction, transformation, and loading (ETL) processes.- Management and administration of MSSQL databases, optimizing performance, ensuring data integrity, and implementing backup and recovery strategies.- Performance of routine database maintenance tasks, including indexing, query optimization. - Collaboration with project managers to ensure the successful execution of data-related project.- Working with cross-functional teams to optimize data storage and retrieval processes, improving data accessibility and efficiency.- Utilization of Confluence and Jira software for effective project documentation, task tracking, and collaboration with project teams.- Creation of detailed documentation, including business requirements, through close engagement with shareholders, various teams (marketing, sales, support, and developers), ensuring that delivered solutions meet the specified requirements.- Active participation in system testing to validate that developed solutions align with business objectives and expectations. Show less