Senior Business Analyst, BI
United Arab Shipping Company
Total years of experience :11 years, 5 Months
- Analyze and translate the users’ needs into technical terms
- Help business intelligence team in building data models and technical design to serve requirements
- Ensuring the data quality of the business intelligence solutions provided to the users
- Build reports and dashboards using self-service BI, and data visualization tools (Power BI, MS Excel, PowerPivot, Power Query)
- Verify data warehouse tables against relational database and making sure the data warehouse is holding the correct, complete and accurate measures
- Querying database tables and create scripts for testing and reporting purposes
- Ensuring that the technical solution implemented will serve the purposes of the internal client
- Simplifying the users’ day to day tasks by creating and automating customized data models and out of the box solutions and publishing them to SharePoint
- Responsible for impact analysis of system changes
- Responsible for the review of the project plan as a whole
- Responsible for giving estimates on the duration of the testing and UAT activities
- Initial testing of the output to make sure that the data quality is sound
- Acts as a liaison between departmental end-users, other stakeholders and BI team in the analysis, design, configuration, testing and maintenance of UASC BI systems to ensure optimal operational performance
- Plan and assign tasks for Quality Engineering team
- Design and create database scripts to be used in verifying and testing BI solutions
- Review project requirements, design, and all related testing documents
- Perform ad hoc testing and tests the most complex parts of the system
- Ensure regression, stress, and security testing are done
- Monitor bugs closure on ITWorx tracking tool
- Manage projects; testing estimates
- Manage quality assurance and testing processes
- Conduct training sessions for Quality Engineers on different testing topics
- Coach and support team members in technical issues, challenges, and problems
- Identify technical risks and support Project Leaders in developing risk management plan and tracking different measurable aspects in projects
- Responsible for the testing process, requirements review and designing and developing defect report.
- Develops reviews and updates test plan and test cases.
- Identify test cases risk and priority
- Create Testing scripts and prepare test data
- Executes Test cases on the system
- Log issues on Bugbase (Bug tracking tool) and tracks them until closure
- Analyzing and tracking bug count, closure rate, and rejection rate
- Recognizes problems or situations as similar to past experiences.
- Identify the risk of sending the project with a certain quality level.
- Save all documents on the suitable place on Sourcesafe.
- Responsible for quality audit reviews and project conformance.
- Ensures conformance to quality assurance processes within the project.
- Review packages/documents to be delivered using deliverables checklist.
- Develop the testing activity report delivered with each version.
- Report project status and required resources weekly to Quality TL and PL
- Reports the measurement of testing effectiveness per project weekly
- Communicate with all the team concerning the projects issues.
- Negotiate testing effort and schedule with PL.
- Assign and follow-up on assigned bugs to developers.
- Train QEs in area regarding Testing policy and procedure.
- Encourage research and understanding of new technologies for team members
- Reviews Requirements and design of the system to be implemented
- Develops the test cases
- Define test cases priority.
- Use adequate tool to execute scripts on received code.
- Executes Test cases on the system
- Log issues on Bugbase (Bug tracking tool) and tracks them until closure
- Verifies issues posted by any of the team members on Bugbase.
- Follow up on issues status to improve quality of customer deliverables.
- Triggers the measurement of effectiveness of testing per project
- Add all generated testing documents on SourceSafe and update them when needed.
- Tests the requirement document and generates defect report.
- Reports project quality status to Senior Quality Engineer.
- Communicates with the PL to discuss project’s issues and schedule.
- Perform other duties as assigned