Make a list of extra sites which is available in NEP and not available in site data base & after checked with internal team deleted those as confirmed by Bassem over an email.

As suggested by Bassem, consolidate the sites issue for Nokia RAN which to be share to Ooredoo.

Validated the same data on staging-DB deployed the latest AI patch and CSV output uploaded by integration with updated static sheet.

Checked feedback which is received from Ooredoo in attached sheet on secure share and send an email to AI DEV to implement the same with updated static sheet.

As per customer given updated rule, prepare the FRS for same and given rule to AI DEV to implement the same.

Validated the data for MICRO site rule parsing on staging-DB and now sites are parsing correctly as given rule for micro sites and imported the Nokia RAN XML then validated the same site in NEP.

As per @Bassem suggestion prepared the one consolidate sheet regarding all sites issue which to be raise to Ooredoo including for RAN & MW.

Check & update the tracker which to be share to Ooredoo as suggested by @Bassem and shared over an email.

I have uploaded the CSV output shared by DEV_AI. After the upload, I compared the data before and after the upload in SD, and the record counts are matching across all tables.

Check XML for micro site only and shared feedback to Sandya.

work on the issue

work on the issue

To make a rule to parse site id for micro sites as per Ooredoo new update & updated the FRS. and send an email for same.

And, also send an email to Ooredoo to confirm for all possible condition to parse site id.

Worked on this to identified the possible cases so that I can discuss with Ooredoo in next meeting.

Worked on sites issue as discussed with Ooredoo to implement the rule for micro sites.

Worked on site matching issue based on new sheet shared by Ooredoo on secure share (Micro sites) and shared my feedback.

Update the sheet related to site matching & shared to Bassem as he suggested to share the same to Ooredoo.

As discussed Bassem he need to update & modify the documents regarding site matching (RAN & MW) Worked on same to update the data as discussed with Bassem to take count & prepare summary with details data regarding demo with management.

Updated the site data information sheet based on sites-DB shared by Ooredoo for RAN & MW.

Validate the XML (which shared by @Sandya under JIRA OT-33) for site matching, now sites are parsing correct.

Validate the XML for site matching issue and still there is site missed for BSC/RNC as Sandya forgot to implement the rule for BSC/RNC. feedback shared to her over teams. and she will check & fix the same when she will work for OT-33.

Updated the static sheet "Site Data Information" for Nokia RAN and shared to @Sandya to use it when she will generate XML.

work on the issue

work on the issue

XML validation completed for site id and feedback shared to @Sandya over an email and also update the comment on JIRA. updated the FRS & shared the same.

Partially XML validation for site id issues.

Consolidated the site id issues where require lat/long or naming convention is not applicable for RAN & MW.

Worked on site id parsing rule through naming convention.

and consolidate the data of RAN & MW in a single sheet and shared to @Bassem with summary.

Worked on site matching issue of Nokia RAN & Make a rule regarding naming convention for site id parsing.

Checked the site naming convention rule which is shared by customer on 16-07-2025 over the sharepoint.

Imported XML in NEP for site id validation.

work on the issue

work on the issue

Sample XML validated for same and feedback shared to @Sandhya.

work on the issue

work on the issue

Make a rule to parse site id and updated in FRS also for sample nodes. given rule to @Sandya to generate XML.

Checked sample dump regarding site id & lat/long availability.