ROCKEN Documentation Archives - Page 77 of 81

Rocken Sprint 41 – Planning & Goals

Sprint planning checklist

Preparation	Meeting	Follow up
Sprint planning call with team Close & clean previous sprint	Discuss planned tasks Add estimates (poker estimating)	Make sure all estimations are added to the tasks Demo after each sprint

Preparation

Meeting

Follow up

Sprint planning call with team
Close & clean previous sprint

Discuss planned tasks
Add estimates (poker estimating)

Make sure all estimations are added to the tasks
Demo after each sprint

Sprint team members

Name	Role	Main Goal	Planned Capacity	Note
sophiabilyk	Project Manager	–	2.5D	17-28.04 Vacation
Julia	Product Manager	–	10D
Sviridenko Dima (Unlicensed)	TeamLead, BE/FE Dev	New Architecture	10D
Dasha Rozhniatovska	BE Dev	New Architecture	10D
alex.neroznak (Unlicensed)	Bughunter/BE Dev	Support, New Architecture	10D	+ Support
Anton Liakh	BE Dev	New Architecture	10D
Valya Stelmashenko (Unlicensed)	FE Dev	New Architecture	5D	17-21.04 Vacation
Zhuravlev Artem (Unlicensed)	FE Dev	New Architecture	8D	10-11.04 Vacation
Anna Aksonenko	FE/BE dev	SEO tasks, Corporate site	–	17-21.04 Vacation
Ivan Hodoniuk	QA	New Architecture, Support QA	10D
Viktoriia Malysh	QA	New Architecture FE, Support QA	2.5D	17,21.04 Vacation
Ihor	FE Dev	Corporate site	–
Mikhail	Designer	Onboarding	10D
Roman	DevOps	Replication DB, DevOps tasks	–
Freelancer	Dev	3D animation	–

Sprint Goals

Details

Start date	10 апр. 2023 г.
End date	24 апр. 2023 г.
Sprint theme	New Architecture, Support cases

New Architecture:

Back-end:

API: Vacancy preview, Language, User & profile attach avatar, Get profiles with filters
Processes: Modification actions
Modules: Chat, Filters save
User phone addition with confirm
Slug Replace and make test for hasid config

Front-end:

CRM Chat module
Process Interview part connect
New Architecture bug fixing

General:

Elastic search research
Location input API sync

DevOps:

DB replication
Migrate domains to new URL

Support:

Check the work queue
Do not change the consultant if the candidate is in Offline
Average time to Candidate Active for Sara Cartensen
Create a new process type: Order
Collect statistics about interview completion
Remove duplicated candidates

April 10, 2023

Support tasks status – Sprint 40

Task	Spent time	Comment	Status
RT-1822	–		NEXT SPRINT
RT-1955	–		NEXT SPRINT
RT-1998	–		NEXT SPRINT
RT-2066	–		NEXT SPRINT
RT-2131	7h	Not planned task	IN PROGRESS
RT-1882	1D 1h		QA
RT-2103	4h	Not planned task	QA
RT-2132	3h	Not planned task	QA
RT-1827	1.5D		DONE
RT-1826	3h		DONE
RT-1921	1D		DONE
RT-1989	3h		DONE
RT-2064	–	No time logged	DONE
RT-2065	4h		QA
RT-2096	4h	Not planned task	DONE
RT-2065	4h	Not planned task	QA
RT-2093	2h	Not planned task	DONE
RT-2129	1h	Not planned task	DONE
RT-1880	2.5h	Not planned task	DONE
±Spent: 8.5D

April 6, 2023

Report. Top publications

Task:

RT-2065

Criteria: Candidates which became active

Query:

select vacancies.id, vacancies.name, count(DISTINCT applications.candidates_id) as count
from applications
         left join vacancies on applications.vacancies_id = vacancies.id
         inner join comments
                    on commentable_type = 'backend\models\Candidates'
                        and commentable_id = applications.candidates_id
