Ярослав
BI Engineer/SQL Developer
- Рассматривает должности:
- BI Engineer/SQL Developer, Аналітик
- Вид занятости:
- полная
- Возраст:
- 41 год
- Город проживания:
- Мукачево
- Готов работать:
- Удаленно
Контактная информация
Соискатель указал телефон и эл. почту.
Фамилия, контакты и фото доступны только для зарегистрированных работодателей. Чтобы получить доступ к личным данным кандидатов, войдите как работодатель или зарегистрируйтесь.
Получить контакты этого кандидата можно на странице https://www.work.ua/resumes/4075732/
Опыт работы
Senior Software Engineer (BI & Data Management)
с 08.2024 по наст. время
(2 года)
Tietoevry Create Ukraine (formerly Infopulse Ukraine), Дистанційно (IT)
•Designed, developed, and maintained enterprise Data Warehouse (DWH) solutions using SAP HANA for business reporting and analytics.
•Developed complex SQLScript database objects, including stored procedures, table functions, scalar functions, and reusable database artifacts.
•Designed, developed, and optimized SAP HANA Calculation Views (Star Join, Cube, Dimension) to support enterprise reporting and analytical solutions.
•Developed and maintained ETL processes using SAP BODS to integrate enterprise data into SAP HANA.
•Designed analytical data models and reporting data structures supporting enterprise BI solutions.
•Optimized SAP HANA Calculation Views, SQLScript procedures, and database performance for large-scale analytical workloads.
•Implemented analytical privileges and participated in troubleshooting authorizationn and data access issues.
•Investigated production incidents, performed root cause analysis, and resolved SAP HANA data and reporting issues.
•Collaborated with business analysts and development teams to translate business requirements into scalable SAP HANA solutions.
•Supported application deployments across DEV, QA, STAGE, and Production environments using Git and Azure DevOps.
•Debugged SAP OData services by analyzing JSON responses and troubleshooting backend data issues.
•Performed data validation and ensured consistency across SAP HANA reporting solutions.
Software Engineer (BI & Data Management)
с 04.2021 по 07.2024
(3 года 4 месяца)
Tietoevry Create Ukraine (formerly Infopulse Ukraine), Дистанційно (IT)
•Developed and maintained SAP applications using ABAP during the initial phase of the project.
•Gathered and analyzed business requirements, preparing functional and technical specifications for SAP HANA reporting solutions.
•Designed and developed SAP HANA reporting solutions using SAP HANA Web IDE.
•Developed SQLScript database objects and SQL-based reporting solutions for enterprise reporting.
•Designed SAP HANA analytical data models and Calculation Views supportingbusiness intelligence requirements.
•Collaborated with business stakeholders to translate reporting requirements into scalable SAP HANA solutions.
•Performed testing, production support, issue investigation, and root cause analysis.
Team Lead, MES Solutions
с 09.2019 по 03.2021
(1 год 7 месяцев)
Flex, виробнича компанія, Мукачево (Машинобудування)
•Led a team of 4 Database/MES Engineers while remaining actively involved in software development (~70% hands-on).
•Planned and prioritized team workload, assigned tasks, and provided effort
estimations for new development requests.
•Conducted technical interviews, participated in hiring decisions, and onboarded new engineers.
•Performed code reviews and ensured adherence to development standards and best practices.
•Mentored team members through technical guidance and regular 1:1 meetings.
•Conducted performance reviews and supported engineers professional
development.
•Collaborated with manufacturing departments and internal stakeholders to gather requirements, estimate solutions, and resolve production issues.
•Continued hands-on development of MS SQL Server database solutions, ETL processes, SSRS reporting, and production data integration.
IT MES engineer
с 09.2016 по 08.2019
(3 года)
Flex, виробнича компанія, Мукачево (Машинобудування)
•Designed and developed database solutions supporting Manufacturing Execution Systems (MES) and manufacturing analytics.
•Developed and optimized ETL processes integrating data from MES, BAAN ERP, XML production tester logs, and traceability systems.
•Designed reporting tables and analytical data structures to support manufacturing KPIs and business reporting.
•Developed and maintained SSRS reports and dashboards for production
management.
•Implemented incremental data loading processes
•Optimized SQL queries and database performance for manufacturing databases
•Investigated complex production issues, performed root cause analysis, and
implemented long-term technical solutions.
•Collaborated with manufacturing engineers and business stakeholders to deliver new functionality and process improvements.
•Enhanced and completed a manufacturing traceability solution enabling end-to-end product traceability by integrating data from MES, ERP, and production testing systems using serial numbers.
Образование
Mukachevo Technological Institute
Ecolomical, Finance, Мукачево
Высшее, с 2002 по 2007 (5 лет)
Знания и навыки
- SQL
- T-SQL
- ETL support (data loads into reporting tables)
- SAP HANA data modeling (Calculation Views)
- SAP HANA development
- SAP Web IDE
- SAP HANA Studio
- MS SQL Server
- MS Excel
- SSRS
Знание языков
- Украинский — свободно
- Английский — выше среднего
Похожие кандидаты
-
Інженер-програміст
100000 грн, Удаленно, Другие страны -
Інженер-програміст
100000 грн, Удаленно, Киев -
Інженер-програміст
Удаленно, Другие страны -
Програміст БД, DB Developer, розробник систем
55000 грн, Удаленно, Днепр, Киев -
Senior Back-end (PHP) Developer, Software Engineer
120000 грн, Удаленно, Киев -
SQL-програміст
50000 грн, Удаленно, Винница , еще 8 городов