Basma Nasser

Build reports and dashboards architecture. Created Dashboards for "NOSI" using PowerBI. Handled Power BI architecture deployments and upgrades. Build reports for "National organization for social insurance" on SSRS. Writing SQL queries for dashboard model. PowerBI server installation and configuration. SSRS installation and configuration.

Create solution for ETL pipeline. Implemented DWH using AWS Redshift. Implemented ETL flow using AWS Glue service to transfer data from RDS to Redshift. Rebuilt reports on metabase and DWH. Integrate redshift with metabase and reporting tool.

Write session plans and prepare materials for all course sessions. Assisting students with projects and tasks. Working with students to help them understand key concepts.

Handled Power BI architecture deployments and upgrades. Responsible for technical leading and on job training of new comers. Supervise team members to provide robust data analysis platforms to various departments (IT, Business, Operation, Management. Validate scripts & database design to ensure accuracy of data, clear documentation and problem resolution to ensure high quality of data.

Developed alarming tool using python script to detect all systems behavior per hour. Developed script to monitor and generate all opened and failed SRs from Siebel, SSS , billing and TIBCO databases. Write operation guides for the developed scripts and tools. Develop different python scripts to validate network issues cases from HLR, Billing and charging systems. Solution handover including training and documentation. Build analysis models for different charging network using Microsoft power BI. Developed dashboards using power BI and tableau including scheduled reports according to business need. Writing SQL/Oracle queries. Developed logs mining dashboards for various services in Etisalat using ELK stack and Grafana.

Manage Huawei RBT (RingBack Tone) system, Call signature, AdVoice and promotion platform. Follow implementation process of new projects or upgrades. Handle communication between commercial and vendors. Participate in projects & acceptance testing. Develop and update projects on online mediation using Java language. Ensures operation by training client personnel; providing support. Identify and document RBT system solutions in order to meet business requirement. Analyse the data of RBT and call signature systems to check the trend of the revenues and subscribers behavior in the system. Create and view different reports using Cognos. Write SQL queries to collect data for analysis from different systems databases.

Handling customer requests related to RBT (RingBack Tone) system. Supporting Huawei RBT system (IVR, SMS, USSD,..). Support the DB software used with Huawei products mainly Oracle Database. Accept customer technical problems, Respond & resolve them quickly & effectively. If assigned, participate in projects & acceptance testing . Create documented processes and procedures for operation and maintenance task. Manage the troubleshooting activities. Participate in software upgrade or enhancement activities. Investigate and resolve fault that occurs in the system and respond to emergency situation within the specified response times. Implement and close received Work Orders and Trouble Tickets within the required date and SLAs. Perform Operation and Maintenance tasks and routines according to documented procedures and processes.

Develop and update project code using python language. Data gathering from social media like Twitter, Facebook, Instagram, Google+ and Flickr. Prepare project related documentation.