Rana Soleiman – Senior Specialist, Database storage & Development Department at National Telecom Regulatory Authority (NTRA)

Work Experience

National Telecom Regulatory Authority (NTRA)

Jul 2021 - Present -4 yrs

Job Details:Design efficient and comprehensive relational database solutions to help different departments in storing and processing their data. Implement highly reliable databases to significantly reduce time spent in daily activities and speed up reporting. Store and maintain data in designated places in the database for easy manipulation and retrieval. Participate in developing user friendly portals to allow users to enter, update and retrieve data in a quick and easy manner. Develop database user defined functions, views, stored procedures and scripts to ease and speed up data analysis process. Build and maintain interactive dashboards using power BI. Monitor and analyze data trends to identify market backdoors and loopholes. Develop solutions using python for analyzing data. Report analytical findings to help decision makers with regulating the market by adding or updating regulations upon need.

National Telecom Regulatory Authority (NTRA)

Nov 2020 - Jul 2021 -8 months

Job Details:•Design a comprehensive database for all operators’ mobile base stations to ease daily activities and speed up mobile stations compliance certificates issuance process. •Implement a highly secure and stable database for mobile base stations. •Script advanced SQL queries to cleanse data and convert unstructured data to a uniform and usable one. •Store, maintain and update all mobile base stations data in its designated locations. •Participate in developing mobile base stations portal that help employees enter and update data. •Participate in developing mobile stations interactive dashboard. •Participate in developing auto generated compliance certificates for complying stations through the portal. •Keep track of new studies published by IEEE, WHO, and ICNIRP to ensure that the latest protocols and the safety guidelines are being strictly followed for installing and maintaining mobile base stations to ensure humans well-being against electromagnetic waves.

National Telecom Regulatory Authority (NTRA)

Sep 2017 - Nov 2020 -3 yrs, 2 months

Egypt

Job Details:•Conduct regular and on demand monthly database audits on telecom companies to ensure their compliance with the authority’s regulations. •Prepare monthly regular and on demand audit reports. •Handle communication with telecom companies regarding regular and newly requested reports. •Handle communication with telecom companies regarding newly requested audit queries. •Report violations found during the audit to management and hand it over to the violations team. •Inspect the data sent from telecom companies for violations and report findings to management and the violations team. •Analyze data collected from telecom operators to understand market behavior that can help in finding market backdoors and loopholes.

LINK Development

Sep 2016 - Sep 2017 -1 yr

Egypt , Cairo

Job Details:•Tailor business proposals’ to best suit each customer needs in order to guarantee his/her interest in going through the entire proposal. •Thoroughly proof read all business proposals in terms of layout, language and components before handing over to the customer. •Create rich and attractive PowerPoint presentations to be presented for customers. •Meet with projects owners to gather information about previously implemented projects to market our solutions to new customers. •Write case studies about the delivered projects to be included in the business proposals to familiarize the customer with the company’s achievements. •Write newly used technologies write-ups and updating old ones to be referenced in the business proposals. •Create MS word styles and templates to guarantee the documents uniformity.