Data Analyst
Careem
Total years of experience :5 years, 4 Months
• Performed analysis with large data sets on a daily basis(using SQL, Excel) to understand the pattern and make recommendations to the marketing team leading to improved monthly trips by 12%.
• Worked on generating various interactive dashboards in Tableau to measure the actual spending to the budget and spend forecast for upcoming months and quarters.
• Generated weekly and monthly reports(using Excel) on customer and driver campaigns to track the KPIs and provided business insights to the spend manager and stakeholders
• Implemented the JIRA workflow process to identify the incorrect data and highlight them to the stakeholders which resulted in a 30% improvement in data accuracy and Created dashboards (on JIRA) to track various metrics for campaign performance that decreased manual effort.
• Worked on Tableau dashboard migration from one tableau server to another and performed testing the dashboards to ensure the data provided all the business requirements.
• Collaborated with multiple stakeholders to review and resolve any pricing component issues, and customer/driver campaign exception on a daily basis.
• Performed pricing analysis on historical data to provide pricing decisions on new and existing car types.
Client: Telenor, Norway
• Worked in an Agile Environment to Analyze the business requirements, created a test strategy, and executed the in-sprint testing.
• Coordinated data requirement gathering, analysis, and quality activities for all the in-sprint user stories and ensure appropriate details are defined prior to the sprint execution.
• Logged and updated the defects in Quality Center (QC) and JIRA in different testing stages
• Developed and executed the automation test scripts (using VB script) in HP QTP.
• Responsible to confirm the user stories are completed correctly and maintain the sprint commitment document before sprint demos (present it) with on-shore and off-shore teams.
• Extracted data from SQL server database tables and feed into excel sheet to perform testing.
Integrated course