محمود الفحل

Senior BI Analyst في KnowledgeNet

• مصر - القاهرة
• أشغل هذه الوظيفة منذ مارس 2020

My major tasks in the projects (so far):
▪ Gather, review, and analyze the business requirements for the data projects, reports, and dashboards from the customer.
▪ Design, develop, implement, and maintain reports and dashboards with Power BI, BIRT, and Excel.
▪ Create complex SQL queries, views, stored procedures, materialized view, and SQL jobs to support the reporting module.
▪ Design, develop, test, implement, troubleshoot, and document scalable ETL jobs using Talend and IBM DataStage.
▪ Design, develop, and implement databases, data warehouse, and metadata repository.
▪ Write a business rules book for data quality depending on regulation such as CMA and SAMA regulation in KSA
▪ Maintain and support the production data application platform.
▪ Analysis and mapping of the data integration and data migration requirements.
▪ Audit quality assurance data and processes to ensure data quality and integrity throughout the data systems.
▪ Create documentation and implementation guide for the development of data products.
▪ Write user stories with acceptance criteria, business requirement documents “BRD”, and traceability matrix for the data products.
▪ Contribute with the project manager, product owner, product growth to define the work breakdown structure, project time plan, milestones and product road map.
▪ Collaborate and support the backend, frontend, and UX teams by clarifying the requirements and ensuring that they align completely with documented business requirements.
▪ Conduct demos, POC, and product presentations for Pre-Sales activity.
▪ Mentor and provide guidance and support to junior, less experienced, and new team members