Viktors Dundurs
IT Consultant
Experience
Jun 2025 - Present
8 monthsBaar, Switzerland
IT Consultant
Dundurs Consulting GmbH
- Supporting the implementation of a digitalization project in the area of nutrient balancing
- Analyzing complex business processes and interfaces to surrounding systems (data flows, dependencies)
- Designing processes for data retrieval, storage, and sharing, including plausibility checks and validation logic
- Creating and prioritizing user stories and guiding developers in agile sprints (clarifying acceptance criteria, conducting technical reviews)
- Supporting the Product Owner in defining functional and technical requirements
- Participating in the rollout process and delivering training for stakeholders
- Documenting processes, requirements, and interfaces (including records/changes for releases)
Nov 2024 - Present
1 year 3 monthsLucerne, Switzerland
IT Consultant
Dundurs Consulting GmbH
- Implementing SQL database requirements as part of a digitalization project
- Developing and optimizing ETL processes for automated data integration
- Defining and implementing interface requirements in collaboration with the development team
- Validating data flows and performing technical checks (plausibility, completeness, reconciliations)
- Developing reports and data access solutions (MSSQL, Report Server / Visual Studio) to control and trace results
- Creating PowerShell scripts to automate data and system processes
- Developing reusable scripts and templates
- Setting up monitoring solutions to track data processes and detect errors early
- Training staff in SQL (stored procedures, views, performance optimization)
- Preparing process and project documentation
Dec 2022 - Oct 2024
1 year 11 monthsIT Consultant
Dundurs Consulting GmbH
- Developing and optimizing ETL workflows for medical data integration
- Creating, maintaining, and extending complex MSSQL objects (stored procedures, views, functions)
- Validating data flows and performance tuning to ensure data quality and integrity
- Defining and implementing interfaces and data flows in the system architecture
- Building monitoring solutions for data products to detect errors and deviations early
- Creating medical reports (including SSRS / Report Server) for technical review and result validation
- Automating recurring processes using PowerShell
- Documenting data processes for compliance, data protection, and traceability
- Working closely with business units to align requirements and resolve findings
Jun 2022 - May 2023
1 yearIT Consultant
Dundurs Consulting GmbH
- Setting up, configuring, and documenting MSSQL servers
- Developing SQL queries and stored procedures, including optimizations
- Analyzing and improving data provisioning and access concepts
- Validating data access and results to ensure stable operations
- Preparing technical documentation and handing it over to operations
- Writing PowerShell scripts to automate data processes
- Supporting cloud migrations and the introduction of new platform solutions
- Performance tuning of existing databases
- Coordinating with IT departments to ensure stable operations and prevent errors
Apr 2022 - Nov 2022
8 monthsGermany
Lead Consultant
CGI Deutschland B.V. & Co. KG
- Executing infrastructure measures as part of an M&A carve-out
- Designing and implementing Active Directory and Office 365 migrations
- Developing and customizing PowerShell scripts to automate migrations
- Validating migration results and reviewing user, group, and permission structures
- Reorganizing user and group structures in complex AD environments
- Supporting modern workplace rollouts (Teams, OneDrive, Exchange Online)
- Creating infrastructure and migration plans and handing them off to operations teams
- Documenting technical processes and best practices to ensure stable operations
- Collaborating closely with project teams and international stakeholders
- Assisting with change and knowledge management
Feb 2020 - Apr 2022
2 years 3 monthsGermany
Junior Consultant
Avanade Deutschland GmbH
- Implementation of Azure cloud and Office 365 projects
- Automation of operations and migration processes using PowerShell scripts
- Execution of Active Directory migrations and cloud carve-outs
- Validation of migration results (users, groups, permissions)
- Support for user management and system-related migration processes
- Creation of documentation and process descriptions
- Training staff on Azure AD, Exchange Online, Teams, and OneDrive
- Maintenance of IAM systems including permission management
- Participation in agile project teams (SCRUM, sprints, reviews)
Dec 2018 - Jan 2020
1 year 2 monthsGermany
System Engineer
AM GmbH
- Operation and further development of IAM systems (ICU, MyWorkplace)
- Management of permissions, roles, and access
- Integration of new systems to central IAM solutions including compliance requirements
- Validation of access rights and system integrations to ensure stable operations
- Use of MSSQL for analysis and reporting
- Creation of technical documentation
- Maintenance of Active Directory environments
- Collaboration with internal IT teams on system integration and troubleshooting
Jun 2018 - Dec 2018
7 monthsGermany
System Engineer
Avanti GmbH
- Maintenance of IAM and Active Directory environments
- Use of MSSQL for data analysis and system maintenance
- Assignment of permissions and roles
- Validation of access rights and user configurations
- Creation of technical documentation
- Support in troubleshooting and process optimizations
Jan 2017 - Jan 2018
1 year 1 monthHamburg, Germany
Junior System Engineer
OktoPOS Solutions GmbH
- Handling 2nd-level support requests for point-of-sale systems and infrastructure
- Analysis and reproduction of error scenarios, supporting development in bug fixes
- Installation and configuration of hardware and software solutions at customer sites
- Development of automation scripts (Windows client & server)
- Creation of support documentation and processes
- Training customers in the use of new systems
- Testing software releases for quality assurance
Skills
- Sql / Mssql
- Data Analysis & Comparisons
- Testing & Quality Assurance
- Etl & Data Integration
- Performance & Data Quality
- Migrations & Technology Change
- Defect Analysis
- Agile Work (Scrum, Hermes)
- Automation (Powershell)
- Interfaces & Documentation
Languages
German
NativeLatvian
NativeEnglish
AdvancedRussian
AdvancedEducation
Jan 2014 - Jan 2017
OktoPOS Solutions GmbH / IHK Hamburg
Apprenticeship as an IT Specialist in System Integration · System Integration · Hamburg, Germany
Certifications & licenses
Hermes
Hermes
AZ-900: Microsoft Azure Fundamentals
PSM I: Professional Scrum Master
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience