Saras AnalyticsSenior Business Analyst
Nov. 2019 - Feb. 2021Hyderabad, Telangana𝗦𝗮𝗿𝗮𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗶𝘀 𝗮 𝗱𝗮𝘁𝗮 𝗺𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 𝗮𝗻𝗱 𝗽𝗿𝗲𝗱𝗶𝗰𝘁𝗶𝘃𝗲 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗰𝗼𝗺𝗽𝗮𝗻𝘆 𝘁𝗵𝗮𝘁 𝗵𝗲𝗹𝗽𝘀 𝘆𝗼𝘂 𝗲𝗻𝗴𝗮𝗴𝗲 𝗶𝗻 𝗮𝗻𝘆 𝘀𝘁𝗮𝗴𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗱𝗮𝘁𝗮 𝗹𝗶𝗳𝗲 𝗰𝘆𝗰𝗹𝗲.
- Worked with an NA-based Restaurants company on BI & Advanced Analytics projects.
- Worked with the largest MENA-based Restaurants & Foods company and accelerated multiple Growth Consulting, CRO, co-directed BI, Advanced Analytics, & systemized SEO projects to achieve a digital revenue of $100M (▲55% YoY) across 3 brands & 9 markets. (Client Facing Role)
- Spearheaded the SEO engagement for F|B e-Commerce website in 3 markets in MENA.
- Engineered the reporting database for the QSR chains client from the ground up.
- Programmed Google (Analytics, Search Console & My Business) API based Reporting Automation using Python to statistically flag metrics above or below the desired threshold.
- Built End to End automation of a Playstore reviews' PowerBI dashboard using NLP, Google Cloud Functions, & BigQuery.
- Collaborated with the client’s Product team to create multi-market customer reviews & ran NLP for the sentiments.
- Automated an Excel Dashboard with PowerBI cube for daily consumption, for data of 22 websites & 8 apps. Team’s manual toil -> 3~4 hrs/day to 30 mins/day.
- Led the initiative of a new marketing strategy for a client’s website based on insights from Hotjar user usage video analysis.
Data Tech Stack: Google Analytics, Google Tag Manager, Power BI, Qlikview, Tableau, Google Datastudio, Looker, Python, Google Bigquery, MySQL, pandas, Spark, MS Excel & PowerPoint, Segment, VSCode, Google Ads, Google My Business, Statistics, SEM, SEO, eCommerce, etc.