where vacancies.consultants_id in (157, 171, 165, 79, 179)
  and text ilike '%to Active'
group by vacancies.id, vacancies.name
order by count desc
limit 25;

April 4, 2023

Report. Collect statistics about the quarter

Task:

RT-2103

Query:

select bu.name,
       concat(consultants.first_name, ' ', consultants.last_name) as consultant_name,
       COUNT(distinct case
                          when table_name = 'candidates_vacancy_requests' and
                               field_name = 'status' and
                               old_value = '1'
                              then cvr.id end) as created,
       COUNT(distinct case
                          when table_name = 'candidates_vacancy_requests' and
                               field_name = 'status' and
                               new_value = '6'
                          then cvr.id end) as shared,
       COUNT(distinct case
                          when table_name = 'candidates_vacancy_requests' and
                               field_name = 'status' and
                               new_value = '13'
                              then cvr.id end) as rocked,
       COUNT(distinct case
                          when table_name = 'candidates' and
                               field_name = 'status_id' and
                               new_value = '5'
                              then candidates.id end) as active
from arhistory ar
         left join candidates_vacancy_requests cvr on ar.row_id = cvr.id
         left join candidates on ar.row_id = candidates.id
         left join consultants
                   on case
                          when table_name = 'candidates_vacancy_requests' then cvr.consultants_id = consultants.id
                          else candidates.consultants_id = consultants.id
                       end
         left join business_units bu on bu.id = consultants.business_unit_id
where date(to_timestamp(ar.created_at)) between '2023-01-01' and '2023-03-31'
group by bu.name, consultant_name
order by bu.name;

March 31, 2023

Reports

March 31, 2023

Rocken Sprint 40 – Planning & Goals

Sprint planning checklist

Preparation	Meeting	Follow up
Sprint planning call with team Close & clean previous sprint	Discuss planned tasks Add estimates (poker estimating)	Make sure all estimations are added to the tasks Demo after each sprint

Preparation

Meeting

Follow up

Sprint planning call with team
Close & clean previous sprint

Discuss planned tasks
Add estimates (poker estimating)

Make sure all estimations are added to the tasks
Demo after each sprint

Sprint team members

Name	Role	Main Goal	Planned Capacity	Note
sophiabilyk	Project Manager	–	5D
Julia	Product Manager	–	10D
Sviridenko Dima (Unlicensed)	TeamLead, BE/FE Dev	New Architecture	10D
Dasha Rozhniatovska	Bughunter/BE Dev	Support, New Architecture	10D	+ Support
alex.neroznak (Unlicensed)	BE Dev	New Architecture	10D
Anton Liakh	BE Dev	New Architecture	10D
Valya Stelmashenko (Unlicensed)	FE Dev	New Architecture	10D
Zhuravlev Artem (Unlicensed)	FE Dev	New Architecture	10D
Anna Aksonenko	FE/BE dev	SEO tasks, Corporate site	–
Ivan Hodoniuk	QA	New Architecture, Support QA	10D
Viktoriia Malysh	QA	New Architecture FE, Support QA	5D
Ihor	FE Dev	Corporate site	–
Mikhail	Designer	Onboarding	10D
Roman	DevOps	Replication DB, DevOps tasks	–
Freelancer	Dev	3D animation	–

Sprint Goals

Details

Start date	27 мар. 2023 г.
End date	10 апр. 2023 г.
Sprint theme	New Architecture, Support cases

New Architecture:

Back-end:

API: Profile Full/short page, Profile Preview, Vacancy Preview
Processes: Modification actions, History of changes, Interview dates functionality (first iteration)
Modules: Chat

Front-end:

Talent Home page: Dashboard, Category stats
Profile Preview page connect to API: Languages, Experience, Hobbies, Skills
CRM Management header
Settings Phone/Email confirm
Interview form

General:

Elastic search research

DevOps:

DB replication

Support:

Some regions missing at Talent
Make the chronological order of attached pdfs in the Profile PDF
Collect statistics about interview completion
Add an obligatory reason of rejection for applicants
Send a dedicated RJ application email to RT candidate
Swap sign in buttons on CRM
Do not change the consultant if the candidate is in Offline
Reassign publications from Adolfo and Donika
Report – Top 25 publications (Finance)
Check the work queue

March 27, 2023

Tasks status – Sprint 40

Dev	Task	Estimated / Remaining time	Spent time	Comment	Result
alex.neroznak (Unlicensed)	RT-1856	3D	6D	Returned from Code Review 31.03	?
	RT-1906	1.5D	1.5D		DONE
	RT-1909	1D	1D 2h		DONE
	RT-1711	1.5D	3.5D		DONE
	RT-1848	3D	2D		NEXT SPRINT
	RT-2068	3D	3D		NEXT SPRINT
	RT-2069	2D	1.5D		NEXT SPRINT
	RT-2070	–	5h		Ongoing task
	Code Reviews	–	1,5h	–	–
	Total (planned): 9D				±Spent: 9D
Dasha Rozhniatovska Bug hunter	RT-1839	–	–	Can be moved to the next Sprint	NEXT SPRINT
	RT-1837	–	–	Can be moved to the next Sprint	NEXT SPRINT
	RT-1840	–	–	Can be moved to the next Sprint	NEXT SPRINT
	RT-1798	3D	–	Can be moved to the next Sprint	NEXT SPRINT
	RT-1827	2D	1.5D		DONE
	RT-1826	1D	3h		DONE
	RT-1822	4h	–		NEXT SPRINT
	RT-1921	2D	1D		DONE
	RT-1882	1D	9h		DONE
	RT-1955	4h	–		NEXT SPRINT
	RT-1989	2h	3h		DONE
	RT-1998	2h	–		NEXT SPRINT
	RT-2064	1h	–	No time logged	DONE
	RT-2065	4h	4h		QA
	RT-2066	1D	–		NEXT SPRINT
	RT-2131	1D	7h	Not planned task	?
	RT-2103	4h	4h	Not planned task	QA
	RT-2096	–	4h	Not planned task	DONE
	RT-2065	4h	4h	Not planned task	QA
	RT-2132	2h	3h	Not planned task	QA
	RT-2093	4h	2h	Not planned task	DONE
	RT-2129	1h	1h	Not planned task	DONE
	RT-1880	2h	2.5h	Not planned task	DONE
	Code Reviews	–	2,5h	–	–
	Total (planned): 14D				±Spent: 8.5D
Anton Liakh	RT-1857	4D	7.5D	Remaining time – Next sprint Need to divide to subtasks	NEXT SPRINT
	RT-1858	4D	–		NEXT SPRINT
	RT-1854	2D	–		NEXT SPRINT
	RT-1990	–	5h	From previous Sprint	DONE
	RT-2067	2D	–		NEXT SPRINT
	Code Reviews	–	1.5h	–	–
	Total (planned): 12D				±Spent: 8.5D
Sviridenko Dima (Unlicensed)	RT-1667	2.5D	4D	–	DONE
	RT-1795	–	–	–	NEXT SPRINT
	RT-1809	2.5D	1h	Task time – 2.5D	DONE
	RT-1788	2D	3h	Task time – 1W	DONE
	RT-1927	5D	–		NEXT SPRINT
	RT-2071	–	1D 2h	Ongoing task	NEXT SPRINT
	RT-1804	2.5D	–		NEXT SPRINT
	RT-2027	2h	3h		NEXT SPRINT
	RT-2028	4h	2h		NEXT SPRINT
	Code Reviews	–	14h	–	–
	Total (planned):				±Spent: 8.5D
