Rumsha Khan Email & Phone Number

San Francisco, Ca, Us

Lahore, Pk

- Created a sales dashboard that highlighted best-selling products, enabling a targeted marketing approach, and contributing to a 30% increase in sales during the 6 month campaign period. - Improved the performance of existing Power BI reports by optimizing data models and DAX measures, reducing report load times by 15%. - Leveraged Power BI insights to recommend reallocating budget from low-performing ads to high-performing ones, maximizing ROI by 10%.- Team lead for a group of various Marketing specialists and analysts

Redmond, Washington, Us

Worked in Microsoft Bing Team (Marketing Group) with a focus on Bing SERP performance in comparison to Google.Bing Search Engine SERP PerformanceData Gathering & Cleansing- Gathered Bing and Google SERP data from thousands of beta test users and stored in Microsoft Cosmos Big Data Platform (BDP).- Wrote data cleansing scripts in SQL / SCOPE query language to create structured streams and datasets.- Wrote C# data processors called from SQL / SCOPE to handle sophisticated data cleansing and transformation- Used Azure Data Factory (ADF) to schedule and automate SQL / SCOPE scripts- Cosmos BDP runs on thousands of servers in Azure cloud privately for Microsoft internal useData Analysis, Visualization & Reporting- Worked with the team lead to identify various data analysis and visualization dashboards- Used Power BI / Excel / Titan data visualization and reporting tools (Titan is internal to Microsoft)- Wrote SQL / SCOPE scripts to transform Cosmos structured streams into meaningful datasets for dashboards- Designed and developed numerous visual dashboards in Power BI / Excel / Titan around the datasets created with SQL / SCOPE- Power BI / Excel / Titan dashboards used by the Bing team to understand Bing performance and take corrective actions- My meaningful SQL / SCOPE datasets used by others in the Bing group for designing additional dashboardsData Testing for Bing SERP Annotations- Wrote SQL / SCOPE scripts in Cosmos Big Data Platform (BDP)- SQL / SCOPE scripts and C# data processors analyzed over 5000 scenarios daily to test Bing SERP Annotations health- Used Azure Data Factory (ADF) to schedule and automate SQL / SCOPE scriptsData Testing for Bing Personally Identifiable Information (PII) Bugs- Gathered 1000+ SERP data logs daily from Bing beta usage and tested them as part of a team of 5 people- Tested Bing SERP logs for PII scrubbing / over-scrubbing bugs and reported them to the Bing Engineering team

Dallas, Texas, Us

NCache Marketing Channel Performance- Data Gathering & Cleansing, Data Analysis, Visualization & Reporting- Data from KickFire, Google Analytics, Google Facebook LinkedIn Ads- Power BI, Excel Dashboards, SQL, ETL scripts, MySQL databaseNCache Email Marketing- Campaign Management, Constant Contact, Email Campaigns, Content Writing- Data Analysis, Visualization & Reporting, Excel Dashboards, MySQL database

Dallas, Texas, Us

NCache Marketing Channel Performance- Data Gathering & Cleansing, Data Analysis, Visualization & Reporting- Excel Dashboards, SQL, MySQL databaseNCache Competitor & Industry Analysis- Research, competing products, industry leaders- Analysis, Excel, Pivot Tables, Dashboard Reports

Islamabad, Islamabad, Pk

Sabaq.pk eLearning Website- Data Gathering & Cleansing, Website Leads, SQL Scripts, CSV, MySQL Backup- Analysis, Excel, Pivot Tables, Dashboard Reports

Islamabad, Capital Territory, Pk

Research Competitor Marketing Activities- Research, competitors, industry leaders, SEO ranking, Google Ads- Analysis, Excel, Reports