Valya Stelmashenko (Unlicensed)	RT-1846	3.5D	5h	Task time – 3D	NEXT SPRINT
	RT-1861	4D	0.5h	Task time – 4.5D	DONE
	RT-1899	2.5D	1.4D		NEXT SPRINT
	RT-2021	2.5D	–		?
	RT-2023	1D	7h		NEXT SPRINT
	RT-2024	1.5D	1.5D		?
	RT-1902	1.5D	1.5D		DONE
	RT-1915	6h	3h		NEXT SPRINT
	RT-1976	2h	1h		NEXT SPRINT
	RT-1979	4h	2h		NEXT SPRINT
	RT-1980	4h	4h		NEXT SPRINT
	RT-1983	2h	2h		NEXT SPRINT
	RT-1894	2D	1.5D	Not planned task	NEXT SPRINT
	Code Reviews	–	1.5h	–	–
	Total (planned): 10D				±Spent: 8D
Zhuravlev Artem (Unlicensed)	RT-1896	–	–	Hangs too long in Review	?
	RT-1898	4D	1.5D	Task time – 2.5D	NEXT SPRINT
	RT-1926	–	–	Hangs too long in Review	?
	RT-1895	2D	3h	Task time – 1.5D	NEXT SPRINT
	RT-1900	1.5D	1D	Task time – 2.5D	NEXT SPRINT
	RT-1897	4D	2.5D		NEXT SPRINT
	RT-1907	3D	1D		NEXT SPRINT
	RT-2022	1D	1D		NEXT SPRINT
	RT-2072	2D	1.5D		NEXT SPRINT
	Code Reviews	–	2.5h	–	–
	Total (planned): 10D				±Spent: 9D

Pay attention:

Task	Responsible	Comment
RT-1889	Anna / Dasha / Sophia	Picked 1 option – rewriting to WP
RT-1863	Ihor / Alec / Sophia	Start with back-end Sprint 40
Bugs fixing		Start with fixing bugs in Sprint 41

Task

Responsible

Comment

RT-1889

Anna / Dasha / Sophia

Picked 1 option – rewriting to WP

RT-1863

Ihor / Alec / Sophia

Start with back-end Sprint 40

Bugs fixing

Start with fixing bugs in Sprint 41

March 27, 2023

ROCKEN – All Reports

March 12, 2023

Rocken Sprint 39 – Planning & Goals

Sprint planning checklist

Preparation	Meeting	Follow up
Sprint planning call with team Close & clean previous sprint	Discuss planned tasks Add estimates (poker estimating)	Make sure all estimations are added to the tasks Demo after each sprint Dima check tasks and delete some from current sprint

Preparation

Meeting

Follow up

Sprint planning call with team
Close & clean previous sprint

Discuss planned tasks
Add estimates (poker estimating)

Make sure all estimations are added to the tasks
Demo after each sprint
Dima check tasks and delete some from current sprint

Sprint team members

Name	Role	Main Goal	Planned Capacity	Note
sophiabilyk	Project Manager	–	5D
Julia	Product Manager	–	10D
Sviridenko Dima (Unlicensed)	TeamLead, BE/FE Dev	New Architecture	10D
Dasha Rozhniatovska	BE Dev	New Architecture	10D
alex.neroznak (Unlicensed)	BE Dev	New Architecture	7D	Vacation 22-24.03
Anton Liakh	Bughunter/BE Dev	Support, New Architecture	10D+ Support
Valya Stelmashenko (Unlicensed)	FE Dev	New Architecture	10D
Zhuravlev Artem (Unlicensed)	FE Dev	New Architecture	10D
Anna Aksonenko	FE/BE dev	SEO tasks	–
Ivan Hodoniuk	QA	New Architecture, Support QA	10D
Viktoriia Malysh	QA	New Architecture FE, Support QA	5D
Roman	DevOps	Deploy BI board, CRM, Talent; VPN	–
Freelancer	Dev	3D animation	–

Sprint Goals

Details

Start date	13 мар. 2023 г.
End date	27 мар. 2023 г.
Sprint theme	New Architecture, Support cases, Security measures

New Architecture:

Back-end:

API Profile: Hobby
Modules: Notification, Chat, Processes

Front-end:

Talent Home page: Dashboard, Category stats
Loader, button load functionality
Confirm on remove educations, experience
CRM side bar
Vacancy Preview page
Interview form

General:

Elastic search research
Make volumes in docker compose for logs file
Talent container center on big screen
Unit test localizations

DevOps:

CI/CD Deploy BI board, CRM, Talent
VPN live

Support:

Incorrect job search
Create a list of companies with a "SPOC" comment
Make the chronological order of attached pdfs in the Profile PDF
Collect statistics about interview completion
Add an obligatory reason of rejection for applicants
Send a dedicated RJ application email to RT candidate
Make the sender of RJ emails a consultant and not "wir@rocken.jobs"
Set processes from no reply to rejected (team Neptun)
Report – Vacancy from RUAG AG (Interview status)
Filter out the statistics by BU Venus
Set all vacancies to Inactive for Adelina Dushaj
Collect statistics about Unfinished with profile links

March 12, 2023

Tasks status – Sprint 39

Dev	Task	Estimated / Remaining time	Spent time	Comment	Result
alex.neroznak (Unlicensed)	RT-1856	3D	5D	Returned from Code Review	NEXT SPRINT
	RT-1906	1.5D	1.5D	in Code Review	NEXT SPRINT Need to be merged
	RT-1909	1D	1D	Returned from Code Review	NEXT SPRINT
	RT-1712	–	–		DONE
	RT-1805	–	–		DONE
	RT-1853	–	–	Return from Review by Dima 7.03	DONE
	RT-1537	–	–	NOT PLANNEDStarted in Sprint 34, returned because Review Total Spent – Planned – 1W	DONE
	RT-1711	–	–	NOT PLANNEDStarted in Sprint 35, returned because Review Total Spent – 3D Planned – 1.5D	NEXT SPRINT Need to be merged
	RT-1761	–	–	NOT PLANNEDStarted in Sprint 36, returned because Review Total Spent – 1.5D Planned – 1D	DONE
	Code Reviews	–	–	–	–
	Total (planned): 6D				±Spent: 7D
Dasha Rozhniatovska	RT-1838	–	–	Total Spent – 2D 5h Planned – 2D	DONE
	RT-1839	4D	2.5D	Total Spent – 5D Planned – 7D	NEXT SPRINT
	RT-1837	2D	2h	–	NEXT SPRINT
	RT-1840	3D	3D 2h	in Code Review	NEXT SPRINT
	RT-1880	2h	2h	–	QA
	RT-1878	1D	6h		QA
	RT-1873	1D	7h	–	DONE
	Code Reviews	–	2.5h	–	–
	Total (planned): 11D				±Spent: 8.5D
Anton Liakh Bug hunter	RT-1827	2h	10h	–	Assigned to Dasha
	RT-1918	4h	4h		QA DONE
	RT-1852 RT-1974 RT-1973 RT-1975	–	–	–	DONE
	RT-1877	–	–		DONE
	RT-1924	4h	6h	–	DONE
	RT-1892	2h	10m	–	DONE
	RT-1922	2h	20m	–	DONE
	RT-1891	2h	2h	–	DONE
	RT-1890	2h	3h	–	DONE
	RT-1879	4h	3h	–	DONE
	RT-1882	1D		–	NEXT SPRINT
	RT-1921	2D		–	NEXT SPRINT
	RT-1921	4h		–	NEXT SPRINT
	RT-1822	4h		–	NEXT SPRINT
	RT-1826	1D		–	NEXT SPRINT
	RT-1871	4h	30m	–	DONE
	RT-1949	2h	12h	–	DONE
	RT-1935	–	7.5h	–	DONE
	Code Reviews	–	3.5h	–	–
	Total (planned): 8.5D				±Spent: 9D
Sviridenko Dima (Unlicensed)	RT-1695 RT-1795 RT-1843	–	–		DONEQA Slug – later to be able to test (with Profile page)
	RT-1667	2.5D	–	–	NEXT SPRINT
	RT-1809	2.5D	1D	–	NEXT SPRINT (Backlog)
	RT-1788	2D	1h	–	NEXT SPRINT Need to merge
	RT-1930	4h	3h	–	DONE
	RT-1927	5D	–	–	NEXT SPRINT
	RT-1893	2D	3D	–	DONE
	Profile Interview back part	–	14h	Added manually to TD? Transfer time to RT-1809	?
	Code Reviews	–	10h	–	–
	Total (planned):				±Spent: 7.5D
Valya Stelmashenko (Unlicensed)	RT-1849	–	1D	Returned from Code Review several times Total Spent – 1W 4h Planned – 1W	DONE
	RT-1846	3.5D	1.5D	–	NEXT SPRINT
	RT-1861	4D	4D 5h	in Code Review	NEXT SPRINT
	RT-1902	1.5D	1D	–	NEXT SPRINT
	RT-1673 RT-1794 RT-1672 RT-1767 RT-1601 RT-1789 RT-1674	–	–	–	QA DONE
	Code Reviews	–	2h	–	–
	Total (planned): 9D				±Spent: 8D
Zhuravlev Artem (Unlicensed)	RT-1851	–	0.5h	Total Spent – 1D Planned – 1.5D	DONE
	RT-1834	–	2.5h	Returned from Code Review several times Total Spent – 2.5D Planned – 2D	NEXT SPRINT
	RT-1842	–	3h	Need to be deployed – check	?
	RT-1806	2.5D	1.5D	Time not tracked in the task	QADONE
	RT-1896	2.5D	1.5D	in Code Review	NEXT SPRINT
	RT-1898	2.5D	2.5D	in Code Review	NEXT SPRINT
	RT-1900	1.5D	1.5D	in Code Review	NEXT SPRINT
	RT-1926	2D	5h	in Code Review	NEXT SPRINT
	RT-1790 RT-1765 RT-1744 RT-1602 RT-1725 RT-1766 RT-1719	–	–	Need to be deployed in this Sprint	?
	Code Reviews	–	1.5h	–	–
	Total (planned): 11D				±Spent: 9D

Pay attention:

Task	Responsible	Comment
RT-1852	Anton / Sophia	Consultants are waiting for set up, need to start with it at the begging of the Sprint
RT-1889	Anna / Dasha / Sophia	Need Client’s decision
RT-1863	Ihor / Alec / Sophia	Start with back-end Sprint 40

Task

Responsible

Comment

RT-1852

Anton / Sophia

Consultants are waiting for set up, need to start with it at the begging of the Sprint

RT-1889

Anna / Dasha / Sophia

Need Client’s decision

RT-1863

Ihor / Alec / Sophia

Start with back-end Sprint 40

March 12, 2023

Category: ROCKEN Documentation

[data-colorid=sbalxxcia2]{color:#00b8d9} html[data-color-mode=dark] [data-colorid=sbalxxcia2]{color:#26deff} Sprint planning checklist

Sprint team members

Sprint Goals

Details

New Architecture:

DevOps:

[data-colorid=xk9i19beu5]{color:#00b8d9} html[data-color-mode=dark] [data-colorid=xk9i19beu5]{color:#26deff} Sprint planning checklist

Sprint team members

Sprint Goals

Details

New Architecture:

DevOps:

[data-colorid=ewirwc5dsu]{color:#00b8d9} html[data-color-mode=dark] [data-colorid=ewirwc5dsu]{color:#26deff} Sprint planning checklist

Sprint team members

Sprint Goals

Details

New Architecture:

DevOps:

Sprint planning checklist

Sprint planning checklist

Sprint planning checklist